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