Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| facility_id | int | 4 | √ | null |
|
|
||||
| facility_name | varchar | 375 | √ | null |
|
|
||||
| facility_code | varchar | 5 | √ | null |
|
|
||||
| facility_health_type | varchar | 10 | √ | null |
|
|
||||
| facility_type | varchar | 4 | √ | null |
|
|
||||
| facility_city | varchar | 50 | √ | null |
|
|
||||
| facility_state | varchar | 3 | √ | null |
|
|
||||
| facility_zip_code | varchar | 15 | √ | null |
|
|
||||
| facility_region | varchar | 254 | √ | null |
|
|
||||
| patient_id | int | 4 | null |
|
|
|||||
| mds_first_name | varchar | 2000 | √ | null |
|
|
||||
| mds_middle_initial | varchar | 2000 | √ | null |
|
|
||||
| mds_last_name | varchar | 2000 | √ | null |
|
|
||||
| mds_gender | varchar | 2000 | √ | null |
|
|
||||
| mds_ssn | varchar | 2000 | √ | null |
|
|
||||
| medicaid_nbr | varchar | 2000 | √ | null |
|
|
||||
| medicare_nbr | varchar | 2000 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
