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