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