홈즈 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

      시스템

      • 논리 — 기관)