Setting the file. One moment.
Subchapter 16.4
agent_budget_spend.mdMarkdown1 KBView on GitHub
CREATE TABLE "agent_budget_spend" ("key" varchar(128) PRIMARY KEY NOT NULL, "totalUsd" real NOT NULL DEFAULT (0), "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), CONSTRAINT "CHK_agent_budget_spend_total_usd_non_negative" CHECK ("totalUsd" >= 0))| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| createdAt | datetime(3) | STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’) | false | |||
| key | varchar(128) | false | ||||
| totalUsd | REAL | 0 | false | |||
| updatedAt | datetime(3) | STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’) | false |
| Name | Type | Definition |
|---|---|---|
| - | CHECK | CHECK (“totalUsd” >= 0) |
| key | PRIMARY KEY | PRIMARY KEY (key) |
| sqlite_autoindex_agent_budget_spend_1 | PRIMARY KEY | PRIMARY KEY (key) |
| Name | Definition |
|---|---|
| sqlite_autoindex_agent_budget_spend_1 | PRIMARY KEY (key) |
erDiagram
"agent_budget_spend" {
datetime_3_ createdAt
varchar_128_ key PK
REAL totalUsd
datetime_3_ updatedAt
}Generated by tbls (opens in a new tab)