new_remote_ERD
테이블 (16)
1:1문의게시글 (qa_board)
- qa_key — int(11) — 기본 키 — NOT NULL
- qa_group — int(11) — NOT NULL
- qa_parent — int(11) — NOT NULL
- qa_category — varchar(100)
- qa_subject — varchar(255)
- qa_content — text
- user_name — varchar(255)
- qa_registered — datetime — NOT NULL
- qa_updated — datetime — NOT NULL
- qa_file_count — tinyint(4)
- qa_replied — int(10) — NOT NULL
- qa_is_reply — int(10)
- qa_extra_posted — tinyint(4)
- file_link_key — varchar(512)
- user_id — varchar(20) — 외래 키 → 웹사용자(판독의, 병원담당자, 영업담당자, 센터담당자).user_key — NOT NULL
SAINTVIEW 사용자 (USERS)
- USER_KEY — BIGINT — 기본 키 — NOT NULL
- USER_ID — VARCHAR(32)
- FULLNAME — VARCHAR(72)
- FIRST_NAME — VARCHAR(24)
- MIDDLE_NAME — VARCHAR(24)
- LAST_NAME — VARCHAR(24)
- PWD — VARCHAR(24)
- GROUP_KEY — BIGINT
- DESCRIPTION — VARCHAR(64)
- MEDICAL_ID — VARCHAR(32)
- USER_LICENSE — VARCHAR(128)
- USER_LICENSE_TYPE — VARCHAR(32)
- USER_PROFILE — BLOB
- HANGING_PROTOCOL — BLOB
검사 (STUDY)
- STUDY_KEY — BIGINT — 기본 키 — NOT NULL
- INSTITUTION_KEY — BIGINT — 외래 키 → 병원(PACS).INSTITUTION_KEY — NOT NULL
- ORDER_KEY — BIGINT
- MERGE_KEY — BIGINT
- PATIENT_ID — VARCHAR(32) — NOT NULL
- PATIENT_NAME — VARCHAR(64)
- PATIENT_AGE — VARCHAR(6)
- PATIENT_SEX — VARCHAR(8)
- PATIENT_BIRTHDATE — TIMESTAMP
- PATIENT_KEY — BIGINT
- STUDY_INSTANCE_UID — VARCHAR(64) — NOT NULL
- STUDY_DTTM — TIMESTAMP
- UPDATE_DTTM — TIMESTAMP
- REGISTRATION_NO — VARCHAR(32)
- ACCESS_NO — VARCHAR(32)
- STUDY_LEVEL — INTEGER
- STUDY_DESC — VARCHAR(64)
- SERIES_COUNT — INTEGER
- IMAGE_COUNT — INTEGER
- MODALITY — VARCHAR(16)
- BODYPART — VARCHAR(32)
- AETITLE — VARCHAR(16)
- INSTITUTION — VARCHAR(32)
- ASSIGNED_USER_KEY — BIGINT
- ASSIGNED_USER — VARCHAR(72)
- PRIORITY — INTEGER
- MEMO_KEY — BIGINT
- USER_DELETED — INTEGER
- REQUEST_DEPARTMENT — VARCHAR(32)
- REFER_DOCTOR — BIGINT
- REFER_DOCTOR_NAME — VARCHAR(72)
- CONSULT_DOCTOR — BIGINT
- CONSULT_DOCTOR_NAME — VARCHAR(72)
- ATTEND_DOCTOR — BIGINT
- ATTEND_DOCTOR_NAME — VARCHAR(72)
- SPECIALTY — VARCHAR(32)
- SPECIAL_NEEDS — VARCHAR(128)
- FINDING — VARCHAR(128)
- SCORE — INTEGER
- REPORT_STATUS — INTEGER
- COMMENTS — VARCHAR(4096)
- RESERVED1 — VARCHAR(32)
- RESERVED2 — VARCHAR(12)
- RESERVED3 — VARCHAR(12)
게시글 (post)
- post_key — int(11) — 기본 키 — NOT NULL
- post_parent_key — int(11)
- post_category — varchar(100)
- post_title — varchar(256)
- post_depth — int(11)
- post_group — int(11)
- post_group_order — int(11)
- post_content — text
- post_hit — int(11)
- post_registered_datetime — timestamp — NOT NULL
- post_updated_datetime — timestamp — NOT NULL
- user_name — varchar(50)
- post_file_count — int(11)
- file_link_key — varchar(512)
- post_priority — varchar(4)
- user_id — varchar(50) — 외래 키 → 웹사용자(판독의, 병원담당자, 영업담당자, 센터담당자).user_key
- board_key (board_key2) — int(11) — 외래 키 → 게시판 설정.board_key
게시판 설정 (board)
- board_key — int(11) — 기본 키 — NOT NULL
- board_name — varchar(100)
- board_url — varchar(100)
- board_description — varchar(256)
- board_category_use — varchar(4) — NOT NULL
- board_category_list — varchar(256)
- board_reply_use — varchar(4) — NOT NULL
- board_comment_use — varchar(4) — NOT NULL
- board_use — varchar(4) — NOT NULL
- board_table_id_use — varchar(4) — NOT NULL
- board_table_name_use — varchar(4) — NOT NULL
- board_table_title_use — varchar(4) — NOT NULL
- board_table_hit_use — varchar(4) — NOT NULL
- board_table_registered_datetime_use — varchar(4) — NOT NULL
- board_table_updated_datetime_use — varchar(4) — NOT NULL
- board_table_order — varchar(4) — NOT NULL
- board_file_use — varchar(4) — NOT NULL
- board_level_read — varchar(100)
- board_level_write — varchar(100)
- board_level_delete — varchar(100)
- board_create_datetime — timestamp — NOT NULL
관리자 (admin_user)
- admin_key — int(11) — 기본 키 — NOT NULL
- admin_id — varchar(20) — NOT NULL
- admin_name — varchar(50)
- admin_pwd — varchar(500) — NOT NULL
- admin_level — int(10) — NOT NULL
- admin_regis_dttm — timestamp
- admin_edit_dttm — timestamp
댓글 (comment)
- comment_key — int(11) — 기본 키 — NOT NULL
- board_key — int(11)
- comment_depth — int(11)
- comment_group — int(11)
- comment_parent_key — int(11)
- comment_group_order — int(11)
- comment_content — text
- user_name — varchar(50)
- comment_registered_datetime — timestamp — NOT NULL
- comment_updated_datetime — timestamp — NOT NULL
- user_id — varchar(50) — 외래 키 → 웹사용자(판독의, 병원담당자, 영업담당자, 센터담당자).user_key
- post_key (post_key2) — int(11) — 외래 키 → 게시글.post_key
병원(PACS) (INSTITUTION)
- INSTITUTION_KEY — BIGINT — 기본 키 — NOT NULL
- INSTITUTION_NAME — VARCHAR(32)
- INSTITUTION_ADDRESS — VARCHAR(128)
- INSTITUTION_TYPE — VARCHAR(12)
- INSTITUTION_UID — VARCHAR(64) — 외래 키 → 병원(WEB).hospital_key
병원(WEB) (hospital)
- hospital_key — int(11) — 기본 키 — NOT NULL
- hospital_name — varchar(50)
- hospital_code_key — int(11)
- hospital_type — varchar(10)
- hospital_code — varchar(50)
- hospital_contact — varchar(24)
- hospital_fax — varchar(24)
- manager_name — varchar(50)
- manager_hp — varchar(24)
- hospital_email — varchar(100)
- hospital_addr — varchar(256)
- hospital_regis_dttm — timestamp — NOT NULL
- hospital_edit_dttm — timestamp
- active_status — varchar(10)
- center_key — int(11) — 외래 키 → 판독센터.center_key
웹로그 (log_web)
- log_key — bigint(20) — 기본 키 — NOT NULL
- log_type — varchar(24)
- content — varchar(4000)
- save_dttm — timestamp — NOT NULL
- user_id — varchar(50) — 외래 키 → 웹사용자(판독의, 병원담당자, 영업담당자, 센터담당자).user_key
웹사용자 토큰 (token)
- token_key — bigint(20) — 기본 키 — NOT NULL
- user_id — varchar(50) — NOT NULL
- token_value — varchar(400) — NOT NULL
- registration_date — timestamp — NOT NULL
웹사용자(판독의, 병원담당자, 영업담당자, 센터담당자) (user)
- user_key — bigint(20) — 기본 키 — NOT NULL
- user_id — varchar(50)
- user_pwd — varchar(200)
- user_name — varchar(50) — NOT NULL
- user_type — varchar(24) — NOT NULL
- hospital_type — varchar(8)
- hospital_code — varchar(32)
- hospital_contact — varchar(24)
- manager_name — varchar(100)
- manager_hp — varchar(100)
- user_email — varchar(32)
- user_addr — varchar(100)
- user_regis_dttm — timestamp — NOT NULL
- user_edit_dttm — timestamp
- dr_certified_no — varchar(32)
- dr_major_no — varchar(32)
- active_status — varchar(10)
- hospital_code_key — int(11)
- auth_hospital_code — varchar(256) — 외래 키 → 병원(WEB).hospital_key
- center_key — int(11) — 외래 키 → 판독센터.center_key
파일 (file)
- file_key — bigint(20) — 기본 키 — NOT NULL
- file_name — varchar(255)
- file_size — bigint(20)
- file_type — varchar(50)
- file_link_key — varchar(512) — 외래 키 → 게시글.post_key
판독된 검사 (REPORT)
- REPORT_KEY — BIGINT — 기본 키 — NOT NULL
- STUDY_KEY — BIGINT — 외래 키 → 검사.STUDY_KEY — NOT NULL
- INSTITUTION_KEY (INSTITUTION_KEY2) — BIGINT — 외래 키 → 검사.INSTITUTION_KEY — NOT NULL
- APPROVER — BIGINT — 외래 키 → SAINTVIEW 사용자.USER_KEY — NOT NULL
- MERGE_KEY — BIGINT
- READING — VARCHAR(8000)
- CONCLUSION — VARCHAR(4000)
- CREATOR — BIGINT
- DICTATER — BIGINT
- TRANSCRIBER — BIGINT
- APPROVER2 — BIGINT
- CREATE_DTTM — TIMESTAMP
- MODIFIED_DTTM — TIMESTAMP
- MODIFIER — BIGINT
- DICTATE_DTTM — TIMESTAMP
- TRANSCRIBE_DTTM — TIMESTAMP
- APPROVE_DTTM — TIMESTAMP
- APPROVE2_DTTM — TIMESTAMP
- ENCRYPTED — VARCHAR(4)
판독료 (price)
- price_key — int(11) — 기본 키 — NOT NULL
- modality — varchar(100) — NOT NULL
- bodypart — varchar(100) — NOT NULL
- study_desc — varchar(128) — NOT NULL
- price_hp — int(15) — NOT NULL
- price_dr — int(15) — NOT NULL
- price_hp_er — float — NOT NULL
- price_dr_er — float — NOT NULL
- hospital_code — varchar(100) — 외래 키 → 검사.STUDY_KEY — NOT NULL
판독센터 (center)
- center_key — int(11) — 기본 키 — NOT NULL
- center_name — varchar(50)
- center_contact — varchar(24)
- center_fax — varchar(24)
- manager_name — varchar(24)
- manager_hp — varchar(24)
- center_email — varchar(50)
- center_addr — varchar(100)
- center_business_registration_no — varchar(100)
- center_regis_dttm — timestamp — NOT NULL
- center_edit_dttm — timestamp
- active_status — varchar(5)