shopping

Tables (6)

cart

  • cart_id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • product_id — int — NOT NULL

category

  • category_id — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL

order

  • order_id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20)
  • created_at — datetime(6) — NOT NULL
  • delivery_request — varchar(100)
  • recipient_name — varchar(20) — NOT NULL
  • recipient_tel — varchar(20) — NOT NULL
  • delivery_address — json — NOT NULL
  • delivery_detail_address — varchar(50)
  • delivery_fee — int — NOT NULL
  • total_price — int — NOT NULL
  • order_status — enum — NOT NULL

order_detail

  • order_detail_id — INT — Primary key — NOT NULL
  • order_id — INT — NOT NULL
  • product_id — int — NOT NULL
  • count — int — NOT NULL
  • price — int — NOT NULL

product

  • product_id — int — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • price — int — NOT NULL
  • description — varchar(255) — NOT NULL
  • detail (deatil) — text

user

  • id — INT — Primary key
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • is_admin — boolean — NOT NULL
  • is_seller — boolean — NOT NULL
  • address — varchar(255)
  • phone — varchar(15) — NOT NULL