opencart

+-
ERD Image


Start a discussion

MySQL

opencart

Gravatar photo
Created by George
on 2009 Dec 30
Gravatar photo
Last Updated by Elouafiq
on 2010 Mar 15
Brief Description

opencart v1.4
www.opencart.com
OpenCart is an open source PHP-based online shopping cart system. A robust e-commerce solution for Internet merchants with the ability to create their online business

Tags

mysql opencart php shopping

Favorites          3 Followers
Viewed                1031 times

Permalink

trunk_4

address_id

PKINT

customer_id

INT

company

VARCHAR

firstname

VARCHAR

lastname

VARCHAR

address_1

VARCHAR

address_2

VARCHAR

postcode

VARCHAR

city

VARCHAR

country_id

INT

zone_id

INT

category_id

PKINT

image

VARCHAR

parent_id

INT

sort_order

INT

date_added

DATETIME

date_modified

DATETIME

category_id

PKINT

language_id

PKINT

name

VARCHAR

meta_description

VARCHAR

description

TEXT

country_id

PKINT

name

VARCHAR

iso_code_2

VARCHAR

iso_code_3

VARCHAR

address_format

TEXT

coupon_id

PKINT

code

VARCHAR

type

CHAR

discount

DECIMAL

logged

INT

shipping

INT

total

DECIMAL

date_start

DATE

date_end

DATE

uses_total

INT

uses_customer

VARCHAR

status

INT

date_added

DATETIME

coupon_id

PKINT

language_id

PKINT

name

VARCHAR

description

TEXT

coupon_product_id

PKINT

coupon_id

INT

product_id

INT

currency_id

PKINT

title

VARCHAR

code

VARCHAR

symbol_left

VARCHAR

symbol_right

VARCHAR

decimal_place

CHAR

value

FLOAT

status

INT

date_modified

DATETIME

customer_id

PKINT

firstname

VARCHAR

lastname

VARCHAR

email

VARCHAR

telephone

VARCHAR

fax

VARCHAR

password

VARCHAR

cart

TEXT

newsletter

INT

address_id

INT

status

INT

customer_group_id

INT

ip

VARCHAR

date_added

DATETIME

customer_group_id

PKINT

name

VARCHAR

download_id

PKINT

filename

VARCHAR

mask

VARCHAR

remaining

INT

date_added

DATETIME

download_id

PKINT

language_id

PKINT

name

VARCHAR

extension_id

PKINT

type

VARCHAR

key

VARCHAR

geo_zone_id

PKINT

name

VARCHAR

description

VARCHAR

date_modified

DATETIME

date_added

DATETIME

information_id

PKINT

sort_order

INT

information_id

PKINT

language_id

PKINT

title

VARCHAR

description

TEXT

language_id

PKINT

name

VARCHAR

code

VARCHAR

locale

VARCHAR

image

VARCHAR

directory

VARCHAR

filename

VARCHAR

sort_order

INT

status

INT

manufacturer_id

PKINT

name

VARCHAR

image

VARCHAR

sort_order

INT

measurement_class_id

PKINT

language_id

PKINT

title

VARCHAR

unit

VARCHAR

from_id

INT

to_id

INT

rule

DECIMAL

order_id

PKINT

customer_id

INT

firstname

VARCHAR

lastname

VARCHAR

telephone

VARCHAR

fax

VARCHAR

email

VARCHAR

shipping_firstname

VARCHAR

shipping_lastname

VARCHAR

shipping_company

VARCHAR

shipping_address_1

VARCHAR

shipping_address_2

VARCHAR

shipping_city

VARCHAR

shipping_postcode

VARCHAR

shipping_zone

VARCHAR

shipping_zone_id

INT

shipping_country

VARCHAR

shipping_country_id

INT

shipping_address_format

TEXT

shipping_method

VARCHAR

payment_firstname

VARCHAR

payment_lastname

VARCHAR

payment_company

VARCHAR

payment_address_1

VARCHAR

payment_address_2

VARCHAR

payment_city

VARCHAR

payment_postcode

VARCHAR

payment_zone

VARCHAR

payment_zone_id

INT

payment_country

VARCHAR

payment_country_id

INT

payment_address_format

TEXT

payment_method

VARCHAR

comment

TEXT

total

DECIMAL

order_status_id

INT

language_id

INT

currency_id

INT

currency

VARCHAR

value

DECIMAL

coupon_id

INT

date_modified

DATETIME

date_added

DATETIME

ip

VARCHAR

order_download_id

PKINT

order_id

INT

order_product_id

INT

name

VARCHAR

filename

VARCHAR

mask

VARCHAR

remaining

INT

order_history_id

PKINT

order_id

INT

order_status_id

INT

notify

INT

comment

TEXT

date_added

DATETIME

order_option_id

PKINT

order_id

INT

order_product_id

INT

product_option_value_id

INT

name

VARCHAR

value

VARCHAR

price

DECIMAL

prefix

CHAR

order_product_id

PKINT

order_id

INT

product_id

INT

name

VARCHAR

model

VARCHAR

price

DECIMAL

total

DECIMAL

tax

DECIMAL

quantity

INT

order_status_id

PKINT

language_id

PKINT

name

VARCHAR

order_total_id

PKINT

order_id

INT

title

VARCHAR

text

VARCHAR

value

DECIMAL

sort_order

INT

product_id

PKINT

model

VARCHAR

sku

VARCHAR

location

VARCHAR

quantity

INT

stock_status_id

INT

image

VARCHAR

manufacturer_id

INT

shipping

INT

price

DECIMAL

tax_class_id

INT

date_available

DATE

weight

DECIMAL

weight_class_id

INT

length

DECIMAL

width

DECIMAL

height

DECIMAL

measurement_class_id

INT

status

INT

date_added

DATETIME

date_modified

DATETIME

viewed

INT

product_id

PKINT

language_id

PKINT

name

VARCHAR

meta_description

VARCHAR

description

TEXT

product_discount_id

PKINT

product_id

INT

customer_group_id

INT

quantity

INT

priority

INT

price

DECIMAL

date_start

DATE

date_end

DATE

product_image_id

PKINT

product_id

INT

image

VARCHAR

product_option_id

PKINT

product_id

INT

sort_order

INT

New Attribute1

VARCHAR

product_option_id

PKINT

language_id

PKINT

product_id

INT

name

VARCHAR

product_option_value_id

PKINT

product_option_id

INT

product_id

INT

quantity

INT

subtract

INT

price

DECIMAL

prefix

CHAR

sort_order

INT

product_option_value_id

PKINT

language_id

PKINT

product_id

INT

name

VARCHAR

product_id

PKINT

related_id

PKINT

product_special_id

PKINT

product_id

INT

customer_group_id

INT

priority

INT

price

DECIMAL

date_start

DATE

date_end

DATE

product_id

PKINT

category_id

PKINT

product_id

PKINT

download_id

PKINT

review_id

PKINT

product_id

INT

customer_id

INT

author

VARCHAR

text

TEXT

rating

INT

status

INT

date_added

DATETIME

date_modified

DATETIME

setting_id

PKINT

group

VARCHAR

key

VARCHAR

value

TEXT

tax_class_id

PKINT

title

VARCHAR

description

VARCHAR

date_added

DATETIME

date_modified

DATETIME

tax_rate_id

PKINT

geo_zone_id

INT

tax_class_id

INT

priority

INT

rate

DECIMAL

description

VARCHAR

date_modified

DATETIME

date_added

DATETIME

url_alias_id

PKINT

query

VARCHAR

keyword

VARCHAR

user_id

PKINT

user_group_id

INT

username

VARCHAR

password

VARCHAR

firstname

VARCHAR

lastname

VARCHAR

email

VARCHAR

status

INT

ip

VARCHAR

date_added

DATETIME

user_group_id

PKINT

name

VARCHAR

permission

TEXT

weight_class_id

PKINT

language_id

PKINT

title

VARCHAR

unit

VARCHAR

from_id

INT

to_id

INT

rule

DECIMAL

zone_id

PKINT

country_id

INT

code

VARCHAR

name

VARCHAR

zone_to_geo_zone_id

PKINT

country_id

INT

zone_id

INT

geo_zone_id

INT

date_added

DATETIME

date_modified

DATETIME