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