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