SaaS

Tables (11)

ALGORITHM_VIEW (Untitled2)

  • browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
  • product_id (Key2) — string — Foreign key → products.product_id — NOT NULL — FK

MEMBERS_CART (Untitled3)

  • browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
  • product_id (Key2) — string — Foreign key → products.product_id — NOT NULL — FK

MEMBERS_LIKE (Untitled4)

  • browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
  • product_id (Key2) — string — Foreign key → products.product_id — NOT NULL — FK

ORDERS (Untitled)

  • orderNo (Key2) — string — Primary key — NOT NULL — PK
  • browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK

ORDER_CHANNEL (Untitled5)

  • browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
  • member_id (Field) — string
  • channel (Field2) — string — NOT NULL

browser

  • browserKey — uuid — Foreign key → main.browserKey — NOT NULL — PK, FK
  • userId (Field) — Array — NOT NULL

category (Untitled8)

  • category_id (Key) — string — Primary key — NOT NULL — PK

main

  • browserKey — uuid — Primary key — NOT NULL — PK
  • key (Field) — uuid — NOT NULL — PK

order (Untitled6)

  • orderNo (Key2) — string — Foreign key → ORDERS.orderNo — NOT NULL — FK
  • product_id (Key) — string — Foreign key → products.product_id — NOT NULL — FK
  • orderChannel (Field) — string — NOT NULL

products (Untitled7)

  • product_id (Key) — string — Primary key — NOT NULL — PK
  • category_id (Key2) — string — Foreign key → category.category_id — FK

sub

  • browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
  • goodsCode (Key2) — string — Foreign key → products.product_id — NOT NULL — FK