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