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