VbzCart/tables/ctg sources

About

• Used by:

1. REDIRECT Template:l/vc/query

• Fields:
  • ID_Supercede: Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current
  • 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"
• 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 avaialble.

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",
 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 = MYISAM;</mysql>