# Placer.ai schema ERD

Table and field reference for the Fivetran Placer.ai connector.

## Table & Field Reference

### sub_entity_visit_by_hour

| Column | Type | Keys |
| --- | --- | --- |
| bins | Unknown | PK |
| end_date | String | PK |
| start_date | String | PK |
| sub_entity_api_id | Unknown | PK, FK |
| estimated_foot_traffic | Unknown |  |
| near_by_radius | Unknown |  |
| visit_duration_segmentation | Unknown |  |

### sub_entity_visit_by_opening_hour

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sub_entity_api_id | Unknown | PK, FK |
| day | Unknown |  |
| from_hour | Unknown |  |
| to_hour | Unknown |  |

### sub_entity

| Column | Type | Keys |
| --- | --- | --- |
| sub_entity_api_id | Unknown | PK |
| entity_api_id | Unknown | PK, FK |
| flagged | Unknown |  |
| name | Unknown |  |
| region_code | Unknown |  |
| region_type | Unknown |  |
| store_id | Unknown |  |

### visit_by_trend

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| api_id | Unknown | PK, FK |
| panel_visit | Unknown |  |
| visit | Unknown |  |
| visit_duration_segmentation | Unknown |  |

### sub_entity_visit_by_trend

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| api_id | Unknown | PK, FK |
| panel_visit | Unknown |  |
| visit | Unknown |  |
| visit_duration_segmentation | Unknown |  |

### visit_by_hour

| Column | Type | Keys |
| --- | --- | --- |
| bins | Unknown | PK |
| end_date | String | PK |
| start_date | String | PK |
| api_id | Unknown | PK, FK |
| estimated_foot_traffic | Unknown |  |
| near_by_radius | Unknown |  |
| visit_duration_segmentation | Unknown |  |

### visit_by_opening_hour

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| api_id | Unknown | PK, FK |
| day | Unknown |  |
| from_hour | Unknown |  |
| to_hour | Unknown |  |

### entity

| Column | Type | Keys |
| --- | --- | --- |
| api_id | Unknown | PK |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_formatted_address | Unknown |  |
| address_short_formatted_address | Unknown |  |
| address_state | Unknown |  |
| address_street_name | Unknown |  |
| address_zip_code | Unknown |  |
| category_info_category | Unknown |  |
| category_info_group | Unknown |  |
| category_info_sub_category | Unknown |  |
| is_flagged | Unknown |  |
| is_permitted | Unknown |  |
| name | Unknown |  |
| parent_chain_api_id | Unknown |  |
| parent_chain_name | Unknown |  |
| parent_tag_api_id | Unknown |  |
| parent_tag_name | Unknown |  |
| placer_url | Unknown |  |
| region_cbsa_code | Unknown |  |
| region_cbsa_name | Unknown |  |
| region_code | Unknown |  |
| region_dma_code | Unknown |  |
| region_dma_name | Unknown |  |
| region_state_code | Unknown |  |
| region_state_name | Unknown |  |
| region_type | Unknown |  |

## Relationships

- sub_entity_visit_by_hour(sub_entity_api_id) → sub_entity(sub_entity_api_id)
- sub_entity_visit_by_opening_hour(sub_entity_api_id) → sub_entity(sub_entity_api_id)
- sub_entity(entity_api_id) → entity(api_id)
- visit_by_trend(api_id) → entity(api_id)
- sub_entity_visit_by_trend(api_id) → sub_entity(sub_entity_api_id)
- visit_by_hour(api_id) → entity(api_id)
- visit_by_opening_hour(api_id) → entity(api_id)