Ecshop Tables And Columns
select table_name, column_name
from columns 
where table_schema like '%ecshop' 
order by table_name, column_name, ordinal_position

ecs_account_log

change_desc
change_time
change_type
frozen_money
log_id
pay_points
rank_points
user_id
user_money

ecs_ad

ad_code
ad_id
ad_link
ad_name
click_count
enabled
end_time
link_email
link_man
link_phone
media_type
position_id
start_time

ecs_admin_action

action_code
action_id
parent_id
relevance

ecs_admin_log

ip_address
log_id
log_info
log_time
user_id

ecs_admin_message

deleted
message
message_id
readed
read_time
receiver_id
sender_id
sent_time
title

ecs_admin_user

action_list
add_time
agency_id
email
lang_type
last_ip
last_login
nav_list
password
role_id
suppliers_id
todolist
user_id
user_name

ecs_adsense

clicks
from_ad
referer

ecs_ad_custom

add_time
ad_id
ad_name
ad_status
ad_type
content
url

ecs_ad_position

ad_height
ad_width
position_desc
position_id
position_name
position_style

ecs_affiliate_log

log_id
money
order_id
point
separate_type
time
user_id
user_name

ecs_agency

agency_desc
agency_id
agency_name

ecs_area_region

region_id
shipping_area_id

ecs_article

add_time
article_id
article_type
author
author_email
cat_id
content
description
file_url
is_open
keywords
link
open_type
title

ecs_article_cat

cat_desc
cat_id
cat_name
cat_type
keywords
parent_id
show_in_nav
sort_order

ecs_attribute

attr_group
attr_id
attr_index
attr_input_type
attr_name
attr_type
attr_values
cat_id
is_linked
sort_order

ecs_auction_log

act_id
bid_price
bid_time
bid_user
log_id

ecs_auto_manage

endtime
item_id
starttime
type

ecs_back_goods

back_id
brand_name
goods_attr
goods_id
goods_name
goods_sn
is_real
product_id
product_sn
rec_id
send_number

ecs_back_order

action_user
address
add_time
agency_id
back_id
best_time
city
consignee
country
delivery_sn
district
email
how_oos
insure_fee
invoice_no
mobile
order_id
order_sn
postscript
province
return_time
shipping_fee
shipping_id
shipping_name
sign_building
status
suppliers_id
tel
update_time
user_id
zipcode

ecs_bonus_type

max_amount
min_amount
min_goods_amount
send_end_date
send_start_date
send_type
type_id
type_money
type_name
use_end_date
use_start_date

ecs_booking_goods

booking_time
dispose_note
dispose_time
dispose_user
email
goods_desc
goods_id
goods_number
is_dispose
link_man
rec_id
tel
user_id

ecs_brand

brand_desc
brand_id
brand_logo
brand_name
is_show
site_url
sort_order

ecs_card

card_desc
card_fee
card_id
card_img
card_name
free_money

ecs_cart

can_handsel
extension_code
goods_attr
goods_attr_id
goods_id
goods_name
goods_number
goods_price
goods_sn
is_gift
is_real
is_shipping
market_price
parent_id
product_id
rec_id
rec_type
session_id
user_id

ecs_category

cat_desc
cat_id
cat_name
filter_attr
grade
is_show
keywords
measure_unit
parent_id
show_in_nav
sort_order
style
template_file

ecs_cat_recommend

cat_id
recommend_type

ecs_collect_goods

add_time
goods_id
is_attention
rec_id
user_id

ecs_comment

add_time
comment_id
comment_rank
comment_type
content
email
id_value
ip_address
parent_id
status
user_id
user_name

ecs_crons

allow_ip
alow_files
cron_code
cron_config
cron_desc
cron_id
cron_name
cron_order
day
enable
hour
minute
nextime
run_once
thistime
week

ecs_delivery_goods

brand_name
delivery_id
extension_code
goods_attr
goods_id
goods_name
goods_sn
is_real
parent_id
product_id
product_sn
rec_id
send_number

ecs_delivery_order

action_user
address
add_time
agency_id
best_time
city
consignee
country
delivery_id
delivery_sn
district
email
how_oos
insure_fee
invoice_no
mobile
order_id
order_sn
postscript
province
shipping_fee
shipping_id
shipping_name
sign_building
status
suppliers_id
tel
update_time
user_id
zipcode

ecs_email_list

email
hash
id
stat

ecs_email_sendlist

email
email_content
error
id
last_send
pri
template_id

ecs_error_log

file
id
info
time

ecs_exchange_goods

exchange_integral
goods_id
is_exchange
is_hot

ecs_favourable_activity

act_id
act_name
act_range
act_range_ext
act_type
act_type_ext
end_time
gift
max_amount
min_amount
sort_order
start_time
user_rank

ecs_feedback

message_img
msg_area
msg_content
msg_id
msg_status
msg_time
msg_title
msg_type
order_id
parent_id
user_email
user_id
user_name

ecs_friend_link

link_id
link_logo
link_name
link_url
show_order

ecs_goods

add_time
bonus_type_id
brand_id
cat_id
click_count
extension_code
give_integral
goods_brief
goods_desc
goods_id
goods_img
goods_name
goods_name_style
goods_number
goods_sn
goods_thumb
goods_type
goods_weight
integral
is_alone_sale
is_best
is_check
is_delete
is_hot
is_new
is_on_sale
is_promote
is_real
is_shipping
keywords
last_update
market_price
original_img
promote_end_date
promote_price
promote_start_date
provider_name
rank_integral
seller_note
shop_price
sort_order
suppliers_id
warn_number

ecs_goods_activity

act_desc
act_id
act_name
act_type
end_time
ext_info
goods_id
goods_name
is_finished
product_id
start_time

ecs_goods_article

admin_id
article_id
goods_id

ecs_goods_attr

attr_id
attr_price
attr_value
goods_attr_id
goods_id

ecs_goods_cat

cat_id
goods_id

ecs_goods_gallery

goods_id
img_desc
img_id
img_original
img_url
thumb_url

ecs_goods_type

attr_group
cat_id
cat_name
enabled

ecs_group_goods

admin_id
goods_id
goods_price
parent_id

ecs_keywords

count
date
keyword
searchengine

ecs_link_goods

admin_id
goods_id
is_double
link_goods_id

ecs_mail_templates

is_html
last_modify
last_send
template_code
template_content
template_id
template_subject
type

ecs_member_price

goods_id
price_id
user_price
user_rank

ecs_nav

cid
ctype
id
ifshow
name
opennew
type
url
vieworder

ecs_order_action

action_id
action_note
action_place
action_user
log_time
order_id
order_status
pay_status
shipping_status

ecs_order_goods

extension_code
goods_attr
goods_attr_id
goods_id
goods_name
goods_number
goods_price
goods_sn
is_gift
is_real
market_price
order_id
parent_id
product_id
rec_id
send_number

ecs_order_info

address
add_time
agency_id
best_time
bonus
bonus_id
card_fee
card_id
card_message
card_name
city
confirm_time
consignee
country
discount
district
email
extension_code
extension_id
from_ad
goods_amount
how_oos
how_surplus
insure_fee
integral
integral_money
invoice_no
inv_content
inv_payee
inv_type
is_separate
mobile
money_paid
order_amount
order_id
order_sn
order_status
pack_fee
pack_id
pack_name
parent_id
pay_fee
pay_id
pay_name
pay_note
pay_status
pay_time
postscript
province
referer
shipping_fee
shipping_id
shipping_name
shipping_status
shipping_time
sign_building
surplus
tax
tel
to_buyer
user_id
zipcode

ecs_pack

free_money
pack_desc
pack_fee
pack_id
pack_img
pack_name

ecs_package_goods

admin_id
goods_id
goods_number
package_id
product_id

ecs_payment

enabled
is_cod
is_online
pay_code
pay_config
pay_desc
pay_fee
pay_id
pay_name
pay_order

ecs_pay_log

is_paid
log_id
order_amount
order_id
order_type

ecs_plugins

assign
code
install_date
library
version

ecs_products

goods_attr
goods_id
product_id
product_number
product_sn

ecs_region

agency_id
parent_id
region_id
region_name
region_type

ecs_reg_extend_info

content
Id
reg_field_id
user_id

ecs_reg_fields

display
dis_order
id
is_need
reg_field_name
type

ecs_role

action_list
role_describe
role_id
role_name

ecs_searchengine

count
date
searchengine

ecs_sessions

adminid
data
discount
email
expiry
ip
sesskey
userid
user_name
user_rank

ecs_sessions_data

data
expiry
sesskey

ecs_shipping

config_lable
enabled
insure
print_bg
print_model
shipping_code
shipping_desc
shipping_id
shipping_name
shipping_print
support_cod

ecs_shipping_area

configure
shipping_area_id
shipping_area_name
shipping_id

ecs_shop_config

code
id
parent_id
sort_order
store_dir
store_range
type
value

ecs_snatch_log

bid_price
bid_time
log_id
snatch_id
user_id

ecs_stats

access_time
access_url
area
browser
ip_address
language
referer_domain
referer_path
system
visit_times

ecs_suppliers

is_check
suppliers_desc
suppliers_id
suppliers_name

ecs_tag

goods_id
tag_id
tag_words
user_id

ecs_template

filename
id
library
number
region
remarks
sort_order
theme
type

ecs_topic

base_style
css
data
description
end_time
htmls
intro
keywords
start_time
template
title
title_pic
topic_id
topic_img

ecs_users

address_id
alias
answer
birthday
credit_line
email
flag
frozen_money
home_phone
is_special
is_validated
last_ip
last_login
last_time
mobile_phone
msn
office_phone
parent_id
passwd_answer
passwd_question
password
pay_points
qq
question
rank_points
reg_time
salt
sex
user_id
user_money
user_name
user_rank
visit_count

ecs_user_account

add_time
admin_note
admin_user
amount
id
is_paid
paid_time
payment
process_type
user_id
user_note

ecs_user_address

address
address_id
address_name
best_time
city
consignee
country
district
email
mobile
province
sign_building
tel
user_id
zipcode

ecs_user_bonus

bonus_id
bonus_sn
bonus_type_id
emailed
order_id
used_time
user_id

ecs_user_feed

feed_id
feed_type
goods_id
is_feed
user_id
value_id

ecs_user_rank

discount
max_points
min_points
rank_id
rank_name
show_price
special_rank

ecs_virtual_card

add_date
card_id
card_password
card_sn
crc32
end_date
goods_id
is_saled
order_sn

ecs_volume_price

goods_id
price_type
volume_number
volume_price

ecs_vote

can_multi
end_time
start_time
vote_count
vote_id
vote_name

ecs_vote_log

ip_address
log_id
vote_id
vote_time

ecs_vote_option

option_count
option_id
option_name
option_order
vote_id

ecs_wholesale

act_id
enabled
goods_id
goods_name
prices
rank_ids