order_system
Tables (4)
member (회원)
- id (Key) — Primary key — NOT NULL
- email (Field)
- password (Field2)
- role (Field3) — emum
- Field4
order (주문)
- order_id (Key) — Primary key — NOT NULL
- Field (주문생성 일자)
- member_id (Key2) — Foreign key → member.id — NOT NULL
order_details (주문상세)
- id (Key) — Primary key — NOT NULL
- order_id (Key2) — Foreign key → order.order_id — NOT NULL
- product_id (Key3) — Foreign key → product.id — NOT NULL
- Field (주문수량)
product (상품)
- id (Key) — Primary key — NOT NULL
- Field (상품명)
- Field (상품가격)
- Field2 (상품제고)
- member_id (Key2) — Foreign key → member.id — NOT NULL