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)