Query

cards.db — organisation_settings

SQL

CREATE TABLE organisation_settings  (
  organisation_id TEXT NOT NULL,
  key TEXT NOT NULL,
  value TEXT,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (organisation_id, key),
  FOREIGN KEY (organisation_id) REFERENCES organisations(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
organisation_id TEXT ✓ Rename | Drop
key TEXT ✓ Rename | Drop
value TEXT ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
organisation_id organisations.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_organisation_settings_1
  • organisation_id
  • key
 ✓ SQL
-- no sql found --
 Drop