SQL

CREATE TABLE "TeamBudget"  (
  "id" TEXT NOT NULL PRIMARY KEY,
  "monthConfigId" TEXT NOT NULL,
  "teamId" TEXT NOT NULL,
  "monthlyIncentive" INTEGER NOT NULL DEFAULT 0,
  "poolContribution" INTEGER NOT NULL DEFAULT 0,
  CONSTRAINT "TeamBudget_monthConfigId_fkey" FOREIGN KEY ("monthConfigId") REFERENCES "MonthConfig" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT "TeamBudget_teamId_fkey" FOREIGN KEY ("teamId") REFERENCES "Team" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ read-only
monthConfigId TEXT read-only
teamId TEXT read-only
monthlyIncentive INTEGER read-only
poolContribution INTEGER read-only

Foreign Keys

Column Destination
teamId Team.id
monthConfigId MonthConfig.id

Indexes

Name Columns Unique SQL Drop?
TeamBudget_monthConfigId_teamId_key
  • monthConfigId
  • teamId
 ✓ SQL 
CREATE UNIQUE INDEX "TeamBudget_monthConfigId_teamId_key"
ON "TeamBudget"("monthConfigId", "teamId")
read-only
sqlite_autoindex_TeamBudget_1 id ✓ SQL
-- no sql found --
 read-only