title
Tables (4)
item (상품)
- item_id (BIgInt) — auto_increment — Primary key — NOT NULL
- member_id (BigInt) — auto_increment — Foreign key → member.member_id — NOT NULL
- 상품명 (Field) — BigInt
- 상품재고 (Field2)
- 상품가격 (Field3)
member (회원가입)
- member_id (BigInt) — auto_increment — Primary key — NOT NULL
- role (Varchar) — enum{"user":"seller"}
order (Untitled2)
- order_id (Bigint) — auto_increment — Primary key — NOT NULL
- member_id (BigInt) — auto_increment — Foreign key → member.member_id — NOT NULL
- 주문생성일자 (Field)
orderItem (Untitled3)
- orderItemId (Bigint) — auto_increment — Primary key — NOT NULL
- item_id (BIgInt) — auto_increment — Foreign key → item.item_id — NOT NULL
- order_id (Bigint2) — auto_increment — Foreign key → order.order_id — NOT NULL
- quantity (Bigint3) — BigInt