PK

classroom_id Integer

NOT_NULL,name Varchar(200)

description Text

therapist_id Integer

PK, FK

user_id Integer

therapist_id Integer

full_name Varchar(200)

qualifications Text

PK

enrollment_id Integer

FK classroom_id Integer

FK patient_id Integer

enrolled_at Timestamp

PK, FK

user_id Integer

PK patient_id Integer

NOT_NULL,display_name Varchar(200)

dob Date

sensory_profile Jsonb

Diagnosis Varchar(100)

PK

id Integer

model_name Varchar(200)

version Varchar(50)

config Jsonb

trained_on Text

deployed_at Timestamp

PK

assignment_id Integer

FK template_id Integer

FK classroom_id Integer

due_date Date

FK created_by Integer

created_at Timestamp

PK

template_id Integer

NOT_NULL,title Varchar(250)

description Text

modalities Text[]

difficulty Smallint

default_settings Jsonb

FK created_by Integer

PK

sensor_data_id Integer

FK attempt_id Integer

FK device_id Integer

ts Timestamp

payload Jsonb

PK

device_id Integer

NOT_NULL,device_type Varchar(50)

NOT_NULL,identifier Varchar(200)

location Varchar(200)

config Jsonb

PK

profile_id Integer

FK patient_id Integer

model_state Jsonb

start_trained_at Timestamp

last_trained_at Timestamp

PK

report_id Integer

FK patient_id Integer

FK therapist_id Integer

period_start Date

period_end Date

summary Jsonb

created_at Timestamp

PK

session_id Integer

FK patient_id Integer

FK therapist_id Integer

NOT_NULL start_time Timestamp

end_time Timestamp

duration_minutes Integer

PK, FK

user_id Integer

PK admin_id Integer

PK

user_id Integer

NOT_NULL email Varchar(255)

NOT_NULL password_hash Text

NOT_NULL role Varchar(20)

NOT_NULL created_at Timestamp

PK

notification_id Integer

FK user_id Integer

title Varchar(250)

body Text

is_read Boolean

created_at Timestamp