Product
Tables (9)
Company (회사)
- company_id (Key) — VARCHAR — Primary key — NOT NULL
- company_name (Field)
- company_size (Field2)
Deposit (예금)
- product_id (Key) — VARCHAR — Primary key — NOT NULL
- product_name (Field)
- min_join_amount (Field2)
- min_term_months (Field3)
- max_term_months (Field4)
- min_interest_rate (Field5)
- type (Field6)
- max_interast_rate (Field7)
Fund (투자)
- product_id (Key) — BIGINT — Primary key — NOT NULL
- product_id (Key2) — Foreign key → product.product_id — NOT NULL
- risk_level (Field3) — INT
- accumulation_type (Field4) — VARCHAR(20)
- total_fee_rate (Field5) — DECIMAL(5, 4)
- equity_ratio (Field6) — DECIMAL(5, 2)
- diversification_type (Field7) — VARCHAR(20)
Loan (대출)
- product_id (Key) — VARCHAR — Primary key — NOT NULL
- product_id (Key2) — Foreign key → product.product_id — NOT NULL
- product_name (Field) — VARCHAR
- income_cap (Field2)
- condition (Field3)
- base_rate (Field4) — DECIMAL(5, 2)
- spread_rate (Field5) — DECIMAL(5, 2)
- prime_rate (Field6) — DECIMAL(5, 2)
- min_rate (Field7) — DECIMAL(5, 2)
- max_rate (Field8) — DECIMAL(5, 2)
- purpose (Field9) — VARCHAR
- loan_limit (Field10)
Saving (적금)
- product_id (Key) — VARCHAR — Primary key — NOT NULL
SavingRateTier (금리구간)
- rate_tier_id (Key) — Primary key — NOT NULL
- period_min_months (Field2)
- period_max_months (Field3)
- deposit_type (Field4)
- base_rate (Field5)
- product_id (Key2) — VARCHAR — Foreign key → Saving.product_id — NOT NULL
Tax_Shelter (절세)
- product_id (Key) — VARCHAR — Primary key — NOT NULL
- product_id (Key2) — Foreign key → product.product_id — NOT NULL
- account_kind (Field2) — VARCHAR(20)
- min_holding_period_years (Field3) — INT
- description (Field4) — TEXT
- operation_type (Field5) — VARCHAR(30)
- tax_benefit_type (Field6) — VARCHAR(30)
- fee (Field7)
product (상품)
- product_id (Key) — Primary key — NOT NULL
- product_type (Field)
- product_name (Field2)
- company_id (Key2) — VARCHAR — Foreign key → Company.company_id — NOT NULL