Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
CREATE TABLE "td"."CimLinks" ( "Id" serial NOT NULL, "UniqueCode" text NOT NULL, "StartDate" timestamp without time zone NOT NULL, "EndDate" timestamp without time zone NULL, "Name" text NOT NULL, "SourceClassUniqueCode" text NOT NULL, "TargetClassUniqueCode" text NOT NULL, "TypeId" integer NOT NULL, "CapacityId" integer NOT NULL, CONSTRAINT "PK_CimLinks" PRIMARY KEY ("Id"), CONSTRAINT "FK_CimLinks_CimLinkCapacities_CapacityId" FOREIGN KEY ("CapacityId") REFERENCES "td"."CimLinkCapacities" ("Id") ON DELETE CASCADE, CONSTRAINT "FK_CimLinks_CimLinkTypes_TypeId" FOREIGN KEY ("TypeId") REFERENCES "td"."CimLinkTypes" ("Id") ON DELETE CASCADE );

Stuck with a problem? Got Error? Ask AI support!

Copy Clear