poc.sql

CREATE TABLE patient(
    patient_id,
    name,
    birth_date
)

CREATE TABLE user_role_lu ( --1 -> admin, 2 -> district_manager, 3 -> hospital_manager, 4 -> doctor, 5 -> patient
    user_role_id,
    name,
    description
)

CREATE TABLE hospital(
    hospital_id,
    name,
    district_id
)

CREATE TABLE user(
    user_id,
    user_role_id
)

CREATE TABLE patient_data(
    patient_data_id,
    patient_id,
    hospital_id
)