View source

{{Template:menuBarDevelopers}}
== Database Version ==
:1.3.5


== Description ==
:Stores all the group pricing information.


== Table Details ==
=== Primary Key ===
:[[Table group_pricing#group_id|group_id]]

=== Indexed Fields ===
:None.


== Columns ==
=== group_id [[Image:Primary_key.gif|Primary Key]]===
:A unique, auto incremented value, to identify each group pricing record.
<BLOCKQUOTE>
{| 
| Type: || int(11)
|- 
| Null: || No
|-
| Default: ||
|- 
| Extra: || auto_increment
|}
</BLOCKQUOTE>


=== group_name ===
:The name of the group pricing record.
<BLOCKQUOTE>
{| 
| Type: || varchar(32)
|- 
| Null: || No
|-
| Default: ||
|}
</BLOCKQUOTE>


=== group_percentage ===
:The percentage discount for the group.
<BLOCKQUOTE>
{| 
| Type: || decimal(5,2)
|- 
| Null: || No
|-
| Default: || 0.00
|}
</BLOCKQUOTE>


=== last_modified ===
:The date and time that the group pricing record was last modified.
<BLOCKQUOTE>
{| 
| Type: || datetime
|- 
| Null: || Yes
|-
| Default: || ''NULL''
|}
</BLOCKQUOTE>


=== date_added ===
:The date and time that the group pricing record was first added.
<BLOCKQUOTE>
{| 
| Type: || datetime
|- 
| Null: || No
|-
| Default: || 0001-01-01 00:00:00
|}
</BLOCKQUOTE>


== Default Entries ==
<BLOCKQUOTE>
{| 
|  [[Table group_pricing#group_id|group_id]]: || 1
|- 
|  [[Table group_pricing#group_name|group_name]]: || Group 10
|-
|  [[Table group_pricing#group_percentage|group_percentage]]: || 10.00
|- 
|  [[Table group_pricing#last_modified|last_modified]]: || ''NULL''
|- 
|  [[Table group_pricing#date_added|date_added]]: || 2004-04-29 00:21:04
|}
</BLOCKQUOTE>