VbzCart/docs/tables/event vc bin: Difference between revisions
Jump to navigation
Jump to search
imported>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''':...") |
m (Woozle moved page VbzCart/VbzCart/tables/event vc bin to VbzCart/docs/tables/event vc bin without leaving a redirect: part 4/5) |
(No difference)
| |
Latest revision as of 01:57, 25 February 2024
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
- Fields from original no longer needed:
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>