Table orders

• 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 the details of all orders.

Table Details

Primary Key

orders_id

Indexed Fields

orders_status

orders_id

customers_id

date_purchased

Columns

orders_id

A unique, auto incremented value, to identify each order record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

customers_id

The customers_id of the customer that placed the order.

Type:	int(11)
Null:	No
Default:	0

customers_name

The customer's first and lastname that placed the order.

Type:	varchar(64)
Null:	No
Default:

customers_company

The company of the customer that placed the order.

Type:	varchar(32)
Null:	Yes
Default:	NULL

customers_street_address

The street address of the customer that placed the order.

Type:	varchar(64)
Null:	No
Default:

customers_suburb

The suburb of the customer that placed the order.

Type:	varchar(32)
Null:	Yes
Default:	NULL

customers_city

The city of the customer that placed the order.

Type:	varchar(32)
Null:	No
Default:

customers_postcode

The postcode of the customer that placed the order.

Type:	varchar(10)
Null:	No
Default:

customers_state

The state of the customer that placed the order.

Type:	varchar(32)
Null:	Yes
Default:	NULL

customers_country

The country of the customer that placed the order.

Type:	varchar(32)
Null:	No
Default:

customers_telephone

The telephone number of the customer that placed the order.

Type:	varchar(32)
Null:	No
Default:

customers_email_address

The email address of the customer that placed the order.

Type:	varchar(96)
Null:	No
Default:

customers_address_format_id

The default address format id of the customer that placed the order.

Type:	int(5)
Null:	No
Default:	0

delivery_name

The first and last name of the person that the order is being delivered to.

Type:	varchar(64)
Null:	No
Default:

delivery_company

The company of the person that the order is being delivered to.

Type:	varchar(32)
Null:	Yes
Default:	NULL

delivery_street_address

The street address of the person that the order is being delivered to.

Type:	varchar(64)
Null:	No
Default:

delivery_suburb

The suburb of the person that the order is being delivered to.

Type:	varchar(32)
Null:	Yes
Default:	NULL

delivery_city

The city of the person that the order is being delivered to.

Type:	varchar(32)
Null:	No
Default:

delivery_postcode

The postcode of the person that the order is being delivered to.

Type:	varchar(10)
Null:	No
Default:

delivery_state

The state of the person that the order is being delivered to.

Type:	varchar(32)
Null:	Yes
Default:	NULL

delivery_country

The country of the person that the order is being delivered to.

Type:	varchar(32)
Null:	No
Default:

delivery_address_format_id

The address format id of the person that the order is being delivered to.

Type:	int(5)
Null:	No
Default:	0

billing_name

The first and last name of the person that the order is being billed to.

Type:	varchar(64)
Null:	No
Default:

billing_company

The company of the person that the order is being billed to.

Type:	varchar(32)
Null:	Yes
Default:	NULL

billing_street_address

The street address of the person that the order is being billed to.

Type:	varchar(64)
Null:	No
Default:

billing_suburb

The suburb of the person that the order is being billed to.

Type:	varchar(32)
Null:	Yes
Default:	NULL

billing_city

The city of the person that the order is being billed to.

Type:	varchar(32)
Null:	No
Default:

billing_postcode

The postcode of the person that the order is being billed to.

Type:	varchar(10)
Null:	No
Default:

billing_state

The state of the person that the order is being billed to.

Type:	varchar(32)
Null:	Yes
Default:	NULL

billing_country

The country of the person that the order is being billed to.

Type:	varchar(32)
Null:	No
Default:

billing_address_format_id

The address format id of the person that the order is being billed to.

Type:	int(5)
Null:	No
Default:	0

payment_method

The payment method that was used to pay for the order.

Type:	varchar(128)
Null:	No
Default:

payment_module_code

The code of the payment module that was used to pay for the order.

Type:	varchar(32)
Null:	No
Default:

shipping_method

The shipping method that was used to ship the order.

Type:	varchar(128)
Null:	No
Default:

shipping_module_code

The shipping module code that was used to ship the order.

Type:	varchar(32)
Null:	No
Default:

coupon_code

The coupon code (if any) that was used on this order.

Type:	varchar(32)
Null:	No
Default:

cc_type

The credit card type that was used to pay for this order (if credit card information is being stored in the database). NOT RECOMMENDED!

Type:	varchar(20)
Null:	Yes
Default:	NULL

cc_owner

The credit card owner name that was used to pay for this order (if credit card information is being stored in the database). NOT RECOMMENDED!

Type:	varchar(64)
Null:	Yes
Default:	NULL

cc_number

The credit card number that was used to pay for this order (if credit card information is being stored in the database). NOT RECOMMENDED!

Type:	varchar(32)
Null:	Yes
Default:	NULL

cc_expires

The expiration date of the credit card that was used to pay for this order (if credit card information is being stored in the database). NOT RECOMMENDED!

Type:	varchar(4)
Null:	Yes
Default:	NULL

cc_cvv

The cvv number of the credit card that was used to pay for this order (if credit card information is being stored in the database). NOT RECOMMENDED!

Type:	blob
Null:	Yes
Default:	NULL
Attributes:	Binary

last_modified

The date and time that this order was last modified.

Type:	datetime
Null:	Yes
Default:	NULL

date_purchased

The date and time that this order was placed.

Type:	datetime
Null:	Yes
Default:	NULL

orders_status

The order status of this order.

Type:	int(5)
Null:	No
Default:	0

orders_date_finished

Type:	datetime
Null:	Yes
Default:	NULL

currency

The currency used to pay for this order.

Type:	char(3)
Null:	Yes
Default:	NULL

currency_value

Type:	decimal(14,6)
Null:	Yes
Default:	NULL

order_total

The total dollar amount of this order. With or without tax???

Type:	decimal(14,2)
Null:	Yes
Default:	NULL

order_tax

The dollar amount of tax on this order.

Type:	decimal(14,2)
Null:	Yes
Default:	NULL

paypal_ipn_id

Type:	int(11)
Null:	No
Default:	0

ip_address

The ip address of the computer used to place this order.

Type:	varchar(96)
Null:	No
Default:

Default Entries

None.