rsyarsi / coas-configuration

Coas Configuration
https://sikm.rsyarsi.co.id
0 stars 0 forks source link

Database #3

Closed hsbmaulana closed 1 month ago

hsbmaulana commented 1 month ago

Master

users (admin, lecturer, student) groups hospitals universities years semesters patients

specialist_groups (Gigi) specialist_sub_groups (Ortodontik, Periodontik, Prostodontik, Pedodontik, Konservasi, Radiologi Penoramik, Radiologi Oklusi, Radiologi Periapikal) specialist_group_id, simrsid

assessment_groups (Sikap) specialist_id assessment_sub_groups (Teknik Radiografi Intraoral Periapikal) assessment_group_id assessment_weight assessment_group_id value description

forms | type = emhr (specialist_sub_group_id), assessment (assessment_sub_group_id) - data {}

Transaksi

tr_forms_emhr | name, user_id (student), patient_id, specialist_sub_group_id - data {} tr_forms_assessment | name, user_id (lecturer), student_id, assessment_sub_group_id - data {}

.