DB-TOSS

Tables (25)

account

  • account_id — integer
  • customer_id — integer
  • account_number — varchar
  • account_password — varchar
  • account_balance — decimal
  • account_type — varchar

card

  • card_id — integer
  • customer_id — integer
  • user_name — varchar
  • cvc_num — integer
  • cexpiry_date — date
  • card_pwd — integer
  • card_name — varchar
  • card_type — enum('debit', 'credit', 'prepaid')
  • card_bank — varchar
  • card_benefit — varchar
  • card_num — integer
  • card_traffic — boolean
  • card_abroad — boolean

card_transaction

  • cpermit_num — integer
  • card_id — integer
  • ct_time — integer
  • ct_amount — integer
  • ct_card — varchar
  • ct_use — varchar
  • ct_div — enum('online', 'offline')
  • cinstallment_period — integer

customer

  • customer_id — integer
  • personal_number — varchar
  • phone_number — varchar
  • user_name — varchar
  • telecom_provider — varchar
  • password — varchar
  • email — varchar
  • home_address — varchar
  • job_title — varchar

deposit

  • deposit_id — integer
  • investment_id — integer
  • deposit_period — integer
  • deposit_amount — integer
  • deposit_start_date — timestamp
  • deposit_exdate — date
  • deposit_tax — varchar
  • deposit_interest_rate — float
  • deposit_receive_account — varchar
  • deposit_interest_type — varchar
  • deposit_exmethod — varchar

depositcustomer

  • deposit_customer_id — integer
  • deposit_id — integer
  • customer_id — integer

exchange

  • exchange_id — integer
  • exchange_rate_id — integer
  • customer_id — integer
  • exchange_before_amount — integer
  • exchange_after_amount — integer
  • exchange_before_currency — varchar
  • exchange_after_currency — varchar
  • exchange_fee — float
  • exchange_type — varchar
  • exchange_account — varchar
  • exchange_card — varchar
  • exchange_date — timestamp

exchangerate

  • exchange_rate_id — integer
  • base_currency — varchar
  • comparison_currency — varchar
  • exchange_rate — float
  • exchange_rate_datetime — timestamp

insurance_applicant

  • insurance_applicant_id — integer
  • customer_id — integer
  • applicant_account_info — varchar(50)
  • risk_info — varchar(255)

insurance_claim

  • claim_id — integer
  • insurance_contract_id — integer
  • claim_details — varchar
  • claim_amount — integer
  • claim_date — date
  • payment_date — date
  • payment_amount — integer
  • applicant_account_info — varchar(50)

insurance_contract

  • insurance_contract_id — integer
  • applicantid — integer
  • insurance_product_id — integer
  • enrollmentdate — date
  • startdate — date
  • enddate — date
  • insurance_premium — integer
  • otherattributes — varchar

insurance_product

  • insurance_product_id — integer
  • insurance_product_name — varchar(50)
  • age_limit — integer
  • coveragecondition — varchar(255)
  • insurance_amount — integer
  • insurance_type — varchar(20)
  • compensation — decimal
  • otherattributes — varchar(255)

investment

  • investment_id — integer
  • investment_name — varchar
  • investment_type — varchar
  • investment_period_min — float
  • investment_period_max — float
  • investment_interest_rate_min — float
  • investment_interest_rate_max — float
  • investment_target — varchar

loan_applicant

  • loan_applicant_id — integer
  • customer_id — integer
  • applicant_income_info — varchar(255)
  • applicant_credit_info — varchar(255)
  • guarantor_info — varchar(255)
  • application_date — date

loan_contract

  • loan_contract_id — integer
  • loan_applicant_id — integer
  • loan_product_id — integer
  • application_date — date
  • approval_date — date
  • repayment_date — date
  • loan_amount — integer
  • loan_status — varchar(10)
  • loan_purpose — varchar(100)
  • customer_account_info — varchar(50)
  • otherattributes — varchar(255)

loan_product

  • loan_product_id — integer
  • loan_product_name — varchar(50)
  • loan_status — varchar(10)
  • interest_rate — float
  • loan_limit — integer
  • loan_term — integer
  • otherattributes — varchar(255)

loan_repayment

  • repayment_id — integer
  • loan_contract_id — integer
  • repayment_amount — integer
  • repayment_date — date
  • interest_rate — integer
  • loan_repayment_status — boolean

payment_info

  • payment_his — integer
  • payment_id — integer
  • payment_date — date
  • payment_amount — decimal(10,2)

payment_order

  • payment_id — integer
  • card_id — integer
  • customer_id — integer
  • order_status — enum('pending', 'completed', 'failed')
  • payment_success — boolean

savings

  • savings_id — integer
  • investment_id — integer
  • savings_cycle — varchar
  • savings_cycle_amount — integer
  • savings_period — integer
  • savings_amount — integer
  • savings_start_date — timestamp
  • savings_exdate — date
  • savings_tax — varchar
  • savings_interest_rate — float
  • savings_receive_account — varchar
  • savings_interest_type — varchar
  • savings_exmethod — varchar

savingscustomer

  • savings_customer_id — integer
  • savings_id — integer
  • customer_id — integer

termination

  • termi_id — integer
  • card_id — integer
  • termi_reason — varchar
  • termi_check — boolean
  • termi_date — date

transaction_history

  • transaction_his — integer
  • transaction_id — integer
  • amount — decimal(10,2)
  • transaction_date — date

transaction_info

  • transaction_id — integer
  • customer_id — integer
  • recipient_account — integer
  • recipient_bank — varchar(50)

user_authentication

  • customer_auth — integer
  • customer_id — integer
  • password — varchar(100)
  • face_id — varchar(100)
  • auth_success — boolean