order
Tables (5)
order (주문 테이블)
- id (주문 ID) — bigint — Primary key — NOT NULL
- user_id (유저아이디) — bigint — Foreign key → user.id — NOT NULL
- order_time (주문시간)
order_before (장바구니)
- id (Key) — bigint — Primary key — NOT NULL
- product_id (상품 아이디) — bigint — Foreign key → product.id — NOT NULL
- user_id (유저아이디2) — bigint — Foreign key → user.id — NOT NULL
- wbuy_count (구매수량) — int — NOT NULL
order_detail (주문 상세내역)
- id (주문 상세내역아이디) — bigint — Primary key — NOT NULL
- product_id (상품 아이디) — bigint — Foreign key → product.id — NOT NULL
- order_id (주문 ID) — bigint — Foreign key → order.id — NOT NULL
- buy_count (주문 수량) — int — NOT NULL
product (상품 테이블)
- id (상품 아이디) — bigint — Primary key — NOT NULL
- user_id (유저아이디(판매자)) — bigint — Foreign key → user.id — NOT NULL
- p_name (상품이름) — varchar(255) — NOT NULL
- stock (재고) — int — NOT NULL
user (유저테이블)
- id (유저아이디) — bigint — Primary key — NOT NULL
- name (이름) — varchar(255) — NOT NULL
- role (역할군) — enum('user','seller') — NOT NULL
- ph_num (번호) — varchar(255) — NOT NULL