SQL
CREATE TABLE "project" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"name" varchar(255) NOT NULL,
"type" varchar(36) NOT NULL,
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"icon" text,
"description" VARCHAR(512)
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
varchar(36) |
✓ | Rename | Drop | |
name |
varchar(255) |
Rename | Drop | ||
type |
varchar(36) |
Rename | Drop | ||
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop | ||
icon |
TEXT |
✓ | Rename | Drop | |
description |
VARCHAR(512) |
✓ | Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_project_1 |
id
|
✓ | SQL | Drop |