SQL

CREATE TABLE "Team"  (
  "id" TEXT NOT NULL PRIMARY KEY,
  "name" TEXT NOT NULL,
  "groupId" TEXT NOT NULL,
  CONSTRAINT "Team_groupId_fkey" FOREIGN KEY ("groupId") REFERENCES "Group" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
)

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ read-only
name TEXT read-only
groupId TEXT read-only

Foreign Keys

Column Destination
groupId Group.id

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_Team_1 id ✓ SQL
-- no sql found --
 read-only