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("관리자", "사용자")