OccupierEvent

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OccupierEventId int identity 4 √ null
OccupierCompany.OccupierEventId FK_OccupierCompany_OccupierEvent R
OccupierEvent.ReplaceOccupierEventId FK_OccupierEvent_OccupierEvent R
OccupierEventDescription nvarchar 560 √ null
OccupierEventDate date 20 √ null
SchemeId int 4 √ null
Scheme.SchemeId FK_OccupierEvent_Scheme R
ReplaceOccupierEventId int 4 √ null
OccupierEvent.OccupierEventId FK_OccupierEvent_OccupierEvent R
OccupierEventTypeId int 4 √ null
OccupierEventType.OccupierEventTypeId FK_OccupierEvent_OccupierEventType R
OccupierEventStatusId int 4 √ null
OccupierEventStatus.OccupierEventStatusId FK_OccupierEvent_OccupierEventStatus R
BuildingUseId int 4 √ null
BuildingUse.BuildingUseId FK_OccupierEvent_BuildingUse R
OccupierSizeGross decimal 20,8 √ null
OccupierSizeNet decimal 20,8 √ null
OccupierSizeLocal decimal 20,8 √ null
OccupierSizeUnitId int 4 √ null
SizeUnit.SizeUnitId FK_OccupierEvent_SizeUnit R
RentLocal decimal 20,8 √ null
RentEUR decimal 20,8 √ null
RentGBP decimal 20,8 √ null
RentUSD decimal 20,8 √ null
RentSizeUnitId int 4 √ null
SizeUnit.SizeUnitId FK_OccupierEvent_SizeUnitRent R
LeaseLength int 4 √ null
IsVerified bit 1 null
IsOccupierUnknown bit 1 ((0))
IsRetired bit 1 null
RetiredDate date 20 √ null
CreatedAt datetime 16,3 √ null
UpdatedAt datetime 16,3 √ null
RentFree int 4 √ null
BreakOption nvarchar 30 √ null
CompletenessScore decimal 20,8 √ null
CompletenessScoreLastCalculated datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_OccupierEventId Primary key Asc OccupierEventId

Relationships

Close relationships within degrees of separation