· 5 years ago · Oct 06, 2020, 12:28 PM
1CREATE TABLE IF NOT EXISTS "person" (
2 "id" UUID NOT NULL,
3 "type" AS CAST(2 as SMALLINT) PERSISTED,
4 "name" VARCHAR(128) NOT NULL,
5 PRIMARY KEY ("id"),
6 FOREIGN KEY ("id","type") REFERENCES "unit"("id","type")
7);