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)

Untitled

    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