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)