VbzCart/tables/ctg sources

About

• Notes:
  • 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 (NULL = this one is current)",
 isCloseOut  BOOL DEFAULT FALSE COMMENT "TRUE = this catalog is a list of discontinued items no longer in print (closeouts); FALSE = normal catalog",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>