VbzCart/docs/tables/ctg items: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(New page: ==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_...)
 
imported>Woozle
(+Sort field)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': Specifies which item varieties/prices are available in a group
* '''Purpose''': Specifies which item varieties/prices are available in a group
* '''History''':
** '''2011-02-13''' added '''Sort''' field
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ctg_items` (
<section begin=sql /><mysql>CREATE TABLE `ctg_items` (
   ID            INT NOT NULL AUTO_INCREMENT,
   ID            INT             NOT NULL AUTO_INCREMENT,
   ID_Group      INT NOT NULL COMMENT "ctg_groups.ID",
   ID_Group      INT             NOT NULL COMMENT "ctg_groups.ID",
   ID_ItTyp      INT NOT NULL COMMENT "cat_ittyps.ID -- basic item type",
   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",
   ID_ItOpt      INT         DEFAULT NULL COMMENT "cat_itopts.ID -- option for this item",
   Descr          VARCHAR(63) COMMENT "name or description for this item/option",
   Descr          VARCHAR(63)               COMMENT "name or description for this item/option",
  Sort          VARCHAR(15)  DEFAULT NULL COMMENT "sorting order for display",
   PriceBuy      DECIMAL(9,2) DEFAULT NULL COMMENT "cost to us",
   PriceBuy      DECIMAL(9,2) DEFAULT NULL COMMENT "cost to us",
   PriceSell      DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",
   PriceSell      DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",
   PriceList      DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",
   PriceList      DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",
   ID_ShipCost    INT DEFAULT NULL COMMENT "cat_ship_costs.ID",
   ID_ShipCost    INT         DEFAULT NULL COMMENT "cat_ship_costs.ID",
   isActive      BOOL DEFAULT FALSE COMMENT "this group/type/option is available",
   isActive      BOOL       DEFAULT FALSE COMMENT "this group/type/option is available",
   PRIMARY KEY(`ID`)
   PRIMARY KEY(`ID`)
)
)
ENGINE = MYISAM;</mysql>
ENGINE = MYISAM;</mysql>
<section end=sql />
<section end=sql />

Revision as of 14:09, 13 February 2011

About

  • Purpose: Specifies which item varieties/prices are available in a group
  • History:
    • 2011-02-13 added Sort field

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",
 Sort           VARCHAR(15)  DEFAULT NULL COMMENT "sorting order for display",
 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 />