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)