Kream1
Tables (4)
Order (상품 주문)
- order_id (PK) — LONG — Primary key — NOT NULL
- product_id (PK3) — LONG — Foreign key → Products.product_id — NOT NULL
- 입찰 제시 가격 (Field)
- 구매가 (Field2)
Ordered (주문 내역)
- ordered_id (PK) — LONG — Primary key — NOT NULL
- user_id (PK2) — LONG — Foreign key → User.user_id — NOT NULL
- order_id (PK3) — LONG — Foreign key → Order.order_id — NOT NULL
- Field
Products (상품)
- product_id (PK) — LONG — Primary key — NOT NULL
- Field
User (사용자)
- user_id (PK) — LONG — Primary key — NOT NULL
- username (사용자 이름) — varchar
- email (이메일 주소) — varchar
- password (비밀번호) — varchar
- role (관리자/사용자) — ENUM("관리자", "사용자")