Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
CareID | int | 4 | null |
|
|
|||||
CancerSite | varchar | 30 | √ | null |
|
|
||||
SubSite | varchar | 30 | √ | null |
|
|
||||
NHSNumber | varchar | 10 | √ | null |
|
|
||||
HospitalNumber | varchar | 50 | √ | null |
|
|
||||
Surname | varchar | 100 | √ | null |
|
|
||||
Forename | varchar | 100 | √ | null |
|
|
||||
TimedPathwayVersionID | int | 4 | null |
|
|
|||||
TimedPathwayEventID | int | 4 | null |
|
|
|||||
TimedPathwayID | int | 4 | null |
|
|
|||||
TimedPathwayName | varchar | 100 | √ | null |
|
|
||||
VersionNumber | int | 4 | null |
|
|
|||||
TargetRangeStart | int | 4 | √ | null |
|
|
||||
TargetRangeEnd | int | 4 | null |
|
|
|||||
EventDate | date | 20 | √ | null |
|
|
||||
TimedPathwayStartDate | date | 20 | √ | null |
|
|
||||
EventName | varchar | 100 | √ | null |
|
|
||||
Username | varchar | 100 | null |
|
|