Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| facility_id | uuid | 2147483647 | √ | null |
|
|
ID of the facility |
|
| facility_name | varchar | 2147483647 | √ | null |
|
|
Name of the facility |
|
| facility_type | varchar | 2147483647 | √ | null |
|
|
Type of the facility (eg. ‘District Hospital’) |
|
| facility_size | varchar | 2147483647 | √ | null |
|
|
Size of the facility (community, small, medium, large) |
|
| facility_region_id | uuid | 2147483647 | √ | null |
|
|
ID of the facility region |
|
| facility_region_name | varchar | 2147483647 | √ | null |
|
|
Name of the facility region. Usually the same as the facility name |
|
| facility_region_slug | varchar | 2147483647 | √ | null |
|
|
Human readable ID of the facility region |
|
| block_region_id | uuid | 2147483647 | √ | null |
|
|
ID of the block region that the facility is in |
|
| block_name | varchar | 2147483647 | √ | null |
|
|
Name of the block region that the facility is in |
|
| block_slug | varchar | 2147483647 | √ | null |
|
|
Human readable ID of the block region that the facility is in |
|
| district_id | uuid | 2147483647 | √ | null |
|
|
ID of the facility group that the facility is in |
|
| district_region_id | uuid | 2147483647 | √ | null |
|
|
ID of the district region that the facility is in |
|
| district_name | varchar | 2147483647 | √ | null |
|
|
Name of the district region that the facility is in |
|
| district_slug | varchar | 2147483647 | √ | null |
|
|
Human readable ID of the district region that the facility is in |
|
| state_region_id | uuid | 2147483647 | √ | null |
|
|
ID of the state region that the facility is in |
|
| state_name | varchar | 2147483647 | √ | null |
|
|
Name of the state region that the facility is in |
|
| state_slug | varchar | 2147483647 | √ | null |
|
|
Human readable ID of the state region that the facility is in |
|
| organization_id | uuid | 2147483647 | √ | null |
|
|
ID of the organization that the facility is in |
|
| organization_region_id | uuid | 2147483647 | √ | null |
|
|
ID of the organization region that the facility is in |
|
| organization_name | varchar | 2147483647 | √ | null |
|
|
Name of the organization region that the facility is in |
|
| organization_slug | varchar | 2147483647 | √ | null |
|
|
Human readable ID of the organization region that the facility is in |
Relationships
Close relationships within degrees of separation
