carrot

Tables (6)

Untitled2 (Location)

  • Key (location_id) — Primary key — NOT NULL
  • Field (city)
  • Field (district)

Untitled2 (Category)

  • Key (category_id) — Primary key — NOT NULL
  • Field (name)
  • Field (parent_category_id)

Untitled2 (Product)

  • Key (product_id) — Primary key — NOT NULL
  • Key (category_id) — Foreign key → Untitled2.Key — NOT NULL
  • user_id — Foreign key → User.user_id — NOT NULL
  • Key (location_id) — Foreign key → User.Key — NOT NULL
  • Field (title)
  • Field (description)
  • Field2 (price)
  • Field3 (condition)
  • Field4 (created_at)
  • Field5 (updated_at)

Untitled2 (Chat)

  • Key2 (chat_id) — Primary key — NOT NULL
  • Key (product_id) — Foreign key → Untitled2.Key — NOT NULL
  • Key (category_id) — Foreign key → Untitled2.Key — NOT NULL
  • user_id — Foreign key → Untitled2.user_id — NOT NULL
  • Key (location_id) — Foreign key → Untitled2.Key — NOT NULL
  • Field (created_at)
  • Field2 (updated_at)

Untitled2 (Message)

  • Key (message_id) — Primary key — NOT NULL
  • Key2 (chat_id) — Foreign key → Untitled2.Key2 — NOT NULL
  • Key (product_id) — Foreign key → Untitled2.Key — NOT NULL
  • Key (category_id) — Foreign key → Untitled2.Key — NOT NULL
  • user_id — Foreign key → Untitled2.user_id — NOT NULL
  • Key (location_id) — Foreign key → Untitled2.Key — NOT NULL
  • Field (content)
  • Field (created_at)

User

  • user_id — Primary key — NOT NULL
  • Key (location_id) — Foreign key → Untitled2.Key — NOT NULL
  • name
  • Field2 (email)
  • Field3 (password)
  • Field4 (gender)
  • Field (age)
  • Field2