Hoard: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
No edit summary
(meant to delete the stuff that got moved to a subpage)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
==About==
==About==
All the things I need to track tie together in various ways, it seems. [[Hoard]] is the database that ties them together. It also has a number of ''ad hoc'' uses.
All the things I need to track tie together in various ways, it seems. [[Hoard]] is the database that ties them together. It also has a number of ''ad hoc'' uses.
==Schemae==
==Pages==
===Things===
* [[/Data]]
This keeps track of all the things.
<syntaxhighlight lang=SQL>
CREATE TABLE
  `things` (
    `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `WhenNew`    timestamp NOT NULL DEFAULT current_timestamp(),
    `ID_Base`    int(11) DEFAULT NULL COMMENT 'ID of parent record',
    `ID_Stuff`  int(11) DEFAULT NULL COMMENT 'external reference, if any',
    `Name`      varchar(255) DEFAULT NULL COMMENT 'label for lists',
    PRIMARY KEY (`ID`)
  ) ENGINE = InnoDB
</syntaxhighlight>
===Stuff===
This keeps track of stuff about the things. (still designing; not functional yet)
<syntaxhighlight lang=SQL>
CREATE TABLE
  `stuff` (
    `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `WhenNew`    timestamp NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`ID`)
  ) ENGINE = InnoDB
</syntaxhighlight>
===Extern===
This tracks external data repositories.
<syntaxhighlight lang=SQL>
CREATE TABLE
  `extern` (
    `ID`      int(10) unsigned NOT NULL AUTO_INCREMENT,
    `WhenNew`  timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'when this record was added',
    `SID_Type` varchar(255) DEFAULT NULL COMMENT 'slug for thing-type (matches coded external data)',
    `Name`    varchar(255) DEFAULT NULL COMMENT 'single line for lists',
    PRIMARY KEY (`ID`)
  ) ENGINE = InnoDB
</syntaxhighlight>

Latest revision as of 16:49, 12 August 2024

About

All the things I need to track tie together in various ways, it seems. Hoard is the database that ties them together. It also has a number of ad hoc uses.

Pages

Retrieved from "https://wooz.dev/mw/index.php?title=Hoard&oldid=7121"