board

Tables (4)

order_detail (주문상세내역)

  • id (주문상세id) — bigint — Primary key — NOT NULL
  • order_id (주문id) — bigint — Foreign key → order_list.id — NOT NULL
  • product_id (상품id) — bigint — Foreign key → product.id — NOT NULL
  • product_quantity (상품별수량) — bigint — NOT NULL
  • product_price (상품별가격) — bigint — NOT NULL

order_list (주문내역)

  • id (주문id) — bigint — Primary key — NOT NULL
  • buyer_id (구매자id) — bigint — Foreign key → user.id — NOT NULL
  • total_quantity (총수량) — bigint — NOT NULL
  • order_price (총금액) — bigint — NOT NULL

product (상품)

  • id (상품id) — bigint — Primary key — NOT NULL
  • seller_id (판매자id) — bigint — Foreign key → user.id — NOT NULL
  • name (상품이름) — varchar(255) — NOT NULL
  • price (가격) — bigint — NOT NULL
  • stock (재고) — bigint — NOT NULL

user (회원정보)

  • id (회원id) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(255) — NOT NULL
  • email (이메일) — varchar(255) — NOT NULL
  • password (비밀번호) — varchar(255) — NOT NULL
  • address (주소) — varchar(255) — NOT NULL
  • role (Field5) — enum — NOT NULL