1223_cdss

Tables (20)

acct_users

  • user_id — uuid — Primary key — NOT NULL
  • password — varchar(128) — NOT NULL
  • username — varchar(150) — NOT NULL
  • email — varchar(254) — NOT NULL
  • role — varchar(20) — NOT NULL
  • full_name — varchar(200) — NOT NULL
  • department — varchar(100) — NOT NULL
  • license_number — varchar(50) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • is_staff — tinyint(1) — NOT NULL
  • is_superuser — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • last_login — datetime(6)

acct_users_groups

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — uuid — Foreign key → acct_users.user_id — NOT NULL
  • group_id — int(11) — Foreign key → auth_group.id — NOT NULL

acct_users_user_permissions

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — uuid — Foreign key → acct_users.user_id — NOT NULL
  • permission_id — int(11) — Foreign key → auth_permission.id — NOT NULL

ai_aijob

  • job_id — uuid — Primary key — NOT NULL
  • study_id — uuid — NOT NULL
  • model_type — varchar(50) — NOT NULL
  • status — varchar(20) — NOT NULL
  • result_data — longtext
  • error_message — longtext — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • queued_at — datetime(6)
  • started_at — datetime(6)
  • completed_at — datetime(6)

auth_group

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(150) — NOT NULL

auth_group_permissions

  • id — bigint(20) — Primary key — NOT NULL
  • group_id — int(11) — Foreign key → auth_group.id — NOT NULL
  • permission_id — int(11) — Foreign key → auth_permission.id — NOT NULL

auth_permission

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • content_type_id — int(11) — Foreign key → django_content_type.id — NOT NULL
  • codename — varchar(100) — NOT NULL

django_admin_log

  • id — int(11) — Primary key — NOT NULL
  • action_time — datetime(6) — NOT NULL
  • object_id — longtext
  • object_repr — varchar(200) — NOT NULL
  • action_flag — smallint(5) — NOT NULL
  • change_message — longtext — NOT NULL
  • content_type_id — int(11) — Foreign key → django_content_type.id
  • user_id — uuid — Foreign key → acct_users.user_id — NOT NULL

django_content_type

  • id — int(11) — Primary key — NOT NULL
  • app_label — varchar(100) — NOT NULL
  • model — varchar(100) — NOT NULL

django_migrations

  • id — bigint(20) — 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_encounters

  • encounter_id — varchar(20) — Primary key — NOT NULL
  • doctor_id — varchar(36) — NOT NULL
  • encounter_type — varchar(20) — NOT NULL
  • department — varchar(100) — NOT NULL
  • chief_complaint — longtext
  • diagnosis — longtext
  • status — varchar(20) — NOT NULL
  • encounter_date — datetime(6) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • patient_id — varchar(20) — Foreign key → emr_patient_cache.patient_id — NOT NULL

emr_patient_cache

  • patient_id — varchar(20) — Primary key — NOT NULL
  • family_name — varchar(50) — NOT NULL
  • given_name — varchar(50) — NOT NULL
  • birth_date — date — NOT NULL
  • gender — varchar(10) — NOT NULL
  • phone — varchar(20)
  • email — varchar(100)
  • address — longtext
  • emergency_contact — longtext
  • allergies — longtext
  • blood_type — varchar(5)
  • openemr_patient_id — varchar(100)
  • last_synced_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

ocs_order_items

  • item_id — varchar(20) — Primary key — NOT NULL
  • drug_code — varchar(50)
  • drug_name — varchar(200) — NOT NULL
  • dosage — varchar(50) — NOT NULL
  • frequency — varchar(50) — NOT NULL
  • duration — varchar(20) — NOT NULL
  • route — varchar(50) — NOT NULL
  • instructions — longtext
  • order_id — varchar(20) — Foreign key → ocs_orders.order_id — NOT NULL

ocs_orders

  • order_id — varchar(20) — Primary key — NOT NULL
  • ordered_by — varchar(36) — NOT NULL
  • order_type — varchar(50) — NOT NULL
  • urgency — varchar(20) — NOT NULL
  • status — varchar(20) — NOT NULL
  • notes — longtext
  • ordered_at — datetime(6) — NOT NULL
  • executed_at — datetime(6)
  • executed_by — varchar(36)
  • encounter_id — varchar(20) — Foreign key → emr_encounters.encounter_id
  • patient_id — varchar(20) — Foreign key → emr_patient_cache.patient_id — NOT NULL

ris_radiologyorder

  • order_id — uuid — Primary key — NOT NULL
  • patient_id — varchar(100) — NOT NULL
  • modality — varchar(10) — NOT NULL
  • body_part — varchar(100) — NOT NULL
  • clinical_info — longtext — NOT NULL
  • status — varchar(20) — NOT NULL
  • priority — varchar(20) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • ordered_by_id — uuid — Foreign key → acct_users.user_id

ris_radiologyreport

  • report_id — uuid — Primary key — NOT NULL
  • findings — longtext — NOT NULL
  • impression — longtext — NOT NULL
  • status — varchar(20) — NOT NULL
  • signed_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • radiologist_id — uuid — Foreign key → acct_users.user_id
  • signed_by_id — uuid — Foreign key → acct_users.user_id
  • study_id — uuid — Foreign key → ris_radiologystudy.study_id — NOT NULL

ris_radiologystudy

  • study_id — uuid — Primary key — NOT NULL
  • orthanc_study_id — varchar(100) — NOT NULL
  • study_instance_uid — varchar(255) — NOT NULL
  • patient_name — varchar(200) — NOT NULL
  • patient_id — varchar(100) — NOT NULL
  • study_date — date
  • study_time — time(6)
  • study_description — longtext — NOT NULL
  • modality — varchar(10) — NOT NULL
  • referring_physician — varchar(200) — NOT NULL
  • num_series — int(11) — NOT NULL
  • num_instances — int(11) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • synced_at — datetime(6) — NOT NULL
  • order_id — uuid — Foreign key → ris_radiologyorder.order_id

token_blacklist_blacklistedtoken

  • id — bigint(20) — Primary key — NOT NULL
  • blacklisted_at — datetime(6) — NOT NULL
  • token_id — bigint(20) — Foreign key → token_blacklist_outstandingtoken.id — NOT NULL

token_blacklist_outstandingtoken

  • id — bigint(20) — Primary key — NOT NULL
  • token — longtext — NOT NULL
  • created_at — datetime(6)
  • expires_at — datetime(6) — NOT NULL
  • user_id — uuid — Foreign key → acct_users.user_id
  • jti — varchar(255) — NOT NULL