home / bibliothek

person

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updated_at (date)

id ▼ uuid name updated_at deleted_at
1 da1006d50e15370b745ab96c33fc91ad Person 1 2026-11-12T12:35:43.375Z  
2 de4c3808fc4dc1db0419b6235ab35669 Person 2 2026-11-16T14:04:40.555Z  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE person (
  id         INTEGER PRIMARY KEY,
  uuid       TEXT NOT NULL UNIQUE DEFAULT (lower(hex(randomblob(16)))),
  name       TEXT NOT NULL,
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  deleted_at TEXT
);
Powered by Datasette · Queries took 4.361ms