Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
Position | int | 4 | null |
|
|
|||
MolecularBiomarkerType | int | 4 | null |
|
|
|||
ID | int | 4 | null |
|
|
|||
PatientID | int | 4 | null |
|
|
|||
NHSNumber | varchar | 10 | √ | null |
|
|
||
HospitalNumber | varchar | 20 | √ | null |
|
|
||
Forename | varchar | 50 | √ | null |
|
|
||
Surname | varchar | 60 | √ | null |
|
|
||
DateOfBirth | date | 20 | √ | null |
|
|
||
Gender | varchar | 50 | √ | null |
|
|
||
GermlineGeneticTestingOffered | varchar | 25 | √ | null |
|
|
||
KeyDate | date | 20 | √ | null |
|
|
||
ReportingOrganisation | nvarchar | 500 | √ | null |
|
|
||
Test | varchar | 100 | √ | null |
|
|
||
OtherTest | varchar | 30 | √ | null |
|
|
||
TestStatus | varchar | 255 | √ | null |
|
|
||
ReferralToClinicalGeneticist | varchar | 25 | √ | null |
|
|
||
Username | varchar | 100 | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors