Schema tabella VirtueMart 1.1
Servizio offerto da VMItalia.net
 

 

jos_vm_affiliate  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

affiliate_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

user_id

int(11)

(NULL)

NO

0

active

char(1)

utf8_general_ci

NO

N

rate

int(11)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_affiliate

0

PRIMARY

1

affiliate_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_affiliate_sale  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

order_id

int(11)

(NULL)

NO

PRI

0

visit_id

varchar(32)

utf8_general_ci

NO

affiliate_id

int(11)

(NULL)

NO

0

rate

int(2)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_affiliate_sale

0

PRIMARY

1

order_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_auth_group  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

group_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

group_name

varchar(128)

utf8_general_ci

YES

(NULL)

group_level

int(11)

(NULL)

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_auth_group

0

PRIMARY

1

group_id

A

4

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_auth_user_group  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

user_id

int(11)

(NULL)

NO

PRI

0

group_id

int(11)

(NULL)

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_auth_user_group

0

PRIMARY

1

user_id

A

2

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_auth_user_vendor  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

user_id

int(11)

(NULL)

YES

MUL

(NULL)

vendor_id

int(11)

(NULL)

YES

MUL

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_auth_user_vendor

1

idx_auth_user_vendor_user_id

1

user_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_auth_user_vendor

1

idx_auth_user_vendor_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_cart  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

user_id

int(11)

(NULL)

NO

PRI

cart_content

text

utf8_general_ci

NO

last_updated

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_cart

0

PRIMARY

1

user_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_category  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

category_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_id

int(11)

(NULL)

NO

MUL

0

category_name

varchar(128)

utf8_general_ci

NO

MUL

category_description

text

utf8_general_ci

YES

(NULL)

category_thumb_image

varchar(255)

utf8_general_ci

YES

(NULL)

category_full_image

varchar(255)

utf8_general_ci

YES

(NULL)

category_publish

char(1)

utf8_general_ci

YES

(NULL)

cdate

int(11)

(NULL)

YES

(NULL)

mdate

int(11)

(NULL)

YES

(NULL)

category_browsepage

varchar(255)

utf8_general_ci

NO

browse_1

products_per_row

tinyint(2)

(NULL)

NO

1

category_flypage

varchar(255)

utf8_general_ci

YES

(NULL)

list_order

int(11)

(NULL)

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_category

0

PRIMARY

1

category_id

A

5

(NULL)

(NULL)

BTREE

jos_vm_category

1

idx_category_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_category

1

idx_category_name

1

category_name

A

(NULL)

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_category_xref  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

category_parent_id

int(11)

(NULL)

NO

MUL

0

category_child_id

int(11)

(NULL)

NO

PRI

0

category_list

int(11)

(NULL)

YES

MUL

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_category_xref

0

PRIMARY

1

category_child_id

A

5

(NULL)

(NULL)

BTREE

jos_vm_category_xref

1

category_xref_category_parent_id

1

category_parent_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_category_xref

1

idx_category_xref_category_list

1

category_list

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_country  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

country_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

zone_id

int(11)

(NULL)

NO

1

country_name

varchar(64)

utf8_general_ci

YES

MUL

(NULL)

country_3_code

char(3)

utf8_general_ci

YES

(NULL)

country_2_code

char(2)

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_country

0

PRIMARY

1

country_id

A

244

(NULL)

(NULL)

BTREE

jos_vm_country

1

idx_country_name

1

country_name

A

244

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_coupons  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

coupon_id

int(16)

(NULL)

NO

PRI

(NULL)

auto_increment

coupon_code

varchar(32)

utf8_general_ci

NO

percent_or_total

enum('percent','total')

utf8_general_ci

NO

percent

coupon_type

enum('gift','permanent')

utf8_general_ci

NO

gift

coupon_value

decimal(12,2)

(NULL)

NO

0.00

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_coupons

0

PRIMARY

1

coupon_id

A

4

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_creditcard  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

creditcard_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_id

int(11)

(NULL)

NO

0

creditcard_name

varchar(70)

utf8_general_ci

NO

creditcard_code

varchar(30)

utf8_general_ci

NO

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_creditcard

0

PRIMARY

1

creditcard_id

A

7

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_csv  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

field_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

field_name

varchar(128)

utf8_general_ci

NO

field_default_value

text

utf8_general_ci

YES

(NULL)

field_ordering

int(3)

(NULL)

NO

0

field_required

char(1)

utf8_general_ci

YES

N

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_csv

0

PRIMARY

1

field_id

A

25

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_currency  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

currency_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

currency_name

varchar(64)

utf8_general_ci

YES

MUL

(NULL)

currency_code

char(3)

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_currency

0

PRIMARY

1

currency_id

A

144

(NULL)

(NULL)

BTREE

jos_vm_currency

1

idx_currency_name

1

currency_name

A

144

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_export  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

export_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_id

int(11)

(NULL)

YES

(NULL)

export_name

varchar(255)

utf8_general_ci

YES

(NULL)

export_desc

text

utf8_general_ci

NO

export_class

varchar(50)

utf8_general_ci

NO

export_enabled

char(1)

utf8_general_ci

NO

N

export_config

text

utf8_general_ci

NO

iscore

tinyint(3)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_export

0

PRIMARY

1

export_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_function  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

function_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

module_id

int(11)

(NULL)

YES

MUL

(NULL)

function_name

varchar(32)

utf8_general_ci

YES

MUL

(NULL)

function_class

varchar(32)

utf8_general_ci

YES

(NULL)

function_method

varchar(32)

utf8_general_ci

YES

(NULL)

function_description

text

utf8_general_ci

YES

(NULL)

function_perms

varchar(255)

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_function

0

PRIMARY

1

function_id

A

146

(NULL)

(NULL)

BTREE

jos_vm_function

1

idx_function_module_id

1

module_id

A

14

(NULL)

(NULL)

YES

BTREE

jos_vm_function

1

idx_function_name

1

function_name

A

146

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_manufacturer  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

manufacturer_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

mf_name

varchar(64)

utf8_general_ci

YES

(NULL)

mf_email

varchar(255)

utf8_general_ci

YES

(NULL)

mf_desc

text

utf8_general_ci

YES

(NULL)

mf_category_id

int(11)

(NULL)

YES

(NULL)

mf_url

varchar(255)

utf8_general_ci

NO

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_manufacturer

0

PRIMARY

1

manufacturer_id

A

1

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_manufacturer_category  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

mf_category_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

mf_category_name

varchar(64)

utf8_general_ci

YES

MUL

(NULL)

mf_category_desc

text

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_manufacturer_category

0

PRIMARY

1

mf_category_id

A

1

(NULL)

(NULL)

BTREE

jos_vm_manufacturer_category

1

idx_manufacturer_category_category_name

1

mf_category_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_module  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

module_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

module_name

varchar(255)

utf8_general_ci

YES

MUL

(NULL)

module_description

text

utf8_general_ci

YES

(NULL)

module_perms

varchar(255)

utf8_general_ci

YES

(NULL)

module_publish

char(1)

utf8_general_ci

YES

(NULL)

list_order

int(11)

(NULL)

YES

MUL

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_module

0

PRIMARY

1

module_id

A

18

(NULL)

(NULL)

BTREE

jos_vm_module

1

idx_module_name

1

module_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_module

1

idx_module_list_order

1

list_order

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_order_history  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

order_status_history_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

order_id

int(11)

(NULL)

NO

0

order_status_code

char(1)

utf8_general_ci

NO

0

date_added

datetime

(NULL)

NO

0000-00-00 00:00:00

customer_notified

int(1)

(NULL)

YES

0

comments

text

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_order_history

0

PRIMARY

1

order_status_history_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_order_item  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

order_item_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

order_id

int(11)

(NULL)

YES

MUL

(NULL)

user_info_id

varchar(32)

utf8_general_ci

YES

MUL

(NULL)

vendor_id

int(11)

(NULL)

YES

MUL

(NULL)

product_id

int(11)

(NULL)

YES

(NULL)

order_item_sku

varchar(64)

utf8_general_ci

NO

order_item_name

varchar(64)

utf8_general_ci

NO

product_quantity

int(11)

(NULL)

YES

(NULL)

product_item_price

decimal(15,5)

(NULL)

YES

(NULL)

product_final_price

decimal(12,2)

(NULL)

NO

0.00

order_item_currency

varchar(16)

utf8_general_ci

YES

(NULL)

order_status

char(1)

utf8_general_ci

YES

(NULL)

cdate

int(11)

(NULL)

YES

(NULL)

mdate

int(11)

(NULL)

YES

(NULL)

product_attribute

text

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_order_item

0

PRIMARY

1

order_item_id

A

0

(NULL)

(NULL)

BTREE

jos_vm_order_item

1

idx_order_item_order_id

1

order_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_order_item

1

idx_order_item_user_info_id

1

user_info_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_order_item

1

idx_order_item_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_order_payment  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

order_id

int(11)

(NULL)

NO

MUL

0

payment_method_id

int(11)

(NULL)

YES

MUL

(NULL)

order_payment_code

varchar(30)

utf8_general_ci

NO

order_payment_number

blob

(NULL)

YES

(NULL)

order_payment_expire

int(11)

(NULL)

YES

(NULL)

order_payment_name

varchar(255)

utf8_general_ci

YES

(NULL)

order_payment_log

text

utf8_general_ci

YES

(NULL)

order_payment_trans_id

text

utf8_general_ci

NO

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_order_payment

1

idx_order_payment_order_id

1

order_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_order_payment

1

idx_order_payment_method_id

1

payment_method_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_order_status  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

order_status_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

order_status_code

char(1)

utf8_general_ci

NO

order_status_name

varchar(64)

utf8_general_ci

YES

(NULL)

order_status_description

text

utf8_general_ci

NO

list_order

int(11)

(NULL)

YES

MUL

(NULL)

vendor_id

int(11)

(NULL)

YES

MUL

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_order_status

0

PRIMARY

1

order_status_id

A

5

(NULL)

(NULL)

BTREE

jos_vm_order_status

1

idx_order_status_list_order

1

list_order

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_order_status

1

idx_order_status_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_order_user_info  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

order_info_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

order_id

int(11)

(NULL)

NO

MUL

0

user_id

int(11)

(NULL)

NO

0

address_type

char(2)

utf8_general_ci

YES

(NULL)

address_type_name

varchar(32)

utf8_general_ci

YES

(NULL)

company

varchar(64)

utf8_general_ci

YES

(NULL)

title

varchar(32)

utf8_general_ci

YES

(NULL)

last_name

varchar(32)

utf8_general_ci

YES

(NULL)

first_name

varchar(32)

utf8_general_ci

YES

(NULL)

middle_name

varchar(32)

utf8_general_ci

YES

(NULL)

phone_1

varchar(32)

utf8_general_ci

YES

(NULL)

phone_2

varchar(32)

utf8_general_ci

YES

(NULL)

fax

varchar(32)

utf8_general_ci

YES

(NULL)

address_1

varchar(64)

utf8_general_ci

NO

address_2

varchar(64)

utf8_general_ci

YES

(NULL)

city

varchar(32)

utf8_general_ci

NO

state

varchar(32)

utf8_general_ci

NO

country

varchar(32)

utf8_general_ci

NO

US

zip

varchar(32)

utf8_general_ci

NO

user_email

varchar(255)

utf8_general_ci

YES

(NULL)

extra_field_1

varchar(255)

utf8_general_ci

YES

(NULL)

extra_field_2

varchar(255)

utf8_general_ci

YES

(NULL)

extra_field_3

varchar(255)

utf8_general_ci

YES

(NULL)

extra_field_4

char(1)

utf8_general_ci

YES

(NULL)

extra_field_5

char(1)

utf8_general_ci

YES

(NULL)

bank_account_nr

varchar(32)

utf8_general_ci

NO

bank_name

varchar(32)

utf8_general_ci

NO

bank_sort_code

varchar(16)

utf8_general_ci

NO

bank_iban

varchar(64)

utf8_general_ci

NO

bank_account_holder

varchar(48)

utf8_general_ci

NO

bank_account_type

enum('Checking','Business Checking','Savings')

utf8_general_ci

NO

Checking

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_order_user_info

0

PRIMARY

1

order_info_id

A

0

(NULL)

(NULL)

BTREE

jos_vm_order_user_info

1

idx_order_info_order_id

1

order_id

A

(NULL)

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_orders  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

order_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

user_id

int(11)

(NULL)

NO

MUL

0

vendor_id

int(11)

(NULL)

NO

MUL

0

order_number

varchar(32)

utf8_general_ci

YES

MUL

(NULL)

user_info_id

varchar(32)

utf8_general_ci

YES

MUL

(NULL)

order_total

decimal(15,5)

(NULL)

NO

0.00000

order_subtotal

decimal(15,5)

(NULL)

YES

(NULL)

order_tax

decimal(10,2)

(NULL)

YES

(NULL)

order_tax_details

text

utf8_general_ci

NO

order_shipping

decimal(10,2)

(NULL)

YES

(NULL)

order_shipping_tax

decimal(10,2)

(NULL)

YES

(NULL)

coupon_discount

decimal(12,2)

(NULL)

NO

0.00

coupon_code

varchar(32)

utf8_general_ci

YES

(NULL)

order_discount

decimal(12,2)

(NULL)

NO

0.00

order_currency

varchar(16)

utf8_general_ci

YES

(NULL)

order_status

char(1)

utf8_general_ci

YES

(NULL)

cdate

int(11)

(NULL)

YES

(NULL)

mdate

int(11)

(NULL)

YES

(NULL)

ship_method_id

varchar(255)

utf8_general_ci

YES

MUL

(NULL)

customer_note

text

utf8_general_ci

NO

ip_address

varchar(15)

utf8_general_ci

NO

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_orders

0

PRIMARY

1

order_id

A

0

(NULL)

(NULL)

BTREE

jos_vm_orders

1

idx_orders_user_id

1

user_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_orders

1

idx_orders_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_orders

1

idx_orders_order_number

1

order_number

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_orders

1

idx_orders_user_info_id

1

user_info_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_orders

1

idx_orders_ship_method_id

1

ship_method_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_payment_method  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

payment_method_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_id

int(11)

(NULL)

YES

MUL

(NULL)

payment_method_name

varchar(255)

utf8_general_ci

YES

MUL

(NULL)

payment_class

varchar(50)

utf8_general_ci

NO

shopper_group_id

int(11)

(NULL)

YES

MUL

(NULL)

payment_method_discount

decimal(12,2)

(NULL)

YES

(NULL)

payment_method_discount_is_percent

tinyint(1)

(NULL)

NO

payment_method_discount_max_amount

decimal(10,2)

(NULL)

NO

payment_method_discount_min_amount

decimal(10,2)

(NULL)

NO

list_order

int(11)

(NULL)

YES

MUL

(NULL)

payment_method_code

varchar(8)

utf8_general_ci

YES

(NULL)

enable_processor

char(1)

utf8_general_ci

YES

(NULL)

is_creditcard

tinyint(1)

(NULL)

NO

0

payment_enabled

char(1)

utf8_general_ci

NO

N

accepted_creditcards

varchar(128)

utf8_general_ci

NO

payment_extrainfo

text

utf8_general_ci

NO

payment_passkey

blob

(NULL)

NO

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_payment_method

0

PRIMARY

1

payment_method_id

A

16

(NULL)

(NULL)

BTREE

jos_vm_payment_method

1

idx_payment_method_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_payment_method

1

idx_payment_method_name

1

payment_method_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_payment_method

1

idx_payment_method_list_order

1

list_order

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_payment_method

1

idx_payment_method_shopper_group_id

1

shopper_group_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_product  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_id

int(11)

(NULL)

NO

MUL

0

product_parent_id

int(11)

(NULL)

NO

MUL

0

product_sku

varchar(64)

utf8_general_ci

NO

MUL

product_s_desc

varchar(255)

utf8_general_ci

YES

(NULL)

product_desc

text

utf8_general_ci

YES

(NULL)

product_thumb_image

varchar(255)

utf8_general_ci

YES

(NULL)

product_full_image

varchar(255)

utf8_general_ci

YES

(NULL)

product_publish

char(1)

utf8_general_ci

YES

(NULL)

product_weight

decimal(10,4)

(NULL)

YES

(NULL)

product_weight_uom

varchar(32)

utf8_general_ci

YES

pounds.

product_length

decimal(10,4)

(NULL)

YES

(NULL)

product_width

decimal(10,4)

(NULL)

YES

(NULL)

product_height

decimal(10,4)

(NULL)

YES

(NULL)

product_lwh_uom

varchar(32)

utf8_general_ci

YES

inches

product_url

varchar(255)

utf8_general_ci

YES

(NULL)

product_in_stock

int(11)

(NULL)

NO

0

product_available_date

int(11)

(NULL)

YES

(NULL)

product_availability

varchar(56)

utf8_general_ci

NO

product_special

char(1)

utf8_general_ci

YES

(NULL)

product_discount_id

int(11)

(NULL)

YES

(NULL)

ship_code_id

int(11)

(NULL)

YES

MUL

(NULL)

cdate

int(11)

(NULL)

YES

(NULL)

mdate

int(11)

(NULL)

YES

(NULL)

product_name

varchar(64)

utf8_general_ci

YES

MUL

(NULL)

product_sales

int(11)

(NULL)

NO

0

attribute

text

utf8_general_ci

YES

(NULL)

custom_attribute

text

utf8_general_ci

NO

product_tax_id

tinyint(2)

(NULL)

NO

0

product_unit

varchar(32)

utf8_general_ci

YES

(NULL)

product_packaging

int(11)

(NULL)

YES

(NULL)

child_options

varchar(45)

utf8_general_ci

YES

(NULL)

quantity_options

varchar(45)

utf8_general_ci

YES

(NULL)

child_option_ids

varchar(45)

utf8_general_ci

YES

(NULL)

product_order_levels

varchar(45)

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product

0

PRIMARY

1

product_id

A

16

(NULL)

(NULL)

BTREE

jos_vm_product

1

idx_product_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product

1

idx_product_product_parent_id

1

product_parent_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product

1

idx_product_sku

1

product_sku

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product

1

idx_product_ship_code_id

1

ship_code_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_product

1

idx_product_name

1

product_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_product_attribute  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

attribute_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

product_id

int(11)

(NULL)

NO

MUL

0

attribute_name

char(255)

utf8_general_ci

NO

MUL

attribute_value

char(255)

utf8_general_ci

NO

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_attribute

0

PRIMARY

1

attribute_id

A

9

(NULL)

(NULL)

BTREE

jos_vm_product_attribute

1

idx_product_attribute_product_id

1

product_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_attribute

1

idx_product_attribute_name

1

attribute_name

A

(NULL)

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_attribute_sku  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_id

int(11)

(NULL)

NO

MUL

0

attribute_name

char(255)

utf8_general_ci

NO

MUL

attribute_list

int(11)

(NULL)

NO

MUL

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_attribute_sku

1

idx_product_attribute_sku_product_id

1

product_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_attribute_sku

1

idx_product_attribute_sku_attribute_name

1

attribute_name

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_attribute_sku

1

idx_product_attribute_list

1

attribute_list

A

(NULL)

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_category_xref  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

category_id

int(11)

(NULL)

NO

MUL

0

product_id

int(11)

(NULL)

NO

MUL

0

product_list

int(11)

(NULL)

YES

MUL

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_category_xref

1

idx_product_category_xref_category_id

1

category_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_category_xref

1

idx_product_category_xref_product_id

1

product_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_category_xref

1

idx_product_category_xref_product_list

1

product_list

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_product_discount  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

discount_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

amount

decimal(12,2)

(NULL)

NO

0.00

is_percent

tinyint(1)

(NULL)

NO

0

start_date

int(11)

(NULL)

NO

0

end_date

int(11)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_discount

0

PRIMARY

1

discount_id

A

2

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_download  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_id

int(11)

(NULL)

NO

0

user_id

int(11)

(NULL)

NO

0

order_id

int(11)

(NULL)

NO

0

end_date

int(11)

(NULL)

NO

0

download_max

int(11)

(NULL)

NO

0

download_id

varchar(32)

utf8_general_ci

NO

PRI

file_name

varchar(255)

utf8_general_ci

NO

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_download

0

PRIMARY

1

download_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_files  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

file_id

int(19)

(NULL)

NO

PRI

(NULL)

auto_increment

file_product_id

int(11)

(NULL)

NO

0

file_name

varchar(128)

utf8_general_ci

NO

file_title

varchar(128)

utf8_general_ci

NO

file_description

mediumtext

utf8_general_ci

NO

file_extension

varchar(128)

utf8_general_ci

NO

file_mimetype

varchar(64)

utf8_general_ci

NO

file_url

varchar(254)

utf8_general_ci

NO

file_published

tinyint(1)

(NULL)

NO

0

file_is_image

tinyint(1)

(NULL)

NO

0

file_image_height

int(11)

(NULL)

NO

0

file_image_width

int(11)

(NULL)

NO

0

file_image_thumb_height

int(11)

(NULL)

NO

50

file_image_thumb_width

int(11)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_files

0

PRIMARY

1

file_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_mf_xref  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_id

int(11)

(NULL)

YES

MUL

(NULL)

manufacturer_id

int(11)

(NULL)

YES

MUL

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_mf_xref

1

idx_product_mf_xref_product_id

1

product_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_product_mf_xref

1

idx_product_mf_xref_manufacturer_id

1

manufacturer_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_product_price  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_price_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

product_id

int(11)

(NULL)

NO

MUL

0

product_price

decimal(12,5)

(NULL)

YES

(NULL)

product_currency

char(16)

utf8_general_ci

YES

(NULL)

product_price_vdate

int(11)

(NULL)

YES

(NULL)

product_price_edate

int(11)

(NULL)

YES

(NULL)

cdate

int(11)

(NULL)

YES

(NULL)

mdate

int(11)

(NULL)

YES

(NULL)

shopper_group_id

int(11)

(NULL)

YES

MUL

(NULL)

price_quantity_start

int(11) unsigned

(NULL)

NO

0

price_quantity_end

int(11) unsigned

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_price

0

PRIMARY

1

product_price_id

A

16

(NULL)

(NULL)

BTREE

jos_vm_product_price

1

idx_product_price_product_id

1

product_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_price

1

idx_product_price_shopper_group_id

1

shopper_group_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_product_product_type_xref  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_id

int(11)

(NULL)

NO

MUL

0

product_type_id

int(11)

(NULL)

NO

MUL

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_product_type_xref

1

idx_product_product_type_xref_product_id

1

product_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_product_type_xref

1

idx_product_product_type_xref_product_type_id

1

product_type_id

A

(NULL)

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_relations  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_id

int(11)

(NULL)

NO

PRI

0

related_products

text

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_relations

0

PRIMARY

1

product_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_reviews  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

review_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

product_id

int(11)

(NULL)

NO

MUL

0

comment

text

utf8_general_ci

NO

userid

int(11)

(NULL)

NO

0

time

int(11)

(NULL)

NO

0

user_rating

tinyint(1)

(NULL)

NO

0

review_ok

int(11)

(NULL)

NO

0

review_votes

int(11)

(NULL)

NO

0

published

char(1)

utf8_general_ci

NO

Y

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_reviews

0

PRIMARY

1

review_id

A

0

(NULL)

(NULL)

BTREE

jos_vm_product_reviews

0

product_id

1

product_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_reviews

0

product_id

2

userid

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_type  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_type_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

product_type_name

varchar(255)

utf8_general_ci

NO

product_type_description

text

utf8_general_ci

YES

(NULL)

product_type_publish

char(1)

utf8_general_ci

YES

(NULL)

product_type_browsepage

varchar(255)

utf8_general_ci

YES

(NULL)

product_type_flypage

varchar(255)

utf8_general_ci

YES

(NULL)

product_type_list_order

int(11)

(NULL)

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_type

0

PRIMARY

1

product_type_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_type_parameter  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_type_id

int(11)

(NULL)

NO

PRI

0

parameter_name

varchar(255)

utf8_general_ci

NO

PRI

parameter_label

varchar(255)

utf8_general_ci

NO

parameter_description

text

utf8_general_ci

YES

(NULL)

parameter_list_order

int(11)

(NULL)

NO

MUL

0

parameter_type

char(1)

utf8_general_ci

NO

T

parameter_values

varchar(255)

utf8_general_ci

YES

(NULL)

parameter_multiselect

char(1)

utf8_general_ci

YES

(NULL)

parameter_default

varchar(255)

utf8_general_ci

YES

(NULL)

parameter_unit

varchar(32)

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_type_parameter

0

PRIMARY

1

product_type_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_type_parameter

0

PRIMARY

2

parameter_name

A

0

(NULL)

(NULL)

BTREE

jos_vm_product_type_parameter

1

idx_product_type_parameter_product_type_id

1

product_type_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_product_type_parameter

1

idx_product_type_parameter_parameter_order

1

parameter_list_order

A

(NULL)

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_product_votes  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

product_id

int(255)

(NULL)

NO

PRI

0

votes

text

utf8_general_ci

NO

allvotes

int(11)

(NULL)

NO

0

rating

tinyint(1)

(NULL)

NO

0

lastip

varchar(50)

utf8_general_ci

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_product_votes

0

PRIMARY

1

product_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_shipping_carrier  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

shipping_carrier_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

shipping_carrier_name

char(80)

utf8_general_ci

NO

shipping_carrier_list_order

int(11)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_shipping_carrier

0

PRIMARY

1

shipping_carrier_id

A

2

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_shipping_label  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

order_id

int(11)

(NULL)

NO

PRI

0

shipper_class

varchar(32)

utf8_general_ci

YES

(NULL)

ship_date

varchar(32)

utf8_general_ci

YES

(NULL)

service_code

varchar(32)

utf8_general_ci

YES

(NULL)

special_service

varchar(32)

utf8_general_ci

YES

(NULL)

package_type

varchar(16)

utf8_general_ci

YES

(NULL)

order_weight

decimal(10,2)

(NULL)

YES

(NULL)

is_international

tinyint(1)

(NULL)

YES

(NULL)

additional_protection_type

varchar(16)

utf8_general_ci

YES

(NULL)

additional_protection_value

decimal(10,2)

(NULL)

YES

(NULL)

duty_value

decimal(10,2)

(NULL)

YES

(NULL)

content_desc

varchar(255)

utf8_general_ci

YES

(NULL)

label_is_generated

tinyint(1)

(NULL)

NO

0

tracking_number

varchar(32)

utf8_general_ci

YES

(NULL)

label_image

blob

(NULL)

YES

(NULL)

have_signature

tinyint(1)

(NULL)

NO

0

signature_image

blob

(NULL)

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_shipping_label

0

PRIMARY

1

order_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_shipping_rate  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

shipping_rate_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

shipping_rate_name

varchar(255)

utf8_general_ci

NO

shipping_rate_carrier_id

int(11)

(NULL)

NO

0

shipping_rate_country

text

utf8_general_ci

NO

shipping_rate_zip_start

varchar(32)

utf8_general_ci

NO

shipping_rate_zip_end

varchar(32)

utf8_general_ci

NO

shipping_rate_weight_start

decimal(10,3)

(NULL)

NO

0.000

shipping_rate_weight_end

decimal(10,3)

(NULL)

NO

0.000

shipping_rate_value

decimal(10,2)

(NULL)

NO

0.00

shipping_rate_package_fee

decimal(10,2)

(NULL)

NO

0.00

shipping_rate_currency_id

int(11)

(NULL)

NO

0

shipping_rate_vat_id

int(11)

(NULL)

NO

0

shipping_rate_list_order

int(11)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_shipping_rate

0

PRIMARY

1

shipping_rate_id

A

21

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_shopper_group  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

shopper_group_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_id

int(11)

(NULL)

YES

MUL

(NULL)

shopper_group_name

varchar(32)

utf8_general_ci

YES

MUL

(NULL)

shopper_group_desc

text

utf8_general_ci

YES

(NULL)

shopper_group_discount

decimal(5,2)

(NULL)

NO

0.00

show_price_including_tax

tinyint(1)

(NULL)

NO

1

default

tinyint(1)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_shopper_group

0

PRIMARY

1

shopper_group_id

A

3

(NULL)

(NULL)

BTREE

jos_vm_shopper_group

1

idx_shopper_group_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_shopper_group

1

idx_shopper_group_name

1

shopper_group_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_shopper_vendor_xref  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

user_id

int(11)

(NULL)

YES

MUL

(NULL)

vendor_id

int(11)

(NULL)

YES

MUL

(NULL)

shopper_group_id

int(11)

(NULL)

YES

MUL

(NULL)

customer_number

varchar(32)

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_shopper_vendor_xref

1

idx_shopper_vendor_xref_user_id

1

user_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_shopper_vendor_xref

1

idx_shopper_vendor_xref_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_shopper_vendor_xref

1

idx_shopper_vendor_xref_shopper_group_id

1

shopper_group_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_state  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

state_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

country_id

int(11)

(NULL)

NO

MUL

1

state_name

varchar(64)

utf8_general_ci

YES

(NULL)

state_3_code

char(3)

utf8_general_ci

YES

(NULL)

state_2_code

char(2)

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_state

0

PRIMARY

1

state_id

A

448

(NULL)

(NULL)

BTREE

jos_vm_state

0

state_3_code

1

country_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_state

0

state_3_code

2

state_3_code

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_state

0

state_2_code

1

country_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_state

0

state_2_code

2

state_2_code

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_state

1

idx_country_id

1

country_id

A

14

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_tax_rate  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

tax_rate_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_id

int(11)

(NULL)

YES

MUL

(NULL)

tax_state

varchar(64)

utf8_general_ci

YES

(NULL)

tax_country

varchar(64)

utf8_general_ci

YES

(NULL)

mdate

int(11)

(NULL)

YES

(NULL)

tax_rate

decimal(10,4)

(NULL)

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_tax_rate

0

PRIMARY

1

tax_rate_id

A

1

(NULL)

(NULL)

BTREE

jos_vm_tax_rate

1

idx_tax_rate_vendor_id

1

vendor_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_user_info  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

user_info_id

varchar(32)

utf8_general_ci

NO

PRI

user_id

int(11)

(NULL)

NO

MUL

0

address_type

char(2)

utf8_general_ci

YES

(NULL)

address_type_name

varchar(32)

utf8_general_ci

YES

(NULL)

company

varchar(64)

utf8_general_ci

YES

(NULL)

title

varchar(32)

utf8_general_ci

YES

(NULL)

last_name

varchar(32)

utf8_general_ci

YES

(NULL)

first_name

varchar(32)

utf8_general_ci

YES

(NULL)

middle_name

varchar(32)

utf8_general_ci

YES

(NULL)

phone_1

varchar(32)

utf8_general_ci

YES

(NULL)

phone_2

varchar(32)

utf8_general_ci

YES

(NULL)

fax

varchar(32)

utf8_general_ci

YES

(NULL)

address_1

varchar(64)

utf8_general_ci

NO

address_2

varchar(64)

utf8_general_ci

YES

(NULL)

city

varchar(32)

utf8_general_ci

NO

state

varchar(32)

utf8_general_ci

NO

country

varchar(32)

utf8_general_ci

NO

US

zip

varchar(32)

utf8_general_ci

NO

user_email

varchar(255)

utf8_general_ci

YES

(NULL)

extra_field_1

varchar(255)

utf8_general_ci

YES

(NULL)

extra_field_2

varchar(255)

utf8_general_ci

YES

(NULL)

extra_field_3

varchar(255)

utf8_general_ci

YES

(NULL)

extra_field_4

char(1)

utf8_general_ci

YES

(NULL)

extra_field_5

char(1)

utf8_general_ci

YES

(NULL)

cdate

int(11)

(NULL)

YES

(NULL)

mdate

int(11)

(NULL)

YES

(NULL)

perms

varchar(40)

utf8_general_ci

NO

shopper

bank_account_nr

varchar(32)

utf8_general_ci

NO

bank_name

varchar(32)

utf8_general_ci

NO

bank_sort_code

varchar(16)

utf8_general_ci

NO

bank_iban

varchar(64)

utf8_general_ci

NO

bank_account_holder

varchar(48)

utf8_general_ci

NO

bank_account_type

enum('Checking','Business Checking','Savings')

utf8_general_ci

NO

Checking

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_user_info

0

PRIMARY

1

user_info_id

A

2

(NULL)

(NULL)

BTREE

jos_vm_user_info

1

idx_user_info_user_id

1

user_id

A

(NULL)

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_userfield  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

fieldid

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

name

varchar(50)

utf8_general_ci

NO

title

varchar(255)

utf8_general_ci

NO

description

mediumtext

utf8_general_ci

NO

Tipo

varchar(50)

utf8_general_ci

NO

maxlength

int(11)

(NULL)

YES

(NULL)

size

int(11)

(NULL)

YES

(NULL)

required

tinyint(4)

(NULL)

YES

0

ordering

int(11)

(NULL)

YES

(NULL)

cols

int(11)

(NULL)

YES

(NULL)

rows

int(11)

(NULL)

YES

(NULL)

value

varchar(50)

utf8_general_ci

YES

(NULL)

default

int(11)

(NULL)

YES

(NULL)

published

tinyint(1)

(NULL)

NO

1

registration

tinyint(1)

(NULL)

NO

0

shipping

tinyint(1)

(NULL)

NO

0

account

tinyint(1)

(NULL)

NO

1

readonly

tinyint(1)

(NULL)

NO

0

calculated

tinyint(1)

(NULL)

NO

0

sys

tinyint(4)

(NULL)

NO

0

vendor_id

int(11)

(NULL)

YES

(NULL)

params

mediumtext

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_userfield

0

PRIMARY

1

fieldid

A

35

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_userfield_values  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

fieldvalueid

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

fieldid

int(11)

(NULL)

NO

0

fieldtitle

varchar(255)

utf8_general_ci

NO

fieldvalue

varchar(255)

utf8_general_ci

NO

ordering

int(11)

(NULL)

NO

0

sys

tinyint(4)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_userfield_values

0

PRIMARY

1

fieldvalueid

A

3

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_vendor  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

vendor_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_name

varchar(64)

utf8_general_ci

YES

MUL

(NULL)

contact_last_name

varchar(32)

utf8_general_ci

NO

contact_first_name

varchar(32)

utf8_general_ci

NO

contact_middle_name

varchar(32)

utf8_general_ci

YES

(NULL)

contact_title

varchar(32)

utf8_general_ci

YES

(NULL)

contact_phone_1

varchar(32)

utf8_general_ci

NO

contact_phone_2

varchar(32)

utf8_general_ci

YES

(NULL)

contact_fax

varchar(32)

utf8_general_ci

YES

(NULL)

contact_email

varchar(255)

utf8_general_ci

YES

(NULL)

vendor_phone

varchar(32)

utf8_general_ci

YES

(NULL)

vendor_address_1

varchar(64)

utf8_general_ci

NO

vendor_address_2

varchar(64)

utf8_general_ci

YES

(NULL)

vendor_city

varchar(32)

utf8_general_ci

NO

vendor_state

varchar(32)

utf8_general_ci

NO

vendor_country

varchar(32)

utf8_general_ci

NO

US

vendor_zip

varchar(32)

utf8_general_ci

NO

vendor_store_name

varchar(128)

utf8_general_ci

NO

vendor_store_desc

text

utf8_general_ci

YES

(NULL)

vendor_category_id

int(11)

(NULL)

YES

MUL

(NULL)

vendor_thumb_image

varchar(255)

utf8_general_ci

YES

(NULL)

vendor_full_image

varchar(255)

utf8_general_ci

YES

(NULL)

vendor_currency

varchar(16)

utf8_general_ci

YES

(NULL)

cdate

int(11)

(NULL)

YES

(NULL)

mdate

int(11)

(NULL)

YES

(NULL)

vendor_image_path

varchar(255)

utf8_general_ci

YES

(NULL)

vendor_terms_of_service

text

utf8_general_ci

NO

vendor_url

varchar(255)

utf8_general_ci

NO

vendor_min_pov

decimal(10,2)

(NULL)

YES

(NULL)

vendor_freeshipping

decimal(10,2)

(NULL)

NO

0.00

vendor_currency_display_style

varchar(64)

utf8_general_ci

NO

vendor_accepted_currencies

text

utf8_general_ci

NO

vendor_address_format

text

utf8_general_ci

NO

vendor_date_format

varchar(255)

utf8_general_ci

NO

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_vendor

0

PRIMARY

1

vendor_id

A

1

(NULL)

(NULL)

BTREE

jos_vm_vendor

1

idx_vendor_name

1

vendor_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

jos_vm_vendor

1

idx_vendor_category_id

1

vendor_category_id

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_vendor_category  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

vendor_category_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

vendor_category_name

varchar(64)

utf8_general_ci

YES

MUL

(NULL)

vendor_category_desc

text

utf8_general_ci

YES

(NULL)

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_vendor_category

0

PRIMARY

1

vendor_category_id

A

1

(NULL)

(NULL)

BTREE

jos_vm_vendor_category

1

idx_vendor_category_category_name

1

vendor_category_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

Torna su


 

jos_vm_visit  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

visit_id

varchar(255)

utf8_general_ci

NO

PRI

affiliate_id

int(11)

(NULL)

NO

0

pages

int(11)

(NULL)

NO

0

entry_page

varchar(255)

utf8_general_ci

NO

exit_page

varchar(255)

utf8_general_ci

NO

sdate

int(11)

(NULL)

NO

0

edate

int(11)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_visit

0

PRIMARY

1

visit_id

A

0

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_waiting_list  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

waiting_list_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

product_id

int(11)

(NULL)

NO

MUL

0

user_id

int(11)

(NULL)

NO

0

notify_email

varchar(150)

utf8_general_ci

NO

MUL

notified

enum('0','1')

utf8_general_ci

YES

0

notify_date

timestamp

(NULL)

NO

CURRENT_TIMESTAMP

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_waiting_list

0

PRIMARY

1

waiting_list_id

A

0

(NULL)

(NULL)

BTREE

jos_vm_waiting_list

1

product_id

1

product_id

A

(NULL)

(NULL)

(NULL)

BTREE

jos_vm_waiting_list

1

notify_email

1

notify_email

A

(NULL)

(NULL)

(NULL)

BTREE

Torna su


 

jos_vm_zone_shipping  
Campi
Campo Tipo Collation Null Chiave Default Extra Comment

zone_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

zone_name

varchar(255)

utf8_general_ci

YES

(NULL)

zone_cost

decimal(10,2)

(NULL)

YES

(NULL)

zone_limit

decimal(10,2)

(NULL)

YES

(NULL)

zone_description

text

utf8_general_ci

NO

zone_tax_rate

int(11)

(NULL)

NO

0

Indici
Tabella Non
univoco		 Nome
chiave		 Seq
in
indice		 Nome
colonna		 Collation Cardinalità Sub
part		 Packed Null Tipo Indice Comment

jos_vm_zone_shipping

0

PRIMARY

1

zone_id

A

4

(NULL)

(NULL)

BTREE

Torna su