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