Insurance

테이블 (7)

고객 (Untitled3)

  • Client_ID (Key) — Number — 기본 키 — NOT NULL
  • CodeVerifyNumber (Key3) — VarChar2(10) — 외래 키 → 코드종류.CodeVerifyNumber — NOT NULL
  • Client_Name (Field) — Varchar(12)
  • Phone (Field2) — Varchar(30)
  • Contract_Date (Field3) — Date
  • End_Date (Field5) — Date
  • PayCount (Field7) — Number

상품 (Untitled2)

  • CodeVerifyNumber (Key2) — VarChar2(10) — 외래 키 → 코드종류.CodeVerifyNumber — NOT NULL
  • Product_Name (Field) — Varchar2(30)
  • Product_Price (Field2) — Number

운전자보험 (Untitled7)

  • CodeVerifyNumber (Key2) — VarChar2(10) — 외래 키 → 상품.CodeVerifyNumber — NOT NULL
  • DriverInsurance_ID (Field)
  • DriverInsurance_Name (Field2)

은행 (Untitled4)

  • CodeVerifyNumber (Key) — VarChar2(10) — 외래 키 → 코드종류.CodeVerifyNumber — NOT NULL
  • Bank_Code (Field) — VarChar2(10)

자동차보험 (Untitled6)

  • CodeVerifyNumber (Key22) — VarChar2(10) — 외래 키 → 상품.CodeVerifyNumber — NOT NULL
  • Car_ID (Field)
  • Car_Name (Field2)

카드사 (Untitled5)

  • CodeVerifyNumber (Key) — VarChar2(10) — 외래 키 → 코드종류.CodeVerifyNumber — NOT NULL
  • Card_Code (Field)

코드종류 (Untitled)

  • CodeVerifyNumber (Key) — VarChar2(10) — 기본 키 — NOT NULL