Database schema and CRUD for Patients

[moozeq]

Description

Create basic back-end part for Patients (they are not Users and they can't log in the application) and they can be added by Users with "doctor" Role.

Prerequisites

• User log in and log out functionality #2
• Database schema and predefined Roles #3
• Database schema and predefined Facilities #4

Acceptance criteria

• Create database schema for Patient class using sequelize-typescript with fields:
  • ssn Social Security number (or any other unique country-specific ID)
  • status - patient's status, allowed values: waiting, in-progress, completed, discontinued
  • name
  • surname
  • telephone? (optional)
  • email? (optional)
  • address? (optional)
  • medicalHistory - description of medical history of the patient
  • files - medical reports, column needs to be encypted!
  • meta - metadata dictionary where other less specific information can be stored
• Add CRUD for Patients but only accessible for authorized Users with "doctor" Role
• Add association one-to-many for Facilities (Database schema and predefined Facilities #4) and Patients