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 |
|
|
||||
PatientID | 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 |
|
|