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