ERD

Tables (12)

Cart (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • product_count (Field)
  • user_id (INT UNSIGNED) — Foreign key → User.id — NOT NULL
  • product_id (Key2) — Foreign key → Product.id — NOT NULL

Discount (Untitled13)

  • id (Key) — Primary key — NOT NULL
  • value (Field)
  • Field2
  • product_id (Key2) — Foreign key → Product.id — NOT NULL

Display_Product (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • main_image_url (Field3)
  • created_at (Field4)
  • updated_at (Field5)

Order (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • receiver_name (Field)
  • receiver_phone (Field2)
  • recipient_address (Field3)
  • order_status (Field4)
  • created_at (Field5)
  • delivered_at (Field6)
  • user_id (INT UNSIGNED) — Foreign key → User.id — NOT NULL

Order_Product (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • count (Field)
  • order_id (Key2) — Foreign key → Product.id — NOT NULL
  • product_id (Key3) — Foreign key → Order.id — NOT NULL

Payment (Untitled10)

  • Key — Primary key — NOT NULL
  • total_price (Field)
  • discount_price (Field2)
  • delivery_fee (Field3)
  • final_price (Field4)
  • created_at (Field5)
  • payment_type_id (Key2) — Foreign key → Payment_Type.id — NOT NULL
  • order_id (Key3) — Foreign key → Order.id — NOT NULL

Payment_Type (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

Product (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)
  • stock (Field3)
  • status (Field4)
  • display_product_id (Key2) — Foreign key → Display_Product.id — NOT NULL

Review (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • description (Field2)
  • created_at (Field3)
  • user_id (Field4)
  • Order_Product_id (Field5)
  • user_id (INT UNSIGNED) — Foreign key → User.id — NOT NULL
  • Order_Product_id (Key2) — Foreign key → Order_Product.id — NOT NULL

Review_Photo (Untitled)

  • id (BIGINT UNSIGNED) — Primary key — NOT NULL
  • photo_url (VARCHAR(100))
  • review_id (Key) — Foreign key → Review.id — NOT NULL

Shipping_Address (Untitled3)

  • id (BIGINT UNSIGNED) — Primary key — NOT NULL
  • address (Field2)
  • user_id (INT UNSIGNED2) — Foreign key → User.id — NOT NULL

User (Untitled2)

  • id (INT UNSIGNED) — Primary key — NOT NULL
  • login_id (VARCHAR(30))
  • passward (VARCHAR(256))
  • name (Field3)
  • email (Field4)
  • phone_number (VARCHAR(11))
  • gender (ENUM)
  • birth (DATE)