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