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