Table group pricing

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

Database Version

1.3.5

Description

Stores all the group pricing information.

Table Details

Primary Key

group_id

Indexed Fields

None.

Columns

group_id

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