online-shopping
Tables (4)
member (members)
- member_id (Key) — int — Primary key — NOT NULL
- email (이메일) — Varchar
- name (이름) — Varchar
- created_at (가입 일시) — Datetime
order (orders)
- order_id — int — Primary key — NOT NULL
- member_id — int — Primary key — NOT NULL
- order_date — Datetime
- total_amount — int
- member_id (Key) — int — Foreign key → member.member_id — NOT NULL
order_item
- order_id — int — Foreign key → order.order_id — NOT NULL
- member_id — int — Foreign key → order.member_id — NOT NULL
- quantity (수량) — int
- price (단가) — int
- product_id — int — Foreign key → product.product_id — NOT NULL
product (products)
- product_id — int — Primary key — NOT NULL
- name (상품명) — char
- price (가격) — int
- stock (재고 수량) — int