|
this article last updated: June 11, 2010 Due to inevitable changes that will be made to the shopping cart software over time, the cart's variable and database structure may change from time to time without advanced notice. We will attempt to keep the information in this article up-to-date, but Modular Merchant makes no guarantee as to the accuracy of the information provided in this article. Use this information at your own risk.
This article outlines the database structure for the MMv4 orders database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- product_value
The total price of all products in the order.
double(16,2) | indexed
- gw_value
The total of gift wrap fees.
double(16,2) | indexed
- order_total
The total amount paid for the order.
double(16,2) | indexed
- coupon_value
The dollar total of any coupon codes that were redeemed for the order.
double(16,2) | indexed
- cid
A reference to the customer.id field associated with this order record.
int(10) | unsigned | indexed
- email
The email address associated with this order record.
varchar(255) | indexed
- create_date
The Unix timestamp of the date and time this order was created.
int(10) | unsigned | indexed
- auth_date
The Unix timestamp of the date and time payment was authorized for this order.
int(10) | unsigned | indexed
- pay_date
The Unix timestamp of the date and time payment was received for this order.
int(10) | unsigned | indexed
- processor
A reference to the entity that placed the order: system (S), admin (A), or customer (C)
char(1) | Values: S/C/A | indexed
- sai
The shipping address system ID number.
int(10) | unsigned | indexed
- ship_first_name
The first name associated with the shipping address for this order.
varchar(255) | indexed
- ship_last_name
The last name associated with the shipping address for this order.
varchar(255) | indexed
- ship_address_1
The first line of the shipping address.
varchar(255) | indexed
- ship_address_2
The second line of the shipping address.
varchar(255) | indexed
- ship_city
The city of the shipping address.
varchar(255) | indexed
- ship_state
The two-character ISO code for the state of the shipping address, followed by the two-character ISO code for that state's country.
varchar(255) | Format: State-ISO_Country-ISO (Example: OR_US) | indexed
- ship_zip
The zip code of the shipping address.
varchar(255) | indexed
- ship_country
The two-character ISO code for the country of the shipping address.
varchar(255) | indexed
- bill_first_name
The first name associated with the billing address for this order.
varchar(255) | indexed
- bill_last_name
The last name associated with the billing address for this order. The first line of the billing address.
varchar(255) | indexed
- bill_address_1
The first line of the billing address.
varchar(255) | indexed
- bill_address_2
The second line of the billing address.
varchar(255) | indexed
- bill_city
The city of the billing address.
varchar(255) | indexed
- bill_state
The two-character ISO code for the state of the billing address, followed by the two-character ISO code for that state's country.
varchar(255) | Format: State-ISO_Country-ISO (Example: OR_US) | indexed
- bill_zip
The zip code of the billing address.
varchar(255) | indexed
- bill_country
The two-character ISO code for the country of the billing address.
varchar(255) | indexed
- phone_ac
The area code of the customer's primary phone number.
varchar(255) | indexed
- phone
The customer's primary phone number.
varchar(255) | indexed
- cmr_ip
The IP address of the customer when this order was created.
varchar(255) | indexed
- pay_method
The brand name of the cc or other payment method used for this order.
varchar(255) | indexed
- cc_name
The name on the credit card used for payment.
varchar(255) | encrypted
- cc_num
The credit card number used for payment.
varchar(255) | encrypted
- cc_mon
The 2-digit month number of the expiration date of the credit card used for payment.
varchar(255) | encrypted
- cc_year
The 4-digit month number of the expiration date of the credit card used for payment.
varchar(255) | encrypted
- bid
A reference to the basket.id field associated with this order record.
varchar(255) | indexed
- gateway
The name of the payment gateway used to process payment on this order.
varchar(255) | indexed
- digdel_password
Auto-generated password needed to access the download area for this order.
varbinary(255) | indexed
- wish_list_id
System ID number of the wish list in which the order is associated with.
int(10) | unsigned | indexed
- memo
This field is used to store notes specific to the order that are visible to the customer.
text
|
