VbzCart/docs/tables/ctg groups: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(New page: ==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 **...)
 
m (Woozle moved page VbzCart/VbzCart/tables/ctg groups to VbzCart/docs/tables/ctg groups without leaving a redirect: part 3/5)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': Master list of groups (CTGs)
* '''Purpose''': Master list of Supplier Catalog Management Groups (SCMGs) -- see [[VbzCart/pieces/catalog/building]]
* '''Fields''':
* '''Fields''':
** '''ID_Supplier''': supplier to which this group applies; NULL = no fixed supplier, can be used for any of them
** '''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).
** '''ID_Redir''': ctg_groups.ID -- if not null, redirect all references to the current ID to use ID_Redir instead. This is used to indicate a disused SCMG (at the moment, I can't remember why it was better to do this than to just edit the existing SCMG, but I'm sure there was a reason).
* '''Future''': It may be that ID_Redir isn't really a useful thing to have. For now (2010-11-17), I'm not going to bother making it editable in the administration form.
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ctg_groups` (
<mysql>CREATE TABLE `ctg_groups` (
   ID          INT NOT NULL AUTO_INCREMENT,
   ID          INT NOT NULL AUTO_INCREMENT,
   ID_Supplier INT DEFAULT NULL COMMENT "Suppliers.ID to which this TGroup uniquely applies",
   ID_Supplier INT DEFAULT NULL COMMENT "cat_supp.ID to which this SCMG uniquely applies",
   Name        VARCHAR(63) DEFAULT NULL COMMENT "Name of this group (brief)",
   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)",
   Descr      VARCHAR(127) DEFAULT NULL COMMENT "Description (for display; if NULL, use ItemType fields)",
   isActive    BOOL DEFAULT FALSE,
   isActive    BOOL DEFAULT FALSE,
   Code        VARCHAR(7) DEFAULT NULL COMMENT "suffix for Items.CatNum",
   Code        VARCHAR(7) DEFAULT NULL COMMENT "suffix for cat_items.CatNum",
   Sort        VARCHAR(31) DEFAULT NULL COMMENT "sorting key within group list",
   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",
   ID_Redir    INT DEFAULT NULL COMMENT "ctg_groups.ID of SCMG to use instead of this one",
PRIMARY KEY(`ID`)
PRIMARY KEY(`ID`)
)
)
ENGINE = MYISAM;</mysql>
ENGINE = MYISAM;</mysql>
<section end=sql />

Latest revision as of 01:56, 25 February 2024

About

  • Purpose: Master list of Supplier Catalog Management Groups (SCMGs) -- see VbzCart/pieces/catalog/building
  • Fields:
    • ID_Supplier: supplier to which this group applies; NULL = no fixed supplier, can be used for any of them
    • ID_Redir: ctg_groups.ID -- if not null, redirect all references to the current ID to use ID_Redir instead. This is used to indicate a disused SCMG (at the moment, I can't remember why it was better to do this than to just edit the existing SCMG, but I'm sure there was a reason).
  • Future: It may be that ID_Redir isn't really a useful thing to have. For now (2010-11-17), I'm not going to bother making it editable in the administration form.

SQL

<mysql>CREATE TABLE `ctg_groups` ( 

 ID          INT NOT NULL AUTO_INCREMENT,
 ID_Supplier INT DEFAULT NULL COMMENT "cat_supp.ID to which this SCMG 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 cat_items.CatNum",
 Sort        VARCHAR(31) DEFAULT NULL COMMENT "sorting key within group list",
 ID_Redir    INT DEFAULT NULL COMMENT "ctg_groups.ID of SCMG to use instead of this one",

PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/ctg_groups&oldid=6884"