Recommendations with ML Sample

https://cloud.google.com/solutions/recommendations-using-machine-learning-on-compute-engine

Tables (4)

Accommodation

  • id — varchar(255) — Primary key — NOT NULL
  • title — varchar(255)
  • price — int
  • rooms count (rooms) — int
  • rating — float
  • type — varchar(255)

Rating

  • user id (userId) — varchar(255) — Foreign key → User.user id — NOT NULL
  • accommodation id (accoId) — varchar(255) — Foreign key → Accommodation.id — NOT NULL
  • rating — int

Recommendation

  • user id (userId) — varchar(255) — Foreign key → User.user id — NOT NULL
  • accommodation id (accoId) — varchar(255) — Foreign key → Accommodation.id — NOT NULL
  • prediction — float

User

  • user id (userId) — varchar(255) — Primary key — NOT NULL