pc_protector
Tables (21)
audit_log
- idx — int(10) — Primary key — NOT NULL
- manager_id — varchar(30) — NOT NULL
- uri — varchar(200)
- method — varchar(30)
- ip_address — varchar(20)
- create_time — datetime
client
- idx — bigint(20) — Primary key — NOT NULL
- ip_address — varchar(30)
- user_id — varchar(50) — NOT NULL
- pc_name — varchar(100)
- os — varchar(100)
- pc_protector_version — varchar(100)
- vaccine_version — varchar(100)
- check_time — datetime
- create_time — datetime
- update_time — datetime
- wrong_md5 — tinyint(4)
- roles — varchar(50)
- active — bit(1)
- mac_address — varchar(100) — NOT NULL
client_file
- idx — int(10) — Primary key — NOT NULL
- version — varchar(100)
- file_name — varchar(200)
- file_size — varchar(200)
- md5 — varchar(500)
- create_time — datetime
- update_time — datetime
client_history
- idx — bigint(20) — Primary key — NOT NULL
- mac_address — varchar(100) — Primary key — NOT NULL
- ip_address — varchar(30)
- user_id — varchar(50) — NOT NULL
- pc_name — varchar(100)
- os — varchar(100)
- pc_protector_version — varchar(100)
- vaccine_version — varchar(100)
- check_time — datetime
- create_time — datetime
- update_time — datetime
- wrong_md5 — tinyint(4)
- roles — varchar(50)
- active — bit(1)
configuration
- configuration_idx — int(10) — Primary key — NOT NULL
- vaccine_installation_execution — varchar(100)
- vaccine_patch — varchar(100)
- os_with_ms_office_patch — varchar(100)
- hwp_patch — varchar(100)
- password_stability — varchar(100)
- password_change — varchar(100)
- screen_saver — varchar(100)
- shared_folder — varchar(100)
- usb_auto_run — varchar(100)
- over_date_active_x — varchar(100)
- acrobat_security_patch — varchar(100)
- edit_program — varchar(100)
- wireless_lan_card — varchar(100)
- security_usb — varchar(100)
- un_approved_process — varchar(100)
- required_process — varchar(100)
- force_run — tinyint(4)
dashboard_period
- start_date — datetime
- end_date — datetime
db_backup
- set_idx — int(10) — Primary key — NOT NULL
- backup_day_of_week — varchar(100)
- backup_days — varchar(100)
- backup_time — varchar(100)
- delete_cycle — varchar(100)
db_backup_log
- log_idx — int(100) — NOT NULL
- content — varchar(500)
- create_time — datetime
department
- department_idx — int(10) — Primary key — NOT NULL
- code — bigint(20) — NOT NULL
- parent_code — bigint(20)
- name — varchar(100)
- create_tm — datetime
- update_time — datetime
edit_program_check
- idx — int(10) — Primary key — NOT NULL
- ms_word — tinyint(4) — NOT NULL
- ms_power_point — tinyint(4) — NOT NULL
- ms_excel — tinyint(4) — NOT NULL
- hwp — tinyint(4) — NOT NULL
- pdf — tinyint(4) — NOT NULL
manager
- idx — bigint(20) — Primary key — NOT NULL
- id — varchar(20)
- name — varchar(10)
- mobile — varchar(15)
- department — varchar(100)
- department_idx — bigint(20)
- email — varchar(40)
- password — varchar(200)
- roles — varchar(50)
- permissions — varchar(50)
- active — int(11)
- locked — int(10)
next_period_date_configuration
- start_date — date
- end_date — date
period_date_configuration
- idx — int(11) — Primary key — NOT NULL
- period — int(11)
- from_week — int(11)
- from_day — int(11)
- to_week — int(11)
- to_day — int(11)
- apply — tinyint(4)
process
- idx — bigint(20) — Primary key — NOT NULL
- type — varchar(50)
- display_name — varchar(200) — NOT NULL
- registry_item — varchar(200) — NOT NULL
- create_time — datetime
- update_time — datetime
qna
- qna_idx — int(100) — Primary key — NOT NULL
- url — varchar(100)
- title — varchar(100)
- content — mediumtext
- create_time — datetime
- update_time — datetime
security_usb_details
- idx — int(10) — Primary key — NOT NULL
- registry_name — varchar(200)
- process_name — varchar(200)
- run_file_name — varchar(200)
un_approved_details
- idx — int(10) — Primary key — NOT NULL
- policy_idx — int(10) — NOT NULL
- display_name — varchar(200)
unlicensed_program_list
- idx — int(10) — Primary key — NOT NULL
- registry_itme — varchar(100)
- display_name — varchar(100)
- create_time — datetime
user
- idx — bigint(20) — Primary key — NOT NULL
- user_id — varchar(50) — NOT NULL
- name — varchar(255) — NOT NULL
- department — varchar(100) — NOT NULL
- department_idx — bigint(20) — NOT NULL
- email — varchar(50)
- phone — varchar(50)
- create_time — datetime
- update_time — datetime
user_result
- idx — int(10) — Primary key — NOT NULL
- ip_address — varchar(100)
- user_id — varchar(200) — NOT NULL
- score — int(11)
- check_time — datetime — NOT NULL
- create_time — datetime — NOT NULL
- item1_result — int(100) — NOT NULL
- item2_result — int(100) — NOT NULL
- item3_result — int(100) — NOT NULL
- item4_result — int(100) — NOT NULL
- item5_result — int(100) — NOT NULL
- item6_result — int(100) — NOT NULL
- item7_result — int(100) — NOT NULL
- item8_result — int(100) — NOT NULL
- item9_result — int(100) — NOT NULL
- item10_result — int(100) — NOT NULL
- item11_result — int(100) — NOT NULL
- item12_result — int(100) — NOT NULL
- item13_result — int(100) — NOT NULL
- item14_result — int(100) — NOT NULL
- item15_result — int(100) — NOT NULL
- item16_result — int(100) — NOT NULL
- item1_installation_status_check — int(100) — NOT NULL
- item1_execution_status_check — int(100) — NOT NULL
- item2_execution_status_check — int(100) — NOT NULL
- item2_update_status_check — int(100) — NOT NULL
- item3_count — int(100) — NOT NULL
- item4_count — int(100) — NOT NULL
- item10_count — int(100) — NOT NULL
- item5_reasons_vulnerability — int(100) — NOT NULL
- item5_password_length — int(100) — NOT NULL
- item5_detail_reasons — varchar(200) — NOT NULL
- item6_pw_last_change_past_date — int(100) — NOT NULL
- item7_execution_status_check — int(100) — NOT NULL
- item7_pw_usage_status — int(100) — NOT NULL
- item7_period — int(100) — NOT NULL
- in_schedule — bit(1) — NOT NULL
user_result_process
- idx — int(10) — Primary key — NOT NULL
- user_id — varchar(100) — NOT NULL
- ip_address — varchar(100)
- type — varchar(50)
- process_name — varchar(200) — NOT NULL
- check_time — date
- create_time — datetime — NOT NULL