Contents

CREATE TABLE Person (
	-- maybe Person is an Australian and maybe Australian has TFN,
	AustralianTFN                           char(9) NULL,
	-- maybe Person is an Employee and Employee has Employee ID,
	EmployeeID                              int NULL,
	-- Person has Person Name,
	PersonName                              varchar NOT NULL,
	PRIMARY KEY(PersonName)
)
GO

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

CREATE UNIQUE CLUSTERED INDEX IX_AustralianInPersonByAustralianTFN ON dbo.AustralianInPerson_TFN(AustralianTFN)
GO

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

CREATE UNIQUE CLUSTERED INDEX PK_EmployeeInPerson ON dbo.EmployeeInPerson_ID(EmployeeID)
GO

Version data entries

5 entries across 5 versions & 1 rubygems

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