test
Tables (4)
order (주문)
- id (order_id) — bigint — Primary key — NOT NULL
- 유저아이디 (user_id) — bigint — Foreign key → user.id — NOT NULL
order-product (상품-주문)
- id (order_product_id) — bigint — Primary key — NOT NULL
- 상품아이디 (product_id) — bigint — Foreign key → product.id — NOT NULL
- 주문아이디 (order_id) — bigint — Foreign key → order.id — NOT NULL
- 주문일 (order_date) — datetime
product (상품)
- id (product_id) — bigint — Primary key — NOT NULL
- 상품이름 (name) — varchar
- 가격 (price) — integer
user (유저)
- id (user_id) — bigint — Primary key — NOT NULL
- 이름 (name) — varchar
- 주소 (address) — varchar
- 생년월일 (birth) — varchar