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