node management

Tables (12)

link (NM_LINK)

  • Link Identity (NM_LINK_ID) — BIGINT — Primary key — NOT NULL
  • Project Identity (NM_PRJ_ID) — BIGINT — Foreign key → prjnode.Project Identity — NOT NULL
  • Node Identity (NM_NODE_ID) — BIGINT — Foreign key → prjnode.Node Identity — NOT NULL
  • Link Direction (NM_LINK_DIRECT) — TINYINT — NOT NULL
  • Link Type (NM_LINK_TYPE) — TINYINT — NOT NULL
  • Link Source (NM_LINK_SRC) — BIGINT
  • Link Destination (NM_LINK_DST) — BIGINT
  • Link Presetation (NM_LINK_PRS) — VARCHAR(45)
  • Link Port (NM_LINK_PORT) — INT(11)
  • Link Status (NM_LINK_STATUS) — INT(11)
  • Link Target (NM_LINK_TRG) — BIGINT — NOT NULL

nic (NM_NIC)

  • NIC Identity (NM_NIC_ID) — BIGINT — Primary key — NOT NULL
  • Node Identity (NM_NODE_ID) — BIGINT — Foreign key → node.Node Identity — NOT NULL
  • NIC Name (NM_NIC_NAME) — VARCHAR(256) — NOT NULL
  • NIC Type (NM_NIC_TYPE) — INT(11)
  • NIC PHY (NM_NIC_PHY) — VARCHAR(20)
  • NIC Info (NM_NIC_INFO) — VARCHAR(45)
  • NIC Registration Date (NM_NIC_REG) — DATETIME — NOT NULL
  • NIC Modification Date (NM_NIC_MOD) — DATETIME — NOT NULL
  • NIC Creator (NM_USER_IDX) — BIGINT — Foreign key → siteuser.Site User — NOT NULL

node (NM_NODE)

  • Node Identity (NM_NODE_ID) — BIGINT — Primary key — NOT NULL
  • Node Name (NM_NODE_NAME) — VARCHAR(256)
  • Node Type (NM_NODE_TYPE) — TINYINT
  • Node Registration Date (NM_NODE_REG) — DATETIME — NOT NULL
  • Node Modification Date (NM_NODE_MOD) — DATETIME — NOT NULL
  • Node Status (NM_NODE_STATUS) — INT(11)
  • Node Row (NM_NODE_ROW) — INT(11) — NOT NULL
  • Node Col (NM_NODE_COL) — INT(11) — NOT NULL
  • Site Identity (NM_SITE_ID) — BIGINT — Foreign key → siteuser.Site Identity — NOT NULL
  • Node Creator (NM_USER_INDEX) — BIGINT — Foreign key → siteuser.Site User — NOT NULL

prjnode (PRJ_NODE)

  • Project Identity (NM_PRJ_ID) — BIGINT — Foreign key → project.Project Identity — NOT NULL
  • Node Identity (NM_NODE_ID) — BIGINT — Foreign key → node.Node Identity — NOT NULL
  • Project Node Name (PRJ_NODE_NAME) — VARCHAR(256)
  • Project Node Type (PRJ_NODE_TYPE) — TINYINT
  • Project Node Registration Date (PRJ_NODE_REG) — DATETIME — NOT NULL
  • Project Node Modification Date (PRJ_NODE_MOD) — DATETIME — NOT NULL
  • Project Node Creator (NM_USER_IDX) — BIGINT — Foreign key → prjuser.Project User — NOT NULL

prjnode_his (HIS_PRJNODE)

  • Node History ID (HIS_PRJNODE_ID) — BIGINT — Primary key — NOT NULL
  • Project Identity (NM_PRJ_ID) — BIGINT — Foreign key → prjnode.Project Identity — NOT NULL
  • Node Identity (NM_NODE_ID) — BIGINT — Foreign key → prjnode.Node Identity — NOT NULL
  • Node Message (HIS_PRJNODE_MSG) — MEDIUMTEXT — NOT NULL
  • Node Action (HIS_PRJNODE_ACT) — MEDIUM_TEXT — NOT NULL
  • Node Message Registration Date (HIS_PRJNODE_REG) — DATETIME — NOT NULL

prjuser (PRJ_USER)

  • Site Identity (NM_SITE_ID) — BIGINT — Foreign key → siteuser.Site Identity — NOT NULL
  • Project Identity (NM_PRJ_ID) — BIGINT — Foreign key → project.Project Identity — NOT NULL
  • Project User (NM_USER_IDX) — BIGINT — Foreign key → siteuser.Site User — NOT NULL
  • User Permission in Project (PRJ_USER_PERM) — TINYINT
  • Prject User Registration Date (PRJ_USER_REG) — DATETIME — NOT NULL
  • Project User Status (PRJ_USER_STATUS) — INT(11)

project (NM_PRJ)

  • Project Identity (NM_PRJ_ID) — BIGINT — Primary key — NOT NULL
  • Project Name (NM_PRJ_NAME) — VARCHAR(256)
  • Project Description (NM_PRJ_MEMO) — MEDIUMTEXT
  • Project Type (NM_PRJ_TYPE) — INT(11)
  • Project Row (NM_PRJ_ROW) — INT(11) — NOT NULL
  • Project Col (NM_PRJ_COL) — INT(11) — NOT NULL
  • Project Registration Date (NM_PRJ_REG) — DATETIME — NOT NULL
  • Project Modification Date (NM_PRJ_MOD) — DATETIME — NOT NULL
  • Project Status (NM_PRJ_STATUS) — INT(11)
  • Project Site Identity (NM_SITE_ID) — BIGINT — Foreign key → siteuser.Site Identity — NOT NULL
  • Project Creator (NM_USER_IDX) — BIGINT — Foreign key → siteuser.Site User — NOT NULL

rule (NM_RULE)

  • Ruleset Identity (NM_RULE_ID) — BIGINT — Primary key — NOT NULL
  • Ruleset Type (NM_RULE_TYPE) — TINYINT — NOT NULL
  • Ruleset Name (NM_RULE_NAME) — VARCHAR(256)
  • Ruleset Registration Date (NM_RULE_REG) — DATETIME — NOT NULL
  • Ruleset Status (NM_RULE_STATUS) — INT(11)
  • Project Identity (NM_PRJ_ID) — BIGINT — Foreign key → prjnode.Project Identity — NOT NULL
  • Node Identity (NM_NODE_ID) — BIGINT — Foreign key → prjnode.Node Identity — NOT NULL
  • Ruleset Creator (NM_USER_IDX2) — BIGINT — Foreign key → prjuser.Project User — NOT NULL

ruleitem (NM_RITM)

  • Rulset Item Identity (NM_RITEM_ID) — BIGINT — Primary key — NOT NULL
  • Ruleset Identity (NM_RULE_ID) — BIGINT — Foreign key → rule.Ruleset Identity — NOT NULL
  • Ruleset Source Pattern (NM_RITEM_SRC) — MEDIUMTEXT
  • Ruleset Translation (NM_RITEM_TRS) — MEDIUMTEXT
  • Ruleset Item Type (NM_RITEM_TYPE) — INT(11)
  • Ruleset Item Action (NM_RITEM_ACT) — MEDIUM_TEXT
  • Ruleset Item Status (NM_RITEM_STATUS) — INT(11)
  • Ruleset Item Registration Date (NM_RITEM_REG) — DATETIME — NOT NULL
  • Ruleset Item Creator (NM_USER_IDX) — BIGINT — Foreign key → prjuser.Project User — NOT NULL

site (NM_SITE)

  • Site Identity (NM_SITE_ID) — BIGINT — Primary key — NOT NULL
  • Site Name (NM_SITE_NAME) — VARCHAR(256)
  • Site Registration Date (NM_SITE_REG) — DATETIME — NOT NULL
  • Site Creator (NM_USER_IDX) — BIGINT — Foreign key → user.User Index — NOT NULL

siteuser (SITE_USER)

  • Site Identity (NM_SITE_ID) — BIGINT — Foreign key → site.Site Identity — NOT NULL
  • Site User (NM_USER_IDX) — BIGINT — Foreign key → user.User Index — NOT NULL
  • Site User Permission (SITE_USER_PERM) — TINYINT
  • Site User Registration Date (SITE_USER_REG) — DATETIME — NOT NULL
  • Site User Status (SITE_USER_STATUS) — INT(11)

user (NM_USER)

  • User Index (NM_USER_IDX) — BIGINT — Primary key — NOT NULL
  • User Identity (NM_USER_ID) — VARCHAR(256)
  • User Password (NM_USER_PASS) — VARCHAR(64)
  • User Permission (NM_USER_PERM) — TINYINT
  • User Registration Date (NM_USER_REG) — DATETIME — NOT NULL
  • User Modification Date (NM_USER_MOD) — DATETIME — NOT NULL
  • User Status (NM_USER_STATUS) — INT(11)