SQL
CREATE TABLE journal (
id INTEGER PRIMARY KEY AUTOINCREMENT,
ts TEXT NOT NULL,
method TEXT NOT NULL,
path TEXT NOT NULL,
query TEXT,
status INTEGER,
duration_ms INTEGER,
client TEXT,
user_agent TEXT,
origin TEXT,
request_body TEXT,
response_body TEXT,
replayable INTEGER DEFAULT 0,
note TEXT
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
INTEGER |
✓ | ✓ | read-only |
ts |
TEXT |
read-only | ||
method |
TEXT |
read-only | ||
path |
TEXT |
read-only | ||
query |
TEXT |
✓ | read-only | |
status |
INTEGER |
✓ | read-only | |
duration_ms |
INTEGER |
✓ | read-only | |
client |
TEXT |
✓ | read-only | |
user_agent |
TEXT |
✓ | read-only | |
origin |
TEXT |
✓ | read-only | |
request_body |
TEXT |
✓ | read-only | |
response_body |
TEXT |
✓ | read-only | |
replayable |
INTEGER |
✓ | read-only | |
note |
TEXT |
✓ | read-only |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|