VbzCart/docs/tables/ctg sources: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==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== <section begin=sql />...) |
imported>Woozle (shortened SQL doc lines a bit by moving longer explanations to "about") |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''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''': | * '''Notes''': | ||
** To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as avaialble. | ** To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as avaialble. | ||
| Line 9: | Line 14: | ||
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 | ID_Supercede INT DEFAULT NULL COMMENT "[Supplier Catalogs].ID of catalog which supercedes this one, if any", | ||
isCloseOut BOOL DEFAULT FALSE COMMENT " | isCloseOut BOOL DEFAULT FALSE COMMENT "is this a close-out catalog?", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 18:44, 8 March 2009
About
- 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.
SQL
<section begin=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> <section end=sql />