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)