Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CARE_ID | int | 4 | null |
|
|
|||
Cancer Site | varchar | 50 | √ | null |
|
|
||
NHS Number | varchar | 10 | √ | null |
|
|
||
Hospital Number | varchar | 20 | √ | null |
|
|
||
Full Name | varchar | 111 | √ | null |
|
|
||
Clinical Trial Status | varchar | 75 | √ | null |
|
|
||
Consent Date | date | 20 | √ | null |
|
|
||
Reason Not Offered | varchar | 255 | √ | null |
|
|
||
Reason Declined | varchar | 255 | √ | null |
|
|
||
Reason Failed | varchar | 255 | √ | null |
|
|
||
Trial Name | varchar | 255 | √ | null |
|
|
||
Trial Type | varchar | 50 | √ | null |
|
|
||
Local/National Trial | varchar | 50 | √ | null |
|
|
||
Trial Number | varchar | 50 | √ | null |
|
|
||
Regimen | varchar | 255 | √ | null |
|
|
||
Randomised Date | smalldatetime | 16 | √ | null |
|
|
||
Start Date | smalldatetime | 16 | √ | null |
|
|
||
Consultant | varchar | 59 | √ | null |
|
|
||
Investigator | varchar | 255 | √ | null |
|
|
||
Comments | text | 2147483647 | √ | null |
|
|