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)