task#2
Tables (7)
Heart (찜)
- email — varchar(200) — Foreign key → Users.email — NOT NULL
- stuff_id — int — Foreign key → Stuff.stuff_id — NOT NULL
- created_at — date
- delete — int
Review
- review_id — int — Primary key — NOT NULL
- email — varchar(200) — Foreign key → Users.email — NOT NULL
- star — int
- comment — varchar(500)
Review (review)
- order_id — int — Foreign key → order.order_id — NOT NULL
- comment — varchar(500)
- updated_at — date
Stuff
- stuff_id — int — Primary key — NOT NULL
- stuff_name — varchar(50)
- describe — varchar(300)
- category_id — int — Foreign key → category.category_id — NOT NULL
- price — int
- quantity — int
- email — varchar(200) — Foreign key → Users.email — NOT NULL
Users
- email — varchar(200) — Primary key — NOT NULL
- name — varchar(20)
- password — varchar(50)
- address — varchar(500)
- admin — int
category
- category_id — int — Primary key — NOT NULL
- category_name — varchar(50)
order
- order_id — int — Primary key — NOT NULL
- order_quantitiy (order_quantity) — int
- stuff_id — int — Foreign key → Stuff.stuff_id — NOT NULL
- user_email — varchar(200) — Foreign key → Users.email — NOT NULL
- created_at — date