Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
USER_ID | int | 4 | null |
|
|
|||
USER_NAME | varchar | 50 | √ | null |
|
|
||
PASSWORD | varchar | 50 | null |
|
|
|||
NAME | varchar | 50 | √ | null |
|
|
||
LOCATION | varchar | 50 | √ | null |
|
|
||
TRUST_CODE | varchar | 5 | √ | null |
|
|
||
TRUST | nvarchar | 500 | √ | null |
|
|
||
CREATED_DATE | smalldatetime | 16 | √ | null |
|
|
||
ADMIN | int | 4 | √ | null |
|
|
||
BRAIN | int | 4 | √ | null |
|
|
||
BREAST | int | 4 | √ | null |
|
|
||
COLORECTAL | int | 4 | √ | null |
|
|
||
DERMATOLOGY | int | 4 | √ | null |
|
|
||
GYNAECOLOGY | int | 4 | √ | null |
|
|
||
HAEMATOLOGY | int | 4 | √ | null |
|
|
||
HEAD_NECK | int | 4 | √ | null |
|
|
||
LUNG | int | 4 | √ | null |
|
|
||
OTHER | int | 4 | √ | null |
|
|
||
PAEDIATRIC | int | 4 | √ | null |
|
|
||
PALLIATIVE_CARE | int | 4 | √ | null |
|
|
||
SARCOMA | int | 4 | √ | null |
|
|
||
UPPER_GI | int | 4 | √ | null |
|
|
||
UROLOGY | int | 4 | √ | null |
|
|
||
MDT_ACCESS | int | 4 | √ | null |
|
|
||
PRINT_LETTERS | int | 4 | √ | null |
|
|
||
CREATED_BY | varchar | 50 | √ | null |
|
|
||
LAST_DATE | smalldatetime | 16 | √ | null |
|
|
||
EXP_DATE | smalldatetime | 16 | √ | null |
|
|
||
DELETED | int | 4 | √ | null |
|
|