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