hi

Tables (11)

Category

  • standardCategoryId — 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
  • section_id — INT(11)
  • activeStart — TIMESTAMP
  • activeEnd — TIMESTAMP
  • status — TINYINT(4)

CategoryMap

  • display_depth2_code — VARCHAR(256)
  • standardCategoryId — VARCHAR(100) — NOT NULL

Interactions

  • Timestamp — TIMESTAMP
  • event — VARCHAR(128)
  • sessionId — BIGNT(20) — NOT NULL
  • productId — BIGNT(20) — NOT NULL
  • userId — INT(11) — 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 — VARCHAR(255)
  • 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
  • standardCategoryId — VARCHAR(100) — NOT NULL

Search

  • Timestamp — TIMESTAMP
  • searchword — VARCHAR(256)
  • userId — INT(11) — NOT NULL

Sessions

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

Standard

  • cosine_similarity — DOUBLE
  • standardCategoryId — VARCHAR(100) — NOT NULL
  • standardCategoryId2 — VARCHAR(100) — NOT NULL

Tag

  • cosine_similarity — DOUBLE
  • tagId1 — INT(11) — NOT NULL
  • tagId2 — INT(11) — NOT NULL

TagTemplate

  • tagId — INT(11) — Primary key — NOT NULL
  • tagName — VARCHAR(128)
  • parentId — INT(11)

User

  • userId — INT(11) — Primary key — NOT NULL
  • gender — TINYINT(4)
  • birth — VARCHAR(10)

UserTag

  • status — TINYINT(4)
  • statusStart — TIMESTAMP
  • statusEnd — TIMESTAMP
  • userId — INT(11) — NOT NULL
  • tagId — INT(11) — NOT NULL