df

Tables (12)

BranchPerformances

  • record_id — INT
  • organization_id — INT — NOT NULL
  • branch_manager_name — VARCHAR(255) — NOT NULL
  • conversion_number — VARCHAR(50)
  • email — VARCHAR(255)
  • overdue_count — INT — NOT NULL
  • overdue_rate — DECIMAL(5,2) — NOT NULL
  • total_loan_executed — DECIMAL(18,2) — NOT NULL
  • total_loan_count — INT — NOT NULL
  • total_collateral_count — INT — NOT NULL
  • outstanding_rate — DECIMAL(5,2) — NOT NULL
  • additional_info — TEXT
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_overdue
  • INDEX — idx_outstanding

Collaterals

  • collateral_id — INT
  • customer_id — INT — NOT NULL
  • total_value — DECIMAL(18, 2) — NOT NULL
  • count_watch — INT — NOT NULL
  • count_bag — INT — NOT NULL
  • count_precious — INT — NOT NULL
  • count_apparel — INT — NOT NULL
  • count_electronics — INT — NOT NULL
  • count_other — INT — NOT NULL
  • loan_amount — DECIMAL(18, 2) — NOT NULL
  • execution_ratio — DECIMAL(5, 2) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • collateral_status — VARCHAR(50) — NOT NULL — 상환완료, 상환중, 유질
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_status
  • INDEX — idx_dates

ContractCollaterals

  • id — INT
  • contract_id — INT — NOT NULL
  • collateral_id — INT — NOT NULL

Contracts

  • contract_id — INT
  • customer_id — INT — NOT NULL
  • total_collateral_value — DECIMAL(18, 2) — NOT NULL
  • loan_amount — DECIMAL(18, 2) — NOT NULL
  • interest_rate — DECIMAL(5, 2) — NOT NULL
  • prepayment_fee — DECIMAL(18, 2) — NOT NULL
  • overdue_interest_rate — DECIMAL(5, 2) — NOT NULL
  • repayment_method — VARCHAR(50) — NOT NULL — 만기일시, 원리금균등, 원금균등
  • monthly_payment — DECIMAL(18, 2) — NOT NULL
  • interest_collection_date — DATE — NOT NULL
  • wholesale_finance — DECIMAL(18, 2)
  • wholesale_interest — DECIMAL(18, 2)
  • wholesale_repayment_method — VARCHAR(50)
  • notes — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_collection_date

Customers

  • customer_id — INT
  • name — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255)
  • account_number — VARCHAR(100)
  • birth_date — DATE — NOT NULL
  • id_document — VARCHAR(255) — NOT NULL
  • customer_type — VARCHAR(50) — NOT NULL — 대출없음, 대출중, 연체, 블랙리스트, 신규
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_customer_type
  • INDEX — idx_phone
  • INDEX — idx_email

Images

  • image_id — INT
  • related_entity_type — VARCHAR(50) — NOT NULL — product, organization
  • related_entity_id — INT — NOT NULL
  • image_type — VARCHAR(50) — NOT NULL — 정면, 측면, 후면, 버클, 추가이미지
  • image_path — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_entity

Loans

  • loan_id — INT
  • customer_id — INT — NOT NULL
  • total_loan_amount — DECIMAL(18,2) — NOT NULL
  • loan_date — DATE — NOT NULL
  • interest_payment_date — DATE — NOT NULL
  • outstanding_balance — DECIMAL(18,2) — NOT NULL
  • remaining_claims — DECIMAL(18,2) — NOT NULL
  • account_verified — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_loan_date
  • INDEX — idx_payment_date

LoginHistories

  • history_id — INT
  • user_id — INT — NOT NULL
  • login_time — DATETIME — NOT NULL
  • login_method — VARCHAR(50) — NOT NULL
  • success — BOOLEAN — NOT NULL
  • ip_address — VARCHAR(50) — NOT NULL
  • INDEX — idx_login_time
  • INDEX — idx_ip

MarketRates

  • rate_id — INT
  • asset_category — VARCHAR(50) — NOT NULL — PreciousMetal, Crypto, Exchange
  • asset_subtype — VARCHAR(50) — NOT NULL — 24k, 18k, 달러, 유로 등
  • current_price — DECIMAL(18, 4) — NOT NULL
  • collateral_ratio — DECIMAL(5, 2) — NOT NULL — 담보비율
  • change_value — DECIMAL(10, 4) — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_asset

Organizations

  • organization_id — INT
  • organization_name — VARCHAR(255) — NOT NULL
  • is_head — BOOLEAN — NOT NULL
  • parent_org_id — INT
  • logo — VARCHAR(255)
  • external_photo — VARCHAR(255)
  • internal_photo — VARCHAR(255)
  • registration_certificate — VARCHAR(255)
  • lending_post_notice — VARCHAR(255)
  • business_number — VARCHAR(100) — NOT NULL
  • lending_license_number — VARCHAR(100) — NOT NULL
  • account_number — VARCHAR(100)
  • business_address — VARCHAR(255) — NOT NULL
  • contact — VARCHAR(50) — NOT NULL
  • manager_name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_business_number
  • INDEX — idx_lending_license

Products

  • product_id — INT
  • collateral_id — INT — NOT NULL
  • category — VARCHAR(50) — NOT NULL — 시계, 가방, 귀금속, 의류/신발, 전자기기, 기타
  • brand — VARCHAR(255) — NOT NULL
  • model — VARCHAR(255) — NOT NULL
  • market_price — DECIMAL(18, 2) — NOT NULL
  • purchase_place — VARCHAR(255)
  • purchase_price — DECIMAL(18, 2)
  • purchase_datetime — DATETIME
  • condition — VARCHAR(50) — NOT NULL
  • manufacture_year — INT
  • image_directory — VARCHAR(255)
  • serial_number — VARCHAR(255)
  • components — TEXT
  • contract_id — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_category
  • INDEX — idx_brand

Users

  • user_id — INT
  • username — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • phone — VARCHAR(50)
  • login_type — VARCHAR(50) — NOT NULL — 로그인 타입 (normal, social)
  • role — VARCHAR(50) — NOT NULL — 사용자 역할 (본점, 지점, 개인, 개발자)
  • social_provider — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_email
  • INDEX — idx_phone