VbzCart/docs/tables/stk whse: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (Created page with "==About== * '''Purpose''': tracks {{l/vc/term|warehouse}} locations * '''Future''': we'll probably want contact information, eventually. * '''History''': ** '''2016-01-08''' c...") |
m (Woozle moved page VbzCart/VbzCart/tables/stk whse to VbzCart/docs/tables/stk whse without leaving a redirect: part 4/5) |
(No difference)
| |
Latest revision as of 01:57, 25 February 2024
About
- Purpose: tracks Template:L/vc/term locations
- Future: we'll probably want contact information, eventually.
- History:
- 2016-01-08 created because it really doesn't make sense to have warehouses in the suppliers table, but we do (or will) need a way to track them.
SQL
<mysql>CREATE TABLE `stk_whse` (
`ID` INT NOT NULL AUTO_INCREMENT, `Name` VARCHAR(64) COMMENT 'name of supplier as displayed', `isActive` BOOL COMMENT 'if FALSE, hide from casual listings', `Notes` TEXT COMMENT "Human-entered notes about this supplier, for quick reference", PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>