123

Tables (35)

ai_reading

  • id — SERIAL
  • type — ai_reading_type
  • contents — varchar
  • ai_reading_model_id — long — Foreign key → ai_reading_model.id
  • exam_id — long — Foreign key → exam.id
  • status — ai_reading_status
  • error_reason — varcahr

ai_reading_model

  • id — SERIAL
  • model_source — model_source
  • name — string
  • key — varchar
  • base_url — varchar

attached_file

  • id — SERIAL
  • path — varchar
  • origin_file_name — varchar
  • size — long

auto_radiologist_assignment

  • id — SERIAL
  • request_hospital_id — long — Foreign key → request_hospital.id
  • center_id — long — Foreign key → center.id
  • user_id — varchar — Foreign key → user.id

auto_radiologist_assignment_bodpart

  • auto_radiologist_assignment_id — long — Foreign key → auto_radiologist_assignment.id
  • body_part_id — long — Foreign key → body_part.id

auto_radiologist_assignment_modality

  • auto_radiologist_assignment_id — long — Foreign key → auto_radiologist_assignment.id
  • modality_id — long — Foreign key → modality.id

body_part

  • id — SERIAL
  • name — varchar
  • description — varchar

center

  • id — SERIAL
  • name — varchar
  • approvalNumber — varchar
  • address — varchar
  • telephone — varchar
  • email — varchar
  • director — varchar
  • administrator — long — Foreign key → user.id
  • request_delay_time_value — int
  • request_delay_time_unit — chronounit

center_employee

  • user_id — varchar — Foreign key → user.id
  • center_id — long — Foreign key → center.id

comment_preset

  • id — SERIAL
  • type — preset_type
  • request_hospital_id — long — Foreign key → request_hospital.id
  • center_id — long — Foreign key → center.id
  • contests — varchar

comment_preset_modality

  • comment_preset_id — long — Foreign key → comment_preset.id
  • modality_id — long — Foreign key → modality.id

contract

  • id — SERIAL
  • contract_information_id — long — Foreign key → contract_information.id
  • scan_file_id — long — Foreign key → attached_file.id
  • period_start_date — datetime
  • period_end_date — datetime
  • execution_date — datetime
  • appenedix — string
  • contract_round — int

contract_information

  • id — SERIAL
  • center_id — long — Foreign key → center.id
  • request_hospital_id — long — Foreign key → request_hospital.id

exam

  • id — SERIAL
  • name — varchar
  • description — varchar
  • reading_request_id — long — Foreign key → reading_request.id

feedback

  • id — SERIAL
  • 내용 — text
  • 작성일시 — datetime

invoice

  • id — SERIAL
  • 계약_id — long — Foreign key → contract_information.id
  • 청구금액 — decimal
  • 발행일시 — datetime

invoice_status

  • id — SERIAL
  • 상태명 — varchar
  • invoice_id — long — Foreign key → invoice.id

invoice_template

  • id — SERIAL
  • 계약_id — long — Foreign key → contract_information.id
  • template_path — varchar

modality

  • id — SERIAL
  • name — varchar
  • description — varchar

notification

  • id — SERIAL
  • recipient — int — Foreign key → user.id
  • type — notification_type
  • subject — varchar
  • contents — varchar
  • contents_parameters — text
  • readDate — datetime

notification_template

  • id — SERIAL
  • type — notification_type
  • subject — varchar
  • contents — varchar
  • activated — boolean

radiologist_assignment

  • id — SERIAL
  • user_id — varchar — Foreign key → user.id
  • reading_request_id — long — Foreign key → reading_request.id
  • canceled — boolean

reading_code

  • id — SERIAL
  • reading_code_group_id — long — Foreign key → reading_code_group.id
  • title — varchar
  • shortcut_key — varchar
  • contents — varchar

reading_code_group

  • id — SERIAL
  • center_id — long — Foreign key → center.id
  • user_id — varchar — Foreign key → user.id
  • title — varchar
  • shared — boolean

reading_request

  • id — SERIAL
  • request_hospital_id — long — Foreign key → request_hospital.id
  • emergency_transit_date — datetime
  • emergency — boolean
  • reading_status_id — long — Foreign key → reading_status.id
  • patient_id — varchar
  • patient_name — varchar
  • patient_age — varchar
  • patient_sex — varchar
  • study_id — varchar
  • study_date — datetime
  • study_desc — varchar
  • study_instance_UID — varchar
  • modality — varchar
  • body_part — varchar
  • series_count — int
  • instance_count — int
  • dicom_file_id — long — Foreign key → attached_file.id
  • hospital_comment — varchar
  • center_comment — varchar

reading_status

  • id — SERIAL
  • request_status — request_status
  • reReading — boolean
  • denial_comment — varchar
  • denialed_date — datetime
  • transfer_status — transfer_status

report

  • id — SERIAL
  • radiologist_assignment_id — long — Foreign key → radiologist_assignment.id
  • contents — varchar
  • cvr — boolean
  • cvr_text — boolean
  • reported_date — datetime
  • feedback_id — long — Foreign key → feedback.id

request_hospital

  • id — SERIAL
  • name — varchar
  • medical_institution_establishment_permit_no — varchar
  • address — varchar
  • telephone — varchar
  • email — varchar
  • director — varchar
  • administrator — long — Foreign key → user.id
  • request_delay_time_value — int
  • request_delay_time_unit — chronounit
  • request_delay_time_limit_value — int
  • request_delay_time_limit_unit — chronounit

role

  • id — SERIAL
  • name — varchar
  • type — role_type

role_authority

  • role_id — long — Foreign key → role.id
  • authority — Authority

unit_price

  • id — SERIAL
  • body_part_id — long — Foreign key → body_part.id
  • Modality_id — long — Foreign key → modality.id
  • price — decimal
  • emergency_price — decimal

user

  • id — SERIAL
  • login — varchar
  • password — varchar
  • name — varchar
  • phone — varchar
  • medical_license — varchar
  • specialist_license — varchar
  • role_id — long — Foreign key → role.id
  • signature_image — text
  • proattached_file_image_id — varchar — Foreign key → attached_file.id
  • activated — boolean
  • deleted_at — boolean

user_preference

  • id — SERIAL
  • user_id — long — Foreign key → user.id
  • preference_type — preference_type
  • screen_type — screen_type
  • preferences — varchar

데이터_변경이력

  • id — SERIAL
  • 테이블명 — varchar
  • 레코드_id — long
  • 변경일시 — datetime
  • 변경내용 — text

정산

  • id — SERIAL
  • report_id — long — Foreign key → report.id
  • unit_price_id — long — Foreign key → unit_price.id
  • 정산일시 — datetime
  • 총금액 — decimal