SaaS_all
Tables (12)
ALGORITHM_VIEW (Untitled2)
- browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
- product_id (Key2) — string — Foreign key → products.product_id — NOT NULL — FK
- algorithm (Field) — string — NOT NULL
- member_id (Field2) — string
- created_at (Field3) — Date — NOT NULL
MEMBERS_CART (Untitled3)
- browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
- product_id (Key2) — string — Foreign key → products.product_id — NOT NULL — FK
- member_id (Field) — string
- isReco (Field2) — Boolean — NOT NULL
- created_at (Field3) — Date — NOT NULL
MEMBERS_LIKE (Untitled4)
- browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
- product_id (Key2) — string — Foreign key → products.product_id — NOT NULL — FK
- member_id (Field) — string
- isReco (Field2) — Boolean — NOT NULL
- created_at (Field3) — Date — NOT NULL
MEMBERS_SHARE (CopyOfUntitled4)
- browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
- product_id (Key2) — string — Foreign key → products.product_id — NOT NULL — FK
- member_id (Field) — string
- isReco (Field2) — Boolean — NOT NULL
- created_at (Field3) — Date — NOT NULL
ORDERS (Untitled)
- orderNo (Key2) — string — Primary key — NOT NULL — PK
- browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
- member_ids (Field) — string
- isDirect (Field2) — Boolean — NOT NULL
- created_at (Field3) — Date — NOT NULL
ORDER_CHANNEL (Untitled5)
- browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
- member_id (Field) — string
- product_id (Field3) — string — NOT NULL
- channel (Field2) — string — NOT NULL
- isReco (Field4) — Boolean — NOT NULL
- created_at (Field5) — Date — 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
- name (Field) — string — NOT NULL
- category_display (Field2) — int — NOT NULL
- category_display_mobile (Field3) — int — NOT NULL
main
- browserKey — uuid — Primary key — NOT NULL — PK
- key (Field) — string — NOT NULL — PK
- userId (Field2) — string
- date (Field3) — Date — NOT NULL
- title (Field4) — string
- pageName (Field5) — string — NOT NULL
- browser (Field6) — string — NOT NULL
- screenSize (Field7) — string — NOT NULL
- geolocation (Field8) — string
- device (Field9) — string — NOT NULL
- os (Field10) — string — NOT NULL
- funnel (Field11) — string — NOT NULL
- day (Field12) — string — NOT NULL
- userAgent (Field13) — string — NOT NULL
- appName (Field14) — string — NOT NULL
- referrer (Field15) — string
- urlSearch (Field16) — string
order (Untitled6)
- orderNo (Key2) — string — Foreign key → ORDERS.orderNo — NOT NULL — FK
- goodsNo (Key) — string — Foreign key → products.product_id — NOT NULL — FK
- memId (Field2) — string
- orderId_sno (Field4) — uuid — NOT NULL — UQ
- orderStatus (Field5) — string — NOT NULL
- orderChannel (Field) — string — NOT NULL
- goodsNm (Field6) — string — NOT NULL
- goodsPrice (Field7) — int — NOT NULL
- goodsCnt (Field8) — int — NOT NULL
- totalGoodsPrice (Field9) — int — NOT NULL
- isRefund (Field10) — string
- orderDate (Field3) — Date — NOT NULL
- optionValue (Field11) — Array — NOT NULL
- sumOptionPrice (Field12) — Array — NOT NULL
- optionGoodsCnt (Field13) — Array — NOT NULL
- payment (Field14) — string — NOT NULL
products (Untitled7)
- product_id (Key) — string — Primary key — NOT NULL — PK
- name (Field) — string — NOT NULL
- description (Field2) — string
- sold_out (Field3) — int — NOT NULL
- total_stock (Field4) — int — NOT NULL
- photo_url (Field5) — string — NOT NULL
- price (Field6) — int — NOT NULL
- discount_price (Field7) — int — NOT NULL
- category_id (Key2) — string — Foreign key → category.category_id — FK
- category_all_id (Field8) — string
- goods_display (Field9) — int — NOT NULL
- goods_display_mobile (Field10) — int — NOT NULL
- goods_sell (Field11) — int — NOT NULL
- goods_sell_mobile (Field12) — int — NOT NULL
sub
- browserKey — uuid — Foreign key → main.browserKey — NOT NULL — FK
- goodsCode (Key2) — string — Foreign key → products.product_id — NOT NULL — FK
- key (Field) — string — NOT NULL
- userId (Field2) — string
- date (Field3) — Date — NOT NULL
- title (Field4) — string
- pageName (Field5) — string — NOT NULL
- scrollDepth (Field6) — int — NOT NULL
- stayTime (Field7) — int — NOT NULL
- clickTextCount (Field8) — Object
- dragTextName (Field9) — Array
- clickTagCount (Field14) — Object
- search (Field18) — string
- searchText (Field10) — string
- revisit (Field11) — string
- recommendGoods (Field12) — string
- nextPageName (Field13) — string — NOT NULL
- cart (Field15) — string
- pageMovingNumber (Field16) — int — NOT NULL
- day (Field17) — string — NOT NULL