Ferreteria/v0.41/sql/node leaf

versions: 0.41, 0.42, 0.5

About

• Purpose: Index to all Template:L/version leafs, regardless of format

Fields

• Type: name of type; caller code will maintain an index of leaf-handler classes (array[Type] => class_name)

History

• 2017-08-03 Started, because the need became apparent.
• 2020-01-16 redesigning for v0.4 (copied from Ferreteria/sql/tf leaf)

SQL

CREATE TABLE `node_leaf` (
  `ID`      INT(4)        NOT NULL AUTO_INCREMENT,
  `ID_Node` INT(4)        NOT NULL COMMENT "ID of node to which this value belongs",
  `Name`    VARCHAR(255)  NOT NULL COMMENT "internal name of this value",
  `Type`    VARCHAR(255)  NOT NULL COMMENT "name of leaf (field) type",
  PRIMARY KEY(`ID`),
  UNIQUE KEY(`ID_Node`,`Name`)
) ENGINE=InnoDB;