Contents

CREATE TABLE Window (
	-- Window is located in Wall and Wall has Wall Number,
	WallNumber                              int NOT NULL,
	-- Window is located in Wall and Wall is in Room and Room is in Building and Building has Building Number,
	WallRoomBuildingNumber                  int NOT NULL,
	-- Window is located in Wall and Wall is in Room and Room has Room Number,
	WallRoomNumber                          int NOT NULL,
	-- Window has Window Number,
	WindowNumber                            int NOT NULL,
	PRIMARY KEY(WallRoomBuildingNumber, WallRoomNumber, WallNumber, WindowNumber)
)
GO

Version data entries

5 entries across 5 versions & 1 rubygems

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