Commerce Payments System
Tables (7)
CartItems (CopyOfCopyOfUntitled)
- PK (Key) — bigint — Primary key — NOT NULL
- (Key2) — Foreign key → Carts.PK — NOT NULL
- FK (Key22) — bigint — Foreign key → Carts.FK, UK — NOT NULL
- FK (Key3) — bigint — Foreign key → Products.PK — NOT NULL
- Field — int
- Field2 — datetime
- Field3 — datetime
Carts (CopyOfUntitled)
- PK (Key) — bigint — Primary key — NOT NULL
- FK, UK (Key2) — bigint — Foreign key → Members.PK — NOT NULL
- Field2 — datetime
- Field3 — datetime
Members (Untitled)
- PK (Key) — bigint — Primary key — NOT NULL
- UK (Field) — varchar(255)
- Field2 — varchar(255)
- Field3 — varchar(100)
- Field4 — varchar(20)
- Field5 — datetime
- Field6 — datetime
OrderItems (CopyOfCopyOfProduct)
- PK (Key) — bigint — Primary key — NOT NULL
- FK (Key2) — bigint — Foreign key → Orders.PK — NOT NULL
- (Key3) — Foreign key → Products.PK — NOT NULL
- PK (Key32) — bigint — Foreign key → Orders.FK — NOT NULL
- Field — int
- Field2 — int
- Field3 — datetime
- Field4 — datetime
- Field5 — varchar(200)
Orders (CopyOfProduct)
- PK (Key) — bigint — Primary key — NOT NULL
- FK (Key3) — bigint — Foreign key → Members.PK — NOT NULL
- UK (Field5) — varchar(20)
- Field — int
- Field2 — enum
- Field3 — datetime
- Field4 — datetime
Payments (Untitled2)
- PK (Key) — bigint — Primary key — NOT NULL
- FK, UK (Key2) — bigint — Foreign key → Orders.PK — NOT NULL
- (Key3) — Foreign key → Orders.FK — NOT NULL
- Field — int
- Field2 — enum
- Field3 — datetime
- Field4 — datetime
- Field5 — datetime
Products (Product)
- PK (Key) — bigint — Primary key — NOT NULL
- Field — varchar(200)
- Field2 — varchar(100)
- Field3 — int
- Field4 — int
- Field5 — text
- Field7 — datetime
- Field8 — datetime