VbzCart/tables/ctg sources

From HTYP, the free directory anyone can edit

[edit] About

• Used by: qryCtg_Sources_active
• 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:
  • To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as avaialble.

[edit] SQL

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;