Difference between revisions of "VbzCart/tables/cat topic"
Jump to navigation
Jump to search
(saving work; still revising) |
(fields: +NameMeta, +Usage) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Status''': | + | * '''Status''': Working (2011-02-04) |
* '''Used by''': {{vbzcart|table|brs_titles_x_topics}} | * '''Used by''': {{vbzcart|table|brs_titles_x_topics}} | ||
* '''Future''': rename to {{vbzcart|table|cat_topic}}; rename {{vbzcart|table|brs_titles_x_topics}} to {{vbzcart|table|cat_title_x_topic}} | * '''Future''': rename to {{vbzcart|table|cat_topic}}; rename {{vbzcart|table|brs_titles_x_topics}} to {{vbzcart|table|cat_title_x_topic}} | ||
* '''History''': | * '''History''': | ||
** '''2010-10-13''' Coding (store and admin) in progress; noted 3 possible fields to add | ** '''2010-10-13''' Coding (store and admin) in progress; noted 3 possible fields to add | ||
| + | ** '''2011-02-05''' New fields: '''NameMeta''' and '''Usage''' | ||
* '''Notes''': | * '''Notes''': | ||
** Fields I'm considering adding here: | ** Fields I'm considering adding here: | ||
| Line 25: | Line 26: | ||
`NameTree` VARCHAR(64) DEFAULT NULL COMMENT "name within context of parent; defaults to Name", | `NameTree` VARCHAR(64) DEFAULT NULL COMMENT "name within context of parent; defaults to Name", | ||
`NameFull` VARCHAR(255) DEFAULT NULL COMMENT "descriptive standalone name (context free, can be long)", | `NameFull` VARCHAR(255) DEFAULT NULL COMMENT "descriptive standalone name (context free, can be long)", | ||
| + | `NameMeta` VARCHAR(144) DEFAULT NULL COMMENT "plain text for HTML META description tag", | ||
| + | `Usage` VARCHAR(255) DEFAULT NULL COMMENT "usage instructions for this topic - show when editing topic", | ||
| + | /* `Details` VARCHAR(255) DEFAULT NULL COMMENT "additional information of interest to regular users (may include HTML)", */ | ||
`Sort` VARCHAR(15) DEFAULT NULL COMMENT "optional sorting key", | `Sort` VARCHAR(15) DEFAULT NULL COMMENT "optional sorting key", | ||
`Variants` VARCHAR(255) DEFAULT NULL COMMENT "synonyms and other keywords which should find this topic", | `Variants` VARCHAR(255) DEFAULT NULL COMMENT "synonyms and other keywords which should find this topic", | ||
Revision as of 18:39, 5 February 2011
About
- Status: Working (2011-02-04)
- Used by: brs_titles_x_topics
- Future: rename to cat_topic; rename brs_titles_x_topics to cat_title_x_topic
- History:
- 2010-10-13 Coding (store and admin) in progress; noted 3 possible fields to add
- 2011-02-05 New fields: NameMeta and Usage
- Notes:
- Fields I'm considering adding here:
- A) a flag to indicate that thumbnails of other items in the same category should be shown
- B) a prefix to be added to NameFull for all child nodes (and maybe a flag to override it)
- C) a way of creating "virtual" nodes to cross-link to related topics in other branches
- Fields I'm considering adding here:
- Uses: Topics are (eventually) to be used in the following places:
- Topic pages (show what titles are assigned)
- Topic index (show what item types are [(1) available (2) in stock] for each topic)
- Title pages
- show what topics the title is in
- summarize how many other titles are available for each topic
- (future) show thumbnails for titles in topics with the A flag
SQL
<mysql>DROP TABLE IF EXISTS `brs_topics`; CREATE TABLE `brs_topics` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Parent` INT DEFAULT NULL COMMENT "brs_topics.ID of parent topic", `Name` VARCHAR(128) NOT NULL COMMENT "generic name (context-free, but as short as possible)", `NameTree` VARCHAR(64) DEFAULT NULL COMMENT "name within context of parent; defaults to Name", `NameFull` VARCHAR(255) DEFAULT NULL COMMENT "descriptive standalone name (context free, can be long)", `NameMeta` VARCHAR(144) DEFAULT NULL COMMENT "plain text for HTML META description tag", `Usage` VARCHAR(255) DEFAULT NULL COMMENT "usage instructions for this topic - show when editing topic",
/* `Details` VARCHAR(255) DEFAULT NULL COMMENT "additional information of interest to regular users (may include HTML)", */
`Sort` VARCHAR(15) DEFAULT NULL COMMENT "optional sorting key", `Variants` VARCHAR(255) DEFAULT NULL COMMENT "synonyms and other keywords which should find this topic", `Mispeled` VARCHAR(255) DEFAULT NULL COMMENT "same as Variants, but these are WRONG spellings; avoid displaying", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>