Difference between revisions of "VbzCart/tables/cat titles"
Jump to navigation
Jump to search
(extracted from "tables" page) |
(future notes) |
||
| Line 2: | Line 2: | ||
* '''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 (note that the extra complication of using the wiki for data must be balanced against the ease-of-editing and flexibility this allows) | * '''Future''': The design of this table will probably change some, as there deprecated fields to be removed (note that the extra complication of using the wiki for data must be balanced against the ease-of-editing and flexibility this allows) | ||
| + | ** 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 tentatively makes more sense) | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql> CREATE TABLE `cat_titles` ( | <section begin=sql /><mysql> CREATE TABLE `cat_titles` ( | ||
| Line 8: | Line 12: | ||
`CatKey` varchar(63) NOT NULL, | `CatKey` varchar(63) NOT NULL, | ||
`ID_Dept` int(11) unsigned NOT NULL default '0', | `ID_Dept` int(11) unsigned NOT NULL default '0', | ||
| − | `ID_License` int(11) default NULL COMMENT | + | `ID_License` int(11) default NULL COMMENT "DEPRECATED", |
`DateAdded` datetime default NULL, | `DateAdded` datetime default NULL, | ||
`DateChecked` datetime default NULL COMMENT 'DEPRECATED', | `DateChecked` datetime default NULL COMMENT 'DEPRECATED', | ||
Revision as of 18:48, 29 January 2011
About
- Purpose: catalog titles within departments
- Future: The design of this table will probably change some, as there deprecated fields to be removed (note that the extra complication of using the wiki for data must be balanced against the ease-of-editing and flexibility this allows)
- 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 tentatively makes more sense)
SQL
<mysql> CREATE TABLE `cat_titles` (
`ID` int(11) unsigned NOT NULL auto_increment, `Name` varchar(127), `CatKey` varchar(63) NOT NULL, `ID_Dept` int(11) unsigned NOT NULL default '0', `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, `Supplier_CatNum` varchar(31), `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` varchar(255) COMMENT 'internal notes; not displayed or searched - DEPRECATED (use wiki)', PRIMARY KEY(`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>