test
Tables (18)
bank (은행)
- code — varchar(10) — Primary key — NOT NULL
- name — varchar(10) — NOT NULL
- active — boolean — NOT NULL
- sort_order — integer — NOT NULL
- created_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_member_seq — bigint — NOT NULL
- updated_at — timestamp — NOT NULL
borrower (차주)
- borrower_seq (일련번호) — BIGINT — Primary key — NOT NULL
- borrower_id (차주ID) — varchar(20) — NOT NULL
- business_name (사업자명) — varchar(100) — NOT NULL
- business_number (사업자등록번호) — varchar(10) — NOT NULL
- representative_name (대표자명) — varchar(50) — NOT NULL
- mobile_phone (휴대전화번호) — varchar(11) — NOT NULL
- memo (메모) — text
- created_member_seq (생성자) — bigint — NOT NULL
- created_at (생성일시) — timestamp — NOT NULL
- updated_member_seq (수정자) — bigint — NOT NULL
- updated_at (수정일시) — timestamp — NOT NULL
borrower_change_history (차주 수정 이력)
- change_history_seq (일련번호) — BIGINT — Primary key — NOT NULL
- borrower_seq (차주 일련번호) — bigint — Foreign key → borrower.borrower_seq — NOT NULL
- changed_fields (수정 항목) — text — NOT NULL
- created_member_seq (생성자) — bigint — NOT NULL
- updated_member_seq (생성일시) — bigint — NOT NULL
- created_at (수정자) — timestamp — NOT NULL
- updated_at (수정일시) — timestamp — NOT NULL
fund_pool
- fund_pool_seq — BIGINT — Primary key — NOT NULL
- pool_id — varchar(20) — NOT NULL
- current_balance — decimal(19,0) — NOT NULL
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
fund_transaction
- fund_transaction_seq — BIGINT — Primary key — NOT NULL
- fund_pool_seq — bigint — Foreign key → fund_pool.fund_pool_seq — NOT NULL
- transaction_type — varchar(40) — NOT NULL
- direction — varchar(10) — NOT NULL
- amount — decimal(19,0) — NOT NULL
- occurred_on — date — NOT NULL
- description — varchar(500) — NOT NULL
- balance_after — decimal(19,0) — NOT NULL
- source_type — varchar(40)
- source_seq — bigint
- manual_reason — varchar(30)
- memo — text
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
investment_contract
- contract_seq — BIGINT — Primary key — NOT NULL
- contract_id — varchar(20) — NOT NULL
- investor_seq — bigint — Foreign key → investor.investor_seq — NOT NULL
- amount — decimal(19,0) — NOT NULL
- procurement_rate — decimal(7,4) — NOT NULL
- contract_start_date — date — NOT NULL
- maturity_date — date — NOT NULL
- payment_cycle — varchar(30) — NOT NULL
- payout_base_day — smallint
- contract_status — varchar(10) — NOT NULL
- memo — text
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
investment_early_redemption
- early_redemption_seq — BIGINT — Primary key — NOT NULL
- contract_seq — bigint — Foreign key → investment_contract.contract_seq — NOT NULL
- termination_date — date — NOT NULL
- returned_principal_amount — decimal(19,0) — NOT NULL
- accrued_interest_amount — decimal(19,0) — NOT NULL
- termination_fee_amount — decimal(19,0) — NOT NULL
- settlement_amount — decimal(19,0) — NOT NULL
- memo — text
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
investment_interest_schedule
- interest_schedule_seq — BIGINT — Primary key — NOT NULL
- contract_seq — bigint — Foreign key → investment_contract.contract_seq — NOT NULL
- period_start_date — date — NOT NULL
- period_end_date — date — NOT NULL
- due_date — date — NOT NULL
- scheduled_amount — decimal(19,0) — NOT NULL
- schedule_status — varchar(30) — NOT NULL
- paid_date — date
- paid_amount — decimal(19,0)
- memo — text
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
investment_principal_return
- principal_return_seq — BIGINT — Primary key — NOT NULL
- contract_seq — bigint — Foreign key → investment_contract.contract_seq — NOT NULL
- returned_amount — decimal(19,0) — NOT NULL
- returned_date — date — NOT NULL
- memo — text
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
investor
- investor_seq — BIGINT — Primary key — NOT NULL
- investor_id — varchar(20) — NOT NULL
- name — varchar(100) — NOT NULL
- business_number — varchar(10) — NOT NULL
- mobile_phone — varchar(20) — NOT NULL
- memo — text
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
investor_payout_account
- payout_account_seq — BIGINT — Primary key — NOT NULL
- investor_seq — bigint — Foreign key → investor.investor_seq — NOT NULL
- bank_code — varchar(10) — NOT NULL
- account_number — varchar(50) — NOT NULL
- account_holder — varchar(100) — NOT NULL
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
loan
- loan_seq — BIGINT — Primary key — NOT NULL
- loan_id — varchar(20) — NOT NULL
- borrower_seq — bigint — Foreign key → borrower.borrower_seq — NOT NULL
- interest_rate — decimal(7,4) — NOT NULL
- total_scheduled_settlement_amount — decimal(19,0) — NOT NULL
- total_principal_amount — decimal(19,0) — NOT NULL
- maturity_date — date — NOT NULL
- loan_status — varchar(30) — NOT NULL
- execution_date — date
- memo — text
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
loan_repayment
- repayment_seq — BIGINT — Primary key — NOT NULL
- repayment_schedule_seq — bigint — Foreign key → loan_repayment_schedule.repayment_schedule_seq — NOT NULL
- repayment_date — date — NOT NULL
- total_repayment_amount — decimal(19,0) — NOT NULL
- principal_amount — decimal(19,0) — NOT NULL
- interest_amount — decimal(19,0) — NOT NULL
- memo — text
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
loan_repayment_schedule
- repayment_schedule_seq — BIGINT — Primary key — NOT NULL
- loan_seq — bigint — Foreign key → loan.loan_seq — NOT NULL
- payer_seq — bigint — Foreign key → payer.payer_seq — NOT NULL
- due_date — date — NOT NULL
- scheduled_settlement_amount — decimal(19,0) — NOT NULL
- advance_ratio — decimal(7,4) — NOT NULL
- principal_amount — decimal(19,0) — NOT NULL
- schedule_status — varchar(30) — NOT NULL
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
payer
- payer_seq — BIGINT — Primary key — NOT NULL
- payer_id — varchar(20) — NOT NULL
- name — varchar(100) — NOT NULL
- ltv — decimal(5,2) — NOT NULL
- credit_grade — varchar(10) — NOT NULL
- active — boolean — NOT NULL
- memo — text
- created_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_member_seq — bigint — NOT NULL
- updated_at — timestamp — NOT NULL
payer_change_history
- change_history_seq — BIGINT — Primary key — NOT NULL
- payer_seq — bigint — Foreign key → payer.payer_seq — NOT NULL
- changed_fields — text — NOT NULL
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
settlement_account (정산 계좌)
- settlement_account_seq (일련번호) — BIGINT — Primary key — NOT NULL
- borrower_seq (차주 일련번호) — bigint — Foreign key → borrower.borrower_seq — NOT NULL
- bank_code (은행코드) — varchar(10) — NOT NULL
- account_number (계좌번호) — varchar(20) — NOT NULL
- account_holder (예금주) — varchar(20) — NOT NULL
- active (사용여부) — boolean — NOT NULL
- created_member_seq (생성자) — bigint — NOT NULL
- created_at (생성일시) — timestamp — NOT NULL
- updated_member_seq (수정자) — bigint — NOT NULL
- updated_at (수정일시) — timestamp — NOT NULL
settlement_schedule
- settlement_schedule_seq — BIGINT — Primary key — NOT NULL
- settlement_schedule_id — varchar(20) — NOT NULL
- repayment_schedule_seq — bigint — Foreign key → loan_repayment_schedule.repayment_schedule_seq — NOT NULL
- actual_amount — decimal(19,0)
- status — varchar(30) — NOT NULL
- memo — varchar(30)
- deposit_confirmed_at — timestamp
- created_member_seq — bigint — NOT NULL
- updated_member_seq — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL