홈즈 AI
테이블 (20)
Instituition
- Institution_key — int — 기본 키 — NOT NULL
- Institution_type — enum — NOT NULL
- Institution_code — varchar — NOT NULL
- Institution_name — varchar — NOT NULL
- Institution_address — varchar — NOT NULL
- manager_name — varchar — NOT NULL
- manager_phone_number — varchar — NOT NULL
- manager_email — varchar — NOT NULL
- expiration_date — datetime
UserFile
- user_file_key — int — 기본 키 — NOT NULL
- user_file_name — varchar — NOT NULL
- user_file_type — varchar — NOT NULL
- user_file_value — varchar — NOT NULL
- user_key — int — NOT NULL
access_log
- access_log_key — bigint — 기본 키 — NOT NULL
- access_user_key — unsigned — NOT NULL
- access_user_id — varchar — NOT NULL
- access_datetime — datetime — NOT NULL
- access_entity — varchar — NOT NULL
- access_entity_key — int — NOT NULL
- access_job — varchar — NOT NULL
- access_ip — varchar — NOT NULL
- access_url — varchar — NOT NULL
- before_data — varchar
- after_data — varchar
- access_reason — varchar
analysis_institution
- analysis_institution_key — int — 기본 키 — NOT NULL
- analysis_institution_code — varchar — NOT NULL
- analysis_institution_name — varchar — NOT NULL
- analysis_institution_address — varchar — NOT NULL
- manager_name — varchar — NOT NULL
- manager_phone_number — varchar — NOT NULL
- manager_email — varchar — NOT NULL
- expiration_date — date
code_group
- code_group_key — int — 기본 키 — NOT NULL
- domain — varchar — NOT NULL
- name — varchar — NOT NULL
code_value
- code_value_key — int — 기본 키 — NOT NULL
- code_group_key — int — NOT NULL
- code — varchar — NOT NULL
- value — varchar — NOT NULL
common_column
- creator_key — int — NOT NULL
- creator_id — varchar(30) — NOT NULL
- creator_name — varchar(30) — NOT NULL
- create_datetime — datetime — NOT NULL
- editor_key — int
- editor_id — varchar(30)
- editor_name — varchar(30)
- edit_datetime — datetime
- remover_key — int
- remover_id — varchar(30)
- remover_name — varchar(30)
- remove_datetime — datetime
- remove_yn — boolean — NOT NULL — default : 0
institution_file
- institution_file_key — int — 기본 키 — NOT NULL
- Institution_key — int — NOT NULL
- institution_type — enum — NOT NULL
- file_name — varchar — NOT NULL
- file_extension — varchar — NOT NULL
- file_path — varchar — NOT NULL
- file_change_name — varchar — NOT NULL
measurement
- measurement_key — int — 기본 키 — NOT NULL — 환자 key와 같을 예정
- patch_sn — varchar — NOT NULL
- physician_name — varchar — NOT NULL
- duration — enum — NOT NULL
- start_datetime — datetime
- end_datetime — datetime
- measurement_status — enum — NOT NULL
measurement_data
medical_institution
- medical_institution_key — int — 기본 키 — NOT NULL
- analysis_institution_key — int — NOT NULL
- medical_institution_code — varchar — NOT NULL
- medical_institution_name — varchar — NOT NULL
- medical_institution_address — varchar — NOT NULL
- manager_name — varchar — NOT NULL
- manager_phone_number — varchar — NOT NULL
- manager_email — varchar — NOT NULL
- expiration_date — date
notice
- notice_key — int — 기본 키 — NOT NULL
- notice_category — varchar — NOT NULL
- notice_title — varchar — NOT NULL
- notice_content — text
past_password
- past_password_key — VARCHAR(255) — 기본 키 — NOT NULL
- pointer — int — NOT NULL
- word1 — varchar — 3개가 있음
patient
- patient_key — int — 기본 키 — NOT NULL
- medical_institution_key — int — NOT NULL
- measurement_code — VARCHAR(255) — NOT NULL — Mediv에서 부여하는 고유 코드
- patient_code — varchar — NOT NULL
- patient_name — varchar — NOT NULL
- patient_birth — datetime — NOT NULL
- patient_sex — int — NOT NULL — 남자 0, 여자 1 (AI와 맞춤)
- patient_height — float — NOT NULL
- patient_weight — float — NOT NULL
- patient_icd_code — string
- patient_chronic_disease — string
report
status_history
- status_hisotry_key — VARCHAR(255) — 기본 키 — NOT NULL
- change_datetime — date — NOT NULL
- before_status — varchar — NOT NULL
- after_status — varchar — NOT NULL
symptom_note
- symptom_note_key — VARCHAR(255) — 기본 키 — NOT NULL
- patient_key — int — NOT NULL
- sypmtom_occur_datetime — datetime — NOT NULL
- symptom_type — 공통코드
- symptom_activity — 공통코드
- hand_written — text
user
- user_key — int — 기본 키 — NOT NULL
- Institution_key — int — NOT NULL
- institution_type — enum — NOT NULL
- user_id — varchar — NOT NULL
- user_password — varchar — NOT NULL
- user_name — varchar — NOT NULL
- user_phone_number — varchar — NOT NULL
- user_email — varchar — NOT NULL
- admin_yn — boolean — NOT NULL
- permission_yn — boolean — NOT NULL
- login_fail_count — int — NOT NULL
- activation_yn — boolean — NOT NULL
- password_change_datetime — date — NOT NULL
- password_change_target_yn — boolean — NOT NULL — 발급 받은 계정의 경우, 임시 비밀번호를 발급받은 경우
- last_login_datetime — date — NOT NULL — 휴면 계정 판단을 위함
- autehtication_yn — boolean — NOT NULL — 6가지가 있음
- past_password_key — int — NOT NULL
user_to_patient
- user_to_patient_key — int — NOT NULL — auto index와 복합 index가 나은지 , 추후 효율성 측면의 고려
- user_part — Enum — NOT NULL — ex) physician, technician
- user_key — int — NOT NULL
- patient_key — int — NOT NULL
시스템
- 논리 — 기관)