Difference between revisions of "VbzCart/tables/ctg titles"
Jump to navigation
Jump to search
(note about field naming) |
(note about ID_Title) |
||
| Line 2: | Line 2: | ||
* '''Purpose''': Specifies which groups a <abbr title="Supplier Catalog">SC</abbr> title belongs to | * '''Purpose''': Specifies which groups a <abbr title="Supplier Catalog">SC</abbr> title belongs to | ||
* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency. | * '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency. | ||
| + | ==Fields== | ||
| + | * '''ID_Title''': at this point (2016-01-31), I'm actually mystified as to what this field is actually for. Documentation says it refers to cat_titles, but I can't think why or how it gets set. | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `ctg_titles` ( | <mysql>CREATE TABLE `ctg_titles` ( | ||
Revision as of 02:09, 1 February 2016
About
- Purpose: Specifies which groups a SC title belongs to
- Future: Rename ID_Title field to ID_LCTitle, for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.
Fields
- ID_Title: at this point (2016-01-31), I'm actually mystified as to what this field is actually for. Documentation says it refers to cat_titles, but I can't think why or how it gets set.
SQL
<mysql>CREATE TABLE `ctg_titles` (
ID INT NOT NULL AUTO_INCREMENT, ID_Title INT DEFAULT NULL COMMENT "cat_titles.ID", ID_Group INT DEFAULT NULL COMMENT "ctg_groups.ID", ID_Source INT DEFAULT NULL COMMENT "ctg_sources.ID - source which enables this selection", WhenDiscont DATETIME DEFAULT NULL COMMENT "non-sourced discontinuation", GroupCode VARCHAR(7) DEFAULT NULL COMMENT "catalog code extension for this title group (optional)", GroupDescr VARCHAR(127) DEFAULT NULL COMMENT "description extension for this title group (required if GroupCode is used)", GroupSort VARCHAR(7) DEFAULT NULL COMMENT "sorting override", isActive BOOL DEFAULT FALSE COMMENT "this group-title membership is active?", Supp_CatNum VARCHAR(15) DEFAULT NULL COMMENT "catalog # for restock from supplier", Notes VARCHAR(255) DEFAULT NULL COMMENT "notes about this particular title's availability in this group", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>