SQL

CREATE TABLE tags  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL UNIQUE,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ read-only
name TEXT read-only
created_at DATETIME ✓ read-only

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_tags_1 name ✓ SQL
-- no sql found --
 read-only