CREATE TABLE "foo" ( "test_id2" varchar(255) FOREIGN KEY("test_id2") REFERENCES "test" ("id2") ); CREATE TABLE "bar" ( "id" int PRIMARY KEY, "foo" varchar(255) ); CREATE TABLE "test_first" ( "testid" int FOREIGN KEY("testid") REFERENCES "foo" ("test_id2"), "test_value" varchar(255) );