Hi Andy et al,
I think this is what you wanted?
CREATE SCHEMA "Exists"
GO
CREATE TABLE "Exists".Claimant
(
claimantId INTEGER IDENTITY (1, 1) NOT NULL,
hasUnlistedWorkHistory BIT,
federalAgencyId INTEGER IDENTITY (1, 1),
publicOrganizationId INTEGER,
homeCountry NATIONAL CHARACTER(2),
CONSTRAINT Claimant_PK PRIMARY KEY(claimantId)
)
GO
CREATE TABLE "Exists".PublicOrganization
(
publicOrganizationId INTEGER IDENTITY (1, 1) NOT NULL,
countryCode NATIONAL CHARACTER(2) NOT NULL,
CONSTRAINT PublicOrganization_PK PRIMARY KEY(publicOrganizationId)
)
GO
CREATE TABLE "Exists".Country
(
countryCode NATIONAL CHARACTER(2) NOT NULL,
cost DECIMAL(7,2),
CONSTRAINT Country_PK PRIMARY KEY(countryCode)
)
GO
ALTER TABLE "Exists".Claimant ADD CONSTRAINT Claimant_FK1 FOREIGN KEY (publicOrganizationId) REFERENCES "Exists".PublicOrganization (publicOrganizationId) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE "Exists".Claimant ADD CONSTRAINT Claimant_FK2 FOREIGN KEY (homeCountry) REFERENCES "Exists".Country (countryCode) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
ALTER TABLE "Exists".PublicOrganization ADD CONSTRAINT PublicOrganization_FK FOREIGN KEY (countryCode) REFERENCES "Exists".Country (countryCode) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
Insert into "Exists".Country ('us', 55.00)
Insert into "Exists".country ('fr', 45.00)
Insert into "Exists".Country ('af', 42.00)