Ferreteria/v0.42/sql/node leaf

versions: 0.41, 0.42, 0.5

About

• Purpose: Values for nodes

Concept

Every leaf:

• has
  • a data type
  • a name (unique within the node)
  • a value
• is like a single field in a single record

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) - this became 0.41
• 2020-01-23 tweaking for v0.42
• 2021-01-19
  • "integer width is deprecated"; also decided it should be 8 bytes
  • Turns out LONGTEXT barfs at certain kinds of binary data, so changing to LONGBLOB.

SQL

CREATE TABLE `node_leaf` (
  `ID`      BIGINT        NOT NULL AUTO_INCREMENT,
  `ID_Node` BIGINT        NOT NULL COMMENT "ID of node to which this value belongs",
  `Name`    VARCHAR(255)  NOT NULL COMMENT "field name of this value",
  `Value`   LONGBLOB  DEFAULT NULL COMMENT "value",
  PRIMARY KEY(`ID`),
  UNIQUE KEY(`ID_Node`,`Name`)
) ENGINE=InnoDB;