Database schema and CRUD for Studies

[moozeq]

Description

Create basic back-end part for Studies which are coducted in accordance with Protocols (#6) instructions.

Prerequisites

• Database schema and predefined Facilities #4
• Database schema and CRUD for Patients #5
• Database schema, CRUD and predefined Protocols #6

Acceptance criteria

• Create database schema for Study class using sequelize-typescript with fields:
  • status - study's status, allowed values: waiting, in-progress, completed, discontinued
  • name
  • description
  • startDate
  • endDate
  • protocol - Protocol for the study with drug administration instruction
  • facilities[] - Facilities which are included in the study
• Add CRUD for Study but only accessible for authorized Users with "director" Role
• Add association one-to-many for Studies and Facilities (Database schema and predefined Facilities #4)
• Add association one-to-one for Studies and Protocols (Database schema, CRUD and predefined Protocols #6)