Company

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CompanyId int identity 4 √ null
Company.ParentCompanyId FK_Company_Company R
CompanyFund.CompanyId FK_CompanyFund_Company R
DevelopmentDeveloper.CompanyId FK_DevelopmentDeveloper_Company R
InvestmentCompany.CompanyId FK_InvestmentCompany_Company R
OccupierCompany.CompanyId FK_OccupierCompany_Company R
PortfolioCompany.CompanyId FK_PortfolioCompany_Company R
SchemeCompany.CompanyId FK_SchemeCompany_Company R
CompanyName nvarchar 510 null
Url nvarchar 510 √ null
AddressId int 4 √ null
Address.AddressId FK_Company_Address R
CompanyNumber nvarchar 510 √ null
CountryId int 4 √ null
Country.CountryId FK_Company_Country R
CompanyTypeId int 4 √ null
CompanyType.CompanyTypeId FK_Company_CompanyType R
OfferScore int 4 √ null
ParentCompanyId int 4 √ null
Company.CompanyId FK_Company_Company R
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_CompanyId Primary key Asc CompanyId
IX_Company_PK_Covering Performance Asc CompanyId

Relationships

Close relationships within degrees of separation