Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ResidentNumberMRN | varchar | 50 | null |
|
|
|||||
| FirstName | varchar | 100 | √ | null |
|
|
||||
| MiddleName | varchar | 50 | √ | null |
|
|
||||
| LastName | varchar | 100 | √ | null |
|
|
||||
| DateOfBirth | varchar | 30 | √ | null |
|
|
||||
| Gender | varchar | 50 | √ | null |
|
|
||||
| Address1 | varchar | 200 | √ | null |
|
|
||||
| City | varchar | 100 | √ | null |
|
|
||||
| State | varchar | 50 | √ | null |
|
|
||||
| ZipCode | varchar | 50 | √ | null |
|
|
||||
| Phone | varchar | 50 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
