CEMS_AI_2
Tables (23)
action
- action_id — varchar(255) — Primary key — NOT NULL
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
alarm
- alarm_id — varchar(255) — Primary key — NOT NULL
- alarm_setting_id — varchar(255) — Foreign key → alarm_setting.alarm_setting_id — NOT NULL
- action_id — varchar(255) — Foreign key → action.action_id — NOT NULL
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- min — float
- max — float
- alarm_name — varchar(255)
- tag_name — varchar(255)
alarm_history
- alarm_history_id — varchar(255) — Primary key — NOT NULL
- alarm_id — varchar(255) — Foreign key → alarm.alarm_id — NOT NULL
- alarm_setting_id — varchar(255) — Foreign key → alarm.alarm_setting_id — NOT NULL
- action_id — varchar(255) — Foreign key → alarm.action_id — NOT NULL
- company_id — varchar(255) — Foreign key → alarm.company_id — NOT NULL
- alarm_value — float
- alarm_time — datetime
- min — float
- max — float
- alarm_check — varchar(255)
- alarm_done — varchar(255)
alarm_setting
- alarm_setting_id — varchar(255) — Primary key — NOT NULL
- mail_group_id — varchar(255) — Foreign key → mail_group.mail_group_id — NOT NULL
- company_id — varchar(255) — Foreign key → mail_group.company_id — NOT NULL
- conf — text
- type — varchar(255)
- alarm_setting_name — varchar(255)
client
- client_id — varchar(255) — Primary key — NOT NULL
- client_ip — varchar(255)
- client_port — varchar(255)
- client_name — varchar(255)
- sysinfo_time — int
- event_duration — int
- timer_interval — int
- keep_data — int
- delete_interval — int
- use_origin_tag — varchar(255)
- change_base_time — varchar(255)
- save_sysinf — varchar(255)
- max_taglet_idx — int
company
- company_id — varchar(255) — Primary key — NOT NULL
- vendor_id — varchar(255) — Foreign key → vendor.vendor_id — NOT NULL
- company_name — varchar(255) — NOT NULL
company_max_idx
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- max_equip_idx — int
- max_client_idx — int
- max_alarm_idx — int
- max_mail_group_idx — int
- max_action_idx — int
- max_report_idx — int
- max_img_idx — int
- max_board_idx — int
dashboard
- board_id — varchar(255) — Primary key — NOT NULL
- board_name — varchar(255)
- panels — text
- range_bgn — varchar(255)
- range_end — varchar(255)
- refresh — varchar(255)
equip
- euqip_id — varchar(255) — Primary key — NOT NULL
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- equip_name — varchar(255)
- assigned — varchar(255)
equip_to_edge
- euqip_id — varchar(255) — Foreign key → equip.euqip_id — NOT NULL
- company_id — varchar(255) — Foreign key → equip.company_id — NOT NULL
- client_id — varchar(255) — Foreign key → client.client_id — NOT NULL
group
- group_id — varchar(255) — Primary key — NOT NULL
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- group_tree — text
image
- image_id — varchar(255) — Primary key — NOT NULL
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- image_blob — text
mail_group
- mail_group_id — varchar(255) — Primary key — NOT NULL
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- addr_list — text
member
- member_id — varchar(255) — Primary key — NOT NULL
- permmission_id — varchar(255) — Foreign key → permission.permmission_id — NOT NULL
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- home_group — varchar(255)
permission
- permmission_id — varchar(255) — Primary key — NOT NULL
- name — varchar(255)
- info — text
report
- report_id — varchar(255) — Primary key — NOT NULL
- mail_group_id — varchar(255) — Foreign key → mail_group.mail_group_id — NOT NULL
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- board_id2 — varchar(255) — Foreign key → dashboard.board_id — NOT NULL
- sched_type — varchar(255)
- sched_value — varchar(255)
- sched_time — varchar(255)
- report_type — varchar(255)
- csv_tag_list — text
- csv_begin — varchar(255)
- csv_end — varchar(255)
- csv_interval — varchar(255)
- report_title — varchar(255)
- report_start — datetime
- report_stop — datetime
- report_content — text
- report_name — varchar(255)
- csv_aggr — varchar(255)
server_config
- company_id — varchar(255) — Foreign key → company.company_id — NOT NULL
- key — varchar(255)
- value — varchar(255)
- type — varchar(255)
setting_config
- key — varchar(255)
- value — varchar(255)
- type — varchar(255)
tag
- tag_id — varchar(255) — Primary key — NOT NULL
- taglet_id — varchar(255) — Foreign key → taglet.taglet_id — NOT NULL
- tag_name — varchar(255)
- scale — float
- replication_using — varchar(255)
- save_data — varchar(255)
- effective_from — float
- effective_to — float
- effective_using — varchar(255)
- noinput_using — varchar(255)
tag_name_maps
- tag_id — varchar(255) — Foreign key → tag.tag_id — NOT NULL
- alarm_id — varchar(255) — Foreign key → alarm.alarm_id — NOT NULL
taglet
- taglet_id — varchar(255) — Primary key — NOT NULL
- client_id — varchar(255) — Foreign key → client.client_id — NOT NULL
- use_all_tag — varchar(255)
- taglet_name — varchar(255)
- taglet_format — varchar(255)
- profile_id — varchar(255)
- max_tag_count — int
- taglet_config — varchar(255)
- taglet_info — varchar(255)
- byte_one — int
- byte_count — int
- csv_use_header — varchar(255)
- csv_separator — varchar(255)
- csv_time_column — int
- date_format — varchar(255)
- max_tag_idx — int
taglet_profile
- profile_id — varchar(255)
- profile — varchar(255)
vendor
- vendor_id — varchar(255) — Primary key — NOT NULL