BoheomMong
Tables (9)
BaseEntity
- base_entity_id — BIGINT
- create_date — DATETIME — NOT NULL
- update_date — DATETIME
- delete_date — DATETIME
- is_deleted — TINYINT(1) — NOT NULL
Bookmark
- bookmark_id — BIGINT
- base_entity_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
InsuranceCompany
- company_id — INT
- base_entity_id — BIGINT — NOT NULL
- company_name — VARCHAR(50) — NOT NULL
- company_website — VARCHAR(255) — NOT NULL — 크롤링 대상 URL/공식 웹사이트
InsuranceEnrollment
- enrollment_id — BIGINT
- base_entity_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- monthly_premium — DECIMAL(10,2) — NOT NULL
- status — VARCHAR(20) — NOT NULL
InsuranceProduct
- product_id — BIGINT
- base_entity_id — BIGINT — NOT NULL
- company_id — INT — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- product_link — VARCHAR(255) — NOT NULL — 상품 상세 페이지 링크(크롤링용)
- coverage_details — TEXT — 보장 내용, 상품 특징
- monthly_premium — DECIMAL(10, 2) — NOT NULL
InsuranceRecommendation
- recommendation_id — BIGINT
- base_entity_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- recommended_date — DATETIME — NOT NULL
PaymentInfo
- payment_id — BIGINT
- base_entity_id — BIGINT — NOT NULL
- enrollment_id — BIGINT — NOT NULL
- virtual_account — VARCHAR(30) — NOT NULL
- is_auto_transfer — TINYINT(1) — NOT NULL
- transfer_date — TINYINT(2) — 매월 며칠 자동이체할지
- payment_period — INT — 납부 기간(개월)
User
- user_id — BIGINT
- base_entity_id — BIGINT — NOT NULL
- social_id — VARCHAR(255) — NOT NULL — 카카오 등 소셜 로그인 ID
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
UserHealthInfo
- health_id — BIGINT
- base_entity_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- age — INT — NOT NULL
- gender — CHAR(1) — NOT NULL — M/F
- height — DECIMAL(5, 2) — NOT NULL
- weight — DECIMAL(5, 2) — NOT NULL
- bmi — DECIMAL(5, 2) — 자동 계산 혹은 수동 입력
- is_smoker — TINYINT(1) — NOT NULL
- is_drinker — TINYINT(1) — NOT NULL
- has_chronic_disease — TINYINT(1) — NOT NULL
- chronic_disease_list — VARCHAR(255) — 기저 질환(당뇨 등)
- surgery_history — TEXT
- last_checkup_date — DATE
- blood_pressure — VARCHAR(20)
- blood_sugar — VARCHAR(20)