GH X FRIP 1118
Tables (7)
Interactions (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- Timestamp (Field) — TIMESTAMP
- event (Field2) — INT
- userId (Key2) — INT — Foreign key → User.userId — NOT NULL
- productId (Key3) — INT — Foreign key → Product.productId — NOT NULL
Product (Untitled2)
- productId (Key) — Primary key — NOT NULL
- updatedAt (Field) — INT
- version (Field2) — INT
- hostId (Field3)
- retailPrice (Field4) — DECIMAL
- salePrice (Field5) — DECIMAL
- salesStartedAt (Field6) — TIMESTAMP
- saleEndedAt (Field7) — TIMESTAMP
- productStatus (Field8) — TINYINT
- attributesId (Field9) — INT
- recommendedAge (Field10) — INT
- fripKinds (Field11)
- attachedToScheduleFlags (Field12) — BOOLEAN
- latitudes (Field13) — DOUBLE
- longitudes (Field14) — DOUBLE
- address (Field15) — VARCHAR
- tagIds (Field16) — INT
- keyword (Field17) — VARCHAR
- region (Field18) — VARCHAR
- saleRatio (Field19) — DECIMAL
- country (Field20) — VARCHAR
- kind (Field21)
- standardCategoryid (Field22) — INT
- overseasFlag (Field23) — BIT
Search
- id — NT — Primary key — NOT NULL
- Timestamp — TIMESTAMP
- searchWord — VARCHAR
- userId (Key) — 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 — INT
User
- userId (Key) — INT — Primary key — NOT NULL
- gender (Field) — TINYINT
- birth (Field2) — TIMESTAMP
- updatedAt (Field3) — TIMESTAMP
UserTag
- id — INT — Primary key — NOT NULL
- tagId — INT
- status — TINYINT
- statusStart (StatusEnd) — TIMESTAMP
- statusEnd (Field) — TIMESTAMP
- userId (Key) — INT — Foreign key → User.userId — NOT NULL
jaccard similarity (Untitled3)
- id (Key) — INT — Primary key — NOT NULL
- simmilarity (Field) — DOUBLE
- productId_1 (Key2) — INT — Foreign key → Product.productId — NOT NULL
- productId_2 (Key3) — INT — Foreign key → Product.productId — NOT NULL