Difference between revisions of "VbzCart/tables/ctg sources"
Jump to navigation
Jump to search
(battery low, saving edits) |
(some updates) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Used by''': {{l/vbzcart/query|qryCtg_Sources_active}} | + | * '''Part of''': [[VbzCart/pieces/catalog/building/2017|catalog building process]] |
| + | * <s>'''Used by''': {{l/vbzcart/query|qryCtg_Sources_active}}</s> | ||
==Fields== | ==Fields== | ||
| − | * '''ID_Supercede''': Supplier Catalogs | + | * '''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. | ** It can be set to point to the current record if the superceding catalog has not been entered or is not known. | ||
* '''isCloseOut''': | * '''isCloseOut''': | ||
| Line 8: | Line 9: | ||
** FALSE = normal catalog; items will be marked as "in print" | ** 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. | * '''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== | ==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. | * A "source" is usually a printed catalog from a supplier, though it can also be the manufacturer's web site on a particular date. | ||
| Line 13: | Line 16: | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `ctg_sources` ( | <mysql>CREATE TABLE `ctg_sources` ( | ||
| − | ID INT NOT NULL AUTO_INCREMENT, | + | ID INT NOT NULL AUTO_INCREMENT, |
| − | Name VARCHAR(63) NOT NULL COMMENT "name of source", | + | Name VARCHAR(63) NOT NULL COMMENT "name of source", |
| − | Abbr VARCHAR(15) NOT NULL COMMENT "abbreviation, for drop-down lists", | + | Abbr VARCHAR(15) NOT NULL COMMENT "abbreviation, for drop-down lists", |
| − | ID_Supplier INT NOT NULL COMMENT "Suppliers.ID - supplier for this source", | + | 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", | 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", | + | LastUpdate TIMESTAMP NULL ON UPDATE NOW() COMMENT "automatically updated when record changes", |
| − | isCloseOut BOOL DEFAULT FALSE COMMENT "is this a close-out catalog?", | + | 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`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
| − | ENGINE = | + | ENGINE = InnoDB;</mysql> |
Revision as of 17:22, 18 June 2017
About
- Part of: catalog building process
Used by: qryCtg_Sources_active
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>