Contents

CREATE TABLE Person (
	-- maybe Person is a Girl and maybe Girl is going out with Boy and Boy is a kind of Person and Person has Person ID,
	GirlBoyfriendID                         int NULL,
	-- Person is called Name,
	Name                                    varchar NOT NULL,
	-- Person has Person ID,
	PersonID                                int IDENTITY NOT NULL,
	PRIMARY KEY(PersonID),
	FOREIGN KEY (GirlBoyfriendID) REFERENCES Person (PersonID)
)
GO

CREATE VIEW dbo.GirlInPerson_BoyfriendID (GirlBoyfriendID) WITH SCHEMABINDING AS
	SELECT GirlBoyfriendID FROM dbo.Person
	WHERE	GirlBoyfriendID IS NOT NULL
GO

CREATE UNIQUE CLUSTERED INDEX IX_GirlInPersonByGirlBoyfriendID ON dbo.GirlInPerson_BoyfriendID(GirlBoyfriendID)
GO

Version data entries

5 entries across 5 versions & 1 rubygems

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