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