table|usage_daily|usage_daily|CREATE TABLE usage_daily ( day TEXT NOT NULL CHECK (length(day) = 10), root_id BLOB NOT NULL, tool TEXT NOT NULL, operation TEXT NOT NULL, surface TEXT NOT NULL, host TEXT NOT NULL, principal_kind TEXT NOT NULL, outcome TEXT NOT NULL CHECK (outcome IN ('ok', 'error')), error_code TEXT NOT NULL, calls INTEGER NOT NULL CHECK (calls >= 1), errors INTEGER NOT NULL CHECK (errors >= 0), request_bytes INTEGER NOT NULL CHECK (request_bytes >= 0), response_bytes INTEGER NOT NULL CHECK (response_bytes >= 0), response_tokens_est INTEGER NOT NULL CHECK (response_tokens_est >= 0), latency_ms_sum INTEGER NOT NULL CHECK (latency_ms_sum >= 0), latency_ms_max INTEGER NOT NULL CHECK (latency_ms_max >= 0), retries INTEGER NOT NULL CHECK (retries >= 0), replays INTEGER NOT NULL CHECK (replays >= 0), PRIMARY KEY (day, root_id, tool, operation, surface, host, principal_kind, outcome, error_code) )
