17 lines
671 B
SQL
17 lines
671 B
SQL
CREATE TABLE runtime_usage (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
runtime_id UUID NOT NULL REFERENCES agent_runtime(id) ON DELETE CASCADE,
|
|
date DATE NOT NULL,
|
|
provider TEXT NOT NULL,
|
|
model TEXT NOT NULL DEFAULT '',
|
|
input_tokens BIGINT NOT NULL DEFAULT 0,
|
|
output_tokens BIGINT NOT NULL DEFAULT 0,
|
|
cache_read_tokens BIGINT NOT NULL DEFAULT 0,
|
|
cache_write_tokens BIGINT NOT NULL DEFAULT 0,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT now(),
|
|
UNIQUE (runtime_id, date, provider, model)
|
|
);
|
|
|
|
CREATE INDEX idx_runtime_usage_runtime_date ON runtime_usage(runtime_id, date DESC);
|