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