Difference between revisions of "VbzCart/tables/cat titles"
Jump to navigation
Jump to search
(extracted from "tables" page) |
(tidying) |
||
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': catalog titles within departments | * '''Purpose''': catalog titles within departments | ||
− | * '''Future''': The design of this table will probably change some, as there deprecated fields to be removed ( | + | * '''Related''': {{vbzcart/table|cat_depts}} (parent), {{vbzcart/table|cat_supp}} (parent) |
+ | * '''Future''': The design of this table will probably change some, as there are deprecated fields to be removed | ||
+ | ** Rename '''Desc''' to '''Descr''' because "Desc" is an SQL keyword | ||
+ | ** Possibly another field specifically for text that appears in the Title's image(s) -- or should that be tied to the Images data? | ||
+ | ** Also possibly another field for an "alt=" description (what the thing actually looks like, in words) | ||
+ | ** '''ID_License''' should go with Images (earlier, was thinking this could be tracked as a Topic, but making it image-specific makes more sense -- e.g. a photo of a model wearing a shirt should be licensed differently than the image of the pattern that goes on the shirt) | ||
+ | ==History== | ||
+ | * '''2011-09-28''' adding '''ID_Supp''' field, making '''ID_Dept''' DEFAULT NULL (and optional) | ||
+ | ** The code doesn't know this yet, but it will get fixed as time permits. | ||
+ | ** Once the code is rewritten and any remaining Dept data is migrated to Topics, we can remove '''ID_Dept'''. | ||
+ | * '''2016-01-17''' changed '''Notes''' from VARCHAR(255) to TEXT because notes, while rare, are sometimes long. | ||
+ | ** Eventually, Ferreteria will provide a wiki-like content management API... | ||
==SQL== | ==SQL== | ||
− | + | <mysql> CREATE TABLE `cat_titles` ( | |
− | `ID` int(11) unsigned NOT NULL auto_increment, | + | `ID` int(11) unsigned NOT NULL auto_increment, |
− | `Name` varchar(127), | + | `Name` varchar(127), |
− | `CatKey` varchar(63) NOT NULL, | + | `CatKey` varchar(63) NOT NULL, |
− | `ID_Dept` int(11) | + | `ID_Supp` INT(11) UNSIGNED NOT NULL COMMENT "cat_supp.ID", |
− | `ID_License` int(11) | + | `ID_Dept` int(11) UNSIGNED DEFAULT NULL COMMENT "cat_dept.ID (optional)", |
− | `DateAdded` datetime | + | `ID_License` int(11) DEFAULT NULL COMMENT "DEPRECATED", |
− | `DateChecked` datetime | + | `DateAdded` datetime DEFAULT NULL, |
− | `DateUnavail` datetime | + | `DateChecked` datetime DEFAULT NULL COMMENT 'DEPRECATED', |
− | `RstkMin` int(11) unsigned | + | `DateUnavail` datetime DEFAULT NULL, |
− | `Supplier_CatNum` varchar(31), | + | `RstkMin` int(11) unsigned DEFAULT NULL COMMENT "minimum qty that can be ordered from supplier", |
+ | `Supplier_CatNum` varchar(31) COMMENT "supplier's catalog # for this title", | ||
`Supplier_CatNum_Alt` varchar(31) COMMENT 'DEPRECATED', | `Supplier_CatNum_Alt` varchar(31) COMMENT 'DEPRECATED', | ||
− | `Desc` tinytext COMMENT 'descriptive text for display on web - DEPRECATED (use wiki)', | + | `Desc` tinytext COMMENT 'descriptive text for display on web - DEPRECATED (use wiki)', |
− | `Search` varchar(255) COMMENT 'additional keywords for searching, but not displayed', | + | `Search` varchar(255) COMMENT 'additional keywords for searching, but not displayed', |
− | `Notes` | + | `Notes` TEXT COMMENT 'internal notes; not displayed or searched - DEPRECATED (use wiki)', |
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql> | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql> | ||
− |
Latest revision as of 19:04, 7 November 2016
About
- Purpose: catalog titles within departments
- Related:
- REDIRECT Template:l/vc/table (parent), cat_supp (parent)
- Future: The design of this table will probably change some, as there are deprecated fields to be removed
- Rename Desc to Descr because "Desc" is an SQL keyword
- Possibly another field specifically for text that appears in the Title's image(s) -- or should that be tied to the Images data?
- Also possibly another field for an "alt=" description (what the thing actually looks like, in words)
- ID_License should go with Images (earlier, was thinking this could be tracked as a Topic, but making it image-specific makes more sense -- e.g. a photo of a model wearing a shirt should be licensed differently than the image of the pattern that goes on the shirt)
History
- 2011-09-28 adding ID_Supp field, making ID_Dept DEFAULT NULL (and optional)
- The code doesn't know this yet, but it will get fixed as time permits.
- Once the code is rewritten and any remaining Dept data is migrated to Topics, we can remove ID_Dept.
- 2016-01-17 changed Notes from VARCHAR(255) to TEXT because notes, while rare, are sometimes long.
- Eventually, Ferreteria will provide a wiki-like content management API...
SQL
<mysql> CREATE TABLE `cat_titles` (
`ID` int(11) unsigned NOT NULL auto_increment, `Name` varchar(127), `CatKey` varchar(63) NOT NULL, `ID_Supp` INT(11) UNSIGNED NOT NULL COMMENT "cat_supp.ID", `ID_Dept` int(11) UNSIGNED DEFAULT NULL COMMENT "cat_dept.ID (optional)", `ID_License` int(11) DEFAULT NULL COMMENT "DEPRECATED", `DateAdded` datetime DEFAULT NULL, `DateChecked` datetime DEFAULT NULL COMMENT 'DEPRECATED', `DateUnavail` datetime DEFAULT NULL, `RstkMin` int(11) unsigned DEFAULT NULL COMMENT "minimum qty that can be ordered from supplier", `Supplier_CatNum` varchar(31) COMMENT "supplier's catalog # for this title", `Supplier_CatNum_Alt` varchar(31) COMMENT 'DEPRECATED', `Desc` tinytext COMMENT 'descriptive text for display on web - DEPRECATED (use wiki)', `Search` varchar(255) COMMENT 'additional keywords for searching, but not displayed', `Notes` TEXT COMMENT 'internal notes; not displayed or searched - DEPRECATED (use wiki)', PRIMARY KEY(`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>