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, search

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>