DMS

Tables (50)

aio_patient

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • aio_user_id — bigint — Foreign key → aio_user.id — NOT NULL
  • profile_id — bigint — NOT NULL
  • patient_id — varchar(255) — NOT NULL

aio_user

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • user_id — bigint — NOT NULL — appio user id
  • client — varchar(50) — NOT NULL
  • oauth_client_id — binary(16) — Foreign key → oauth_client.id — NOT NULL

analyte_info_description

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • language — varchar(50) — NOT NULL
  • analyte_id — varchar(50) — NOT NULL
  • analyte_name — varchar(50)
  • analyte_full_name — varchar(50)
  • description — text

analyte_info_item

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • species_type — varchar(50) — NOT NULL
  • analyte_id — varchar(50) — NOT NULL
  • analyte_name — varchar(50) — NOT NULL
  • analyte_full_name — varchar(50) — NOT NULL
  • ref_range_min — double — NOT NULL
  • ref_range_max — double — NOT NULL
  • ref_range_user — int
  • dynamic_min — double — NOT NULL
  • dynamic_max — double — NOT NULL
  • unit — varchar(10)
  • si_unit — varchar(10)
  • unit_flag — bit(1) — NOT NULL
  • conversion_factor — double — NOT NULL
  • conversion_offset — double — NOT NULL
  • decimal_no — int — NOT NULL
  • si_decimal_no — int — NOT NULL
  • qc_flag — varchar(10)
  • inst_factor_a — double — NOT NULL
  • inst_factor_b — double — NOT NULL
  • loinc — varchar(50) — NOT NULL
  • si_loinc — varchar(50) — NOT NULL
  • serum_hem — double — NOT NULL
  • serum_ict — double — NOT NULL
  • serum_lip — double — NOT NULL

auth_user

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • username — varchar(100) — NOT NULL
  • credentials — varchar(255) — NOT NULL
  • role — varchar(10) — NOT NULL
  • auth_type — varchar(50) — NOT NULL
  • is_active — bit(1) — NOT NULL
  • deleted_at — timestamp

auth_user_authority

  • user_entity_id — bigint — Foreign key → auth_user.id — NOT NULL
  • authorities — varchar(255)

cartridge

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • panel_id — varchar(50) — NOT NULL
  • species_type — varchar(50)
  • panel_name — varchar(50)

console_user

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • email — varchar(255) — NOT NULL
  • name — varchar(50) — NOT NULL
  • role — varchar(10) — NOT NULL
  • department — varchar(50) — NOT NULL
  • is_active — bit(1) — NOT NULL
  • deleted_at — timestamp
  • user_id — bigint — Foreign key → auth_user.id — NOT NULL

console_user_file

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • file_info_id — bigint — Foreign key → file_info.id — NOT NULL
  • console_user_id — bigint — Foreign key → console_user.id — NOT NULL

country

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • code — varchar(50) — NOT NULL
  • name — varchar(50)
  • country_area_id — bigint — Foreign key → country_area.id — NOT NULL

country_area

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • code — varchar(50) — NOT NULL
  • name — varchar(50)

customer_device

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • prod_name — varchar(50)
  • reg_code — varchar(50)
  • serial — varchar(50) — NOT NULL
  • product_at — date
  • device_state — varchar(50)
  • mac — varchar(50) — NOT NULL
  • is_active — bit(1) — NOT NULL
  • deleted_at — timestamp
  • customer_user_id — bigint — Foreign key → customer_user.id — NOT NULL

customer_device_history

  • id — bigint — Primary key — NOT NULL — ㅁㄴㅇ
  • created_at — timestamp
  • updated_at — timestamp
  • email — varchar(255) — NOT NULL
  • device_state — varchar(50) — NOT NULL
  • customer_device_id — bigint — Foreign key → customer_device.id — NOT NULL

customer_email

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • email — varchar(255)
  • verify_code — varchar(10)
  • ip — varchar(50)
  • expired_at — datetime
  • verified_at — datetime

customer_user

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • email — varchar(255) — NOT NULL
  • role — varchar(10) — NOT NULL
  • ip — varchar(50) — NOT NULL
  • is_active — bit(1) — NOT NULL
  • deleted_at — timestamp
  • user_id — bigint — Foreign key → auth_user.id — NOT NULL

customer_user_history

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • email — varchar(255) — NOT NULL
  • customer_user_id — bigint — Foreign key → customer_user.id — NOT NULL

data_init_history

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • path — varchar(255)
  • status — bit(1)
  • checksum — varchar(255)

device

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • reg_code — varchar(50)
  • serial — varchar(50) — NOT NULL
  • product_at — datetime
  • mac — varchar(50) — NOT NULL
  • is_active — bit(1) — NOT NULL
  • prod_name — varchar(50)
  • device_state — varchar(50)
  • deleted_at — timestamp
  • reseller_id — bigint — Foreign key → reseller.id

device_connect

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • state — bit(1)
  • ip — varchar(50)
  • device_id — bigint — Foreign key → device.id

device_error_code

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • code — varchar(10) — NOT NULL
  • level — varchar(10) — NOT NULL
  • language — varchar(50) — NOT NULL
  • title — varchar(255)
  • guide — text
  • version — int

device_file_info

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • date — datetime
  • log_category — varchar(50)
  • log_filename — varchar(50)
  • log_filetype — varchar(50)
  • log_filesize — bigint
  • log_file_id — varchar(50)
  • md5 — varchar(50)
  • file_info_id — bigint — Foreign key → file_info.id — NOT NULL
  • device_id — bigint — Foreign key → device.id — NOT NULL

device_panel_info

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • panel — varchar(50)
  • version — varchar(50)
  • device_id — bigint — Foreign key → device.id — NOT NULL

device_state

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • serial — varchar(50) — NOT NULL
  • state — varchar(50) — NOT NULL
  • device_id — bigint — Foreign key → device.id
  • customer_device_id — bigint — Foreign key → customer_device.id

device_system_info

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • serial — varchar(50)
  • mac — varchar(50)
  • sys — varchar(50)
  • boot — varchar(50)
  • kernel — varchar(50)
  • root_fs — varchar(50)
  • qte — varchar(50)
  • app — varchar(50)
  • dsp — varchar(50)
  • xml — varchar(50)
  • analysis_archive — int
  • control_archive — int
  • last_send_to_pc_date — timestamp
  • last_usb_backup_date — timestamp
  • device_id — bigint — Foreign key → device.id — NOT NULL

dynamic_range

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • analyte_id — varchar(50) — NOT NULL
  • panel_id — varchar(50) — NOT NULL
  • apply_date_from — date — NOT NULL
  • dynamic_min — float
  • dynamic_max — float
  • reagent_version — varchar(50) — NOT NULL

event_log

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • event_type — varchar(50) — NOT NULL
  • action — varchar(50) — NOT NULL
  • message — varchar(255) — NOT NULL
  • state — bit(1) — NOT NULL
  • data — json
  • user_id — bigint — Foreign key → auth_user.id

file_info

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • category — varchar(255) — NOT NULL
  • path — varchar(255) — NOT NULL
  • origin_name — varchar(255) — NOT NULL
  • conv_name — varchar(255) — NOT NULL
  • extension — varchar(255)
  • mime_type — varchar(255)
  • size — bigint — NOT NULL

flyway_schema_history

  • installed_rank — int — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int — NOT NULL
  • success — tinyint(1) — NOT NULL

login_history

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • ip — varchar(50)
  • user_id — bigint — Foreign key → auth_user.id

manager

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • name — varchar(50) — NOT NULL
  • is_active — bit(1) — NOT NULL
  • deleted_at — timestamp

oauth_client

  • id — binary(16) — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • client_name — varchar(50) — NOT NULL
  • client_id — varchar(255) — NOT NULL
  • client_secret — varchar(255) — NOT NULL
  • access_token_time_to_live — bigint
  • refresh_token_time_to_live — bigint

oauth_client_authentication_method

  • oauth_client_entity_id — binary(16) — Foreign key → oauth_client.id — NOT NULL
  • client_authentication_methods — varchar(255)

oauth_client_grant

  • oauth_client_entity_id — binary(16) — Foreign key → oauth_client.id — NOT NULL
  • grants — varchar(255)

oauth_client_redirect_uri

  • oauth_client_entity_id — binary(16) — Foreign key → oauth_client.id — NOT NULL
  • redirect_uris — varchar(255)

oauth_client_scope

  • oauth_client_entity_id — binary(16) — Foreign key → oauth_client.id — NOT NULL
  • scopes — varchar(255)

panel_analyte_relation

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • cartridge_id — bigint — Foreign key → cartridge.id
  • analyte_info_item_id — bigint — Foreign key → analyte_info_item.id

patient

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • patient_id — varchar(255) — NOT NULL
  • device_id — bigint — Foreign key → device.id — NOT NULL

product

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • prod_name — varchar(50)
  • prod_category — varchar(50)
  • prod_type — varchar(50)
  • prod_spare — varchar(50)
  • prod_number_min — varchar(50)
  • prod_number_max — varchar(50)
  • prod_code — varchar(50)
  • is_active — bit(1)

product_date_code

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • prod_year_code — varchar(10)
  • prod_year — varchar(10)

qc_material

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • qc_name — varchar(50) — NOT NULL
  • qc_level — int — NOT NULL
  • qc_lot_number — varchar(50) — NOT NULL
  • qc_value_version — varchar(50) — NOT NULL
  • qc_expired_date — varchar(50) — NOT NULL
  • modifier — varchar(50) — NOT NULL
  • device_id — bigint — Foreign key → device.id

qc_material_analytes

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • analyte_id — varchar(50) — NOT NULL
  • qc_name — varchar(50) — NOT NULL
  • qc_level — int — NOT NULL
  • qc_lot_number — varchar(50) — NOT NULL
  • mean — double — NOT NULL
  • sd — double — NOT NULL
  • min — double — NOT NULL
  • max — double — NOT NULL
  • rules — varchar(50) — NOT NULL
  • selected_rule — int — NOT NULL
  • qc_value_version — varchar(50) — NOT NULL
  • qc_material_id — bigint — Foreign key → qc_material.id — NOT NULL

reseller

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • name — varchar(50) — NOT NULL
  • is_active — bit(1) — NOT NULL
  • deleted_at — timestamp
  • country_id — bigint — Foreign key → country.id — NOT NULL
  • manager_id — bigint — Foreign key → manager.id

result_summary

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • date — datetime — NOT NULL
  • panel_id — varchar(50) — NOT NULL
  • species_class — varchar(50) — NOT NULL
  • test_type — varchar(50)
  • blood_info — int
  • pc_sync — bit(1)
  • serial_number — varchar(50)
  • available_period — varchar(50)
  • lot_number — varchar(50)
  • error_code — int
  • error_level — varchar(50)
  • operator_id — varchar(50)
  • sex — varchar(255)
  • birth — varchar(255)
  • order_inserted_date — datetime
  • serum_result_hem — double
  • serum_result_ict — double
  • serum_result_lip — double
  • poct_send_flag — varchar(50)
  • weight — double
  • race — varchar(50)
  • species_id — varchar(50)
  • panel_short_name — varchar(50)
  • operator_row_id — int
  • age — varchar(255)
  • client_id — varchar(50)
  • specimen_type — varchar(50)
  • app_sw_ver — varchar(50)
  • sys_sw_ver — varchar(50)
  • xml_sw_ver — varchar(50)
  • serum_index_hem — varchar(50)
  • serum_index_ict — varchar(50)
  • serum_index_lip — varchar(50)
  • reagent_version — varchar(50)
  • recalcable — int
  • method — varchar(50) — NOT NULL
  • patient_id — bigint — Foreign key → patient.id
  • device_id — bigint — Foreign key → device.id — NOT NULL
  • encrypted_patient_id — varchar(255) — NOT NULL

rm_msg

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • date — datetime
  • msg_code — varchar(50)
  • msg — varchar(50)
  • category — varchar(50) — NOT NULL
  • exam_id — varchar(50)
  • exam_date — datetime
  • view_log — varchar(50)
  • temperature_file — varchar(50)
  • sent — bit(1)
  • panel_type — varchar(50)
  • control_type — int
  • error_log_session — varchar(50)
  • error_title — varchar(255)
  • error_guide — text
  • log_file_id — varchar(50)
  • device_id — bigint — Foreign key → device.id — NOT NULL

self_test

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • date — datetime — NOT NULL
  • canceled — bit(1) — NOT NULL
  • app_sw_ver — varchar(255)
  • sys_sw_ver — varchar(255)
  • xml_sw_ver — varchar(255)
  • etc — text
  • device_id — bigint — Foreign key → device.id — NOT NULL

self_test_result

  • module — varchar(50) — Primary key — NOT NULL
  • self_test_id — bigint — Foreign key → self_test.id — NOT NULL
  • result — varchar(50)

send_mail_history

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • from_email — varchar(255)
  • to_email — varchar(255)
  • subject — varchar(255)
  • content_type — varchar(255)
  • content — text
  • state — bit(1)
  • message_id — varchar(255)

species_feature

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • species_id — varchar(50) — NOT NULL
  • analyte_id — varchar(50) — NOT NULL
  • class — varchar(50)
  • breed — varchar(50)
  • gender — varchar(50)
  • age_min — int
  • age_max — int
  • ref_range_min — double
  • ref_range_max — double
  • ref_range_user — int
  • ref_range_def_min — double
  • ref_range_def_max — double
  • display_position — int
  • is_default_species — bit(1)
  • species_inst_factor_a — double
  • species_inst_factor_b — double
  • is_visible — bit(1)
  • device_id — bigint — Foreign key → device.id — NOT NULL

species_feature_item

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • species_type — varchar(50) — NOT NULL
  • species_id — varchar(50) — NOT NULL
  • analyte_id — varchar(50) — NOT NULL
  • class — varchar(50) — NOT NULL
  • breed — varchar(50)
  • gender — varchar(50)
  • age_min — int
  • age_max — int
  • ref_range_min — double
  • ref_range_max — double
  • ref_range_user — int
  • ref_range_def_min — double
  • ref_range_def_max — double
  • display_position — int
  • is_default_species — bit(1)
  • species_inst_factor_a — double
  • species_inst_factor_b — double
  • is_visible — bit(1)
  • analyte_info_item_id — bigint — Foreign key → analyte_info_item.id

update_history

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • module_name — varchar(50) — NOT NULL
  • update_complete_time — datetime — NOT NULL
  • elapsed_time — varchar(50) — NOT NULL
  • old_version — varchar(50) — NOT NULL
  • new_version — varchar(50) — NOT NULL
  • method — varchar(50) — NOT NULL
  • device_id — bigint — Foreign key → device.id — NOT NULL