GPMS
Tables (65)
admin_clientgrp
- admin_id — varchar(100) — Primary key — NOT NULL
- grp_id — varchar(20) — Primary key — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
admin_connip
- admin_id — varchar(100) — Primary key — NOT NULL
- conn_ip — varchar(200) — Primary key — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
admin_dept
- admin_id — varchar(100) — Primary key — NOT NULL
- dept_cd — varchar(20) — Primary key — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
admin_hist
- admin_id — varchar(100) — Primary key — NOT NULL
- mod_dt — datetime — Primary key — NOT NULL
- admin_nm — varchar(20)
- admin_pw — varchar(255)
- status_cd — varchar(20)
- mod_user_id — varchar(100)
admin_mstr
- admin_id — varchar(100) — Primary key — NOT NULL
- admin_nm — varchar(20)
- admin_pw — varchar(64)
- admin_tp — varchar(2)
- status_cd — varchar(20)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
- polling_cycle — smallint(4)
admin_present
- admin_id — varchar(100) — Primary key — NOT NULL
- reg_dt — datetime
- connect_ip — varchar(25) — NOT NULL
- session_id — varchar(200) — NOT NULL
- duplogin_try_ip — varchar(25)
- duplogin_try_dt — datetime
admin_rules
- admin_id — varchar(100) — Primary key — NOT NULL
- rule_type — varchar(64) — Primary key — NOT NULL
- rule_name — varchar(64) — Primary key — NOT NULL
- has_rule — int(1) — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
client_access
- client_id — varchar(40) — Primary key — NOT NULL
- on_user_id — varchar(100)
- on_last_id — varchar(100)
- on_check_dt — datetime
- local_user_id — varchar(100)
- local_last_id — varchar(100)
- local_check_dt — datetime
- check_dt — datetime
- max_rsp_time — double
- timeout_cnt — int(11)
- polling_time — int(11) — NOT NULL
client_cfg
- client_id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(100) — Primary key — NOT NULL
- pass_phrase — varchar(2000) — NOT NULL
- reg_dt — datetime
client_ext
- client_id — varchar(40) — Primary key — NOT NULL
- prod_no — varchar(100)
- ip — varchar(20)
- os — varchar(100)
- kernel — varchar(100)
- mod_dt — datetime
- safe_score — varchar(20)
- strg_size — bigint(20)
- strg_use — bigint(20)
- local_ip — varchar(20)
client_ext_hist
- client_id — varchar(40) — Primary key — NOT NULL
- mod_dt — datetime — Primary key — NOT NULL
- prod_no — varchar(100)
- ip — varchar(20)
- os — varchar(100)
- kernel — varchar(100)
- safe_score — varchar(20)
client_grp_hist
- hist_seq — int(11) — Primary key — NOT NULL
- chg_tp — varchar(10)
- grp_id — varchar(20) — NOT NULL
- grp_nm — varchar(100)
- upr_grp_id — varchar(20)
- whle_grp_id — varchar(1000)
- grp_level — smallint(3)
- comment — varchar(200)
- reg_client_ip — varchar(100)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
- hist_reg_dt — datetime
- hist_user_id — varchar(100)
client_grp_mstr
- grp_id — varchar(20) — Primary key — NOT NULL
- grp_nm — varchar(100)
- upr_grp_id — varchar(20)
- whle_grp_id — varchar(1000)
- grp_level — smallint(3)
- comment — varchar(200)
- reg_client_ip — varchar(100)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
client_mstr
- client_id — varchar(40) — Primary key — NOT NULL
- client_nm — varchar(200) — NOT NULL
- grp_id — varchar(20) — NOT NULL
- client_ou — varchar(200)
- cert_info — varchar(4000)
- expiration_ymd — varchar(8)
- status_cd — varchar(20)
- comment — varchar(500)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
- serial_no — varchar(50)
client_mstr_hist
- hist_seq — int(11) — Primary key — NOT NULL
- chg_tp — varchar(10)
- client_id — varchar(40) — NOT NULL
- client_nm — varchar(200)
- grp_id — varchar(20)
- client_ou — varchar(200)
- cert_info — varchar(4000)
- expiration_ymd — varchar(8)
- status_cd — varchar(20)
- comment — varchar(500)
- serial_no — varchar(50)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
- hist_reg_dt — datetime
- hist_user_id — varchar(100)
client_package
- client_id — varchar(40) — Primary key — NOT NULL
- package_id — varchar(100) — Primary key — NOT NULL
- package_arch — varchar(100)
- install_ver — varchar(100)
- package_last_ver — varchar(100)
- mod_dt — datetime
client_package_state
- client_id — varchar(40) — Primary key — NOT NULL
- total_cnt — smallint(6)
- update_target_cnt — smallint(6)
- update_mainos_cnt — smallint(6)
- mod_dt — datetime
client_profile_data
- profile_no — varchar(20) — Primary key — NOT NULL
- package_id — varchar(100) — Primary key — NOT NULL
- package_arch — varchar(100)
- install_ver — varchar(100)
- package_last_ver — varchar(100)
- mod_dt — datetime
client_profile_mstr
- profile_no — int(20) — Primary key — NOT NULL
- profile_nm — varchar(100)
- profile_comment — varchar(1000)
- client_id — varchar(40)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
client_regkey
- regkey_no — varchar(40) — Primary key — NOT NULL
- valid_dt — datetime
- expire_dt — datetime
- ip_range — varchar(200)
- comment — varchar(500)
- mod_dt — datetime
- mod_user_id — varchar(100)
- reg_dt — datetime
- reg_user_id — varchar(100)
client_security_state
- client_id — varchar(40) — Primary key — NOT NULL
- boot_protector_dt — datetime
- exe_protector_dt — datetime
- os_protector_dt — datetime
- media_protector_dt — datetime
- client_check_dt — datetime
- confirm_dt — datetime
- confirm_user_id — varchar(100)
- mod_dt — datetime
- boot_protector_act_stop_dt — datetime
- exe_protector_act_stop_dt — datetime
- os_protector_act_stop_dt — datetime
- media_protector_act_stop_dt — datetime
- boot_protector_cnt — int(11) — NOT NULL
- exe_protector_cnt — int(11) — NOT NULL
- os_protector_cnt — int(11) — NOT NULL
- media_protector_cnt — int(11) — NOT NULL
client_security_state_hist
- client_id — varchar(40) — Primary key — NOT NULL
- mod_dt — datetime — Primary key — NOT NULL
- boot_protector_dt — datetime
- exe_protector_dt — datetime
- os_protector_dt — datetime
- media_protector_dt — datetime
- client_check_dt — datetime
- confirm_dt — datetime
- confirm_user_id — varchar(100)
- boot_protector_act_stop_dt — datetime
- exe_protector_act_stop_dt — datetime
- os_protector_act_stop_dt — datetime
- media_protector_act_stop_dt — datetime
ctrl_item_mstr
- obj_id — varchar(40) — Primary key — NOT NULL
- obj_nm — varchar(100)
- mng_obj_tp — varchar(20)
- comment — varchar(500)
- mod_dt — datetime
- mod_user_id — varchar(100)
- reg_dt — datetime
- reg_user_id — varchar(100)
ctrl_item_prop
- obj_id — varchar(40) — Primary key — NOT NULL
- prop_id — varchar(40) — Primary key — NOT NULL
- prop_nm — varchar(100)
- prop_value — mediumtext
- link — varchar(1)
- mod_dt — datetime
- mod_user_id — varchar(100)
- reg_dt — datetime
- reg_user_id — varchar(100)
dept_mstr
- dept_cd — varchar(64) — Primary key — NOT NULL
- dept_nm — varchar(300)
- upr_dept_cd — varchar(64)
- whle_dept_cd — varchar(1000)
- dept_level — smallint(6)
- opt_yn — varchar(1)
- sort_sord — smallint(6)
- expire_dt — datetime
- mod_user_id — varchar(20)
- mod_dt — datetime
- reg_user_id — varchar(20)
- reg_dt — datetime
dept_mstr_hist
- hist_seq — int(11) — Primary key — NOT NULL
- chg_tp — varchar(20)
- dept_cd — varchar(64) — NOT NULL
- dept_nm — varchar(300)
- upr_dept_cd — varchar(64)
- whle_dept_cd — varchar(1000)
- dept_level — smallint(6)
- opt_yn — varchar(1)
- sort_sord — smallint(6)
- expire_dt — datetime
- mod_user_id — varchar(20)
- mod_dt — datetime
- reg_user_id — varchar(20)
- reg_dt — datetime
- hist_reg_dt — datetime
- hist_user_id — varchar(100)
desktop_app_info
- APP_ID — varchar(20) — Primary key — NOT NULL
- APP_NM — varchar(100) — NOT NULL
- APP_INFO — varchar(300)
- APP_GUBUN — varchar(20)
- APP_EXEC — varchar(300)
- MOUNT_URL — varchar(200)
- MOUNT_POINT — varchar(200)
- ICON_GUBUN — varchar(10)
- ICON_ID — varchar(100)
- ICON_URL — varchar(300)
- STATUS_CD — varchar(10) — NOT NULL
- MOD_USER_ID — varchar(100)
- MOD_DT — datetime
- REG_USER_ID — varchar(100)
- REG_DT — datetime
desktop_conf_app
- CONF_ID — varchar(20) — Primary key — NOT NULL
- APP_ID — varchar(20) — Primary key — NOT NULL
- reg_dt — datetime
- reg_user_id — varchar(100)
- APP_ORDER — int(11)
desktop_conf_info
- CONF_ID — varchar(20) — Primary key — NOT NULL
- CONF_NM — varchar(100) — NOT NULL
- CONF_INFO — text
- THEME_ID — int(20)
- MOD_USER_ID — varchar(100)
- MOD_DT — datetime
- REG_USER_ID — varchar(100)
- REG_DT — datetime
file_mstr
- FILE_NO — int(20) — Primary key — NOT NULL
- FILE_NM — varchar(100)
- FILE_TP — varchar(10)
- FILE_PATH — varchar(200)
- FILE_SIZE — varchar(20)
- FILE_ORG_NM — varchar(1000)
- DELETE_YN — varchar(1)
- REG_DT — datetime
- REG_USER_ID — varchar(100)
gcsp_hist
- gcsp_id — varchar(40) — Primary key — NOT NULL
- mod_dt — datetime — Primary key — NOT NULL
- gcsp_nm — varchar(100)
- url — varchar(100)
- ip_ranges — varchar(1000)
- expiration_ymd — varchar(8)
- status_cd — varchar(20)
- comment — varchar(500)
- mod_user_id — varchar(100)
gcsp_mstr
- gcsp_id — varchar(40) — Primary key — NOT NULL
- gcsp_nm — varchar(100)
- status_cd — varchar(20)
- expiration_ymd — varchar(8)
- ip_ranges — varchar(1000)
- url — varchar(100)
- comment — varchar(500)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
- cert — varchar(4000)
- priv — varchar(4000)
- serial_no — varchar(50)
gr_dept_rule_conf
- dept_cd — varchar(64) — Primary key — NOT NULL
- conf_tp — varchar(20) — Primary key — NOT NULL
- conf_id — varchar(20) — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
gr_group_rule_conf
- grp_id — varchar(20) — Primary key — NOT NULL
- conf_tp — varchar(20) — Primary key — NOT NULL
- conf_id — varchar(20) — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
gr_user_rule_conf
- user_id — varchar(100) — Primary key — NOT NULL
- conf_tp — varchar(20) — Primary key — NOT NULL
- conf_id — varchar(20) — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
icon_grp
- grp_id — varchar(20) — Primary key — NOT NULL
- icon_id — varchar(40) — Primary key — NOT NULL
- reg_dt — datetime
- reg_user_id — varchar(100)
icon_grp_mstr
- grp_id — int(20) — Primary key — NOT NULL
- grp_nm — varchar(100)
- grp_cmt — varchar(200)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
icon_mstr
- icon_id — int(20) — Primary key — NOT NULL
- icon_nm — varchar(100)
- icon_cmt — varchar(200)
- file_no — varchar(20)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
- icon_type — varchar(100)
job_mstr
- job_no — int(20) — Primary key — NOT NULL
- job_nm — varchar(100)
- job_tp — varchar(20)
- job_data — varchar(2000)
- reg_user_id — varchar(100)
- reg_dt — datetime
job_mstr_bk
- job_no — int(20) — Primary key — NOT NULL
- job_nm — varchar(100)
- job_tp — varchar(20)
- job_data — varchar(2000)
- reg_user_id — varchar(20)
- reg_dt — datetime
job_trgt
- job_no — int(20) — Primary key — NOT NULL
- client_id — varchar(40) — Primary key — NOT NULL
- job_stat — varchar(20)
- mod_user_id — varchar(100)
- mod_dt — datetime
- result_data — mediumtext
job_trgt_bk
- job_no — int(20) — Primary key — NOT NULL
- client_id — varchar(40) — Primary key — NOT NULL
- mod_dt — datetime — Primary key — NOT NULL
- job_stat — varchar(20)
- mod_user_id — varchar(100)
- result_data — mediumtext
log_admin_act
- log_seq — bigint(20) — Primary key — NOT NULL
- act_tp — varchar(20)
- act_item — varchar(2000)
- act_data — varchar(19000)
- access_ip — varchar(20)
- act_user_id — varchar(100)
- act_dt — datetime
log_general
- log_seq — bigint(20) — Primary key — NOT NULL
- client_id — varchar(40)
- user_id — varchar(100)
- log_tp — varchar(20)
- log_item — varchar(20)
- log_value — mediumtext
- extra_info — varchar(2000)
- reg_dt — varchar(20)
log_security
- log_seq — bigint(20) — Primary key — NOT NULL
- client_id — varchar(40)
- user_id — varchar(100)
- log_item — varchar(20)
- log_tp — varchar(20)
- log_value — mediumtext
- reg_dt — datetime
- log_dt — datetime
- log_level — varchar(20)
- log_code — varchar(20)
- eval_level — varchar(20)
mg_server
- km_ip — varchar(20)
- km_url — varchar(100)
- lm_ip — varchar(20)
- lm_url — varchar(100)
- rm_ip — varchar(20)
- rm_url — varchar(100)
- pm_ip — varchar(20)
- pm_url — varchar(100)
- mod_user_id — varchar(100)
- mod_dt — datetime
mg_server_hist
- km_ip — varchar(20)
- mod_dt — datetime — NOT NULL
- km_url — varchar(100)
- lm_ip — varchar(20)
- lm_url — varchar(100)
- rm_ip — varchar(20)
- rm_url — varchar(100)
- pm_ip — varchar(20)
- pm_url — varchar(100)
- mod_user_id — varchar(100)
notice_instant_alarm
- notice_instant_alarm_id — varchar(20) — Primary key — NOT NULL
- notice_publish_id — varchar(20) — Foreign key → notice_publish.notice_publish_id — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
notice_mstr
- notice_id — varchar(20) — Primary key — NOT NULL
- title — varchar(1000) — NOT NULL
- content — mediumtext
- status_cd — varchar(20)
- reg_user_id — varchar(100)
- reg_dt — datetime
- mod_user_id — varchar(100)
- mod_dt — varchar(45)
notice_publish
- notice_publish_id — varchar(20) — Primary key — NOT NULL
- notice_id — varchar(20) — Foreign key → notice_mstr.notice_id — NOT NULL
- status_cd — varchar(20)
- open_dt — datetime
- close_dt — datetime
- view_type — char(2) — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
- mod_user_id — varchar(100)
- mod_dt — varchar(45)
notice_publish_target
- target_type — char(2) — Primary key — NOT NULL
- target_id — varchar(100) — Primary key — NOT NULL
- notice_publish_id — varchar(20) — Foreign key → notice_publish.notice_publish_id — NOT NULL
- is_child_check — char(1)
- is_show — char(1)
otp
- id — binary(16) — Primary key — NOT NULL
- registered — tinyint(1) — NOT NULL
- secret — varchar(255)
- user_id — binary(16)
package_mstr
- package_id — varchar(100) — Primary key — NOT NULL
- package_arch — varchar(100) — Primary key — NOT NULL
- repo_label — varchar(100)
- package_ver — varchar(100)
- reg_dt — datetime
sequences
- name — varchar(32)
- currval — bigint(20)
site_mstr
- site_id — varchar(10) — Primary key — NOT NULL
- site_name — varchar(100) — NOT NULL
- comment — varchar(500)
- polling_cycle — int(11) — NOT NULL
- server_version — varchar(100) — NOT NULL
- rootdept_cd — varchar(20)
- rootgrp_id — varchar(20)
- status — varchar(3) — NOT NULL
- trial_count — smallint(2)
- lock_time — int(6)
- password_rule — varchar(100)
- enable_duplogin — tinyint(1)
- reg_user — varchar(100)
- reg_dt — datetime
- mod_user — varchar(100)
- mod_dt — datetime
site_mstr_hist
- site_id — varchar(10) — Primary key — NOT NULL
- mod_dt — datetime — Primary key — NOT NULL
- site_name — varchar(100)
- comment — varchar(500)
- polling_cycle — int(11)
- server_version — varchar(100) — NOT NULL
- rootdept_cd — varchar(20)
- rootgrp_id — varchar(20)
- status — varchar(3)
- trial_count — smallint(2)
- lock_time — int(6)
- password_rule — varchar(100)
- enable_duplogin — tinyint(1)
- mod_user — varchar(100)
theme_icon
- theme_id — int(20) — Primary key — NOT NULL
- app_nm — varchar(200) — Primary key — NOT NULL
- file_no — varchar(20) — NOT NULL
- reg_user_id — varchar(100)
- reg_dt — datetime
theme_mstr
- theme_id — int(20) — Primary key — NOT NULL
- theme_nm — varchar(100)
- theme_cmt — varchar(200)
- wallpaper — varchar(200)
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
user_hist
- user_id — varchar(100) — Primary key — NOT NULL
- mod_dt — datetime — Primary key — NOT NULL
- user_nm — varchar(20)
- user_passwd — varchar(256)
- login_id — varchar(20)
- status — varchar(20)
- first_login_dt — datetime
- last_login_dt — datetime
- mod_user_id — varchar(100)
- nfc_secret_data — varchar(64)
- last_passwd_ch_dt — datetime
- user_passwd_status — varchar(20)
user_login_hist
- hist_seq — bigint(20) — Primary key — NOT NULL
- user_id — varchar(100)
- act_tp — varchar(20)
- client_id — varchar(40)
- ip — varchar(20)
- token — varchar(255)
- response_cd — varchar(20)
- reg_dt — datetime
user_mstr
- user_id — varchar(100) — Primary key — NOT NULL
- user_nm — varchar(40)
- user_passwd — varchar(100)
- user_email — varchar(80)
- login_id — varchar(100)
- status — varchar(20)
- first_login_dt — datetime
- last_login_dt — datetime
- nfc_secret_data — varchar(64)
- last_passwd_ch_dt — datetime
- user_passwd_status — varchar(20)
- passwd_expire_dt — datetime
- grade — varchar(100)
- sort_sord — int(11)
- dept_cd — varchar(64)
- client_id — varchar(40)
- expire_dt — datetime
- login_trial — smallint(2)
- login_trial_dt — datetime
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
user_mstr_hist
- hist_seq — int(11) — Primary key — NOT NULL
- chg_tp — varchar(20)
- user_id — varchar(100) — NOT NULL
- user_nm — varchar(40)
- user_passwd — varchar(100)
- login_id — varchar(100)
- status — varchar(20)
- first_login_dt — datetime
- last_login_dt — datetime
- mod_user_id — varchar(100)
- mod_dt — datetime
- reg_user_id — varchar(100)
- reg_dt — datetime
- nfc_secret_data — varchar(64)
- last_passwd_ch_dt — datetime
- user_passwd_status — varchar(20)
- passwd_expire_dt — datetime
- grade — varchar(100)
- sort_sord — int(11)
- dept_cd — varchar(64)
- client_id — varchar(40)
- expire_dt — datetime
- login_trial — smallint(2)
- login_trial_dt — datetime
- user_email — varchar(80)
- hist_reg_dt — datetime
- hist_user_id — varchar(100)
user_opened_notice
- user_id — varchar(100) — Primary key — NOT NULL
- notice_publish_id — varchar(20) — Foreign key → notice_publish.notice_publish_id — NOT NULL
- opened_dt — varchar(45)
user_token
- token — varchar(255) — Primary key — NOT NULL
- user_id — varchar(100)
- expiration_dt — datetime
- status_cd — varchar(20)
- auth_allow_cnt — smallint(6)
- auth_cnt — smallint(6)
- client_id — varchar(40)
- gcsp_id — varchar(20)
- mod_dt — datetime
- gcsp_token — varchar(255)
wallpaper_mstr
- wallpaper_id — int(20) — Primary key — NOT NULL
- wallpaper_nm — varchar(100)
- file_no — varchar(20)
- mod_user_id — varchar(100)
- mod_dt — datetime