VbzCart/tables/ctg sources - Revision history

Woozle: DateAvail -> DateActive

2017-06-20T10:29:50Z

DateAvail -> DateActive

Woozle: DateExpires

2017-06-19T10:35:27Z

DateExpires

← Older revision		Revision as of 10:35, 19 June 2017
Line 9:		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.
			* '''DateAvail''': The approximate date of the catalog's effectiveness (e.g. "Spring 20xx" would be 20xx-03-15 or so, or date received if earlier)
			* '''DateExpires''': The approximate date when the catalog is no longer expected to apply (e.g. "20xx Catalog" would be 20xx-12-31)
	==History==		==History==
	* '''2017-06-18''' Changed engine from MYISAM to InnoDB; added LastUpdate		* '''2017-06-18''' Changed engine from MYISAM to InnoDB; added '''LastUpdate'''
			* '''2017-06-19''' Added '''DateExpires'''
	==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 21:		Line 24:
	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",
			DateExpires DATETIME DEFAULT NULL COMMENT "estimated date on which this source expires",
	LastUpdate TIMESTAMP NULL ON UPDATE NOW() COMMENT "automatically updated when record changes",		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",		ID_Supercede INT DEFAULT NULL COMMENT "[Supplier Catalogs].ID of catalog which supercedes this one, if any",

Woozle: some updates

2017-06-18T17:22:51Z

some updates

← Older revision		Revision as of 17:22, 18 June 2017
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 of catalog which supercedes this one; NULL = this one is current		* '''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 = ~~MYISAM~~;</mysql>		ENGINE = InnoDB;</mysql>

Woozle: battery low, saving edits

2017-06-18T16:07:49Z

battery low, saving edits

← Older revision		Revision as of 16:07, 18 June 2017
Line 1:		Line 1:
	==About==		==About==
	* '''Used by''': {{vbzcart/query\|qryCtg_Sources_active}}		* '''Used by''': {{l/vbzcart/query\|qryCtg_Sources_active}}
	* '''Fields~~''':~~		==Fields==
	** '''ID_Supercede''': Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current		* '''ID_Supercede''': Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current
	** '''isCloseOut''':		** It can be set to point to the current record if the superceding catalog has not been entered or is not known.
	*** TRUE = this catalog is a list of discontinued items ''no longer in print'' (closeouts)		* '''isCloseOut''':
	*** FALSE = normal catalog; items will be marked as "in print"		** TRUE = this catalog is a list of discontinued items ''no longer in print'' (closeouts)
	* '''~~Notes~~''':		** FALSE = normal catalog; items will be marked as "in print"
	** A "source" is usually a printed catalog from a supplier, though it can also be the manufacturer's web site on a particular date.		* '''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.
	** To discontinue a supplier, set ID_Supercede=ID for all active sources; the catalog will then show only current stock as ~~avaialble~~.		==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==		==SQL==
	<mysql>CREATE TABLE `ctg_sources` (		<mysql>CREATE TABLE `ctg_sources` (

Woozle: rescued brief explanation from Tables page before deleting it there

2016-02-01T21:28:01Z

rescued brief explanation from Tables page before deleting it there

← Older revision		Revision as of 21:28, 1 February 2016
Line 7:		Line 7:
	*** FALSE = normal catalog; items will be marked as "in print"		*** FALSE = normal catalog; items will be marked as "in print"
	* '''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.
	** 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.
	==SQL==		==SQL==
	~~<section begin=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",
Line 20:		Line 21:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: used by

2009-05-03T23:51:20Z

used by

← Older revision		Revision as of 23:51, 3 May 2009
Line 1:		Line 1:
	==About==		==About==
			* '''Used by''': {{vbzcart/query\|qryCtg_Sources_active}}
	* '''Fields''':		* '''Fields''':
	** '''ID_Supercede''': Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current		** '''ID_Supercede''': Supplier Catalogs].ID of catalog which supercedes this one; NULL = this one is current

Woozle: shortened SQL doc lines a bit by moving longer explanations to "about"

2009-03-08T18:44:59Z

shortened SQL doc lines a bit by moving longer explanations to "about"

← Older revision		Revision as of 18:44, 8 March 2009
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 ~~(NULL = this one is current)~~",		ID_Supercede INT DEFAULT NULL COMMENT "[Supplier Catalogs].ID of catalog which supercedes this one, if any",
	isCloseOut BOOL DEFAULT FALSE COMMENT "~~TRUE =~~ this ~~catalog is~~ a ~~list of discontinued items no longer in print (closeouts); FALSE = normal~~ catalog",		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 />

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==
...

2009-03-08T18:42:16Z

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 />...

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 /><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>
<section end=sql />

← Older revision		Revision as of 10:29, 20 June 2017
Line 6:		Line 6:
	** 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''':
	** TRUE = this catalog is a list of discontinued items ''no longer in print'' (closeouts)		** TRUE = this catalog is a list of discontinued items ''no longer in print'' (closeouts) but still available for the moment
	** 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.
	* '''~~DateAvail~~''': The approximate date of the catalog's effectiveness (e.g. "Spring 20xx" would be 20xx-03-15 or so, or date received if earlier)		* '''DateActive''': The approximate earliest date of the catalog's effectiveness (e.g. "Spring 20xx" would be 20xx-03-15 or so, or date received if earlier)
	* '''DateExpires''': The approximate date when the catalog is no longer expected to apply (e.g. "20xx Catalog" would be 20xx-12-31)		* '''DateExpires''': The approximate date when the catalog is no longer expected to apply (e.g. "20xx Catalog" would be 20xx-12-31)
	==History==		==History==
	* '''2017-06-18''' Changed engine from MYISAM to InnoDB; added '''LastUpdate'''		* '''2017-06-18''' Changed engine from MYISAM to InnoDB; added '''LastUpdate'''
	* '''2017-06-19''' Added '''DateExpires'''		* '''2017-06-19''' Added '''DateExpires'''
			* '''2017-06-20''' Renaming '''DateAvail''' to '''DateActive''', mainly for aesthetic reasons
	==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 23:		Line 24:
	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",		DateActive DATETIME DEFAULT NULL COMMENT "earliest date on which this source is valid",
	DateExpires DATETIME DEFAULT NULL COMMENT "estimated date on which this source expires",		DateExpires DATETIME DEFAULT NULL COMMENT "estimated date on which this source expires",
	LastUpdate TIMESTAMP NULL ON UPDATE NOW() COMMENT "automatically updated when record changes",		LastUpdate TIMESTAMP NULL ON UPDATE NOW() COMMENT "automatically updated when record changes",