FlexingCPS_v1.0

Tables (50)

alarm_histories

  • id — serial4 — Primary key — NOT NULL
  • device_id — int4 — NOT NULL
  • device_name — varchar(100) — NOT NULL
  • node_name — varchar(100)
  • alarm_state — varchar(100)
  • node_value — int4
  • alarm_check — timestamptz
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

alarm_settings

  • id — serial4 — Primary key — NOT NULL
  • device_id — int4 — Foreign key → devices.id
  • node_name — varchar(100)
  • high_high — int4
  • high — int4
  • low — int4
  • low_low — int4
  • active — bool
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

anomalies

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(100)
  • group_id — int4 — Foreign key → groups.id
  • all_tag_list — _varchar
  • selected_tag_list — _varchar
  • anomaly_analysis_result — _json
  • label_info — _json
  • machine_learning_info — json
  • class_info — json
  • deploy_device_info — _json
  • deploy_info — _json
  • upload_file_path — varchar(100)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

categories

  • id — serial4 — Primary key — NOT NULL
  • category_code — varchar(100) — NOT NULL
  • category_name — varchar(100) — NOT NULL
  • is_edge — bool — NOT NULL
  • description — varchar(200)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

certification_file_joins

  • id — serial4 — Primary key — NOT NULL
  • certification_id — int4 — Foreign key → certifications.id
  • file_id — int4 — Foreign key → files.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

certifications

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • version — varchar(20) — NOT NULL
  • description — varchar(1000)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

codes

  • id — serial4 — Primary key — NOT NULL
  • category_id — int4 — Foreign key → categories.id
  • code — varchar(100) — NOT NULL
  • code_value — varchar(100) — NOT NULL
  • description — varchar(200)
  • usage — bool — NOT NULL
  • sort — int4 — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

connection_infos

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • category_id — int4 — Foreign key → categories.id — NOT NULL
  • protocol_type_template_id — int4
  • item — varchar(200) — NOT NULL
  • default_code_id — int4 — Foreign key → codes.id
  • default_value — varchar(200)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

dashboards

  • id — serial4 — Primary key — NOT NULL
  • user_id — int4
  • dashboard_data — _json
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

data_analysis_flows

  • id — serial4 — Primary key — NOT NULL
  • device_id — int4
  • device_name — varchar(255)
  • flow_meta — _json
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

data_collect_histories

  • id — serial4 — Primary key — NOT NULL
  • device_id — int4 — Foreign key → devices.id
  • measurement — varchar(100)
  • name — varchar(100)
  • collect_start_at — timestamptz
  • collect_stop_at — timestamptz
  • collect_num — int4
  • tag_list — _json
  • tag_num — int4
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

data_markets

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id
  • user_id — int4
  • data_collect_history_id — int4 — Foreign key → data_collect_histories.id
  • device_id — int4 — Foreign key → devices.id
  • measurement — varchar(100)
  • start_range — timestamptz
  • end_range — timestamptz
  • price — int4
  • description — varchar(100)
  • is_canceled — bool
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

data_preprocessing

  • id — serial4 — Primary key — NOT NULL
  • data_collect_history_id — int4
  • measurement — varchar(100)
  • name — varchar(100) — NOT NULL
  • start_range — timestamptz
  • end_range — timestamptz
  • selected_tag_list — _varchar
  • missing_string_preprocessing_info — _varchar
  • string_process_info — _varchar
  • source_data — varchar(100)
  • norm_dime_reduction_info — json
  • data_preprocessing_path — varchar(100)
  • all_tag_list — _varchar
  • source_data_summary_top — json
  • source_data_summary_bottom — json
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

devices

  • id — serial4 — NOT NULL
  • name — varchar(100)
  • model — varchar(100)
  • manufacturer — varchar(100)
  • location — varchar(255)
  • edge_id — int4
  • profile_id — int4
  • connection_type — varchar(255)
  • network_config — json
  • img_path — varchar(255)
  • description — text
  • logical_station_number — int4
  • deploy_model — _int4
  • user_id — int4
  • group_id — int4
  • data_collect_history_id — int4
  • security_certification — json
  • collection_speed — int4
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

edas

  • id — serial4 — Primary key — NOT NULL
  • eda_name — varchar(100)
  • data_preprocessing_id — int4
  • measurement — varchar(100)
  • start_range — timestamptz
  • end_range — timestamptz
  • selected_tag_list — _varchar
  • group_id — int4 — Foreign key → groups.id
  • eda_start_at — timestamptz
  • eda_end_at — timestamptz
  • processed_time — int4
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

edge_managements

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — NOT NULL
  • position_structure_id — int4 — 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

edges

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(100)
  • version — varchar(100)
  • serial_num — varchar(255)
  • location — varchar(255)
  • user_id — int4
  • group_id — int4
  • project_id — int4
  • opc_server_url — varchar(255)
  • edge_url — varchar(255)
  • certification — varchar(255)
  • current_volume — int4
  • amount_volume — int4
  • status — bool
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

event_histories

  • id — serial4 — Primary key — NOT NULL
  • user_id — int4
  • action — varchar(30)
  • table_name — varchar(100)
  • table_pks — _int4
  • request_log — jsonb
  • response_log — jsonb
  • client_ip — varchar(255)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

facility_connection_infos

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id
  • protocol_tag_template_id — int4 — Foreign key → protocol_tag_templates.id
  • connection_info_id — int4 — Foreign key → connection_infos.id
  • facility_management_id — int4 — Foreign key → facility_managements.id
  • value — varchar(300)
  • value_id — int4 — Foreign key → codes.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

facility_managements

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • edge_management_id — int4
  • protocol_tag_template_id — int4 — Foreign key → protocol_tag_templates.id
  • facility_code — varchar(200)
  • facility_name — varchar(200)
  • description — varchar(1000)
  • x_coordinate — varchar(500)
  • y_coordinate — varchar(500)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

files

  • id — serial4 — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • path — varchar(1000) — NOT NULL
  • type — varchar(20)
  • size — int4
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

groups

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(100)
  • license — varchar(100)
  • namespace — varchar(100)
  • location — varchar(100)
  • access_code — varchar(500)
  • central_xml — bytea
  • payment_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • group_code — varchar(300)

hmis

  • id — serial4 — Primary key — NOT NULL
  • user_id — int4
  • group_id — int4
  • web_hmi_data — _json
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

intelligence_decisions

  • id — serial4 — Primary key — NOT NULL
  • node_id — int4
  • machine_learning_model_id — int4 — Foreign key → machine_learning_models.id
  • model_name — varchar(100)
  • decision_class — json
  • activation — varchar(100)
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

license_types

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(100)
  • grant_list — _json
  • menu_auth — _json
  • price — int4
  • description — varchar(255)
  • volume — int4
  • edge_quantity — int4
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

licenses

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id
  • max_users_count — int4
  • type — varchar(10)
  • serial_number — varchar(6) — NOT NULL
  • published_at — timestamptz
  • expried_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

machine_learning_models

  • id — serial4 — Primary key — NOT NULL
  • data_preprocessing_id — int4 — Foreign key → data_preprocessing.id
  • learning_done — bool
  • model_name — varchar(255)
  • algorithm_name — varchar(100)
  • algorithm_type — varchar(100)
  • hyper_parameter — jsonb
  • number_of_data — int4
  • tag_data — _json
  • task_id — varchar(100)
  • progress — int4
  • best_accuray — int4
  • current_accuracy — int4
  • precision — int4
  • recall — int4
  • class_info — _json
  • learn_start_at — timestamptz
  • learn_done_at — timestamptz
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

modelers

  • id — serial4 — Primary key — NOT NULL
  • user_id — int4
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • edge_management_id — int4
  • nodes — json
  • root_node_id — _varchar
  • connections — json
  • model_xml — bytea
  • is_deployed — bool — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

mqtt_infos

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • 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_file_joins

  • id — serial4 — Primary key — NOT NULL
  • object_file_management_id — int4 — Foreign key → object_file_managements.id
  • file_id — int4 — Foreign key → files.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

object_file_managements

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • name — varchar(100) — NOT NULL
  • writer — varchar(20) — NOT NULL
  • description — varchar(1000)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

payments

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id
  • account_holder — varchar(255)
  • price — int4
  • bank — varchar(255)
  • deposit_date — timestamptz
  • deposit_status — varchar(255)
  • upload_file_path — varchar(100)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

permissions

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • resource_type — varchar(100) — NOT NULL
  • resource_name — varchar(100) — NOT NULL
  • description — varchar(100)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

position_structures

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4
  • name — varchar(300)
  • parent_id — int4
  • level — int4
  • full_path — varchar(300)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

profiles

  • id — serial4 — Primary key — NOT NULL
  • name — varchar(100)
  • requests — _json
  • protocol — varchar(100)
  • connection_type — varchar(10)
  • description — varchar(255)
  • group_id — int4 — Foreign key → groups.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

protocol_tag_data

  • id — serial4 — Primary key — NOT NULL
  • protocol_tag_template_id — int4 — Foreign key → protocol_tag_templates.id
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • tag_id — varchar(200) — NOT NULL
  • tag_name — varchar(200) — NOT NULL
  • control_authorization — bool — NOT NULL
  • tag_group_id — int4 — Foreign key → categories.id — NOT NULL
  • tag_group_value_id — int4 — Foreign key → codes.id — NOT NULL
  • tag_unit_id — int4 — Foreign key → categories.id — NOT NULL
  • tag_unit_value_id — int4 — Foreign key → codes.id — NOT NULL
  • tag_format_id — int4 — Foreign key → categories.id — NOT NULL
  • tag_format_value_id — int4 — Foreign key → codes.id — NOT NULL
  • tag_endian_id — int4 — Foreign key → categories.id — NOT NULL
  • tag_endian_value_id — int4 — Foreign key → codes.id — NOT NULL
  • ratio — float8
  • decimal — int4
  • calculation_id — int4 — Foreign key → categories.id — NOT NULL
  • calculation_value_id — int4 — Foreign key → codes.id — NOT NULL
  • bitwise_operation_id — int4 — Foreign key → categories.id — NOT NULL
  • bitwise_operation_value_id — int4 — Foreign key → codes.id
  • bitwise_value_for_calculate — varchar(50)
  • bitwise_data_type_id — int4 — Foreign key → categories.id — NOT NULL
  • bitwise_data_type_value_id — int4 — Foreign key → codes.id
  • scale_facility_range_min — int4
  • scale_facility_range_max — int4
  • scale_ui_range_min — int4
  • scale_ui_range_max — int4
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

protocol_tag_templates

  • id — serial4 — Primary key — NOT NULL
  • protocol_type_template_id — int4
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • template_id — varchar(200) — NOT NULL
  • template_name — varchar(200) — NOT NULL
  • collection_velocity — int4
  • transition_cycle — int4
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

protocol_type_tag_data_infos

  • id — serial4 — Primary key — NOT NULL
  • protocol_tag_data_id — int4 — Foreign key → protocol_tag_data.id — NOT NULL
  • protocol_type_template_id — int4 — NOT NULL
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • tag_data_info_id — int4 — Foreign key → tag_data_infos.id — NOT NULL
  • value — varchar(200)
  • value_id — int4 — Foreign key → codes.id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

protocol_type_templates

  • id — serial4 — Primary key — NOT NULL
  • group_id — int4 — Foreign key → groups.id — NOT NULL
  • template_code — varchar(200) — NOT NULL
  • template_name — varchar(200) — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

registration_managements

  • id — serial4 — Primary key — NOT NULL
  • group_name — varchar(100)
  • name — varchar(100)
  • email — varchar(320) — NOT NULL
  • password — varchar(500)
  • login_fail_count — int4 — NOT NULL
  • updated_pw_date — timestamptz
  • phone — varchar(100)
  • access_ip_v4 — varchar(100)
  • access_ip_v6 — varchar(100)
  • balance — int4
  • buy_item_list — _json
  • last_login — timestamptz
  • last_logout — timestamptz
  • menu_auth — _json
  • active — bool — NOT NULL
  • personal_info_agreement — bool
  • business_registration_num — varchar(100)
  • payment_date — timestamptz
  • industry — varchar(100) — NOT NULL
  • available_consultation_hour — varchar(100) — NOT NULL
  • business_registration_pdf — varchar(100) — NOT NULL
  • validation_completed — bool — NOT NULL
  • company_phone_number — varchar(50)
  • company_website_address — varchar(500)
  • request_comment — varchar(255)
  • linked_equipment_list — varchar(4000)
  • approval_date — timestamptz
  • terms_agreement_date — timestamptz
  • progress_status — varchar(50)
  • memo — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz
  • group_code — varchar(300)

repair_histories

  • id — serial4 — Primary key — NOT NULL
  • facility_name — varchar(255)
  • description — text
  • manager — varchar(255)
  • day — varchar(255)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

role_permissions

  • role_id — int4 — Foreign key → roles.id — NOT NULL
  • permission_id — int4 — Foreign key → permissions.id — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

roles

  • id — serial4 — NOT NULL
  • group_id — int4
  • name — varchar(200)
  • role_name — varchar(200)
  • description — varchar(200)
  • is_default — bool
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

service_metrics

  • id — serial4 — NOT NULL
  • user_id — int4
  • user_name — varchar(100)
  • group_id — int4
  • group_name — varchar(100)
  • subscription_start — timestamptz
  • subscription_end — timestamptz
  • data_collect_srv_usage — numeric(7, 3)
  • data_analysis_srv_usage — numeric(7, 3)
  • remain_subscriptions — int4
  • additional_fee — numeric(11, 3)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

tag_data_infos

  • id — serial4 — NOT NULL
  • group_id — int4 — NOT NULL
  • category_id — int4 — NOT NULL
  • protocol_type_template_id — int4
  • item — varchar(200) — NOT NULL
  • default_code_id — int4
  • default_value — varchar(200)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

temp_modeler_structures

  • id — serial4 — NOT NULL
  • group_id — int4 — NOT NULL
  • name — varchar(300)
  • parent_id — int4
  • level — int4
  • full_path — varchar(300)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

temp_modelers

  • id — serial4 — NOT NULL
  • user_id — int4
  • group_id — int4 — NOT NULL
  • name — varchar(255) — NOT NULL
  • nodes — json
  • connections — json
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • temp_modeler_structure_id — int4

token_histories

  • id — serial4 — Primary key — NOT NULL
  • user_id — int4
  • action — varchar(30)
  • access_token — varchar(500)
  • access_expire — timestamptz
  • client_ip — varchar(255)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

user_roles

  • user_id — int4 — Foreign key → users.id — NOT NULL
  • role_id — int4 — Foreign key → roles.id — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

users

  • id — serial4 — NOT NULL
  • group_id — int4
  • name — varchar(100)
  • email — varchar(320) — NOT NULL
  • password — varchar(500)
  • login_fail_count — int4 — NOT NULL
  • updated_pw_date — timestamptz
  • phone — varchar(100)
  • access_ip_v4 — varchar(100)
  • access_ip_v6 — varchar(100)
  • balance — int4
  • buy_item_list — _json
  • last_login — timestamptz
  • last_logout — timestamptz
  • menu_auth — _json
  • active — bool — NOT NULL
  • personal_info_agreement — bool
  • business_registration_num — varchar(100)
  • payment_date — timestamptz
  • industry — varchar(100)
  • available_consultation_hour — varchar(100)
  • business_registration_pdf — varchar(100)
  • validation_completed — bool
  • company_phone_number — varchar(50)
  • company_website_address — varchar(500)
  • request_comment — varchar(4000)
  • linked_equipment_list — varchar(4000)
  • approval_date — timestamptz
  • terms_agreement_date — timestamptz
  • progress_status — varchar(50)
  • delete_request_date — timestamptz
  • device_collection_date — timestamptz
  • memo — text
  • customer_file_management — _varchar
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz