VbzCart/docs/tables/event vc bin

About

• Purpose: sub-event to work with Ferreteria's eventPlex (see Ferreteria/sql/event, Ferreteria/usage/events, other pages to be written)
• Event: whenever a Bin is moved from one Place to another (or created or destroyed)
• Replaces: stk_bin_history
  • Fields from original no longer needed:
    • WhenDone - handled by Ferreteria/sql/event (base event)
    • WhoAdmin - handled by event_vc_legacy
    • WhoSystem - handled by event_vc_legacy
    • WhoNetwork - handled by event_vc_legacy
    • Descr - handled by Ferreteria/sql/event (base event)
    • Notes - handled by Ferreteria/sql/event_notes

History

• 2017-04-17 started design

SQL

<mysql>CREATE TABLE `event_vc_bin` (

 `ID_Event`                INT NOT NULL COMMENT "event.ID of parent event",
 `ID_Bin`                  INT NOT NULL COMMENT "stk_bins.ID of bin being moved",
 `ID_Srce`                 INT NOT NULL COMMENT "stk_places.ID of where the bin came from (NULL = new bin)",
 `ID_Dest`                 INT NOT NULL COMMENT "stk_places.ID of where the bin was moved to (NULL = bin destroyed)",
 PRIMARY KEY (`ID_Event`)

) ENGINE = InnoDB;</mysql>