wayne
/
crm
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
crm/app/public/mysql.md

92 KiB
Raw Permalink Blame History

ecs_account_log

name type length default comment
log_id MEDIUMINT 8
user_id MEDIUMINT 8
user_money DECIMAL 10,2
frozen_money DECIMAL 10,2
rank_points MEDIUMINT 9
pay_points MEDIUMINT 9
change_time INT 10
change_desc VARCHAR 255
change_type TINYINT 3

ecs_ad

name type length default comment
ad_id SMALLINT 5
position_id SMALLINT 5 0
media_type TINYINT 3 0
ad_name VARCHAR 60
ad_link VARCHAR 255
ad_code TEXT
start_time INT 11 0
end_time INT 11 0
link_man VARCHAR 60
link_email VARCHAR 60
link_phone VARCHAR 60
click_count MEDIUMINT 8 0
enabled TINYINT 3 1

ecs_ad_custom

name type length default comment
ad_id MEDIUMINT 8
ad_type TINYINT 1 1
ad_name VARCHAR 60 NULL
add_time INT 10 0
content MEDIUMTEXT
url VARCHAR 255 NULL
ad_status TINYINT 3 0

ecs_ad_position

name type length default comment
position_id TINYINT 3
position_name VARCHAR 60
ad_width SMALLINT 5 0
ad_height SMALLINT 5 0
position_desc VARCHAR 255
position_style TEXT

ecs_admin_action

name type length default comment
action_id TINYINT 3
parent_id TINYINT 3 0
action_code VARCHAR 20
relevance VARCHAR 20

ecs_admin_log

name type length default comment
log_id INT 10
log_time INT 10 0
user_id TINYINT 3 0
log_info VARCHAR 255
ip_address VARCHAR 15

ecs_admin_message

name type length default comment
message_id SMALLINT 5
sender_id TINYINT 3 0
receiver_id TINYINT 3 0
sent_time INT 11 0
read_time INT 11 0
readed TINYINT 1 0
deleted TINYINT 1 0
title VARCHAR 150
message TEXT

ecs_admin_user

name type length default comment
user_id SMALLINT 5 自增ID
user_name VARCHAR 60 帳號
email VARCHAR 60 email
password VARCHAR 32 密碼
ec_salt VARCHAR 10 NULL salt值
add_time INT 11 0 加入時間
last_login INT 11 0 最後登入時間
last_ip VARCHAR 15 最後登入IP
action_list TEXT 功能列表
nav_list TEXT 常用導航
lang_type VARCHAR 50
agency_id SMALLINT 5
suppliers_id SMALLINT 5 0 供應商ID
todolist LONGTEXT 待辦事項
role_id SMALLINT 5 NULL 角色ID

ecs_adsense

name type length default comment
from_ad SMALLINT 5 0
referer VARCHAR 255
clicks INT 10 0

ecs_affiliate_log

name type length default comment
log_id MEDIUMINT 8
order_id MEDIUMINT 8
time INT 10
user_id MEDIUMINT 8
user_name VARCHAR 60 NULL
money DECIMAL 10,2 0.00
point INT 10 0
separate_type TINYINT 1 0

ecs_agency

name type length default comment
agency_id SMALLINT 5
agency_name VARCHAR 255
agency_desc TEXT

ecs_area_region

name type length default comment
shipping_area_id SMALLINT 5 0
region_id SMALLINT 5 0

ecs_article

name type length default comment
article_id MEDIUMINT 8
cat_id SMALLINT 5 0
title VARCHAR 150
content LONGTEXT
author VARCHAR 30
author_email VARCHAR 60
keywords VARCHAR 255
article_type TINYINT 1 2
is_open TINYINT 1 1
add_time INT 10 0
file_url VARCHAR 255
open_type TINYINT 1 0
link VARCHAR 255
description VARCHAR 255 NULL
pic VARCHAR 255

ecs_article_cat

name type length default comment
cat_id SMALLINT 5
cat_name VARCHAR 255
cat_type TINYINT 1 1
keywords VARCHAR 255
cat_desc VARCHAR 255
sort_order TINYINT 3 50
show_in_nav TINYINT 1 0
parent_id SMALLINT 5 0

ecs_attribute

name type length default comment
attr_id SMALLINT 5
cat_id SMALLINT 5 0
attr_name VARCHAR 60
attr_input_type TINYINT 1 1
attr_type TINYINT 1 1
attr_values TEXT
attr_index TINYINT 1 0
sort_order TINYINT 3 0
is_linked TINYINT 1 0
attr_group TINYINT 1 0

ecs_auction_log

name type length default comment
log_id MEDIUMINT 8
act_id MEDIUMINT 8
bid_user MEDIUMINT 8
bid_price DECIMAL 10,2
bid_time INT 10

ecs_auto_manage

name type length default comment
item_id MEDIUMINT 8
type VARCHAR 10
starttime INT 10
endtime INT 10

ecs_back_action

name type length default comment
action_id MEDIUMINT 8
back_id MEDIUMINT 8 0
action_user VARCHAR 30
status_back TINYINT 1 0
status_refund TINYINT 1 0
action_note VARCHAR 255
log_time INT 11 0

ecs_back_goods

name type length default comment
rec_id MEDIUMINT 8
back_id MEDIUMINT 8 0
goods_id MEDIUMINT 8 0
product_id MEDIUMINT 8 0
product_sn VARCHAR 60 NULL
goods_name VARCHAR 120 NULL
brand_name VARCHAR 60 NULL
goods_sn VARCHAR 60 NULL
is_real TINYINT 1 0
send_number SMALLINT 5 0
goods_attr TEXT
back_type TINYINT 1 0
parent_id INT 10
back_goods_price DECIMAL 10,2 0.00
back_goods_number SMALLINT 5
status_back TINYINT 1 0
status_refund TINYINT 1 0

ecs_back_order

name type length default comment
back_id MEDIUMINT 8
delivery_sn VARCHAR 20
order_sn VARCHAR 20
order_id MEDIUMINT 8 0
invoice_no VARCHAR 50 NULL
add_time INT 10 0
shipping_id TINYINT 3 0
shipping_name VARCHAR 120 NULL
user_id MEDIUMINT 8 0
action_user VARCHAR 30 NULL
consignee VARCHAR 60 NULL
address VARCHAR 250 NULL
country SMALLINT 5 0
province SMALLINT 5 0
city SMALLINT 5 0
district SMALLINT 5 0
sign_building VARCHAR 120 NULL
email VARCHAR 60 NULL
zipcode VARCHAR 60 NULL
tel VARCHAR 60 NULL
mobile VARCHAR 60 NULL
best_time VARCHAR 120 NULL
postscript VARCHAR 255 NULL
how_oos VARCHAR 120 NULL
insure_fee DECIMAL 10,2 0.00
shipping_fee DECIMAL 10,2 0.00
update_time INT 10 0
suppliers_id SMALLINT 5 0
status TINYINT 1 0
return_time INT 10 0
agency_id SMALLINT 5 0
refund_type TINYINT 1 0
refund_desc VARCHAR 255
refund_money_1 DECIMAL 10,2 0.00
refund_money_2 DECIMAL 10,2 0.00
back_reason VARCHAR 255
goods_id INT 10
goods_name VARCHAR 255
status_back TINYINT 1 0 0:審核通過,1:收到寄回產品,2:換回產品已寄出,3:完成退貨/返修,4:退款(無需退貨),5:審核中,6:申請被拒絕,7:管理員取消,8:用户自己取消
status_refund TINYINT 1 0 0:未退款,1:已退款
imgs TEXT
back_pay TINYINT 1 0
back_type VARCHAR 1 0
supplier_id INT 10 0

ecs_back_replay

name type length default comment
id MEDIUMINT 8
back_id MEDIUMINT 8 0
message TEXT
add_time INT 10 0
type TINYINT 1 0

ecs_bonus_type

name type length default comment
type_id SMALLINT 5
type_name VARCHAR 60
type_money DECIMAL 10,2 0.00
send_type TINYINT 3 0
min_amount DECIMAL 10,2 0.00
max_amount DECIMAL 10,2 0.00
send_start_date INT 11 0
send_end_date INT 11 0
use_start_date INT 11 0
use_end_date INT 11 0
min_goods_amount DECIMAL 10,2 0.00
user_bonus_max INT 10

ecs_booking_goods

name type length default comment
rec_id MEDIUMINT 8
user_id MEDIUMINT 8 0
email VARCHAR 60
link_man VARCHAR 60
tel VARCHAR 60
goods_id MEDIUMINT 8 0
goods_desc VARCHAR 255
goods_number SMALLINT 5 0
booking_time INT 10 0
is_dispose TINYINT 1 0
dispose_user VARCHAR 30
dispose_time INT 10 0
dispose_note VARCHAR 255

ecs_brand

name type length default comment
brand_id SMALLINT 5
brand_name VARCHAR 60
brand_logo VARCHAR 80
brand_desc TEXT
site_url VARCHAR 255
sort_order TINYINT 3 50
is_show TINYINT 1 1
brand_banner VARCHAR 80 產品品牌banner

ecs_card

name type length default comment
card_id TINYINT 3
card_name VARCHAR 120
card_img VARCHAR 255
card_fee DECIMAL 6,2 0.00
free_money DECIMAL 6,2 0.00
card_desc VARCHAR 255

ecs_cart

name type length default comment
rec_id MEDIUMINT 8
user_id MEDIUMINT 8 0
session_id CHAR 32
goods_id MEDIUMINT 8 0
goods_sn VARCHAR 60
product_id MEDIUMINT 8 0
group_id VARCHAR 255
goods_name VARCHAR 120
market_price DECIMAL 10,2 0.00
goods_price DECIMAL 10,2 0.00
goods_number SMALLINT 5 0
goods_attr TEXT
is_real TINYINT 1 0
extension_code VARCHAR 30
parent_id MEDIUMINT 8 0
rec_type TINYINT 1 0
is_gift SMALLINT 5 0
is_shipping TINYINT 1 0
can_handsel TINYINT 3 0
goods_attr_id VARCHAR 255
fencheng VARCHAR 255 NULL

ecs_cart_combo

name type length default comment
rec_id MEDIUMINT 8
user_id MEDIUMINT 8 0
session_id CHAR 32
goods_id MEDIUMINT 8 0
goods_sn VARCHAR 60
product_id MEDIUMINT 8 0
group_id VARCHAR 255
goods_name VARCHAR 120
market_price DECIMAL 10,2 0.00
goods_price DECIMAL 10,2 0.00
goods_number SMALLINT 5 0
goods_attr TEXT
is_real TINYINT 1 0
extension_code VARCHAR 30
parent_id MEDIUMINT 8 0
rec_type TINYINT 1 0
is_gift SMALLINT 5 0
is_shipping TINYINT 1 0
can_handsel TINYINT 3 0
goods_attr_id VARCHAR 255
fencheng VARCHAR 255 NULL

ecs_cat_recommend

name type length default comment
cat_id SMALLINT 5
recommend_type TINYINT 1

ecs_category

name type length default comment
cat_id SMALLINT 5
cat_name VARCHAR 90
keywords VARCHAR 255
cat_desc VARCHAR 255
parent_id SMALLINT 5 0
sort_order TINYINT 1 50
template_file VARCHAR 50
measure_unit VARCHAR 15
show_in_nav TINYINT 1 0
style VARCHAR 150
is_show TINYINT 1 1
grade TINYINT 4 0
filter_attr VARCHAR 255 0
is_top_style INT 3 0
is_top_show INT 3 0
cat_ico VARCHAR 255

ecs_collect_goods

name type length default comment
rec_id MEDIUMINT 8
user_id MEDIUMINT 8 0
goods_id MEDIUMINT 8 0
add_time INT 11 0
is_attention TINYINT 1 0

ecs_comment

name type length default comment
comment_id INT 10
comment_type TINYINT 3 0
id_value MEDIUMINT 8 0
email VARCHAR 60
user_name VARCHAR 60
content TEXT
comment_rank TINYINT 1 0
add_time INT 10 0
ip_address VARCHAR 15
status TINYINT 3 0
parent_id INT 10 0
user_id INT 10 0

ecs_crons

name type length default comment
cron_id TINYINT 3
cron_code VARCHAR 20
cron_name VARCHAR 120
cron_desc TEXT
cron_order TINYINT 3 0
cron_config TEXT
thistime INT 10 0
nextime INT 10
day TINYINT 2
week VARCHAR 1
hour VARCHAR 2
minute VARCHAR 255
enable TINYINT 1 1
run_once TINYINT 1 0
allow_ip VARCHAR 100
alow_files VARCHAR 255

ecs_delivery_goods

name type length default comment
rec_id MEDIUMINT 8
delivery_id MEDIUMINT 8 0
goods_id MEDIUMINT 8 0
product_id MEDIUMINT 8 0
product_sn VARCHAR 60 NULL
goods_name VARCHAR 120 NULL
brand_name VARCHAR 60 NULL
goods_sn VARCHAR 60 NULL
is_real TINYINT 1 0
extension_code VARCHAR 30 NULL
parent_id MEDIUMINT 8 0
send_number SMALLINT 5 0
goods_attr TEXT

ecs_delivery_order

name type length default comment
delivery_id MEDIUMINT 8
delivery_sn VARCHAR 20
order_sn VARCHAR 20
order_id MEDIUMINT 8 0
invoice_no VARCHAR 50 NULL
add_time INT 10 0
shipping_id TINYINT 3 0
shipping_name VARCHAR 120 NULL
user_id MEDIUMINT 8 0
action_user VARCHAR 30 NULL
consignee VARCHAR 60 NULL
address VARCHAR 250 NULL
country SMALLINT 5 0
province SMALLINT 5 0
city SMALLINT 5 0
district SMALLINT 5 0
sign_building VARCHAR 120 NULL
email VARCHAR 60 NULL
zipcode VARCHAR 60 NULL
tel VARCHAR 60 NULL
mobile VARCHAR 60 NULL
best_time VARCHAR 120 NULL
postscript VARCHAR 255 NULL
how_oos VARCHAR 120 NULL
insure_fee DECIMAL 10,2 0.00
shipping_fee DECIMAL 10,2 0.00
update_time INT 10 0
suppliers_id SMALLINT 5 0
status TINYINT 1 0
agency_id SMALLINT 5 0

ecs_email_list

name type length default comment
id MEDIUMINT 8
email VARCHAR 60
stat TINYINT 1 0
hash VARCHAR 10

ecs_email_sendlist

name type length default comment
id MEDIUMINT 8
email VARCHAR 100
template_id MEDIUMINT 8
email_content TEXT
error TINYINT 1 0
pri TINYINT 10
last_send INT 10

ecs_error_log

name type length default comment
id INT 10
info VARCHAR 255
file VARCHAR 100
time INT 10

ecs_exchange_goods

name type length default comment
goods_id MEDIUMINT 8 0
exchange_integral INT 10 0
is_exchange TINYINT 1 0
is_hot TINYINT 1 0

ecs_favourable_activity

name type length default comment
act_id SMALLINT 5
act_name VARCHAR 255
start_time INT 10
end_time INT 10
user_rank VARCHAR 255
act_range TINYINT 3
act_range_ext VARCHAR 255
min_amount DECIMAL 10,2
max_amount DECIMAL 10,2
act_type TINYINT 3
act_type_ext DECIMAL 10,2
gift TEXT
sort_order TINYINT 3 50
logo VARCHAR 255 活動代表圖

ecs_feedback

name type length default comment
msg_id MEDIUMINT 8
parent_id MEDIUMINT 8 0
user_id MEDIUMINT 8 0
user_name VARCHAR 60
user_email VARCHAR 60
msg_title VARCHAR 200
msg_type TINYINT 1 0
msg_status TINYINT 1 0
msg_content TEXT
msg_time INT 10 0
message_img VARCHAR 255 0
order_id INT 11 0
msg_area TINYINT 1 0

ecs_friend_link

name type length default comment
link_id SMALLINT 5
link_name VARCHAR 255
link_url VARCHAR 255
link_logo VARCHAR 255
show_order TINYINT 3 50

ecs_goods

name type length default comment
goods_id MEDIUMINT 8
cat_id SMALLINT 5 0
goods_sn VARCHAR 60
goods_name VARCHAR 120
goods_name_style VARCHAR 60 +
click_count INT 10 0
brand_id SMALLINT 5 0
provider_name VARCHAR 100
goods_number SMALLINT 5 0
goods_weight DECIMAL 10,3 0.000
market_price DECIMAL 10,2 0.00
shop_price DECIMAL 10,2 0.00
promote_price DECIMAL 10,2 0.00
promote_start_date INT 11 0
promote_end_date INT 11 0
sale_price DECIMAL 10,2 0.00
sale_start_date INT 11 0
sale_end_date INT 11 0
warn_number TINYINT 3 1
keywords VARCHAR 255
goods_brief VARCHAR 255
goods_desc TEXT
goods_thumb VARCHAR 255
goods_img VARCHAR 255
original_img VARCHAR 255
is_real TINYINT 3 1
extension_code VARCHAR 30
is_on_sale TINYINT 1 1
is_alone_sale TINYINT 1 1
is_shipping TINYINT 1 0
integral INT 10 0
add_time INT 10 0
sort_order SMALLINT 4 100
is_delete TINYINT 1 0
is_best TINYINT 1 0
is_new TINYINT 1 0
is_hot TINYINT 1 0
is_promote TINYINT 1 0
is_sale TINYINT 1 0
bonus_type_id TINYINT 3 0
last_update INT 10 0
goods_type SMALLINT 5 0
seller_note VARCHAR 255
give_integral INT 11 -1
rank_integral INT 11 -1
suppliers_id SMALLINT 5 NULL
is_check TINYINT 1 NULL
sales_volume INT 10 0
comments_number INT 10 0
bb_chicun CHAR 28
mobile_desc TEXT
fencheng VARCHAR 255 NULL
sales_count INT 10 0
goods_shipai TEXT
sales_volume_base INT 10 0 銷量基數
buymax INT 10 0

ecs_goods_activity

name type length default comment
act_id MEDIUMINT 8
act_name VARCHAR 255
act_desc TEXT
act_type TINYINT 3
goods_id MEDIUMINT 8
product_id MEDIUMINT 8 0
goods_name VARCHAR 255
start_time INT 10
end_time INT 10
is_finished TINYINT 3
ext_info TEXT

ecs_goods_article

name type length default comment
goods_id MEDIUMINT 8 0
article_id MEDIUMINT 8 0
admin_id TINYINT 3 0

ecs_goods_attr

name type length default comment
goods_attr_id INT 10
goods_id MEDIUMINT 8 0
attr_id SMALLINT 5 0
attr_value TEXT
attr_price VARCHAR 255
attr_sort_order TINYINT 3 0
thumb_url VARCHAR 255
img_url VARCHAR 255
img_original VARCHAR 255
hex_color VARCHAR 255

ecs_goods_cat

name type length default comment
goods_id MEDIUMINT 8 0
cat_id SMALLINT 5 0

ecs_goods_gallery

name type length default comment
img_id MEDIUMINT 8
goods_id MEDIUMINT 8 0
img_url VARCHAR 255
img_desc VARCHAR 255
thumb_url VARCHAR 255
img_original VARCHAR 255

ecs_goods_type

name type length default comment
cat_id SMALLINT 5
cat_name VARCHAR 60
enabled TINYINT 1 1
attr_group VARCHAR 255

ecs_group_goods

name type length default comment
parent_id MEDIUMINT 8 0
goods_id MEDIUMINT 8 0
goods_price DECIMAL 10,2 0.00
admin_id TINYINT 3 0
group_id MEDIUMINT 8 0

ecs_ip_log

name type length default comment
id INT 20
ip VARCHAR 20 NULL
u_id INT 20 NULL
state INT 2 0
phone_state VARCHAR 255 NULL

ecs_keywords

name type length default comment
date DATE 0000-00-00
searchengine VARCHAR 20
keyword VARCHAR 90
count MEDIUMINT 8 0

ecs_link_goods

name type length default comment
goods_id MEDIUMINT 8 0
link_goods_id MEDIUMINT 8 0
is_double TINYINT 1 0
admin_id TINYINT 3 0

ecs_mail_templates

name type length default comment
template_id TINYINT 1
template_code VARCHAR 30
is_html TINYINT 1 0
template_subject VARCHAR 200
template_content TEXT
last_modify INT 10 0
last_send INT 10 0
type VARCHAR 10

ecs_member_price

name type length default comment
price_id MEDIUMINT 8
goods_id MEDIUMINT 8 0
user_rank TINYINT 3 0
user_price DECIMAL 10,2 0.00

ecs_nav

name type length default comment
id MEDIUMINT 8
ctype VARCHAR 10 NULL
cid SMALLINT 5 NULL
name VARCHAR 255
ifshow TINYINT 1
vieworder TINYINT 1
opennew TINYINT 1
url VARCHAR 255
type VARCHAR 10

ecs_order_action

name type length default comment
action_id MEDIUMINT 8
order_id MEDIUMINT 8 0
action_user VARCHAR 30
order_status TINYINT 1 0
shipping_status TINYINT 1 0
pay_status TINYINT 1 0
action_place TINYINT 1 0
action_note VARCHAR 255
log_time INT 11 0

ecs_order_goods

name type length default comment
rec_id MEDIUMINT 8
order_id MEDIUMINT 8 0
goods_id MEDIUMINT 8 0
goods_name VARCHAR 120
goods_sn VARCHAR 60
product_id MEDIUMINT 8 0
goods_number SMALLINT 5 1
market_price DECIMAL 10,2 0.00
goods_price DECIMAL 10,2 0.00
goods_attr TEXT
send_number SMALLINT 5 0
is_real TINYINT 1 0
extension_code VARCHAR 30
parent_id MEDIUMINT 8 0
is_gift SMALLINT 5 0
goods_attr_id VARCHAR 255
is_back TINYINT 1 0

ecs_order_info

name type length default comment
order_id MEDIUMINT 8
order_sn VARCHAR 20
user_id MEDIUMINT 8 0
order_status TINYINT 1 0
shipping_status TINYINT 1 0
pay_status TINYINT 1 0
consignee VARCHAR 60
country SMALLINT 5 0
province SMALLINT 5 0
city SMALLINT 5 0
district SMALLINT 5 0
address VARCHAR 255
zipcode VARCHAR 60
tel VARCHAR 60
mobile VARCHAR 60
email VARCHAR 60
best_time VARCHAR 120
sign_building VARCHAR 120
postscript VARCHAR 255
shipping_id TINYINT 3 0
shipping_name VARCHAR 120
pay_id TINYINT 3 0
pay_name VARCHAR 120
how_oos VARCHAR 120
how_surplus VARCHAR 120
pack_name VARCHAR 120
card_name VARCHAR 120
card_message VARCHAR 255
inv_payee VARCHAR 120
inv_content VARCHAR 120
goods_amount DECIMAL 10,2 0.00
shipping_fee DECIMAL 10,2 0.00
insure_fee DECIMAL 10,2 0.00
pay_fee DECIMAL 10,2 0.00
pack_fee DECIMAL 10,2 0.00
card_fee DECIMAL 10,2 0.00
money_paid DECIMAL 10,2 0.00
surplus DECIMAL 10,2 0.00
integral INT 10 0
integral_money DECIMAL 10,2 0.00
bonus DECIMAL 10,2 0.00
order_amount DECIMAL 10,2 0.00
from_ad SMALLINT 5 0
referer VARCHAR 255
add_time INT 10 0
confirm_time INT 10 0
pay_time INT 10 0
shipping_time INT 10 0
pack_id TINYINT 3 0
card_id TINYINT 3 0
bonus_id MEDIUMINT 8 0
invoice_no VARCHAR 255
extension_code VARCHAR 30
extension_id MEDIUMINT 8 0
to_buyer VARCHAR 255
pay_note VARCHAR 255
agency_id SMALLINT 5
inv_type VARCHAR 60
tax DECIMAL 10,2
is_separate TINYINT 1 0
parent_id MEDIUMINT 8 0
discount DECIMAL 10,2
fencheng VARCHAR 255 NULL
shipping_time_end INT 10 0

ecs_pack

name type length default comment
pack_id TINYINT 3
pack_name VARCHAR 120
pack_img VARCHAR 255
pack_fee DECIMAL 6,2 0.00
free_money SMALLINT 5 0
pack_desc VARCHAR 255

ecs_package_goods

name type length default comment
package_id MEDIUMINT 8 0
goods_id MEDIUMINT 8 0
product_id MEDIUMINT 8 0
goods_number SMALLINT 5 1
admin_id TINYINT 3 0

ecs_pay_log

name type length default comment
log_id INT 10
order_id MEDIUMINT 8 0
order_amount DECIMAL 10,2
order_type TINYINT 1 0
is_paid TINYINT 1 0
user_account_id INT 10

ecs_payment

name type length default comment
pay_id TINYINT 3
pay_code VARCHAR 20
pay_name VARCHAR 120
pay_fee VARCHAR 10 0
pay_desc TEXT
pay_order TINYINT 3 0
pay_config TEXT
enabled TINYINT 1 0
is_cod TINYINT 1 0
is_online TINYINT 1 0

ecs_plugins

name type length default comment
code VARCHAR 30
version VARCHAR 10
library VARCHAR 255
assign TINYINT 1 0
install_date INT 10 0

ecs_products

name type length default comment
product_id MEDIUMINT 8
goods_id MEDIUMINT 8 0
goods_attr VARCHAR 50 NULL
product_sn VARCHAR 60 NULL
product_number SMALLINT 5 0
is_check INT 1

ecs_reg_extend_info

name type length default comment
Id INT 10
user_id MEDIUMINT 8
reg_field_id INT 10
content TEXT

ecs_reg_fields

name type length default comment
id TINYINT 3
reg_field_name VARCHAR 60
dis_order TINYINT 3 100
display TINYINT 1 1
type TINYINT 1 0
is_need TINYINT 1 1

ecs_region

name type length default comment
region_id SMALLINT 5
parent_id SMALLINT 5 0
region_name VARCHAR 120
region_type TINYINT 1 2
agency_id SMALLINT 5 0

ecs_role

name type length default comment
role_id SMALLINT 5
role_name VARCHAR 60
action_list TEXT
role_describe TEXT

ecs_searchengine

name type length default comment
date DATE 0000-00-00
searchengine VARCHAR 20
count MEDIUMINT 8 0

ecs_sessions

name type length default comment
sesskey CHAR 32
expiry INT 10 0
userid MEDIUMINT 8 0
adminid MEDIUMINT 8 0
ip CHAR 15
user_name VARCHAR 60
user_rank TINYINT 3
discount DECIMAL 3,2
email VARCHAR 60
data CHAR 255

ecs_sessions_data

name type length default comment
sesskey VARCHAR 32
expiry INT 10 0
data LONGTEXT

ecs_shipping

name type length default comment
shipping_id TINYINT 3
shipping_code VARCHAR 20
shipping_name VARCHAR 120
shipping_desc VARCHAR 255
insure VARCHAR 10 0
support_cod TINYINT 1 0
enabled TINYINT 1 0
shipping_print TEXT
print_bg VARCHAR 255 NULL
config_lable TEXT
print_model TINYINT 1 0
shipping_order TINYINT 3 0

ecs_shipping_area

name type length default comment
shipping_area_id SMALLINT 5
shipping_area_name VARCHAR 150
shipping_id TINYINT 3 0
configure TEXT

ecs_shop_config

name type length default comment
id SMALLINT 5
parent_id SMALLINT 5 0
code VARCHAR 30
type VARCHAR 10
store_range VARCHAR 255
store_dir VARCHAR 255
value TEXT
sort_order TINYINT 3 1

ecs_snatch_log

name type length default comment
log_id MEDIUMINT 8
snatch_id TINYINT 3 0
user_id MEDIUMINT 8 0
bid_price DECIMAL 10,2 0.00
bid_time INT 10 0

ecs_stats

name type length default comment
access_time INT 10 0
ip_address VARCHAR 15
visit_times SMALLINT 5 1
browser VARCHAR 60
os VARCHAR 20
language VARCHAR 20
area VARCHAR 30
referer_domain VARCHAR 100
referer_path VARCHAR 200
access_url VARCHAR 255

ecs_suppliers

name type length default comment
suppliers_id SMALLINT 5
suppliers_name VARCHAR 255 NULL
suppliers_desc MEDIUMTEXT
is_check TINYINT 1 1

ecs_tag

name type length default comment
tag_id MEDIUMINT 8
user_id MEDIUMINT 8 0
goods_id MEDIUMINT 8 0
tag_words VARCHAR 255

ecs_template

name type length default comment
filename VARCHAR 30
region VARCHAR 40
library VARCHAR 40
sort_order TINYINT 1 0
id SMALLINT 5 0
number TINYINT 1 5
type TINYINT 1 0
theme VARCHAR 60
remarks VARCHAR 30

ecs_topic

name type length default comment
topic_id INT 10
title VARCHAR 255
intro TEXT
start_time INT 11 0
end_time INT 10 0
data TEXT
template VARCHAR 255
css TEXT
topic_img VARCHAR 255 NULL
title_pic VARCHAR 255 NULL
base_style CHAR 6 NULL
htmls MEDIUMTEXT
keywords VARCHAR 255 NULL
description VARCHAR 255 NULL

ecs_touch_action

name type length default comment
action_id TINYINT 3
parent_id TINYINT 3 0
action_code VARCHAR 20
relevance VARCHAR 20

ecs_touch_ad

name type length default comment
ad_id SMALLINT 5
position_id SMALLINT 5 0
media_type TINYINT 3 0
ad_name VARCHAR 60
ad_link VARCHAR 255
ad_code TEXT
start_time INT 11 0
end_time INT 11 0
link_man VARCHAR 60
link_email VARCHAR 60
link_phone VARCHAR 60
click_count MEDIUMINT 8 0
enabled TINYINT 3 1

ecs_touch_ad_position

name type length default comment
position_id TINYINT 3
position_name VARCHAR 60
ad_width SMALLINT 5 0
ad_height SMALLINT 5 0
position_desc VARCHAR 255
position_style TEXT

ecs_touch_nav

name type length default comment
id MEDIUMINT 8
ctype VARCHAR 10 NULL
cid SMALLINT 5 NULL
name VARCHAR 255
ifshow TINYINT 1
vieworder TINYINT 1
opennew TINYINT 1
url VARCHAR 255
pic VARCHAR 255
type VARCHAR 10

ecs_touch_payment

name type length default comment
pay_id TINYINT 3
pay_code VARCHAR 20
pay_name VARCHAR 120
pay_fee VARCHAR 10 0
pay_desc TEXT
pay_order TINYINT 3 0
pay_config TEXT
enabled TINYINT 1 0
is_cod TINYINT 1 0
is_online TINYINT 1 0

ecs_touch_priv

name type length default comment
id INT 11
user_id INT 11
action_list TEXT

ecs_user_account

name type length default comment
id MEDIUMINT 8
user_id MEDIUMINT 8 0
admin_user VARCHAR 255
amount DECIMAL 10,2
add_time INT 10 0
paid_time INT 10 0
admin_note VARCHAR 255
user_note VARCHAR 255
process_type TINYINT 1 0
payment VARCHAR 90
is_paid TINYINT 1 0

ecs_user_address

name type length default comment
address_id MEDIUMINT 8
address_name VARCHAR 50
user_id MEDIUMINT 8 0
consignee VARCHAR 60
email VARCHAR 60
country SMALLINT 5 0
province SMALLINT 5 0
city SMALLINT 5 0
district SMALLINT 5 0
address VARCHAR 120
zipcode VARCHAR 60
tel VARCHAR 60
mobile VARCHAR 60
sign_building VARCHAR 120
best_time VARCHAR 120

ecs_user_bonus

name type length default comment
bonus_id MEDIUMINT 8
bonus_type_id TINYINT 3 0
bonus_sn BIGINT 20 0
user_id MEDIUMINT 8 0
used_time INT 10 0
order_id MEDIUMINT 8 0
emailed TINYINT 3 0

ecs_user_card

name type length default comment
id INT 20
user_id MEDIUMINT 8 0
ct_id INT 10 0
card_level VARCHAR 60
card_no VARCHAR 60
card_pass VARCHAR 60
card_status TINYINT 1 0
send_type VARCHAR 60
add_time INT 10 0
bind_time INT 10 0
user_money DECIMAL 10,2 0.00
pay_points INT 10 0
rank_points INT 10 0
true_name VARCHAR 60
address VARCHAR 255
mobile VARCHAR 60
email VARCHAR 60
sex VARCHAR 10
is_show INT 1 0
des VARCHAR 255

ecs_user_card_type

name type length default comment
ct_id INT 10
ct_name VARCHAR 60
des VARCHAR 255

ecs_user_feed

name type length default comment
feed_id MEDIUMINT 8
user_id MEDIUMINT 8 0
value_id MEDIUMINT 8 0
goods_id MEDIUMINT 8 0
feed_type TINYINT 1 0
is_feed TINYINT 1 0

ecs_user_rank

name type length default comment
rank_id TINYINT 3
rank_name VARCHAR 30
min_points INT 10 0
max_points INT 10 0
discount TINYINT 3 0
show_price TINYINT 1 1
special_rank TINYINT 1 0

ecs_users

name type length default comment
user_id MEDIUMINT 8
aite_id TEXT
email VARCHAR 60
user_name VARCHAR 60
password VARCHAR 32
question VARCHAR 255
answer VARCHAR 255
sex TINYINT 1 0
birthday DATE 0000-00-00
user_money DECIMAL 10,2 0.00
frozen_money DECIMAL 10,2 0.00
pay_points INT 10 0
rank_points INT 10 0
address_id MEDIUMINT 8 0
reg_time INT 10 0
last_login INT 11 0
last_time DATETIME 0000-00-00 00:00:00
last_ip VARCHAR 15
visit_count SMALLINT 5 0
user_rank TINYINT 3 0
is_special TINYINT 3 0
ec_salt VARCHAR 10 NULL
salt VARCHAR 10 0
parent_id MEDIUMINT 9 0
flag TINYINT 3 0
alias VARCHAR 60
msn VARCHAR 60
qq VARCHAR 20
office_phone VARCHAR 20
home_phone VARCHAR 20
mobile_phone VARCHAR 20
is_validated TINYINT 3 0
credit_line DECIMAL 10,2
passwd_question VARCHAR 50 NULL
passwd_answer VARCHAR 255 NULL
wxid CHAR 28
wxch_bd CHAR 2
nicheng VARCHAR 255 NULL
password_xkfla VARCHAR 40
headimg VARCHAR 255

ecs_users_auth

name type length default comment
id INT 10
user_id INT 10 0
user_name VARCHAR 60
identity_type VARCHAR 32
identifier VARCHAR 128
credential VARCHAR 128
verified TINYINT 1 0
add_time INT 10 0
update_time INT 10 0
type TINYINT 1 1 1=PC 或者 手機

ecs_verifycode

name type length default comment
id MEDIUMINT 8
mobile CHAR 12
getip CHAR 15
verifycode CHAR 6
dateline INT 10 0
reguid MEDIUMINT 8 0
regdateline INT 10 0
status TINYINT 1 1

ecs_virtual_card

name type length default comment
card_id MEDIUMINT 8
goods_id MEDIUMINT 8 0
card_sn VARCHAR 60
card_password VARCHAR 60
add_date INT 11 0
end_date INT 11 0
is_saled TINYINT 1 0
order_sn VARCHAR 20
crc32 VARCHAR 12 0

ecs_volume_price

name type length default comment
price_type TINYINT 1
goods_id MEDIUMINT 8
volume_number SMALLINT 5 0
volume_price DECIMAL 10,2 0.00

ecs_vote

name type length default comment
vote_id SMALLINT 5
vote_name VARCHAR 250
start_time INT 11 0
end_time INT 11 0
can_multi TINYINT 1 0
vote_count INT 10 0

ecs_vote_log

name type length default comment
log_id MEDIUMINT 8
vote_id SMALLINT 5 0
ip_address VARCHAR 15
vote_time INT 10 0

ecs_vote_option

name type length default comment
option_id SMALLINT 5
vote_id SMALLINT 5 0
option_name VARCHAR 250
option_count INT 8 0
option_order TINYINT 3 100

ecs_weixin_autoreg

name type length default comment
autoreg_id TINYINT 1
autoreg_rand TINYINT 1
autoreg_name VARCHAR 200
autoreg_content TEXT
state TINYINT 1
rank_id TINYINT 3 0

ecs_weixin_cfg

name type length default comment
cfg_id INT 3
cfg_name VARCHAR 64
cfg_value VARCHAR 255 NULL
autoload VARCHAR 20 yes

ecs_weixin_config

name type length default comment
id INT 1
token VARCHAR 100
appid CHAR 18
appsecret CHAR 32
access_token TEXT
dateline INT 10

ecs_weixin_coupon

name type length default comment
id TINYINT 1
type_id INT 5

ecs_weixin_keywords

name type length default comment
id INT 4
name VARCHAR 100
keyword VARCHAR 100
type TINYINT 1
contents TEXT
count INT 10
status TINYINT 1

ecs_weixin_keywords1

name type length default comment
id INT 4
name VARCHAR 100
keyword VARCHAR 100
type TINYINT 1
contents TEXT
count INT 10
status TINYINT 1
is_start INT 11 NULL

ecs_weixin_keywords_article

name type length default comment
kws_id MEDIUMINT 8 0
article_id MEDIUMINT 8 0

ecs_weixin_lang

name type length default comment
lang_id INT 4
lang_name VARCHAR 64
lang_value TEXT

ecs_weixin_login

name type length default comment
id INT 11
createtime INT 11
uid INT 11
token VARCHAR 200
ip VARCHAR 15
value INT 10

ecs_weixin_menu

name type length default comment
id INT 3
menu_type VARCHAR 6
level INT 1
name VARCHAR 30
value VARCHAR 250
aid INT 3

ecs_weixin_message

name type length default comment
id INT 9
wxid CHAR 28
w_message TEXT
message TEXT
belong INT 9
dateline INT 10

ecs_weixin_msg

name type length default comment
id INT 3
name VARCHAR 100
function VARCHAR 30
command TEXT

ecs_weixin_oauth

name type length default comment
oid INT 4
name VARCHAR 100
contents TEXT
count INT 10
status TINYINT 1

ecs_weixin_order

name type length default comment
id TINYINT 1
order_name VARCHAR 30
title VARCHAR 100
image VARCHAR 150
content TEXT
autoload VARCHAR 100

ecs_weixin_pay

name type length default comment
id INT 1
appid CHAR 18
paysignkey CHAR 128
partnerkey CHAR 32
appsecret CHAR 32
dateline INT 10

ecs_weixin_point

name type length default comment
point_id INT 3
point_name VARCHAR 64
point_value INT 3
point_num INT 3
autoload VARCHAR 20 yes

ecs_weixin_point_record

name type length default comment
pr_id INT 7
wxid CHAR 28
point_name VARCHAR 64
num INT 5
lasttime INT 10
datelinie INT 10

ecs_weixin_prize

name type length default comment
pid INT 4
title VARCHAR 100
fun VARCHAR 10
status TINYINT 1
num INT 2
count INT 8
loop INT 3
starttime INT 10
endtime INT 10
dateline INT 10
point INT 10 NULL

ecs_weixin_prize_append

name type length default comment
id INT 5
prize_id INT 4
prize_name VARCHAR 64
prize_value INT 8

ecs_weixin_prize_cnum

name type length default comment
pcid INT 5
paid INT 5
pid INT 4
prize_name VARCHAR 64
prize_value INT 8
user_count INT 8

ecs_weixin_prize_count

name type length default comment
cid INT 7
pid INT 5
wxid CHAR 28
num INT 5
count INT 5
lasttime INT 10
dateline INT 10

ecs_weixin_prize_register

name type length default comment
rid INT 8
pid INT 7
wxid CHAR 28
nickname VARCHAR 200
phone VARCHAR 12
name VARCHAR 100
dateline INT 10

ecs_weixin_prize_users

name type length default comment
id INT 7
wxid CHAR 28
fun VARCHAR 10
nickname VARCHAR 200
prize_id INT 5 NULL
prize_name VARCHAR 64 NULL
prize_sn VARCHAR 35
register TINYINT 1
status TINYINT 1 NULL
yn VARCHAR 3
dateline INT 10 NULL

ecs_weixin_qr

name type length default comment
qid INT 7
type VARCHAR 2
expire_seconds INT 4
action_name VARCHAR 30
scene_id INT 7
ticket VARCHAR 120
scene VARCHAR 200
qr_path VARCHAR 200
subscribe INT 8
scan INT 8
function VARCHAR 100
affiliate INT 8
endtime INT 10
dateline INT 10

ecs_weixin_qr_xkfla2015

name type length default comment
Id INT 11
qr_path VARCHAR 255 NULL
scene VARCHAR 255 NULL
scene_id INT 11 NULL
nickname VARCHAR 255 NULL

ecs_weixin_user

name type length default comment
uid INT 7
subscribe TINYINT 1
wxid CHAR 28
nickname VARCHAR 200
sex TINYINT 1
city VARCHAR 100
country VARCHAR 100
province VARCHAR 100
language VARCHAR 50
headimgurl VARCHAR 200
subscribe_time INT 10
localimgurl VARCHAR 200
setp SMALLINT 2
uname VARCHAR 50
coupon VARCHAR 30
affiliate INT 8
dateline INT 10

ecs_weixin_ver

name type length default comment
vid TINYINT 1
type VARCHAR 5
ver VARCHAR 8
dateline INT 10

ecs_wholesale

name type length default comment
act_id MEDIUMINT 8
goods_id MEDIUMINT 8
goods_name VARCHAR 255
rank_ids VARCHAR 255
prices TEXT
enabled TINYINT 3