Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| masterpatientid | int | 4 | √ | null |
|
|
||
| gender | char | 1 | √ | null |
|
|
||
| title | varchar | 254 | √ | null |
|
|
||
| firstname | varchar | 50 | √ | null |
|
|
||
| middlename | varchar | 35 | √ | null |
|
|
||
| lastname | varchar | 50 | √ | null |
|
|
||
| suffix | int | 4 | √ | null |
|
|
||
| dateofbirth | datetime | 16,3 | √ | null |
|
|
||
| ssnumber | varchar | 30 | √ | null |
|
|
||
| education | varchar | 254 | √ | null |
|
|
||
| citizenship | varchar | 254 | √ | null |
|
|
||
| race | varchar | 254 | √ | null |
|
|
||
| religion | varchar | 254 | √ | null |
|
|
||
| maritialstatus | varchar | 254 | √ | null |
|
|
||
| maritalstatus | varchar | 254 | √ | null |
|
|
||
| address1 | varchar | 35 | √ | null |
|
|
||
| address2 | varchar | 35 | √ | null |
|
|
||
| address3 | varchar | 35 | √ | null |
|
|
||
| city | varchar | 50 | √ | null |
|
|
||
| state | varchar | 3 | √ | null |
|
|
||
| country | varchar | 254 | √ | null |
|
|
||
| zipcode | varchar | 15 | √ | null |
|
|
||
| varchar | 75 | √ | null |
|
|
|||
| homephone | varchar | 35 | √ | null |
|
|
||
| primarylanguage | varchar | 254 | √ | null |
|
|
||
| deceaseddate | datetime | 16,3 | √ | null |
|
|
||
| createdby | varchar | 60 | √ | null |
|
|
||
| createddate | datetime | 16,3 | √ | null |
|
|
||
| revisionby | varchar | 60 | √ | null |
|
|
||
| revisiondate | datetime | 16,3 | √ | null |
|
|
||
| deleted | varchar | 1 | √ | null |
|
|
||
| deletedby | varchar | 60 | √ | null |
|
|
||
| deleteddate | datetime | 16,3 | √ | null |
|
|
||
| dss_update_time | datetime | 16,3 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors