Difference between revisions of "VbzCart/tables/ctg titles"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(note about ID_Title)
(link to catalog-building doc area)
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
==About==
 
==About==
* '''Purpose''': Specifies which groups a <abbr title="Supplier Catalog">SC</abbr> title belongs to
+
* '''Purpose''': represents the availability of a Local Catalog Title from a particular Supplier Source (catalog), in a particular Group (set of types/options/prices)
 +
* '''Part of''': {{l/vc|pieces/catalog/building}}
 +
* '''Procedure''': Any new Titles in a given Source must be entered into the Local Catalog before they can be used here.
 
* '''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==
 
==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.
+
* '''ID_Title''': the Local Catalog Title for which this record represents availability from a Source
 +
* '''Code''': Still reconstructing what this is for.
 +
* '''Descr''': Still reconstructing what this is for. Schema comment said "required if Code is used", but it is often NULL when Code is not NULL -- so changing that to "recommended if Code is used".
 +
* '''Supp_CatNum''': the catalog number that the Supplier was assigning to this title for this catalog (sometimes the numbers change). This can be used both to note the SuppCatNum for the LCTitle (for checking in Restocks) and also to help track down the correct Title record for CatNums in old records (mainly printed).
 +
==History==
 +
* '''2016-02-04'''
 +
** Removing '''GroupSort''' -- I'm still figuring out how the former Group* fields are supposed to be used, and GroupSort is NULL in all existing records. If it's ever needed, document how it is supposed to work.
 +
** Renaming '''GroupCode''' and '''GroupDescr''' to '''Code''' and '''Descr''' to be consistent with naming in {{l/vc/table|ctg_groups}}.
 +
** Changing '''ID_Title''' to NOT NULL.
 +
* '''2017-06-12''' Changed engine from MYISAM to InnoDB
 
==SQL==
 
==SQL==
 
<mysql>CREATE TABLE `ctg_titles` (
 
<mysql>CREATE TABLE `ctg_titles` (
   ID          INT NOT NULL AUTO_INCREMENT,
+
   ID          INT         NOT NULL AUTO_INCREMENT,
   ID_Title    INT DEFAULT NULL COMMENT "cat_titles.ID",
+
   ID_Title    INT         NOT NULL COMMENT "cat_titles.ID",
   ID_Group    INT DEFAULT NULL COMMENT "ctg_groups.ID",
+
   ID_Group    INT     DEFAULT NULL COMMENT "ctg_groups.ID",
   ID_Source INT DEFAULT NULL COMMENT "ctg_sources.ID - source which enables this selection",
+
   ID_Source   INT     DEFAULT NULL COMMENT "ctg_sources.ID - source which enables this selection",
 
   WhenDiscont DATETIME DEFAULT NULL COMMENT "non-sourced discontinuation",
 
   WhenDiscont DATETIME DEFAULT NULL COMMENT "non-sourced discontinuation",
   GroupCode   VARCHAR(7) DEFAULT NULL COMMENT "catalog code extension for this title group (optional)",
+
   Code   VARCHAR(7)   DEFAULT NULL COMMENT "optional catalog code extension",
   GroupDescr VARCHAR(127) DEFAULT NULL COMMENT "description extension for this title group (required if GroupCode is used)",
+
   Descr VARCHAR(127) DEFAULT NULL COMMENT "description extension (recommended if Code is used)",
  GroupSort  VARCHAR(7) DEFAULT NULL COMMENT "sorting override",
+
   isActive    BOOL     DEFAULT FALSE COMMENT "this group-title membership is active?",
   isActive    BOOL DEFAULT FALSE COMMENT "this group-title membership is active?",
+
   Supp_CatNum VARCHAR(15) DEFAULT NULL COMMENT "catalog # for restock from supplier",
   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",
 
   Notes      VARCHAR(255) DEFAULT NULL COMMENT "notes about this particular title's availability in this group",
 
   PRIMARY KEY(`ID`)
 
   PRIMARY KEY(`ID`)
 
)
 
)
ENGINE = MYISAM;</mysql>
+
ENGINE = InnoDB;</mysql>

Latest revision as of 11:13, 12 June 2017

About

  • Purpose: represents the availability of a Local Catalog Title from a particular Supplier Source (catalog), in a particular Group (set of types/options/prices)
  • Part of: pieces/catalog/building
  • Procedure: Any new Titles in a given Source must be entered into the Local Catalog before they can be used here.
  • 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: the Local Catalog Title for which this record represents availability from a Source
  • Code: Still reconstructing what this is for.
  • Descr: Still reconstructing what this is for. Schema comment said "required if Code is used", but it is often NULL when Code is not NULL -- so changing that to "recommended if Code is used".
  • Supp_CatNum: the catalog number that the Supplier was assigning to this title for this catalog (sometimes the numbers change). This can be used both to note the SuppCatNum for the LCTitle (for checking in Restocks) and also to help track down the correct Title record for CatNums in old records (mainly printed).

History

  • 2016-02-04
    • Removing GroupSort -- I'm still figuring out how the former Group* fields are supposed to be used, and GroupSort is NULL in all existing records. If it's ever needed, document how it is supposed to work.
    • Renaming GroupCode and GroupDescr to Code and Descr to be consistent with naming in ctg_groups.
    • Changing ID_Title to NOT NULL.
  • 2017-06-12 Changed engine from MYISAM to InnoDB

SQL

<mysql>CREATE TABLE `ctg_titles` (

 ID          INT          NOT NULL AUTO_INCREMENT,
 ID_Title    INT          NOT 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",
 Code   VARCHAR(7)    DEFAULT NULL COMMENT "optional catalog code extension",
 Descr  VARCHAR(127)  DEFAULT NULL COMMENT "description extension (recommended if Code is used)",
 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 = InnoDB;</mysql>