address_book_id

PKINT

customers_id

INT

entry_gender

CHAR

entry_company

VARCHAR

entry_firstname

VARCHAR

entry_lastname

VARCHAR

entry_street_address

VARCHAR

entry_suburb

VARCHAR

entry_postcode

VARCHAR

entry_city

VARCHAR

entry_state

VARCHAR

entry_country_id

INT

entry_zone_id

INT

address_format_id

PKINT

address_format

VARCHAR

address_summary

VARCHAR

banners_id

PKINT

banners_title

VARCHAR

banners_url

VARCHAR

banners_image

VARCHAR

banners_group

VARCHAR

banners_html_text

TEXT

expires_impressions

INT

expires_date

DATETIME

date_scheduled

DATETIME

date_added

DATETIME

date_status_change

DATETIME

status

INT

banners_history_id

PKINT

banners_id

INT

banners_shown

INT

banners_clicked

INT

banners_history_date

DATETIME

categories_id

PKINT

categories_image

VARCHAR

parent_id

INT

sort_order

INT

date_added

DATETIME

last_modified

DATETIME

categories_id

PKINT

language_id

PKINT

categories_name

VARCHAR

configuration_id

PKINT

configuration_title

VARCHAR

configuration_key

VARCHAR

configuration_value

VARCHAR

configuration_description

VARCHAR

configuration_group_id

INT

sort_order

INT

last_modified

DATETIME

date_added

DATETIME

use_function

VARCHAR

set_function

VARCHAR

configuration_group_id

PKINT

configuration_group_title

VARCHAR

configuration_group_description

VARCHAR

sort_order

INT

visible

INT

startdate

CHAR

counter

INT

month

CHAR

counter

INT

countries_id

PKINT

countries_name

VARCHAR

countries_iso_code_2

CHAR

countries_iso_code_3

CHAR

address_format_id

INT

currencies_id

PKINT

title

VARCHAR

code

CHAR

symbol_left

VARCHAR

symbol_right

VARCHAR

decimal_point

CHAR

thousands_point

CHAR

decimal_places

CHAR

value

FLOAT

last_updated

DATETIME

customers_id

PKINT

customers_gender

CHAR

customers_firstname

VARCHAR

customers_lastname

VARCHAR

customers_dob

DATETIME

customers_email_address

VARCHAR

customers_default_address_id

INT

customers_telephone

VARCHAR

customers_fax

VARCHAR

customers_password

VARCHAR

customers_newsletter

CHAR

customers_basket_id

PKINT

customers_id

INT

products_id

TINYTEXT

customers_basket_quantity

INT

final_price

DECIMAL

customers_basket_date_added

CHAR

customers_basket_attributes_id

PKINT

customers_id

INT

products_id

TINYTEXT

products_options_id

INT

products_options_value_id

INT

customers_info_id

PKINT

customers_info_date_of_last_logon

DATETIME

customers_info_number_of_logons

INT

customers_info_date_account_created

DATETIME

customers_info_date_account_last_modified

DATETIME

global_product_notifications

INT

geo_zone_id

PKINT

geo_zone_name

VARCHAR

geo_zone_description

VARCHAR

last_modified

DATETIME

date_added

DATETIME

languages_id

PKINT

name

VARCHAR

code

CHAR

image

VARCHAR

directory

VARCHAR

sort_order

INT

manufacturers_id

PKINT

manufacturers_name

VARCHAR

manufacturers_image

VARCHAR

date_added

DATETIME

last_modified

DATETIME

manufacturers_id

PKINT

languages_id

PKINT

manufacturers_url

VARCHAR

url_clicked

INT

date_last_click

DATETIME

newsletters_id

PKINT

title

VARCHAR

content

TEXT

module

VARCHAR

date_added

DATETIME

date_sent

DATETIME

status

INT

locked

INT

orders_id

PKINT

customers_id

INT

customers_name

VARCHAR

customers_company

VARCHAR

customers_street_address

VARCHAR

customers_suburb

VARCHAR

customers_city

VARCHAR

customers_postcode

VARCHAR

customers_state

VARCHAR

customers_country

VARCHAR

customers_telephone

VARCHAR

customers_email_address

VARCHAR

customers_address_format_id

INT

delivery_name

VARCHAR

delivery_company

VARCHAR

delivery_street_address

VARCHAR

delivery_suburb

VARCHAR

delivery_city

VARCHAR

delivery_postcode

VARCHAR

delivery_state

VARCHAR

delivery_country

VARCHAR

delivery_address_format_id

INT

billing_name

VARCHAR

billing_company

VARCHAR

billing_street_address

VARCHAR

billing_suburb

VARCHAR

billing_city

VARCHAR

billing_postcode

VARCHAR

billing_state

VARCHAR

billing_country

VARCHAR

billing_address_format_id

INT

payment_method

VARCHAR

cc_type

VARCHAR

cc_owner

VARCHAR

cc_number

VARCHAR

cc_expires

VARCHAR

last_modified

DATETIME

date_purchased

DATETIME

orders_status

INT

orders_date_finished

DATETIME

currency

CHAR

currency_value

DECIMAL

orders_products_id

PKINT

orders_id

INT

products_id

INT

products_model

VARCHAR

products_name

VARCHAR

products_price

DECIMAL

final_price

DECIMAL

products_tax

DECIMAL

products_quantity

INT

orders_products_attributes_id

PKINT

orders_id

INT

orders_products_id

INT

products_options

VARCHAR

products_options_values

VARCHAR

options_values_price

DECIMAL

price_prefix

CHAR

orders_products_download_id

PKINT

orders_id

INT

orders_products_id

INT

orders_products_filename

VARCHAR

download_maxdays

INT

download_count

INT

orders_status_id

PKINT

language_id

PKINT

orders_status_name

VARCHAR

orders_status_history_id

PKINT

orders_id

INT

orders_status_id

INT

date_added

DATETIME

customer_notified

INT

comments

TEXT

orders_total_id

PKINT

orders_id

INT

title

VARCHAR

text

VARCHAR

value

DECIMAL

class

VARCHAR

sort_order

INT

products_id

PKINT

products_quantity

INT

products_model

VARCHAR

products_image

VARCHAR

products_price

DECIMAL

products_date_added

DATETIME

products_last_modified

DATETIME

products_date_available

DATETIME

products_weight

DECIMAL

products_status

TINYINT

products_tax_class_id

INT

manufacturers_id

INT

products_ordered

INT

products_attributes_id

PKINT

products_id

INT

options_id

INT

options_values_id

INT

options_values_price

DECIMAL

price_prefix

CHAR

products_attributes_id

PKINT

products_attributes_filename

VARCHAR

products_attributes_maxdays

INT

products_attributes_maxcount

INT

products_id

PKINT

language_id

PKINT

products_name

VARCHAR

products_description

TEXT

products_url

VARCHAR

products_viewed

INT

products_id

PKINT

customers_id

PKINT

date_added

DATETIME

products_options_id

PKINT

language_id

PKINT

products_options_name

VARCHAR

products_options_values_id

PKINT

language_id

PKINT

products_options_values_name

VARCHAR

products_options_values_to_products_options_id

PKINT

products_options_id

INT

products_options_values_id

INT

products_id

PKINT

categories_id

PKINT

reviews_id

PKINT

products_id

INT

customers_id

INT

customers_name

VARCHAR

reviews_rating

INT

date_added

DATETIME

last_modified

DATETIME

reviews_read

INT

reviews_id

PKINT

languages_id

PKINT

reviews_text

TEXT

sesskey

PKVARCHAR

expiry

INT

value

TEXT

specials_id

PKINT

products_id

INT

specials_new_products_price

DECIMAL

specials_date_added

DATETIME

specials_last_modified

DATETIME

expires_date

DATETIME

date_status_change

DATETIME

status

INT

tax_class_id

PKINT

tax_class_title

VARCHAR

tax_class_description

VARCHAR

last_modified

DATETIME

date_added

DATETIME

tax_rates_id

PKINT

tax_zone_id

INT

tax_class_id

INT

tax_priority

INT

tax_rate

DECIMAL

tax_description

VARCHAR

last_modified

DATETIME

date_added

DATETIME

customer_id

INT

full_name

VARCHAR

session_id

VARCHAR

ip_address

VARCHAR

time_entry

VARCHAR

time_last_click

VARCHAR

last_page_url

VARCHAR

zone_id

PKINT

zone_country_id

INT

zone_code

VARCHAR

zone_name

VARCHAR

association_id

PKINT

zone_country_id

INT

zone_id

INT

geo_zone_id

INT

last_modified

DATETIME

date_added

DATETIME