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