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