shop
Tables (7)
Cart (cart)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (id2) — bigint — Foreign key → Untitled2.Key — NOT NULL
CartItem (cart_item)
- Key (id) — bigint — Primary key — NOT NULL
- Key (id2) — bigint(20) — Foreign key → Cart.Key — NOT NULL
- Key (id3) — bigint — Foreign key → Copy Of Untitled26.Key — NOT NULL
Copy Of Untitled2 (order)
- Key (id) — bigint — Primary key — NOT NULL
- Field (order_date) — datetime
- Field (order_status) — enum
Copy Of Untitled24 (item_img)
- Key (id) — bigint — Primary key — NOT NULL
- Field (original_img_name) — varchar(255)
- Field (imgName) — varchar(255)
- Field (img_url) — varchar(255)
- Field (rep_img_yn) — varchar(5)
- Key (item_id) — bigint — Foreign key → Copy Of Untitled26.Key — NOT NULL
Copy Of Untitled25 (order_item)
- Key (item_id) — bigint — Foreign key → Copy Of Untitled26.Key — NOT NULL
- Key (order_id) — bigint — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Field (order_price) — int
- Field (count) — int
Copy Of Untitled26 (item)
- Key (id) — bigint — Primary key — NOT NULL
- Field (item_named) — varchar
- Field (price) — int
- Field (stock_number) — int
- Field (item_detail) — blob
Untitled2 (member)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(50)
- Field (email) — vahchar(255)
- Field (password) — varchar(255)
- Field (role) — enum