2.1. Product Types and Subtypes

Type and Subtype

In the legacy IGDB, a product "type" was defined by the GlazingTypeID column. This was an integer value that corresponded to 'types' in the GlazingTypes table, like Monolithic, Coated, etc.

Meanwhile, in the legacy CGDB, a "Shade Layer" product was defined by the "type" column, an integer value that corresponded to 'types' like venetian blind, diffusing shade, etc.

The IGSDB is designed to hold both glazing and shading types. Therefore, products are now grouped into two basic "types": GLAZING and SHADING products. Products are then further categorized by "subtypes". The table below lists the current set of subtypes for each type, as well as the legacy integer from the older databases.

Subtypes for GLAZING Type:

Subtype	Display Name	Legacy Value in IGDB
MONOLITHIC	Monolithic	2
LAMINATE	Laminate	6
INTERLAYER	Interlayer	7
EMBEDDED_COATING	Embedded coating	--
COATED	Coated glass	3
COATING	Coating	--
APPLIED_FILM	Applied film	5
FILM	Film	4

Subtypes for SHADING Type:

Subtype	Display Name	Legacy Value in CGDB
VENETIAN_BLIND	Venetian blind	0
DIFFUSING_SHADE	Diffusing shade	1
ROLLER_SHADE	Roller shade	2
WOVEN_SHADE	Woven shade	3
VERTICAL_LOUVER	Vertical louver	5
PERFORATED_SCREEN	Perforated screen	6
CELLULAR_SHADE	Cellular shade	7
PLEATED_SHADE	Pleated Shade	7
ROMAN_SHADE	Roman shade	7
SHADE_MATERIAL	Shade material	--
FRITTED_GLASS	Fritted glass	4
ACID_ETCHED_GLASS	Acid etched glass	--
SANDBLASTED_GLASS	Sandblasted glass	--
CHROMOGENIC	Chromogenic	--