SizeUnit

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SizeUnitId int identity 4 √ null
Development.CompletionOccupancySizeSizeUnitId FK_Development_SizeUnitComp R
Development.PlanningOccupancySizeSizeUnitId FK_Development_SizeUnit R
DevelopmentUse.DevelopmentUseSizeUnitId FK_DevelopmentUse_SizeUnit R
InvestmentEvent.PercentageYieldSizeUnitId FK_InvestmentEvent_SizeUnit R
OccupierEvent.OccupierSizeUnitId FK_OccupierEvent_SizeUnit R
OccupierEvent.RentSizeUnitId FK_OccupierEvent_SizeUnitRent R
Portfolio.PortfolioSizeSizeUnitId FK_Portfolio_SizeUnit R
PortfolioMarketSector.PortfolioMarketSectorSizeSizeUnitId FK_PortfolioMarketSector_SizeUnit R
Statistic.ValueSizeUnitId FK_Statistic_SizeUnit R
StatisticField.SizeUnitId FK_StatisticField_SizeUnit R
UnitType nvarchar 100 √ null
UnitName nvarchar 510 √ null
RatioToMetric decimal 20,8 √ null
RatioToImperial decimal 20,8 √ null
IsNet bit 1 ((0))
CurrencyTypeId int 4 √ null
CurrencyType.CurrencyTypeId FK_SizeUnit_CurrencyType R
Description nvarchar 510 √ null
DisplayFormat nvarchar 510 √ null
IsActive bit 1 √ null
Version int 4 √ null
CreatedBy nvarchar 510 √ null
CreatedByDate datetime 16,3 √ null
ValidFrom datetime 16,3 √ null
ValidTo datetime2 54 √ null
SortIndex int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_SizeUnitId Primary key Asc SizeUnitId

Relationships

Close relationships within degrees of separation