sad

Tables (7)

Untitled (Property)

  • Key (id) — Primary key — NOT NULL
  • id (userId) — Foreign key → User.id — NOT NULL
  • Field (address)
  • Field (type)
  • Field (price)
  • Field (size)
  • Field (status)
  • Field (description)
  • Field (builtYear)

Untitled (Transaction)

  • Key (id) — Primary key — NOT NULL
  • Field (data)
  • Field (description)

Untitled (PropertyImage)

  • Key (id) — Primary key — NOT NULL
  • Key (propertyId) — Foreign key → Untitled.Key — NOT NULL
  • Field (url)

Untitled (Review)

  • Key (id) — Primary key — NOT NULL
  • Key (propertyId) — Foreign key → Untitled.Key — NOT NULL
  • id (userId) — Foreign key → Untitled.id — NOT NULL
  • Field (rating)
  • Field (comment)
  • Field (reviewDate)

Untitled (Favorite)

  • Key (id) — Primary key — NOT NULL

Untitled (Agent)

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

User

  • id — Primary key — NOT NULL
  • name (email)
  • phone
  • Field3 (role)
  • Field (address)