reco-engine

Tables (5)

Category

  • category id (id) — Primary key — NOT NULL
  • category name (name) — varchar(100) — NOT NULL

Untitled (UserCategoryRating)

  • userId — int — Foreign key → User.userId — NOT NULL
  • category id (categoryId) — Foreign key → Category.category id — NOT NULL
  • Field (rating) — int

Untitled (UserWorkspaceRating)

  • userId — int — Foreign key → User.userId — NOT NULL
  • workspace id (workspaceId) — int — Foreign key → Workspaces.workspace id — NOT NULL
  • Field (rating) — int — rated by user

User

  • userId (id) — int — Primary key — NOT NULL
  • name — varchar(30) — NOT NULL
  • email — varchar(200) — NOT NULL
  • password (pw) — varchar(20) — NOT NULL
  • Field (distance) — int — NOT NULL — how far are you willing to travel -> 1/5/10
  • Field (pref_space) — varchar(30) — NOT NULL — what type of workspace do you prefer ->

Workspaces

  • workspace id (id) — int — Primary key — NOT NULL
  • category id (category_id) — int — Foreign key → Category.category id — NOT NULL
  • address — varchar(30)
  • latitude (lat) — float
  • longitude (long) — float
  • name — varchar(50)
  • price range (price_range)
  • rating — int — NOT NULL — rating from google maps
  • Field (review_count) — int
  • Field (detailed_url) — varchar(200)
  • Field (img_url) — varchar(200)