Woozle: Created page with "==About== * '''Purpose''': sub-event to work with Ferreteria's eventPlex (see Ferreteria/sql/event, Ferreteria/usage/events, other pages to be written) * '''Event''':..."

2017-04-18T00:12:05Z

Created page with "==About== * '''Purpose''': sub-event to work with Ferreteria's eventPlex (see Ferreteria/sql/event, Ferreteria/usage/events, other pages to be written) * '''Event''':..."

New page

==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>

VbzCart/tables/event vc bin - Revision history

Woozle: Created page with "==About== * '''Purpose''': sub-event to work with Ferreteria's eventPlex (see Ferreteria/sql/event, Ferreteria/usage/events, other pages to be written) * '''Event''':..."