lion
Tables (3)
order (Untitled2)
- id (주문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
- date (주문일자) — int
product (Untitled3)
- id (상품id) — int — Primary key — NOT NULL
- name (상품이름) — char
- price (상품가격) — int
- stock (재고) — int
user (Untitled)
- id (회원id) — int — Primary key — NOT NULL
- name (이름) — char
- email (이메일) — char
- password (비밀번호) — int
- phone (전화번호) — int