contract
Tables (4)
contract (계약)
- id (Key) — Primary key — NOT NULL
- startDate (Field)
- endDate (Field2)
- totalPremium (Field3)
- status (Field4)
- createdAt (Field5)
- updateAt (Field6)
- product_id (Key2) — Foreign key → product.id — NOT NULL
contract_warranty (Untitled)
- id (Key2) — Primary key — NOT NULL
- contract_id (Key) — Foreign key → contract.id — NOT NULL
- warranty_id (Key3) — Foreign key → warranty.id — NOT NULL
product (상품)
- id (Key) — Primary key — NOT NULL
- name (Field)
- contractPeriod (Field2)
warranty (담보)
- id (Key) — Primary key — NOT NULL
- product_id (Key2) — Foreign key → product.id — NOT NULL
- name (Field)
- subscribeAmount (Field2)
- standardAmount (Field3)