RS

Tables (8)

CONTEXT_MENU_DEF

  • menu_id — INT — Primary key — NOT NULL
  • menu_key — VARCHAR(50) — NOT NULL
  • display_label — VARCHAR(100) — NOT NULL
  • menu_icon — VARCHAR(255) — 우클릭 메뉴용 아이콘

DEVICE_INSTANCE

  • device_id — INT — Primary key — NOT NULL
  • model_id — INT — Foreign key → DEVICE_MODEL.model_id — NOT NULL
  • firmware_version — VARCHAR(50)
  • connection_type — VARCHAR(20)
  • ip_address — VARCHAR(50)
  • created_at — DATETIME

DEVICE_MODEL

  • model_id — INT — Primary key — NOT NULL
  • product_code — VARCHAR(50) — NOT NULL
  • model_name — VARCHAR(100) — NOT NULL
  • vendor — VARCHAR(50)
  • device_icon — VARCHAR(255) — 트리 노드용 장치 아이콘

PARAM_DEFINITION

  • param_def_id — INT — Primary key — NOT NULL
  • structure_id — INT — Foreign key → TEMPLATE_STRUCTURE.structure_id — NOT NULL
  • param_key — VARCHAR(50) — NOT NULL
  • param_label — VARCHAR(100)
  • data_type — VARCHAR(20)
  • default_value — VARCHAR(100)

PARAM_VALUE

  • value_id — BIGINT — Primary key — NOT NULL
  • device_id — INT — Foreign key → DEVICE_INSTANCE.device_id — NOT NULL
  • param_def_id — INT — Foreign key → PARAM_DEFINITION.param_def_id — NOT NULL
  • current_value — VARCHAR(255)
  • updated_at — DATETIME

TEMPLATE_MENU_MAP

  • map_id — INT — Primary key — NOT NULL
  • structure_id — INT — Foreign key → TEMPLATE_STRUCTURE.structure_id — NOT NULL
  • menu_id — INT — Foreign key → CONTEXT_MENU_DEF.menu_id — NOT NULL
  • sort_order — INT

TEMPLATE_STRUCTURE

  • structure_id — INT — Primary key — NOT NULL
  • model_id — INT — Foreign key → DEVICE_MODEL.model_id — NOT NULL
  • node_name — VARCHAR(100) — NOT NULL
  • parent_structure_id — INT — Foreign key → TEMPLATE_STRUCTURE.structure_id — Self Join
  • display_order — INT
  • node_icon — VARCHAR(255) — 트리 노드용 항목 아이콘

UI_TREE_NODE

  • node_id — BIGINT — Primary key — NOT NULL
  • parent_node_id — BIGINT — Foreign key → UI_TREE_NODE.node_id
  • node_type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • device_id — INT — Foreign key → DEVICE_INSTANCE.device_id
  • structure_id_ref — INT
  • sort_order — INT
  • custom_icon — VARCHAR(255) — 사용자 지정 아이콘 (Optional)