자동차 보험회사 고객관리
테이블 (10)
accident_record
- accident_id — BIGINT
- vehicle_id — BIGINT — 외래 키 → vehicle.vehicle_id
- accident_datetime — DATETIME
- accident_description — TEXT
company
- company_id — BIGINT
- company_name — VARCHAR(100)
company_insurance_product
- company_product_id — BIGINT
- company_id — BIGINT — 외래 키 → company.company_id
- product_id — BIGINT — 외래 키 → insurance_product.product_id
- sale_name — VARCHAR(100)
- sale_status — VARCHAR(20)
- min_risk_level — INTEGER
- max_risk_level — INTEGER
- allowed_vehicle_grade — VARCHAR(20)
customer
- customer_id — BIGINT
- customer_name — VARCHAR(100)
- customer_type — VARCHAR(20)
employee_customer
- customer_id — BIGINT — 외래 키 → customer.customer_id
- company_name — VARCHAR(100)
insurance_product
- product_id — BIGINT
- product_name — VARCHAR(100)
- description — TEXT
insurance_subscription
- subscription_id — BIGINT
- customer_id — BIGINT — 외래 키 → customer.customer_id
- vehicle_id — BIGINT — 외래 키 → vehicle.vehicle_id
- company_product_id — BIGINT — 외래 키 → company_insurance_product.company_product_id
- subscription_status — VARCHAR(20)
occupation
- occupation_id — BIGINT
- occupation_name — VARCHAR(100)
- risk_level — INTEGER
self_employed_customer
- customer_id — BIGINT — 외래 키 → customer.customer_id
- occupation_id — BIGINT — 외래 키 → occupation.occupation_id
vehicle
- vehicle_id — BIGINT
- registration_no — VARCHAR(30)
- customer_id — BIGINT — 외래 키 → customer.customer_id
- manufacture_year — INTEGER
- vehicle_usage — VARCHAR(30)
- weekly_distance — INTEGER
- vehicle_grade — VARCHAR(20)