Difference between revisions of "Table orders status"

From Zen Cart(tm) Wiki
Jump to: navigation, search
(Inserted framework for table description)
 
Line 1: Line 1:
== Database version ==
+
{{Template:menuBarDevelopers}}
 +
== Database Version ==
 +
:1.3.0.2
  
v1.3.0
 
  
 
== Description ==
 
== Description ==
 +
:Stores the different order statuses that can be used.
 +
  
 
== Table Details ==
 
== Table Details ==
 +
=== Primary Key ===
 +
:[[Table orders_status#orders_status_id|orders_status_id]]
 +
:[[Table orders_status#language_id|language_id]]
 +
 +
=== Indexed Fields ===
 +
:[[Table orders_status#orders_status_name|orders_status_name]]
 +
 +
 +
== Columns ==
 +
=== orders_status_id [[Image:Primary_key.gif|Primary Key]]===
 +
:A value to identify each orders status record.
 +
<BLOCKQUOTE>
 +
{|
 +
| Type: || int(11)
 +
|-
 +
| Null: || No
 +
|-
 +
| Default: || 0
 +
|}
 +
</BLOCKQUOTE>
 +
 +
 +
=== language_id [[Image:Primary_key.gif|Primary Key]]===
 +
:Cross-reference link to the [[Table languages|languages]] table.
 +
<BLOCKQUOTE>
 +
{|
 +
| Type: || int(11)
 +
|-
 +
| Null: || No
 +
|-
 +
| Default: || 1
 +
|}
 +
</BLOCKQUOTE>
 +
 +
 +
=== orders_status_name [[Image:Index.gif|Index]]===
 +
:The name of the order status for disply purposes.
 +
<BLOCKQUOTE>
 +
{|
 +
| Type: || smallint(6)
 +
|-
 +
| Null: || No
 +
|-
 +
| Default: || 0
 +
|}
 +
</BLOCKQUOTE>
  
=== Primary Key ===
 
  
field_name <br />
 
  
=== Indexed Fields ===  
+
== Default Entries ==
 +
<BLOCKQUOTE>
 +
{|
 +
|  [[Table orders_status#orders_status_id|orders_status_id]]: || 1
 +
|-
 +
|  [[Table orders_status#language_id|language_id]]: || 1
 +
|-
 +
|  [[Table orders_status#orders_status_name|orders_status_name]]: || Pending
 +
|}
 +
</BLOCKQUOTE>
 +
 
 +
 
 +
<BLOCKQUOTE>
 +
{|
 +
|  [[Table orders_status#orders_status_id|orders_status_id]]: || 2
 +
|-
 +
|  [[Table orders_status#language_id|language_id]]: || 1
 +
|-
 +
|  [[Table orders_status#orders_status_name|orders_status_name]]: || Processing
 +
|}
 +
</BLOCKQUOTE>
  
field_name <br />
 
  
== Columns ==
+
<BLOCKQUOTE>
 +
{|
 +
|  [[Table orders_status#orders_status_id|orders_status_id]]: || 3
 +
|-
 +
|  [[Table orders_status#language_id|language_id]]: || 1
 +
|-
 +
|  [[Table orders_status#orders_status_name|orders_status_name]]: || Delivered
 +
|}
 +
</BLOCKQUOTE>
  
=== field_name ===
 
 
Type:      (value) <br />
 
Attributes:  <br />
 
Null:        <br />
 
Default:    <br />
 
Extra:      <br />
 
  
== Defaults ==
+
<BLOCKQUOTE>
 +
{|
 +
|  [[Table orders_status#orders_status_id|orders_status_id]]: || 4
 +
|-
 +
|  [[Table orders_status#language_id|language_id]]: || 1
 +
|-
 +
|  [[Table orders_status#orders_status_name|orders_status_name]]: || Update
 +
|}
 +
</BLOCKQUOTE>

Revision as of 02:10, 19 July 2006

Database Version

1.3.0.2


Description

Stores the different order statuses that can be used.


Table Details

Primary Key

orders_status_id
language_id

Indexed Fields

orders_status_name


Columns

orders_status_id Primary Key

A value to identify each orders status record.
Type: int(11)
Null: No
Default: 0


language_id Primary Key

Cross-reference link to the languages table.
Type: int(11)
Null: No
Default: 1


orders_status_name Index

The name of the order status for disply purposes.
Type: smallint(6)
Null: No
Default: 0


Default Entries

orders_status_id: 1
language_id: 1
orders_status_name: Pending


orders_status_id: 2
language_id: 1
orders_status_name: Processing


orders_status_id: 3
language_id: 1
orders_status_name: Delivered


orders_status_id: 4
language_id: 1
orders_status_name: Update