Ferreteria/sql/tf leaf

From Woozle Writes Code
< Ferreteria‎ | sql
Revision as of 15:28, 5 August 2018 by htyp>Woozle
Jump to navigation Jump to search

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;