Database Model
- Download create_all sql
- Download drop_all sql
Store information related to Regovar's users
| Field | Type | Description |
|---|---|---|
| id | serial | [PK] unique id of the user |
| varchar(255) | email of the user | |
| password | varchar(255) | SHA-2 token of the user's password |
| firstname | varchar(255) | the firstname of the user |
| astname | varchar(255) | the lastname of the user |
| location | varchar(255) | the location where is working the user (CHU + City by example) |
| function | varchar(50) | the job of the user or the service where he is working |
| last_activity_date | datetime | the last date when the user used one of the regovar applications |
| settings | text | the settings of the applications are saved online to alow user to retrieve it even if he have to use the application on another computer, or need to reinstall the application |
describe a Regovar project
| Field | Type | Description |
|---|---|---|
| id | serial | [PK] unique id of the project |
| name | varchar(50) | the name of the project; (owner_id, name) shall be unique |
| comments | text | some comments can be stored by project |
| owner_id | integer | [FK] the id of the user who created this project |
| creation_date | datetime | the date when the project have been created |
| update_date | datetime | the last date when the project have been edited |
| is_archived | bool | if the project is archived or not; see archiving project feature |
several differents analyses can be conducted on the same dataset of the project
| Field | Type | Description |
|---|---|---|
| id | serial | [PK] unique id of the analysis |
| name | varchar(50) | the name of the analysis |
| project_id | int | [FK] the id of the project that own te analysis |
| comments | text | some comments can be stored about the analysis |
| template_id | int | the id of the template (pipe) on which this analysis is based |
| template_settings | text | some custom parameters can be set for the analysis |
__
| Field | Type | Description |
|---|---|---|
| id | serial | [PK] unique id of the user |
| name | varchar(50) | the name of the analyse |
| project_id | int | [FK] the id of the project that own te analyse |
| comments | text | some comments can be stored about the analyse |
| template_id | int | the id of the template (pipe) on which this analyse is based |
| template_settings | text | some custom parameters can be set the analyse |