Objects


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ObjectNumber int identity 4 √ null
ObjectAccommodation.ObjectNumber FK_ObjectAccommodation_ObjectNumber R
ObjectAttributes.ObjectNumber FK_ObjectAttributes_Objects R
ObjectBookings.ObjectNumber FK_ObjectBookings_Objects R
ObjectElements.ObjectNumber FK_ObjectElements_Objects R
ObjectLoans.ObjectNumber FK_ObjectLoans_Objects R
Objects.ParentObjectNumber FK_Objects_Objects R
ObjectTasks.ObjectNumber FK_ObjectTasks_Objects R
ParentObjectNumber int 4 √ null
Objects.ObjectNumber FK_Objects_Objects R
Description varchar 100 √ ('')
ObjectTypeCategoryCode varchar 15 ('')
Model varchar 50 ('')
Serial varchar 50 ('')
AcquiredDate datetime 16,3 √ null
BarCode varchar 20 ('')
Quantity int 4 ((1))
Room varchar 15 ('')
AssetNumber int 4 √ ((0))
AssetSynDatabaseCode varchar 5 ('')
OwnershipType varchar 15 ('')
Status varchar 15 ('')
ResponsibleID int 4 √ null
Community.ID FK_Objects_Community_ResponsibleID R
LoanedToID int 4 √ null
Community.ID FK_Objects_Community_LoanedToID R
InsurancePolicyCode varchar 15 ('')
InsuranceValue money 21,4 ((0))
InsuranceValuedDate datetime 16,3 √ null
MasterObjectFlag bit 1 ((0))
SystemProcessNumber int 4 √ null
SystemProcessControl.SystemProcessNumber FK_Objects_SystemProcessControl R
ObjectTypesSeq int 4 null
ObjectTypes.ObjectTypesSeq FK_Objects_ObjectTypes R
DefaultChildObjectTypesSeq int 4 √ null
InsurancePoliciesSeq int 4 √ null
InsurancePolicies.InsurancePoliciesSeq FK_Objects_InsurancePolicies R
ActiveFlag bit 1 ((1))
PhoneExtension varchar 15 ('')
OverdueChargeAmount money 21,4 ((0.00))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_Objects Primary key Asc ObjectNumber
AK_Objects_InsurancePoliciesSeq Performance Asc InsurancePoliciesSeq
AK_Objects_ObjectTypesSeq Performance Asc ObjectTypesSeq
AK_Objects_ParentObjectNumber Performance Asc ParentObjectNumber
AK_Objects_Room Performance Asc Room

Relationships

Close relationships within degrees of separation