VbzCart/docs/tables/ctg sources

About

• Part of: catalog building process
• Used by: Template:L/vbzcart/query

Fields

• ID_Supercede: Supplier Catalogs.ID of catalog which supercedes this one; NULL = this one is current
  • It can be set to point to the current record if the superceding catalog has not been entered or is not known.
• isCloseOut:
  • TRUE = this catalog is a list of discontinued items no longer in print (closeouts)
  • FALSE = normal catalog; items will be marked as "in print"
• WhenUpdated: When this record was last saved. This is actually significant for catalog building because it is copied to LCItem.Supp_LastUpdate. Presumably any time the record is edited, the editor would not leave the ID_Supercede field NULL if the catalog was not still current.

History

• 2017-06-18 Changed engine from MYISAM to InnoDB; added LastUpdate

Notes

• A "source" is usually a printed catalog from a supplier, though it can also be the manufacturer's web site on a particular date.
• To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as available.

SQL

<mysql>CREATE TABLE `ctg_sources` (

 ID          INT          NOT NULL AUTO_INCREMENT,
 Name        VARCHAR(63)  NOT NULL COMMENT "name of source",
 Abbr        VARCHAR(15)  NOT NULL COMMENT "abbreviation, for drop-down lists",
 ID_Supplier INT          NOT NULL COMMENT "Suppliers.ID - supplier for this source",
 DateAvail   DATETIME DEFAULT NULL COMMENT "earliest date on which this source is valid",
 LastUpdate  TIMESTAMP        NULL ON UPDATE NOW() COMMENT "automatically updated when record changes",
 ID_Supercede INT     DEFAULT NULL COMMENT "[Supplier Catalogs].ID of catalog which supercedes this one, if any",
 isCloseOut  BOOL    DEFAULT FALSE COMMENT "is this a close-out catalog?",
 PRIMARY KEY(`ID`)

) ENGINE = InnoDB;</mysql>