# RetailNext schema ERD

Table and field reference for the Fivetran RetailNext connector.

## Table & Field Reference

### appliance

| Column | Type | Keys |
| --- | --- | --- |
| appliance_id | Unknown | PK |
| mac_address | Unknown |  |
| private_ip | Unknown |  |
| public_ip | Unknown |  |
| store_uuid | Unknown |  |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| channel_uuid | Unknown | PK |
| device_id | Unknown | FK |
| blur_video | Unknown |  |
| bytes_per_day | Unknown |  |
| camera_model | Unknown |  |
| first_recorded_time | Unknown |  |
| frame_rate | Unknown |  |
| max_resolution | Unknown |  |
| maximun_retention_days | Unknown |  |
| minimum_retention_days | Unknown |  |
| motion_per_day | Unknown |  |
| name | Unknown |  |
| record_on_motion | Unknown |  |
| recording_enabled | Unknown |  |
| resolution | Unknown |  |
| snapshot_enabled | Unknown |  |
| snapshot_interval_secs | Unknown |  |
| snapshot_resolution | Unknown |  |

### user_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| enterprise_groups | Json |  |
| idle_timeout | Unknown |  |
| name | Unknown |  |
| subscription_admin | Unknown |  |
| use_idle_timeout | Unknown |  |

### users_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| id | Unknown | FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| current_sign_in_at | Unknown |  |
| disabled | Unknown |  |
| email | Unknown |  |
| invitation_accepted | Unknown |  |
| invitation_locale | Unknown |  |
| last_sign_in_at | Unknown |  |
| location_profile_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| user_profile_id | Unknown |  |

### datamine_metric_location

| Column | Type | Keys |
| --- | --- | --- |
| datamine_location_from_datetime | Unknown | PK |
| datamine_location_name | Unknown | PK |
| group_from_gregorian | Unknown | PK |
| location_id | Unknown | PK, FK |
| datamine_location_to_datetime | Unknown |  |
| group_through_gregorian | Unknown |  |
| group_type | Unknown |  |
| index | Unknown |  |
| validity | Unknown |  |
| value | Unknown |  |

### location_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archive_date | Unknown |  |
| comp_start_date | Unknown |  |
| currency | Unknown |  |
| current_utc_offset | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| store_id | Unknown |  |
| street_address | Unknown |  |
| time_zone | Unknown |  |
| time_zone_abbrev | Unknown |  |
| type | Unknown |  |

### network_interface

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| camera_device_id | Unknown | FK |
| gateway | Unknown |  |
| ip | Unknown |  |
| mac | Unknown |  |
| mode | Unknown |  |
| name | Unknown |  |
| subnet | Unknown |  |

### video_channel

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| camera_device_id | Unknown | PK, FK |

### camera

| Column | Type | Keys |
| --- | --- | --- |
| device_id | Unknown | PK |
| accessories | Unknown |  |
| analytics_direction_line_configured | Unknown |  |
| analytics_dwell_zone_count | Unknown |  |
| analytics_traffic_line_count | Unknown |  |
| appliance_id | Unknown |  |
| configuration_summary | Json |  |
| date_added | Unknown |  |
| device_name | Unknown |  |
| dns_servers | Json |  |
| firmware_version | Unknown |  |
| height | Unknown |  |
| last_heard | Unknown |  |
| model | Unknown |  |
| network_configuration_dns | Unknown |  |
| network_configuration_gateway | Unknown |  |
| network_configuration_ip | Unknown |  |
| network_configuration_mode | Unknown |  |
| network_configuration_ntp | Unknown |  |
| private_ip | Unknown |  |
| public_ip | Unknown |  |
| serial_number | Unknown |  |
| store_uuid | Unknown |  |
| type | Unknown |  |
| vendor | Unknown |  |
| video_channel_count | Unknown |  |

## Relationships

- channel(device_id) → camera(device_id)
- users_location(id) → location(id)
- users_location(users_id) → users(id)
- datamine_metric_location(location_id) → location(id)
- location_attribute(location_id) → location(id)
- network_interface(camera_device_id) → camera(device_id)
- video_channel(camera_device_id) → camera(device_id)