Placer.ai
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
day | Unknown | |
from_hour | Unknown | |
to_hour | Unknown |
sub_entity
| Column | Type | Keys |
|---|---|---|
sub_entity_api_id | Unknown | PK |
entity_api_id | Unknown | PKFK |
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 | PKFK |
panel_visit | Unknown | |
visit | Unknown | |
visit_duration_segmentation | Unknown |
sub_entity_visit_by_trend
| Column | Type | Keys |
|---|---|---|
date | Unknown | PK |
api_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 |