Ferreteria/v0.41/sql/node: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==About== * '''table purpose''': root for all data * '''record purpose''': a thing that has values * '''Module''': {{l/version|odata}} * '''History''': ** '''2017-03-12''' sta...") |
m (4 revisions imported: moving this project here) |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
'''versions''': {{l/ferreteria/|v0.41/sql/node|0.41}}, {{l/ferreteria/|v0.42/sql/node|0.42}}, {{l/ferreteria/|v0.5/sql/node|0.5}} | |||
==About== | ==About== | ||
* '''table purpose''': root for all data | * '''table purpose''': root for all data | ||
| Line 7: | Line 8: | ||
** '''2017-04-09''' decided there really should be a WhenMade timestamp; can always remove later | ** '''2017-04-09''' decided there really should be a WhenMade timestamp; can always remove later | ||
** '''2017-08-05''' renamed '''Class''' to '''Type''' for consistency with tf_leaf: records use "types", code maps these to "classes" | ** '''2017-08-05''' renamed '''Class''' to '''Type''' for consistency with tf_leaf: records use "types", code maps these to "classes" | ||
** '''2020-01-16''' redesigning for v0.4 | ** '''2020-01-16''' redesigning for v0.4 (copied from [[Ferreteria/sql/tf node]]) | ||
==Fields== | ==Fields== | ||
* '''Type''': name of node type; code should know how to map these to node-handler classes | * '''Type''': name of node type; code should know how to map these to node-handler classes | ||
Latest revision as of 16:44, 22 May 2022
About
- table purpose: root for all data
- record purpose: a thing that has values
- Module: Template:L/version
- History:
- 2017-03-12 started
- 2017-04-09 decided there really should be a WhenMade timestamp; can always remove later
- 2017-08-05 renamed Class to Type for consistency with tf_leaf: records use "types", code maps these to "classes"
- 2020-01-16 redesigning for v0.4 (copied from Ferreteria/sql/tf node)
Fields
- Type: name of node type; code should know how to map these to node-handler classes
SQL
CREATE TABLE `node` (
`ID` INT(4) NOT NULL AUTO_INCREMENT,
`Type` VARCHAR(255) NOT NULL COMMENT "name of node type",
`WhenMade` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY(`ID`)
) ENGINE=InnoDB;