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