SQL
CREATE TABLE "MonthConfig" (
"id" TEXT NOT NULL PRIMARY KEY,
"month" TEXT NOT NULL,
"capPerEmployee" INTEGER NOT NULL DEFAULT 800,
"minPoolPerGroup" INTEGER NOT NULL DEFAULT 2000,
"isLocked" BOOLEAN NOT NULL DEFAULT false,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" DATETIME NOT NULL
)
Columns
| Column |
Data type |
Allow null |
Primary key |
Actions |
id |
TEXT |
|
✓ |
read-only
|
month |
TEXT |
|
|
read-only
|
capPerEmployee |
INTEGER |
|
|
read-only
|
minPoolPerGroup |
INTEGER |
|
|
read-only
|
isLocked |
BOOLEAN |
|
|
read-only
|
createdAt |
DATETIME |
|
|
read-only
|
updatedAt |
DATETIME |
|
|
read-only
|
Indexes
| Name |
Columns |
Unique |
SQL |
Drop? |
| MonthConfig_month_key |
month
|
✓ |
SQL
CREATE UNIQUE INDEX "MonthConfig_month_key"
ON "MonthConfig"("month")
|
read-only
|
| sqlite_autoindex_MonthConfig_1 |
id
|
✓ |
SQL
-- no sql found --
|
read-only
|