Query

cool-keeper.db — organization

SQL

CREATE TABLE "organization"  (
  `id` text PRIMARY KEY NOT NULL,
  `name` text NOT NULL,
  `slug` text NOT NULL,
  `logo` text,
  `metadata` text,
  `createdAt` integer NOT NULL,
  `updatedAt` integer
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
name TEXT Rename | Drop
slug TEXT Rename | Drop
logo TEXT ✓ Rename | Drop
metadata TEXT ✓ Rename | Drop
createdAt INTEGER Rename | Drop
updatedAt INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
organization_slug_unique slug ✓ SQL 
CREATE UNIQUE INDEX `organization_slug_unique`
ON `organization` (`slug`)
Drop
sqlite_autoindex_organization_1 id ✓ SQL
-- no sql found --
 Drop