tdim_collector
Tables (48)
agent_basic_conf
- agent_basic_conf_id — BIGINT — Primary key — NOT NULL
- conf_form_data — TEXT
- conf_file_name — VARCHAR(255)
- agent_version — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
agent_bootstrap
- bootstrap_id — BIGINT — Primary key — NOT NULL
- resource_id — BIGINT — NOT NULL
- datacenter_id — BIGINT — NOT NULL
- action — VARCHAR(10) — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
- result_code — VARCHAR(10)
- result_message — VARCHAR(1024)
- message_code — VARCHAR(10)
- agent_version — VARCHAR(100)
- ia_job_id — BIGINT
- template_names — VARCHAR(1024) — pipe-separated (legacy: tmplat_nm)
- template_seqs — VARCHAR(256) — pipe-separated (legacy: tmplat_seq)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
agent_node_status_history
- history_id — BIGINT — Primary key — NOT NULL
- resource_id — BIGINT — NOT NULL
- agent_conf_id — BIGINT
- resource_status_code — VARCHAR(4)
- check_begin_at — DATETIME
- check_end_at — DATETIME
- response_time_ms — INT
- heartbeat_check_status — VARCHAR(50)
- agent_initial_check_status — VARCHAR(50)
- cpu_collect_item_status — VARCHAR(50)
- occurred_at — DATETIME
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
agent_resource_status
- resource_id — BIGINT — Primary key — NOT NULL
- agent_conf_id — BIGINT
- resource_status_code — VARCHAR(4)
- check_begin_at — DATETIME
- check_end_at — DATETIME
- response_time_ms — INT
- heartbeat_check_status — VARCHAR(50)
- agent_initial_check_status — VARCHAR(50)
- cpu_collect_item_status — VARCHAR(50)
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
agent_version
- agent_version_id — BIGINT — Primary key — NOT NULL
- agent_version — VARCHAR(100) — NOT NULL
- tcore_version — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
collect_item
- collect_item_id — BIGINT — Primary key — NOT NULL
- plugin_id — BIGINT — Foreign key → plugin.plugin_id — NOT NULL
- plugin_collect_name_id — BIGINT — Foreign key → plugin_collect_name.plugin_collect_name_id
- item_name — VARCHAR(100) — NOT NULL
- item_name_ko — VARCHAR(255)
- unit — VARCHAR(64)
- description — VARCHAR(1000)
- has_configuration — BOOLEAN — NOT NULL
- data_type — VARCHAR(64) — NOT NULL
- group_name — VARCHAR(100)
- parent_group_name — VARCHAR(100)
- agent_version — INT
- is_enabled — BOOLEAN — NOT NULL
- dimension — VARCHAR(256)
- metric_kind — VARCHAR(32) — NOT NULL
- reference_metric_name — VARCHAR(512)
- display_order — INT
- display_index — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
collect_item_conf_dependency
- collect_item_id — BIGINT — Foreign key → collect_item.collect_item_id — NOT NULL
- dependency_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id — NOT NULL
- default_value — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
collect_item_value_option
- value_option_id — BIGINT — Primary key — NOT NULL
- collect_item_id — BIGINT — Foreign key → collect_item.collect_item_id — NOT NULL
- option_value — VARCHAR(128) — NOT NULL
- option_comment — VARCHAR(256) — ARCHAR(256) NUL
- color — VARCHAR(64)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
common_code
- code_id — VARCHAR(32) — Primary key — NOT NULL
- parent_code_id — VARCHAR(32) — Foreign key → common_code.code_id
- code_name — VARCHAR(100) — NOT NULL
- code_value — VARCHAR(200) — NOT NULL
- description — VARCHAR(300)
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
container
- container_id — BIGINT — Primary key — NOT NULL
- container_name — VARCHAR(50) — NOT NULL
- container_type — VARCHAR(100) — NOT NULL
- status_code — VARCHAR(4) — NOT NULL
- container_order — INT
- check_interval_sec — INT
- image_name — VARCHAR(100)
- host_name — VARCHAR(100)
- cpu_threshold — FLOAT
- memory_threshold — VARCHAR(10)
- cpu_assigned — FLOAT
- memory_assigned — VARCHAR(10)
- is_active — BOOLEAN — NOT NULL
- running_resource_id — BIGINT — Foreign key → target_resource.target_resource_id
- container_resource_id — BIGINT
- kafka_brokers — VARCHAR(200)
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
container_resource_mapping
- container_resource_mapping_id — BIGINT — Primary key — NOT NULL
- container_id — BIGINT — Foreign key → container.container_id — NOT NULL
- target_resource_check_id — BIGINT — Foreign key → target_resource_check.target_resource_check_id — NOT NULL
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
k8s_node_rel
- k8s_node_rel_id — BIGINT — Primary key — NOT NULL
- template_id — BIGINT — Foreign key → template.template_id — NOT NULL
- node_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
metric
- metric_id — INT — Primary key — NOT NULL
- metric_name — VARCHAR(255) — NOT NULL
- metric_name_ko — VARCHAR(100)
- rel_collect_rule_id — BIGINT — Foreign key → statistics_rule.statistics_rule_id
- rel_collect_tmplat_id — BIGINT — Foreign key → template.template_id
- rel_collect_item_id — BIGINT — Foreign key → collect_item.collect_item_id
- type — VARCHAR(20) — NOT NULL
- period — VARCHAR(20)
- data_source — VARCHAR(255)
- field — VARCHAR(255)
- statistics — VARCHAR(20)
- denominator — VARCHAR(255)
- numerator — VARCHAR(255)
- denominator_id — BIGINT
- numerator_id — BIGINT
- dimensions — VARCHAR(100)
- created_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
metric_condition
- condition_id — BIGINT — Primary key — NOT NULL
- metric_id — INT — Foreign key → metric.metric_id — NOT NULL
- condition_name — VARCHAR(100)
- comparison — VARCHAR(10)
- value — VARCHAR(100)
- operator — VARCHAR(10)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
mgmt
- resource_id — BIGINT — Primary key — NOT NULL
- service_type — VARCHAR(20) — Primary key — NOT NULL
- service_port — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
package
- package_id — BIGINT — Primary key — NOT NULL
- package_name — VARCHAR(100) — NOT NULL
- is_remote — BOOLEAN — NOT NULL
- classification — VARCHAR(128)
- package_alias — VARCHAR(128)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
package_collect_item
- package_plugin_id — BIGINT — Foreign key → package_plugin.package_plugin_id — NOT NULL
- collect_item_id — BIGINT — Foreign key → collect_item.collect_item_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
package_plugin
- package_plugin_id — BIGINT — Primary key — NOT NULL
- package_id — BIGINT — Foreign key → package.package_id — NOT NULL
- plugin_id — BIGINT — Foreign key → plugin.plugin_id — NOT NULL
- plugin_alias — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
package_plugin_conf
- package_plugin_conf_id — BIGINT — Primary key — NOT NULL
- package_plugin_id — BIGINT — Foreign key → package_plugin.package_plugin_id — NOT NULL
- plugin_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id — NOT NULL
- conf_value — VARCHAR(1000)
- is_input — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
package_plugin_conf_sub_item
- package_conf_sub_item_id — BIGINT — Primary key — NOT NULL
- package_plugin_conf_id — BIGINT — Foreign key → package_plugin_conf.package_plugin_conf_id — NOT NULL
- plugin_conf_sub_item_id — BIGINT — Foreign key → plugin_conf_sub_item.plugin_conf_sub_item_id — NOT NULL
- conf_name — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(100)
- default_value — TEXT
- data_type — VARCHAR(255)
- group_seq — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
package_plugin_conf_sub_value
- package_plugin_conf_value_id — BIGINT — Foreign key → package_plugin_conf_value.package_plugin_conf_value_id — NOT NULL
- plugin_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id — NOT NULL
- conf_value — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
package_plugin_conf_value
- package_plugin_conf_value_id — BIGINT — Primary key — NOT NULL
- package_plugin_conf_id — BIGINT — Foreign key → package_plugin_conf.package_plugin_conf_id — NOT NULL
- plugin_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id — NOT NULL
- conf_value — VARCHAR(1000)
- conf_kind — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
plugin
- plugin_id — BIGINT — Primary key — NOT NULL
- plugin_name — VARCHAR(100) — NOT NULL
- parent_plugin_id — BIGINT — Foreign key → plugin.plugin_id
- collect_interval — VARCHAR(100)
- is_duplicate_allowed — BOOLEAN — NOT NULL
- agent_version — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
plugin_collect_name
- plugin_collect_name_id — BIGINT — Primary key — NOT NULL
- plugin_id — BIGINT — Foreign key → plugin.plugin_id — NOT NULL
- collect_name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
plugin_collect_tag
- plugin_collect_tag_id — BIGINT — Primary key — NOT NULL
- plugin_collect_name_id — BIGINT — Foreign key → plugin_collect_name.plugin_collect_name_id — NOT NULL
- collect_tag_name — VARCHAR(128) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
plugin_conf
- plugin_conf_id — BIGINT — Primary key — NOT NULL
- plugin_id — BIGINT — Foreign key → plugin.plugin_id — NOT NULL
- parent_plugin_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id
- conf_name — VARCHAR(100) — NOT NULL
- conf_kind — VARCHAR(50)
- is_input — BOOLEAN — NOT NULL
- is_required — BOOLEAN — NOT NULL
- data_type — VARCHAR(100)
- default_value — TEXT
- is_repeatable — BOOLEAN — NOT NULL
- sub_conf_form — TEXT
- agent_version — INT
- conf_group — VARCHAR(32)
- sample_value — TEXT
- description — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
plugin_conf_sub_item
- plugin_conf_sub_item_id — BIGINT — Primary key — NOT NULL
- plugin_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id — NOT NULL
- conf_name — VARCHAR(100) — NOT NULL
- display_name — VARCHAR(100)
- default_value — VARCHAR(1000)
- data_type — VARCHAR(100)
- sample_value — VARCHAR(1000)
- description — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
request_failure
- request_failure_id — BIGINT — Primary key — NOT NULL
- resource_id — BIGINT
- api_url — VARCHAR(512) — NOT NULL
- request_time — DATETIME — NOT NULL
- request_body — LONGTEXT
- response_code — VARCHAR(32)
- response_body — LONGTEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
resource_collect_item
- resource_collect_item_id — BIGINT — Primary key — NOT NULL
- resource_plugin_id — BIGINT — Foreign key → resource_plugin.resource_plugin_id — NOT NULL
- collect_item_id — BIGINT — Foreign key → collect_item.collect_item_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
resource_collect_item_conf
- resource_collect_item_conf_id — BIGINT — Primary key — NOT NULL
- resource_plugin_id — BIGINT — Foreign key → resource_plugin.resource_plugin_id — NOT NULL
- plugin_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id — NOT NULL
- conf_value — VARCHAR(200)
- source_conf_dtl_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
resource_collect_item_conf_sub_item
- resource_conf_sub_item_id — BIGINT — Primary key — NOT NULL
- resource_collect_item_conf_id — BIGINT — Foreign key → resource_collect_item_conf.resource_collect_item_conf_id — NOT NULL
- plugin_conf_sub_item_id — BIGINT — Foreign key → plugin_conf_sub_item.plugin_conf_sub_item_id — NOT NULL
- conf_name — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(100)
- conf_value — TEXT
- default_value — TEXT
- data_type — VARCHAR(255)
- group_seq — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
resource_collect_target
- resource_collect_target_id — BIGINT — Primary key — NOT NULL
- application_type — VARCHAR(10) — NOT NULL — template | package
- group_id — BIGINT — NOT NULL — template_id 또는 package_id (legacy: colct_compstn_grp_id)
- tcore_id — VARCHAR(255) — NOT NULL
- id_type — VARCHAR(10) — NOT NULL — NODE | GROUP
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
resource_plugin
- resource_plugin_id — BIGINT — Primary key — NOT NULL
- resource_collect_target_id — BIGINT — Foreign key → resource_collect_target.resource_collect_target_id — NOT NULL
- plugin_component_type — VARCHAR(10) — NOT NULL — template | package
- plugin_dtl_id — BIGINT — NOT NULL — template_plugin_id 또는 package_plugin_id (legacy: plugin_dtl_id)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
resource_plugin_conf_file
- resource_plugin_conf_file_id — BIGINT — Primary key — NOT NULL
- tcore_id — VARCHAR(100) — NOT NULL
- id_type — VARCHAR(10) — NOT NULL — NODE | GROUP
- plugin_id — BIGINT — Foreign key → plugin.plugin_id — NOT NULL
- conf_form_data — TEXT
- conf_file_name — VARCHAR(255)
- is_enabled — BOOLEAN — NOT NULL
- is_remote — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
statistics_column_rule
- statistics_column_rule_id — BIGINT — Primary key — NOT NULL
- statistics_rule_id — BIGINT — Foreign key → statistics_rule.statistics_rule_id — NOT NULL
- field_name — VARCHAR(64)
- field_type — VARCHAR(10) — NOT NULL
- field_index — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
statistics_rule
- statistics_rule_id — BIGINT — Primary key — NOT NULL
- template_id — BIGINT — Foreign key → template.template_id
- target_data_source — VARCHAR(100) — NOT NULL
- field_separator — VARCHAR(10)
- supervisor_task_count — BIGINT
- date_format — VARCHAR(30)
- date_index — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
target_resource
- target_resource_id — BIGINT — Primary key — NOT NULL
- datacenter_id — BIGINT — NOT NULL
- resource_ip — VARCHAR(64) — NOT NULL
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
target_resource_check
- target_resource_check_id — BIGINT — Primary key — NOT NULL
- target_resource_id — BIGINT — Foreign key → target_resource.target_resource_id — NOT NULL
- check_type_code — VARCHAR(4) — NOT NULL
- check_port_no — INT — NOT NULL
- check_status_code — VARCHAR(4) — NOT NULL
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
target_resource_check_attribute
- check_attribute_id — BIGINT — Primary key — NOT NULL
- target_resource_check_id — BIGINT — Foreign key → target_resource_check.target_resource_check_id — NOT NULL
- attribute_name — VARCHAR(50) — NOT NULL
- attribute_value — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
template
- template_id — BIGINT — Primary key — NOT NULL
- template_name — VARCHAR(100) — NOT NULL
- classification — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- is_enabled — BOOLEAN — NOT NULL
- equipment_count — INT
- created_by — VARCHAR(100)
- updated_by — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
template_collect_item
- template_plugin_id — BIGINT — Foreign key → template_plugin.template_plugin_id — NOT NULL
- collect_item_id — BIGINT — Foreign key → collect_item.collect_item_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
template_component
- template_component_id — BIGINT — Primary key — NOT NULL
- template_id — BIGINT — Foreign key → template.template_id — NOT NULL
- package_id — BIGINT — Foreign key → package.package_id — NOT NULL
- classification — VARCHAR(256)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
template_plugin
- template_plugin_id — BIGINT — Primary key — NOT NULL
- template_component_id — BIGINT — Foreign key → template_component.template_component_id — NOT NULL
- plugin_id — BIGINT — Foreign key → plugin.plugin_id — NOT NULL
- package_plugin_id — BIGINT — Foreign key → package_plugin.package_plugin_id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
template_plugin_conf
- template_plugin_conf_id — BIGINT — Primary key — NOT NULL
- template_plugin_id — BIGINT — Foreign key → template_plugin.template_plugin_id — NOT NULL
- plugin_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id — NOT NULL
- conf_value — VARCHAR(1000)
- is_input — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
template_plugin_conf_value
- template_plugin_conf_value_id — BIGINT — Primary key — NOT NULL
- template_plugin_conf_id — BIGINT — Foreign key → template_plugin_conf.template_plugin_conf_id — NOT NULL
- plugin_conf_id — BIGINT — Foreign key → plugin_conf.plugin_conf_id — NOT NULL
- conf_value — VARCHAR(1000)
- conf_kind — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
template_plugin_input_conf
- template_input_conf_id — BIGINT — Primary key — NOT NULL
- template_plugin_conf_id — BIGINT — Foreign key → template_plugin_conf.template_plugin_conf_id — NOT NULL
- plugin_conf_sub_item_id — BIGINT — Foreign key → plugin_conf_sub_item.plugin_conf_sub_item_id
- conf_name — VARCHAR(255) — NOT NULL
- conf_value — TEXT
- is_input — BOOLEAN — NOT NULL
- display_name — VARCHAR(100)
- data_type — VARCHAR(255)
- group_seq — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
template_target
- template_target_id — BIGINT — Primary key — NOT NULL
- template_id — BIGINT — Foreign key → template.template_id — NOT NULL
- tcore_id — VARCHAR(255) — NOT NULL
- id_type — VARCHAR(10) — NOT NULL — NODE | GROUP
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_db_metric_preference
- preference_id — BIGINT — Primary key — NOT NULL
- collect_item_id — BIGINT — Foreign key → collect_item.collect_item_id — NOT NULL
- metric_name_ko — VARCHAR(100)
- is_selected — BOOLEAN — NOT NULL
- user_id — INT — NOT NULL
- db_type — VARCHAR(32) — NOT NULL — mysql | altibase
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL