MiniShoppingMall
Tables (3)
Orders (주문)
- id (주문번호) — int — Primary key — NOT NULL
- user_id (사용자id) — int — Foreign key → User.id — NOT NULL
- product_id (상품id) — int — Foreign key → Product.id — NOT NULL
- quantity (수량) — int
- total_price (총금액) — int
- created_at (주문일) — datetime
Product (상품)
- id (상품id) — int — Primary key — NOT NULL
- name (상품이름) — varchar(20)
- price (상품가격) — int
- stock (재고) — int
- created_at (생성일) — datetime
User (사용자)
- id (사용자id) — int — Primary key — NOT NULL
- email (사용자이메일) — varchar(50)
- name (사용자이름) — varchar(5)
- created_at (생성일) — datetime