Skip to content

Instantly share code, notes, and snippets.

@vbilopav

vbilopav/example_dict.md

Created February 12, 2024 11:22
Show Gist options
  • Save vbilopav/58eb3fcd9550902a8f571f95fe1a78cf to your computer and use it in GitHub Desktop.
Save vbilopav/58eb3fcd9550902a8f571f95fe1a78cf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
example_dict.md

Dictionary for database example

  • Server: PostgreSQL 216.158.72.53:5432, version 13.7 (Debian 13.7-0+deb11u1)
  • Local time stamp: 2022-07-20T12:41:43.0051958+02:00
  • Schema: public

Table of Contents

Tables

Table public.addresses

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

⇡

Table public.alarm_alarm_contacts

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

⇡

Table public.alarm_contacts

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

⇡

Table public.alarm_history

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

⇡

Table public.alarm_templates

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(64) NO
#content text YES

⇡

Table public.alarm_types

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(64) NO

⇡

Table public.alarms

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

⇡

Table public.alt_company_addresses

Column Type Nullable Default Comment
#company_id FK ➝ companies.id integer YES
#address_id FK ➝ addresses.id integer YES

⇡

Table public.alt_contact_addresses

Column Type Nullable Default Comment
#contact_id FK ➝ contacts.id integer YES
#address_id FK ➝ addresses.id integer YES

⇡

Table public.asset_customer_locations

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

⇡

Table public.asset_customers

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

⇡

Table public.asset_data_points

Column Type Nullable Default Comment
#data_point_id PK, FK ➝ data_points.id integer NO
#asset_id PK, FK ➝ assets.id, IDX integer NO

⇡

Table public.asset_trigger_points

Column Type Nullable Default Comment
#trigger_point_id PK, FK ➝ trigger_points.id integer NO
#asset_id PK, FK ➝ assets.id, IDX integer NO

⇡

Table public.assets

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

⇡

Table public.celery_taskmeta

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

⇡

Table public.celery_tasksetmeta

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

⇡

Table public.companies

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

⇡

Table public.company_role_data_points

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

⇡

Table public.company_role_things

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

⇡

Table public.company_role_users

Column Type Nullable Default Comment
#user_id FK ➝ users.id integer YES
#company_role_id FK ➝ company_roles.id integer YES

⇡

Table public.company_roles

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

⇡

Table public.company_types

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

⇡

Table public.computed_data_point_things

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

⇡

Table public.computed_data_point_values

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

⇡

Table public.computed_thing_data

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

⇡

Table public.computed_thing_members

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

⇡

Table public.computed_things

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

⇡

Table public.contacts

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

⇡

Table public.custom_periods

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

⇡

Table public.dashboard_data_views

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

⇡

Table public.dashboards

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

⇡

Table public.data_functions

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.data_note_events

Column Type Nullable Default Comment
#data_note_id FK ➝ data_notes.id integer YES
#event_id FK ➝ events.id integer YES

⇡

Table public.data_note_types

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO
#description text YES

⇡

Table public.data_notes

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

⇡

Table public.data_point_copies

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

⇡

Table public.data_point_copy

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

⇡

Table public.data_point_things

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

⇡

Table public.data_point_types

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.data_points

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

⇡

Table public.data_view_config_templates

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

⇡

Table public.data_view_data_points

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

⇡

Table public.data_view_date_range_filters

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

⇡

Table public.data_view_grid

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

⇡

Table public.data_view_types

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.data_views

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

⇡

Table public.date_range_filters

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

⇡

Table public.event_acks

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

⇡

Table public.event_categories

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

⇡

Table public.event_category_issues

Column Type Nullable Default Comment
#id PK integer NO auto increment
#value character varying(128) NO

⇡

Table public.event_category_lines

Column Type Nullable Default Comment
#id PK integer NO auto increment
#value character varying(128) NO

⇡

Table public.event_category_locations

Column Type Nullable Default Comment
#id PK integer NO auto increment
#value character varying(128) NO

⇡

Table public.event_category_types

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

⇡

Table public.event_contacts

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

⇡

Table public.event_history

Column Type Nullable Default Comment
#id PK integer NO auto increment
#event_id FK ➝ events.id integer YES
#created timestamp without time zone NO

⇡

Table public.event_periods

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

⇡

Table public.event_types

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO
#description text YES
#ui_config json YES

⇡

Table public.events

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

⇡

Table public.group_permissions

Column Type Nullable Default Comment
#group_id FK ➝ groups.id integer YES
#permission_id FK ➝ permissions.id integer YES

⇡

Table public.groups

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

⇡

Table public.interval_lengths

Column Type Nullable Default Comment
#id PK integer NO auto increment
#length character varying(255) NO

⇡

Table public.intervals

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

⇡

Table public.ip_addrs

Column Type Nullable Default Comment
#id PK integer NO auto increment
#ip character varying(64) YES
#prefix character varying(64) YES

⇡

Table public.itron_things

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

⇡

Table public.modbus_things

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

⇡

Table public.permissions

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(32) YES
#description character varying(255) YES

⇡

Table public.report_templates

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

⇡

Table public.reports

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

⇡

Table public.scheduled_event_contacts

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

⇡

Table public.scheduled_event_intervals

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(64) NO

⇡

Table public.scheduled_event_scheduled_event_contacts

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

⇡

Table public.scheduled_event_types

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(64) NO

⇡

Table public.scheduled_events

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

⇡

Table public.system_message_types

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.system_messages

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

⇡

Table public.task_status

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

⇡

Table public.thing_acl

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

⇡

Table public.thing_data

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

⇡

Table public.thing_data_failure_log

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

⇡

Table public.thing_notes

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

⇡

Table public.thing_tags

Column Type Nullable Default Comment
#id PK integer NO auto increment
#tag character varying(128) NO
#thing_id FK ➝ things.id integer YES

⇡

Table public.things

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

⇡

Table public.ticket_events

Column Type Nullable Default Comment
#ticket_id FK ➝ tickets.id integer YES
#event_id FK ➝ events.id integer YES

⇡

Table public.ticket_notes

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

⇡

Table public.ticket_priority

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.ticket_status

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.ticket_types

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO
#description text YES

⇡

Table public.ticket_users

Column Type Nullable Default Comment
#ticket_id PK, FK ➝ tickets.id integer NO
#user_id PK, FK ➝ users.id, IDX integer NO

⇡

Table public.tickets

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

⇡

Table public.time_domain_intervals

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

⇡

Table public.time_domains

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(32) NO
#step integer NO
#domain character varying(32) YES

⇡

Table public.time_zones

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.trigger_point_actions

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.trigger_point_contacts

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

⇡

Table public.trigger_point_data_views

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

⇡

Table public.trigger_point_profile_actions

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

⇡

Table public.trigger_point_profiles

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO
#settings json YES

⇡

Table public.trigger_point_trigger_point_profiles

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

⇡

Table public.trigger_points

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.units

Column Type Nullable Default Comment
#id PK integer NO auto increment
#name character varying(255) NO

⇡

Table public.user_auth_logs

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

⇡

Table public.user_companies

Column Type Nullable Default Comment
#user_id FK ➝ users.id integer YES
#company_id FK ➝ companies.id integer YES

⇡

Table public.user_contacts

Column Type Nullable Default Comment
#user_id FK ➝ users.id integer YES
#contact_id FK ➝ contacts.id integer YES

⇡

Table public.user_groups

Column Type Nullable Default Comment
#user_id FK ➝ users.id integer YES
#group_id FK ➝ groups.id integer YES

⇡

Table public.user_transaction_logs

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

⇡

Table public.users

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

⇡

Routines

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

⇡

Function public.update_computed_data_point_thing_cnt()

  • Returns trigger

  • Language is plpgsql

⇡

Function public.update_dashboard_data_view_cnt()

  • Returns trigger

  • Language is plpgsql

⇡

Function public.update_data_point_thing_cnt()

  • Returns trigger

  • Language is plpgsql

⇡

Function public.update_data_view_data_point_cnt()

  • Returns trigger

  • Language is plpgsql

⇡

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment