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