chakramax_v4
Tables (50)
apprv_rule_line
- id — INT — Primary key — NOT NULL
- apprv_rule_id — INT — NOT NULL
- apprv_rule_unique_seq — INT — NOT NULL
- wg_id — INT — NOT NULL
- wg_level — INT — NOT NULL
- manager_of_degree — INT — NOT NULL
- req_for_all_member — INT — NOT NULL
- group_apprv — TINYINT — NOT NULL
- apprv_seq — INT — NOT NULL
- condition — TEXT
- rule_line_type — INT
- user_id — INT
- apprv_kind — INT
apprv_safe_sql
- id — INT — Primary key — NOT NULL
- title — TEXT
- req_user_id — INT
- db_type — INT
- type — INT
- tool_name — TEXT
- req_time — INT
- req_comment — TEXT
- apprv_user_id — INT
- apprv_agent_id — INT
- apprv_status — INT
- apprv_time — INT
- admin_id — INT
- admin_approved — TINYINT — NOT NULL
- admin_approved_time — INT
- apprv_comment — TEXT
- sql_type — INT
- sql_text — TEXT
- active_flag — INT
auth_key
- id — INT — NOT NULL
- key_name — CLOB
- key_value — CLOB
- passphrase — CLOB
- key_type — INT
- key_size — INT
- fingerprint — CLOB
- create_time — INT
backup_policy
- id — INT — Primary key — NOT NULL
- schedule_id — INT — NOT NULL
- backup_file_split — INT — NOT NULL
- retry_day — INT
- email_noti — INT — NOT NULL
- run_auto_backup — INT — NOT NULL
- min_backup_space — INT — NOT NULL
- space_unit — INT — NOT NULL
- backup_password — TEXT
- active_flag — INT — NOT NULL
db_application
- id — INT — Primary key — NOT NULL
- name — TEXT — NOT NULL
- exe_file — TEXT — NOT NULL
- version — TEXT — NOT NULL
db_node
- id — INT — Primary key — NOT NULL
- database_id — INT — NOT NULL
- tcp_service_id — INT — NOT NULL
- name — TEXT
- sid — TEXT
- redirect — INT
- keypath — TEXT
- priority — INT
- active_flag — INT
- description — TEXT
exclude_list
- id — BIGINT — Primary key — NOT NULL
- type — INT
- value — TEXT
- update_date — INT
- max_manager_id — INT
- active_flag — INT
holiday
- id — INT — Primary key — NOT NULL
- holiday_name — TEXT
- calendar_id — INT — NOT NULL
- holiday_desc — TEXT
- repeat — INT
- date_type — INT
- year — INT
- month — INT
- day — INT
- week_num — INT
- week_day — INT
holiday_calendar
- key_id — INT — Primary key — NOT NULL
- name — TEXT — NOT NULL
- site_id — INT
- description — TEXT
max_capture_nic_info
- key_id — INT — Primary key — NOT NULL
- max_machine_id — INT — NOT NULL
- name — TEXT
- type — TEXT
- nic_name — TEXT
- group_name — TEXT
- in_out — TEXT
max_config
- key_id — INT — Primary key — NOT NULL
- param — TEXT
- value — TEXT
- value_type — INT
- default_value — TEXT
- category — TEXT
- show_ui — INT
- apply_mode — INT
- description — TEXT
- max_machine_id — INT
max_engine
- key_id — INT — Primary key — NOT NULL
- machine_key_id — INT — NOT NULL
- engine_name — TEXT
- description — TEXT
- engine_type — INT — NOT NULL
- engine_path — TEXT — NOT NULL
- monitoring_flag — INT
- exec_check_flag — INT
- ha_id — INT
- active_flag — INT — NOT NULL
max_machine
- key_id — INT — Primary key — NOT NULL
- name — TEXT — NOT NULL
- description — TEXT — NOT NULL
- os_type_id — INT — NOT NULL
- ip_address — TEXT — NOT NULL
- mac_address — TEXT
- active_flag — INT — NOT NULL
- backup_path — TEXT
- license — TEXT
max_manager_conn_ip
- id — INT — Primary key — NOT NULL
- max_manager_id — INT
- start_ip — TEXT
- end_ip — TEXT
max_schedule
- schedule_id — INT — Primary key — NOT NULL
- machine_key_id — INT — NOT NULL
- description — TEXT
- minute — TEXT — NOT NULL
- hour — TEXT — NOT NULL
- day — TEXT — NOT NULL
- month — TEXT — NOT NULL
- weekday — TEXT — NOT NULL
- script_path — TEXT — NOT NULL
- script_type — INT — NOT NULL
- active_flag — INT — NOT NULL
max_user
- id — INT — Primary key — NOT NULL
- profile_id — INT
- default_workgroup_id — INT
- area_info_id — INT
- company_info_id — INT
- security_level — INT
- name — TEXT
- emp_id — TEXT
- login_id — TEXT
- hr_login_id — TEXT
- password — TEXT
- mc_password — TEXT
- connect_cnt — BIGINT
- tel_no — TEXT
- mobile_no — TEXT
- email_addr — TEXT
- use_email_apprv — TINYINT
- user_kind — INT
- active_flag — INT — NOT NULL
- description — TEXT
- mandate_flag — TINYINT
- mandatee_id — INT
- mandate_start_date — INT
- mandate_end_date — INT
- start_date — INT
- expiry_date — INT
- lock_start_date — INT
- unlocked_date — INT
- pw_changed_date — INT
- pw_changed_by_adm — INT
- first_login_time — INT
- recent_login_time — INT
- recent_logout_time — INT
- pw_error_cnt — TINYINT — NOT NULL
- login_locked_time — INT
- ext_auth_type — INT — NOT NULL
- lock_reason — INT — NOT NULL
- ds_key_id — TEXT
- use_packet_redirect — INT — NOT NULL
- allow_clientless_login — INT — NOT NULL
- is_lookup_real_user — INT — NOT NULL
- allow_multi_login_cnt — INT — NOT NULL
- product_version — TEXT
- reserve1 — TEXT
- reserve2 — TEXT
- reserve3 — TEXT
mfm_config
- key_id — INT — Primary key — NOT NULL
- param — TEXT
- value — TEXT
- tcp_service_type_id — INT — NOT NULL
- description — TEXT
mng_database
- id — INT — Primary key — NOT NULL
- db_name — TEXT
- site_id — INT
- db_user — TEXT
- db_passwd — TEXT
- auth_mode — TEXT
- tns_name — TEXT
- case_sense — INT
- server_manage_acc_flag — INT — NOT NULL
- active_flag — INT
- service_name — TEXT
- manage_db_account — INT — NOT NULL
- calendar_id — INT — NOT NULL
- use_load_balanc_for_rac — INT
- description — TEXT
- is_repository — INT
- dssl_key — TEXT
- audit_stored_object — TINYINT
- use_window_auth — INT
- register — INT
- discovery_result_id — INT
mng_database_account
- id — INT — Primary key — NOT NULL
- database_id — INT — NOT NULL
- db_account — TEXT — NOT NULL
- db_password — TEXT — NOT NULL
mng_server_account
- id — INT — Primary key — NOT NULL
- server_id — INT — NOT NULL
- username — TEXT — NOT NULL
- password — TEXT — NOT NULL
- auth_type — INT
- cert_id — INT
notice
- key_id — INT — Primary key — NOT NULL
- manager_id — INT — NOT NULL
- update_time — INT — NOT NULL
- end_time — INT — NOT NULL
- title — TEXT
- contents — TEXT
password_black_list
- key_id — INT — Primary key — NOT NULL
- black_list — TEXT — NOT NULL
password_rule
- key_id — INT — Primary key — NOT NULL
- param — TEXT — NOT NULL
- value — TEXT — NOT NULL
- value_type — INT — NOT NULL
- default_value — TEXT — NOT NULL
policy_item_group
- id — INT — Primary key — NOT NULL
- name — TEXT — NOT NULL
- site_id — INT
- description — TEXT
- group_type — TINYINT — NOT NULL
- expr_text — TEXT
- expr_for_display — TEXT
- active_flag — TINYINT — NOT NULL
policy_item_group_assign
- pol_item_group_id — INT — Primary key — NOT NULL
- sec_pol_id — BIGINT — Primary key — NOT NULL
- sec_pol_seq — BIGINT — Primary key — NOT NULL
product_version
- version — TEXT — Primary key — NOT NULL
- update_date — timestamp
- description — TEXT
proxy_server
- key_id — INTEGER — Primary key — NOT NULL
- seq_no — INTEGER — Primary key — NOT NULL
- proxy_type — INTEGER — NOT NULL
- name — CHARACTER — NOT NULL
- ip_address — CHARACTER — NOT NULL
- port — INTEGER — NOT NULL
- register_id — INTEGER — NOT NULL
- auth_type — INTEGER — NOT NULL
- auth_entity — CHARACTER
- auth_challenge — CHARACTER
- active_flag — INTEGER — NOT NULL
repository_info
- key_id — INT — Primary key — NOT NULL
- repository_type — INT — NOT NULL
- ha_type — INT
- ip_address — TEXT — NOT NULL
- port — INT — NOT NULL
- db_name — TEXT — NOT NULL
- user_id — TEXT — NOT NULL
- password — TEXT — NOT NULL
- max_machine_id — INT — NOT NULL
- ip_address_alt — TEXT
safe_application
- id — INT — Primary key — NOT NULL
- application_name — TEXT
- exe_file_name — TEXT
- application_version — TEXT
- application_checksum — TEXT
- description — TEXT
- update_date — INT
- update_manager — INT
- active_flag — INT
- request_date — INT
- requester_id — INT
- requester_login_id — TEXT
- requester_name — TEXT
- application_property — TEXT
- application_status — INT — NOT NULL
safe_object
- id — INT
- db_type — INT
- type — INT
- name — TEXT
- apprv_safe_object_id — INT
- req_user_id — INT
- apprv_user_id — INT
- apprv_agent_id — INT
- apprv_time — INT
safe_sql
- id — INT — NOT NULL
- db_type — INT
- type — BIGINT
- sql_type — TINYINT
- sql_text — TEXT
- ori_sql_text — TEXT
- hit_date — INT
- apprv_safe_sql_id — INT
- req_user_id — INT
- apprv_user_id — INT
- apprv_agent_id — INT
- apprv_time — INT
- tool_name — TEXT
sagent_info
- id — INT — Primary key — NOT NULL
- server_id — INT — NOT NULL
- mode — TINYINT — NOT NULL
- cpu_limit — INT — NOT NULL
- max_packet_queue_count — INT — NOT NULL
- sagent_port — INT — NOT NULL
- connection_timeout — INT — NOT NULL
- advance_mode — TINYINT — NOT NULL
- pcap_filter — TEXT
- kill_mode — TINYINT — NOT NULL
- alert_mode — TINYINT — NOT NULL
- ip_policy_mode — INT — NOT NULL
- ports — TEXT
- create_time — INT
- update_time — INT
- delete_time — INT
- status — TINYINT — NOT NULL
- active_flag — TINYINT — NOT NULL
sagent_ip_policy
- id — INT — NOT NULL
- agent_id — INT — NOT NULL
- type — INT — NOT NULL
- site_id — INT
- policy_item_group_id — INT
- ip_addr_from — TEXT — NOT NULL
- ip_addr_to — TEXT — NOT NULL
sec_pol_column
- id — INT — Primary key — NOT NULL
- sec_pol_object_id — INT
- column_name — TEXT
- mask_format — TEXT
- mask_type — TEXT
sec_pol_object
- id — INT — Primary key — NOT NULL
- sec_pol_id — BIGINT
- sec_pol_seq — BIGINT
- object_name — TEXT
sec_pol_pattern
- id — INTEGER — Primary key — NOT NULL
- sec_pol_id — BIGINT
- sec_pol_seq — BIGINT
- pattern_id — INTEGER
- mask_format — CHARACTER
- mask_type — CHARACTER
sensitive_object
- key_id — INT — Primary key — NOT NULL
- pattern_id — INT
- pattern_seq — INT
- apprv_req_id — INT
- apprv_req_user — INT
- register_id — INT
- database_id — INT — NOT NULL
- database_name — TEXT
- schema_name — TEXT
- object_name — TEXT — NOT NULL
- column_name — TEXT
- description — TEXT
- active_flag — INT — NOT NULL
- insert_date — INT
- ad_data_result_data_key_id — INT — NOT NULL
- register_type — INT — NOT NULL
- discovery_type — INT — NOT NULL
- object_type — INT — NOT NULL
sensitive_pattern
- key_id — INT — NOT NULL
- seq_no — INT — NOT NULL
- name — TEXT — NOT NULL
- expression — TEXT — NOT NULL
- register_id — INT — NOT NULL
- nation — INT — NOT NULL
- description — TEXT
- report_masking — INT — NOT NULL
- log_search_masking — INT — NOT NULL
- masking_format — TEXT
- active_flag — INT — NOT NULL
- create_date — INT — NOT NULL
- ordinary_col_names — TEXT
- expression_check_min_length — INT — NOT NULL
- expression_check_max_length — INT — NOT NULL
server
- id — INT — Primary key — NOT NULL
- server_name — TEXT
- site_id — INT
- active_flag — INT
- os_type — INT
- os_name — TEXT
- calendar_id — INT — NOT NULL
- description — TEXT
- is_repository — INT
- discovery_result_id — INT
- manage_server_account — INT — NOT NULL
server_masking_pattern
- key_id — INTEGER — NOT NULL
- name — VARCHAR(100)
- expression — VARCHAR(500)
- description — CHARACTER
- masking_format — VARCHAR(200)
- active_flag — INTEGER — NOT NULL
server_nic_info
- id — INT — Primary key — NOT NULL
- ip_addr — TEXT — NOT NULL
- mac_addr — TEXT
- network_type — INT
- server_id — INT — NOT NULL
- ip_addr_type — INT
- active_flag — INT
- address_type — INT — NOT NULL
- hostname — CHARACTER
service_group
- id — INT — Primary key — NOT NULL
- name — TEXT
- site_id — INT
- active_flag — INT — NOT NULL
site_info
- id — INT — NOT NULL
- name — TEXT — NOT NULL
- description — TEXT
- default_sql_logging_policy — INT
- default_out_logging_policy — INT
- default_calendar_id — INT
- active_flag — INT
tcp_service
- id — INT — Primary key — NOT NULL
- server_id — INT
- service_type — INT
- gateway_port — INT
- output — INT
- char_set — INT
- zip_create — INT
- capture_mode — INT — NOT NULL
- description — TEXT
- service_port — INT
- active_flag — INT
- last_hit_date — INT
- protocol — TEXT — NOT NULL
- ip_range — TEXT — NOT NULL
- service_version — INT
- expr_text — TEXT
- case_sens — INT
tcp_service_assigned_agent
- id — INT — Primary key — NOT NULL
- agent_id — INT — NOT NULL
- tcp_service_id — INT — NOT NULL
tcp_service_assigned_nic
- id — INT — Primary key — NOT NULL
- tcp_service_id — INT
- server_nic_id — INT
- gateway_port — INT
- service_port — INT
- listen_type — INT
- port_type — INT
- active_flag — INT
user_assigned_db_account
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- mng_db_account_id — INT — NOT NULL
- assign_date — INT
- exit_date — INT
- active_flag — INT
- apprv_req_id — INT
- manager_id — INT
- start_date — INT
- expiry_date — INT
user_assigned_server_account
- id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- mng_server_account_id — INT — NOT NULL
- assign_date — INT
- exit_date — INT
- active_flag — INT
- apprv_req_id — INT
- manager_id — INT
- start_date — INT
- expiry_date — INT
user_profile
- id — INT — Primary key — NOT NULL
- profile_name — TEXT
- concurrent_session — INT — NOT NULL
- acc_valid_period_flag — INT — NOT NULL
- acc_valid_period — INT — NOT NULL
- pw_valid_period_flag — INT — NOT NULL
- pw_valid_period — INT — NOT NULL
- pw_change_first_login — INT — NOT NULL
- to_connectable — INT — NOT NULL
- active_flag — INT — NOT NULL
- description — TEXT
- pw_error_count_flag — TINYINT — NOT NULL
- pw_error_count — TINYINT — NOT NULL
- pw_error_lock_time — INT
- acc_no_used_period_flag — TINYINT — NOT NULL
- acc_no_used_period — INT — NOT NULL
- relogin_after_idle_flag — TINYINT — NOT NULL
- relogin_after_idle_time — INT — NOT NULL
- reauth_supported_extra_auth — TINYINT — NOT NULL
- reauth_only_sess_exec_time_use — TINYINT — NOT NULL
- default_passwd — TEXT
- default_auth_type — TINYINT — NOT NULL
workgroup
- id — INT — Primary key — NOT NULL
- root_parent_wg_id — INT — NOT NULL
- parent_wg_id — INT — NOT NULL
- wg_manager_id — INT
- group_depth — INT — NOT NULL
- wg_security_level — INT
- group_name — TEXT
- hr_group_id — TEXT
- hr_group_name — TEXT
- apprv_trust_active_flag — INT — NOT NULL
- active_flag — INT — NOT NULL
- description — TEXT
- start_date — INT
- expiry_date — INT
- ds_key_id — TEXT
- reserve1 — TEXT
- reserve2 — TEXT
- reserve3 — TEXT
- ext_auth_type — INT