Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CT_Snomed_ID | int | 4 | null |
|
|
|||||
| Code | varchar | 10 | null |
|
|
|||||
| Description | varchar | 100 | null |
|
|
|||||
| CT_Desc_Code | bigint | 8 | √ | null |
|
|
||||
| CT_Concept_ID | bigint | 8 | √ | null |
|
|
||||
| CT_Description | varchar | 100 | √ | null |
|
|
||||
| isDeleted | bit | 1 | ((0)) |
|
|
|||||
| IsBCC | bit | 1 | null |
|
|
|||||
| IsNeuroendocrine | bit | 1 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ltblSNOMedCT | Primary key | Asc | CT_Snomed_ID |