test
Tables (17)
edge_ai_model_management
- ai_model_management_Index — int — Primary key — NOT NULL
- ai_Name — varchar(50) — NOT NULL
- edge_name — varchar(50) — NOT NULL
edge_categories
- category_id — smallint — Primary key — NOT NULL
- category_name — varchar(50) — NOT NULL
- description — varchar(100)
edge_code_group_send_periods
- edge_code_group_send_period_Index — VARCHAR(255) — Primary key — NOT NULL
- facility_mgmt_index — int — Foreign key → facility_management.facility_management_Index — NOT NULL
- code_id_tag_group — int — Foreign key → edge_codes.code_id — NOT NULL
- send_period — smallint — NOT NULL
edge_codes
- code_id — int — Primary key — NOT NULL
- value — varchar(50) — NOT NULL — 화면에서
- description — varchar(100)
- ordering — smallint — NOT NULL
- active — bool — NOT NULL
- category_id — smallint — Foreign key → edge_categories.category_id — NOT NULL
edge_history
- facility_management_Index — int — Foreign key → facility_management.facility_management_Index — NOT NULL
- edge_management_Index — int — Foreign key → edge_management.edge_management_Index — NOT NULL
- install_datetime — timestamp
- retrieve_datetime — timestamp
edge_management
- edge_management_Index — int — Primary key — NOT NULL
- edge_code — varchar(50) — NOT NULL
- edge_name — varchar(50) — NOT NULL
- edge_model — varchar(100) — NOT NULL
- buying_datetime — timestamp — NOT NULL
- supplier — varchar(100) — NOT NULL
- price — int
- buyer — varchar(100)
edge_protocol_connection_infos
- index — int — Primary key — NOT NULL
- protocol_template_id — smallint — Foreign key → protocol_templates.protocol_template_id — NOT NULL
- item — varchar(50) — NOT NULL — 연결
- value — varchar(50) — NOT NULL
- description — varchar(100)
- category_id — smallint — Foreign key → edge_categories.category_id
- ordering — smallint — NOT NULL
- active — bool — NOT NULL
edge_protocol_tag_data_infos
- protocol_tag_data_info_id — int — Primary key — NOT NULL
- protocol_template_id — smallint — Foreign key → protocol_templates.protocol_template_id — NOT NULL
- item — varchar(50) — NOT NULL — 태그
- value — varchar(50) — NOT NULL
- description — varchar(100)
- category_id — smallint — Foreign key → edge_categories.category_id
- ordering — smallint — NOT NULL
- active — bool — NOT NULL
edge_protocol_tag_templates
- protocol_tag_template_index — int — Primary key — NOT NULL
- template_code — VARCHAR(255)
- name — varchar(100) — NOT NULL
- protocol_template_id — smallint — Foreign key → protocol_templates.protocol_template_id — NOT NULL
edge_protocol_tag_templates_tag_infos_relations
- protocol_tag_template_index — int — Foreign key → edge_protocol_tag_templates.protocol_tag_template_index — NOT NULL
- edge_tag_info_index — int — Foreign key → edge_tag_infos.edge_tag_info_index — NOT NULL
edge_system_configurataion
- system_configurataion_index — smallint — Primary key — NOT NULL
- item — varchar(50) — NOT NULL
- value — varchar(100) — NOT NULL
- active — bool — NOT NULL
edge_tag_bit_ops
- edge_tag_bit_op_index — smallint — Primary key — NOT NULL
- edge_tag_info_index — int — Foreign key → edge_tag_infos.edge_tag_info_index — NOT NULL
- code_id_bit_operator — int — Foreign key → edge_codes.code_id — NOT NULL
- bit_operand — varchar(100) — NOT NULL
- code_id_data_type — int — Foreign key → edge_codes.code_id — NOT NULL
- active — bool — NOT NULL
edge_tag_events
- edge_tag_event_index — smallint — Primary key — NOT NULL
- edge_tag_info_index — int — Foreign key → edge_tag_infos.edge_tag_info_index — NOT NULL
- code_id_operator — int — Foreign key → edge_codes.code_id — NOT NULL
- operand — varchar(100) — NOT NULL
- code_id_event_level — int — Foreign key → edge_codes.code_id — NOT NULL
- code_id_event_type — int — Foreign key → edge_codes.code_id — NOT NULL
- active — bool — NOT NULL
- message — varchar(1000)
edge_tag_infos
- edge_tag_info_index — int — Primary key — NOT NULL
- tag_id — varchar(50) — NOT NULL
- tag_name — varchar(100) — NOT NULL
- code_id_tag_group — int — Foreign key → edge_codes.code_id — NOT NULL
- code_id_tag_unit — int — Foreign key → edge_codes.code_id — NOT NULL
- code_id_tag_format — int — Foreign key → edge_codes.code_id — NOT NULL
- code_id_tag_endian — int — Foreign key → edge_codes.code_id — NOT NULL
- decimal_Point1 — float — NOT NULL
- decimal_Point2 — int — NOT NULL
- code_id_tag_decimal_op — int — Foreign key → edge_codes.code_id — NOT NULL
- active — bool — NOT NULL
edge_tag_scales
- edge_tag_scale_index — smallint — Primary key — NOT NULL
- edge_tag_info_index — int — Foreign key → edge_tag_infos.edge_tag_info_index — NOT NULL
- input_min — int — NOT NULL
- input_max — int — NOT NULL
- ui_min — int — NOT NULL
- ui_max — int — NOT NULL
facility_management
- facility_management_Index — int — Primary key — NOT NULL
- facility_id — varchar(100) — NOT NULL
- facility_name — varchar(100) — NOT NULL
- description — varchar(200)
- ai_model_management_Index — integer — Foreign key → edge_ai_model_management.ai_model_management_Index — NOT NULL
- protocol_tag_template_index — int — Foreign key → edge_protocol_tag_templates.protocol_tag_template_index — NOT NULL
- aggr_period — smallint — NOT NULL
- send_period — smallint — NOT NULL
protocol_templates
- protocol_template_id — smallint — Primary key — NOT NULL
- type — varchar(100) — NOT NULL