Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| FacilityCode | varchar | 10 | √ | null |
|
|
||||
| FacilityId | int | 4 | √ | null |
|
|
||||
| EmployeeId | varchar | 20 | √ | null |
|
|
||||
| FirstName | varchar | 100 | √ | null |
|
|
||||
| MiddleName | varchar | 100 | √ | null |
|
|
||||
| LastName | varchar | 100 | √ | null |
|
|
||||
| Job | varchar | 200 | √ | null |
|
|
||||
| DOB | varchar | 30 | √ | null |
|
|
||||
| Gender | varchar | 100 | √ | null |
|
|
||||
| Ethnicity | varchar | 100 | √ | null |
|
|
||||
| Race | varchar | 100 | √ | null |
|
|
||||
| Status | varchar | 100 | √ | null |
|
|
||||
| PersonType | varchar | 100 | √ | null |
|
|
||||
| Phone | varchar | 20 | √ | null |
|
|
||||
| Street1 | varchar | 200 | √ | null |
|
|
||||
| Street2 | varchar | 200 | √ | null |
|
|
||||
| City | varchar | 200 | √ | null |
|
|
||||
| State | varchar | 100 | √ | null |
|
|
||||
| Zip | varchar | 20 | √ | null |
|
|
||||
| CovidVaccineType | varchar | 7 | √ | null |
|
|
||||
| CovidVaccineDate1 | date | 6 | √ | null |
|
|
||||
| FirstDoseLotNumber | varchar | 60 | √ | null |
|
|
||||
| FirstDoseExpirationDate | date | 6 | √ | null |
|
|
||||
| CovidVaccineDate2 | date | 6 | √ | null |
|
|
||||
| SecondDoseLotNumber | varchar | 60 | √ | null |
|
|
||||
| SecondDoseExpirationDate | date | 6 | √ | null |
|
|
||||
| CovidVaccineDate3 | date | 6 | √ | null |
|
|
||||
| ThirdDoseLotNumber | varchar | 60 | √ | null |
|
|
||||
| ThirdDoseExpirationDate | date | 6 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
