portone

Tables (3)

Orders (주문 내역)

  • order_id (주문 id) — int — Primary key — NOT NULL
  • user_id (유저 id) — int — Foreign key → Users.user_id — NOT NULL
  • product_id (상품 id) — int — Foreign key → Products.product_id — NOT NULL
  • paymentId (포트원 주문 내역 id) — varchar
  • status (주문 상태) — enum

Products (상품)

  • product_id (상품 id) — int — Primary key — NOT NULL
  • name (상품 이름) — varchar
  • price (가격) — int

Users (유저)

  • user_id (유저 id) — int — Primary key — NOT NULL
  • email (이메일) — varchar
  • password (비밀번호) — varchar
  • Field