Location Table

The Location table stores information about the place where a group meets or an activity takes place. This table has foreign key relationships with the Activity and Group tables. The following illustration shows the column properties of the Location table.

• The LocationId column is the primary key for a location and it is an identity column.
• The Name column contains the name or brief description of a location.
• The Street, City, Region, PostalCode, and Country columns make up the address for a location. These optional fields contain character data and have an nvarchar data type.
• The Phone column contains the telephone number for a location.
• The Email column contains the e-mail address of a location.
• The MaxOccupancy column contains the maximum number of persons allowed in a location. The default value is 50. Any group that has a location must have a maximum size (MaxSize) that is less than or equal to the value of MaxOccupancy. Triggers on Eval Tables describes how this rule is enforced.
• The Comment column contains miscellaneous comments and notes about the location. Its data type is ntext. Eval Database Columns with ntext Data Types describes this data type in detail.