Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
USER_ID | int identity | 4 | √ | null |
|
|
||
USER_NAME | varchar | 50 | null |
|
|
|||
PASSWORD | varchar | 50 | null |
|
|
|||
NAME | varchar | 50 | √ | null |
|
|
||
LOCATION | varchar | 50 | √ | null |
|
|
||
TRUST | varchar | 5 | √ | 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 |
|
|
||
CREATED_BY | varchar | 50 | √ | null |
|
|
||
LAST_DATE | smalldatetime | 16 | √ | null |
|
|
||
EXP_DATE | smalldatetime | 16 | √ | null |
|
|
||
DELETED | int | 4 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_tblUSERS | Primary key | Asc | USER_ID |
IX_tblUSERS | Performance | Asc/Asc | USER_NAME + PASSWORD |
Diagram producer might be missing
No diagrams were produced please see application output for any errors