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