topology Node

Tables (3)

WAS_TOPOLOGY_NODE

  • NODE_ID — VARCHAR(50) — Primary key — NOT NULL
  • PROJECT_ID — VARCHAR(50) — NOT NULL
  • NODE_TYPE — TEXT — NOT NULL
  • UPDATE_DATE — DATETIME

WAS_TOPOLOGY_NODE_PROPERTY

  • NODE_PROPERTY_ID — VARCHAR(50) — Primary key — NOT NULL
  • NODE_ID — VARCHAR(50) — Foreign key → WAS_TOPOLOGY_NODE.NODE_ID — NOT NULL
  • PROPERTY_KEY — TEXT — NOT NULL
  • FIELD_TYPE — CHAR(1)
  • FIELD_MIN_NUM — NUMBER
  • FILED_MAX_NUM — NUMBER
  • FILED_MAX_LENGTH — NUMBER
  • REPRESENTATIVE — CHAR(1)

WAS_TOPOLOGY_NODE_STATE

  • NODE_STATE_ID — VARCHAR(50) — Primary key — NOT NULL
  • NODE_PROPERTY_ID — VARCHAR(50) — Foreign key → WAS_TOPOLOGY_NODE_PROPERTY.NODE_PROPERTY_ID — NOT NULL
  • NODE_ID — VARCHAR(50) — Foreign key → WAS_TOPOLOGY_NODE_PROPERTY.NODE_ID — NOT NULL
  • STATE — TEXT — NOT NULL
  • EFFECT — TEXT — NOT NULL
  • EFFECT_CONDITION — TEXT — NOT NULL