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