SchemeCompany

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SchemeCompanyId int identity 4 √ null
SchemeId int 4 √ null
Scheme.SchemeId FK_SchemeCompany_Scheme R
CompanyId int 4 √ null
Company.CompanyId FK_SchemeCompany_Company R
SchemeCompanyRoleId int 4 √ null
SchemeCompanyRole.SchemeCompanyRoleId FK_SchemeCompany_SchemeCompanyRole R
PercentageShare decimal 20,8 √ null
IsUnknown bit 1 ((0))

Indexes

Constraint Name Type Sort Column(s)
PK_SchemeCompanyId Primary key Asc SchemeCompanyId
IX_SchemeCompany_SchemeId Performance Asc SchemeId

Relationships

Close relationships within degrees of separation