· 5 years ago · Oct 06, 2020, 12:30 PM
1CREATE TABLE IF NOT EXISTS "person" (
2 "id" UUID NOT NULL,
3 "type" SMALLINT NOT NULL DEFAULT 3,
4 "name" VARCHAR(128) NOT NULL,
5 FOREIGN KEY ("id", "type") REFERENCES "unit"("id", "type"),
6 CHECK ("type" = 3)
7);