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