Portfolio

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PortfolioId int identity 4 √ null
PortfolioCompany.PortfolioId FK_PortfolioCompany_Portfolio R
PortfolioMarketSector.PortfolioId FK_PortfolioMarketSector_Portfolio R
PortfolioScheme.PortfolioId FK_PortfolioScheme_Portfolio R
PortfolioDate date 20 √ null
PortfolioName nvarchar 510 √ null
BuildingTypeId int 4 √ null
BuildingType.BuildingTypeId FK_Portfolio_BuildingType R
InvestmentEventTypeId int 4 √ null
InvestmentEventType.InvestmentEventTypeId FK_Portfolio_InvestmentEventType R
InvestmentEventStatusId int 4 √ null
InvestmentEventStatus.InvestmentEventStatusId FK_Portfolio_InvestmentEventStatus R
InvestmentOwnershipTypeId int 4 √ null
InvestmentOwnershipType.InvestmentOwnershipTypeId FK_Portfolio_InvestmentOwnershipType R
PurchasePriceEUR decimal 20,8 √ null
PurchasePriceGBP decimal 20,8 √ null
PurchasePriceUSD decimal 20,8 √ null
PurchasePriceLocal decimal 20,8 √ null
PurchasePriceCurrencyTypeId int 4 √ null
CurrencyType.CurrencyTypeId FK_Portfolio_CurrencyType R
Yield decimal 20,8 √ null
PropertyCount int 4 √ null
PortfolioSizeNet decimal 20,8 √ null
PortfolioSizeGross decimal 20,8 √ null
PortfolioSizeLocal decimal 20,8 √ null
PortfolioSizeSizeUnitId int 4 √ null
SizeUnit.SizeUnitId FK_Portfolio_SizeUnit R
PortfolioPercentage decimal 20,8 √ null
IsVerified bit 1 ((0))
IsRetired bit 1 ((0))
RetiredDate date 20 √ null
CompletenessScore decimal 20,8 √ null
CompletenessScoreLastCalculated datetime 16,3 √ null
CreatedAt datetime 16,3 √ null
UpdatedAt datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_PortfolioId Primary key Asc PortfolioId

Relationships

Close relationships within degrees of separation