Difference between revisions of "VbzCart/tables/cat topic"
Jump to navigation
Jump to search
(fields: +NameMeta, +Usage) |
(new fields: cntTiHere, cntTiSub) |
||
| Line 6: | Line 6: | ||
** '''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''' | ** '''2011-02-05''' New fields: '''NameMeta''' and '''Usage''' | ||
| + | ** '''2011-02-24''' New fields: '''cntTiHere''' and '''cntTiSub''' to support lookup-free indication of where to find active titles | ||
* '''Notes''': | * '''Notes''': | ||
** Fields I'm considering adding here: | ** Fields I'm considering adding here: | ||
| Line 32: | Line 33: | ||
`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", | ||
`Mispeled` VARCHAR(255) DEFAULT NULL COMMENT "same as Variants, but these are WRONG spellings; avoid displaying", | `Mispeled` VARCHAR(255) DEFAULT NULL COMMENT "same as Variants, but these are WRONG spellings; avoid displaying", | ||
| + | `cntTiHere` INT DEFAULT NULL COMMENT "calculated: number of active titles for this topic", | ||
| + | `cntTiSub` INT DEFAULT NULL COMMENT "calculated: sum of active titles for all subtopics", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 19:37, 24 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
- 2011-02-24 New fields: cntTiHere and cntTiSub to support lookup-free indication of where to find active titles
- 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", `cntTiHere` INT DEFAULT NULL COMMENT "calculated: number of active titles for this topic", `cntTiSub` INT DEFAULT NULL COMMENT "calculated: sum of active titles for all subtopics", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>