AB TEST DB 1122_initial

Tables (7)

categoryLabel (CategoryLabel)

  • id — INT — Primary key — NOT NULL
  • code — VARCHAR
  • name — VARCHAR

click (Click)

  • insert_id (id) — VARCHAR — Primary key — NOT NULL
  • productId — INT
  • userId — INT
  • ts — TIMESTAMP

displayCategory (DisplayCategory)

  • id — INT — Primary key — NOT NULL
  • categoryLabelId — INT
  • categoryLabelCode — VARCHAR

product

  • productId — INT — Primary key — NOT NULL
  • overseasFlags — INT
  • title — VARCHAR
  • kind — VARCHAR
  • fripKinds — VARCHAR
  • region — VARCHAR
  • content — VARCHAR
  • productStatus — INT
  • standardCategoryids — INT
  • attributeIds (attributesIds) — INT

standardCategory (StandardCategory)

  • id — INT — Primary key — NOT NULL
  • idPath — VARCHAR
  • codePath — VARCHAR

tagTemplate (Tagtemplate)

  • id (tagId) — INT — Primary key — NOT NULL
  • name (tagName) — VARCHAR
  • displayCategoryId — INT

userTag (UserTag)

  • id — NT — Primary key — NOT NULL
  • userId — INT
  • tagTemplateId (tagId) — INT