order
Tables (6)
member (회원)
- 회원ID (id) — BIGINT — Primary key — NOT NULL
- 이름 (name)
- 이메일 (email) — VARCHAR(100) — NOT NULL
- 패스워드 (password) — VARCHAR(100) — NOT NULL
- 역할 (role) — enum('user','seller') — NOT NULL
order_details (주문상세)
- 주문상세ID (id) — BIGINT — Primary key — NOT NULL
- 주문ID (orders_id) — BIGINT — Foreign key → orders.주문ID — NOT NULL
- 상품ID (product_id) — BIGINT — Foreign key → product.상품ID — NOT NULL
- 주문수량 (order_num) — BIGINT — NOT NULL
orders (주문)
- 주문ID (id) — BIGINT — Primary key — NOT NULL
- 회원ID (memeber_id) — BIGINT — Foreign key → member.회원ID — NOT NULL
- 주문생성일자 (order_date) — VARCHAR(100)
product (상품)
- 상품ID (id) — BIGINT — Primary key — NOT NULL
- 회원ID (member_id) — BIGINT — Foreign key → member.회원ID — NOT NULL
- 상품명 (product_name) — VARCHAR(100)
- 상품가격 (product_price) — BIGINT
- 상품재고 (product_save) — BIGINT
seller (판매자)
- Key — Primary key — NOT NULL
- 회원ID (id) — BIGINT — Foreign key → member.회원ID — NOT NULL
- Field
user (사용자)
- Key — Primary key — NOT NULL
- 회원ID (id) — BIGINT — Foreign key → member.회원ID — NOT NULL
- Field