AICloud
Tables (40)
Untitled (ai_setting_config)
- Key (setting_id) — int — Primary key — NOT NULL
- Field (key) — varchar(255)
- Field (value) — varchar(255)
- Field (type) — varchar(32)
Untitled (ai_default_plugin)
- Key (default_plugin_id) — int — Primary key — NOT NULL
- Field (name) — varchar(128) — NOT NULL
- Field (desc) — text
- Field (work_interval) — float — NOT NULL
- Field (extract) — json
- Field (preprocess) — json
- Field (execute) — json
- Field (postprocess) — json
- Field (examine) — json
action
- action_id — int — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- action_conf — text
- action_name — varchar(40)
- action_type — varchar(20)
- action_desc — text
- act_pre_id — int
ai_access_log(machbase) (ai_access_log)
- access_log_id — int — Primary key — NOT NULL
- service_id — int — Foreign key → ai_service.service_id — NOT NULL
- ip — varchar(16) — NOT NULL
- method — varchar(10) — NOT NULL
- url — text
- data — json
- return — text
ai_alarm
- alarm_id — int — Primary key — NOT NULL
- service_id — int — Foreign key → ai_service.service_id — NOT NULL
- message — text
- type — varchar(16) — NOT NULL
- badge — bool — NOT NULL
- level — int — NOT NULL
- alarm_time (datetime) — varchar(32) — NOT NULL
- fetch_start_time — varchar(32) — NOT NULL
- fetch_end_time — varchar(32) — NOT NULL
- Field (anomaly_score) — float — NOT NULL
- query — text
ai_batch
- batch_id — int — Primary key — NOT NULL
- service_id — int — Foreign key → ai_service.service_id — NOT NULL
- active — bool — NOT NULL
- batch_start_time — varchar(32) — NOT NULL
- batch_end_time — varchar(32) — NOT NULL
- init_time — varchar(32) — NOT NULL
- adj_batch_start_time — varchar(32) — NOT NULL
- adj_batch_end_time — varchar(32) — NOT NULL
- last_minibatch_time — varchar(32) — NOT NULL
ai_plugin
- plugin_id — int — Primary key — NOT NULL
- name — varchar(128) — NOT NULL
- desc — text
- version — varchar(32) — NOT NULL
- release_date — varchar(32) — NOT NULL
- work_interval — float — NOT NULL
- extract — json
- preprocess — json
- execute — json
- postprocess — json
- examine — json
- status — varchar(20) — NOT NULL
- progress — int — NOT NULL
ai_plugin_to_equip
- plugin_id — int — Foreign key → ai_plugin.plugin_id — NOT NULL
- equip_id — int — Foreign key → equipment.equip_id — NOT NULL
- sample — boolean — NOT NULL
ai_plugin_to_tag
- plugin_id — int — Foreign key → ai_plugin.plugin_id — NOT NULL
- tag_id — varchar(255) — Foreign key → tag.tag_id — NOT NULL
ai_schedule
- schedule_id — int — Primary key — NOT NULL
- service_id — int — Foreign key → ai_service.service_id — NOT NULL
- name — varchar(128) — NOT NULL
- desc — text
- active — bool — NOT NULL
- active_from — varchar(32) — NOT NULL
- active_until — varchar(32) — NOT NULL
- status — varchar(16) — NOT NULL
ai_schedule_job
- schedule_job_id — int — Primary key — NOT NULL
- schedule_id — int — Foreign key → ai_schedule.schedule_id — NOT NULL
- cron — varchar(32) — NOT NULL
- duration — varchar(32) — NOT NULL
ai_service
- service_id — int — Primary key — NOT NULL
- equip_id — int — Foreign key → equipment.equip_id — NOT NULL
- name — varchar(128) — NOT NULL
- desc — text
- execute_count — int — NOT NULL
- anomaly_count — int — NOT NULL
- status — varchar(16) — NOT NULL
- query — text
- create_time — varchar(32) — NOT NULL
- start_time — varchar(32) — NOT NULL
- Field (last_data_time) — varchar(32) — NOT NULL
ai_service_config
- service_id — int — Foreign key → ai_service.service_id — NOT NULL
- plugin_id — int — Foreign key → ai_plugin.plugin_id — NOT NULL
- name — varchar(128) — NOT NULL
- desc — text
- version — varchar(16) — NOT NULL
- release_date — varchar(32) — NOT NULL
- work_interval — float — NOT NULL
- extract — json
- preprocess — json
- execute — json
- postprocess — json
- examine — json
ai_service_to_tag
- service_id — int — Foreign key → ai_service.service_id — NOT NULL
- tag_id — varchar(255) — Foreign key → tag.tag_id — NOT NULL
ai_trace_log(machbase) (ai_trace_log)
- trace_log_id — int — Primary key — NOT NULL
- service_id — int — Foreign key → ai_service.service_id — NOT NULL
- level — varchar(10) — NOT NULL
- message — text
- time (datetime) — varchar(32) — NOT NULL
ai_user_to_plugin (ai_member_to_plugin)
- plugin_id — int — Foreign key → ai_plugin.plugin_id — NOT NULL
- member_id — varchar(255) — Foreign key → member.member_id — NOT NULL
ai_user_to_service (ai_member_to_service)
- service_id — int — Foreign key → ai_service.service_id — NOT NULL
- member_id — varchar(255) — Foreign key → member.member_id — NOT NULL
- Field (favorite) — tinyint(1) — NOT NULL
alarm
- alarm_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- min — float
- max — float
- alarm_name — varchar(255)
- tag_name — varchar(255)
- risk — int
- remark — text
alarm_action
- alarm_id — varchar(255) — Primary key — NOT NULL
- action_id — int — Primary key — NOT NULL
- msg_id — varchar(255) — Primary key — NOT NULL
- action_type — varchar(2)
alarm_history
- alarm_history_id — varchar(255) — Primary key — NOT NULL
- alarm_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- alarm_value — float
- alarm_time — datetime
- min — float
- max — float
- alarm_check — varchar(255)
- alarm_done — varchar(255)
- tag_id — varchar(255)
- alarm_type — varchar(255)
- ai_link — varchar(255)
- ai_reffer — varchar(255)
- comment — text
client
- client_id — varchar(255) — Primary key — NOT NULL
- client_ip — varchar(255)
- client_port — varchar(255)
- client_name — varchar(255)
- sysinfo_time — int
- timer_interval — int
- keep_data — int
- delete_interval — int
- use_origin_tag — varchar(255)
- change_base_time — varchar(255)
- max_taglet_idx — int
- machlake_key — varchar(255)
- machlake_id — varchar(40)
- tag_prefix — varchar(30)
company
- company_id — int — Primary key — NOT NULL
- vendor_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- email — varchar(100)
- phone — varchar(11)
- is_delete — int
- timezone_key — varchar(50)
- timezone_value — varchar(10)
company_max_idx
- company_id — int — Primary key — NOT NULL
- max_client_idx — int
- max_alarm_idx — int
- max_alarm_history_idx — int
- max_mail_group_idx — int
- max_messenger_idx — int
- max_action_idx — int
- max_report_idx — int
- max_img_idx — int
- max_board_idx — int
- max_group_idx — int
dashboard
- board_id — varchar(255) — Primary key — NOT NULL
- member_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_to_edge
- equip_id — int — Primary key — NOT NULL
- client_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
equipment
- equip_id — int — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- software_id — int
- preset_id — int
- patch_id — int
- name — varchar(100)
- serial — varchar(100)
- ip — varchar(255)
- status — int
- create_date — datetime
- update_date — datetime
- is_assign — int
- is_delete — int
group
- group_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- group_tree — text
image
- image_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- image_blob — longblob
mail_group
- mail_group_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- addr_list — text
- mail_group_name — varchar(40)
member
- member_id — varchar(255) — Primary key — NOT NULL
- permission_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- board_id — varchar(255) — Primary key — NOT NULL
- home_group — varchar(255)
- home_page — varchar(255)
- password — VARCHAR(255)
- timezone_key — varchar(50)
- timezone_value — varchar(10)
messenger
- msg_id — varchar(255) — Primary key — NOT NULL
- mail_group_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- msg_conf — text
- msg_type — varchar(255)
- msg_name — varchar(40)
- msg_content — text
permission
- permission_id — varchar(255) — Primary key — NOT NULL
- name — varchar(255)
- info — text
report
- report_id — varchar(255) — Primary key — NOT NULL
- company_id — int — Primary key — NOT NULL
- board_id — varchar(255) — Primary key — NOT NULL
- msg_id — varchar(255) — Primary key — NOT NULL
- member_id — varchar(255) — Primary key — NOT NULL
- sched_type — varchar(255)
- sched_value — varchar(255)
- sched_time — varchar(255)
- report_type — varchar(255)
- data_from — varchar(255)
- data_to — varchar(255)
- csv_tag_list — text
- csv_interval — int
- csv_interval_unit — VARCHAR(255)
- csv_aggr — varchar(255)
- report_title — varchar(255)
- report_start — datetime
- report_stop — datetime
- report_content — text
- report_name — varchar(255)
server_config
- company_id — int — Primary key — 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) — Primary key — NOT NULL
- equip_id — int — Primary key — NOT NULL
- tag_name — varchar(255)
- alias — varchar(255)
- offset — float
- 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) — Primary key — NOT NULL
- alarm_id — varchar(255) — Primary key — NOT NULL
taglet
- taglet_id — varchar(255) — Primary key — NOT NULL
- client_id — varchar(255) — Primary key — 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_storage
- profile_id — varchar(255)
- taglet_profile — longblob — 미리 설정되어있는 기본 설정 값이 json format으로 구성된 파일
- taglet_html — longblob — taglet 별 상세 설정에서 출력될 화면을 위한 html
vendor
- vendor_id — int — Primary key — NOT NULL
- admin_id — int
- name — varchar(100)
- user_id — varchar(100)
- user_pwd — varchar(64)
- create_date — datetime
- phone — varchar(11)
- email — varchar(100)
- token — varchar(64)
- status — int
- is_delete — int