Shop
Tables (5)
Delivery (Untitled7)
- 주문id (id) — bigint — Foreign key → Orders.주문id — NOT NULL
Item (Untitled)
- 상품id (id) — bigint — Primary key — NOT NULL
- 이름 (name) — varchar
- 가격 (price) — Integer
- 상품설명 (feature) — varchar(500)
- 멤버id (id2) — bigint — Foreign key → Member.멤버id — NOT NULL
Member (Untitled2)
- 멤버id (id) — bigint — Primary key — NOT NULL
- Field
Order_Item (Untitled4)
- 주문id (id) — bigint — Foreign key → Orders.주문id — NOT NULL
- 상품id (id2) — bigint — Foreign key → Item.상품id — NOT NULL
Orders (Untitled3)
- 주문id (id) — bigint — Primary key — NOT NULL
- 멤버id (id2) — bigint — Foreign key → Member.멤버id — NOT NULL