Ferreteria/sql/tf leaf

About

• Purpose: Index to all node (Template:L/ferreteria/table) leafs, regardless of format
• Module: Template:L/ferreteria/module

Fields

• Type: name of type; in code, this should refer to an index of leaf-handler-classes

History

• 2017-08-03 Started, because the need became apparent.

SQL

CREATE TABLE  `tf_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;