Insurance

Tables (3)

Contract (계약)

  • Key — Primary key — NOT NULL
  • code (납입기간코드) — VARCHAR2(20) — Foreign key → PAYMENT_PERIOD_TYPE.code — NOT NULL
  • code (납입주기코드) — VARCHAR2(20) — Foreign key → payment_cycle.code — NOT NULL
  • Field (보험사고)
  • Field (보험기간)
  • Field (보험금액) — NUMBER(10,0)
  • Field (보험료) — NUMBER(10,0)

PAYMENT_PERIOD_TYPE (보험료 납입 기간)

  • code (납입기간코드) — VARCHAR2(20) — Primary key — NOT NULL
  • name (납입기간) — VARCHAR2(50)

payment_cycle (보험료 납입 주기)

  • code (납입주기코드) — VARCHAR2(20) — Primary key — NOT NULL
  • name (납입주기) — VARCHAR2(50)