VbzCart/docs/tables/event vc bin

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Revision as of 01:57, 25 February 2024 by Woozle (talk | contribs) (Woozle moved page VbzCart/VbzCart/tables/event vc bin to VbzCart/docs/tables/event vc bin without leaving a redirect: part 4/5)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

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>