LikeLion_DRF_Team
Tables (7)
Brand
- brand_id — integer — Primary key — NOT NULL
- user_id (Key) — integer — Foreign key → User.id — NOT NULL
- brand_name — string
Cart (Untitled5)
- cartitem_id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → User.id — NOT NULL
- product_id — integer — Foreign key → Product.product_id — NOT NULL
- quantity (Field) — integer
- option_color (Field2) — string
- option_size (Field3) — string
Order (Untitled3)
- order_id — integer — Primary key — NOT NULL
- user_id (Key) — integer — Foreign key → User.id — NOT NULL
- total_quantity (Field) — integer
- total_cost (Field2) — integer
- address (Field3) — string
- delivery_status (Field4) — boolean
OrderDetail (OrderItem)
- id — integer — Primary key — NOT NULL
- order_id — integer — Foreign key → Order.order_id — NOT NULL
- product_id — integer — Foreign key → Product.product_id — NOT NULL
- quantity (order_qty) — integer
- price (order_price) — demical
- option_color (Field) — string
- option_size (Field2) — string
Product
- product_id — integer — Primary key — NOT NULL
- brand_id — integer — Foreign key → Brand.brand_id — NOT NULL
- name (product_name) — string
- price (product_price) — decimal
- category (product_category) — string
- stock (product_stock) — integer
- description (product_description) — string
- option_color (Field) — list
- option_size (Field2) — list
- availability (Field3) — boolean
Review (Untitled2)
- review_id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → User.id — NOT NULL
- product_id — integer — Foreign key → Product.product_id — NOT NULL
- rating (Field3) — integer
- comment (Field4) — string
- likes (Field5) — integer
- create_on (Field) — TimeStamp
User (Untitled)
- id (Key) — integer — Primary key — NOT NULL
- login_id (Field3) — string
- email (Field) — string
- password (Field2) — string
- nickname (Field4) — string
- phone_number (Field5) — string
- gender (Field6) — string
- is_admin (Field7) — boolean
- is_seller (Field8) — boolean