Ferret File System/v0.1/SQL/event: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(added ID_Client, Code; Type+Code are unique key)
m (5 revisions imported: moving here)
(No difference)

Revision as of 13:20, 24 September 2022

About

  • purpose: root events table -- all task-specific events tables refer to this one

fields

  • ID_Client: ID of client that generated the event
  • When: When the event occurred.
    • If an event-type has a beginning and end, the auxiliary table for that type may treat When as "when started" and add a WhenComplete field to indicate when the event was complete.
  • Type: short string indicating which type of event, i.e. which class to use (and which auxiliary event table to look at).
  • What: automatically-generated human-friendly description of what happened

history

  • 2016-02-27 started

SQL

<mysql>CREATE TABLE `event` (

 `ID`                 INT NOT NULL AUTO_INCREMENT,
 `ID_Client`          INT NOT NULL,
 `When`          DATETIME NOT NULL,
 `Type`  VARCHAR(15)      NOT NULL,
 `Code`  VARCHAR(15)      NOT NULL,
 `What`  VARCHAR(255) DEFAULT NULL,
 PRIMARY KEY(`ID`),
 UNIQUE KEY(`Type`,`Code`)

) ENGINE = INNODB;</mysql>