DRF
Tables (10)
Brnad (Untitled10)
- Key (brand_idx) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR
Cart (Untitled9)
- Key (cart_idx) — INT — Primary key — NOT NULL
- Key (user_idx) — VARCHAR — Foreign key → User.Key — NOT NULL — CASCADE ON DELETE
- Key (option_idx) — INT — Foreign key → Product_Option.Key — NOT NULL — CASCADE ON DELETE
- Field (quantity) — INT — quantity >=1
Category (Untitled3)
- Key (category_idx) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR
Order (Untitled7)
- Key (order_idx) — INT — Primary key — NOT NULL
- Key (user_idx) — VARCHAR — Foreign key → User.Key — NOT NULL
- Key (order_item_idx) — INT — Foreign key → Order_Item.Key — NOT NULL
- Field (price) — INT — price>=0
- Field (address) — VARCHAR
- Field (status) — VARCHAR — 결제완료 | 배송 준비 | 배송 중 | 배송 완료
Order_Item (Untitled8)
- Key (order_item_idx) — INT — Primary key — NOT NULL
- Key (option_idx) — INT — Foreign key → Product_Option.Key — NOT NULL
- Field (quantity) — INT — quantity >=1
Product (Untitled2)
- Key (product_idx) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR
- Field (price) — INT — price>=0
- Key (category_idx) — INT — Foreign key → Category.Key — NOT NULL
- Field (deescription) — TEXT
- Key (brand_idx) — INT — Foreign key → Brnad.Key — NOT NULL
Product_Option (Untitled4)
- Key (option_idx) — INT — Primary key — NOT NULL
- Key (product_idx) — INT — Foreign key → Product.Key — NOT NULL — CASCADE ON DELETE
- Field (color) — VARCHAR
- Field (size) — VARCHAR
- Field (stock) — INT — stock>=0
Review (Untitled5)
- Key (review_idx) — INT — Primary key — NOT NULL
- Key (user_idx) — VARCHAR — Foreign key → User.Key — NOT NULL — CASCADE ON DELETE
- Key (product_idx) — INT — Foreign key → Product.Key — NOT NULL — CASCADE ON DELETE
- Field (star) — INT — 0<=star<=5
- Field (comment) — TEXT
Review_Likes (Untitled6)
- Key (review_idx) — INT — Foreign key → Review.Key — NOT NULL — CASCADE ON DELETE
- Key (user_idx) — VARCHAR — Foreign key → User.Key — NOT NULL — CASCADE ON DELETE
User (Untitled)
- Key (id) — VARCHAR — Primary key — NOT NULL
- Field (user_id) — VARCHAR
- Field (email) — VARCHAR
- Field (password) — VARCHAR
- Field (nickname) — VARCHAR
- Field (phone_number) — VARCHAR
- Field (gender) — VARCHAR — {남|여}
- Field (is_admin) — boolean