RetailNext
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 |