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