CEMS-ERD by shawn

수환님 외래키 설정 작

테이블 (37)

action

  • action_id — int — 기본 키 — NOT NULL
  • action_preset_id — int — 외래 키 → action_preset.action_preset_id — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • action_conf — text — NOT NULL
  • action_name — varchar(40) — NOT NULL
  • action_type — varchar(20) — NOT NULL
  • action_desc — text — NOT NULL

action_preset

  • action_preset_id — int — 기본 키 — NOT NULL
  • vendor_id — int — 외래 키 → vendor.vendor_id — NOT NULL
  • admin_id — int — 외래 키 → vendor.admin_id — NOT NULL
  • action_conf — text — NOT NULL
  • action_name — varchar(40) — NOT NULL
  • action_type — varchar(20) — NOT NULL
  • action_desc — text — NOT NULL
  • is_delete — int — NOT NULL

admin

  • admin_id — int — 기본 키 — NOT NULL
  • user_id — varchar(100) — NOT NULL
  • user_pwd — varchar(64) — NOT NULL
  • level — int — NOT NULL
  • token — varchar(300)
  • is_delete — int — NOT NULL

alarm

  • alarm_id — varchar(30) — 기본 키 — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • min — float — NOT NULL
  • max — float — NOT NULL
  • alarm_name — varchar(100) — NOT NULL
  • tag_name — varchar(100) — NOT NULL
  • risk — int — NOT NULL
  • remark — text — NOT NULL
  • notice_interval — int — NOT NULL
  • alarm_type — varchar(30) — NOT NULL
  • is_delete — varchar(1) — NOT NULL
  • last_modified — datetime — NOT NULL
  • modified_member — varchar(100) — NOT NULL

alarm_action

  • alarm_id — varchar(30) — 외래 키 → alarm.alarm_id — NOT NULL
  • action_id — int — 외래 키 → action.action_id
  • msg_id — varchar(30) — 외래 키 → messenger.msg_id
  • action_type — varchar(2) — NOT NULL

alarm_history

  • alarm_history_id — varchar(40) — 기본 키 — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • alarm_id — varchar(30) — NOT NULL
  • alarm_value — float — NOT NULL
  • alarm_time — datetime — NOT NULL
  • min — float — NOT NULL
  • max — float — NOT NULL
  • alarm_check — varchar(1) — NOT NULL
  • alarm_done — varchar(1) — NOT NULL
  • tag_id — varchar(30) — NOT NULL
  • alarm_type — varchar(10) — NOT NULL
  • ai_link — varchar(100) — NOT NULL
  • ai_reffer — varchar(100) — NOT NULL
  • comment — text — NOT NULL

category

  • category_name — NOT NULL
  • info

client

  • client_id — varchar(30) — 기본 키 — NOT NULL
  • client_ip — varchar(100) — NOT NULL
  • client_port — varchar(5) — NOT NULL
  • client_name — varchar(100) — NOT NULL
  • sysinfo_time — int — NOT NULL
  • timer_interval — int — NOT NULL
  • keep_data — int — NOT NULL
  • delete_interval — int — NOT NULL
  • use_origin_tag — varchar(1) — NOT NULL
  • use_base_time — varchar(1) — NOT NULL
  • max_taglet_idx — int — NOT NULL
  • machlake_key — varchar(255) — NOT NULL
  • machlake_id — varchar(20) — NOT NULL
  • tag_prefix — varchar(30) — NOT NULL
  • company_id — int — NOT NULL
  • equipment_id — int — NOT NULL

company

  • company_id — int — 기본 키 — NOT NULL
  • vendor_id — int — 외래 키 → vendor.vendor_id — NOT NULL
  • logo_image_id — int — 외래 키 → logo_image.logo_image_id — NOT NULL
  • copyright_id — int — 외래 키 → copyright.copyright_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • email — varchar(100) — NOT NULL
  • phone — varchar(11) — NOT NULL
  • admin_id — varchar(100) — NOT NULL
  • installer_id — varchar(100) — NOT NULL
  • timezone_key — varchar(50) — NOT NULL
  • timezone_value — varchar(10) — NOT NULL
  • address — varchar(255) — NOT NULL
  • is_delete — int — NOT NULL
  • machlake_key — varchar(255) — NOT NULL
  • machlake_id — varchar(20) — NOT NULL

company_max_idx

  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • max_client_idx — int — NOT NULL
  • max_alarm_idx — int — NOT NULL
  • max_alarm_history_idx — int — NOT NULL
  • max_mail_group_idx — int — NOT NULL
  • max_msg_idx — int — NOT NULL
  • max_action_idx — int — NOT NULL
  • max_report_idx — int — NOT NULL
  • max_img_idx — int — NOT NULL
  • max_board_idx — int — NOT NULL
  • max_group_idx — int — NOT NULL

company_setting

  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • key — varchar(30) — NOT NULL
  • value — varchar(200) — NOT NULL
  • type — varchar(10) — NOT NULL

copyright

  • copyright_id — int — 기본 키 — NOT NULL
  • vendor_id — int — 외래 키 → vendor.vendor_id — NOT NULL
  • name — varchar(100)
  • content — varchar(300)
  • style — text
  • is_delete — int — NOT NULL

dashboard

  • board_id — varchar(30) — 기본 키 — NOT NULL
  • member_id — varchar(100) — 외래 키 → member.member_id — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • board_name — varchar(100) — NOT NULL
  • panels — text — NOT NULL
  • range_bgn — varchar(30) — NOT NULL
  • range_end — varchar(30) — NOT NULL
  • refresh — varchar(30) — NOT NULL

equip_to_edge

  • equipment_id — int — 외래 키 → equipment.equipment_id — NOT NULL
  • client_id — varchar(30) — 외래 키 → client.client_id — NOT NULL

equipment

  • equipment_id — int — 기본 키 — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • vendor_id — int — 외래 키 → company.vendor_id — NOT NULL
  • software_id — int — 외래 키 → software.software_id
  • preset_id — int — 외래 키 → preset.preset_id
  • patch_id — int — 외래 키 → patch.patch_id
  • name — varchar(100) — NOT NULL
  • serial — varchar(100) — NOT NULL
  • ip — varchar(100)
  • status — int — NOT NULL
  • create_date — datetime — NOT NULL
  • update_date — datetime
  • is_assign — int — NOT NULL
  • is_delete — int — NOT NULL
  • is_grouped — int — NOT NULL

equipment_log

  • equipment_log_id — int — 기본 키 — NOT NULL
  • equipment_id — int — 외래 키 → equipment.equipment_id — NOT NULL
  • company_id — int — 외래 키 → equipment.company_id — NOT NULL
  • vendor_id — int — 외래 키 → equipment.vendor_id — NOT NULL
  • create_date — datetime — NOT NULL
  • type — varchar(30) — NOT NULL
  • title — varchar(40) — NOT NULL
  • description — varchar(150) — NOT NULL
  • log — longblob — NOT NULL
  • is_delete — int — NOT NULL

group_info (group)

  • group_id — varchar(30) — 기본 키 — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • group_tree — text — NOT NULL

image

  • image_id — varchar(30) — 기본 키 — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • image_blob — longblob — NOT NULL

installer

  • installer_id — int — 기본 키 — NOT NULL
  • major — int — NOT NULL
  • minor — int — NOT NULL
  • hotfix — int — NOT NULL
  • create_date — datetime — NOT NULL
  • description — varchar(1000) — NOT NULL
  • src_path — varchar(300) — NOT NULL
  • download_count — int — NOT NULL
  • is_delete — int — NOT NULL

logo_image

  • logo_image_id — int — 기본 키 — NOT NULL
  • vendor_id — int — 외래 키 → vendor.vendor_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • src — longblob — NOT NULL
  • is_delete — int — NOT NULL

mail_group

  • mail_group_id — varchar(30) — 기본 키 — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • addr_list — text — NOT NULL
  • mail_group_name — varchar(40) — NOT NULL

member

  • member_id — varchar(100) — 기본 키 — NOT NULL
  • permission_id — varchar(30) — 외래 키 → permission.permission_id — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • board_id — varchar(30) — NOT NULL
  • home_group — varchar(30) — NOT NULL
  • home_page — varchar(30) — NOT NULL
  • password — varchar(255) — NOT NULL
  • timezone_key — varchar(50) — NOT NULL
  • timezone_value — varchar(10) — NOT NULL

messenger

  • msg_id — varchar(30) — 기본 키 — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • mail_group_id — varchar(30) — NOT NULL
  • msg_conf — text — NOT NULL
  • msg_type — varchar(10) — NOT NULL
  • msg_name — varchar(40) — NOT NULL
  • msg_content — text — NOT NULL
  • is_late_send — int — NOT NULL

patch

  • patch_id — int — 기본 키 — NOT NULL
  • name — varchar(100) — NOT NULL
  • description — varchar(1000) — NOT NULL
  • src_path — varchar(300) — NOT NULL
  • download_count — int — NOT NULL
  • is_delete — int — NOT NULL
  • old_major — int — NOT NULL
  • old_minor — int — NOT NULL
  • old_hotfix — int — NOT NULL
  • current_major — int — NOT NULL
  • current_minor — int — NOT NULL
  • current_hotfix — int — NOT NULL
  • category_name — varchar(50) — NOT NULL

payment

  • payment_id — int — 기본 키 — NOT NULL
  • vendor_id — int — 외래 키 → vendor.vendor_id — NOT NULL
  • amount — int — NOT NULL
  • method — int — NOT NULL
  • description — varchar(300) — NOT NULL
  • status — int — NOT NULL
  • create_date — datetime — NOT NULL
  • contract_date — datetime
  • is_delete — int — NOT NULL

permission

  • permission_id — varchar(30) — 기본 키 — NOT NULL
  • name — varchar(30) — NOT NULL
  • info — text — NOT NULL

preset

  • preset_id — int — 기본 키 — NOT NULL
  • software_id — int — 외래 키 → software.software_id — NOT NULL
  • vendor_id — int — 외래 키 → vendor.vendor_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • description — varchar(1000) — NOT NULL
  • src_path — varchar(300) — NOT NULL
  • create_date — datetime — NOT NULL
  • update_date — datetime
  • download_count — int — NOT NULL
  • is_delete — int — NOT NULL

receive_late_report

  • rs_id — int — 외래 키 → receive_setting.rs_id — NOT NULL
  • alarm_history_id — varchar(30) — 외래 키 → alarm_history.alarm_history_id — NOT NULL
  • send_time — datetime — NOT NULL

receive_setting

  • rs_id — int — 기본 키 — NOT NULL
  • msg_id — varchar(30) — 외래 키 → messenger.msg_id — NOT NULL
  • time_set — text — NOT NULL
  • rs_conf — text — NOT NULL

report

  • report_id — varchar(30) — 기본 키 — NOT NULL
  • company_id — int — 외래 키 → company.company_id — NOT NULL
  • board_id — varchar(30) — 외래 키 → dashboard.board_id
  • member_id — varchar(100) — 외래 키 → member.member_id — NOT NULL
  • mail_group_id — varchar(30) — 외래 키 → mail_group.mail_group_id — NOT NULL
  • sched_type — varchar(10) — NOT NULL
  • sched_value — varchar(10) — NOT NULL
  • sched_time — varchar(10) — NOT NULL
  • report_type — varchar(20) — NOT NULL
  • data_from — varchar(50) — NOT NULL
  • data_to — varchar(50) — NOT NULL
  • csv_tag_list — text
  • csv_interval — int
  • csv_interval_unit — VARCHAR(10)
  • csv_aggr — varchar(10)
  • report_title — varchar(100) — NOT NULL
  • report_start — datetime — NOT NULL
  • report_stop — datetime — NOT NULL
  • report_content — text — NOT NULL
  • report_name — varchar(100) — NOT NULL

setting

  • key — varchar(30) — 기본 키 — NOT NULL
  • value — varchar(200) — NOT NULL
  • type — varchar(10) — NOT NULL

software

  • software_id — int — 기본 키 — NOT NULL
  • name — varchar(300) — NOT NULL
  • major — int — NOT NULL
  • minor — int — NOT NULL
  • hotfix — int — NOT NULL
  • src_path — varchar(300) — NOT NULL
  • create_date — datetime — NOT NULL
  • update_date — datetime
  • download_count — int — NOT NULL
  • is_delete — int — NOT NULL
  • category_name — varchar(50) — NOT NULL

tag

  • tag_id — varchar(30) — 기본 키 — NOT NULL
  • taglet_id — varchar(30) — 외래 키 → taglet.taglet_id — NOT NULL
  • equipment_id — int — 외래 키 → equipment.equipment_id — NOT NULL
  • tag_name — varchar(100) — NOT NULL
  • alias — varchar(100) — NOT NULL
  • offset — float — NOT NULL
  • scale — float — NOT NULL
  • copy_data — varchar(1) — NOT NULL
  • save_data — varchar(1) — NOT NULL
  • effective_from — float — NOT NULL
  • effective_to — float — NOT NULL
  • effective_using — varchar(1) — NOT NULL
  • noinput_using — varchar(1) — NOT NULL

tag_name_maps

  • tag_id — varchar(30) — 외래 키 → tag.tag_id — NOT NULL
  • alarm_id — varchar(30) — 외래 키 → alarm.alarm_id — NOT NULL
  • max — float — NOT NULL
  • min — float — NOT NULL

taglet

  • taglet_id — varchar(30) — 기본 키 — NOT NULL
  • client_id — varchar(30) — 외래 키 → client.client_id — NOT NULL
  • taglet_name — varchar(100) — NOT NULL
  • taglet_format — varchar(20) — NOT NULL
  • profile_id — varchar(50) — NOT NULL
  • max_tag_count — int — NOT NULL
  • taglet_config — text — NOT NULL
  • taglet_info — text — NOT NULL
  • byte_one — int — NOT NULL
  • byte_count — int — NOT NULL
  • byte_data_type — varchar — NOT NULL
  • byte_endian — varchar — NOT NULL
  • csv_skip_first — varchar — NOT NULL
  • csv_separator — varchar — NOT NULL
  • csv_time_column — int — NOT NULL
  • csv_header — varchar — NOT NULL
  • date_format — varchar — NOT NULL
  • max_tag_idx — int — NOT NULL

taglet_storage

  • profile_id — varchar(50) — 기본 키 — NOT NULL
  • taglet_profile — longblob — NOT NULL
  • taglet_html — longblob — NOT NULL

vendor

  • vendor_id — int — 기본 키 — NOT NULL
  • admin_id — int — 외래 키 → admin.admin_id — NOT NULL
  • name — varchar(100) — NOT NULL
  • user_id — varchar(100) — NOT NULL
  • user_pwd — varchar(64) — NOT NULL
  • create_date — datetime — NOT NULL
  • phone — varchar(11) — NOT NULL
  • email — varchar(100) — NOT NULL
  • token — varchar(300)
  • status — int — NOT NULL
  • is_delete — int — NOT NULL
  • logo_image_id — int — NOT NULL
  • copyright_id — int — NOT NULL
  • timezone_key — varchar(50) — NOT NULL
  • timezone_value — varchar(10) — NOT NULL