ERD
Tables (8)
anatomy_master
- anatomy_code — INT — Primary key — NOT NULL
- anatomy_name — VARCHAR(64) — NOT NULL
aws_accounts
- user_key — INT — Primary key — NOT NULL
- user_id — VARCHAR(64)
- user_name — VARCHAR(64)
- password_digest — VARCHAR(64)
- permission_level — INT — NOT NULL
- user_description — VARCHAR(64)
- try_count — INT — NOT NULL
- last_login_datetime — DATETIME — NOT NULL
- password_change_datetime — DATETIME — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME — NOT NULL
aws_anatomy
- anatomy_key — INT — Primary key — NOT NULL
- worklist_key — INT — Foreign key → aws_worklist.worklist_key — NOT NULL
- anatomy_code — INT — Foreign key → anatomy_master.anatomy_code — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME — NOT NULL
aws_image
- image_key — INT — Primary key — NOT NULL
- view_key — INT — Foreign key → aws_part_view.part_view_key — NOT NULL
- image_number — INT — NOT NULL
- species_name — VARCHAR(64)
- anatomy_name — VARCHAR(64) — NOT NULL
- part_name — VARCHAR(64) — NOT NULL
- view_name — VARCHAR(64) — NOT NULL
- save_folder — VARCHAR(1024) — NOT NULL
- info_bits — TINYINT — NOT NULL
- info_width — SMALLINT — NOT NULL
- info_height — SMALLINT — NOT NULL
- image_instance_uid — VARCHAR(64)
- raw_file_path — VARCHAR(1024) — NOT NULL
- dcm_file_path — VARCHAR(1024) — NOT NULL
- thumbnail_file_path — VARCHAR(1024) — NOT NULL
- image_status — TINYINT — NOT NULL
- dicom_storage — TINYINT — NOT NULL
- dicom_print — TINYINT — NOT NULL
- reject_reason — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME — NOT NULL
aws_part_view
- part_view_key — INT — Primary key — NOT NULL
- anatomy_key — INT — Foreign key → aws_anatomy.anatomy_key — NOT NULL
- part_view_code — INT — Foreign key → part_view_master.part_view_code — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME — NOT NULL
aws_sent
- sent_key — INT — Primary key — NOT NULL
- image_key — INT — Foreign key → aws_image.image_key — NOT NULL
- worklist_key — INT — Foreign key → aws_worklist.worklist_key — NOT NULL
- print_file_name — VARCHAR(64)
- device_type — VARCHAR(64)
- server_name — VARCHAR(64)
- server_aetitle — VARCHAR(64)
- client_aetitle — VARCHAR(64)
- ip_address — VARCHAR(64)
- port_number — VARCHAR(64)
- send_status — TINYINT
- error_code — INT — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME — NOT NULL
aws_worklist
- worklist_key — INT — Primary key — NOT NULL
- status — TINYINT — NOT NULL
- patient_id — VARCHAR(64) — NOT NULL
- patient_name — VARCHAR(64) — NOT NULL
- patient_name2 — VARCHAR(64)
- patient_sex — VARCHAR(8) — NOT NULL
- patient_age — VARCHAR(16)
- patient_birth_datetime — DATETIME — NOT NULL
- patient_size — VARCHAR(64)
- patient_weight — VARCHAR(64)
- patient_comments — VARCHAR(64)
- patient_transport_arrangements — VARCHAR(64)
- patient_institution_residence — VARCHAR(64)
- patient_address — VARCHAR(64)
- patient_state — VARCHAR(64)
- patient_telephone_numbers — VARCHAR(64)
- access_no — VARCHAR(64)
- study_datetime — DATETIME — NOT NULL
- study_description — VARCHAR(255)
- study_instance_id — VARCHAR(255)
- modality — VARCHAR(64) — NOT NULL
- ocs_id_list — VARCHAR(1024)
- referring_physician — VARCHAR(64)
- requested_procedure_id — VARCHAR(64)
- requested_procedure_description — VARCHAR(255)
- requested_procedure_code_sequence — VARCHAR(64)
- requested_procedure_priority — VARCHAR(64)
- requested_procedure_location — VARCHAR(64)
- requested_contrast_agent — VARCHAR(64)
- scheduled_start_datetime — DATETIME — NOT NULL
- scheduled_station_ae_title — VARCHAR(64)
- scheduled_procedure_step_description — VARCHAR(255)
- scheduled_performing_physician_name — VARCHAR(64)
- scheduled_station_name — VARCHAR(64)
- scheduled_procedure_step_id — VARCHAR(64)
- requesting_service — VARCHAR(64)
- visit_status_id — VARCHAR(64)
- current_patient_location — VARCHAR(64)
- admitting_diagnosis_description — VARCHAR(64)
- other_patient_ids — VARCHAR(64)
- other_patient_names — VARCHAR(64)
- ethnic_group — VARCHAR(64)
- occupation — VARCHAR(64)
- confidentiality_constraint_on_patient — VARCHAR(64)
- additional_patient_history — VARCHAR(64)
- pregnancy_status — VARCHAR(64)
- medical_alerts — VARCHAR(64)
- allergies — VARCHAR(64)
- special_needs — VARCHAR(64)
- institution_name — VARCHAR(64)
- institution_address — VARCHAR(64)
- institutional_department_name — VARCHAR(64)
- patient_species_description — VARCHAR(64)
- patient_sex_neutered — VARCHAR(64)
- patient_breed_description — VARCHAR(64)
- responsible_person — VARCHAR(64)
- premedication — VARCHAR(64)
- intervention_drug_name — VARCHAR(64)
- life_number — VARCHAR(64)
- create_datetime — DATETIME — NOT NULL
- … +1
part_view_master
- part_view_code — INT — Primary key — NOT NULL
- part_name — VARCHAR(64) — NOT NULL
- view_name — VARCHAR(64) — NOT NULL