> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/analytics/prodco-analytics/schema-information.md).

# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Prodco Analytics connector:

* [Traffic Daily ](#traffic-daily)
* [Traffic Hourly by Entran](#traffic-hourly-by-entrance)[ce](#traffic-hourly-by-entrance)
* [Sensors](#sensors)

#### Traffic Daily 

The Traffic\_Daily API from Prodco Analytics provides daily traffic-related data and insights. For more information, see [Traffic\_Daily](https://api.prodcotech.com/apidoc/#/TrafficData).

<table><thead><tr><th width="86">Field Name</th><th width="86">Data Type</th></tr></thead><tbody><tr><td>DateTime</td><td>DATETIME</td></tr><tr><td>StoreNo</td><td>STRING</td></tr><tr><td>Traffic</td><td>NUMERIC</td></tr></tbody></table>

#### Traffic Hourly by Entrance&#x20;

The Traffic Hourly API extends the granularity of your store's traffic data to an hourly level.

For more information, see [Traffic\_Hourly\_by\_Entrance](https://api.prodcotech.com/apidoc/#/TrafficData/gethourlytraffic).

<table><thead><tr><th width="86">Field Name</th><th width="86">Data Type</th></tr></thead><tbody><tr><td>DateTime</td><td>DATETIME</td></tr><tr><td>StoreNo</td><td>STRING</td></tr><tr><td>Traffic</td><td>NUMERIC</td></tr><tr><td>StaffCount</td><td>NUMERIC</td></tr><tr><td>DeviceNo</td><td>STRING</td></tr><tr><td>Zone</td><td>STRING</td></tr><tr><td>DeviceType</td><td>STRING</td></tr><tr><td>EntranceName</td><td>STRING</td></tr></tbody></table>

#### Sensors

The Sensors API offered by Prodco Analytics pertains to the data generated by various sensors deployed.

For more information, see [Sensors](https://api.prodcotech.com/apidoc/#/Sensors).

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>StoreNo</td><td>STRING</td></tr><tr><td>EntranceNo</td><td>NUMERIC</td></tr><tr><td>EntranceName</td><td>STRING</td></tr><tr><td>DeviceNo</td><td>STRING</td></tr><tr><td>Sensor</td><td>NUMERIC</td></tr><tr><td>InOut</td><td>STRING</td></tr><tr><td>Zone</td><td>BOOLEAN</td></tr></tbody></table>