Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
BloodTestId | int | 4 | null |
|
|
|||||
HasLowerBound | bit | 1 | null |
|
|
|||||
HasUpperBound | bit | 1 | null |
|
|
|||||
CancerSiteId | int | 4 | ((0)) |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_dbo.BloodTestRangeTypeDefinitions | Primary key | Asc/Asc | CancerSiteId + BloodTestId |
IX_BloodTestId | Performance | Asc | BloodTestId |
IX_BloodTestRangeTypeDefinitions_RangeSummary | Performance | Asc/Asc/Asc/Asc | CancerSiteId + BloodTestId + HasUpperBound + HasLowerBound |
IX_CancerSiteId | Performance | Asc | CancerSiteId |
Check Constraints
Constraint Name | Constraint |
---|---|
MustHaveOneBound | ([HasUpperBound]=(1) OR [HasLowerBound]=(1)) |