Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
FacilityId | varchar | 10 | √ | null |
|
|
||
EmployeeId | varchar | 20 | √ | null |
|
|
||
FirstName | varchar | 100 | √ | null |
|
|
||
MiddleName | varchar | 100 | √ | null |
|
|
||
LastName | varchar | 100 | √ | null |
|
|
||
Job | varchar | 200 | √ | null |
|
|
||
DOB | date | 6 | √ | null |
|
|
||
Gender | varchar | 100 | √ | null |
|
|
||
Ethnicity | varchar | 100 | √ | null |
|
|
||
Race | varchar | 100 | √ | null |
|
|
||
Status | varchar | 100 | √ | null |
|
|
||
PersonType | varchar | 100 | √ | null |
|
|
||
Address1 | varchar | 200 | √ | null |
|
|
||
Address2 | varchar | 200 | √ | null |
|
|
||
City | varchar | 200 | √ | null |
|
|
||
State | varchar | 100 | √ | null |
|
|
||
Zip | varchar | 20 | √ | null |
|
|
||
HomePhone | varchar | 20 | √ | null |
|
|
||
AVA_insdate | datetime2 | 16 | (getdate()) |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors