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