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