+/- table definition

Query 

CREATE TABLE class_students  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  class_id    TEXT NOT NULL,
  child_id    TEXT NOT NULL,
  enrolled_at DATETIME DEFAULT (datetime('now')),
  UNIQUE(class_id, child_id)
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop