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