items

Tables (6)

coupon (Untitled2)

  • id (Key2) — int — Foreign key → item.id — NOT NULL
  • name (Field) — string
  • discountRate (Field2) — double
  • expirationDate (Field3) — time

delivery (-)

  • id (Key) — int — Foreign key → item.id — NOT NULL
  • cost (Field) — int

freegift (Untitled3)

  • id (Key) — int — Foreign key → item.id — NOT NULL
  • name (Field) — string

item (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — string
  • description (Field2) — string
  • cost (Field4) — int

purchaseCount (CopyOfUntitled3)

  • id (Key) — int — Foreign key → item.id — NOT NULL
  • count (Field) — int

seller (CopyOfCopyOfUntitled3)

  • id (Key) — int — Foreign key → item.id — NOT NULL
  • name (Field) — string