Ferreteria/sql/tf leaf: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
mNo edit summary
m (3 revisions imported: moving this project here)
 
(No difference)

Latest revision as of 16:42, 22 May 2022

About

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;