VbzCart/tables/ctg titles - Revision history

Woozle: link to catalog-building doc area

2017-06-12T11:13:38Z

link to catalog-building doc area

← Older revision		Revision as of 11:13, 12 June 2017
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': represents the availability of a Local Catalog Title from a particular Supplier Source (catalog), in a particular Group (set of types/options/prices)		* '''Purpose''': represents the availability of a Local Catalog Title from a particular Supplier Source (catalog), in a particular Group (set of types/options/prices)
			* '''Part of''': {{l/vc\|pieces/catalog/building}}
	* '''Procedure''': Any new Titles in a given Source must be entered into the Local Catalog before they can be used here.		* '''Procedure''': Any new Titles in a given Source must be entered into the Local Catalog before they can be used here.
	* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.		* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.
Line 13:		Line 14:
	** Renaming '''GroupCode''' and '''GroupDescr''' to '''Code''' and '''Descr''' to be consistent with naming in {{l/vc/table\|ctg_groups}}.		** Renaming '''GroupCode''' and '''GroupDescr''' to '''Code''' and '''Descr''' to be consistent with naming in {{l/vc/table\|ctg_groups}}.
	** Changing '''ID_Title''' to NOT NULL.		** Changing '''ID_Title''' to NOT NULL.
			* '''2017-06-12''' Changed engine from MYISAM to InnoDB
	==SQL==		==SQL==
	<mysql>CREATE TABLE `ctg_titles` (		<mysql>CREATE TABLE `ctg_titles` (
Line 27:		Line 29:
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = ~~MYISAM~~;</mysql>		ENGINE = InnoDB;</mysql>

Woozle: about Supp_CatNum

2016-02-04T18:44:29Z

about Supp_CatNum

← Older revision		Revision as of 18:44, 4 February 2016
Line 7:		Line 7:
	* '''Code''': Still reconstructing what this is for.		* '''Code''': Still reconstructing what this is for.
	* '''Descr''': Still reconstructing what this is for. Schema comment said "required if Code is used", but it is often NULL when Code is not NULL -- so changing that to "recommended if Code is used".		* '''Descr''': Still reconstructing what this is for. Schema comment said "required if Code is used", but it is often NULL when Code is not NULL -- so changing that to "recommended if Code is used".
			* '''Supp_CatNum''': the catalog number that the Supplier was assigning to this title for this catalog (sometimes the numbers change). This can be used both to note the SuppCatNum for the LCTitle (for checking in Restocks) and also to help track down the correct Title record for CatNums in old records (mainly printed).
	==History==		==History==
	* '''2016-02-04'''		* '''2016-02-04'''
	** Removing '''GroupSort''' -- I'm still figuring out how the former Group* fields are supposed to be used, and GroupSort is NULL in all existing records. If it's ever needed, document how it is supposed to work.		** Removing '''GroupSort''' -- I'm still figuring out how the former Group* fields are supposed to be used, and GroupSort is NULL in all existing records. If it's ever needed, document how it is supposed to work.
	** Renaming '''GroupCode''' and '''GroupDescr''' to '''Code''' and '''Descr''' to be consistent with naming in {{l/vc/table\|ctg_groups}}.		** Renaming '''GroupCode''' and '''GroupDescr''' to '''Code''' and '''Descr''' to be consistent with naming in {{l/vc/table\|ctg_groups}}.
	** Changing ID_Title to NOT NULL.		** Changing '''ID_Title''' to NOT NULL.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `ctg_titles` (		<mysql>CREATE TABLE `ctg_titles` (

Woozle: making ID_Title NOT NULL; corrected explanation

2016-02-04T15:51:01Z

making ID_Title NOT NULL; corrected explanation

← Older revision		Revision as of 15:51, 4 February 2016
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': ~~Specifies which groups~~ a ~~<abbr title="~~Supplier Catalog~~">SC</abbr> title belongs to~~		* '''Purpose''': represents the availability of a Local Catalog Title from a particular Supplier Source (catalog), in a particular Group (set of types/options/prices)
			* '''Procedure''': Any new Titles in a given Source must be entered into the Local Catalog before they can be used here.
	* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.		* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.
	==Fields==		==Fields==
	* '''ID_Title''': ~~When~~ the ~~build process results in creating a new LC~~ Title~~, this gets filled in with the Title's ID in order to prevent duplicates. If~~ this ~~field is NULL, then the Title is ''probably'' new, unless we have created LC Titles directly before entering them~~ from ~~the catalog. (Currently working out how to efficiently check for possible duplicates before creating new LC Titles.)~~		* '''ID_Title''': the Local Catalog Title for which this record represents availability from a Source
	* '''Code''': Still reconstructing what this is for.		* '''Code''': Still reconstructing what this is for.
	* '''Descr''': Still reconstructing what this is for. ~~Documentation~~ said "required if Code is used", but it is often NULL when Code is not NULL -- so changing that to "recommended if Code is used".		* '''Descr''': Still reconstructing what this is for. Schema comment said "required if Code is used", but it is often NULL when Code is not NULL -- so changing that to "recommended if Code is used".
	==History==		==History==
	* '''2016-02-04'''		* '''2016-02-04'''
	** Removing '''GroupSort''' -- I'm still figuring out how the former Group* fields are supposed to be used, and GroupSort is NULL in all existing records. If it's ever needed, document how it is supposed to work.		** Removing '''GroupSort''' -- I'm still figuring out how the former Group* fields are supposed to be used, and GroupSort is NULL in all existing records. If it's ever needed, document how it is supposed to work.
	** Renaming '''GroupCode''' and '''GroupDescr''' to '''Code''' and '''Descr''' to be consistent with naming in {{l/vc/table\|ctg_groups}}.		** Renaming '''GroupCode''' and '''GroupDescr''' to '''Code''' and '''Descr''' to be consistent with naming in {{l/vc/table\|ctg_groups}}.
			** Changing ID_Title to NOT NULL.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `ctg_titles` (		<mysql>CREATE TABLE `ctg_titles` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	ID_Title INT ~~DEFAULT~~ NULL COMMENT "cat_titles.ID",		ID_Title INT NOT NULL COMMENT "cat_titles.ID",
	ID_Group INT DEFAULT NULL COMMENT "ctg_groups.ID",		ID_Group INT DEFAULT NULL COMMENT "ctg_groups.ID",
	ID_Source INT DEFAULT NULL COMMENT "ctg_sources.ID - source which enables this selection",		ID_Source INT DEFAULT NULL COMMENT "ctg_sources.ID - source which enables this selection",
	WhenDiscont DATETIME DEFAULT NULL COMMENT "non-sourced discontinuation",		WhenDiscont DATETIME DEFAULT NULL COMMENT "non-sourced discontinuation",
	Code VARCHAR(7) DEFAULT NULL COMMENT "optional catalog code extension",		Code VARCHAR(7) DEFAULT NULL COMMENT "optional catalog code extension",
	Descr VARCHAR(127) DEFAULT NULL COMMENT "description extension (recommended if Code is used)",		Descr VARCHAR(127) DEFAULT NULL COMMENT "description extension (recommended if Code is used)",
	isActive BOOL DEFAULT FALSE COMMENT "this group-title membership is active?",		isActive BOOL DEFAULT FALSE COMMENT "this group-title membership is active?",
	Supp_CatNum VARCHAR(15) DEFAULT NULL COMMENT "catalog # for restock from supplier",		Supp_CatNum VARCHAR(15) DEFAULT NULL COMMENT "catalog # for restock from supplier",
	Notes VARCHAR(255) DEFAULT NULL COMMENT "notes about this particular title's availability in this group",		Notes VARCHAR(255) DEFAULT NULL COMMENT "notes about this particular title's availability in this group",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>

Woozle: removing and renaming

2016-02-04T14:31:50Z

removing and renaming

← Older revision		Revision as of 14:31, 4 February 2016
Line 3:		Line 3:
	* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.		* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.
	==Fields==		==Fields==
	* '''ID_Title''': at this ~~point~~ (~~2016-01-31~~)~~, I~~'~~m actually mystified as to~~ what this ~~field~~ is ~~actually~~ for. Documentation ~~says~~ it ~~refers~~ to ~~cat_titles~~, ~~but I can~~'~~t think why or~~ how it ~~gets set~~.		* '''ID_Title''': When the build process results in creating a new LC Title, this gets filled in with the Title's ID in order to prevent duplicates. If this field is NULL, then the Title is ''probably'' new, unless we have created LC Titles directly before entering them from the catalog. (Currently working out how to efficiently check for possible duplicates before creating new LC Titles.)
			* '''Code''': Still reconstructing what this is for.
			* '''Descr''': Still reconstructing what this is for. Documentation said "required if Code is used", but it is often NULL when Code is not NULL -- so changing that to "recommended if Code is used".
			==History==
			* '''2016-02-04'''
			** Removing '''GroupSort''' -- I'm still figuring out how the former Group* fields are supposed to be used, and GroupSort is NULL in all existing records. If it's ever needed, document how it is supposed to work.
			** Renaming '''GroupCode''' and '''GroupDescr''' to '''Code''' and '''Descr''' to be consistent with naming in {{l/vc/table\|ctg_groups}}.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `ctg_titles` (		<mysql>CREATE TABLE `ctg_titles` (
Line 11:		Line 17:
	ID_Source INT DEFAULT NULL COMMENT "ctg_sources.ID - source which enables this selection",		ID_Source INT DEFAULT NULL COMMENT "ctg_sources.ID - source which enables this selection",
	WhenDiscont DATETIME DEFAULT NULL COMMENT "non-sourced discontinuation",		WhenDiscont DATETIME DEFAULT NULL COMMENT "non-sourced discontinuation",
	~~GroupCode~~ VARCHAR(7) DEFAULT NULL COMMENT "catalog code extension ~~for this title group (optional)~~",		Code VARCHAR(7) DEFAULT NULL COMMENT "optional catalog code extension",
	~~GroupDescr~~ VARCHAR(127) DEFAULT NULL COMMENT "description extension ~~for this title group~~ (~~required~~ if ~~GroupCode~~ is used)",		Descr VARCHAR(127) DEFAULT NULL COMMENT "description extension (recommended if Code is used)",
	~~GroupSort VARCHAR(7) DEFAULT NULL COMMENT "sorting override~~",
	isActive BOOL DEFAULT FALSE COMMENT "this group-title membership is active?",		isActive BOOL DEFAULT FALSE COMMENT "this group-title membership is active?",
	Supp_CatNum VARCHAR(15) DEFAULT NULL COMMENT "catalog # for restock from supplier",		Supp_CatNum VARCHAR(15) DEFAULT NULL COMMENT "catalog # for restock from supplier",

Woozle: note about ID_Title

2016-02-01T02:09:28Z

note about ID_Title

← Older revision		Revision as of 02:09, 1 February 2016
Line 2:		Line 2:
	* '''Purpose''': Specifies which groups a <abbr title="Supplier Catalog">SC</abbr> title belongs to		* '''Purpose''': Specifies which groups a <abbr title="Supplier Catalog">SC</abbr> title belongs to
	* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.		* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.
			==Fields==
			* '''ID_Title''': at this point (2016-01-31), I'm actually mystified as to what this field is actually for. Documentation says it refers to cat_titles, but I can't think why or how it gets set.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `ctg_titles` (		<mysql>CREATE TABLE `ctg_titles` (

Woozle: note about field naming

2016-01-28T23:45:49Z

note about field naming

← Older revision		Revision as of 23:45, 28 January 2016
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Specifies which groups a title belongs to		* '''Purpose''': Specifies which groups a <abbr title="Supplier Catalog">SC</abbr> title belongs to
			* '''Future''': Rename '''ID_Title''' field to '''ID_LCTitle''', for disambiguation. Maybe ID_Group and ID_Source should be ID_SCGroup and ID_SCSource, for consistency.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `ctg_titles` (		<mysql>CREATE TABLE `ctg_titles` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	ID_Title INT DEFAULT NULL COMMENT "cat_titles.ID",		ID_Title INT DEFAULT NULL COMMENT "cat_titles.ID",
Line 17:		Line 18:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: New page: ==About== * '''Purpose''': Specifies which groups a title belongs to ==SQL==
CREATE TABLE `ctg_titles` ( ID INT NOT NULL AUTO_INCREMENT, ID_Title ...

2009-03-08T18:50:28Z

New page: ==About== * '''Purpose''': Specifies which groups a title belongs to ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_titles` ( ID INT NOT NULL AUTO_INCREMENT, ID_Title ...

New page

==About==
* '''Purpose''': Specifies which groups a title belongs to
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ctg_titles` (
ID INT NOT NULL AUTO_INCREMENT,
ID_Title INT DEFAULT NULL COMMENT "cat_titles.ID",
ID_Group INT DEFAULT NULL COMMENT "ctg_groups.ID",
ID_Source INT DEFAULT NULL COMMENT "ctg_sources.ID - source which enables this selection",
WhenDiscont DATETIME DEFAULT NULL COMMENT "non-sourced discontinuation",
GroupCode VARCHAR(7) DEFAULT NULL COMMENT "catalog code extension for this title group (optional)",
GroupDescr VARCHAR(127) DEFAULT NULL COMMENT "description extension for this title group (required if GroupCode is used)",
GroupSort VARCHAR(7) DEFAULT NULL COMMENT "sorting override",
isActive BOOL DEFAULT FALSE COMMENT "this group-title membership is active?",
Supp_CatNum VARCHAR(15) DEFAULT NULL COMMENT "catalog # for restock from supplier",
Notes VARCHAR(255) DEFAULT NULL COMMENT "notes about this particular title's availability in this group",
PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>
<section end=sql />