VbzCart/docs/tables/ctg items

About

• Purpose: Specifies which item varieties/prices are available in a group

SQL

<section begin=sql /><mysql>CREATE TABLE `ctg_items` (

 ID             INT NOT NULL AUTO_INCREMENT,
 ID_Group       INT NOT NULL COMMENT "ctg_groups.ID",
 ID_ItTyp       INT NOT NULL COMMENT "cat_ittyps.ID -- basic item type",
 ID_ItOpt       INT DEFAULT NULL COMMENT "cat_itopts.ID -- option for this item",
 Descr          VARCHAR(63) COMMENT "name or description for this item/option",
 PriceBuy       DECIMAL(9,2) DEFAULT NULL COMMENT "cost to us",
 PriceSell      DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",
 PriceList      DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",
 ID_ShipCost    INT DEFAULT NULL COMMENT "cat_ship_costs.ID",
 isActive       BOOL DEFAULT FALSE COMMENT "this group/type/option is available",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql> <section end=sql />