home / bibliothek

comment

0 rows where copy_id = 137

✎ View and edit SQL

This data as json

0 records

CREATE TABLE comment (
  id         INTEGER PRIMARY KEY,
  uuid       TEXT NOT NULL UNIQUE DEFAULT (lower(hex(randomblob(16)))),
  copy_id    INTEGER NOT NULL REFERENCES copy(id),
  body       TEXT NOT NULL,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%d %H:%M','now','localtime')),
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  deleted_at TEXT
);
CREATE INDEX ix_comment_copy ON comment(copy_id);
Powered by Datasette · Queries took 4.548ms