Database Schema Export — 120 tables, 1839 columns Schema: public ================================================================================ TABLE: account_information (9 columns) ------------------------------------------------------------ bank_name text NULL account_number text NULL ifsc_code text NULL branch_name text NULL if_salaried_account text NULL name_as_bank_account text NULL user_id text NULL account_type text NULL if_verified boolean NULL DEFAULT false TABLE: address_detail (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('address_detail_id_seq'::regclass) doctor_id text NULL user_id text NULL address_type text NULL address text NULL building text NULL locality text NULL pin_code text NULL city text NULL state text NULL residence_value text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL TABLE: application_id_day_seq (2 columns) ------------------------------------------------------------ business_date date NOT NULL last_seq integer NOT NULL INDEXES: application_id_day_seq_pkey: CREATE UNIQUE INDEX application_id_day_seq_pkey ON public.application_id_day_seq USING btree (business_date) TABLE: appointment_details (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('appointment_details_id_seq'::regclass) doctor_id text NULL appointment_id text NULL treatment text NULL patient_name text NULL mobile_number text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL user_id text NULL invoice_no text NULL invoice_code text NULL visit_date timestamp without time zone NULL appointment_status character varying(255) NULL TABLE: arthmate_loan_document (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('arthmate_loan_document_id_seq'::regclass) user_id text NULL document_id text NULL document_name text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL TABLE: attendance (10 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('attendance_id_seq'::regclass) user_id character varying(255) NULL user_type character varying(100) NULL attendance_date character varying(50) NULL attendance_id character varying(255) NULL check_in timestamp without time zone NULL check_out timestamp without time zone NULL status character varying(50) NULL check_in_location character varying(255) NULL check_out_location character varying(255) NULL INDEXES: attendance_pkey: CREATE UNIQUE INDEX attendance_pkey ON public.attendance USING btree (id) TABLE: auto_disbursal_audit (9 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('auto_disbursal_audit_id_seq'::regclass) job_id character varying(64) NOT NULL loan_id character varying(64) NOT NULL application_id character varying(64) NULL stage character varying(64) NOT NULL status character varying(32) NOT NULL message text NULL payload text NULL created_at timestamp without time zone NOT NULL DEFAULT now() INDEXES: auto_disbursal_audit_pkey: CREATE UNIQUE INDEX auto_disbursal_audit_pkey ON public.auto_disbursal_audit USING btree (id) idx_auto_disbursal_audit_job_id: CREATE INDEX idx_auto_disbursal_audit_job_id ON public.auto_disbursal_audit USING btree (job_id) idx_auto_disbursal_audit_loan_id: CREATE INDEX idx_auto_disbursal_audit_loan_id ON public.auto_disbursal_audit USING btree (loan_id) TABLE: auto_disbursal_job (12 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('auto_disbursal_job_id_seq'::regclass) job_id character varying(64) NOT NULL loan_id character varying(64) NOT NULL trigger_source character varying(32) NOT NULL status character varying(32) NOT NULL do_shared_at timestamp without time zone NULL cooling_ends_at timestamp without time zone NULL attempt_count integer NOT NULL DEFAULT 0 last_error text NULL initiated_at timestamp without time zone NULL created_at timestamp without time zone NOT NULL DEFAULT now() updated_at timestamp without time zone NOT NULL DEFAULT now() INDEXES: auto_disbursal_job_pkey: CREATE UNIQUE INDEX auto_disbursal_job_pkey ON public.auto_disbursal_job USING btree (id) auto_disbursal_job_job_id_key: CREATE UNIQUE INDEX auto_disbursal_job_job_id_key ON public.auto_disbursal_job USING btree (job_id) idx_auto_disbursal_job_loan_id: CREATE INDEX idx_auto_disbursal_job_loan_id ON public.auto_disbursal_job USING btree (loan_id) idx_auto_disbursal_job_status_cooling: CREATE INDEX idx_auto_disbursal_job_status_cooling ON public.auto_disbursal_job USING btree (status, cooling_ends_at) uq_auto_disbursal_job_active_loan: CREATE UNIQUE INDEX uq_auto_disbursal_job_active_loan ON public.auto_disbursal_job USING btree (loan_id) WHERE ((status)::text = ANY ((ARRAY['PENDING_COOLING'::character varying, 'READY'::character varying, 'INITIATED'::character varying])::text[])) TABLE: axis_transfer_payment (38 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('axis_transfer_payment_id_seq'::regclass) loan_id text NULL doctor_id text NULL doctor_name text NULL transaction_type text NULL txn_paymode text NULL cust_uniq_ref text NULL corp_acc_num text NULL value_date text NULL txn_amount text NULL bene_lei text NULL bene_name text NULL bene_code text NULL bene_acc_num text NULL bene_ac_type text NULL bene_addr1 text NULL bene_addr2 text NULL bene_addr3 text NULL bene_city text NULL bene_state text NULL bene_pincode text NULL bene_ifsc_code text NULL bene_bank_name text NULL bene_email_addr1 text NULL bene_mobile_no text NULL txn_type text NULL sender_to_receiver_info text NULL response_status text NULL response_message text NULL status text NULL status_description text NULL batch_no text NULL utr_no text NULL processing_date text NULL response_code text NULL axis_response text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL INDEXES: axis_transfer_payment_pkey: CREATE UNIQUE INDEX axis_transfer_payment_pkey ON public.axis_transfer_payment USING btree (id) idx_axis_transfer_payment_cust_uniq_ref: CREATE INDEX idx_axis_transfer_payment_cust_uniq_ref ON public.axis_transfer_payment USING btree (cust_uniq_ref) idx_axis_transfer_payment_doctor_id: CREATE INDEX idx_axis_transfer_payment_doctor_id ON public.axis_transfer_payment USING btree (doctor_id) idx_axis_transfer_payment_loan_id: CREATE INDEX idx_axis_transfer_payment_loan_id ON public.axis_transfer_payment USING btree (loan_id) TABLE: bank_details_cp (12 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('bank_details_cp_id_seq'::regclass) doctor_id text NULL account_number text NULL account_type text NULL bank_address text NULL bank_name text NULL branch_name text NULL ifsc_code text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL account_holder_name text NULL if_verified boolean NULL DEFAULT false TABLE: bre_api_logs (7 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('bre_api_logs_id_seq'::regclass) loan_id character varying(100) NULL user_id character varying(100) NULL request_body text NULL response_body text NULL status_code integer NULL added_on timestamp without time zone NULL INDEXES: bre_api_logs_pkey: CREATE UNIQUE INDEX bre_api_logs_pkey ON public.bre_api_logs USING btree (id) TABLE: bureau_decision (12 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('bureau_decision_id_seq'::regclass) loan_id text NULL bureau_decision text NULL decision_reason text NULL bureau_based_max_eligible_emi double precision NULL added_on date NULL updated_on date NULL type text NULL bureau_score character varying(255) NULL bureau_type character varying(255) NULL is_bureau_fetched boolean NULL max_gross_treatment_amount double precision NULL DEFAULT 0.0 TABLE: bureau_mannual_intervention (7 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('bureau_mannual_intervention_id_seq'::regclass) loan_id text NULL status boolean NULL DEFAULT false flag text NULL added_on date NULL updated_on date NULL type text NULL TABLE: care_pay_webhook_event (16 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('care_pay_webhook_event_id_seq'::regclass) order_id character varying(255) NOT NULL loan_id character varying(255) NULL doctor_id character varying(255) NULL event_type character varying(100) NOT NULL loan_status character varying(100) NULL loan_sub_status character varying(100) NULL webhook_url character varying(500) NOT NULL payload text NULL response_status_code integer NULL response_body text NULL status character varying(50) NOT NULL DEFAULT 'PENDING'::character varying retry_count integer NOT NULL DEFAULT 0 error_message text NULL created_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP sent_on timestamp without time zone NULL INDEXES: care_pay_webhook_event_pkey: CREATE UNIQUE INDEX care_pay_webhook_event_pkey ON public.care_pay_webhook_event USING btree (id) idx_webhook_event_created_on: CREATE INDEX idx_webhook_event_created_on ON public.care_pay_webhook_event USING btree (created_on) idx_webhook_event_doctor_id: CREATE INDEX idx_webhook_event_doctor_id ON public.care_pay_webhook_event USING btree (doctor_id) idx_webhook_event_failed_retry: CREATE INDEX idx_webhook_event_failed_retry ON public.care_pay_webhook_event USING btree (status, retry_count) WHERE ((status)::text = 'FAILED'::text) idx_webhook_event_loan_id: CREATE INDEX idx_webhook_event_loan_id ON public.care_pay_webhook_event USING btree (loan_id) idx_webhook_event_order_id: CREATE INDEX idx_webhook_event_order_id ON public.care_pay_webhook_event USING btree (order_id) idx_webhook_event_status: CREATE INDEX idx_webhook_event_status ON public.care_pay_webhook_event USING btree (status) TABLE: carepay_loan_emi (14 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('carepay_loan_emi_id_seq'::regclass) loan_id text NULL date timestamp without time zone NULL emi_no integer NULL emi_amount double precision NULL emi_paid_amount numeric NULL status boolean NULL paid_date timestamp without time zone NULL overdue_amount numeric NULL loan_status text NULL emi_id text NULL principal double precision NULL interest double precision NULL balance double precision NULL INDEXES: carepay_loan_emi_pkey: CREATE UNIQUE INDEX carepay_loan_emi_pkey ON public.carepay_loan_emi USING btree (id) TABLE: cash_free_details (4 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('cash_free_details_id_seq'::regclass) user_id character varying(255) NULL ref_id character varying(255) NULL added_on timestamp without time zone NULL TABLE: click_wrap_signature (29 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('click_wrap_signature_id_seq'::regclass) loan_id character varying(255) NULL agreement_version character varying(255) NULL agreement_title character varying(255) NULL agreement_text text NULL signing_date timestamp without time zone NULL otp_sent_time timestamp without time zone NULL otp_verified_time timestamp without time zone NULL otp_code integer NULL ip_address character varying(255) NULL user_agent character varying(500) NULL verification_status character varying(50) NULL acceptance_time timestamp without time zone NULL verification_attempts integer NULL DEFAULT 0 has_consented boolean NULL DEFAULT false consent_type character varying(255) NULL language character varying(255) NULL location character varying(255) NULL city character varying(255) NULL longitude character varying(255) NULL latitude character varying(255) NULL comments text NULL signed_agreement_url character varying(255) NULL agreement_url character varying(255) NULL kfs_agreement_url character varying(255) NULL is_deleted boolean NULL DEFAULT false deleted_at timestamp without time zone NULL deleted_by character varying(255) NULL send_to_user_time timestamp without time zone NULL INDEXES: click_wrap_signature_pkey: CREATE UNIQUE INDEX click_wrap_signature_pkey ON public.click_wrap_signature USING btree (id) idx_click_wrap_loan_id_active: CREATE INDEX idx_click_wrap_loan_id_active ON public.click_wrap_signature USING btree (loan_id) WHERE (is_deleted = false) TABLE: comment_activity_log (10 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('comment_activity_log_id_seq'::regclass) comment_id integer NOT NULL activity_type character varying(50) NOT NULL activity_description text NULL performed_by_type character varying(50) NOT NULL performed_by_id character varying(255) NOT NULL old_value text NULL new_value text NULL metadata text NULL created_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP INDEXES: comment_activity_log_pkey: CREATE UNIQUE INDEX comment_activity_log_pkey ON public.comment_activity_log USING btree (id) idx_comment_activity_comment_id: CREATE INDEX idx_comment_activity_comment_id ON public.comment_activity_log USING btree (comment_id) idx_comment_activity_created_on: CREATE INDEX idx_comment_activity_created_on ON public.comment_activity_log USING btree (created_on DESC) idx_comment_activity_type: CREATE INDEX idx_comment_activity_type ON public.comment_activity_log USING btree (activity_type) TABLE: comment_type (7 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('comment_type_id_seq'::regclass) comment_type character varying(100) NOT NULL comment text NOT NULL DEFAULT ''::text is_important boolean NULL DEFAULT false created_on timestamp without time zone NULL updated_on timestamp without time zone NULL deleted_on timestamp without time zone NULL INDEXES: comment_type_pkey: CREATE UNIQUE INDEX comment_type_pkey ON public.comment_type USING btree (id) TABLE: communication_tracker (11 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('communication_tracker_id_seq'::regclass) user_id text NULL doctor_id text NULL lender_id text NULL communication_code text NULL text boolean NULL DEFAULT false whatsapp boolean NULL DEFAULT false email boolean NULL DEFAULT false notification boolean NULL DEFAULT false communication_date timestamp without time zone NULL emp_id text NULL TABLE: consent_record_detail (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('consent_record_detail_id_seq'::regclass) consent_id text NULL user_identifier text NULL external_lead_id text NULL consent_type text NULL consent_purpose text NULL source text NULL timestamp timestamp without time zone NULL ip_address text NULL user_agent text NULL location text NULL created_at timestamp without time zone NULL updated_at timestamp without time zone NULL INDEXES: consent_record_detail_consent_id_key: CREATE UNIQUE INDEX consent_record_detail_consent_id_key ON public.consent_record_detail USING btree (consent_id) consent_record_detail_pkey: CREATE UNIQUE INDEX consent_record_detail_pkey ON public.consent_record_detail USING btree (id) TABLE: credit_decision (17 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('credit_decision_id_seq'::regclass) loan_id character varying(255) NULL decision text NULL decision_type character varying(50) NULL added_on timestamp without time zone NULL environment character varying(50) NULL bureau_obligations double precision NULL DEFAULT 0 bureau_response text NULL bs_response text NULL bureau_max_eligible_emi double precision NULL DEFAULT 0 bs_max_eligible_emi double precision NULL DEFAULT 0 max_credit_limit_calculated numeric NULL product_max_credit_limit_calculated text NULL manual_override_decision character varying(255) NULL manual_override_by character varying(255) NULL manual_override_at timestamp without time zone NULL manual_override_remarks text NULL TABLE: credit_limit_estimator (10 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('credit_limit_estimator_id_seq'::regclass) loan_id character varying(255) NOT NULL user_id character varying(255) NOT NULL credit_card_name character varying(255) NOT NULL nudge boolean NOT NULL estimated_limit bigint NOT NULL added_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NULL treatment_amount bigint NULL limit_to_treatment_ratio double precision NULL DEFAULT 0.0 INDEXES: credit_limit_estimator_pkey: CREATE UNIQUE INDEX credit_limit_estimator_pkey ON public.credit_limit_estimator USING btree (id) TABLE: debit_detail (15 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('debit_detail_id_seq'::regclass) loan_id character varying(255) NULL emi_no integer NULL plan_id character varying(255) NULL status character varying(50) NULL create_debit_data text NULL debit_request_data text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL npci_txn_id character varying(255) NULL bounce_reasons text NULL npt_id text NULL cp_status text NULL status_updated_at text NULL transaction_status character varying(50) NULL INDEXES: debit_detail_pkey: CREATE UNIQUE INDEX debit_detail_pkey ON public.debit_detail USING btree (id) TABLE: digio_mandate_bank_details (12 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('digio_mandate_bank_details_id_seq'::regclass) bank_id text NULL name text NULL ifsc_prefix text NULL active boolean NULL primary_bank boolean NULL routing_code text NULL esign_mandate boolean NULL api_mandate boolean NULL physical_mandate boolean NULL allowed_auth_sub_type bytea NULL penny_less boolean NULL INDEXES: digio_mandate_bank_details_pkey: CREATE UNIQUE INDEX digio_mandate_bank_details_pkey ON public.digio_mandate_bank_details USING btree (id) TABLE: disbursal_order_details (42 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('disbursal_order_details_id_seq'::regclass) user_id character varying(255) NULL first_name character varying(255) NULL mobile_number character varying(20) NULL loan_id character varying(255) NULL application_id character varying(255) NULL treatment_amount bigint NULL loan_amount bigint NULL loan_reason character varying(500) NULL loan_apply_date timestamp without time zone NULL disburse_date timestamp without time zone NULL patient_name character varying(255) NULL patient_phone_number character varying(20) NULL doctor_id character varying(255) NULL doctor_name character varying(255) NULL doctor_code character varying(255) NULL clinic_name character varying(255) NULL utr character varying(255) NULL business_entity_name character varying(255) NULL product_id character varying(255) NULL product_name character varying(255) NULL total_emi integer NULL advance_emi integer NULL subvention_rate double precision NULL advance_emi_amount double precision NULL total_tenure integer NULL effective_tenure integer NULL net_loan_amount double precision NULL subvention_excluding_gst double precision NULL subvention_including_gst double precision NULL gst_on_subvention double precision NULL processing_fee double precision NULL disburse_amount double precision NULL interest_amount double precision NULL interest_rate double precision NULL nbfc_name character varying(255) NULL internal_product_id character varying(255) NULL report_generation_date timestamp without time zone NULL do_shared_timestamp timestamp without time zone NULL employment_type character varying(255) NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL INDEXES: disbursal_order_details_pkey: CREATE UNIQUE INDEX disbursal_order_details_pkey ON public.disbursal_order_details USING btree (id) TABLE: doctor_daily_performance (16 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('doctor_daily_performance_id_seq'::regclass) doctor_id character varying(255) NULL calculation_date date NULL month_year character varying(20) NULL monthly_potential integer NULL period integer NULL day_of_month integer NULL expected_amount_till_date numeric NULL actual_business_till_date numeric NULL performance_ratio numeric NULL calculated_at timestamp without time zone NULL potential_category character varying(10) NULL performance_number integer NULL final_rating character varying(10) NULL actual_disbursed_business_till_date character varying(255) NULL expected_disbursed_amount_till_date character varying(255) NULL INDEXES: doctor_daily_performance_pkey: CREATE UNIQUE INDEX doctor_daily_performance_pkey ON public.doctor_daily_performance USING btree (id) TABLE: doctor_details (43 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('doctor_details_id_seq'::regclass) doctor_id text NULL name text NULL email_id text NULL password text NULL phone_number text NULL dob timestamp without time zone NULL qr_code_url text NULL form_status text NULL app_download_status boolean NULL DEFAULT false important boolean NULL DEFAULT false added_on timestamp without time zone NULL updated_on timestamp without time zone NULL creator_id text NULL pan_number text NULL doctor_code text NULL verified boolean NULL DEFAULT false joining_date timestamp without time zone NULL scout_code text NULL bene_id text NULL qr_installation_status boolean NULL DEFAULT false virtual_account_created boolean NULL DEFAULT false cf_bene_id text NULL doctor_status text NULL fibe_mid text NULL parent_doctor_id text NULL cf_anchor_mid text NULL agreement_signed boolean NULL DEFAULT false flex_money_mid text NULL rp_account_id text NULL mv_merchant_id text NULL archived boolean NULL DEFAULT false finzy_merchant_id text NULL jus_pay_merchant_id text NULL fin_doc_mid text NULL fin_bank_id text NULL category character varying(20) NULL active boolean NULL DEFAULT true interest_enabled boolean NULL DEFAULT false auto_disbersed boolean NULL DEFAULT false oculon_score double precision NULL DEFAULT 0.0 zype_mid character varying(100) NULL cloud_banking_mid character varying(255) NULL INDEXES: idx_doctor_details_active: CREATE INDEX idx_doctor_details_active ON public.doctor_details USING btree (active) WHERE (active = true) idx_doctor_details_doctor_code: CREATE INDEX idx_doctor_details_doctor_code ON public.doctor_details USING btree (doctor_code) WHERE (doctor_code IS NOT NULL) idx_doctor_details_doctor_id: CREATE INDEX idx_doctor_details_doctor_id ON public.doctor_details USING btree (doctor_id) idx_doctor_details_joining_date: CREATE INDEX idx_doctor_details_joining_date ON public.doctor_details USING btree (joining_date) WHERE (joining_date IS NOT NULL) idx_doctor_details_parent_doctor_id: CREATE INDEX idx_doctor_details_parent_doctor_id ON public.doctor_details USING btree (parent_doctor_id) WHERE (parent_doctor_id IS NOT NULL) idx_doctor_details_scout_code: CREATE INDEX idx_doctor_details_scout_code ON public.doctor_details USING btree (scout_code) WHERE (scout_code IS NOT NULL) idx_doctor_details_scout_code_id: CREATE INDEX idx_doctor_details_scout_code_id ON public.doctor_details USING btree (scout_code, doctor_id) WHERE (scout_code IS NOT NULL) TABLE: doctor_invoice_detail (11 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('doctor_invoice_detail_id_seq'::regclass) doctor_id text NULL month text NULL year text NULL invoice_no integer NULL sent_mail boolean NULL DEFAULT false created_at timestamp without time zone NULL updated_at timestamp without time zone NULL last_download_at timestamp without time zone NULL last_sent_email_at timestamp without time zone NULL sent_email_count integer NULL DEFAULT 0 INDEXES: doctor_invoice_detail_pkey: CREATE UNIQUE INDEX doctor_invoice_detail_pkey ON public.doctor_invoice_detail USING btree (id) TABLE: doctor_nbfc_mapping (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('doctor_nbfc_mapping_id_seq'::regclass) doctor_id text NULL nbfc_id text NULL cf_merchant boolean NULL DEFAULT false enabled boolean NULL DEFAULT false mapped_on timestamp without time zone NULL TABLE: doctor_nbfc_mapping_logs (8 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('doctor_nbfc_mapping_logs_id_seq'::regclass) doctor_id character varying(255) NULL nbfc_id character varying(255) NULL action character varying(100) NULL action_by character varying(255) NULL reason text NULL added_on timestamp without time zone NULL latest boolean NULL DEFAULT true INDEXES: doctor_nbfc_mapping_logs_pkey: CREATE UNIQUE INDEX doctor_nbfc_mapping_logs_pkey ON public.doctor_nbfc_mapping_logs USING btree (id) TABLE: doctor_opportunities_detail (11 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('doctor_opportunities_detail_id_seq'::regclass) doctor_name text NULL clinic_name text NULL email_id text NULL contact_number text NULL area text NULL scout_code text NULL pin_code text NULL rating integer NULL visiting_date timestamp without time zone NULL comment text NULL TABLE: doctor_potential (7 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('doctor_potential_id_seq'::regclass) doctor_id character varying(255) NULL monthly_potential integer NULL is_active boolean NULL updated_by character varying(255) NULL updated_at timestamp without time zone NULL comment text NULL INDEXES: doctor_potential_pkey: CREATE UNIQUE INDEX doctor_potential_pkey ON public.doctor_potential USING btree (id) TABLE: doctor_professional_detail (36 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('doctor_professional_detail_id_seq'::regclass) doctor_id text NULL pan text NULL name_on_pan text NULL licence_number text NULL clinic_name text NULL business_entity_name text NULL business_entity_type text NULL cin_llpin text NULL gst_in text NULL aadhaar_no text NULL verified boolean NULL DEFAULT false added_on timestamp without time zone NULL updated_on timestamp without time zone NULL speciality text NULL google_review_link text NULL justdial_review_link text NULL incorporation_date timestamp without time zone NULL google_link_hits integer NULL DEFAULT 0 just_dial_link_hits integer NULL DEFAULT 0 monthly_potential integer NULL DEFAULT 0 comment text NULL experience integer NULL qualification character varying(255) NULL just_dial_link character varying(255) NULL practo_link character varying(255) NULL insta_handle character varying(255) NULL agreement_url text NULL is_axis_beneficiary boolean NULL DEFAULT false axis_beneficiary_code character varying(100) NULL logo_url text NULL invoice_required boolean NOT NULL DEFAULT true vc_required boolean NOT NULL DEFAULT true ivr_enable boolean NULL DEFAULT false tag character varying(50) NULL settlement_initiation_status boolean NULL DEFAULT true INDEXES: idx_doctor_professional_detail_doctor_id: CREATE INDEX idx_doctor_professional_detail_doctor_id ON public.doctor_professional_detail USING btree (doctor_id) TABLE: doctor_staff (14 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('doctor_staff_id_seq'::regclass) doctor_staff_id character varying(255) NULL name character varying(255) NULL phone_number character varying(20) NULL email_id character varying(255) NULL doctor_id character varying(255) NULL designation character varying(100) NULL otp_code integer NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL status character varying(50) NULL DEFAULT 'active'::character varying otp_sent_at timestamp without time zone NULL otp_verification_attempts integer NULL DEFAULT 0 otp_locked_until timestamp without time zone NULL INDEXES: doctor_staff_pkey: CREATE UNIQUE INDEX doctor_staff_pkey ON public.doctor_staff USING btree (id) TABLE: doctor_to_product (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('doctor_to_product_id_seq'::regclass) doctor_id text NULL product_id text NULL added_on timestamp without time zone NULL updated_on text NULL status boolean NULL DEFAULT false TABLE: eligibility_details (9 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('eligibility_details_id_seq'::regclass) user_id text NULL user_identifier text NOT NULL external_lead_id text NOT NULL income numeric NULL data text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL max_credit_limit double precision NULL DEFAULT 0 INDEXES: eligibility_details_pkey: CREATE UNIQUE INDEX eligibility_details_pkey ON public.eligibility_details USING btree (id) TABLE: eligibility_limit (15 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('eligibility_limit_id_seq'::regclass) loan_id character varying(255) NOT NULL policy_type character varying(10) NULL bureau_fetch_date timestamp without time zone NULL bureau_source character varying(255) NULL max_eligible_emi double precision NULL DEFAULT 0.0 final_decision character varying(255) NULL epfo boolean NULL DEFAULT false income integer NULL pincode character varying(6) NULL bureau_response text NULL added_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NULL expired boolean NULL DEFAULT false expired_on timestamp without time zone NULL TABLE: employment_details (31 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('employment_details_id_seq'::regclass) user_id text NULL employment_type text NULL monthly_family_income integer NULL DEFAULT 0 current_company_name text NULL current_company_pincode text NULL current_company_address1 text NULL current_company_address2 text NULL in_hand_salary text NULL industry text NULL office_address text NULL salary_date timestamp without time zone NULL total_years_of_experience integer NULL DEFAULT 0 total_month_of_experience integer NULL DEFAULT 0 total_years_in_job integer NULL DEFAULT 0 total_month_in_job integer NULL DEFAULT 0 added_on timestamp without time zone NULL updated_on timestamp without time zone NULL type_of_business text NULL name_of_business text NULL organisation_verified boolean NULL DEFAULT false business_pan text NULL verified_establishment_name text NULL employed_tenure integer NULL DEFAULT 0 organisation_strength integer NULL DEFAULT 0 gst_in character varying(50) NULL udyam_number character varying(50) NULL business_email character varying(255) NULL otp_code integer NULL email_verification_status character varying(50) NULL email_percentage_match double precision NULL TABLE: farmer_audit_log (8 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('farmer_audit_log_id_seq'::regclass) table_name text NULL record_id text NULL action text NULL old_values text NULL new_values text NULL user_id text NULL timestamp timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP INDEXES: idx_farmer_audit_log_record: CREATE INDEX idx_farmer_audit_log_record ON public.farmer_audit_log USING btree (record_id) idx_farmer_audit_log_table: CREATE INDEX idx_farmer_audit_log_table ON public.farmer_audit_log USING btree (table_name) idx_farmer_audit_log_timestamp: CREATE INDEX idx_farmer_audit_log_timestamp ON public.farmer_audit_log USING btree ("timestamp") TABLE: farmer_details (14 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('farmer_details_id_seq'::regclass) farmer_id text NOT NULL name text NULL email_id text NULL phone_number text NULL password text NULL parent_farmer_id text NULL level integer NULL DEFAULT 1 created_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_date timestamp without time zone NULL created_by text NULL status text NULL DEFAULT 'ACTIVE'::text farmer_login_otp integer NULL type character varying(255) NULL INDEXES: farmer_details_email_id_key: CREATE UNIQUE INDEX farmer_details_email_id_key ON public.farmer_details USING btree (email_id) farmer_details_farmer_id_key: CREATE UNIQUE INDEX farmer_details_farmer_id_key ON public.farmer_details USING btree (farmer_id) farmer_details_phone_number_key: CREATE UNIQUE INDEX farmer_details_phone_number_key ON public.farmer_details USING btree (phone_number) idx_farmer_details_email: CREATE INDEX idx_farmer_details_email ON public.farmer_details USING btree (email_id) idx_farmer_details_farmer_id: CREATE INDEX idx_farmer_details_farmer_id ON public.farmer_details USING btree (farmer_id) idx_farmer_details_parent: CREATE INDEX idx_farmer_details_parent ON public.farmer_details USING btree (parent_farmer_id) idx_farmer_details_parent_level_status: CREATE INDEX idx_farmer_details_parent_level_status ON public.farmer_details USING btree (parent_farmer_id, level, status) WHERE (status = 'ACTIVE'::text) idx_farmer_details_parent_status: CREATE INDEX idx_farmer_details_parent_status ON public.farmer_details USING btree (parent_farmer_id, status) WHERE (status = 'ACTIVE'::text) idx_farmer_details_phone: CREATE INDEX idx_farmer_details_phone ON public.farmer_details USING btree (phone_number) idx_farmer_details_status: CREATE INDEX idx_farmer_details_status ON public.farmer_details USING btree (status) TABLE: farmer_doctor_mapping (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('farmer_doctor_mapping_id_seq'::regclass) farmer_id text NOT NULL doctor_id text NOT NULL assigned_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP assigned_by text NULL status text NULL DEFAULT 'ACTIVE'::text INDEXES: idx_farmer_doctor_mapping_assigned_date: CREATE INDEX idx_farmer_doctor_mapping_assigned_date ON public.farmer_doctor_mapping USING btree (assigned_date DESC) idx_farmer_doctor_mapping_doctor: CREATE INDEX idx_farmer_doctor_mapping_doctor ON public.farmer_doctor_mapping USING btree (doctor_id) idx_farmer_doctor_mapping_doctor_id: CREATE INDEX idx_farmer_doctor_mapping_doctor_id ON public.farmer_doctor_mapping USING btree (doctor_id) idx_farmer_doctor_mapping_doctor_status: CREATE INDEX idx_farmer_doctor_mapping_doctor_status ON public.farmer_doctor_mapping USING btree (doctor_id, status) WHERE (status = 'ACTIVE'::text) idx_farmer_doctor_mapping_farmer: CREATE INDEX idx_farmer_doctor_mapping_farmer ON public.farmer_doctor_mapping USING btree (farmer_id) idx_farmer_doctor_mapping_farmer_doctor_status: CREATE INDEX idx_farmer_doctor_mapping_farmer_doctor_status ON public.farmer_doctor_mapping USING btree (farmer_id, doctor_id, status) WHERE (status = 'ACTIVE'::text) idx_farmer_doctor_mapping_farmer_status: CREATE INDEX idx_farmer_doctor_mapping_farmer_status ON public.farmer_doctor_mapping USING btree (farmer_id, status) WHERE (status = 'ACTIVE'::text) idx_farmer_doctor_mapping_status: CREATE INDEX idx_farmer_doctor_mapping_status ON public.farmer_doctor_mapping USING btree (status) TABLE: farmer_performance (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('farmer_performance_id_seq'::regclass) farmer_id character varying(255) NOT NULL target_id integer NULL period_start_date date NOT NULL period_end_date date NOT NULL target_type character varying(50) NOT NULL target_value numeric NOT NULL actual_value numeric NOT NULL achievement_percentage numeric NULL status character varying(20) NULL calculated_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP notification_sent boolean NULL DEFAULT false notification_sent_at timestamp without time zone NULL INDEXES: farmer_performance_pkey: CREATE UNIQUE INDEX farmer_performance_pkey ON public.farmer_performance USING btree (id) idx_farmer_performance_calculated_at: CREATE INDEX idx_farmer_performance_calculated_at ON public.farmer_performance USING btree (calculated_at) idx_farmer_performance_farmer_id: CREATE INDEX idx_farmer_performance_farmer_id ON public.farmer_performance USING btree (farmer_id) idx_farmer_performance_period: CREATE INDEX idx_farmer_performance_period ON public.farmer_performance USING btree (period_start_date, period_end_date) idx_farmer_performance_status: CREATE INDEX idx_farmer_performance_status ON public.farmer_performance USING btree (status) idx_farmer_performance_target_id: CREATE INDEX idx_farmer_performance_target_id ON public.farmer_performance USING btree (target_id) TABLE: farmer_target (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('farmer_target_id_seq'::regclass) farmer_id character varying(255) NOT NULL target_type character varying(50) NOT NULL target_value numeric NOT NULL period_type character varying(20) NOT NULL period_start_date date NOT NULL period_end_date date NOT NULL assigned_by character varying(255) NULL assigned_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP status character varying(20) NULL DEFAULT 'ACTIVE'::character varying notes text NULL created_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_at timestamp without time zone NULL INDEXES: farmer_target_pkey: CREATE UNIQUE INDEX farmer_target_pkey ON public.farmer_target USING btree (id) idx_farmer_target_farmer_id: CREATE INDEX idx_farmer_target_farmer_id ON public.farmer_target USING btree (farmer_id) idx_farmer_target_farmer_status: CREATE INDEX idx_farmer_target_farmer_status ON public.farmer_target USING btree (farmer_id, status) WHERE ((status)::text = 'ACTIVE'::text) idx_farmer_target_farmer_type_status: CREATE INDEX idx_farmer_target_farmer_type_status ON public.farmer_target USING btree (farmer_id, period_type, status) WHERE ((status)::text = 'ACTIVE'::text) idx_farmer_target_period: CREATE INDEX idx_farmer_target_period ON public.farmer_target USING btree (period_start_date, period_end_date) idx_farmer_target_period_dates: CREATE INDEX idx_farmer_target_period_dates ON public.farmer_target USING btree (period_start_date, period_end_date) idx_farmer_target_status: CREATE INDEX idx_farmer_target_status ON public.farmer_target USING btree (status) idx_farmer_target_type: CREATE INDEX idx_farmer_target_type ON public.farmer_target USING btree (target_type) TABLE: fibe_response_detail (28 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('fibe_response_detail_id_seq'::regclass) user_id text NULL loan_id text NULL customer_ref_id text NULL order_id text NULL treatment_proof_logs text NULL redirection_url text NULL bitly_url character varying(255) NULL transaction_id character varying(255) NULL lead_status character varying(255) NULL offer_data text NULL sanction_max_limit double precision NULL DEFAULT 0 sanction_min_limit double precision NULL DEFAULT 0 bre_status character varying(255) NULL merchant_package_id character varying(255) NULL settlement_status character varying(255) NULL order_status character varying(255) NULL customer_status character varying(255) NULL final_amount_to_merchant double precision NULL DEFAULT 0.0 subvention_amount double precision NULL DEFAULT 0.0 disbursed_amount double precision NULL DEFAULT 0.0 settlement_date date NULL disbursal_date date NULL utr_no character varying(255) NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL short_approval boolean NULL DEFAULT false order_amount double precision NULL DEFAULT 0.0 TABLE: fifty_fin_details (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('fifty_fin_details_id_seq'::regclass) loan_id character varying(255) NULL cams_request_no character varying(255) NULL karvy_request_no character varying(255) NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL INDEXES: fifty_fin_details_pkey: CREATE UNIQUE INDEX fifty_fin_details_pkey ON public.fifty_fin_details USING btree (id) TABLE: findoc_api_execution_log (15 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('findoc_api_execution_log_id_seq'::regclass) loan_id character varying(255) NOT NULL api_type character varying(50) NOT NULL loan_type character varying(10) NULL step_name character varying(100) NOT NULL step_index integer NOT NULL status character varying(20) NOT NULL response_message text NULL response_status_code character varying(20) NULL execution_time_ms bigint NULL started_at timestamp without time zone NOT NULL completed_at timestamp without time zone NULL error_message text NULL created_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP response_data text NULL INDEXES: findoc_api_execution_log_pkey: CREATE UNIQUE INDEX findoc_api_execution_log_pkey ON public.findoc_api_execution_log USING btree (id) idx_findoc_log_api_type: CREATE INDEX idx_findoc_log_api_type ON public.findoc_api_execution_log USING btree (api_type) idx_findoc_log_loan_id: CREATE INDEX idx_findoc_log_loan_id ON public.findoc_api_execution_log USING btree (loan_id) idx_findoc_log_started_at: CREATE INDEX idx_findoc_log_started_at ON public.findoc_api_execution_log USING btree (started_at) TABLE: findoc_details (44 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('findoc_details_id_seq'::regclass) loan_id character varying(255) NULL client_id character varying(255) NULL resource_id character varying(255) NULL resource_identifier character varying(255) NULL last_step text NULL fin_loan_id text NULL loan_account_no text NULL aadhaar_resource_id text NULL pan_resource_id text NULL mandate_resource_id text NULL subvention_excluding_gst double precision NULL DEFAULT 0 subvention_including_gst double precision NULL DEFAULT 0 disburse_amount double precision NULL DEFAULT 0 summary text NULL processing_fee double precision NULL DEFAULT 0 utr_no text NULL final_disburse_amount double precision NULL DEFAULT 0 disburse_date timestamp without time zone NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL complete_step_date timestamp without time zone NULL bank_resource_id character varying(255) NULL excess_amount_paid double precision NULL DEFAULT 0.0 total_outstanding double precision NULL DEFAULT 0.0 total_overdue double precision NULL DEFAULT 0.0 total_waived double precision NULL DEFAULT 0.0 penalty_charges_outstanding double precision NULL DEFAULT 0.0 principal_disbursed double precision NULL DEFAULT 0.0 pan_identifier character varying(225) NULL aadhaar_identifier character varying(225) NULL order_amount double precision NULL DEFAULT 0.0 cloudbankin_lead boolean NULL DEFAULT false dedupe_flow boolean NULL DEFAULT false principal_overdue double precision NULL DEFAULT 0.0 fee_charges_overdue double precision NULL DEFAULT 0.0 penalty_charges_overdue double precision NULL DEFAULT 0.0 client_id_m2p character varying(100) NULL loan_id_m2p character varying(100) NULL closed boolean NULL DEFAULT false total_excess_paid double precision NULL DEFAULT 0.0 term_frequency double precision NULL DEFAULT 0.0 principal_amount double precision NULL DEFAULT 0.0 expected_first_repayment_on_date timestamp without time zone NULL INDEXES: uq_findoc_details_loan_id: CREATE UNIQUE INDEX uq_findoc_details_loan_id ON public.findoc_details USING btree (loan_id) TABLE: findoc_repayment_schedule (66 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('findoc_repayment_schedule_id_seq'::regclass) loan_id character varying(255) NULL emi_no integer NULL from_date timestamp without time zone NULL due_date timestamp without time zone NULL complete boolean NULL days_in_period integer NULL principal_original_due double precision NULL DEFAULT 0 principal_due double precision NULL DEFAULT 0 principal_paid double precision NULL DEFAULT 0 principal_written_off double precision NULL DEFAULT 0 principal_outstanding double precision NULL DEFAULT 0 principal_loan_balance_outstanding double precision NULL DEFAULT 0 interest_original_due double precision NULL DEFAULT 0 interest_due double precision NULL DEFAULT 0 interest_paid double precision NULL DEFAULT 0 interest_waived double precision NULL DEFAULT 0 interest_written_off double precision NULL DEFAULT 0 interest_outstanding double precision NULL DEFAULT 0 fee_charges_due double precision NULL DEFAULT 0 fee_charges_paid double precision NULL DEFAULT 0 fee_charges_waived double precision NULL DEFAULT 0 fee_charges_written_off double precision NULL DEFAULT 0 fee_charges_outstanding double precision NULL DEFAULT 0 penalty_charges_due double precision NULL DEFAULT 0 penalty_charges_paid double precision NULL DEFAULT 0 penalty_charges_waived double precision NULL DEFAULT 0 penalty_charges_written_off double precision NULL DEFAULT 0 penalty_charges_outstanding double precision NULL DEFAULT 0 total_original_due_for_period double precision NULL DEFAULT 0 total_due_for_period double precision NULL DEFAULT 0 total_paid_for_period double precision NULL DEFAULT 0 total_paid_in_advance_for_period double precision NULL DEFAULT 0 total_paid_late_for_period double precision NULL DEFAULT 0 total_waived_for_period double precision NULL DEFAULT 0 total_written_off_for_period double precision NULL DEFAULT 0 total_outstanding_for_period double precision NULL DEFAULT 0 total_actual_cost_of_loan_for_period double precision NULL DEFAULT 0 total_installment_amount_for_period double precision NULL DEFAULT 0 recalculated_interest_component boolean NULL advance_payment_amount double precision NULL DEFAULT 0 interest_adjusted_due_to_grace double precision NULL DEFAULT 0 interest_accruable double precision NULL DEFAULT 0 added_on timestamp without time zone NULL updated_on timestamp without time zone NULL debit_status text NULL update_rps_txn_id text NULL razor_pay_payment_link_id text NULL bounce_status character varying(50) NULL presentation_status character varying(50) NULL payment_link character varying(255) NULL payment_link_id character varying(255) NULL foreclosed boolean NULL DEFAULT false obligations_met_on_date timestamp without time zone NULL upcoming boolean NULL DEFAULT false fee_charges_tax_due double precision NULL DEFAULT 0 fee_charges_tax_paid double precision NULL DEFAULT 0 fee_charges_tax_waived double precision NULL DEFAULT 0 fee_charges_tax_written_off double precision NULL DEFAULT 0 fee_charges_tax_outstanding double precision NULL DEFAULT 0 penalty_charges_tax_due double precision NULL DEFAULT 0 penalty_charges_tax_paid double precision NULL DEFAULT 0 penalty_charges_tax_waived double precision NULL DEFAULT 0 penalty_charges_tax_written_off double precision NULL DEFAULT 0 penalty_charges_tax_outstanding double precision NULL DEFAULT 0 prepaid boolean NULL DEFAULT false TABLE: help_desk_tickets (14 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('help_desk_tickets_id_seq'::regclass) identifier_id character varying(255) NULL lead_contact_number character varying(255) NULL description character varying(2000) NULL image_url_1 character varying(255) NULL image_url_2 character varying(255) NULL image_url_3 character varying(255) NULL status character varying(50) NULL comments character varying(2000) NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL identifier_type character varying(255) NULL priority text NULL assign_to text NULL INDEXES: help_desk_tickets_pkey: CREATE UNIQUE INDEX help_desk_tickets_pkey ON public.help_desk_tickets USING btree (id) TABLE: ivr_call_details (35 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('ivr_call_details_id_seq'::regclass) loan_id character varying(255) NULL user_id character varying(255) NULL mobile_number character varying(50) NULL call_sid character varying(255) NULL parent_call_sid character varying(255) NULL date_created timestamp without time zone NULL date_updated timestamp without time zone NULL account_sid character varying(255) NULL to_number character varying(50) NULL from_number character varying(50) NULL phone_number_sid character varying(255) NULL status character varying(50) NULL start_time timestamp without time zone NULL end_time timestamp without time zone NULL duration character varying(50) NULL price character varying(50) NULL direction character varying(50) NULL answered_by character varying(50) NULL forwarded_from character varying(50) NULL caller_name character varying(255) NULL uri text NULL recording_url text NULL digit character varying(10) NULL call_from character varying(50) NULL call_to character varying(50) NULL dial_call_duration character varying(50) NULL call_type character varying(50) NULL dial_whom_number character varying(50) NULL flow_id character varying(50) NULL tenant_id character varying(50) NULL exotel_current_time timestamp without time zone NULL created_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP initiated_by character varying(100) NULL INDEXES: ivr_call_details_call_sid_key: CREATE UNIQUE INDEX ivr_call_details_call_sid_key ON public.ivr_call_details USING btree (call_sid) ivr_call_details_pkey: CREATE UNIQUE INDEX ivr_call_details_pkey ON public.ivr_call_details USING btree (id) idx_ivr_call_details_call_sid: CREATE INDEX idx_ivr_call_details_call_sid ON public.ivr_call_details USING btree (call_sid) idx_ivr_call_details_flow_id: CREATE INDEX idx_ivr_call_details_flow_id ON public.ivr_call_details USING btree (flow_id) idx_ivr_call_details_loan_id: CREATE INDEX idx_ivr_call_details_loan_id ON public.ivr_call_details USING btree (loan_id) idx_ivr_call_details_mobile_number: CREATE INDEX idx_ivr_call_details_mobile_number ON public.ivr_call_details USING btree (mobile_number) idx_ivr_call_details_tenant_id: CREATE INDEX idx_ivr_call_details_tenant_id ON public.ivr_call_details USING btree (tenant_id) idx_ivr_call_details_user_id: CREATE INDEX idx_ivr_call_details_user_id ON public.ivr_call_details USING btree (user_id) TABLE: juspay_session_details (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('juspay_session_details_id_seq'::regclass) loan_id character varying(255) NULL session_type character varying(255) NULL order_id character varying(255) NULL order_status character varying(255) NULL status character varying(255) NULL sub_status character varying(255) NULL request_id character varying(255) NULL web_payment_link character varying(1000) NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL order_amount double precision NULL ready_to_settle boolean NULL DEFAULT false TABLE: kyc_request (34 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('kyc_request_id_seq'::regclass) loan_id text NULL user_id text NULL customer_identifier text NULL customer_name text NULL template_name text NULL notify_customer boolean NULL expire_in_days integer NULL generate_access_token boolean NULL reference_id text NULL transaction_id text NULL generate_deeplink_info boolean NULL digio_id text NULL status text NULL reminder_registered boolean NULL access_token_entity_id text NULL access_token_id text NULL access_token_valid_till timestamp without time zone NULL workflow_name text NULL auto_approved boolean NULL template_id text NULL updated_at timestamp without time zone NULL created_at timestamp without time zone NULL actions text NULL deep_intent_url text NULL deep_qr_url text NULL aadhaar_url text NULL pan_url text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL kyc_report_url text NULL image_url text NULL name_on_aadhaar_card text NULL name_on_pancard text NULL INDEXES: kyc_request_pkey: CREATE UNIQUE INDEX kyc_request_pkey ON public.kyc_request USING btree (id) idx_kyc_request_digio_id: CREATE INDEX idx_kyc_request_digio_id ON public.kyc_request USING btree (digio_id) idx_kyc_request_loan_id: CREATE INDEX idx_kyc_request_loan_id ON public.kyc_request USING btree (loan_id) idx_kyc_request_user_id: CREATE INDEX idx_kyc_request_user_id ON public.kyc_request USING btree (user_id) TABLE: lazypay_customer_status (12 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('lazypay_customer_status_id_seq'::regclass) loan_id text NOT NULL mobile text NULL customer_info_required boolean NULL pre_approval_status boolean NULL onboarding_required boolean NULL available_limit double precision NULL ntb_eligible boolean NULL sub_merchant_id text NULL customer_status_response text NULL created_date timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP updated_date timestamp without time zone NULL INDEXES: lazypay_customer_status_pkey: CREATE UNIQUE INDEX lazypay_customer_status_pkey ON public.lazypay_customer_status USING btree (id) TABLE: lazypay_details (24 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('lazypay_details_id_seq'::regclass) loan_id text NOT NULL bnpl_txn_eligibility boolean NULL bnpl_reason text NULL bnpl_user_eligibility boolean NULL cof_txn_eligibility boolean NULL cof_reason text NULL cof_available_limit double precision NULL offered_emi_plans text NULL merchant_txn_id text NULL order_id text NULL redirect_url text NULL order_amount double precision NULL order_status text NULL existing_user boolean NULL sub_merchant_id text NULL eligibility_response text NULL order_response text NULL webhook_events text NULL created_date timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP updated_date timestamp without time zone NULL selected_emi_plan text NULL eligibility_check boolean NULL DEFAULT false short_approved boolean NULL DEFAULT false INDEXES: lazypay_details_pkey: CREATE UNIQUE INDEX lazypay_details_pkey ON public.lazypay_details USING btree (id) TABLE: lazypay_eligibility (15 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('lazypay_eligibility_id_seq'::regclass) loan_id text NOT NULL bnpl_txn_eligibility boolean NULL bnpl_reason text NULL bnpl_user_eligibility boolean NULL cof_txn_eligibility boolean NULL cof_reason text NULL cof_available_limit double precision NULL offered_emi_plans text NULL existing_user boolean NULL sub_merchant_id text NULL eligibility_response text NULL short_approved boolean NULL DEFAULT false created_date timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP updated_date timestamp without time zone NULL INDEXES: lazypay_eligibility_pkey: CREATE UNIQUE INDEX lazypay_eligibility_pkey ON public.lazypay_eligibility USING btree (id) TABLE: lazypay_orders (14 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('lazypay_orders_id_seq'::regclass) loan_id text NOT NULL merchant_txn_id text NULL order_id text NULL redirect_url text NULL order_amount double precision NULL order_status text NULL selected_emi_plan text NULL sub_merchant_id text NULL order_response text NULL webhook_events text NULL created_date timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP updated_date timestamp without time zone NULL ready_to_settle boolean NULL DEFAULT false INDEXES: lazypay_orders_pkey: CREATE UNIQUE INDEX lazypay_orders_pkey ON public.lazypay_orders USING btree (id) TABLE: lead_tracking (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('lead_tracking_id_seq'::regclass) user_id character varying(100) NULL loan_id character varying(100) NULL identifier_type character varying(50) NULL identifier character varying(100) NULL added_on date NULL INDEXES: lead_tracking_pkey: CREATE UNIQUE INDEX lead_tracking_pkey ON public.lead_tracking USING btree (id) TABLE: lender_decision_detail (9 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('lender_decision_detail_id_seq'::regclass) loan_id text NULL lender_name character varying(255) NULL decision character varying(50) NULL limit integer NULL DEFAULT 0 enhanced_limit integer NULL DEFAULT 0 added_on timestamp without time zone NULL rejection_reason character varying(500) NULL decision_type character varying(255) NULL INDEXES: lender_decision_detail_pkey: CREATE UNIQUE INDEX lender_decision_detail_pkey ON public.lender_decision_detail USING btree (id) TABLE: lender_eligibility_pincode_blacklist (6 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('lender_eligibility_pincode_blacklist_id_seq'::regclass) lender_config_id bigint NOT NULL pincode character varying(10) NOT NULL is_active boolean NULL DEFAULT true added_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP added_by text NULL INDEXES: lender_eligibility_pincode_blacklist_pkey: CREATE UNIQUE INDEX lender_eligibility_pincode_blacklist_pkey ON public.lender_eligibility_pincode_blacklist USING btree (id) idx_is_active: CREATE INDEX idx_is_active ON public.lender_eligibility_pincode_blacklist USING btree (is_active) idx_lender_config_id: CREATE INDEX idx_lender_config_id ON public.lender_eligibility_pincode_blacklist USING btree (lender_config_id) idx_lender_pincode: CREATE INDEX idx_lender_pincode ON public.lender_eligibility_pincode_blacklist USING btree (lender_config_id, pincode) idx_pincode: CREATE INDEX idx_pincode ON public.lender_eligibility_pincode_blacklist USING btree (pincode) idx_unique_lender_pincode: CREATE UNIQUE INDEX idx_unique_lender_pincode ON public.lender_eligibility_pincode_blacklist USING btree (lender_config_id, pincode) WHERE (is_active = true) TABLE: lender_loan_status (5 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('lender_loan_status_id_seq'::regclass) lender_id character varying(255) NOT NULL loan_id character varying(255) NOT NULL external_status character varying(255) NOT NULL added_on timestamp without time zone NULL INDEXES: lender_loan_status_pkey: CREATE UNIQUE INDEX lender_loan_status_pkey ON public.lender_loan_status USING btree (id) TABLE: lender_to_cp_status_mapping (4 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('lender_to_cp_status_mapping_id_seq'::regclass) external_status character varying(255) NULL status_code integer NOT NULL lender_id character varying(255) NULL INDEXES: lender_to_cp_status_mapping_pkey: CREATE UNIQUE INDEX lender_to_cp_status_mapping_pkey ON public.lender_to_cp_status_mapping USING btree (id) TABLE: loan_calculation (19 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('loan_calculation_id_seq'::regclass) loan_id character varying(255) NULL treatment_amount double precision NULL DEFAULT 0.0 loan_amount double precision NULL DEFAULT 0.0 total_tenure integer NULL DEFAULT 0 effective_tenure integer NULL DEFAULT 0 subvention_excl_gst_amount double precision NULL DEFAULT 0.0 subvention_excl_gst_rate double precision NULL DEFAULT 0.0 subvention_incl_gst_amount double precision NULL DEFAULT 0.0 subvention_incl_gst_rate double precision NULL DEFAULT 0.0 processing_fee double precision NULL DEFAULT 0.0 adjusted_subvention_incl_gst_rate double precision NULL DEFAULT 0.0 adjusted_processing_fee_rate double precision NULL DEFAULT 0.0 disburse_amount double precision NULL DEFAULT 0.0 apr double precision NULL DEFAULT 0.0 agreement_date timestamp without time zone NULL product_id character varying(255) NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL TABLE: loan_comment (24 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('loan_comment_id_seq'::regclass) entity_type character varying(50) NOT NULL entity_id character varying(255) NOT NULL comment_text text NOT NULL comment_type character varying(50) NULL DEFAULT 'GENERAL'::character varying priority character varying(20) NULL DEFAULT 'NORMAL'::character varying created_by_type character varying(50) NOT NULL created_by_id character varying(255) NOT NULL created_by_name character varying(255) NULL is_internal boolean NULL DEFAULT false is_important boolean NULL DEFAULT false status character varying(20) NULL DEFAULT 'ACTIVE'::character varying has_reminder boolean NULL DEFAULT false reminder_date timestamp without time zone NULL reminder_status character varying(20) NULL reminder_completion_date timestamp without time zone NULL reminder_completion_notes text NULL reminder_priority character varying(20) NULL metadata text NULL tags character varying(500) NULL created_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NULL deleted_on timestamp without time zone NULL deleted_by character varying(255) NULL INDEXES: loan_comment_pkey: CREATE UNIQUE INDEX loan_comment_pkey ON public.loan_comment USING btree (id) idx_loan_comment_created_by: CREATE INDEX idx_loan_comment_created_by ON public.loan_comment USING btree (created_by_type, created_by_id) idx_loan_comment_created_on: CREATE INDEX idx_loan_comment_created_on ON public.loan_comment USING btree (created_on DESC) idx_loan_comment_entity: CREATE INDEX idx_loan_comment_entity ON public.loan_comment USING btree (entity_type, entity_id) idx_loan_comment_priority: CREATE INDEX idx_loan_comment_priority ON public.loan_comment USING btree (priority) idx_loan_comment_reminder: CREATE INDEX idx_loan_comment_reminder ON public.loan_comment USING btree (reminder_status, reminder_date) WHERE (has_reminder = true) idx_loan_comment_status: CREATE INDEX idx_loan_comment_status ON public.loan_comment USING btree (status) idx_loan_comment_type: CREATE INDEX idx_loan_comment_type ON public.loan_comment USING btree (comment_type) TABLE: loan_communication_log (4 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('loan_communication_log_id_seq'::regclass) loan_id character varying(255) NULL added_on timestamp without time zone NULL merchant_utr_notification_1 boolean NULL INDEXES: loan_communication_log_pkey: CREATE UNIQUE INDEX loan_communication_log_pkey ON public.loan_communication_log USING btree (id) TABLE: loan_decision_detail (8 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('loan_decision_detail_id_seq'::regclass) loan_id text NULL type text NULL loan_status text NULL comment text NULL change_by text NULL added_on timestamp without time zone NULL user_id text NULL TABLE: loan_detail (65 columns) ------------------------------------------------------------ loan_id text NULL loan_amount bigint NULL DEFAULT 0 loan_reason text NULL loan_apply_date timestamp without time zone NULL loan_sanction_status text NULL total_payback_amount integer NULL payback_duration integer NULL if_salaried_account text NULL payback_status text NULL penalty_amount integer NULL total_payback_with_penalty text NULL payback_type text NULL loan_return_date date NULL loan_payback_date timestamp without time zone NULL loan_approve_date timestamp without time zone NULL loan_approve_reason text NULL disburse_date timestamp without time zone NULL score character varying NULL disberse_date timestamp without time zone NULL id integer NOT NULL DEFAULT nextval('loan_detail_id_seq'::regclass) loan_approve_amount bigint NULL paid_amount integer NULL certificate_number text NULL approve_status boolean NULL DEFAULT false tentative_approve_amount bigint NULL tentative_tenure text NULL DEFAULT 0 loan_emi integer NULL DEFAULT 0 call_shifts integer NULL DEFAULT '-1'::integer call_status boolean NULL DEFAULT false call_schedule_date text NULL customer_call_duration text NULL ivr_status integer NULL DEFAULT '-2'::integer call_time text NULL tentative_time timestamp without time zone NULL DEFAULT now() soft_approved text NULL soft_approved_date timestamp without time zone NULL emi_apply boolean NULL DEFAULT false loan_from text NULL nbfc_id text NULL platform_from text NULL mark_complete_type text NULL incomplete_type text NULL tea_garden_id text NULL kyc_status boolean NULL DEFAULT false esign_status integer NULL DEFAULT 0 doctor_id text NULL doctor_name text NULL is_ntc boolean NULL DEFAULT false monthly_emi_expense bigint NULL loan_reject_date timestamp without time zone NULL keyfact_statement_url text NULL is_repeat text NULL product_id text NULL is_subvention_loan boolean NULL DEFAULT false treatment_amount bigint NULL DEFAULT 0 advance_emi_amount double precision NULL DEFAULT 0 utr_no text NULL pf_amount double precision NULL DEFAULT 0 disburse_amount double precision NULL DEFAULT 0 subvention_amt_incl_gst double precision NULL DEFAULT 0 loan_type character varying(50) NULL is_closed boolean NULL DEFAULT false short_approved boolean NULL DEFAULT false order_id text NULL asked_treatment_amount bigint NULL DEFAULT 0 INDEXES: idx_loan_detail_doctor_loan: CREATE INDEX idx_loan_detail_doctor_loan ON public.loan_detail USING btree (doctor_id, loan_id) WHERE (loan_id IS NOT NULL) idx_ld_doctor_id_loan_apply_date: CREATE INDEX idx_ld_doctor_id_loan_apply_date ON public.loan_detail USING btree (doctor_id, loan_apply_date) idx_loan_detail_apply_date: CREATE INDEX idx_loan_detail_apply_date ON public.loan_detail USING btree (loan_apply_date DESC) idx_loan_detail_apply_date_doctor: CREATE INDEX idx_loan_detail_apply_date_doctor ON public.loan_detail USING btree (loan_apply_date, doctor_id) WHERE (loan_id IS NOT NULL) idx_loan_detail_doctor_apply_date: CREATE INDEX idx_loan_detail_doctor_apply_date ON public.loan_detail USING btree (doctor_id, loan_apply_date DESC) WHERE (loan_id IS NOT NULL) idx_loan_detail_doctor_date: CREATE INDEX idx_loan_detail_doctor_date ON public.loan_detail USING btree (doctor_id, loan_apply_date) idx_loan_detail_doctor_id: CREATE INDEX idx_loan_detail_doctor_id ON public.loan_detail USING btree (doctor_id) idx_loan_detail_doctor_treatment: CREATE INDEX idx_loan_detail_doctor_treatment ON public.loan_detail USING btree (doctor_id, treatment_amount) WHERE (treatment_amount IS NOT NULL) idx_loan_detail_is_closed: CREATE INDEX idx_loan_detail_is_closed ON public.loan_detail USING btree (is_closed) WHERE (is_closed IS NOT NULL) idx_loan_detail_loan_id: CREATE INDEX idx_loan_detail_loan_id ON public.loan_detail USING btree (loan_id) idx_loan_detail_nbfc_closed: CREATE INDEX idx_loan_detail_nbfc_closed ON public.loan_detail USING btree (nbfc_id, is_closed) WHERE (nbfc_id IS NOT NULL) TABLE: loan_nbfc (6 columns) ------------------------------------------------------------ loan_id text NOT NULL is_eligible_check_on_findoc boolean NULL is_eligible_check_on_fibe boolean NULL is_eligible_check_on_zype boolean NULL is_eligible_check_on_juspay_cardless boolean NULL is_eligible_check_on_lazypay boolean NULL INDEXES: loan_nbfc_pkey: CREATE UNIQUE INDEX loan_nbfc_pkey ON public.loan_nbfc USING btree (loan_id) TABLE: loan_status (4 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('loan_status_id_seq'::regclass) loan_id character varying(255) NOT NULL status_code integer NOT NULL added_on timestamp without time zone NULL INDEXES: loan_status_pkey: CREATE UNIQUE INDEX loan_status_pkey ON public.loan_status USING btree (id) idx_loan_status_code: CREATE INDEX idx_loan_status_code ON public.loan_status USING btree (status_code) idx_loan_status_loan_code: CREATE INDEX idx_loan_status_loan_code ON public.loan_status USING btree (loan_id, status_code) idx_loan_status_loan_code_date: CREATE INDEX idx_loan_status_loan_code_date ON public.loan_status USING btree (loan_id, status_code, added_on DESC) idx_loan_status_loan_id: CREATE INDEX idx_loan_status_loan_id ON public.loan_status USING btree (loan_id) idx_loan_status_loan_id_code: CREATE INDEX idx_loan_status_loan_id_code ON public.loan_status USING btree (loan_id, status_code) TABLE: loan_to_application (4 columns) ------------------------------------------------------------ loan_id text NULL application_id text NULL id integer NOT NULL DEFAULT nextval('loan_to_application_id_seq'::regclass) gift_card_id text NULL INDEXES: idx_loan_to_application_application_id: CREATE INDEX idx_loan_to_application_application_id ON public.loan_to_application USING btree (application_id) WHERE (application_id IS NOT NULL) idx_loan_to_application_loan_id: CREATE INDEX idx_loan_to_application_loan_id ON public.loan_to_application USING btree (loan_id) uk_application_id: CREATE UNIQUE INDEX uk_application_id ON public.loan_to_application USING btree (application_id) uk_loan_id: CREATE UNIQUE INDEX uk_loan_id ON public.loan_to_application USING btree (loan_id) TABLE: loan_webhook (8 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('loan_webhook_id_seq'::regclass) utr_no text NULL approved_amount double precision NULL DEFAULT 0 disbursed_amount double precision NULL DEFAULT 0 application_no text NULL docs bytea NULL unique_id_no text NULL loan_id text NULL TABLE: mandate (19 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('mandate_id_seq'::regclass) loan_id character varying(255) NULL mandate_id character varying(255) NULL umrn character varying(255) NULL state character varying(100) NULL status character varying(100) NULL created_at timestamp without time zone NULL valid_till timestamp without time zone NULL data text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL mandate_type character varying(100) NULL authentication_url text NULL current_stage character varying(100) NULL message text NULL npci_txn_id character varying(255) NULL phone_number character varying(255) NULL auth_sub_mode character varying(100) NULL maximum_amount double precision NULL INDEXES: mandate_pkey: CREATE UNIQUE INDEX mandate_pkey ON public.mandate USING btree (id) TABLE: media_library_asset (14 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('media_library_asset_id_seq'::regclass) asset_id character varying(64) NOT NULL title character varying(255) NOT NULL language character varying(64) NULL category character varying(128) NULL file_name character varying(255) NULL bucket_name character varying(128) NOT NULL bucket_key character varying(512) NOT NULL content_type character varying(128) NULL size_bytes bigint NULL url text NULL active boolean NOT NULL DEFAULT true added_on timestamp without time zone NOT NULL DEFAULT now() updated_on timestamp without time zone NOT NULL DEFAULT now() INDEXES: media_library_asset_pkey: CREATE UNIQUE INDEX media_library_asset_pkey ON public.media_library_asset USING btree (id) ux_media_library_asset_asset_id: CREATE UNIQUE INDEX ux_media_library_asset_asset_id ON public.media_library_asset USING btree (asset_id) ux_media_library_asset_bucket_key: CREATE UNIQUE INDEX ux_media_library_asset_bucket_key ON public.media_library_asset USING btree (bucket_key) TABLE: merchant_logs (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('merchant_logs_id_seq'::regclass) doctor_id character varying(255) NULL type character varying(100) NULL remark text NULL log_message text NULL added_on timestamp without time zone NULL INDEXES: merchant_logs_pkey: CREATE UNIQUE INDEX merchant_logs_pkey ON public.merchant_logs USING btree (id) TABLE: mis_data (22 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('mis_data_id_seq'::regclass) application_no character varying(100) NULL user_id character varying(100) NULL loan_id character varying(100) NULL borrower_name character varying(255) NULL borrower_mobile_no character varying(20) NULL patient_name character varying(255) NULL patient_mobile_no character varying(20) NULL loan_amount double precision NULL DEFAULT 0.0 treatment_amount double precision NULL DEFAULT 0.0 final_disbursed_amount double precision NULL DEFAULT 0.0 subvention_amount_including_gst double precision NULL DEFAULT 0.0 downpayment_amount double precision NULL DEFAULT 0.0 purpose_of_loan character varying(255) NULL loan_application_date timestamp without time zone NULL clinic_name character varying(255) NULL loan_application_status character varying(100) NULL product_name character varying(255) NULL disbursed_date timestamp without time zone NULL utr_number character varying(100) NULL lender_name character varying(255) NULL added_on timestamp without time zone NULL INDEXES: mis_data_pkey: CREATE UNIQUE INDEX mis_data_pkey ON public.mis_data USING btree (id) TABLE: mis_scheduler (10 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('mis_scheduler_id_seq'::regclass) vendor_name character varying(255) NULL execution_time character varying(255) NULL mail_id character varying(255) NULL cc_mail character varying(255) NULL enabled boolean NOT NULL added_on timestamp without time zone NULL updated_at timestamp without time zone NULL doctor_code character varying(255) NULL type character varying(255) NULL INDEXES: mis_scheduler_pkey: CREATE UNIQUE INDEX mis_scheduler_pkey ON public.mis_scheduler USING btree (id) TABLE: nbfc (19 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('nbfc_id_seq'::regclass) name text NULL razorpay_api text NULL razorpay_secret text NULL max_days text NULL max_month text NULL interest_rate text NULL nbfc_id text NULL columns_allowed text NULL api_key text NULL logo_url text NULL dynamic_emi boolean NULL DEFAULT false contact_person_name text NULL contact_person_number text NULL city text NULL state text NULL address text NULL pin_code text NULL authentication_token text NULL INDEXES: idx_nbfc_nbfc_id: CREATE INDEX idx_nbfc_nbfc_id ON public.nbfc USING btree (nbfc_id) TABLE: new_status_record (55 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('new_status_record_id_seq'::regclass) loan_id character varying(100) NULL application_initiated timestamp without time zone NULL application_in_progress timestamp without time zone NULL application_complete timestamp without time zone NULL lender_eligibility_check timestamp without time zone NULL decisioning_initiated timestamp without time zone NULL awaiting_lender_decision timestamp without time zone NULL loan_rejected timestamp without time zone NULL income_verification_required timestamp without time zone NULL approved timestamp without time zone NULL emi_plans_eligibility_check timestamp without time zone NULL emi_plan_selected timestamp without time zone NULL lender_flow_initiated timestamp without time zone NULL kyc_required timestamp without time zone NULL kyc_failed timestamp without time zone NULL kyc_complete timestamp without time zone NULL agreement_signing_initiated timestamp without time zone NULL agreement_generated timestamp without time zone NULL agreement_signing_failed timestamp without time zone NULL agreement_signed timestamp without time zone NULL bank_acc_kyc_initiated timestamp without time zone NULL bank_acc_kyc_successful timestamp without time zone NULL bank_acc_kyc_failed timestamp without time zone NULL emi_auto_pay_setup_in_progress timestamp without time zone NULL emi_auto_pay_setup_failed timestamp without time zone NULL emi_auto_pay_setup_complete timestamp without time zone NULL disbursal_initiated timestamp without time zone NULL disbursal_failed timestamp without time zone NULL loan_disbursed timestamp without time zone NULL utr_received timestamp without time zone NULL kyc_initiated timestamp without time zone NULL face_verification_initiated timestamp without time zone NULL face_verification_completed timestamp without time zone NULL digi_kyc_initiated timestamp without time zone NULL digi_kyc_completed timestamp without time zone NULL digi_kyc_failed timestamp without time zone NULL rfd timestamp without time zone NULL loan_operation_complete timestamp without time zone NULL name_verification_success timestamp without time zone NULL name_verification_failed timestamp without time zone NULL vc_pending timestamp without time zone NULL vc_completed timestamp without time zone NULL vc_skipped timestamp without time zone NULL do_generated timestamp without time zone NULL do_shared timestamp without time zone NULL invoice_required timestamp without time zone NULL invoice_uploaded timestamp without time zone NULL invoice_shared timestamp without time zone NULL invoice_skipped timestamp without time zone NULL digio_kyc_completed timestamp without time zone NULL digio_kyc_initiated timestamp without time zone NULL short_approval timestamp without time zone NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL INDEXES: new_status_record_pkey: CREATE UNIQUE INDEX new_status_record_pkey ON public.new_status_record USING btree (id) TABLE: nexus_audit_log (8 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('nexus_audit_log_id_seq'::regclass) table_name text NULL record_id text NULL action text NULL old_values text NULL new_values text NULL user_id text NULL timestamp timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP INDEXES: idx_nexus_audit_log_record: CREATE INDEX idx_nexus_audit_log_record ON public.nexus_audit_log USING btree (record_id) idx_nexus_audit_log_table: CREATE INDEX idx_nexus_audit_log_table ON public.nexus_audit_log USING btree (table_name) idx_nexus_audit_log_timestamp: CREATE INDEX idx_nexus_audit_log_timestamp ON public.nexus_audit_log USING btree ("timestamp") TABLE: nexus_details (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('nexus_details_id_seq'::regclass) nexus_id text NOT NULL name text NULL email_id text NULL phone_number text NULL password text NULL parent_nexus_id text NULL level integer NULL DEFAULT 1 created_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_date timestamp without time zone NULL created_by text NULL status text NULL DEFAULT 'ACTIVE'::text nexus_login_otp integer NULL INDEXES: nexus_details_email_id_key: CREATE UNIQUE INDEX nexus_details_email_id_key ON public.nexus_details USING btree (email_id) nexus_details_nexus_id_key: CREATE UNIQUE INDEX nexus_details_nexus_id_key ON public.nexus_details USING btree (nexus_id) nexus_details_phone_number_key: CREATE UNIQUE INDEX nexus_details_phone_number_key ON public.nexus_details USING btree (phone_number) idx_nd_parent_nexus_id_status: CREATE INDEX idx_nd_parent_nexus_id_status ON public.nexus_details USING btree (parent_nexus_id, status) WHERE (status = 'ACTIVE'::text) idx_nexus_details_email: CREATE INDEX idx_nexus_details_email ON public.nexus_details USING btree (email_id) idx_nexus_details_nexus_id: CREATE INDEX idx_nexus_details_nexus_id ON public.nexus_details USING btree (nexus_id) idx_nexus_details_parent: CREATE INDEX idx_nexus_details_parent ON public.nexus_details USING btree (parent_nexus_id) idx_nexus_details_parent_status: CREATE INDEX idx_nexus_details_parent_status ON public.nexus_details USING btree (parent_nexus_id, status) WHERE (status = 'ACTIVE'::text) idx_nexus_details_phone: CREATE INDEX idx_nexus_details_phone ON public.nexus_details USING btree (phone_number) idx_nexus_details_status: CREATE INDEX idx_nexus_details_status ON public.nexus_details USING btree (status) TABLE: nexus_doctor_mapping (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('nexus_doctor_mapping_id_seq'::regclass) nexus_id text NOT NULL doctor_id text NOT NULL assigned_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP assigned_by text NULL status text NULL DEFAULT 'ACTIVE'::text INDEXES: nexus_doctor_mapping_nexus_id_doctor_id_key: CREATE UNIQUE INDEX nexus_doctor_mapping_nexus_id_doctor_id_key ON public.nexus_doctor_mapping USING btree (nexus_id, doctor_id) idx_ndm_doctor_id_nexus_id_status: CREATE INDEX idx_ndm_doctor_id_nexus_id_status ON public.nexus_doctor_mapping USING btree (doctor_id, nexus_id, status) WHERE (status = 'ACTIVE'::text) idx_ndm_doctor_id_status: CREATE INDEX idx_ndm_doctor_id_status ON public.nexus_doctor_mapping USING btree (doctor_id, status) WHERE (status = 'ACTIVE'::text) idx_ndm_nexus_id_status: CREATE INDEX idx_ndm_nexus_id_status ON public.nexus_doctor_mapping USING btree (nexus_id, status) WHERE (status = 'ACTIVE'::text) idx_nexus_doctor_mapping_doctor: CREATE INDEX idx_nexus_doctor_mapping_doctor ON public.nexus_doctor_mapping USING btree (doctor_id) idx_nexus_doctor_mapping_doctor_id: CREATE INDEX idx_nexus_doctor_mapping_doctor_id ON public.nexus_doctor_mapping USING btree (nexus_id) idx_nexus_doctor_mapping_doctor_status: CREATE INDEX idx_nexus_doctor_mapping_doctor_status ON public.nexus_doctor_mapping USING btree (nexus_id, status) WHERE (status = 'ACTIVE'::text) idx_nexus_doctor_mapping_nexus: CREATE INDEX idx_nexus_doctor_mapping_nexus ON public.nexus_doctor_mapping USING btree (nexus_id) idx_nexus_doctor_mapping_nexus_doctor_status: CREATE INDEX idx_nexus_doctor_mapping_nexus_doctor_status ON public.nexus_doctor_mapping USING btree (nexus_id, doctor_id, status) idx_nexus_doctor_mapping_nexus_status: CREATE INDEX idx_nexus_doctor_mapping_nexus_status ON public.nexus_doctor_mapping USING btree (nexus_id, status) WHERE (status = 'ACTIVE'::text) idx_nexus_doctor_mapping_status: CREATE INDEX idx_nexus_doctor_mapping_status ON public.nexus_doctor_mapping USING btree (status) TABLE: nexus_performance (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('nexus_performance_id_seq'::regclass) nexus_id character varying(255) NOT NULL target_id integer NULL period_start_date date NOT NULL period_end_date date NOT NULL target_type character varying(50) NOT NULL target_value numeric NOT NULL actual_value numeric NOT NULL achievement_percentage numeric NULL status character varying(20) NULL calculated_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP notification_sent boolean NULL DEFAULT false notification_sent_at timestamp without time zone NULL INDEXES: nexus_performance_pkey: CREATE UNIQUE INDEX nexus_performance_pkey ON public.nexus_performance USING btree (id) idx_nexus_performance_calculated_at: CREATE INDEX idx_nexus_performance_calculated_at ON public.nexus_performance USING btree (calculated_at) idx_nexus_performance_nexus_id: CREATE INDEX idx_nexus_performance_nexus_id ON public.nexus_performance USING btree (nexus_id) idx_nexus_performance_period: CREATE INDEX idx_nexus_performance_period ON public.nexus_performance USING btree (period_start_date, period_end_date) idx_nexus_performance_status: CREATE INDEX idx_nexus_performance_status ON public.nexus_performance USING btree (status) idx_nexus_performance_target_id: CREATE INDEX idx_nexus_performance_target_id ON public.nexus_performance USING btree (target_id) TABLE: nexus_target (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('nexus_target_id_seq'::regclass) nexus_id character varying(255) NOT NULL target_type character varying(50) NOT NULL target_value numeric NOT NULL period_type character varying(20) NOT NULL period_start_date date NOT NULL period_end_date date NOT NULL assigned_by character varying(255) NULL assigned_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP status character varying(20) NULL DEFAULT 'ACTIVE'::character varying notes text NULL created_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_at timestamp without time zone NULL INDEXES: nexus_target_pkey: CREATE UNIQUE INDEX nexus_target_pkey ON public.nexus_target USING btree (id) idx_nexus_target_nexus_id: CREATE INDEX idx_nexus_target_nexus_id ON public.nexus_target USING btree (nexus_id) idx_nexus_target_period: CREATE INDEX idx_nexus_target_period ON public.nexus_target USING btree (period_start_date, period_end_date) idx_nexus_target_status: CREATE INDEX idx_nexus_target_status ON public.nexus_target USING btree (status) idx_nexus_target_type: CREATE INDEX idx_nexus_target_type ON public.nexus_target USING btree (target_type) TABLE: nexus_visit (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('nexus_visit_id_seq'::regclass) nexus_id character varying(255) NOT NULL visit_id character varying(255) NOT NULL doctor_id character varying(255) NULL visit_date timestamp without time zone NULL check_in timestamp without time zone NULL check_out timestamp without time zone NULL status character varying(50) NULL check_in_location text NULL check_out_location text NULL doctor_opportunity_id character varying(255) NULL reminder_sent integer NULL DEFAULT 0 clinic_image character varying(255) NULL INDEXES: nexus_visit_pkey: CREATE UNIQUE INDEX nexus_visit_pkey ON public.nexus_visit USING btree (id) nexus_visit_visit_id_unique: CREATE UNIQUE INDEX nexus_visit_visit_id_unique ON public.nexus_visit USING btree (visit_id) TABLE: occupational_detail (8 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('occupational_detail_id_seq'::regclass) user_id text NULL highest_qualification text NULL employer_type text NULL change_date date NULL full_part_time text NULL optional_email text NULL designation text NULL TABLE: otp (4 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('otp_id_seq'::regclass) otp integer NULL mobile_number text NULL added_on timestamp without time zone NULL TABLE: payment_links_detail (21 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('payment_links_id_seq'::regclass) payment_link_id text NULL loan_id text NULL emi_no integer NULL short_url text NULL status text NULL created_at timestamp without time zone NULL amount integer NULL currency character varying(3) NULL customer_name character varying(100) NULL customer_contact character varying(15) NULL reference_id character varying(50) NULL expire_by timestamp without time zone NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL user_id text NULL paid_date timestamp without time zone NULL payment_id text NULL payment_type character varying(100) NULL posted_to_findoc character varying(50) NULL posted_date timestamp without time zone NULL TABLE: payu_settlement (10 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('payu_settlement_id_seq'::regclass) settlement_id character varying(255) NULL merchant_id character varying(255) NULL utr_number character varying(255) NULL settlement_amount character varying(50) NULL transaction_amount character varying(50) NULL settlement_date timestamp without time zone NULL raw_response text NULL created_on timestamp without time zone NULL updated_on timestamp without time zone NULL INDEXES: payu_settlement_pkey: CREATE UNIQUE INDEX payu_settlement_pkey ON public.payu_settlement USING btree (id) payu_settlement_settlement_id_key: CREATE UNIQUE INDEX payu_settlement_settlement_id_key ON public.payu_settlement USING btree (settlement_id) TABLE: personal_loan_credit_decision (9 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('personal_loan_credit_decision_id_seq'::regclass) user_id character varying(255) NOT NULL income_declared numeric NULL employment_tenure integer NULL decision character varying(50) NULL external_api_response text NULL created_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP status character varying(20) NULL DEFAULT 'ACTIVE'::character varying INDEXES: personal_loan_credit_decision_pkey: CREATE UNIQUE INDEX personal_loan_credit_decision_pkey ON public.personal_loan_credit_decision USING btree (id) TABLE: personal_loan_product (14 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('personal_loan_product_id_seq'::regclass) product_id character varying(255) NULL product_name character varying(50) NULL total_emi integer NULL advance_emi integer NULL processing_fees_including_gst_rate numeric NULL processing_fees_including_gst_inr integer NULL subvention_rate integer NULL nbfc_take_percent integer NULL interest integer NULL status boolean NULL processing_fees_type character varying(20) NULL reference_id character varying(255) NULL interest_type character varying(20) NULL INDEXES: personal_loan_product_pkey: CREATE UNIQUE INDEX personal_loan_product_pkey ON public.personal_loan_product USING btree (id) personal_loan_product_product_id_key: CREATE UNIQUE INDEX personal_loan_product_product_id_key ON public.personal_loan_product USING btree (product_id) TABLE: policy_doctor_mapping (8 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('policy_doctor_mapping_id_seq'::regclass) doctor_id character varying(255) NOT NULL small_ticket_policy character varying(50) NULL DEFAULT 'Active'::character varying medium_ticket_policy character varying(50) NULL DEFAULT 'Active'::character varying large_ticket_policy character varying(50) NULL DEFAULT 'Active'::character varying added_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NULL changed_by character varying(255) NULL INDEXES: policy_doctor_mapping_doctor_id_key: CREATE UNIQUE INDEX policy_doctor_mapping_doctor_id_key ON public.policy_doctor_mapping USING btree (doctor_id) policy_doctor_mapping_pkey: CREATE UNIQUE INDEX policy_doctor_mapping_pkey ON public.policy_doctor_mapping USING btree (id) TABLE: product_details (15 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('product_details_id_seq'::regclass) product_id text NULL product_name text NULL total_emi integer NULL advance_emi integer NULL processing_fees_including_gst_rate double precision NULL processing_fees_including_gst_inr double precision NULL subvention_rate double precision NULL nbfc_take_percent double precision NULL interest double precision NULL status boolean NULL DEFAULT false processing_fees_type text NULL reference_id text NULL money_view_scheme_id text NULL zype_scheme_id character varying(255) NULL TABLE: razorpay (36 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('razorpay_id_seq'::regclass) user_id text NULL loan_id text NULL customer_id text NULL razorpay_signature text NULL razorpay_order_id text NULL razorpay_payment_id text NULL error text NULL token_id text NULL is_token_present boolean NULL DEFAULT false date timestamp without time zone NULL gift_card_id text NULL method_type text NULL status text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL acquirer_data text NULL entity character varying(255) NULL amount integer NULL invoice_id character varying(255) NULL method character varying(255) NULL amount_refunded integer NULL refund_status character varying(255) NULL captured boolean NULL description text NULL card_id character varying(255) NULL bank character varying(255) NULL wallet character varying(255) NULL vpa character varying(255) NULL email character varying(255) NULL contact character varying(255) NULL fee integer NULL tax integer NULL emi_issuer text NULL emi_duration integer NULL DEFAULT 0 emi_rate double precision NULL DEFAULT 0.0 TABLE: repayment_schedule (14 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('repayment_schedule_id_seq'::regclass) user_id text NULL repay_schedule_id integer NULL DEFAULT 0 company_id integer NULL DEFAULT 0 product_id integer NULL DEFAULT 0 loan_id text NULL emi_no integer NULL DEFAULT 0 due_date text NULL emi_amount double precision NULL DEFAULT 0 prin double precision NULL DEFAULT 0 int_amount double precision NULL DEFAULT 0 __v integer NULL DEFAULT 0 added_on timestamp without time zone NULL outstanding_principal double precision NULL TABLE: roles (5 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('roles_id_seq'::regclass) role_code text NULL role_name text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL TABLE: salaried_detail (27 columns) ------------------------------------------------------------ user_id text NULL organization_name text NULL net_take_home_salary integer NULL DEFAULT 0 work_experience_current_organization text NULL is_this_first_job text NULL work_experience_previous_organization text NULL total_experience text NULL id integer NOT NULL DEFAULT nextval('salaried_detail_id_seq'::regclass) office_address text NULL salary_day integer NULL DEFAULT 0 no_of_employees integer NULL organisation_verified boolean NULL DEFAULT false date_of_joining text NULL employer_type text NULL monthly_in_hand_salary integer NULL DEFAULT 0 monthly_family_income integer NULL DEFAULT 0 current_company_name text NULL workplace_address1 text NULL workplace_address2 text NULL workplace_pincode text NULL industry text NULL current_job_exp_in_month integer NULL DEFAULT 0 current_job_exp_in_years integer NULL DEFAULT 0 total_job_exp_in_month integer NULL DEFAULT 0 total_job_exp_in_years integer NULL DEFAULT 0 employment_type text NULL salary_verified boolean NULL DEFAULT false TABLE: scout_performance (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('scout_performance_id_seq'::regclass) scout_id character varying(255) NOT NULL target_id integer NULL period_start_date date NOT NULL period_end_date date NOT NULL target_type character varying(50) NOT NULL target_value numeric NOT NULL actual_value numeric NOT NULL achievement_percentage numeric NULL status character varying(20) NULL calculated_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP notification_sent boolean NULL DEFAULT false notification_sent_at timestamp without time zone NULL INDEXES: scout_performance_pkey: CREATE UNIQUE INDEX scout_performance_pkey ON public.scout_performance USING btree (id) idx_scout_performance_calculated_at: CREATE INDEX idx_scout_performance_calculated_at ON public.scout_performance USING btree (calculated_at) idx_scout_performance_period: CREATE INDEX idx_scout_performance_period ON public.scout_performance USING btree (period_start_date, period_end_date) idx_scout_performance_scout_id: CREATE INDEX idx_scout_performance_scout_id ON public.scout_performance USING btree (scout_id) idx_scout_performance_status: CREATE INDEX idx_scout_performance_status ON public.scout_performance USING btree (status) idx_scout_performance_target_id: CREATE INDEX idx_scout_performance_target_id ON public.scout_performance USING btree (target_id) TABLE: scout_target (13 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('scout_target_id_seq'::regclass) scout_id character varying(255) NOT NULL target_type character varying(50) NOT NULL target_value numeric NOT NULL period_type character varying(20) NOT NULL period_start_date date NOT NULL period_end_date date NOT NULL assigned_by character varying(255) NULL assigned_date timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP status character varying(20) NULL DEFAULT 'ACTIVE'::character varying notes text NULL created_at timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_at timestamp without time zone NULL INDEXES: scout_target_pkey: CREATE UNIQUE INDEX scout_target_pkey ON public.scout_target USING btree (id) idx_scout_target_period: CREATE INDEX idx_scout_target_period ON public.scout_target USING btree (period_start_date, period_end_date) idx_scout_target_scout_id: CREATE INDEX idx_scout_target_scout_id ON public.scout_target USING btree (scout_id) idx_scout_target_status: CREATE INDEX idx_scout_target_status ON public.scout_target USING btree (status) idx_scout_target_type: CREATE INDEX idx_scout_target_type ON public.scout_target USING btree (target_type) TABLE: scout_visit (11 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('scout_visit_id_seq'::regclass) scout_id character varying(255) NULL visit_id character varying(255) NULL doctor_id character varying(255) NULL visit_date date NULL check_in timestamp without time zone NULL check_out timestamp without time zone NULL status character varying(100) NULL check_in_location character varying(255) NULL check_out_location character varying(255) NULL doctor_opportunity_id text NULL INDEXES: scout_visit_pkey: CREATE UNIQUE INDEX scout_visit_pkey ON public.scout_visit USING btree (id) TABLE: sftp_ingestion_file (12 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('sftp_ingestion_file_id_seq'::regclass) file_name character varying(255) NOT NULL remote_path character varying(1000) NOT NULL file_size_bytes bigint NULL remote_mtime_epoch bigint NULL status character varying(40) NOT NULL attempt_count integer NOT NULL DEFAULT 0 last_error text NULL local_path character varying(1000) NULL processed_on timestamp without time zone NULL added_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP INDEXES: sftp_ingestion_file_pkey: CREATE UNIQUE INDEX sftp_ingestion_file_pkey ON public.sftp_ingestion_file USING btree (id) uk_sftp_ingestion_file_remote_path: CREATE UNIQUE INDEX uk_sftp_ingestion_file_remote_path ON public.sftp_ingestion_file USING btree (remote_path) idx_sftp_ingestion_file_status: CREATE INDEX idx_sftp_ingestion_file_status ON public.sftp_ingestion_file USING btree (status) idx_sftp_ingestion_file_updated_on: CREATE INDEX idx_sftp_ingestion_file_updated_on ON public.sftp_ingestion_file USING btree (updated_on DESC) TABLE: signzy_digilocker (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('signzy_digilocker_id_seq'::regclass) loan_id character varying(255) NULL request_id character varying(255) NULL url text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL TABLE: signzy_digilocker_docs (20 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('signzy_digilocker_docs_id_seq'::regclass) loan_id text NULL digilocker_id text NULL name text NULL mobile text NULL dob text NULL gender text NULL eaadhaar text NULL file_name text NULL file_type text NULL doc_type text NULL description text NULL issuer_id text NULL issuer text NULL file_id text NULL xml_url text NULL pdf_url text NULL json_url text NULL added_on timestamp without time zone NULL carepay_url text NULL TABLE: signzy_penny_drop (15 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('signzy_penny_drop_id_seq'::regclass) loan_id character varying(255) NULL data text NULL active character varying(255) NULL reason character varying(255) NULL name_match character varying(255) NULL mobile_match character varying(255) NULL signzy_reference_id character varying(255) NULL name_match_score character varying(255) NULL bank_transfer text NULL audit_trail text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL audit_time_tamp timestamp without time zone NULL doctor_id text NULL INDEXES: signzy_penny_drop_pkey: CREATE UNIQUE INDEX signzy_penny_drop_pkey ON public.signzy_penny_drop USING btree (id) TABLE: status (7 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('status_id_seq'::regclass) status_code integer NOT NULL user_status character varying(255) NULL admin_status character varying(255) NULL merchant_status character varying(255) NULL scout_status character varying(255) NULL colour_code character varying(255) NULL INDEXES: status_pkey: CREATE UNIQUE INDEX status_pkey ON public.status USING btree (id) TABLE: status_change_detail (8 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('status_change_detail_id_seq'::regclass) loan_id text NULL user_id text NULL previous_status text NULL updated_status text NULL comment text NULL changed_by text NULL change_on timestamp without time zone NULL TABLE: status_mapping (5 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('status_mapping_id_seq'::regclass) user_status text NULL admin_status text NULL status_id text NULL colour_code text NULL INDEXES: status_mapping_pkey: CREATE UNIQUE INDEX status_mapping_pkey ON public.status_mapping USING btree (id) idx_status_mapping_status_id: CREATE INDEX idx_status_mapping_status_id ON public.status_mapping USING btree (status_id) TABLE: treatment_details (10 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('treatment_details_id_seq'::regclass) speciality character varying(255) NULL treatment_name character varying(255) NULL treatment_category character varying(255) NULL cost double precision NULL time character varying(255) NULL status character varying(50) NULL DEFAULT 'active'::character varying added_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP description text NULL INDEXES: treatment_details_pkey: CREATE UNIQUE INDEX treatment_details_pkey ON public.treatment_details USING btree (id) idx_treatment_category: CREATE INDEX idx_treatment_category ON public.treatment_details USING btree (treatment_category) idx_treatment_speciality: CREATE INDEX idx_treatment_speciality ON public.treatment_details USING btree (speciality) idx_treatment_status: CREATE INDEX idx_treatment_status ON public.treatment_details USING btree (status) TABLE: treatment_invoice (16 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('treatment_invoice_id_seq'::regclass) billing_date timestamp without time zone NOT NULL invoice_number character varying(255) NOT NULL loan_id character varying(100) NOT NULL invoice_url text NOT NULL added_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP verification_status character varying NULL DEFAULT 'pending'::character varying verification_date date NULL verified_by character varying NULL remarks character varying NULL customer_name character varying(255) NULL treatment_name character varying(255) NULL total_amount character varying(100) NULL approved_by character varying(255) NULL approval_date timestamp without time zone NULL INDEXES: treatment_invoice_pkey: CREATE UNIQUE INDEX treatment_invoice_pkey ON public.treatment_invoice USING btree (id) TABLE: user_activity_detail (9 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('user_activity_detail_id_seq'::regclass) user_id text NULL type text NULL added_by text NULL added_on timestamp without time zone NULL activity text NULL loan_id text NULL updated_on timestamp without time zone NULL comments text NULL TABLE: user_address (12 columns) ------------------------------------------------------------ user_id text NULL address_type text NULL address text NULL state text NULL city text NULL pincode integer NULL residence_type text NULL residence_value text NULL change_date date NULL id integer NOT NULL DEFAULT nextval('user_address_id_seq'::regclass) locality text NULL landmark text NULL INDEXES: idx_user_address_user_id_id: CREATE INDEX idx_user_address_user_id_id ON public.user_address USING btree (user_id, id DESC) TABLE: user_documents_detail (42 columns) ------------------------------------------------------------ user_id text NULL loan_id text NULL photograph_url text NULL salary_proof_url text NULL pan_card_url text NULL bank_statement_url text NULL adhar_card_url text NULL cibil_url text NULL itr_url text NULL status text NULL loan_agreement text NULL id integer NOT NULL DEFAULT nextval('user_documents_detail_id_seq'::regclass) stamp_duty_url text NULL address text NULL city text NULL loan_cheque text NULL comments text NULL office_id_url text NULL location_image_url text NULL finbix_entity_id text NULL finbox_statement_id text NULL transaction_data text NULL finbox_hit integer NULL DEFAULT 0 finbox_statement_status text NULL signed_loan_aggreement text NULL current_address_url text NULL document_upload_status boolean NULL DEFAULT false gst_url text NULL other_doc_url text NULL multiple_bank_statements text NULL bank_statement_password text NULL other_doc_name text NULL audit_trail_url text NULL prescription_url text NULL adhar_card_back_url text NULL doctor_signed_aggrement_url text NULL rent_agreement_url text NULL electricity_bill_url text NULL gas_connection_bill_url text NULL wifi_bill_url text NULL telephone_bill_url text NULL treatment_proof text NULL TABLE: user_favorite_clinic (6 columns) ------------------------------------------------------------ id bigint NOT NULL DEFAULT nextval('user_favorite_clinic_id_seq'::regclass) user_id character varying(255) NOT NULL doctor_id character varying(255) NOT NULL is_favorite boolean NULL DEFAULT true added_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP INDEXES: user_favorite_clinic_pkey: CREATE UNIQUE INDEX user_favorite_clinic_pkey ON public.user_favorite_clinic USING btree (id) TABLE: user_login (50 columns) ------------------------------------------------------------ user_id text NULL first_name text NULL middle_name text NULL last_name text NULL date_of_birth text NULL gender text NULL marital_status text NULL email_id text NULL mobile_number bigint NULL name_of_reference text NULL religion text NULL image_url text NULL mobile_verified boolean NULL form_status text NULL login_date timestamp without time zone NULL login_device text NULL reference_code text NULL sourceofinfo_plateform text NULL adhahar_link_status boolean NULL DEFAULT false alternate_number text NULL nach_status boolean NULL DEFAULT false verified boolean NULL DEFAULT false loan_from text NULL mail_subscribe boolean NULL DEFAULT true crif_decision text NULL recent_login timestamp without time zone NULL email_verified boolean NULL DEFAULT false save_date timestamp without time zone NULL important text NULL pan_no text NULL login_type integer NULL DEFAULT 0 pan_card_name text NULL completion_status boolean NULL DEFAULT false father_name text NULL reference_number text NULL reference_name text NULL reference_relation text NULL consent boolean NULL DEFAULT false aadhaar_no text NULL mother_name text NULL type_of_email text NULL education_level text NULL created_date timestamp without time zone NULL consent_timestamp timestamp without time zone NULL aadhaar_verified boolean NULL DEFAULT false name_as_per_pan text NULL name_as_per_aadhaar text NULL test_lead boolean NULL DEFAULT false activation_status character varying(50) NULL name_as_per_bureau character varying(255) NULL INDEXES: user_login_user_id_unique: CREATE UNIQUE INDEX user_login_user_id_unique ON public.user_login USING btree (user_id) idx_user_login_completion_date: CREATE INDEX idx_user_login_completion_date ON public.user_login USING btree (completion_status, login_date DESC) WHERE (login_date IS NOT NULL) idx_user_login_date_completion: CREATE INDEX idx_user_login_date_completion ON public.user_login USING btree (login_date DESC, completion_status) WHERE (login_date IS NOT NULL) idx_user_login_email_id: CREATE INDEX idx_user_login_email_id ON public.user_login USING btree (email_id) WHERE (email_id IS NOT NULL) idx_user_login_important: CREATE INDEX idx_user_login_important ON public.user_login USING btree (important) WHERE (important = 'yes'::text) idx_user_login_mobile_number: CREATE INDEX idx_user_login_mobile_number ON public.user_login USING btree (mobile_number) WHERE (mobile_number IS NOT NULL) idx_user_login_recent_login: CREATE INDEX idx_user_login_recent_login ON public.user_login USING btree (recent_login DESC NULLS LAST) WHERE (login_date IS NOT NULL) idx_user_login_user_id: CREATE INDEX idx_user_login_user_id ON public.user_login USING btree (user_id) unique_mobile_number: CREATE UNIQUE INDEX unique_mobile_number ON public.user_login USING btree (mobile_number) TABLE: user_logs (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('user_logs_id_seq'::regclass) log_message text NULL type text NULL added_on timestamp without time zone NULL user_id text NULL remark text NULL INDEXES: useridindex: CREATE INDEX useridindex ON public.user_logs USING btree (user_id) TABLE: user_rating (6 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('user_rating_id_seq'::regclass) loan_id character varying(255) NULL stars double precision NULL DEFAULT 0 comment text NULL created_at timestamp without time zone NULL updated_at timestamp without time zone NULL TABLE: user_to_bank (5 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('user_to_bank_id_seq'::regclass) user_id text NULL bank_id text NULL added_on timestamp without time zone NULL updated_on timestamp without time zone NULL TABLE: user_to_loan (44 columns) ------------------------------------------------------------ user_id text NULL loan_id text NULL loan_amount bigint NULL loan_status text NULL application_status text NULL id integer NOT NULL DEFAULT nextval('user_to_loan_id_seq'::regclass) status_date date NULL assign_to text NULL alert boolean NULL DEFAULT false extension_time boolean NULL DEFAULT false field_boy_assign text NULL referral_code text NULL complete_application_status boolean NULL DEFAULT false latest_activity_date timestamp without time zone NULL current_obligation text NULL nbfc_sent_status boolean NULL DEFAULT false loan_sub_status text NULL assigned_date timestamp without time zone NULL last_assigned character varying NULL incomplete_mark_status boolean NULL DEFAULT false ambassador_id text NULL patient_name text NULL relationship_with_patient text NULL patient_email_id text NULL patient_phone_number text NULL device_type text NULL loan_form_status text NULL quality_check boolean NULL DEFAULT false status_logs text NULL policy_id text NULL bureau_type text NULL do_shared character varying(255) NULL name_verification_status character varying(50) NULL DEFAULT NULL::character varying name_verification_date timestamp without time zone NULL name_verification_manual_override boolean NULL DEFAULT false name_verification_verified_by character varying(255) NULL DEFAULT NULL::character varying name_verification_remarks text NULL is_complete boolean NULL DEFAULT false surepass_score character varying(255) NULL experian_score character varying(255) NULL surepass_type character varying(255) NULL experian_type character varying(255) NULL do_timestamp timestamp without time zone NULL approval_source character varying(50) NULL INDEXES: idx_user_to_loan_loan_id: CREATE INDEX idx_user_to_loan_loan_id ON public.user_to_loan USING btree (loan_id) idx_user_to_loan_loan_id_name_verification: CREATE INDEX idx_user_to_loan_loan_id_name_verification ON public.user_to_loan USING btree (loan_id, name_verification_status) idx_user_to_loan_loan_id_status: CREATE INDEX idx_user_to_loan_loan_id_status ON public.user_to_loan USING btree (loan_id, loan_status) idx_user_to_loan_loan_status: CREATE INDEX idx_user_to_loan_loan_status ON public.user_to_loan USING btree (loan_id, loan_status) idx_user_to_loan_name_verification_status: CREATE INDEX idx_user_to_loan_name_verification_status ON public.user_to_loan USING btree (name_verification_status) idx_user_to_loan_status: CREATE INDEX idx_user_to_loan_status ON public.user_to_loan USING btree (loan_status) idx_user_to_loan_status_complete: CREATE INDEX idx_user_to_loan_status_complete ON public.user_to_loan USING btree (loan_status, is_complete) WHERE (loan_status = '105'::text) idx_user_to_loan_user_id: CREATE INDEX idx_user_to_loan_user_id ON public.user_to_loan USING btree (user_id) idx_utl_loan_id_name_verification: CREATE INDEX idx_utl_loan_id_name_verification ON public.user_to_loan USING btree (loan_id, name_verification_status) idx_utl_loan_id_status: CREATE INDEX idx_utl_loan_id_status ON public.user_to_loan USING btree (loan_id, loan_status) idx_user_to_loan_loan_id_unique: CREATE UNIQUE INDEX idx_user_to_loan_loan_id_unique ON public.user_to_loan USING btree (loan_id) TABLE: userdata (4 columns) ------------------------------------------------------------ id integer NOT NULL mobilenumber text NOT NULL email text NOT NULL name text NOT NULL INDEXES: userdata_email_key: CREATE UNIQUE INDEX userdata_email_key ON public.userdata USING btree (email) userdata_pkey: CREATE UNIQUE INDEX userdata_pkey ON public.userdata USING btree (id) TABLE: whatsapp_log (7 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('whatsapp_log_id_seq'::regclass) identifier character varying(255) NULL identifier_type character varying(255) NULL template_name character varying(255) NULL message text NULL send_to character varying(255) NULL send_date timestamp without time zone NULL INDEXES: whatsapp_log_pkey: CREATE UNIQUE INDEX whatsapp_log_pkey ON public.whatsapp_log USING btree (id) TABLE: zype_orders (21 columns) ------------------------------------------------------------ id integer NOT NULL DEFAULT nextval('zype_orders_id_seq'::regclass) loan_id character varying(255) NOT NULL sso_key character varying(255) NULL redirect_url text NULL webhook_status integer NULL loan_status character varying(255) NULL webhook_amount numeric NULL added_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP updated_on timestamp without time zone NULL DEFAULT CURRENT_TIMESTAMP offer integer NULL short_approved boolean NULL DEFAULT false kyc_status character varying(255) NULL offer_status character varying(255) NULL lead_status text NULL loan_lead_id character varying(255) NULL final_offer integer NULL offer_generated_mode character varying(255) NULL max_l1_offer_amount double precision NULL DEFAULT 0.0 order_amount double precision NULL DEFAULT 0.0 minimum_offer_amount integer NULL DEFAULT 0 bank_statement_required boolean NULL INDEXES: zype_orders_pkey: CREATE UNIQUE INDEX zype_orders_pkey ON public.zype_orders USING btree (id)