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?