PortfolioMarketSector

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PortfolioMarketSectorId int identity 4 √ null
PortfolioId int 4 √ null
Portfolio.PortfolioId FK_PortfolioMarketSector_Portfolio R
MarketId int 4 √ null
Market.MarketId FK_PortfolioMarketSector_Market R
BuildingTypeId int 4 √ null
BuildingType.BuildingTypeId FK_PortfolioMarketSector_BuildingType R
PropertyCount int 4 √ null
PortfolioMarketSectorSizeNet decimal 20,8 √ null
PortfolioMarketSectorSizeGross decimal 20,8 √ null
PortfolioMarketSectorSizeLocal decimal 20,8 √ null
PortfolioMarketSectorSizeSizeUnitId int 4 √ null
SizeUnit.SizeUnitId FK_PortfolioMarketSector_SizeUnit R
PercentageYield decimal 20,8 √ null
PriceSharePercentage decimal 20,8 √ null
IsPriceManualOverride bit 1 √ null
Locality nvarchar 200 √ null
CountryId int 4 √ null
Country.CountryId FK_PortfolioMarketSector_Country R

Indexes

Constraint Name Type Sort Column(s)
PK_PortfolioMarketSectorId Primary key Asc PortfolioMarketSectorId

Relationships

Close relationships within degrees of separation