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