GH X FRIP | ERD
Tables (9)
Category
- id — INT — Primary key — NOT NULL
- standardCategoryId — INT
- standard_depth0 — INT
- standard_depth1 — INT
- standard_depth2 — INT
- standard_depth3 — INT
- standard_depth4 — INT
- display_depth0 — INT
- display_depth1 (dispaly_depth1) — INT
- display_depth2 — INT
- section_depth0 — INT
- section_depth1 — INT
- section_depth2 — INT
- status — TINYINT
- activeStart — TIMESTAMP
- activeEnd — TIMESTAMP
CategoryMap
- id — INT — Primary key — NOT NULL
- category_depth{i} — INT
- category_depth{i}_code — VARCHAR
- updatedAt — TIMESTAMP
Interactions
- id — INT — Primary key — NOT NULL
- Timestamp — TIMESTAMP
- event — INT
- userId (userId2) — INT — Foreign key → User.userId — NOT NULL
- productId (productId2) — INT — Foreign key → Product.productId — NOT NULL
Product
- productId — INT — Primary key — NOT NULL
- updatedAt — INT
- version — INT
- hostId — INT
- retailPrice — DECIMAL
- salePrice — DECIMAL
- salesStartedAt — TIMESTAMP
- saleEndedAt — TIMESTAMP
- productStatusp (productStatus) — TINYINT
- attributetsId (attributesId) — INT
- recommendedAge — INT
- fripKinds — INT
- attachedToScheduleFlags — BOOLEAN
- latitudes — DOUBLE
- longitudes — DOUBLE
- address — VARCHAR
- tagIds — INT
- keyword — VARCHAR
- region — VARCHAR
- saleRatio — DECIMAL
- country — VARCHAR
- tokenized_title1 — DOUBLE
- tokenized_title2 — DOUBLE
- tokenized_title3 (tobkenized_title3) — DOUBLE
- tokenized_title4 (toeknized_title4) — DOUBLE
- tokenized_title5 — DOUBLE
- tokenized_title6 (toeknized_title6) — DOUBLE
- tokenized_title7 — DOUBLE
- tokenized_title8 — DOUBLE
- tokenized_title9 — DOUBLE
- overseasFlag — BIT
- kind — VARCHAR
- categoryId (id) — INT — Foreign key → Category.id — NOT NULL
Search
- id — INT — Primary key — NOT NULL
- Timestamp — TIMESTAMP
- searchWord — VARCHAR
- userId (userId2) — INT — Foreign key → User.userId — NOT NULL
TagTemplate
- id — INT — Primary key — NOT NULL
- tagId — INT
- tagName — VARCHAR
- status — TINYINT
- statusStart — TIMESTAMP
- statusEnd — TIMESTAMP
- parentId (id2) — INT — Foreign key → TagTemplate.id — NOT NULL
User
- userId — INT — Primary key — NOT NULL
- gender — TINYINT
- birth — TIMESTAMP
- updatedAt — TIMESTAMP
UserTag
- id — INT — Primary key — NOT NULL
- tagId — INT
- status — TINYINT
- statusStart — TIMESTAMP
- statusEnd — TIMESTAMP
- userId — INT — Foreign key → User.userId — NOT NULL
- tagTemplateId (id2) — INT — Foreign key → TagTemplate.id — NOT NULL
jaccard similarity (Untitled)
- id (Key) — id — Primary key — NOT NULL
- similarity (Field) — DOUBLE
- productId — INT — Foreign key → Product.productId — NOT NULL
- productId (productId2) — INT — Foreign key → Product.productId — NOT NULL