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.
1816 lines
92 KiB
1816 lines
92 KiB
## 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 | | |
|
|
|