数据库字典可以在后台管理界面查看最新结构：
| article | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| cat_id | smallint(5) | NO | 0 | |
| filename | varchar(32) | NO | ||
| defined | text | NO | ||
| title | varchar(150) | NO | ||
| keywords | varchar(255) | NO | ||
| description | varchar(255) | NO | ||
| content | longtext | YES | ||
| image | varchar(255) | NO | ||
| edit_time | int(10) | NO | 0 | |
| click | smallint(6) | NO | 0 | |
| sort | tinyint(1) | NO | 0 | |
| article_category | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| cat_id | int(11) | NO | auto_increment | |
| category | varchar(32) | NO | ||
| parent_id | smallint(5) | NO | 0 | |
| unique_id | varchar(30) | NO | ||
| cat_name | varchar(32) | NO | ||
| title | varchar(128) | YES | ||
| keywords | varchar(255) | NO | ||
| description | varchar(255) | NO | ||
| content | text | YES | ||
| sort | tinyint(1) | NO | 50 | |
| cart | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| user_id | int(11) | NO | 0 | |
| product_id | int(11) | NO | 0 | |
| numbers | int(11) | NO | 0 | |
| exts | varchar(5120) | NO | ||
| price | decimal(10,4) | NO | 0.0000 | |
| money | decimal(10,4) | NO | 0.0000 | |
| utime | int(11) | NO | 0 | |
| config | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| name | varchar(80) | NO | ||
| value | text | NO | ||
| type | varchar(10) | NO | ||
| tab | varchar(10) | NO | main | |
| box | varchar(255) | NO | ||
| sort | tinyint(3) | NO | 1 | |
| mailbox | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| mail_title | varchar(128) | NO | ||
| mail_body | text | NO | ||
| mail_from | varchar(64) | NO | ||
| mail_to | varchar(64) | NO | ||
| user_ip | varchar(16) | NO | 0.0.0.0 | |
| add_time | int(11) | NO | 0 | |
| send_time | int(11) | NO | 0 | |
| err_count | int(11) | NO | 0 | |
| sending | tinyint(1) | YES | 0 | |
| mail_subscribe | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| mail_to | varchar(64) | NO | ||
| user_ip | varchar(16) | NO | 0.0.0.0 | |
| add_time | int(11) | NO | 0 | |
| member_address | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| user_id | int(11) | NO | 0 | |
| username | varchar(32) | NO | ||
| line1 | varchar(64) | NO | ||
| line2 | varchar(64) | NO | ||
| city | varchar(64) | NO | ||
| state | varchar(64) | NO | ||
| phone | varchar(32) | NO | ||
| postalCode | varchar(32) | NO | ||
| countryCode | varchar(8) | NO | ||
| member_list | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| user_id | int(11) | NO | auto_increment | |
| varchar(32) | NO | |||
| username | varchar(32) | NO | ||
| phone | varchar(16) | NO | ||
| reg_time | int(11) | NO | 0 | |
| last_login | int(11) | NO | 0 | |
| login_count | int(11) | NO | 0 | |
| status | int(11) | NO | 0 | |
| member_msg | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| user_id | int(11) | NO | 0 | |
| title | varchar(64) | NO | ||
| content | text | YES | ||
| atime | int(11) | NO | 0 | |
| member_msg_reply | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| msg_id | int(11) | NO | 0 | |
| user_id | int(11) | NO | 0 | |
| content | text | YES | ||
| atime | int(11) | NO | 0 | |
| member_orders | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| orders_id | int(11) | NO | auto_increment | |
| user_id | int(11) | NO | 0 | |
| pay_type | varchar(16) | NO | ||
| pay_key | varchar(32) | NO | ||
| pay_time | int(11) | NO | 0 | |
| orders_money | decimal(13,4) | NO | 0.0000 | |
| pay_money | decimal(13,4) | NO | 0.0000 | |
| status | tinyint(1) | NO | 0 | |
| notes | varchar(128) | NO | ||
| atime | int(11) | NO | 0 | |
| address_id | int(11) | NO | 0 | |
| tracking_no | varchar(32) | YES | ||
| utime | int(11) | YES | 0 | |
| member_orders_goods | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| orders_id | int(11) | NO | 0 | |
| goods_id | int(11) | NO | 0 | |
| goods_name | varchar(64) | NO | ||
| goods_price | decimal(10,4) | NO | 0.0000 | |
| goods_weight | decimal(10,4) | NO | 0.0000 | |
| goods_num | int(11) | NO | 0 | |
| exts | varchar(5120) | YES | ||
| member_orders_invoice | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| orders_id | int(11) | NO | 0 | |
| orders_info | text | YES | ||
| atime | int(11) | NO | 0 | |
| member_orders_status | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| orders_id | int(11) | NO | 0 | |
| status | tinyint(1) | NO | 0 | |
| notes | varchar(128) | NO | ||
| atime | int(11) | NO | 0 | |
| nav | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| parent_id | smallint(5) | NO | 0 | |
| category | varchar(32) | NO | ||
| nav_name | varchar(255) | NO | ||
| nav_url | varchar(256) | NO | ||
| sort | tinyint(3) | NO | 0 | |
| page | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| category | varchar(32) | NO | ||
| filename | varchar(30) | NO | ||
| parent_id | smallint(5) | NO | 0 | |
| page_name | varchar(150) | NO | ||
| title | varchar(128) | YES | ||
| content | longtext | YES | ||
| keywords | varchar(255) | NO | ||
| description | varchar(255) | NO | ||
| sort | int(8) | NO | 0 | |
| product | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| cat_id | smallint(5) | NO | 0 | |
| filename | varchar(32) | NO | ||
| name | varchar(150) | NO | ||
| price | decimal(10,4) | NO | 0.0000 | |
| weight | decimal(10,4) | NO | 0.0000 | |
| defined | varchar(32) | YES | ||
| title | varchar(128) | YES | ||
| keywords | varchar(255) | NO | ||
| description | varchar(255) | NO | ||
| content | longtext | YES | ||
| image | varchar(5120) | NO | ||
| edit_time | int(10) | NO | 0 | |
| sort | tinyint(1) | NO | 0 | |
| ext1 | varchar(255) | NO | ||
| ext2 | varchar(255) | NO | ||
| ext3 | varchar(255) | NO | ||
| ext4 | varchar(255) | NO | ||
| ext5 | varchar(255) | NO | ||
| ext6 | varchar(255) | NO | ||
| ext7 | varchar(255) | NO | ||
| ext8 | varchar(255) | NO | ||
| ext9 | varchar(255) | NO | ||
| ext10 | varchar(255) | NO | ||
| ext11 | varchar(255) | NO | ||
| ext12 | varchar(255) | NO | ||
| ext13 | varchar(255) | NO | ||
| ext14 | varchar(255) | NO | ||
| ext15 | varchar(255) | NO | ||
| product_category | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| cat_id | int(11) | NO | auto_increment | |
| category | varchar(32) | NO | ||
| parent_id | smallint(5) | NO | 0 | |
| unique_id | varchar(30) | NO | ||
| cat_name | varchar(32) | NO | ||
| title | varchar(128) | YES | ||
| keywords | varchar(255) | NO | ||
| description | varchar(255) | NO | ||
| content | text | YES | ||
| sort | tinyint(1) | NO | 50 | |
| slide | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| name | varchar(60) | NO | ||
| url | varchar(255) | NO | ||
| img | varchar(255) | NO | ||
| category | varchar(32) | NO | ||
| sort | tinyint(1) | NO | 50 | |
| notes | varchar(1024) | YES | ||
| task_list | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| id | int(11) | NO | auto_increment | |
| task_url | varchar(128) | NO | ||
| add_time | int(11) | NO | 0 | |
| last_time | int(11) | NO | 0 | |
| status | tinyint(1) | YES | 0 | |
| cycle | int(11) | YES | 0 | |
| url_maps | ||||
|---|---|---|---|---|
| name | type | is_null | default | PK |
| url_new | varchar(128) | NO | ||
| url_sys | varchar(128) | NO | ||
| lavel | varchar(4) | NO | user | |