VbzCart/tables/ctg groups

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: Master list of groups (CTGs)
• Fields:
  • ID_Supplier: supplier to which this group applies; NULL = no fixed supplier, can be used for any of them
  • ID_Redir: TGroups.ID -- if not null, redirect all references to the current ID to use ID_Redir instead. This is used to indicate a disused TGroup (at the moment, I can't remember why it was better to do this than to just edit the existing TGroup, but I'm sure there was a reason).

[edit] SQL

CREATE TABLE `ctg_groups` (
  ID          INT NOT NULL AUTO_INCREMENT,
  ID_Supplier INT DEFAULT NULL COMMENT "Suppliers.ID to which this TGroup uniquely applies",
  Name        VARCHAR(63) DEFAULT NULL COMMENT "Name of this group (brief)",
  Descr       VARCHAR(127) DEFAULT NULL COMMENT "Description (for display; if NULL, use ItemType fields)",
  isActive    BOOL DEFAULT FALSE,
  Code        VARCHAR(7) DEFAULT NULL COMMENT "suffix for Items.CatNum",
  Sort        VARCHAR(31) DEFAULT NULL COMMENT "sorting key within group list",
  ID_Redir    INT DEFAULT NULL COMMENT "TGroups.ID of TGroup to use instead of this one",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;