11_28
Tables (22)
auth_group
- id — int — Primary key — NOT NULL
- name — varchar(150) — NOT NULL
auth_group_permissions
- id — bigint — Primary key — NOT NULL
- group_id — int — Foreign key → auth_group.id — NOT NULL
- permission_id — int — Foreign key → auth_permission.id — NOT NULL
auth_permission
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- content_type_id — int — Foreign key → django_content_type.id — NOT NULL
- codename — varchar(100) — NOT NULL
auth_user
- id — int — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- is_superuser — tinyint(1) — NOT NULL
- username — varchar(150) — NOT NULL
- first_name — varchar(150) — NOT NULL
- last_name — varchar(150) — NOT NULL
- email — varchar(254) — NOT NULL
- is_staff — tinyint(1) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
auth_user_groups
- id — bigint — Primary key — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
- group_id — int — Foreign key → auth_group.id — NOT NULL
auth_user_user_permissions
- id — bigint — Primary key — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
- permission_id — int — Foreign key → auth_permission.id — NOT NULL
custom_appointment
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- scheduled_at — datetime(6) — NOT NULL
- duration_minutes — int — NOT NULL
- status — varchar(20) — NOT NULL
- visit_type — varchar(20) — NOT NULL
- reason — longtext — NOT NULL
- created_by — varchar(50) — NOT NULL
- notes — longtext — NOT NULL
- patient_id — bigint — Foreign key → emr_patient.id — NOT NULL
- doctor_id — bigint — Foreign key → custom_doctor.id
custom_doctor
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- license_number — varchar(50) — NOT NULL
- specialty — varchar(100) — NOT NULL
- department — varchar(100) — NOT NULL
- bio — longtext — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
custom_patient_doctor
- id — bigint — Primary key — NOT NULL
- is_primary — tinyint(1) — Primary key — NOT NULL
- patient_id — bigint — Foreign key → emr_patient.id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- assigned_date — date — NOT NULL
- doctor_id — bigint — Foreign key → custom_doctor.id — NOT NULL
custom_prediction_result
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- model_name — varchar(100) — NOT NULL
- model_version — varchar(20) — NOT NULL
- orthanc_study_uid — varchar(200) — NOT NULL
- orthanc_series_uid — varchar(200) — NOT NULL
- prediction_class — varchar(50) — NOT NULL
- confidence_score — double — NOT NULL
- probabilities — json — NOT NULL
- xai_image_path — varchar(500) — NOT NULL
- feature_importance — json — NOT NULL
- doctor_feedback — varchar(20) — NOT NULL
- doctor_note — longtext — NOT NULL
- confirmed_at — datetime(6)
- doctor_id — bigint — Foreign key → custom_doctor.id
- encounter_id — bigint — Foreign key → emr_encounter.id — NOT NULL
- patient_id — bigint — Foreign key → emr_patient.id — NOT NULL
custom_prescription
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- medication_code — varchar(50) — NOT NULL
- medication_name — varchar(200) — NOT NULL
- dosage — varchar(100) — NOT NULL
- frequency — varchar(100) — NOT NULL
- duration — varchar(50) — NOT NULL
- route — varchar(50) — NOT NULL
- instructions — longtext — NOT NULL
- prescribed_at — datetime(6) — NOT NULL
- encounter_id — bigint — Foreign key → emr_encounter.id — NOT NULL
django_admin_log
- id — int — Primary key — NOT NULL
- action_time — datetime(6) — NOT NULL
- object_id — longtext
- object_repr — varchar(200) — NOT NULL
- action_flag — smallint — NOT NULL
- change_message — longtext — NOT NULL
- content_type_id — int — Foreign key → django_content_type.id
- user_id — int — Foreign key → auth_user.id — NOT NULL
django_content_type
- id — int — Primary key — NOT NULL
- app_label — varchar(100) — NOT NULL
- model — varchar(100) — NOT NULL
django_migrations
- id — bigint — Primary key — NOT NULL
- app — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- applied — datetime(6) — NOT NULL
django_session
- session_key — varchar(40) — Primary key — NOT NULL
- session_data — longtext — NOT NULL
- expire_date — datetime(6) — NOT NULL
emr_encounter
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- encounter_date — datetime(6) — NOT NULL
- reason — longtext — NOT NULL
- facility — varchar(200) — NOT NULL
- status — varchar(20) — NOT NULL
- doctor_id — int — Foreign key → auth_user.id
- patient_id — bigint — Foreign key → emr_patient.id — NOT NULL
emr_form_soap
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- date — datetime(6) — NOT NULL
- subjective — longtext — NOT NULL
- objective — longtext — NOT NULL
- assessment — longtext — NOT NULL
- plan — longtext — NOT NULL
- encounter_id — bigint — Foreign key → emr_encounter.id — NOT NULL
emr_form_vitals
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- date — datetime(6) — NOT NULL
- bps — int
- bpd — int
- weight — decimal(5,2)
- height — decimal(5,2)
- temperature — decimal(4,1)
- pulse — int
- respiration — int
- oxygen_saturation — int
- bmi — decimal(4,1)
- bmi_status — varchar(20) — NOT NULL
- encounter_id — bigint — Foreign key → emr_encounter.id — NOT NULL
emr_merged_document
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- title — varchar(200) — NOT NULL
- document_type — varchar(50) — NOT NULL
- status — varchar(20) — NOT NULL
- references — json — NOT NULL
- snapshot_data — json — NOT NULL
- encounter_id — bigint — Foreign key → emr_encounter.id — NOT NULL
- signed_by_id — int — Foreign key → auth_user.id
- patient_id — bigint — Foreign key → emr_patient.id — NOT NULL
emr_patient
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- pid — varchar(50) — NOT NULL
- first_name — varchar(100) — NOT NULL
- last_name — varchar(100) — NOT NULL
- date_of_birth — date — NOT NULL
- gender — varchar(1) — NOT NULL
- phone — varchar(20) — NOT NULL
- email — varchar(254) — NOT NULL
- address — longtext — NOT NULL
- insurance_id — varchar(50) — NOT NULL
- emergency_contact — varchar(20) — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
notification_log
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- notification_type — varchar(50) — NOT NULL
- title — varchar(200) — NOT NULL
- message — longtext — NOT NULL
- is_read — tinyint(1) — NOT NULL
- read_at — datetime(6)
- sent_at — datetime(6) — NOT NULL
- metadata — json — NOT NULL
- push_sent — tinyint(1) — NOT NULL
- push_error — longtext — NOT NULL
- recipient_id — int — Foreign key → auth_user.id — NOT NULL
user_profile
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- deleted_at — datetime(6)
- role — varchar(20) — NOT NULL
- phone_number — varchar(20) — NOT NULL
- profile_image — varchar(100)
- fcm_token — varchar(255) — NOT NULL
- bio — longtext — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL