- Server: PostgreSQL
216.158.72.53:5432
, version13.7 (Debian 13.7-0+deb11u1)
- Local time stamp:
2022-07-20T12:41:43.0051958+02:00
- Schema: public
- Table
public.addresses
- Table
public.alarm_alarm_contacts
- Table
public.alarm_contacts
- Table
public.alarm_history
- Table
public.alarm_templates
- Table
public.alarm_types
- Table
public.alarms
- Table
public.alt_company_addresses
- Table
public.alt_contact_addresses
- Table
public.asset_customer_locations
- Table
public.asset_customers
- Table
public.asset_data_points
- Table
public.asset_trigger_points
- Table
public.assets
- Table
public.celery_taskmeta
- Table
public.celery_tasksetmeta
- Table
public.companies
- Table
public.company_role_data_points
- Table
public.company_role_things
- Table
public.company_role_users
- Table
public.company_roles
- Table
public.company_types
- Table
public.computed_data_point_things
- Table
public.computed_data_point_values
- Table
public.computed_thing_data
- Table
public.computed_thing_members
- Table
public.computed_things
- Table
public.contacts
- Table
public.custom_periods
- Table
public.dashboard_data_views
- Table
public.dashboards
- Table
public.data_functions
- Table
public.data_note_events
- Table
public.data_note_types
- Table
public.data_notes
- Table
public.data_point_copies
- Table
public.data_point_copy
- Table
public.data_point_things
- Table
public.data_point_types
- Table
public.data_points
- Table
public.data_view_config_templates
- Table
public.data_view_data_points
- Table
public.data_view_date_range_filters
- Table
public.data_view_grid
- Table
public.data_view_types
- Table
public.data_views
- Table
public.date_range_filters
- Table
public.event_acks
- Table
public.event_categories
- Table
public.event_category_issues
- Table
public.event_category_lines
- Table
public.event_category_locations
- Table
public.event_category_types
- Table
public.event_contacts
- Table
public.event_history
- Table
public.event_periods
- Table
public.event_types
- Table
public.events
- Table
public.group_permissions
- Table
public.groups
- Table
public.interval_lengths
- Table
public.intervals
- Table
public.ip_addrs
- Table
public.itron_things
- Table
public.modbus_things
- Table
public.permissions
- Table
public.report_templates
- Table
public.reports
- Table
public.scheduled_event_contacts
- Table
public.scheduled_event_intervals
- Table
public.scheduled_event_scheduled_event_contacts
- Table
public.scheduled_event_types
- Table
public.scheduled_events
- Table
public.system_message_types
- Table
public.system_messages
- Table
public.task_status
- Table
public.thing_acl
- Table
public.thing_data
- Table
public.thing_data_failure_log
- Table
public.thing_notes
- Table
public.thing_tags
- Table
public.things
- Table
public.ticket_events
- Table
public.ticket_notes
- Table
public.ticket_priority
- Table
public.ticket_status
- Table
public.ticket_types
- Table
public.ticket_users
- Table
public.tickets
- Table
public.time_domain_intervals
- Table
public.time_domains
- Table
public.time_zones
- Table
public.trigger_point_actions
- Table
public.trigger_point_contacts
- Table
public.trigger_point_data_views
- Table
public.trigger_point_profile_actions
- Table
public.trigger_point_profiles
- Table
public.trigger_point_trigger_point_profiles
- Table
public.trigger_points
- Table
public.units
- Table
public.user_auth_logs
- Table
public.user_companies
- Table
public.user_contacts
- Table
public.user_groups
- Table
public.user_transaction_logs
- Table
public.users
- Function
public.dp_data_accumulator(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_accumulator_day(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_avg(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_avg_day(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_max(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_max_day(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_min(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_min_day(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_sum(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.dp_data_sum_day(integer, character varying, integer, character varying, character varying, character varying)
- Function
public.update_computed_data_point_thing_cnt()
- Function
public.update_dashboard_data_view_cnt()
- Function
public.update_data_point_thing_cnt()
- Function
public.update_data_view_data_point_cnt()
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#address_type_id |
integer |
YES | |||
#name |
character varying(128) |
NO | |||
#address |
character varying(64) |
YES | |||
#address_2 |
character varying(64) |
YES | |||
#city |
character varying(64) |
YES | |||
#state |
character varying(32) |
YES | |||
#postal_code |
character varying(15) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#alarm_id |
FK ➝ alarms.id |
integer |
YES | ||
#alarm_contact_id |
FK ➝ alarm_contacts.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(64) |
NO | |||
#email |
character varying(64) |
NO | |||
#cell_number |
character varying(10) |
YES | |||
#email_notification |
boolean |
YES | |||
#sms_notification |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#alarm_id |
FK ➝ alarms.id |
integer |
YES | ||
#name |
character varying(64) |
NO | |||
#content |
text |
YES | |||
#created |
timestamp without time zone |
YES | |||
#acked |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(64) |
NO | |||
#content |
text |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(64) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id |
integer |
YES | ||
#alarm_type_id |
FK ➝ alarm_types.id |
integer |
YES | ||
#alarm_template_id |
FK ➝ alarm_templates.id |
integer |
YES | ||
#name |
character varying(64) |
NO | |||
#interval |
character varying(32) |
YES | |||
#interval_length |
integer |
YES | |||
#period |
interval |
YES | |||
#notice_interval |
interval |
YES | |||
#active_from |
interval |
YES | |||
#active_to |
interval |
YES | |||
#active |
boolean |
YES | |||
#last_run |
timestamp without time zone |
YES | |||
#last_notification |
timestamp without time zone |
YES | |||
#low_threshold |
double precision(53,2) |
YES | |||
#high_threshold |
double precision(53,2) |
YES | |||
#content |
text |
YES | |||
#created |
timestamp without time zone |
YES | |||
#low_discard_threshold |
double precision(53,2) |
YES | |||
#high_discard_threshold |
double precision(53,2) |
YES | |||
#include_null |
boolean |
YES | |||
#timezone |
character varying(64) |
YES | |||
#day_of_week |
json |
YES | |||
#is_accumulator |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#address_id |
FK ➝ addresses.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#contact_id |
FK ➝ contacts.id |
integer |
YES | ||
#address_id |
FK ➝ addresses.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#asset_customer_id |
FK ➝ asset_customers.id |
integer |
YES | ||
#location_name |
character varying(255) |
NO | |||
#address |
character varying(64) |
YES | |||
#address_2 |
character varying(64) |
YES | |||
#city |
character varying(64) |
YES | |||
#state |
character varying(32) |
YES | |||
#postal_code |
character varying(15) |
YES | |||
#lat |
double precision(53,2) |
YES | |||
#lon |
double precision(53,2) |
YES | |||
#created |
timestamp without time zone |
NO | |||
#active |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#name |
character varying(255) |
NO | |||
#address |
character varying(64) |
YES | |||
#address_2 |
character varying(64) |
YES | |||
#city |
character varying(64) |
YES | |||
#state |
character varying(32) |
YES | |||
#postal_code |
character varying(15) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#data_point_id |
PK, FK ➝ data_points.id |
integer |
NO | ||
#asset_id |
PK, FK ➝ assets.id , IDX |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#trigger_point_id |
PK, FK ➝ trigger_points.id |
integer |
NO | ||
#asset_id |
PK, FK ➝ assets.id , IDX |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#make |
character varying(255) |
YES | |||
#model |
character varying(255) |
YES | |||
#description |
text |
YES | |||
#asset_customer_id |
FK ➝ asset_customers.id |
integer |
YES | ||
#created |
timestamp without time zone |
NO | |||
#active |
boolean |
YES | |||
#lat |
double precision(53,2) |
YES | |||
#lon |
double precision(53,2) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | ||
#task_id |
UNIQUE | character varying(155) |
YES | ||
#status |
character varying(50) |
YES | |||
#result |
bytea |
YES | |||
#date_done |
timestamp without time zone |
YES | |||
#traceback |
text |
YES | |||
#name |
character varying(155) |
YES | |||
#args |
bytea |
YES | |||
#kwargs |
bytea |
YES | |||
#worker |
character varying(155) |
YES | |||
#retries |
integer |
YES | |||
#queue |
character varying(155) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | ||
#taskset_id |
UNIQUE | character varying(155) |
YES | ||
#result |
bytea |
YES | |||
#date_done |
timestamp without time zone |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#parent_id |
FK ➝ companies.id |
integer |
YES | ||
#company_type_id |
FK ➝ company_types.id |
integer |
YES | ||
#name |
character varying(128) |
NO | |||
#settings |
text |
YES | |||
#active |
boolean |
YES | |||
#address |
character varying(64) |
YES | |||
#address_2 |
character varying(64) |
YES | |||
#city |
character varying(64) |
YES | |||
#state |
character varying(32) |
YES | |||
#postal_code |
character varying(15) |
YES | |||
#start_date |
timestamp without time zone |
YES | |||
#end_date |
timestamp without time zone |
YES | |||
#last_login |
timestamp without time zone |
YES | |||
#domain |
character varying(255) |
YES | |||
#hostname |
character varying(255) |
YES | |||
#logo_file_name |
character varying(255) |
YES | |||
#url |
character varying(255) |
YES | |||
#description |
text |
YES | |||
#primary_telephone |
character varying(15) |
YES | |||
#primary_extension |
character varying(8) |
YES | |||
#secondary_telephone |
character varying(15) |
YES | |||
#secondary_extension |
character varying(8) |
YES | |||
#administrative_email |
character varying(128) |
YES | |||
#billing_email |
character varying(128) |
YES | |||
#technical_email |
character varying(128) |
YES | |||
#timezone |
character varying(64) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#data_point_id |
FK ➝ data_points.id |
integer |
YES | ||
#company_role_id |
FK ➝ company_roles.id |
integer |
YES | ||
#is_read_only |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id |
integer |
YES | ||
#company_role_id |
FK ➝ company_roles.id |
integer |
YES | ||
#is_read_only |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#user_id |
FK ➝ users.id |
integer |
YES | ||
#company_role_id |
FK ➝ company_roles.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#name |
character varying(128) |
NO | |||
#description |
text |
YES | |||
#config_template |
json |
YES | |||
#created_date |
timestamp without time zone |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(128) |
NO | |||
#description |
text |
YES | |||
#created_date |
timestamp without time zone |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#data_point_id |
FK ➝ data_points.id |
integer |
NO | ||
#thing_id |
FK ➝ things.id |
integer |
NO | ||
#computation_type_id |
integer |
YES | 1 |
||
#scalar |
double precision(53,2) |
NO | 1 |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#data_point_id |
FK ➝ data_points.id |
integer |
YES | ||
#computation_type_id |
integer |
YES | |||
#value |
integer |
NO | |||
#is_percentage |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#computed_thing_id |
FK ➝ computed_things.id |
integer |
YES | ||
#value |
double precision(53,2) |
YES | |||
#timestamp |
timestamp without time zone |
NO | |||
#active |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id |
integer |
YES | ||
#computed_thing_id |
FK ➝ computed_things.id |
integer |
YES | ||
#data_function_id |
FK ➝ data_functions.id |
integer |
YES | ||
#operator_id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#name |
character varying(1024) |
NO | |||
#rollover |
integer |
YES | |||
#interval_length |
integer |
YES | |||
#is_accumulator |
boolean |
YES | |||
#active |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#contact_type_id |
integer |
YES | |||
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#first_name |
character varying(128) |
NO | |||
#last_name |
character varying(128) |
NO | |||
#primary_telephone |
character varying(15) |
YES | |||
#primary_extension |
character varying(8) |
YES | |||
#secondary_telephone |
character varying(15) |
YES | |||
#secondary_extension |
character varying(8) |
YES | |||
#primary_email |
character varying(128) |
YES | |||
#secondary_email |
character varying(128) |
YES | |||
#address |
character varying(64) |
YES | |||
#address_2 |
character varying(64) |
YES | |||
#city |
character varying(64) |
YES | |||
#state |
character varying(32) |
YES | |||
#postal_code |
character varying(15) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#config |
json |
YES | |||
#active |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#dashboard_id |
FK ➝ dashboards.id |
integer |
YES | ||
#data_view_id |
FK ➝ data_views.id |
integer |
YES | ||
#settings |
json |
YES | |||
#active |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#name |
character varying(255) |
NO | |||
#description |
text |
YES | |||
#created |
timestamp without time zone |
NO | |||
#active |
boolean |
YES | |||
#data_view_cnt |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#data_note_id |
FK ➝ data_notes.id |
integer |
YES | ||
#event_id |
FK ➝ events.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#description |
text |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#data_note_type_id |
FK ➝ data_note_types.id |
integer |
YES | ||
#title |
character varying(255) |
NO | |||
#description |
text |
YES | |||
#created |
timestamp without time zone |
NO | |||
#active |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#data_point_copy_id |
FK ➝ data_point_copy.id |
integer |
YES | ||
#data_point_id |
FK ➝ data_points.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#data_point_id |
FK ➝ data_points.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#data_point_id |
FK ➝ data_points.id |
integer |
YES | ||
#thing_id |
FK ➝ things.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#unit_id |
FK ➝ units.id |
integer |
NO | ||
#name |
character varying(255) |
NO | |||
#interval |
character varying(32) |
YES | |||
#interval_length |
integer |
YES | |||
#data_point_type_id |
integer |
YES | |||
#color |
character varying(7) |
YES | |||
#fill |
boolean |
YES | |||
#fill_alpha |
double precision(53,2) |
YES | |||
#data_function_id |
FK ➝ data_functions.id |
integer |
YES | ||
#created |
timestamp without time zone |
NO | |||
#is_accumulator |
boolean |
YES | |||
#is_computed |
boolean |
YES | |||
#expression |
character varying(255) |
YES | |||
#timezone |
character varying(64) |
YES | |||
#active |
boolean |
YES | |||
#thing_cnt |
integer |
YES | |||
#negative_default_zero |
boolean |
YES | |||
#include_negative |
boolean |
YES | |||
#spike_ceiling |
double precision(53,2) |
YES | |||
#spike_floor |
double precision(53,2) |
YES | |||
#rounding_precision |
integer |
NO | |||
#opposite |
boolean |
NO | false |
||
#use_advanced_expression |
boolean |
NO | false |
||
#advanced_expression |
text |
YES | |||
#include_zeroes |
boolean |
YES | true |
||
#data_aggregation_id |
integer |
YES | |||
#room |
character varying(150) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#data_view_type_id |
FK ➝ data_view_types.id |
integer |
YES | ||
#config |
json |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#data_point_id |
FK ➝ data_points.id |
integer |
YES | ||
#data_view_id |
FK ➝ data_views.id , IDX |
integer |
YES | ||
#y_axis_label |
character varying(64) |
YES | |||
#x_axis_label |
character varying(64) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#date_range_filter_id |
FK ➝ date_range_filters.id |
integer |
YES | ||
#data_view_id |
FK ➝ data_views.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#data_view_id |
FK ➝ data_views.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#column_data |
json |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#data_view_type_id |
FK ➝ data_view_types.id |
integer |
YES | ||
#time_domain_id |
FK ➝ time_domains.id |
integer |
YES | ||
#time_domain_interval_id |
FK ➝ time_domain_intervals.id |
integer |
YES | ||
#name |
character varying(255) |
NO | |||
#is_streaming |
boolean |
YES | |||
#stream_interval |
double precision(53,2) |
YES | |||
#auto_color |
boolean |
YES | |||
#active |
boolean |
YES | |||
#settings |
json |
YES | |||
#start_yaxis_on_min |
boolean |
YES | |||
#sort_by_id |
boolean |
YES | |||
#data_point_cnt |
integer |
YES | |||
#custom_period_id |
FK ➝ custom_periods.id |
integer |
YES | ||
#y_axis_label |
character varying(64) |
YES | |||
#x_axis_label |
character varying(64) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#description |
character varying(1024) |
YES | |||
#today |
boolean |
YES | |||
#date_range_type |
USER-DEFINED |
YES | |||
#interval_tense |
USER-DEFINED |
YES | |||
#interval |
USER-DEFINED |
YES | |||
#interval_length |
integer |
NO | |||
#duration_start_time |
time without time zone |
YES | |||
#fixed_date |
timestamp without time zone |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#event_id |
FK ➝ events.id |
integer |
YES | ||
#acked_by |
FK ➝ users.id |
integer |
YES | ||
#acked_at |
timestamp without time zone |
NO | |||
#acked |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#event_category_type_id |
FK ➝ event_category_types.id |
integer |
YES | ||
#object_id |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#value |
character varying(128) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#value |
character varying(128) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#value |
character varying(128) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(64) |
YES | |||
#description |
character varying(255) |
YES | |||
#obj_event_category_data |
character varying(32) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(64) |
NO | |||
#email |
character varying(64) |
NO | |||
#cell_number |
character varying(10) |
YES | |||
#email_notification |
boolean |
YES | |||
#sms_notification |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#event_id |
FK ➝ events.id |
integer |
YES | ||
#created |
timestamp without time zone |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#event_id |
FK ➝ events.id |
integer |
YES | ||
#event_start |
timestamp without time zone |
NO | |||
#event_stop |
timestamp without time zone |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#description |
text |
YES | |||
#ui_config |
json |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#title |
character varying(255) |
NO | |||
#description |
text |
YES | |||
#created |
timestamp without time zone |
NO | |||
#active |
boolean |
YES | |||
#event_type_id |
FK ➝ event_types.id |
integer |
YES | ||
#asset_id |
FK ➝ assets.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#group_id |
FK ➝ groups.id |
integer |
YES | ||
#permission_id |
FK ➝ permissions.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
UNIQUE | character varying(64) |
NO | ||
#description |
text |
YES | |||
#created_date |
timestamp without time zone |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#length |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(64) |
NO | |||
#label |
character varying(64) |
YES | |||
#value |
character varying(32) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#ip |
character varying(64) |
YES | |||
#prefix |
character varying(64) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id |
integer |
YES | ||
#serial_number |
character varying(64) |
YES | |||
#min_pf |
double precision(53,2) |
YES | |||
#kilowatt_hours |
double precision(53,2) |
YES | |||
#kilowatts |
double precision(53,2) |
YES | |||
#min_pf_id |
integer |
YES | |||
#kilowatt_hours_id |
integer |
YES | |||
#kilowatts_id |
integer |
YES | |||
#last_updated |
timestamp without time zone |
YES | |||
#ip_addr |
character varying(15) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id |
integer |
YES | ||
#ip_addr |
character varying(64) |
YES | |||
#port |
integer |
YES | |||
#poll_seconds |
integer |
YES | |||
#poll_group_id |
integer |
YES | |||
#numeric_type_id |
integer |
YES | |||
#thing_code |
IDX | character varying(64) |
YES | ||
#function_code |
integer |
YES | |||
#unit_id |
integer |
YES | |||
#start_address |
integer |
YES | |||
#address_length |
integer |
YES | |||
#value |
double precision(53,2) |
YES | |||
#scalar |
double precision(53,2) |
YES | |||
#byteorder |
character varying(64) |
YES | |||
#wordorder |
character varying(64) |
YES | |||
#decoder |
character varying(64) |
YES | |||
#online |
boolean |
YES | |||
#last_updated |
timestamp without time zone |
YES | |||
#offline_ts |
timestamp without time zone |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(32) |
YES | |||
#description |
character varying(255) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#oid |
character varying(40) |
YES | |||
#name |
character varying(128) |
NO | |||
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#computed_thing |
text |
YES | |||
#description |
text |
YES | |||
#configuration |
json |
YES | |||
#module |
character varying(255) |
NO | |||
#report_type |
character varying(32) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#name |
character varying(64) |
NO | |||
#meta_data |
json |
YES | |||
#created |
timestamp without time zone |
NO | |||
#report_type |
character varying(64) |
YES | |||
#report_name |
character varying(64) |
YES | |||
#date_type |
character varying(64) |
YES | |||
#data_type |
character varying(64) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#name |
character varying(64) |
NO | |||
#email |
character varying(64) |
NO | |||
#cell_number |
character varying(10) |
YES | |||
#email_notification |
boolean |
YES | |||
#sms_notification |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(64) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#scheduled_event_id |
FK ➝ scheduled_events.id |
integer |
YES | ||
#scheduled_event_contact_id |
FK ➝ scheduled_event_contacts.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(64) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#scheduled_event_type_id |
FK ➝ scheduled_event_types.id |
integer |
YES | ||
#scheduled_event_interval_id |
FK ➝ scheduled_event_intervals.id |
integer |
YES | ||
#name |
character varying(64) |
NO | |||
#active |
boolean |
YES | |||
#last_event |
timestamp without time zone |
YES | |||
#meta_data |
json |
YES | |||
#msg_content |
text |
YES | |||
#created |
timestamp without time zone |
YES | |||
#month_day |
integer |
YES | |||
#active_from |
interval |
YES | |||
#active_to |
interval |
YES | |||
#timezone |
character varying(64) |
YES | |||
#day_of_week |
json |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#system_message_type_id |
FK ➝ system_message_types.id |
integer |
YES | ||
#created |
timestamp without time zone |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#task_id |
character varying(255) |
YES | |||
#meta_data |
json |
YES | |||
#status |
text |
YES | |||
#progress |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id |
integer |
YES | ||
#company_id |
FK ➝ companies.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id , IDX, IDX, IDX, IDX, IDX |
integer |
YES | ||
#value |
double precision(53,2) |
YES | |||
#timestamp |
IDX, IDX, IDX | timestamp without time zone |
NO | ||
#active |
boolean |
YES | |||
#thing_code |
IDX | character varying(255) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id |
integer |
YES | ||
#last_value |
double precision(53,2) |
YES | |||
#routing_key |
character varying(255) |
NO | |||
#offline_since |
timestamp without time zone |
NO | |||
#timestamp |
timestamp without time zone |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#thing_id |
FK ➝ things.id |
integer |
YES | ||
#note |
text |
YES | |||
#timestamp |
timestamp without time zone |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#tag |
character varying(128) |
NO | |||
#thing_id |
FK ➝ things.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#name |
character varying(1024) |
NO | |||
#rollover |
integer |
YES | |||
#is_accumulator |
boolean |
YES | |||
#active |
boolean |
YES | |||
#lat |
double precision(53,2) |
YES | |||
#lon |
double precision(53,2) |
YES | |||
#thing_code |
character varying(128) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#ticket_id |
FK ➝ tickets.id |
integer |
YES | ||
#event_id |
FK ➝ events.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#ticket_id |
FK ➝ tickets.id |
integer |
YES | ||
#created |
timestamp without time zone |
NO | |||
#user_id |
FK ➝ users.id |
integer |
YES | ||
#description |
text |
YES | |||
#subject |
character varying(255) |
YES | |||
#sent_user_ids |
ARRAY |
YES | |||
#sent_at |
timestamp without time zone |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#description |
text |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#ticket_id |
PK, FK ➝ tickets.id |
integer |
NO | ||
#user_id |
PK, FK ➝ users.id , IDX |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#description |
text |
YES | |||
#created |
timestamp without time zone |
NO | |||
#updated |
timestamp without time zone |
YES | |||
#subject |
character varying(255) |
NO | |||
#author |
character varying(255) |
NO | |||
#active |
boolean |
YES | |||
#event_id |
FK ➝ events.id |
integer |
YES | ||
#status_id |
FK ➝ ticket_status.id |
integer |
YES | ||
#priority_id |
FK ➝ ticket_priority.id |
integer |
YES | ||
#type_id |
FK ➝ ticket_types.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#interval |
character varying(32) |
YES | |||
#interval_length |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(32) |
NO | |||
#step |
integer |
NO | |||
#domain |
character varying(32) |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#trigger_point_id |
PK, FK ➝ trigger_points.id |
integer |
NO | ||
#event_contact_id |
PK, FK ➝ event_contacts.id , IDX |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#data_view_id |
PK, FK ➝ data_views.id |
integer |
NO | ||
#trigger_point_id |
PK, FK ➝ trigger_points.id , IDX |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#trigger_point_profile_id |
PK, FK ➝ trigger_point_profiles.id |
integer |
NO | ||
#trigger_point_action_id |
PK, FK ➝ trigger_point_actions.id , IDX |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO | |||
#settings |
json |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#trigger_point_profile_id |
PK, FK ➝ trigger_point_profiles.id |
integer |
NO | ||
#trigger_point_id |
PK, FK ➝ trigger_points.id , IDX |
integer |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#name |
character varying(255) |
NO |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#user_id |
integer |
YES | |||
#company_id |
integer |
YES | |||
#username |
character varying(128) |
YES | |||
#timestamp |
timestamp without time zone |
YES | |||
#remote_ip |
character varying(45) |
YES | |||
#user_agent |
text |
YES | |||
#valid_cred |
boolean |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#user_id |
FK ➝ users.id |
integer |
YES | ||
#company_id |
FK ➝ companies.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#user_id |
FK ➝ users.id |
integer |
YES | ||
#contact_id |
FK ➝ contacts.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#user_id |
FK ➝ users.id |
integer |
YES | ||
#group_id |
FK ➝ groups.id |
integer |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#user_id |
integer |
YES | |||
#company_id |
integer |
YES | |||
#username |
character varying(128) |
YES | |||
#timestamp |
timestamp without time zone |
YES | |||
#remote_ip |
character varying(45) |
YES | |||
#user_agent |
text |
YES | |||
#method |
character varying(6) |
YES | |||
#urlvars |
json |
YES | |||
#body |
json |
YES |
Column | Type | Nullable | Default | Comment | |
---|---|---|---|---|---|
#id |
PK | integer |
NO | auto increment | |
#username |
UNIQUE | character varying(128) |
NO | ||
#company_id |
FK ➝ companies.id |
integer |
YES | ||
#first_name |
character varying(128) |
NO | |||
#last_name |
character varying(128) |
NO | |||
#settings |
json |
YES | |||
#created |
timestamp without time zone |
YES | |||
#active |
boolean |
YES | |||
#_hashword |
character varying(255) |
NO | |||
#_login_token |
text |
YES | |||
#_pwd_reset_token |
text |
YES |
Function public.dp_data_accumulator(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_accumulator_day(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_avg(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_avg_day(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_max(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_max_day(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_min(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_min_day(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_sum(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
Function public.dp_data_sum_day(integer, character varying, integer, character varying, character varying, character varying)
-
Returns
record
-
Language is
sql
-
Returns
trigger
-
Language is
plpgsql
-
Returns
trigger
-
Language is
plpgsql
-
Returns
trigger
-
Language is
plpgsql
-
Returns
trigger
-
Language is
plpgsql