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