View source for 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''': {{l/same|stk_bin_history}}
** Fields from original no longer needed:
*** WhenDone - handled by [[Ferreteria/sql/event]] (base event)
*** WhoAdmin - handled by {{l/same|event_vc_legacy}}
*** WhoSystem - handled by {{l/same|event_vc_legacy}}
*** WhoNetwork - handled by {{l/same|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>