ㅇㅇ

Tables (21)

agents

  • id — BIGSERIAL — Primary key — NOT NULL
  • agent_uuid — UUID — NOT NULL
  • application_id — BIGINT — Foreign key → applications.id — NOT NULL
  • agent_key — VARCHAR(100) — NOT NULL
  • hostname — VARCHAR(255)
  • ip — INET
  • jvm_version — VARCHAR(50)
  • agent_version — VARCHAR(50)
  • status — VARCHAR(20) — NOT NULL
  • first_seen_at — TIMESTAMPTZ
  • last_seen_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

alert_channels

  • id — BIGSERIAL — Primary key — NOT NULL
  • alert_channel_uuid — UUID — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • config — JSONB — NOT NULL
  • enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

alert_events

  • id — BIGSERIAL — Primary key — NOT NULL
  • alert_event_uuid — UUID — NOT NULL
  • alert_rule_id — BIGINT — Foreign key → alert_rules.id — NOT NULL
  • agent_id — BIGINT — Foreign key → agents.id
  • fingerprint — VARCHAR(64) — NOT NULL
  • state — VARCHAR(20) — NOT NULL
  • observed_value — NUMERIC(12,4) — NOT NULL
  • metric_kind — VARCHAR(30) — NOT NULL
  • operator — VARCHAR(5) — NOT NULL
  • threshold — NUMERIC(12,4) — NOT NULL
  • window_sec — INT — NOT NULL
  • severity — VARCHAR(20) — NOT NULL
  • fired_at — TIMESTAMPTZ — NOT NULL
  • resolved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

alert_outbox

  • id — BIGSERIAL — Primary key — NOT NULL
  • outbox_uuid — UUID — NOT NULL
  • alert_event_id — BIGINT — Foreign key → alert_events.id — NOT NULL
  • alert_channel_id — BIGINT — Foreign key → alert_channels.id — NOT NULL
  • payload — JSONB — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • attempts — INT — NOT NULL
  • available_at — TIMESTAMPTZ — NOT NULL
  • last_error — TEXT
  • processed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

alert_rule_channels

  • id — BIGSERIAL — Primary key — NOT NULL
  • alert_rule_id — BIGINT — Foreign key → alert_rules.id — NOT NULL
  • alert_channel_id — BIGINT — Foreign key → alert_channels.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

alert_rules

  • id — BIGSERIAL — Primary key — NOT NULL
  • alert_rule_uuid — UUID — NOT NULL
  • application_id — BIGINT — Foreign key → applications.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • metric_kind — VARCHAR(30) — NOT NULL
  • operator — VARCHAR(5) — NOT NULL
  • threshold — NUMERIC(12,4) — NOT NULL
  • window_sec — INT — NOT NULL
  • severity — VARCHAR(20) — NOT NULL
  • enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

application_configs

  • id — BIGSERIAL — Primary key — NOT NULL
  • application_config_uuid — UUID — NOT NULL
  • application_id — BIGINT — Foreign key → applications.id — NOT NULL
  • sampling_rate — NUMERIC(5,4) — NOT NULL
  • version — INT — NOT NULL
  • updated_by — BIGINT — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

applications

  • id — BIGSERIAL — Primary key — NOT NULL
  • application_uuid — UUID — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • display_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

heatmap_1m

  • service_name — LowCardinality(String)
  • bucket — DateTime
  • latency_bucket — UInt16
  • count — UInt64

logs

  • service_name — LowCardinality(String)
  • agent_id — String
  • timestamp — DateTime64(3)
  • level — LowCardinality(String)
  • logger — LowCardinality(String)
  • body — String
  • trace_id — String
  • span_id — String
  • attributes — Map(String, String)
  • timestamp) — TTL

metrics_1h

  • service_name — LowCardinality(String)
  • agent_id — String
  • metric_name — LowCardinality(String)
  • bucket — DateTime
  • count — UInt64
  • sum — Float64
  • min — Float64
  • max — Float64
  • avg — Float64

metrics_1m

  • service_name — LowCardinality(String)
  • agent_id — String
  • metric_name — LowCardinality(String)
  • bucket — DateTime
  • count — UInt64
  • sum — Float64
  • min — Float64
  • max — Float64
  • avg — Float64

metrics_raw

  • service_name — LowCardinality(String)
  • agent_id — String
  • metric_name — LowCardinality(String)
  • timestamp — DateTime
  • value — Float64
  • attributes — Map(String, String)

notification_history

  • id — BIGSERIAL — Primary key — NOT NULL
  • notification_uuid — UUID — NOT NULL
  • alert_event_id — BIGINT — Foreign key → alert_events.id — NOT NULL
  • alert_channel_id — BIGINT — Foreign key → alert_channels.id — NOT NULL
  • result — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • response — TEXT
  • sent_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

server_map_1m

  • from_service — LowCardinality(String)
  • to_service — LowCardinality(String)
  • bucket — DateTime
  • call_count — UInt64
  • error_count — UInt64
  • avg_duration_ms — Float64

service_health_1m

  • service_name — LowCardinality(String)
  • bucket — DateTime
  • request_count — UInt64
  • error_count — UInt64
  • count_4xx — UInt64
  • count_5xx — UInt64
  • p50_state — AggregateFunction(quantile(0.50),
  • p95_state — AggregateFunction(quantile(0.95),
  • p99_state — AggregateFunction(quantile(0.99),

spans

  • service_name — LowCardinality(String)
  • agent_id — String
  • trace_id — String
  • span_id — String
  • parent_span_id — String
  • name — String
  • kind — LowCardinality(String)
  • start_time — DateTime64(9)
  • duration_ns — UInt64
  • http_status — UInt16
  • is_error — UInt8
  • exception_type — LowCardinality(String)
  • exception_message — String
  • stack_trace — String
  • trace_state — String
  • attributes — Map(String, String)
  • trace_id) — TTL

thread_dumps

  • dump_uuid — String
  • service_name — LowCardinality(String)
  • agent_id — String
  • thread_count — UInt32
  • dump — String
  • requested_by — String
  • created_at — DateTime

transactions

  • service_name — LowCardinality(String)
  • agent_id — String
  • trace_id — String
  • url — String
  • start_time — DateTime64(3)
  • duration_ms — UInt32
  • http_status — UInt16
  • is_error — UInt8
  • start_time) — TTL

url_stats_1m

  • service_name — LowCardinality(String)
  • agent_id — String
  • url — String
  • bucket — DateTime
  • call_count — UInt64
  • error_count — UInt64
  • p50_state — AggregateFunction(quantile(0.50),
  • p95_state — AggregateFunction(quantile(0.95),
  • p99_state — AggregateFunction(quantile(0.99),

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_uuid — UUID — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL