Market

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MarketId int identity 4 √ null
MarketBoundary.MarketId FK_MarketBoundary_Market R
PortfolioMarketSector.MarketId FK_PortfolioMarketSector_Market R
MarketCode nvarchar 100 null
MarketName nvarchar 510 null
TierTypeId int 4 null
TierType.TierTypeId FK_Market_TierType R
Description nvarchar 1000 √ null
Parent nvarchar 100 √ null
SortIndex int 4 √ null
IsActive bit 1 √ null
Version int 4 √ null
IsPMACoverage bit 1 ((0))
CreatedBy nvarchar 510 √ null
ValidFrom datetime 16,3 √ null
ValidTo datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_MarketId Primary key Asc MarketId
IX_Market_PK_Covering Performance Asc MarketId

Relationships

Close relationships within degrees of separation