treatment

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
estudio.treatment_id estudio_treatment_id_fkey C
note.treatment_id note_treatment_id_fkey C
session.treatment_id session_treatment_id_fkey R
public_id varchar 10 null
clinic_id int8 19 null
clinic.id treatment_clinic_id_fkey R
diagnostic varchar 2147483647 √ null
motive varchar 2147483647 null
evaluation varchar 2147483647 √ null
background varchar 2147483647 √ null
patient_id int8 19 null
patient.id treatment_patient_id_fkey C
staff_id int8 19 √ null
staff.id treatment_staff_id_fkey R
created_at timestamptz 35,6 now()
finished_at timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
treatment_pkey Primary key Asc id
idx_treatment_clinic_id Performance Asc clinic_id
idx_treatment_patient_id Performance Asc patient_id
idx_treatment_staff_id Performance Asc staff_id
treatment_public_id_key Must be unique Asc public_id

Relationships

Close relationships within degrees of separation