Table orders

From Zen Cart(tm) Wiki
Revision as of 16:55, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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 Primary Key Index

A unique, auto incremented value, to identify each order record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


customers_id Index

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 Index

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

Help.gif
Type: datetime
Null: Yes
Default: NULL


currency

The currency used to pay for this order.
Type: char(3)
Null: Yes
Default: NULL


currency_value

Help.gif
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

Help.gif
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.