SDI2

Tables (96)

DAILY_EQUIPMENT_FACTOR

  • EQP_ID — VARCHAR(1000) — Primary key — NOT NULL
  • FACTOR — VARCHAR(1000)
  • TIMESTAMP — TIMESTAMPTZ

TB_MDT_LAYOUT_PROJECT

  • ID — NUMERIC — Primary key — NOT NULL
  • SAVE_PATH — VARCHAR
  • UPDATE_TIME — TIMESTAMP
  • CREATE_TIME — TIMESTAMP
  • UPDATE_USER — VARCHAR
  • CREATE_USER — VARCHAR
  • DISTRIBUTION_STATUS — NUMERIC
  • VERSION — VARCHAR
  • LAYOUY_NAME — VARCHAR
  • CORPORATION_CODE — VARCHAR
  • PROCESS_CODE — VARCHAR

TB_MDT_PLAYBACK_METADATA

  • ID — NUMERIC — Primary key — NOT NULL
  • UPDATE_TIME — TIMESTAMP
  • CREATE_TIME — TIMESTAMP
  • UPDATE_USER — VARCHAR
  • CREATE_USER — VARCHAR
  • PROCESS_CODE — VARCHAR
  • CORPORATION_CODE — VARCHAR
  • TITLE — VARCHAR
  • RETENTION_DAYS — NUMERIC
  • IS_LIVE — BOOLEAN
  • TOTAL_SIZE_BYTES — NUMERIC
  • STORAGE_NAME — VARCHAR
  • LAST_SEGMENT_INDEX — NUMERIC
  • LAST_SEGMENT_BUILT_TIME — TIMESTAMP
  • SEGMENT_DURATION_MS — NUMERIC
  • STATUS — VARCHAR
  • WINDOW_START_TIME — TIMESTAMP
  • WINDOW_END_TIME — TIMESTAMP

TB_MDT_PLAYBACK_SESSION_H

  • ID — NUMERIC — Primary key — NOT NULL
  • UPDATE_TIME — TIMESTAMP
  • CREATE_TIME — TIMESTAMP
  • UPDATE_USER — VARCHAR
  • CREATE_USER — VARCHAR
  • EVENT_TYPE — VARCHAR
  • PAYLOAD — JSONB
  • EVENT_TIME — TIMESTAMP
  • SESSION_START_TIME — TIMESTAMP
  • SESSION_END_TIME — TIMESTAMP
  • CLIENT_IP — VARCHAR
  • CLIENT_TIME — TIMESTAMP

TB_MDT_UNITY_CORPORATIONCODE

  • ID — NUMERIC — Primary key — NOT NULL
  • CORPORATION_CODE — VARCHAR
  • CORPORATION_NAME — VARCHAR
  • UPDATE_TIME — TIMESTAMP
  • CREATE_TIME — TIMESTAMP
  • UPDATE_USER — VARCHAR
  • CREATE_USER — VARCHAR

TB_MDT_UNITY_PROCESSCODE

  • ID — NUMERIC — Primary key — NOT NULL
  • PROCESS_CODE — VARCHAR
  • PROCESS_NAME — VARCHAR
  • UPDATE_TIME — TIMESTAMP
  • CREATE_TIME — TIMESTAMP
  • UPDATE_USER — VARCHAR
  • CREATE_USER — VARCHAR

TB_MDT_UNITY_UICONFIG

  • ID — NUMERIC — Primary key — NOT NULL
  • DATA — JSONB
  • UPDATE_TIME — TIMESTAMP
  • CREATE_TIME — TIMESTAMP
  • UPDATE_USER — VARCHAR
  • CREATE_USER — VARCHAR

TB_MDT_UNITY_USERCONFIG

  • ID — NUMERIC — Primary key — NOT NULL
  • DATA — JSONB
  • UPDATE_TIME — TIMESTAMP
  • CREATE_TIME — TIMESTAMP
  • UPDATE_USER — VARCHAR
  • CREATE_USER — VARCHAR

actions

  • id — BIGINT — Primary key — NOT NULL
  • service — VARCHAR(50) — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ai_eda

  • id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • eda_id — VARCHAR(50)
  • standard_facility_id — INTEGER
  • standard_date_from — TIMESTAMPTZ
  • standard_date_to — TIMESTAMPTZ
  • standard_columns — JSONB
  • comparative_facility_id — INTEGER
  • comparative_date_from — TIMESTAMPTZ
  • comparative_date_to — TIMESTAMPTZ
  • comparative_columns — JSONB
  • html_result — JSONB
  • data_quality — JSONB
  • training_column — JSONB
  • missing_parameter — JSONB
  • selected_tag_list — JSONB
  • training_parameter — JSONB
  • cc_id_normalization — INTEGER
  • cc_id_dimension_reduction — INTEGER
  • is_training — BOOLEAN
  • system_code — VARCHAR(100)
  • target_code — VARCHAR(50)
  • filter_code — VARCHAR(50)
  • target_db — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

ai_eda_file_join

  • id — SERIAL — Primary key — NOT NULL
  • ai_eda_id — INTEGER — NOT NULL
  • file_id — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

ai_log

  • id — SERIAL — Primary key — NOT NULL
  • model_id — INTEGER — NOT NULL
  • prediction — JSONB
  • anomaly_state — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

ai_model

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • facility_management_id — INTEGER
  • facility_code — VARCHAR(200)
  • facility_name — VARCHAR(200)
  • name — VARCHAR(200) — NOT NULL
  • data_quality — JSONB
  • training_column — JSONB
  • selected_tag_list — JSONB
  • missing_parameter — JSONB
  • training_parameter — JSONB
  • cc_id_normalization — INTEGER
  • cc_id_dimension_reduction — INTEGER
  • algorithm — JSONB
  • eval_score — JSONB
  • model_status — VARCHAR(200)
  • model_progress — INTEGER
  • data_load_from — TIMESTAMPTZ
  • data_load_to — TIMESTAMPTZ
  • is_training — BOOLEAN
  • active — BOOLEAN
  • ai_pattern — JSONB
  • system_code — VARCHAR(100)
  • target_code — VARCHAR(50)
  • filter_code — VARCHAR(50)
  • target_db — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

ai_model_file_join

  • id — SERIAL — Primary key — NOT NULL
  • ai_model_id — INTEGER — NOT NULL
  • file_id — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

api_usage_log

  • id — SERIAL — Primary key — NOT NULL
  • endpoint — VARCHAR(255)
  • method — VARCHAR(255)
  • user_id — INTEGER
  • size_bytes — INTEGER — NOT NULL
  • request_size_bytes — INTEGER — NOT NULL
  • response_size_bytes — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

api_usage_log_daily

  • id — SERIAL — Primary key — NOT NULL
  • date — TIMESTAMPTZ — NOT NULL
  • total_requests — INTEGER — NOT NULL
  • total_bytes — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

api_usage_log_monthly

  • id — SERIAL — Primary key — NOT NULL
  • month_start — TIMESTAMPTZ — NOT NULL
  • total_requests — INTEGER — NOT NULL
  • total_bytes — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

api_usage_log_weekly

  • id — SERIAL — Primary key — NOT NULL
  • week_start — TIMESTAMPTZ — NOT NULL
  • total_requests — INTEGER — NOT NULL
  • total_bytes — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

asset_category

  • id — SERIAL — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

asset_category_join

  • id — SERIAL — Primary key — NOT NULL
  • asset_management_id — INTEGER — NOT NULL
  • asset_category_id — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

asset_file

  • id — SERIAL — Primary key — NOT NULL
  • asset_version_id — INTEGER
  • file_id — INTEGER — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

asset_folder

  • id — SERIAL — Primary key — NOT NULL
  • parent_id — INTEGER
  • name — VARCHAR(255) — NOT NULL
  • order_number — INTEGER — NOT NULL
  • full_path — TEXT — NOT NULL
  • is_favorite — BOOLEAN
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

asset_management

  • id — SERIAL — Primary key — NOT NULL
  • folder_id — INTEGER
  • create_user_id — INTEGER
  • title — VARCHAR(255) — NOT NULL
  • is_favorite — BOOLEAN
  • tags — JSONB
  • order_number — INTEGER — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

asset_thumbnail

  • id — SERIAL — Primary key — NOT NULL
  • asset_management_id — INTEGER — NOT NULL
  • file_id — INTEGER — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

asset_version

  • id — SERIAL — Primary key — NOT NULL
  • asset_management_id — INTEGER — NOT NULL
  • create_user_id — INTEGER
  • title — VARCHAR(255)
  • version — VARCHAR(20) — NOT NULL
  • total_file_size — INTEGER
  • is_default — BOOLEAN — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

audit_logs

  • id — BIGINT — Primary key — NOT NULL
  • company_id — NUMERIC
  • event_type — VARCHAR(50) — NOT NULL
  • user_id — NUMERIC
  • detail — JSON
  • ip_address — VARCHAR(45)
  • user_agent — TEXT
  • created_at — TIMESTAMP

auth_request_manage

  • id — SERIAL — Primary key — NOT NULL
  • request_user_id — INTEGER
  • confirm_user_id — INTEGER
  • role_group_id — INTEGER
  • menu_role_id — INTEGER
  • request_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(100) — NOT NULL
  • authority — VARCHAR(100) — NOT NULL
  • menu_path — VARCHAR(255)
  • request_description — VARCHAR(500)
  • confirm_description — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

auth_requests

  • id — BIGINT — Primary key — NOT NULL
  • requester_id — NUMERIC — NOT NULL
  • role_group_id — NUMERIC — NOT NULL
  • service — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • description — TEXT
  • reviewer_id — NUMERIC
  • review_comment — TEXT
  • reviewed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

category

  • id — SERIAL — Primary key — NOT NULL
  • category_code — VARCHAR(100) — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL
  • is_edge — BOOLEAN — NOT NULL
  • description — VARCHAR(200)
  • visible — BOOLEAN
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

chat_history

  • id — SERIAL — Primary key — NOT NULL
  • workflow_id — INTEGER
  • workflow_code — VARCHAR(100)
  • user_id — INTEGER — NOT NULL
  • session_id — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • proposed_config — JSONB
  • applied_version_id — INTEGER
  • metadata — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

code

  • id — SERIAL — Primary key — NOT NULL
  • category_id — INTEGER — NOT NULL
  • code — VARCHAR(100) — NOT NULL
  • code_value — VARCHAR(100) — NOT NULL
  • description — VARCHAR(200)
  • usage — BOOLEAN — NOT NULL
  • sort — INTEGER — NOT NULL
  • visible — BOOLEAN
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

companies

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • announcement_template — TEXT
  • active — NUMERIC(1) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

component

  • id — SERIAL — Primary key — NOT NULL
  • dashboard_id — INTEGER — NOT NULL
  • drilldown_dashboard_id — INTEGER
  • title — VARCHAR(255)
  • type — VARCHAR(20)
  • data — JSONB
  • drilldown_config — JSONB
  • reference — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

connection_info

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • category_id — INTEGER — NOT NULL
  • protocol_type_template_id — INTEGER — NOT NULL
  • item — VARCHAR(200) — NOT NULL
  • default_code_id — INTEGER
  • default_value — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

custom_menu

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER
  • group_id — INTEGER
  • title — VARCHAR(255) — NOT NULL
  • menu_path — VARCHAR(255) — NOT NULL
  • menu_data — JSONB
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

custom_menu_join

  • id — SERIAL — Primary key — NOT NULL
  • menu_id — INTEGER — NOT NULL
  • structure_id — INTEGER — NOT NULL
  • parent_id — INTEGER
  • level — INTEGER — NOT NULL
  • id_full_path — TEXT — NOT NULL
  • order_number — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

custom_menu_structure

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER
  • group_id — INTEGER
  • title — VARCHAR(100) — NOT NULL
  • in_use — BOOLEAN — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

dashboard_permission

  • id — SERIAL — Primary key — NOT NULL
  • dashboard_id — INTEGER
  • user_id — INTEGER
  • permission — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

dashboard_slide_setting

  • id — SERIAL — Primary key — NOT NULL
  • title — VARCHAR(100)
  • data — JSONB
  • auto — BOOLEAN — NOT NULL
  • count — INTEGER
  • description — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

dashboard_slide_setting_join

  • dashboard_id — INTEGER — Primary key — NOT NULL
  • slide_setting_id — INTEGER — Primary key — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

edge_management

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER — NOT NULL
  • position_structure_id — INTEGER — NOT NULL
  • edge_code — VARCHAR(200) — NOT NULL
  • edge_name — VARCHAR(200) — NOT NULL
  • model_name — VARCHAR(200) — NOT NULL
  • installation_date — TIMESTAMPTZ
  • delivery_place — VARCHAR(200)
  • opcua_server_url — VARCHAR(500)
  • description — VARCHAR(1000)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

email_queue

  • id — BIGINT — Primary key — NOT NULL
  • to — VARCHAR(255) — NOT NULL
  • subject — VARCHAR(500) — NOT NULL
  • body — TEXT — NOT NULL
  • channel — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • error — TEXT
  • related_type — VARCHAR(50)
  • related_id — NUMERIC
  • created_at — TIMESTAMP
  • sent_at — TIMESTAMP

event_history

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER
  • action — VARCHAR(30) — NOT NULL
  • table_name — VARCHAR(100) — NOT NULL
  • table_pks — JSONB
  • request_log — JSONB
  • response_log — JSONB
  • client_ip — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

facility_connection_info

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • protocol_tag_template_id — INTEGER
  • connection_info_id — INTEGER
  • facility_management_id — INTEGER
  • value — VARCHAR(300)
  • value_id — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

facility_management

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER — NOT NULL
  • edge_management_id — INTEGER
  • protocol_tag_template_id — INTEGER
  • facility_code — VARCHAR(200) — NOT NULL
  • facility_name — VARCHAR(200) — NOT NULL
  • description — VARCHAR(1000)
  • x_coordinate — VARCHAR(500)
  • y_coordinate — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

file

  • id — SERIAL — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • path — VARCHAR(1000) — NOT NULL
  • type — VARCHAR(20)
  • size — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

group

  • id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(100)
  • group_code — VARCHAR(300)
  • license — VARCHAR(100)
  • namespace — VARCHAR(100)
  • location — VARCHAR(100)
  • access_code — VARCHAR(500)
  • central_xml — VARCHAR
  • payment_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

menu_role

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • role_group_id — INTEGER
  • menu_path — VARCHAR(200)
  • name — VARCHAR(255)
  • auth_menu — BOOLEAN
  • auth_list — BOOLEAN
  • auth_info — BOOLEAN
  • auth_create — BOOLEAN
  • auth_update — BOOLEAN
  • auth_delete — BOOLEAN
  • auth_confirm — BOOLEAN
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

menu_role_actions

  • id — BIGINT — Primary key — NOT NULL
  • menu_role_id — NUMERIC — NOT NULL
  • action_id — NUMERIC — NOT NULL
  • created_at — TIMESTAMP

menu_roles

  • id — BIGINT — Primary key — NOT NULL
  • company_id — NUMERIC
  • role_group_id — NUMERIC
  • service_menu_id — NUMERIC
  • service — VARCHAR(50) — NOT NULL
  • menu_path — VARCHAR(200) — NOT NULL
  • name — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

menu_usage

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • route — VARCHAR(100) — NOT NULL
  • access_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

modeler

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER
  • group_id — INTEGER — NOT NULL
  • edge_management_id — INTEGER
  • nodes — JSONB
  • root_node_id — JSONB
  • connections — JSONB
  • model_xml — BYTEA
  • is_deployed — BOOLEAN — NOT NULL
  • is_deploy_failed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

mqtt_info

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • tls_broker_url — VARCHAR(500) — NOT NULL
  • wss_broker_url — VARCHAR(500) — NOT NULL
  • expiration — VARCHAR(200) — NOT NULL
  • ca_certification — TEXT — NOT NULL
  • client_certification — TEXT — NOT NULL
  • client_key — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

object_file_management

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • name — VARCHAR(100) — NOT NULL
  • writer — VARCHAR(20) — NOT NULL
  • description — VARCHAR(1000)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

object_file_management_file_join

  • object_file_management_id — INTEGER — Primary key — NOT NULL
  • file_id — INTEGER — Primary key — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

plugin_3d_object

  • id — SERIAL — Primary key — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • version — VARCHAR(100)
  • comment — VARCHAR(500)
  • guid — VARCHAR(500) — NOT NULL
  • metadatas — JSONB
  • image_file_id — INTEGER
  • fbx_file_id — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

plugin_layout

  • id — SERIAL — Primary key — NOT NULL
  • category — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • version — VARCHAR(100)
  • comment — VARCHAR(500)
  • image_file_id — INTEGER
  • layout — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

position_structure

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • name — VARCHAR(300) — NOT NULL
  • parent_id — INTEGER
  • level — INTEGER
  • full_path — VARCHAR(300)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

protocol_tag_data

  • id — SERIAL — Primary key — NOT NULL
  • protocol_tag_template_id — INTEGER — NOT NULL
  • group_id — INTEGER
  • tag_id — VARCHAR(200) — NOT NULL
  • tag_name — VARCHAR(200) — NOT NULL
  • is_read_only — BOOLEAN — NOT NULL
  • tag_group_id — INTEGER — NOT NULL
  • tag_group_value_id — INTEGER — NOT NULL
  • tag_unit_id — INTEGER — NOT NULL
  • tag_unit_value_id — INTEGER — NOT NULL
  • tag_format_id — INTEGER — NOT NULL
  • tag_format_value_id — INTEGER — NOT NULL
  • tag_endian_id — INTEGER — NOT NULL
  • tag_endian_value_id — INTEGER — NOT NULL
  • ratio — DOUBLE — NOT NULL
  • decimal — INTEGER — NOT NULL
  • calculation_id — INTEGER — NOT NULL
  • calculation_value_id — INTEGER — NOT NULL
  • bitwise_operation_id — INTEGER — NOT NULL
  • bitwise_operation_value_id — INTEGER
  • bitwise_value_for_calculate — INTEGER
  • bitwise_data_type_id — INTEGER — NOT NULL
  • bitwise_data_type_value_id — INTEGER
  • scale_facility_range_min — INTEGER
  • scale_facility_range_max — INTEGER
  • scale_ui_range_min — INTEGER
  • scale_ui_range_max — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

protocol_tag_template

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • protocol_type_template_id — INTEGER — NOT NULL
  • template_id — VARCHAR(200) — NOT NULL
  • template_name — VARCHAR(200) — NOT NULL
  • collection_velocity — INTEGER
  • transition_cycle — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

protocol_type_tag_data_info

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • protocol_tag_data_id — INTEGER — NOT NULL
  • protocol_type_template_id — INTEGER — NOT NULL
  • tag_data_info_id — INTEGER — NOT NULL
  • value_id — INTEGER
  • value — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

protocol_type_template

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • template_code — VARCHAR(200) — NOT NULL
  • template_name — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

report

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • dashboard_id — INTEGER
  • title — VARCHAR(100) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • schedule_data — JSONB
  • custom_query_data — JSONB
  • raw_query_data — JSONB
  • chart_setting — JSONB
  • email_enabled — BOOLEAN — NOT NULL
  • email_title — VARCHAR(500)
  • email_content — TEXT
  • next_send_time — TIMESTAMPTZ
  • content_type — VARCHAR(50)
  • time_range_selector — BOOLEAN — NOT NULL
  • description — JSONB
  • active — BOOLEAN — NOT NULL
  • query_tag — VARCHAR(50)
  • is_standard — BOOLEAN — NOT NULL
  • platform — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

report_delivery_history

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • report_id — INTEGER
  • custom_query_data — JSONB
  • raw_query_data — JSONB
  • chart_setting — JSONB
  • query_result — JSONB
  • title — VARCHAR(100) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • schedule_data — JSONB
  • email_title — VARCHAR(500)
  • email_content — TEXT
  • content_type — VARCHAR(50)
  • time_range_selector — BOOLEAN — NOT NULL
  • query_tag — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

report_delivery_history_file_join

  • id — SERIAL — Primary key — NOT NULL
  • report_delivery_history_id — INTEGER — NOT NULL
  • file_id — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

report_delivery_history_user_join

  • id — SERIAL — Primary key — NOT NULL
  • report_delivery_history_id — INTEGER — NOT NULL
  • user_id — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

report_user_join

  • report_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Primary key — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

role_group

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • user_id — INTEGER
  • code — VARCHAR(100)
  • name — VARCHAR(100)
  • default — BOOLEAN
  • description — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

role_group_service_access

  • id — BIGINT — Primary key — NOT NULL
  • role_group_id — NUMERIC — NOT NULL
  • service_code — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

role_group_service_visibility

  • role_group_id — NUMERIC — Primary key — NOT NULL
  • service_code — VARCHAR(50) — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

role_groups

  • id — BIGINT — Primary key — NOT NULL
  • company_id — NUMERIC
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • active — NUMERIC(1)
  • is_personal — NUMERIC(1) — NOT NULL
  • receive_notifications — NUMERIC(1) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

search_history

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER
  • type — VARCHAR(50) — NOT NULL
  • raw_query_data — JSONB
  • chart_setting — JSONB
  • custom_query_data — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

search_query

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER
  • title — VARCHAR(500) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • raw_query_data — JSONB
  • chart_setting — JSONB
  • custom_query_data — JSONB
  • description — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ — NOT NULL

service_menu_actions

  • id — BIGINT — Primary key — NOT NULL
  • service_menu_id — NUMERIC — NOT NULL
  • action_id — NUMERIC — NOT NULL
  • created_at — TIMESTAMP

service_menus

  • id — BIGINT — Primary key — NOT NULL
  • service_code — VARCHAR(50) — NOT NULL
  • path — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • allow_default — NUMERIC(1) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

services

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • announcement_template — TEXT
  • active — NUMERIC(1) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

sessions

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — NUMERIC — NOT NULL
  • ip_address — VARCHAR(45)
  • user_agent — TEXT
  • last_active — TIMESTAMP
  • is_revoked — NUMERIC(1) — NOT NULL
  • created_at — TIMESTAMP

subscription

  • id — SERIAL — Primary key — NOT NULL
  • aws_account_id — VARCHAR(255) — NOT NULL
  • product_code — VARCHAR(255) — NOT NULL
  • subscription_status — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

system_config

  • id — SERIAL — Primary key — NOT NULL
  • update_user_id — INTEGER
  • category — VARCHAR(50) — NOT NULL
  • config_key — VARCHAR(100) — NOT NULL
  • value — JSONB — NOT NULL
  • is_encrypted — BOOLEAN — NOT NULL
  • description — VARCHAR(500)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tag_data_info

  • id — SERIAL — Primary key — NOT NULL
  • group_id — INTEGER
  • category_id — INTEGER — NOT NULL
  • protocol_type_template_id — INTEGER — NOT NULL
  • item — VARCHAR(200) — NOT NULL
  • default_code_id — INTEGER
  • default_value — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

and 16 more tables