Ferreteria/sql/event done

About

• Purpose: dependent table for logging event completion
• Depends on: event

History

• 2017-02-06 Adapting the good bits from VbzCart/tables/event log
• 2017-02-12
  • Corrected table name in SQL
  • Decided that there might be more than one of these per EventPlex, so let's have an ID too and make that the primary key.
  • "Condition" is apparently a reserved word and "Status" is apparently a keyword, so using "State" instead.
• 2017-03-19 Decided many-to-one was a bad idea, given current class design. Removed ID and made ID_Event the primary key again.

SQL

<mysql>CREATE TABLE `event_done` (

   ID_Event        INT NOT NULL COMMENT "event.ID of parent event",
   WhenFinish DATETIME NOT NULL COMMENT "when the event completed",
   State      INT  DEFAULT NULL COMMENT "status code defined by application (success, error, etc.)",
   Descrip    TEXT DEFAULT NULL COMMENT "description of completion",
 PRIMARY KEY (`ID_Event`)

) ENGINE = InnoDB;</mysql>