ㅇㅇ
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