test
Tables (4)
order (주문)
- order_id (Key) — bigint — Primary key — NOT NULL
- user_id (id) — bigint — Foreign key → user.user_id — NOT NULL
- date (Field) — datetime — NOT NULL
order_product (주문 관리)
- order_product_id (Key) — int — Primary key — NOT NULL
- product_id (Key2) — bigint — Foreign key → product.product_id — NOT NULL
- order_id (Key3) — int — Foreign key → order.order_id — NOT NULL
- quantity (Field) — bigint — NOT NULL
product (상품)
- product_id (Key) — bigint — Primary key — NOT NULL
- user_id (id) — bigint — Foreign key → user.user_id — NOT NULL
- product_name (Field) — varchar(255) — NOT NULL
- price (Field2) — bigint — NOT NULL
user (회원)
- user_id (id) — bigint — Primary key — NOT NULL
- user_name (name) — varcher(255) — NOT NULL
- user_email (email) — varchar(255)
- password (비밀 번호) — varchar(255) — NOT NULL
- type (판매자 회원 구분) — varchar(10) — NOT NULL