Contents

CREATE TABLE Marriage (
	-- Marriage is by husband-Person and Person has family-Name,
	HusbandFamilyName                       varchar NOT NULL,
	-- Marriage is by husband-Person and Person has given-Name,
	HusbandGivenName                        varchar NOT NULL,
	-- Marriage is of wife-Person and Person has family-Name,
	WifeFamilyName                          varchar NOT NULL,
	-- Marriage is of wife-Person and Person has given-Name,
	WifeGivenName                           varchar NOT NULL,
	PRIMARY KEY(HusbandGivenName, HusbandFamilyName, WifeGivenName, WifeFamilyName)
)
GO

CREATE TABLE Person (
	-- Person has family-Name,
	FamilyName                              varchar NOT NULL,
	-- Person has given-Name,
	GivenName                               varchar NOT NULL,
	PRIMARY KEY(GivenName, FamilyName)
)
GO

ALTER TABLE Marriage
	ADD FOREIGN KEY (HusbandGivenName, HusbandFamilyName) REFERENCES Person (GivenName, FamilyName)
GO

ALTER TABLE Marriage
	ADD FOREIGN KEY (WifeGivenName, WifeFamilyName) REFERENCES Person (GivenName, FamilyName)
GO

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
activefacts-examples-1.9.9	sql/server/Marriage.sql
activefacts-examples-1.9.8	sql/server/Marriage.sql
activefacts-examples-1.8.0	sql/server/Marriage.sql
activefacts-examples-1.7.2	sql/server/Marriage.sql
activefacts-examples-1.7.1	sql/server/Marriage.sql