VbzCart/tables/ctg titles

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.

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>