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