VbzCart/tables/ctg sources
Jump to navigation
Jump to search
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>