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