order
Tables (4)
Order (Untitled2)
- order_id (주문 pk) — PK — Primary key — NOT NULL
- user_id (사용자 pk) — PK — Foreign key → User.user_id — NOT NULL
- order_date (주문 날짜)
- status (처리 상태)
- total_price (전체 가격)
OrderDetail (Untitled4)
- detail_id (주문상세pk) — Primary key — NOT NULL
- product_id (상품 번호 pk) — PK — Foreign key → Product.product_id — NOT NULL
- order_id (주문 pk) — PK — Foreign key → Order.order_id — NOT NULL
- unit_price (수량 * 상품가격)
- quantity (수량)
Product (Untitled3)
- product_id (상품 번호 pk) — PK — Primary key — NOT NULL
- name (상품 이름)
- price (가격)
- info (상품 정보)
- stock (재고)
- created_at (생성시간)
- updated_at (수정시간)
User (Untitled)
- user_id (사용자 pk) — PK — Primary key — NOT NULL
- username (사용자 이름)
- phonenumber (전화번호)
- email (이메일)
- nickname (닉네임)
- role (역할)