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