insurance

Tables (5)

Client (고객)

  • Client_Num (Key) — Number — Primary key — NOT NULL
  • Client_Name (Field) — VarChar(15)
  • Client_Phone (Field2) — VarChar(30)

Code (코드)

  • Code_Category_Num (Key) — Number — Primary key — NOT NULL
  • Product_Num (Key2) — Number — Foreign key → Product.Product_Num — NOT NULL
  • Code_Category (Field) — VarChar(50)
  • Code_Num (Field3) — Number
  • Code_Name (Field2) — VarChar(50)

Contract (계약)

  • Contract_Num (Key) — Number — Foreign key → Client.Client_Num — NOT NULL
  • Insurance_Num (Key1) — Number — Foreign key → Insurance.Insurance_Num — NOT NULL
  • Product_Num (Key2) — Number — Foreign key → Product.Product_Num — NOT NULL

Insurance (보험관리)

  • Insurance_Num (Key) — Number — Primary key — NOT NULL
  • Insurance_Date (Field) — Date
  • Insurance_StartDate (Field2) — Date
  • Insurance_EndDate (Field3) — Date
  • Insurance_Month (Field4) — Number
  • Insurance_Total (Field5) — Number

Product (상품)

  • Product_Num (Key) — Number — Primary key — NOT NULL
  • Product_Name (Field) — VarChar(50)
  • Product_Price (Field2) — Number