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)