E202

Tables (10)

Codi

  • id — INT UNSIGNED — Primary key — NOT NULL
  • name — varchar(255)
  • date — DATE

Goods

  • id — INT UNSIGNED — Primary key — NOT NULL
  • name — varchar(256)
  • imgUrl — varchar(512)
  • price — varchar(256)
  • gender — TINYINT
  • color — TINYINT

Inquiry

  • id — INT UNSIGNED — Primary key — NOT NULL
  • uid — INT UNSIGNED — Foreign key → User.id — NOT NULL
  • reqContents — varchar(512)
  • resContents — varchar(512)
  • registerDate — DATE

LikeCodi

  • id — INT UNSIGNED — Foreign key → User.id — NOT NULL
  • cid — INT UNSIGNED — Foreign key → Codi.id — NOT NULL

LikeGoods

  • id — INT UNSIGNED — Foreign key → User.id — NOT NULL
  • gid — INT UNSIGNED — Foreign key → Goods.id — NOT NULL

Review

  • id — INT UNSIGNED — Primary key — NOT NULL
  • uid — INT UNSIGNED — Foreign key → User.id — NOT NULL
  • cid — INT UNSIGNED — Foreign key → Codi.id — NOT NULL
  • comment — varchar(255)
  • class — INT
  • order — INT
  • groupNum — INT

ReviewGoods

  • id — INT — Primary key — NOT NULL

UnlikeCodi

  • id — INT UNSIGNED — Foreign key → User.id — NOT NULL
  • cid — INT UNSIGNED — Foreign key → Codi.id — NOT NULL

UnlikeGoods

  • id — INT UNSIGNED — Foreign key → User.id — NOT NULL
  • gid — INT UNSIGNED — Foreign key → Goods.id — NOT NULL

User

  • id — INT UNSIGNED — Primary key — NOT NULL
  • nickName — varchar(10)
  • email — varchar(512)
  • password — varchar(128)
  • imgUrl — varchar(512)
  • height — TINYINT
  • weight — TINYINT
  • gender — TINYINT
  • birthDate — DATE
  • registerDate — DATE
  • role — varchar(10)