Ferreteria/archive/v0.5/sql/node leaf
< Ferreteria | archive
Jump to navigation
Jump to search
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.
- 2022-03-06 copying v0.42/sql/node_leaf verbatim for v0.5
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;