Query

cards.db — organisations

SQL

CREATE TABLE organisations  (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  slug TEXT UNIQUE,
  subscription_tier TEXT DEFAULT 'individual',
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
slug TEXT ✓ Rename | Drop
subscription_tier TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_organisations_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_organisations_2 slug ✓ SQL
-- no sql found --
 Drop