Table group pricing

From Zen Cart(tm) Wiki
Revision as of 22:00, 17 November 2006 by Blindside (talk | contribs) (Reverted edits by Torke (Talk); changed back to last version by Allcanadiansearch.ca)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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