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)