zz

Tables (6)

Copy Of Untitled (insurance_tb)

  • Key (insurance_id) — Primary key — NOT NULL
  • Field (display_name)
  • Field (insurance_plan(스마트/스탠다드/프리미엄))
  • Field (travel_type(국내/해외/장기체류))
  • Key (company_id) — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled2 (premium_tb)

  • Key (premium_id) — Primary key — NOT NULL
  • Field (term)
  • Field (age)
  • Field (gender)
  • Field (premium(보험료))
  • Key (insurance_id) — Foreign key → Copy Of Untitled.Key — NOT NULL

Untitled (policy_holder_tb)

  • Key (policy_holder_id) — Primary key — NOT NULL
  • Field (name)
  • Field (birth_date)
  • Field (gender)
  • Field (user_id(user_tb_fk))
  • Key (insurance_contract_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (created_date)
  • Field (modified_date)

Untitled (insurance_company_tb)

  • Key (company_id) — Primary key — NOT NULL
  • Field (company_name)

Untitled (insurance_contract_tb)

  • Key (insurance_contract_id) — Primary key — NOT NULL
  • Field (start_date)
  • Field (end_date)
  • Field (linked_date(연계날짜))
  • Field (total_premium(총비용))
  • Key (insurance_id) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (created_date)
  • Field (modified_date)

Untitled (insurance_maximum_benefit_tb)

  • Key (insurance_benefit_id) — Primary key — NOT NULL
  • Field (insurance_item)
  • Field (insurance_benefit)
  • Field (currency_code)
  • Key (insurance_id) — Foreign key → Copy Of Untitled.Key — NOT NULL