Table group pricing

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.5


Description

Stores all the group pricing information.


Table Details

Primary Key

group_id

Indexed Fields

None.


Columns

group_id Primary Key

A unique, auto incremented value, to identify each group pricing record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


group_name

The name of the group pricing record.
Type: varchar(32)
Null: No
Default:


group_percentage

The percentage discount for the group.
Type: decimal(5,2)
Null: No
Default: 0.00


last_modified

The date and time that the group pricing record was last modified.
Type: datetime
Null: Yes
Default: NULL


date_added

The date and time that the group pricing record was first added.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


Default Entries

group_id: 1
group_name: Group 10
group_percentage: 10.00
last_modified: NULL
date_added: 2004-04-29 00:21:04