Snapshot on 2022-08-02 00:17:57
Database: wxbot
ky_admin
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
group_id | int(10) | No | 1 | |
username | varchar(50) | No | ||
password | char(60) | No | ||
varchar(100) | No | |||
mobile | varchar(15) | No | ||
realname | varchar(20) | No | ||
ip | varchar(15) | No | ||
status | tinyint(1) | No | 1 | |
last_time | int(10) UNSIGNED | No | 0 | |
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 |
ky_admin_group
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | smallint(5) UNSIGNED | No | |
name | varchar(15) | No | ||
title | char(100) | No | ||
status | tinyint(1) | No | 1 | |
rules | text | No | ||
sort | tinyint(3) | No | 0 | |
pid | int(10) UNSIGNED | No | 0 | |
create_time | int(11) | No | 0 | |
remark | varchar(255) | No | ||
update_time | int(10) UNSIGNED | No | 0 |
ky_admin_rule
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
name | varchar(30) | No | ||
title | varchar(30) | No | ||
pid | int(10) UNSIGNED | No | 0 | |
icon | varchar(30) | No | ||
href | varchar(50) | No | ||
target | enum('_self','_blank') | No | '_self' | |
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
sort | int(6) UNSIGNED | No | 0 | |
type | tinyint(1) UNSIGNED | No | 1 |
ky_bot
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) | No | 1 | |
title | varchar(50) | No | ||
app_key | varchar(32) | No | ||
nickname | varchar(50) | No | ||
headimgurl | varchar(255) | No | ||
status | tinyint(1) | No | 1 | |
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
uuid | varchar(30) | No | ||
uin | varchar(32) | No | '0' | |
is_current | tinyint(1) UNSIGNED | No | 0 | |
login_time | int(10) UNSIGNED | No | 0 | |
protocol | varchar(20) | No | 'vlw' | |
url | varchar(200) | No | ||
alive | tinyint(1) UNSIGNED | No | 0 | |
free | tinyint(1) UNSIGNED | No | 1 |
ky_bot_groupmember
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
bot_id | int(10) UNSIGNED | No | 0 | |
group_id | int(10) UNSIGNED | No | 0 | |
wxid | varchar(100) | No | '0' | |
nickname | varchar(50) | No | ||
group_nickname | varchar(50) | No | ||
username | varchar(100) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 |
ky_bot_member
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
uin | varchar(32) | No | ||
alias | varchar(30) | No | ||
nickname | varchar(50) | No | ||
remark_name | varchar(50) | No | ||
username | varchar(100) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
type | varchar(10) | No | 'friend' | |
headimgurl | varchar(200) | No | ||
wxid | varchar(100) | No | ||
internal | tinyint(1) UNSIGNED | No | 1 |
ky_district
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
title | varchar(50) | No | ||
pid | int(10) UNSIGNED | No | 0 |
ky_emoji_code
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(11) | No | |
class | varchar(30) | No | ||
name | varchar(40) | No | ||
unified | varchar(20) | No | ||
docomo | varchar(20) | No | ||
kddi | varchar(20) | No | ||
softbank | varchar(20) | No | ||
varchar(20) | No | |||
softb_unicode | varchar(20) | No |
ky_forward
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) | No | ||
bot_id | int(10) UNSIGNED | No | 0 | |
group_id | int(10) UNSIGNED | No | 0 | |
officer | varchar(200) | No | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
status | tinyint(1) UNSIGNED | No | 1 | |
wxids | text | Yes |
ky_group_rule
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
wxids | text | Yes | ||
rule | varchar(20) | No | 'rm' | |
status | tinyint(1) UNSIGNED | No | 0 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
value | varchar(100) | No |
ky_hanzi_config
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
key | varchar(30) | No | ||
value | text | Yes | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
wxids | text | Yes |
ky_keyword
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) | No | ||
bot_id | int(10) UNSIGNED | No | 0 | |
keyword | varchar(50) | No | ||
media_type | varchar(20) | No | ||
media_id | int(10) | No | 0 | |
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
wxids | text | Yes | ||
sort | int(6) UNSIGNED | No | 0 | |
user_type | tinyint(1) UNSIGNED | No | 0 |
ky_media_file_1
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(255) | No | ||
location | varchar(20) | No | 'qiniu' |
ky_media_file_2
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(255) | No | ||
location | varchar(20) | No | 'qiniu' |
ky_media_file_3
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(255) | No | ||
location | varchar(20) | No | 'qiniu' |
ky_media_file_4
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(255) | No | ||
location | varchar(20) | No | 'qiniu' |
ky_media_file_5
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(255) | No | ||
location | varchar(20) | No | 'qiniu' |
ky_media_image_1
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | enum('bmp','jpg','jpeg','png','gif') | No | 'jpg' | |
location | varchar(50) | No |
ky_media_image_2
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | enum('bmp','jpg','jpeg','png','gif') | No | 'jpg' | |
location | varchar(50) | No |
ky_media_image_3
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | enum('bmp','jpg','jpeg','png','gif') | No | 'jpg' | |
location | varchar(50) | No |
ky_media_image_4
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | enum('bmp','jpg','jpeg','png','gif') | No | 'jpg' | |
location | varchar(50) | No |
ky_media_image_5
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | enum('bmp','jpg','jpeg','png','gif') | No | 'jpg' | |
location | varchar(50) | No |
ky_media_link_1
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
desc | varchar(255) | No | ||
url | varchar(200) | No | ||
image_url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 |
ky_media_link_2
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
desc | varchar(255) | No | ||
url | varchar(200) | No | ||
image_url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 |
ky_media_link_3
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
desc | varchar(255) | No | ||
url | varchar(200) | No | ||
image_url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 |
ky_media_link_4
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
desc | varchar(255) | No | ||
url | varchar(200) | No | ||
image_url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 |
ky_media_link_5
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
desc | varchar(255) | No | ||
url | varchar(200) | No | ||
image_url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 |
ky_media_text_1
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
title | varchar(30) | No | ||
content | text | No | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_media_text_2
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
title | varchar(30) | No | ||
content | text | No | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_media_text_3
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
title | varchar(30) | No | ||
content | text | No | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_media_text_4
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
title | varchar(30) | No | ||
content | text | No | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_media_text_5
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
title | varchar(30) | No | ||
content | text | No | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_media_video_1
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(8) | No |
ky_media_video_2
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(8) | No |
ky_media_video_3
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(8) | No |
ky_media_video_4
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(8) | No |
ky_media_video_5
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(11) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
url | varchar(200) | No | ||
create_time | int(10) | No | 0 | |
update_time | int(10) | No | 0 | |
size | int(10) UNSIGNED | No | 0 | |
ext | varchar(8) | No |
ky_reply
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) | No | ||
bot_id | int(10) UNSIGNED | No | 0 | |
event | varchar(10) | No | 'beadded' | |
media_type | varchar(20) | No | ||
media_id | int(10) | No | 0 | |
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
wxids | text | Yes | ||
sort | int(6) UNSIGNED | No | 0 | |
need_at | tinyint(1) UNSIGNED | No | 0 | |
handle_type | varchar(20) | No | 'msg' | |
msg_type | smallint(6) UNSIGNED | No | 1 |
ky_setting
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
name | varchar(30) | No | ||
title | varchar(30) | No | ||
value | text | Yes | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_task
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
title | varchar(100) | No | ||
wxids | text | Yes | ||
plan_time | int(10) UNSIGNED | No | 0 | |
complete_time | int(10) UNSIGNED | No | 0 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
status | tinyint(1) UNSIGNED | No | 1 | |
medias | text | Yes | ||
circle | tinyint(1) UNSIGNED | No | 1 | |
plan_hour | char(5) | No | '00:00' | |
atall | tinyint(1) UNSIGNED | No | 0 |
ky_tj_group
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
group_id | int(10) UNSIGNED | No | 0 | |
day | char(10) | No | '0000-00-00' | |
add_num | int(10) UNSIGNED | No | 1 | |
decr_num | int(10) UNSIGNED | No | 0 | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 |
ky_tpzs_channel
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
contact_name | varchar(30) | No | ||
contact_tel | varchar(15) | No | ||
ckid | varchar(20) | No | ||
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_tpzs_config
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
key | varchar(30) | No | ||
value | text | Yes | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_tpzs_gather
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) | No | ||
bot_id | int(10) UNSIGNED | No | 0 | |
group_id | int(10) UNSIGNED | No | 0 | |
officer | varchar(200) | No | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
status | tinyint(1) UNSIGNED | No | 1 | |
wxids | text | Yes | ||
universal | tinyint(1) UNSIGNED | No | 1 |
ky_tpzs_grouppos
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
bot_id | int(10) UNSIGNED | No | 0 | |
group_id | int(10) UNSIGNED | No | 0 | |
position_id | int(10) UNSIGNED | No | 0 | |
channel_id | int(10) UNSIGNED | No | 0 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_tpzs_position
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(11) UNSIGNED | No | |
title | varchar(100) | No | ||
union_id | int(10) UNSIGNED | No | 0 | |
position_id | varchar(64) | No | ||
type | tinyint(1) UNSIGNED | No | 1 | |
admin_id | int(11) UNSIGNED | No | 0 | |
create_time | int(11) UNSIGNED | No | 0 | |
update_time | int(11) UNSIGNED | No | 0 | |
status | tinyint(1) UNSIGNED | No | 1 | |
jd_type | tinyint(1) UNSIGNED | No | 0 | |
siteid | varchar(200) | No | ||
default | tinyint(1) UNSIGNED | No | 0 | |
union_type | tinyint(1) UNSIGNED | No | 3 |
ky_tpzs_task
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
members | text | Yes | ||
sku_id | varchar(50) | No | ||
content | text | Yes | ||
img | varchar(200) | No | ||
plan_time | int(10) UNSIGNED | No | 0 | |
complete_time | int(10) UNSIGNED | No | 0 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
status | tinyint(1) UNSIGNED | No | 1 | |
type | varchar(20) | No | 'basic' | |
title | varchar(50) | No |
ky_tpzs_team
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
groups | text | Yes | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_tpzs_union
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(11) UNSIGNED | No | |
title | varchar(50) | No | ||
unionid | varchar(20) | No | ||
app_key | varchar(200) | No | ||
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(11) UNSIGNED | No | 0 | |
update_time | int(11) UNSIGNED | No | 0 | |
admin_id | int(11) UNSIGNED | No | 0 | |
default | tinyint(1) UNSIGNED | No | 0 | |
type | varchar(20) | No | 'jd' |
ky_whiteid
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
group_wxid | varchar(32) | No | ||
wxids | text | Yes | ||
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_yhq_code
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
coupon_id | int(10) UNSIGNED | No | 0 | |
code | varchar(50) | No | ||
code_url | varchar(200) | No | ||
wxid | varchar(64) | No | ||
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(10) UNSIGNED | No | ||
update_time | int(10) UNSIGNED | No | 0 | |
send_time | int(10) UNSIGNED | No | 0 |
ky_yhq_config
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
key | varchar(30) | No | ||
value | text | Yes | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |
ky_yhq_coupon
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
title | varchar(50) | No | ||
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(10) UNSIGNED | No | ||
update_time | int(10) UNSIGNED | No | 0 |
ky_yhq_reply
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) | No | ||
bot_id | int(10) UNSIGNED | No | 0 | |
event | varchar(10) | No | 'beadded' | |
content | text | No | ||
status | tinyint(1) UNSIGNED | No | 1 | |
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 | |
wxids | text | Yes | ||
sort | int(6) UNSIGNED | No | 0 | |
coupon_id | int(10) UNSIGNED | No | 0 |
ky_ai_config
Field | Type | Allow Null | Default Value | |
---|---|---|---|---|
P | id | int(10) UNSIGNED | No | |
admin_id | int(10) UNSIGNED | No | 0 | |
bot_id | int(10) UNSIGNED | No | 0 | |
key | varchar(30) | No | ||
value | text | Yes | ||
create_time | int(10) UNSIGNED | No | 0 | |
update_time | int(10) UNSIGNED | No | 0 |