Ferreteria/v0.42/sql/node leaf: Difference between revisions
Jump to navigation
Jump to search
m (Woozle moved page Ferreteria/v0.42/sql/leaf to Ferreteria/v0.42/sql/node leaf without leaving a redirect: where it's supposed to be (same as the table name)) |
(to match node) |
||
Line 14: | Line 14: | ||
* '''2020-01-16''' redesigning for v0.4 (copied from [[Ferreteria/sql/tf leaf]]) - this became 0.41 | * '''2020-01-16''' redesigning for v0.4 (copied from [[Ferreteria/sql/tf leaf]]) - this became 0.41 | ||
* '''2020-01-23''' tweaking for v0.42 | * '''2020-01-23''' tweaking for v0.42 | ||
* '''2021-01-19''' "integer width is deprecated"; also decided it should be 8 bytes | |||
==SQL== | ==SQL== | ||
<source lang=mysql>CREATE TABLE `node_leaf` ( | <source lang=mysql>CREATE TABLE `node_leaf` ( | ||
`ID` | `ID` BIGINT NOT NULL AUTO_INCREMENT, | ||
`ID_Node` | `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", | `Name` VARCHAR(255) NOT NULL COMMENT "field name of this value", | ||
`Value` LONGTEXT DEFAULT NULL COMMENT "value, in string format", | `Value` LONGTEXT DEFAULT NULL COMMENT "value, in string format", |
Revision as of 18:44, 19 January 2021
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
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` LONGTEXT DEFAULT NULL COMMENT "value, in string format",
PRIMARY KEY(`ID`),
UNIQUE KEY(`ID_Node`,`Name`)
) ENGINE=InnoDB;