-
Notifications
You must be signed in to change notification settings - Fork 0
Database Schema
Aakash edited this page Sep 3, 2018
·
6 revisions
| Column Name | Datatype | Details |
|---|---|---|
| id | objectId | not null, database generated |
| String | valid email | |
| firstName | String | 2 characrters or more |
| lastName | String | optional |
| password_digest | String | hash |
| Column Name | Datatype | Details |
|---|---|---|
| id | objectId | not null, database generated |
| name | String | 2characters or more |
| services | Array of objectId | Foreign keys to services |
| address | String | valid address |
| owner | Number | id of user that owns the business |
| business hours | Array | [start, end] |
| reviews | Array of objectId | Foreign keys to reviews |
| Average rating | Number | Average review rating |
| Column Name | Datatype | Details |
|---|---|---|
| id | objectId | not null, database generated |
| title | String | 2characters or more |
| description | String | Optional |
| category | String | id of the category |
| price | Number | >=0 |
| address | String | valid address |
| business | Number | id of business that it belongs to |
| owner | Number | id of user that owns the business |
| reviews | Array of objectId | Foreign keys to reviews |
| Average rating | Number | Average of reviews |
| Column Name | Datatype | Details |
|---|---|---|
| id | objectId | not null, database generated |
| Service id | objectId | Foreign keys to services |
| Business id | objectId | Foreign keys to business |
| Reviewer | objectId | Foreign key to user |
| Rating | Number | 1-10 |
| Review details | String | Optional |
| Column Name | Datatype | Details |
|---|---|---|
| id | objectId | not null, database generated |
| image | String | url to image |
| services | Array | keys to services |
| Name | String |