## 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      |         |         |

