ObjectTypes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Description varchar 50 ('')
ObjectMeaning varchar 20 ('')
AllowMasterObjectFlag bit 1 ((0))
ObjectTypesSeq int identity 4 √ null
Objects.ObjectTypesSeq FK_Objects_ObjectTypes R
ObjectTypeAttributes.ObjectTypesSeq FK_ObjectTypeAttributes_ObjectTypes R
ObjectTypeCategories.ObjectTypesSeq FK_ObjectTypeCategories_ObjectTypes R
ObjectTypeCategoryAttributes.ObjectTypesSeq FK_ObjectTypeCategoryAttributes_ObjectTypes R
ObjectTypeCategoryElements.ObjectTypesSeq FK_ObjectTypeCategoryElements_ObjectTypes R
ObjectTypeElements.ObjectTypesSeq FK_ObjectTypeElements_ObjectTypes R
ObjectTypes.DefaultChildObjectTypesSeq FK_ObjectTypes_ObjectTypes_DefaultChildObjectTypesSeq R
ObjectTypeTaskStaff.ObjectTypesSeq FK_ObjectTypeTaskStaff_ObjectTypes R
DefaultChildObjectTypesSeq int 4 √ null
ObjectTypes.ObjectTypesSeq FK_ObjectTypes_ObjectTypes_DefaultChildObjectTypesSeq R
ShowInRoomBookingFlag bit 1 ((1))
FeeCodeOverdue varchar 15 ('')

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_ObjectTypes Primary key Asc ObjectTypesSeq

Relationships

Close relationships within degrees of separation