GH 1103

Tables (10)

Category

  • id (Key) — INT — Primary key — NOT NULL
  • standard_depth0_id — INT
  • standard_depth1_id — INT
  • standard_depth2_id — INT
  • standard_depth3_id — INT
  • standard_depth4_id — INT
  • display_depth0_id — INT
  • display_depth1_id — INT
  • display_depth2_id — INT
  • activeStart — TIMESTAMP
  • activeEnd — TIMESTAMP
  • status — TINYINT
  • standardCategoryId (Field) — INT
  • section_depth0 (Field2) — INT
  • section_depth1 (Field3) — INT
  • section_depth2 (Field4) — INT

Category Lookup Table (Standard Category depth0 Lookup Table)

  • cosine_similarity — DOUBLE
  • category_depth_Id2 (standardCategoryId2) — INT — Foreign key — NOT NULL
  • category_dpeth_Id1 (Key) — INT — Foreign key → Category.id — NOT NULL

CategoryMap

  • id (Key) — INT — Primary key — NOT NULL
  • category_depth{i}_code (display_depth2_code) — INT
  • category_depth{i} (Key2) — INT — Foreign key → Category.id — NOT NULL

Interactions

  • Timestamp — TIMESTAMP
  • event — VARCHAR(128)
  • sessionId — BIGNT(20) — Foreign key → Sessions.sessionId — NOT NULL
  • productId — BIGNT(20) — Foreign key → Product.productId — NOT NULL
  • UserId (userId) — INT(11) — Foreign key → User.UserId — NOT NULL
  • Key — Foreign key — NOT NULL

Product

  • productId — BIGNT(20) — Primary key — NOT NULL
  • updatedAt — TIMESTAMP
  • version — BIGNT(20)
  • hostId — BIGNT(20)
  • retailPrice — DECIMAL(19 2)
  • salePrice — DECIMAL(19, 2)
  • saleStartedAt — TIMESTAMP
  • saleEndedAt — TIMESTAMP
  • productStatus — INT
  • attributeIds — BIGNT(20)
  • recommendedAge — INT
  • fripKinds
  • attachedToScheduleFlags — BIT(1)
  • latitudes — DOUBLE
  • longitudes — DOUBLE
  • address — VARCHAR(256)
  • tagIds — INT(11)
  • keyword — VARCHAR(256)
  • region — VARCHAR(256)
  • saleRatio — DOUBLE
  • country — VARCHAR(256)
  • tokenized_title1 — FLOAT
  • tokenized_title2 — FLOAT
  • tokenized_title3 — FLOAT
  • tokenized_title4 — FLOAT
  • tokenized_title5 — FLOAT
  • tokenized_title6 — FLOAT
  • tokenized_title7 — FLOAT
  • tokenized_title8 — FLOAT
  • tokenized_title9 — FLOAT

Search

  • Timestamp — TIMESTAMP
  • searchword — VARCHAR(256)
  • UserId (userId) — INT(11) — Foreign key → User.UserId — NOT NULL

Sessions

  • sessionId — BIGNT(20) — Primary key — NOT NULL
  • sessionStart — TIMESTAMP
  • sessionEnd — TIMESTAMP

TagTemplate

  • id (Key) — int — Primary key — NOT NULL
  • tagName — VARCHAR
  • parentId — INT
  • tagId (Field) — INT
  • status (Field2) — TINYINT
  • statusStart (Field3) — timestamp
  • statusEnd (Field4) — timestamp

User

  • UserId (userId) — INT — Primary key — NOT NULL
  • gender — TINYINT
  • birth — timestamp

UserTag

  • id (Key) — int — Primary key — NOT NULL
  • status — TINYINT
  • statusStart — TIMESTAMP
  • statusEnd — TIMESTAMP
  • UserId (userId) — INT(11) — Foreign key → User.UserId — NOT NULL
  • tagId (Key2) — int — Foreign key → TagTemplate.id — NOT NULL