CRMEB v4 標(biāo)準(zhǔn)版數(shù)據(jù)字典

數(shù)據(jù)字典

```[sql]

— Table structure for eb_agreement

DROP TABLE IF EXISTS?eb_agreement; CREATE TABLE?eb_agreement?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘協(xié)議類型 1：會(huì)員協(xié)議’, title?varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘協(xié)議名稱’, content?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘協(xié)議內(nèi)容’, sort?int(10) NOT NULL DEFAULT 0 COMMENT ‘排序倒序’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘1：顯示：0：不顯示’, add_time?int(50) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?type(type) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘會(huì)員協(xié)議’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_article

DROP TABLE IF EXISTS?eb_article; CREATE TABLE?eb_article?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘文章管理ID’, cid?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘1’ COMMENT ‘分類id’, title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘文章標(biāo)題’, author?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘文章作者’, image_input?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘文章圖片’, synopsis?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘文章簡介’, share_title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘文章分享標(biāo)題’, share_synopsis?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘文章分享簡介’, visit?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘0’ COMMENT ‘瀏覽次數(shù)’, sort?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘排序’, url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘原文鏈接’, status?tinyint(1) UNSIGNED NOT NULL COMMENT ‘狀態(tài)’, add_time?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘添加時(shí)間’, hide?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否隱藏’, admin_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘管理員id’, mer_id?int(10) UNSIGNED NULL DEFAULT 0 COMMENT ‘商戶id’, product_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘商品關(guān)聯(lián)id’, is_hot?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否熱門(小程序)’, is_banner?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否輪播圖(小程序)’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘文章管理表’ ROW_FORMAT = Dynamic;

— Table structure for eb_article_category

DROP TABLE IF EXISTS?eb_article_category; CREATE TABLE?eb_article_category?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘文章分類id’, pid?int(11) NOT NULL DEFAULT 0 COMMENT ‘父級(jí)ID’, title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘文章分類標(biāo)題’, intr?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘文章分類簡介’, image?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘文章分類圖片’, status?tinyint(1) UNSIGNED NOT NULL COMMENT ‘狀態(tài)’, sort?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘排序’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘1刪除0未刪除’, add_time?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘添加時(shí)間’, hidden?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否隱藏’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘文章分類表’ ROW_FORMAT = Dynamic;

— Table structure for eb_article_content

DROP TABLE IF EXISTS?eb_article_content; CREATE TABLE?eb_article_content?( nid?int(10) UNSIGNED NOT NULL COMMENT ‘文章id’, content?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘文章內(nèi)容’, UNIQUE INDEX?nid(nid) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘文章內(nèi)容表’ ROW_FORMAT = Dynamic;

— Table structure for eb_auxiliary

DROP TABLE IF EXISTS?eb_auxiliary; CREATE TABLE?eb_auxiliary?( id?int(10) NOT NULL AUTO_INCREMENT, binding_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘綁定id’, relation_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘關(guān)聯(lián)id’, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘類型0=客服轉(zhuǎn)接輔助，1=商品和分類輔助，2=優(yōu)惠券和商品輔助’, other?varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘其他數(shù)據(jù)為json’, update_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘更新時(shí)間’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘輔助表’ ROW_FORMAT = Dynamic;

— Table structure for eb_cache

DROP TABLE IF EXISTS?eb_cache; CREATE TABLE?eb_cache?( key?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, result?text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT ‘緩存數(shù)據(jù)’, expire_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘失效時(shí)間0=永久’, add_time?int(10) NULL DEFAULT NULL COMMENT ‘緩存時(shí)間’, PRIMARY KEY (key) USING BTREE, INDEX?key(key) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘微信緩存表’ ROW_FORMAT = Dynamic;

— Table structure for eb_category

DROP TABLE IF EXISTS?eb_category; CREATE TABLE?eb_category?( id?int(10) NOT NULL AUTO_INCREMENT, pid?int(10) NOT NULL DEFAULT 0 COMMENT ‘上級(jí)id’, owner_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘所屬人，為全部’, name?varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘分類名稱’, sort?int(10) NOT NULL DEFAULT 0 COMMENT ‘排序’, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘分類類型0=標(biāo)簽分類，1=快捷短語分類’, other?text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT ‘其他參數(shù)’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?pid(pid) USING BTREE, INDEX?name(name) USING BTREE, INDEX?is_be(owner_id,?type,?id) USING BTREE, INDEX?cate(owner_id,?type) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = ‘標(biāo)簽分類’ ROW_FORMAT = Dynamic;

— Table structure for eb_delivery_service

DROP TABLE IF EXISTS?eb_delivery_service; CREATE TABLE?eb_delivery_service?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘id’, uid?int(11) NOT NULL COMMENT ‘配送員uid’, avatar?varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘配送員頭像’, nickname?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘配送員名稱’, phone?varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘手機(jī)號(hào)碼’, add_time?int(11) NOT NULL COMMENT ‘添加時(shí)間’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘0隱藏1顯示’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘配送員表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_diy

DROP TABLE IF EXISTS?eb_diy; CREATE TABLE?eb_diy?( id?int(11) NOT NULL AUTO_INCREMENT, version?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘版本號(hào)’, name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘頁面名稱’, template_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’, value?longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT ‘頁面數(shù)據(jù)’, default_value?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, add_time?int(11) NULL DEFAULT NULL COMMENT ‘添加時(shí)間’, update_time?int(11) NULL DEFAULT NULL COMMENT ‘更新時(shí)間’, status?tinyint(1) NULL DEFAULT 0 COMMENT ‘是否使用’, type?tinyint(1) NULL DEFAULT NULL COMMENT ‘頁面類型’, is_del?tinyint(1) NULL DEFAULT 0 COMMENT ‘是否刪除’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘DIY數(shù)據(jù)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_express

DROP TABLE IF EXISTS?eb_express; CREATE TABLE?eb_express?( id?mediumint(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘快遞公司id’, code?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘快遞公司簡稱’, name?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘快遞公司全稱’, partner_id?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否需要月結(jié)賬號(hào)’, partner_key?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否需要月結(jié)密碼’, net?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否需要取件網(wǎng)店’, account?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘賬號(hào)’, key?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘密碼’, net_name?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘網(wǎng)點(diǎn)名稱’, sort?int(11) NOT NULL DEFAULT 0 COMMENT ‘排序’, is_show?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否顯示’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否可用’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?code(code) USING BTREE, INDEX?is_show(is_show) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘快遞公司表’ ROW_FORMAT = Dynamic;

— Table structure for eb_live_anchor

DROP TABLE IF EXISTS?eb_live_anchor; CREATE TABLE?eb_live_anchor?( id?int(10) NOT NULL AUTO_INCREMENT, name?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘主播名稱’, cover_img?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘主播圖像’, wechat?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘主播微信號(hào)’, phone?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘手機(jī)號(hào)’, is_show?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘是否顯示’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, add_time?int(10) NOT NULL DEFAULT 0, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— Table structure for eb_live_goods

DROP TABLE IF EXISTS?eb_live_goods; CREATE TABLE?eb_live_goods?( id?int(10) NOT NULL AUTO_INCREMENT, goods_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘微信商品ID’, audit_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘審核ID’, product_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘商品id’, name?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品名稱’, cover_img?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品圖片鏈接’, url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品小程序鏈接’, price_type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘價(jià)格類型（1:一口價(jià)，此時(shí)讀price字段; 2:價(jià)格區(qū)間，此時(shí)price字段為左邊界，price2字段為右邊界; 3:折扣價(jià)，此時(shí)price字段為原價(jià)，price2字段為現(xiàn)價(jià)；）’, cost_price?decimal(10, 2) NOT NULL DEFAULT 0.00, price?decimal(10, 2) NOT NULL DEFAULT 0.00, price2?decimal(10, 2) NOT NULL DEFAULT 0.00, audit_status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘審核狀態(tài)（0：未審核，1：審核中，2:審核通過，3審核失?。? third_part_tag?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘1、2：表示是為 API 添加商品，否則是直播控制臺(tái)添加的商品’, sort?smallint(5) NOT NULL DEFAULT 0, is_show?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘是否顯示’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— Table structure for eb_live_room

DROP TABLE IF EXISTS?eb_live_room; CREATE TABLE?eb_live_room?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT, room_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘直播間 id’, name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘直播間名字’, cover_img?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘背景圖’, share_img?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘分享圖’, start_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘直播計(jì)劃開始時(shí)間’, end_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘直播計(jì)劃結(jié)束時(shí)間’, anchor_name?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘主播昵稱’, anchor_wechat?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘主播微信號(hào)’, phone?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘主播手機(jī)號(hào)’, type?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘直播間類型 【1: 推流，0：手機(jī)直播】’, screen_type?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘橫屏、豎屏 【1：橫屏，0：豎屏】’, close_like?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否關(guān)閉點(diǎn)贊’, close_goods?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否關(guān)閉貨架’, close_comment?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否關(guān)閉評(píng)論’, error_msg?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘未通過原因’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘審核狀態(tài)0=未審核1=微信審核2=審核通過-1=審核未通過’, live_status?smallint(5) UNSIGNED NOT NULL DEFAULT 102 COMMENT ‘直播狀態(tài)101：直播中，102：未開始，103已結(jié)束，104禁播，105：暫停，106：異常，107：已過期’, mark?varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘備注’, replay_status?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘回放狀態(tài)’, sort?smallint(5) NOT NULL DEFAULT 0, is_show?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘是否顯示’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id,?phone) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘直播間表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_live_room_goods

DROP TABLE IF EXISTS?eb_live_room_goods; CREATE TABLE?eb_live_room_goods?( live_room_id?int(10) UNSIGNED NOT NULL, live_goods_id?int(10) UNSIGNED NOT NULL, INDEX?broadcast_room_id(live_room_id,?live_goods_id) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘直播間導(dǎo)入商品表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_member_card

DROP TABLE IF EXISTS?eb_member_card; CREATE TABLE?eb_member_card?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT, card_batch_id?int(11) UNSIGNED NOT NULL COMMENT ‘卡批次id’, card_number?varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘卡號(hào)’, card_password?char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ‘密碼’, use_uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘使用用戶’, use_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘使用時(shí)間’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘卡狀態(tài)：0：凍結(jié)；1：激活’, add_time?int(10) NOT NULL DEFAULT 0, update_time?int(10) NOT NULL DEFAULT 0, PRIMARY KEY (id,?card_batch_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘會(huì)員卡表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_member_card_batch

DROP TABLE IF EXISTS?eb_member_card_batch; CREATE TABLE?eb_member_card_batch?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT, title?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘批次名稱’, total_num?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘生成卡數(shù)量’, use_start_time?int(10) UNSIGNED NOT NULL DEFAULT 7 COMMENT ‘體驗(yàn)開始時(shí)間’, use_end_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘體驗(yàn)結(jié)束時(shí)間’, use_day?int(10) NOT NULL DEFAULT 0 COMMENT ‘體驗(yàn)天數(shù)’, use_num?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘使用’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否生效,控制此批次所有卡0：不生效；1：生效’, sort?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘排序’, qrcode?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘二維碼圖路徑’, remark?varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ‘備注’, add_time?int(10) NOT NULL DEFAULT 0, update_time?int(10) NOT NULL DEFAULT 0, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘會(huì)員卡批次表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_member_right

DROP TABLE IF EXISTS?eb_member_right; CREATE TABLE?eb_member_right?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT, right_type?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘權(quán)益類別’, title?varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘ 權(quán)益名稱’, show_title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘顯示權(quán)益名稱’, image?varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘權(quán)益圖標(biāo)’, explain?varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘權(quán)益介紹’, number?int(2) NOT NULL DEFAULT 1 COMMENT ‘規(guī)則數(shù)字’, sort?int(10) NOT NULL COMMENT ‘排序倒序’, status?tinyint(1) NOT NULL COMMENT ‘0:禁用，1：啟用’, add_time?int(50) NOT NULL COMMENT ‘添加時(shí)間’, PRIMARY KEY (id,?right_type) USING BTREE, INDEX?type(right_type) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘會(huì)員權(quán)益’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_member_ship

DROP TABLE IF EXISTS?eb_member_ship; CREATE TABLE?eb_member_ship?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT, type?varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘month’ COMMENT ‘會(huì)員類別month:月卡會(huì)員；quarter:季卡；year:年卡；ever:永久；free:免費(fèi)’, title?varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘會(huì)員名稱’, vip_day?int(10) NOT NULL COMMENT ‘會(huì)員時(shí)間(天)’, price?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘原價(jià)’, pre_price?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘優(yōu)惠后價(jià)格’, sort?int(10) NOT NULL COMMENT ‘排序倒序’, is_del?int(2) NOT NULL COMMENT ‘刪除’, add_time?int(50) NOT NULL COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?type(type) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘會(huì)員類型’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_other_order

DROP TABLE IF EXISTS?eb_other_order; CREATE TABLE?eb_other_order?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT, uid?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘用戶uid’, type?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘區(qū)別 \r\n0：免費(fèi)領(lǐng)取\r\n1：購買會(huì)員卡 \r\n2：卡密領(lǐng)取會(huì)員卡’, order_id?varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘訂單號(hào)’, member_type?varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘會(huì)員類型 \r\n月卡：month\r\n季卡：quarter\r\n年卡：year\r\n永久：ever\r\n免費(fèi)：free’, code?varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘卡號(hào)’, pay_type?varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘支付方式’, paid?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘支付狀態(tài) 0: 未支付 1：已支付’, pay_price?decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘支付金額’, member_price?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘會(huì)員卡價(jià)格’, pay_time?int(50) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘會(huì)員購買時(shí)間’, trade_no?varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘支付寶支付,支付寶交易訂單號(hào)’, channel_type?varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘支付渠道(微信公眾號(hào) h5 小程序)’, is_free?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否免費(fèi)’, is_permanent?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否永久’, overdue_time?int(50) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘會(huì)員過期時(shí)間’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘刪除’, vip_day?int(10) NOT NULL DEFAULT 0 COMMENT ‘會(huì)員有效天數(shù)’, add_time?int(50) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, money?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘原價(jià)格’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘會(huì)員購買記錄表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_other_order_status

DROP TABLE IF EXISTS?eb_other_order_status; CREATE TABLE?eb_other_order_status?( oid?int(10) UNSIGNED NOT NULL COMMENT ‘訂單id’, change_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘操作類型’, change_message?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘操作備注’, shop_type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘訂單類型 1：會(huì)員卡’, change_time?int(10) NOT NULL DEFAULT 0, INDEX?oid(oid) USING BTREE, INDEX?change_type(change_type) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘訂單操作記錄表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_qrcode

DROP TABLE IF EXISTS?eb_qrcode; CREATE TABLE?eb_qrcode?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘微信二維碼ID’, third_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘二維碼類型’, third_id?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘用戶id’, ticket?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘二維碼參數(shù)’, expire_seconds?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘二維碼有效時(shí)間’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘狀態(tài)’, add_time?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘添加時(shí)間’, url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘微信訪問url’, qrcode_url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘微信二維碼url’, scan?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘被掃的次數(shù)’, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘二維碼所屬平臺(tái)1=小程序，2=公眾號(hào)，3=H5’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?third_type(third_type,?third_id) USING BTREE, INDEX?ticket(ticket) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘微信二維碼管理表’ ROW_FORMAT = COMPACT;

— Table structure for eb_routine_access_token

DROP TABLE IF EXISTS?eb_routine_access_token; CREATE TABLE?eb_routine_access_token?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘小程序access_token表ID’, access_token?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘openid’, stop_time?int(11) UNSIGNED NOT NULL COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘小程序access_token表’ ROW_FORMAT = Dynamic;

— Table structure for eb_routine_form_id

DROP TABLE IF EXISTS?eb_routine_form_id; CREATE TABLE?eb_routine_form_id?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘表單ID表ID’, uid?int(11) NULL DEFAULT 0 COMMENT ‘用戶uid’, form_id?varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘表單ID’, stop_time?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘表單ID失效時(shí)間’, status?tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT ‘狀態(tài)1 未使用 2不能使用’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘表單id表記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_routine_qrcode

DROP TABLE IF EXISTS?eb_routine_qrcode; CREATE TABLE?eb_routine_qrcode?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘微信二維碼ID’, third_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘二維碼類型 spread(用戶推廣) product_spread(商品推廣)’, third_id?int(11) UNSIGNED NOT NULL COMMENT ‘用戶id’, status?tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT ‘狀態(tài) 0不可用 1可用’, add_time?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘添加時(shí)間’, page?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘小程序頁面路徑帶參數(shù)’, qrcode_url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘小程序二維碼路徑’, url_time?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘二維碼添加時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘小程序二維碼管理表’ ROW_FORMAT = Dynamic;

— Table structure for eb_shipping_templates

DROP TABLE IF EXISTS?eb_shipping_templates; CREATE TABLE?eb_shipping_templates?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘編號(hào)’, name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘模板名稱’, type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘計(jì)費(fèi)方式’, appoint?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘指定包郵’, sort?int(11) NOT NULL DEFAULT 0 COMMENT ‘排序’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘運(yùn)費(fèi)模板表’ ROW_FORMAT = Dynamic;

— Table structure for eb_shipping_templates_free

DROP TABLE IF EXISTS?eb_shipping_templates_free; CREATE TABLE?eb_shipping_templates_free?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘編號(hào)’, province_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘省ID’, temp_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘模板ID’, city_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘城市ID’, number?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘包郵件數(shù)’, price?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘包郵金額’, type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘計(jì)費(fèi)方式’, uniqid?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘分組唯一值’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘運(yùn)費(fèi)模板指定城市運(yùn)費(fèi)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_shipping_templates_region

DROP TABLE IF EXISTS?eb_shipping_templates_region; CREATE TABLE?eb_shipping_templates_region?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘編號(hào)’, province_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘省ID’, temp_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘模板ID’, city_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘城市ID’, first?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘首件’, first_price?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘首件運(yùn)費(fèi)’, continue?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘續(xù)件’, continue_price?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘續(xù)件運(yùn)費(fèi)’, type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘計(jì)費(fèi)方式’, uniqid?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘分組唯一值’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘運(yùn)費(fèi)模板指定包郵關(guān)聯(lián)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_sms_record

DROP TABLE IF EXISTS?eb_sms_record; CREATE TABLE?eb_sms_record?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘短信發(fā)送記錄編號(hào)’, uid?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘短信平臺(tái)賬號(hào)’, phone?char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘接受短信的手機(jī)號(hào)’, content?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘短信內(nèi)容’, add_time?int(11) UNSIGNED NOT NULL COMMENT ‘發(fā)送短信時(shí)間’, add_ip?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘添加記錄ip’, template?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘短信模板ID’, resultcode?int(6) UNSIGNED NULL DEFAULT NULL COMMENT ‘狀態(tài)碼 100=成功,130=失敗,131=空號(hào),132=停機(jī),133=關(guān)機(jī),134=無狀態(tài)’, record_id?int(11) UNSIGNED NOT NULL COMMENT ‘發(fā)送記錄id’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘短信發(fā)送記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_bargain

DROP TABLE IF EXISTS?eb_store_bargain; CREATE TABLE?eb_store_bargain?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘砍價(jià)商品ID’, product_id?int(11) UNSIGNED NOT NULL COMMENT ‘關(guān)聯(lián)商品ID’, title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘砍價(jià)活動(dòng)名稱’, image?varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘砍價(jià)活動(dòng)圖片’, unit_name?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘單位名稱’, stock?int(11) UNSIGNED NULL DEFAULT 0 COMMENT ‘庫存’, sales?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘銷量’, images?varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘砍價(jià)商品輪播圖’, start_time?int(11) UNSIGNED NOT NULL COMMENT ‘砍價(jià)開啟時(shí)間’, stop_time?int(11) UNSIGNED NOT NULL COMMENT ‘砍價(jià)結(jié)束時(shí)間’, store_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘砍價(jià)商品名稱’, price?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘砍價(jià)金額’, min_price?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘砍價(jià)商品最低價(jià)’, num?int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘可購買砍價(jià)商品數(shù)量’, bargain_max_price?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘用戶每次砍價(jià)的最大金額’, bargain_min_price?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘用戶每次砍價(jià)的最小金額’, bargain_num?int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘用戶幫砍的次數(shù)’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘砍價(jià)狀態(tài) 0(到砍價(jià)時(shí)間不自動(dòng)開啟) 1(到砍價(jià)時(shí)間自動(dòng)開啟時(shí)間)’, give_integral?decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘反多少積分’, info?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘砍價(jià)活動(dòng)簡介’, cost?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘成本價(jià)’, sort?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘排序’, is_hot?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否推薦0不推薦1推薦’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否刪除 0未刪除 1刪除’, add_time?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘添加時(shí)間’, is_postage?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘是否包郵 0不包郵 1包郵’, postage?decimal(10, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘郵費(fèi)’, rule?text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT ‘砍價(jià)規(guī)則’, look?int(11) UNSIGNED NULL DEFAULT 0 COMMENT ‘砍價(jià)商品瀏覽量’, share?int(11) UNSIGNED NULL DEFAULT 0 COMMENT ‘砍價(jià)商品分享量’, temp_id?int(11) NULL DEFAULT NULL COMMENT ‘運(yùn)費(fèi)模板ID’, weight?decimal(8, 2) NULL DEFAULT 0.00 COMMENT ‘重量’, volume?decimal(8, 2) NULL DEFAULT 0.00 COMMENT ‘體積’, quota?int(10) NOT NULL DEFAULT 0 COMMENT ‘限購總數(shù)’, quota_show?int(10) NOT NULL DEFAULT 0 COMMENT ‘限量總數(shù)顯示’, people_num?int(11) NOT NULL DEFAULT 1 COMMENT ‘用戶幫砍的次數(shù)’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘砍價(jià)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_bargain_user

DROP TABLE IF EXISTS?eb_store_bargain_user; CREATE TABLE?eb_store_bargain_user?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘用戶參與砍價(jià)表ID’, uid?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘用戶ID’, bargain_id?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘砍價(jià)商品id’, bargain_price_min?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘砍價(jià)的最低價(jià)’, bargain_price?decimal(8, 2) NULL DEFAULT NULL COMMENT ‘砍價(jià)金額’, price?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘砍掉的價(jià)格’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘狀態(tài) 1參與中 2 活動(dòng)結(jié)束參與失敗 3活動(dòng)結(jié)束參與成功’, add_time?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘參與時(shí)間’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否取消’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶參與砍價(jià)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_bargain_user_help

DROP TABLE IF EXISTS?eb_store_bargain_user_help; CREATE TABLE?eb_store_bargain_user_help?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘砍價(jià)用戶幫助表ID’, uid?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘幫助的用戶id’, bargain_id?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘砍價(jià)商品ID’, bargain_user_id?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘用戶參與砍價(jià)表id’, price?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘幫助砍價(jià)多少金額’, add_time?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘添加時(shí)間’, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否自己砍價(jià)’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘砍價(jià)用戶幫助表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_cart

DROP TABLE IF EXISTS?eb_store_cart; CREATE TABLE?eb_store_cart?( id?bigint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘購物車表ID’, uid?int(10) UNSIGNED NOT NULL COMMENT ‘用戶ID’, type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘類型’, product_id?int(10) UNSIGNED NOT NULL COMMENT ‘商品ID’, product_attr_unique?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品屬性’, cart_num?smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘商品數(shù)量’, add_time?int(10) UNSIGNED NOT NULL COMMENT ‘添加時(shí)間’, is_pay?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0 = 未購買 1 = 已購買’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, is_new?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否為立即購買’, combination_id?int(11) UNSIGNED NULL DEFAULT 0 COMMENT ‘拼團(tuán)id’, seckill_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘秒殺商品ID’, bargain_id?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘砍價(jià)id’, status?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘購物車商品狀態(tài)’, PRIMARY KEY (id) USING BTREE, INDEX?user_id(uid) USING BTREE, INDEX?goods_id(product_id) USING BTREE, INDEX?uid(uid,?is_pay) USING BTREE, INDEX?uid_2(uid,?is_del) USING BTREE, INDEX?uid_3(uid,?is_new) USING BTREE, INDEX?type(type) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘購物車表’ ROW_FORMAT = COMPACT;

— Table structure for eb_store_category

DROP TABLE IF EXISTS?eb_store_category; CREATE TABLE?eb_store_category?( id?mediumint(11) NOT NULL AUTO_INCREMENT COMMENT ‘商品分類表ID’, pid?mediumint(11) NOT NULL COMMENT ‘父id’, cate_name?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘分類名稱’, sort?mediumint(11) NOT NULL COMMENT ‘排序’, pic?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘圖標(biāo)’, is_show?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘是否推薦’, add_time?int(11) NOT NULL COMMENT ‘添加時(shí)間’, big_pic?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘分類大圖’, PRIMARY KEY (id) USING BTREE, INDEX?pid(pid) USING BTREE, INDEX?is_base(is_show) USING BTREE, INDEX?sort(sort) USING BTREE, INDEX?add_time(add_time) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品分類表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_combination

DROP TABLE IF EXISTS?eb_store_combination; CREATE TABLE?eb_store_combination?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT, product_id?int(10) UNSIGNED NOT NULL COMMENT ‘商品id’, mer_id?int(10) UNSIGNED NULL DEFAULT 0 COMMENT ‘商戶id’, image?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘推薦圖’, images?varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘輪播圖’, title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘活動(dòng)標(biāo)題’, attr?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘活動(dòng)屬性’, people?int(2) UNSIGNED NOT NULL COMMENT ‘參團(tuán)人數(shù)’, info?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘簡介’, price?decimal(10, 2) UNSIGNED NOT NULL COMMENT ‘價(jià)格’, sort?int(10) UNSIGNED NOT NULL COMMENT ‘排序’, sales?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘銷量’, stock?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘庫存’, add_time?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘添加時(shí)間’, is_host?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘推薦’, is_show?tinyint(1) UNSIGNED NOT NULL COMMENT ‘商品狀態(tài)’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0, combination?tinyint(1) UNSIGNED NOT NULL DEFAULT 1, mer_use?tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT ‘商戶是否可用1可用0不可用’, is_postage?tinyint(1) UNSIGNED NOT NULL COMMENT ‘是否包郵1是0否’, postage?decimal(10, 2) UNSIGNED NOT NULL COMMENT ‘郵費(fèi)’, start_time?int(11) UNSIGNED NOT NULL COMMENT ‘拼團(tuán)開始時(shí)間’, stop_time?int(11) UNSIGNED NOT NULL COMMENT ‘拼團(tuán)結(jié)束時(shí)間’, effective_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘拼團(tuán)訂單有效時(shí)間’, cost?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘拼圖商品成本’, browse?int(11) NULL DEFAULT 0 COMMENT ‘瀏覽量’, unit_name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘單位名’, temp_id?int(11) NULL DEFAULT NULL COMMENT ‘運(yùn)費(fèi)模板ID’, weight?decimal(8, 2) NULL DEFAULT 0.00 COMMENT ‘重量’, volume?decimal(8, 2) NULL DEFAULT 0.00 COMMENT ‘體積’, num?int(11) NULL DEFAULT NULL COMMENT ‘單次購買數(shù)量’, once_num?int(11) NOT NULL DEFAULT 0 COMMENT ‘每個(gè)訂單可購買數(shù)量’, quota?int(10) NOT NULL DEFAULT 0 COMMENT ‘限購總數(shù)’, quota_show?int(10) NOT NULL DEFAULT 0 COMMENT ‘限量總數(shù)顯示’, virtual?int(11) NOT NULL DEFAULT 100 COMMENT ‘虛擬成團(tuán)百分比’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘拼團(tuán)商品表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_coupon

DROP TABLE IF EXISTS?eb_store_coupon; CREATE TABLE?eb_store_coupon?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘優(yōu)惠券表ID’, title?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘優(yōu)惠券名稱’, integral?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘兌換消耗積分值’, coupon_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘兌換的優(yōu)惠券面值’, use_min_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘最低消費(fèi)多少金額可用優(yōu)惠券’, coupon_time?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠券有效期限（單位：天）’, sort?int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘排序’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘狀態(tài)（0：關(guān)閉，1：開啟）’, add_time?int(11) UNSIGNED NOT NULL COMMENT ‘兌換項(xiàng)目添加時(shí)間’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, product_id?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘所屬商品id’, category_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘分類id’, type?tinyint(2) NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠券類型 0-通用 1-品類券 2-商品券’, PRIMARY KEY (id) USING BTREE, INDEX?state(status) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?coupon_time(coupon_time) USING BTREE, INDEX?is_del(is_del) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘優(yōu)惠券表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_coupon_issue

DROP TABLE IF EXISTS?eb_store_coupon_issue; CREATE TABLE?eb_store_coupon_issue?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT, cid?int(10) NULL DEFAULT NULL COMMENT ‘優(yōu)惠券ID’, coupon_title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘優(yōu)惠券名稱’, start_time?int(10) NULL DEFAULT NULL COMMENT ‘優(yōu)惠券領(lǐng)取開啟時(shí)間’, end_time?int(10) NULL DEFAULT NULL COMMENT ‘優(yōu)惠券領(lǐng)取結(jié)束時(shí)間’, total_count?int(10) NULL DEFAULT NULL COMMENT ‘優(yōu)惠券領(lǐng)取數(shù)量’, remain_count?int(10) NULL DEFAULT NULL COMMENT ‘優(yōu)惠券剩余領(lǐng)取數(shù)量’, is_permanent?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否無限張數(shù)’, status?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘1 正常 0 未開啟 -1 已無效’, is_give_subscribe?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否首次關(guān)注贈(zèng)送 0-否(默認(rèn)) 1-是’, is_full_give?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否滿贈(zèng)0-否(默認(rèn)) 1-是’, full_reduction?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘消費(fèi)滿多少贈(zèng)送優(yōu)惠券’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0, add_time?int(10) NULL DEFAULT NULL COMMENT ‘優(yōu)惠券添加時(shí)間’, title?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘優(yōu)惠券名稱’, integral?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘兌換消耗積分值’, coupon_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘兌換的優(yōu)惠券面值’, use_min_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘最低消費(fèi)多少金額可用優(yōu)惠券’, coupon_time?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠券有效期限（單位：天）’, product_id?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘所屬商品id’, category_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘分類id’, type?tinyint(2) NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠券類型 0-通用 1-品類券 2-商品券’, receive_type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘1 手動(dòng)領(lǐng)取，2 新人券，3贈(zèng)送券，4會(huì)員券’, start_use_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠券使用開始時(shí)間’, end_use_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠券使用結(jié)束時(shí)間’, sort?int(11) NOT NULL DEFAULT 0 COMMENT ‘排序’, PRIMARY KEY (id) USING BTREE, INDEX?cid(cid) USING BTREE, INDEX?start_time(start_time,?end_time) USING BTREE, INDEX?remain_count(remain_count) USING BTREE, INDEX?status(status) USING BTREE, INDEX?coupon_time(coupon_time) USING BTREE, INDEX?is_del(is_del) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘優(yōu)惠券前臺(tái)領(lǐng)取表’ ROW_FORMAT = COMPACT;

— Table structure for eb_store_coupon_issue_user

DROP TABLE IF EXISTS?eb_store_coupon_issue_user; CREATE TABLE?eb_store_coupon_issue_user?( uid?int(10) NULL DEFAULT NULL COMMENT ‘領(lǐng)取優(yōu)惠券用戶ID’, issue_coupon_id?int(10) NULL DEFAULT NULL COMMENT ‘優(yōu)惠券前臺(tái)領(lǐng)取ID’, add_time?int(10) NULL DEFAULT NULL COMMENT ‘領(lǐng)取時(shí)間’, UNIQUE INDEX?uid(uid,?issue_coupon_id) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘優(yōu)惠券前臺(tái)用戶領(lǐng)取記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_coupon_product

DROP TABLE IF EXISTS?eb_store_coupon_product; CREATE TABLE?eb_store_coupon_product?( coupon_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠卷模板id’, product_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘商品id’, INDEX?coupon_id(coupon_id) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘優(yōu)惠卷模板關(guān)聯(lián)列表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_coupon_user

DROP TABLE IF EXISTS?eb_store_coupon_user; CREATE TABLE?eb_store_coupon_user?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘優(yōu)惠券發(fā)放記錄id’, cid?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘兌換的項(xiàng)目id’, uid?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠券所屬用戶’, coupon_title?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘優(yōu)惠券名稱’, coupon_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘優(yōu)惠券的面值’, use_min_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘最低消費(fèi)多少金額可用優(yōu)惠券’, add_time?int(11) UNSIGNED NOT NULL COMMENT ‘優(yōu)惠券創(chuàng)建時(shí)間’, start_time?int(11) NOT NULL DEFAULT 0, end_time?int(11) UNSIGNED NOT NULL COMMENT ‘優(yōu)惠券結(jié)束時(shí)間’, use_time?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘使用時(shí)間’, type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘send’ COMMENT ‘獲取方式’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘狀態(tài)（0：未使用，1：已使用, 2:已過期）’, is_fail?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否有效’, PRIMARY KEY (id) USING BTREE, INDEX?cid(cid) USING BTREE, INDEX?uid(uid) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?end_time(end_time) USING BTREE, INDEX?status(status) USING BTREE, INDEX?is_fail(is_fail) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘優(yōu)惠券發(fā)放記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_order

DROP TABLE IF EXISTS?eb_store_order; CREATE TABLE?eb_store_order?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘訂單ID’, order_id?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘訂單號(hào)’, trade_no?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘支付寶訂單號(hào)’, uid?int(11) UNSIGNED NOT NULL COMMENT ‘用戶id’, real_name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶姓名’, user_phone?varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶電話’, user_address?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘詳細(xì)地址’, cart_id?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘[]’ COMMENT ‘購物車id’, freight_price?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘運(yùn)費(fèi)金額’, total_num?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘訂單商品總數(shù)’, total_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘訂單總價(jià)’, total_postage?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘郵費(fèi)’, pay_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘實(shí)際支付金額’, pay_postage?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘支付郵費(fèi)’, deduction_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘抵扣金額’, coupon_id?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠券id’, coupon_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘優(yōu)惠券金額’, paid?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘支付狀態(tài)’, pay_time?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘支付時(shí)間’, pay_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘支付方式’, add_time?int(11) UNSIGNED NOT NULL COMMENT ‘創(chuàng)建時(shí)間’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘訂單狀態(tài)（-1 : 申請(qǐng)退款 -2 : 退貨成功 0：待發(fā)貨；1：待收貨；2：已收貨；3：待評(píng)價(jià)；-1：已退款）’, refund_status?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘0 未退款 1 申請(qǐng)中 2 已退款’, refund_reason_wap_img?varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘退款圖片’, refund_reason_wap_explain?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘退款用戶說明’, refund_reason_time?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘退款時(shí)間’, refund_reason_wap?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘前臺(tái)退款原因’, refund_reason?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘不退款的理由’, refund_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘退款金額’, delivery_name?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘快遞名稱/送貨人姓名’, delivery_code?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘快遞公司編碼’, delivery_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘發(fā)貨類型’, delivery_id?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘快遞單號(hào)/手機(jī)號(hào)’, fictitious_content?varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘虛擬發(fā)貨內(nèi)容’, delivery_uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘配送員id’, gain_integral?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘消費(fèi)賺取積分’, use_integral?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘使用積分’, back_integral?decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT ‘給用戶退了多少積分’, mark?varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘備注’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, unique?char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘唯一id(md5加密)類似id’, remark?varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘管理員備注’, mer_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘商戶ID’, is_mer_check?tinyint(3) UNSIGNED NOT NULL DEFAULT 0, combination_id?int(11) UNSIGNED NULL DEFAULT 0 COMMENT ‘拼團(tuán)商品id0一般商品’, pink_id?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘拼團(tuán)id 0沒有拼團(tuán)’, cost?decimal(8, 2) UNSIGNED NOT NULL COMMENT ‘成本價(jià)’, seckill_id?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘秒殺商品ID’, bargain_id?int(11) UNSIGNED NULL DEFAULT 0 COMMENT ‘砍價(jià)id’, verify_code?varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘核銷碼’, store_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘門店id’, shipping_type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘配送方式 1=快遞 ，2=門店自提’, clerk_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘店員id’, is_channel?tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT ‘支付渠道(0微信公眾號(hào)1微信小程序)’, is_remind?tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT ‘消息提醒’, is_system_del?tinyint(1) NULL DEFAULT 0 COMMENT ‘后臺(tái)是否刪除’, channel_type?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶訪問端標(biāo)識(shí)’, province?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶省份’, express_dump?varchar(502) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘訂單面單打印信息’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?order_id_2(order_id,?uid) USING BTREE, UNIQUE INDEX?unique(unique) USING BTREE, INDEX?uid(uid) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?pay_price(pay_price) USING BTREE, INDEX?paid(paid) USING BTREE, INDEX?pay_time(pay_time) USING BTREE, INDEX?pay_type(pay_type) USING BTREE, INDEX?status(status) USING BTREE, INDEX?is_del(is_del) USING BTREE, INDEX?coupon_id(coupon_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘訂單表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_order_cart_info

DROP TABLE IF EXISTS?eb_store_order_cart_info; CREATE TABLE?eb_store_order_cart_info?( oid?int(11) UNSIGNED NOT NULL COMMENT ‘訂單id’, cart_id?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘購物車id’, product_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘商品ID’, cart_info?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘購買東西的詳細(xì)信息’, unique?char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘唯一id’, UNIQUE INDEX?oid(oid,?unique) USING BTREE, INDEX?cart_id(cart_id) USING BTREE, INDEX?product_id(product_id) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘訂單購物詳情表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_order_economize

DROP TABLE IF EXISTS?eb_store_order_economize; CREATE TABLE?eb_store_order_economize?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘訂單ID’, order_id?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘訂單號(hào)’, uid?int(11) UNSIGNED NOT NULL COMMENT ‘用戶id’, order_type?tinyint(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 1 COMMENT ‘配送方式 1=商品訂單 ，2=線下訂單’, pay_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘實(shí)際支付金額’, postage_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘郵費(fèi)優(yōu)惠金額’, member_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘會(huì)員優(yōu)惠金額’, offline_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘線下優(yōu)惠金額’, coupon_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘優(yōu)惠券優(yōu)惠金額’, add_time?int(11) UNSIGNED NOT NULL COMMENT ‘創(chuàng)建時(shí)間’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘狀態(tài)’, PRIMARY KEY (id,?order_id,?uid) USING BTREE, UNIQUE INDEX?order_id_2(order_id,?uid) USING BTREE, INDEX?uid(uid) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?pay_price(pay_price) USING BTREE, INDEX?status(status) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶資金節(jié)省表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_order_invoice

DROP TABLE IF EXISTS?eb_store_order_invoice; CREATE TABLE?eb_store_order_invoice?( id?int(10) NOT NULL AUTO_INCREMENT, uid?int(10) NOT NULL DEFAULT 0 COMMENT ‘用戶uid’, category?varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘order’ COMMENT ‘開票分類 order:訂單’, order_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘訂單id’, invoice_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘發(fā)票id’, header_type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘抬頭類型’, type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘發(fā)票類型’, name?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘名稱（發(fā)票抬頭）’, duty_number?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘稅號(hào)’, drawer_phone?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘開票人手機(jī)號(hào)’, email?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘開票人郵箱’, tell?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘注冊(cè)電話’, address?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘注冊(cè)地址’, bank?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘開戶行’, card_number?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘銀行卡號(hào)’, is_pay?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否支付’, is_refund?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘訂單是否退款’, is_invoice?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否開票’, invoice_number?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘開票票號(hào)’, remark?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘備注’, invoice_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘開票時(shí)間’, add_time?int(10) NOT NULL DEFAULT 0, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— Table structure for eb_store_order_status

DROP TABLE IF EXISTS?eb_store_order_status; CREATE TABLE?eb_store_order_status?( oid?int(10) UNSIGNED NOT NULL COMMENT ‘訂單id’, change_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘操作類型’, change_message?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘操作備注’, change_time?int(10) UNSIGNED NOT NULL COMMENT ‘操作時(shí)間’, INDEX?oid(oid) USING BTREE, INDEX?change_type(change_type) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘訂單操作記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_pink

DROP TABLE IF EXISTS?eb_store_pink; CREATE TABLE?eb_store_pink?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT, uid?int(10) UNSIGNED NOT NULL COMMENT ‘用戶id’, nickname?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶昵稱’, avatar?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶頭像’, order_id?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘訂單id 生成’, order_id_key?int(10) UNSIGNED NOT NULL COMMENT ‘訂單id 數(shù)據(jù)庫’, total_num?int(10) UNSIGNED NOT NULL COMMENT ‘購買商品個(gè)數(shù)’, total_price?decimal(10, 2) UNSIGNED NOT NULL COMMENT ‘購買總金額’, cid?int(10) UNSIGNED NOT NULL COMMENT ‘拼團(tuán)商品id’, pid?int(10) UNSIGNED NOT NULL COMMENT ‘商品id’, people?int(10) UNSIGNED NOT NULL COMMENT ‘拼圖總?cè)藬?shù)’, price?decimal(10, 2) UNSIGNED NOT NULL COMMENT ‘拼團(tuán)商品單價(jià)’, add_time?varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘開始時(shí)間’, stop_time?varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, k_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘團(tuán)長id 0為團(tuán)長’, is_tpl?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否發(fā)送模板消息0未發(fā)送1已發(fā)送’, is_refund?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否退款 0未退款 1已退款’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘狀態(tài)1進(jìn)行中2已完成3未完成’, is_virtual?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否虛擬拼團(tuán)’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘拼團(tuán)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product

DROP TABLE IF EXISTS?eb_store_product; CREATE TABLE?eb_store_product?( id?mediumint(11) NOT NULL AUTO_INCREMENT COMMENT ‘商品id’, mer_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘商戶Id(0為總后臺(tái)管理員創(chuàng)建,不為0的時(shí)候是商戶后臺(tái)創(chuàng)建)’, image?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品圖片’, recommend_image?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘推薦圖’, slider_image?varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘輪播圖’, store_name?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品名稱’, store_info?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品簡介’, keyword?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘關(guān)鍵字’, bar_code?varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品條碼（一維碼）’, cate_id?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘分類id’, price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘商品價(jià)格’, vip_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘會(huì)員價(jià)格’, ot_price?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘市場價(jià)’, postage?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘郵費(fèi)’, unit_name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘單位名’, sort?smallint(11) NOT NULL DEFAULT 0 COMMENT ‘排序’, sales?mediumint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘銷量’, stock?mediumint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘庫存’, is_show?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘狀態(tài)（0：未上架，1：上架）’, is_hot?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否熱賣’, is_benefit?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否優(yōu)惠’, is_best?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否精品’, is_new?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否新品’, add_time?int(11) UNSIGNED NOT NULL COMMENT ‘添加時(shí)間’, is_postage?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否包郵’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, mer_use?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘商戶是否代理 0不可代理1可代理’, give_integral?decimal(8, 2) UNSIGNED NOT NULL COMMENT ‘獲得積分’, cost?decimal(8, 2) UNSIGNED NOT NULL COMMENT ‘成本價(jià)’, is_seckill?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘秒殺狀態(tài) 0 未開啟 1已開啟’, is_bargain?tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT ‘砍價(jià)狀態(tài) 0未開啟 1開啟’, is_good?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否優(yōu)品推薦’, is_sub?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否單獨(dú)分傭’, is_vip?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否開啟會(huì)員價(jià)格’, ficti?mediumint(11) NULL DEFAULT 100 COMMENT ‘虛擬銷量’, browse?int(11) NULL DEFAULT 0 COMMENT ‘瀏覽量’, code_path?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品二維碼地址(用戶小程序海報(bào))’, soure_link?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘’ COMMENT ‘淘寶京東1688類型’, video_link?varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘主圖視頻鏈接’, temp_id?int(11) NOT NULL DEFAULT 1 COMMENT ‘運(yùn)費(fèi)模板ID’, spec_type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘規(guī)格 0單 1多’, activity?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘活動(dòng)顯示排序1=秒殺，2=砍價(jià)，3=拼團(tuán)’, spu?char(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品SPU’, label_id?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘標(biāo)簽ID’, command_word?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘復(fù)制口令’, PRIMARY KEY (id) USING BTREE, INDEX?cate_id(cate_id) USING BTREE, INDEX?is_hot(is_hot) USING BTREE, INDEX?is_benefit(is_benefit) USING BTREE, INDEX?is_best(is_best) USING BTREE, INDEX?is_new(is_new) USING BTREE, INDEX?toggle_on_sale, is_del(is_del) USING BTREE, INDEX?price(price) USING BTREE, INDEX?is_show(is_show) USING BTREE, INDEX?sort(sort) USING BTREE, INDEX?sales(sales) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?is_postage(is_postage) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_attr

DROP TABLE IF EXISTS?eb_store_product_attr; CREATE TABLE?eb_store_product_attr?( id?int(10) NOT NULL AUTO_INCREMENT, product_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘商品ID’, attr_name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘屬性名’, attr_values?longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘屬性值’, type?tinyint(1) NULL DEFAULT 0 COMMENT ‘活動(dòng)類型 0=商品，1=秒殺，2=砍價(jià)，3=拼團(tuán)’, PRIMARY KEY (id) USING BTREE, INDEX?store_id(product_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品屬性表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_attr_result

DROP TABLE IF EXISTS?eb_store_product_attr_result; CREATE TABLE?eb_store_product_attr_result?( product_id?int(10) UNSIGNED NOT NULL COMMENT ‘商品ID’, result?longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品屬性參數(shù)’, change_time?int(10) UNSIGNED NOT NULL COMMENT ‘上次修改時(shí)間’, type?tinyint(1) NULL DEFAULT 0 COMMENT ‘活動(dòng)類型 0=商品，1=秒殺，2=砍價(jià)，3=拼團(tuán)’, INDEX?product_id(product_id) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品屬性詳情表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_attr_value

DROP TABLE IF EXISTS?eb_store_product_attr_value; CREATE TABLE?eb_store_product_attr_value?( product_id?int(10) UNSIGNED NOT NULL COMMENT ‘商品ID’, suk?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品屬性索引值 (attr_value|attr_value[|….])’, stock?int(10) UNSIGNED NOT NULL COMMENT ‘屬性對(duì)應(yīng)的庫存’, sales?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘銷量’, price?decimal(8, 2) UNSIGNED NOT NULL COMMENT ‘屬性金額’, image?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘圖片’, unique?char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘唯一值’, cost?decimal(8, 2) UNSIGNED NOT NULL COMMENT ‘成本價(jià)’, bar_code?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品條碼’, ot_price?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘原價(jià)’, vip_price?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘會(huì)員專享價(jià)’, weight?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘重量’, volume?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘體積’, brokerage?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘一級(jí)返傭’, brokerage_two?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘二級(jí)返傭’, type?tinyint(1) NULL DEFAULT 0 COMMENT ‘活動(dòng)類型 0=商品，1=秒殺，2=砍價(jià)，3=拼團(tuán)’, quota?int(11) NULL DEFAULT NULL COMMENT ‘活動(dòng)限購數(shù)量’, quota_show?int(11) NULL DEFAULT NULL COMMENT ‘活動(dòng)限購數(shù)量顯示’, INDEX?unique(unique,?suk) USING BTREE, INDEX?store_id(product_id,?suk) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品屬性值表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_cate

DROP TABLE IF EXISTS?eb_store_product_cate; CREATE TABLE?eb_store_product_cate?( id?int(11) NOT NULL AUTO_INCREMENT, product_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘商品id’, cate_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘分類id’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, cate_pid?int(11) NOT NULL DEFAULT 0 COMMENT ‘一級(jí)分類id’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘商品狀態(tài)’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品分類輔助表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_coupon

DROP TABLE IF EXISTS?eb_store_product_coupon; CREATE TABLE?eb_store_product_coupon?( id?int(10) NOT NULL AUTO_INCREMENT, product_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘商品id’, issue_coupon_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘優(yōu)惠劵id’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘優(yōu)惠券名稱’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_description

DROP TABLE IF EXISTS?eb_store_product_description; CREATE TABLE?eb_store_product_description?( product_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘商品ID’, description?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品詳情’, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘商品類型’, INDEX?product_id(product_id,?type) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品詳情表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_log

DROP TABLE IF EXISTS?eb_store_product_log; CREATE TABLE?eb_store_product_log?( id?int(11) NOT NULL AUTO_INCREMENT, type?enum(‘visit’,’cart’,’order’,’pay’,’collect’,’refund’) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘類型’, product_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘商品ID’, uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘用戶ID’, visit_num?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否瀏覽’, cart_num?int(11) NOT NULL DEFAULT 0 COMMENT ‘加入購物車數(shù)量’, order_num?int(11) NOT NULL DEFAULT 0 COMMENT ‘下單數(shù)量’, pay_num?int(11) NOT NULL DEFAULT 0 COMMENT ‘支付數(shù)量’, pay_price?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘支付金額’, cost_price?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘商品成本價(jià)’, pay_uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘支付用戶ID’, refund_num?int(11) NOT NULL DEFAULT 0 COMMENT ‘退款數(shù)量’, refund_price?decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT ‘退款金額’, collect_num?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘收藏’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品統(tǒng)計(jì)’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_relation

DROP TABLE IF EXISTS?eb_store_product_relation; CREATE TABLE?eb_store_product_relation?( uid?int(10) UNSIGNED NOT NULL COMMENT ‘用戶ID’, product_id?int(10) UNSIGNED NOT NULL COMMENT ‘商品ID’, type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘類型(收藏(collect）、點(diǎn)贊(like))’, category?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘某種類型的商品(普通商品、秒殺商品)’, add_time?int(10) UNSIGNED NOT NULL COMMENT ‘添加時(shí)間’, UNIQUE INDEX?uid(uid,?product_id,?type,?category) USING BTREE, INDEX?type(type) USING BTREE, INDEX?category(category) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品點(diǎn)贊和收藏表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_reply

DROP TABLE IF EXISTS?eb_store_product_reply; CREATE TABLE?eb_store_product_reply?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘評(píng)論ID’, uid?int(11) NOT NULL COMMENT ‘用戶ID’, oid?int(11) NOT NULL COMMENT ‘訂單ID’, unique?char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘唯一id’, product_id?int(11) NOT NULL COMMENT ‘商品id’, reply_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘product’ COMMENT ‘某種商品類型(普通商品、秒殺商品）’, product_score?tinyint(1) NOT NULL COMMENT ‘商品分?jǐn)?shù)’, service_score?tinyint(1) NOT NULL COMMENT ‘服務(wù)分?jǐn)?shù)’, comment?varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘評(píng)論內(nèi)容’, pics?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘評(píng)論圖片’, add_time?int(11) NOT NULL COMMENT ‘評(píng)論時(shí)間’, merchant_reply_content?varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘管理員回復(fù)內(nèi)容’, merchant_reply_time?int(11) NULL DEFAULT NULL COMMENT ‘管理員回復(fù)時(shí)間’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘0未刪除1已刪除’, is_reply?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0未回復(fù)1已回復(fù)’, nickname?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶名稱’, avatar?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶頭像’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?order_id_2(oid,?unique) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?parent_id(reply_type) USING BTREE, INDEX?is_del(is_del) USING BTREE, INDEX?product_score(product_score) USING BTREE, INDEX?service_score(service_score) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘評(píng)論表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_product_rule

DROP TABLE IF EXISTS?eb_store_product_rule; CREATE TABLE?eb_store_product_rule?( id?int(10) NOT NULL AUTO_INCREMENT, rule_name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘規(guī)格名稱’, rule_value?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘規(guī)格值’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品規(guī)則值(規(guī)格)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_seckill

DROP TABLE IF EXISTS?eb_store_seckill; CREATE TABLE?eb_store_seckill?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘商品秒殺商品表id’, product_id?int(10) UNSIGNED NOT NULL COMMENT ‘商品id’, image?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘推薦圖’, images?varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘輪播圖’, title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘活動(dòng)標(biāo)題’, info?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘簡介’, price?decimal(10, 2) UNSIGNED NOT NULL COMMENT ‘價(jià)格’, cost?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘成本’, ot_price?decimal(10, 2) UNSIGNED NOT NULL COMMENT ‘原價(jià)’, give_integral?decimal(10, 2) UNSIGNED NOT NULL COMMENT ‘返多少積分’, sort?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘排序’, stock?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘庫存’, sales?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘銷量’, unit_name?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘單位名’, postage?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘郵費(fèi)’, description?text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT ‘內(nèi)容’, start_time?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘開始時(shí)間’, stop_time?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘結(jié)束時(shí)間’, add_time?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘添加時(shí)間’, status?tinyint(1) UNSIGNED NOT NULL COMMENT ‘商品狀態(tài)’, is_postage?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否包郵’, is_hot?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘熱門推薦’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘刪除 0未刪除1已刪除’, num?int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘最多秒殺幾個(gè)’, is_show?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘顯示’, time_id?int(11) NULL DEFAULT NULL COMMENT ‘時(shí)間段ID’, temp_id?int(11) NULL DEFAULT NULL COMMENT ‘運(yùn)費(fèi)模板ID’, weight?decimal(8, 2) NULL DEFAULT 0.00 COMMENT ‘商品重量’, volume?decimal(8, 2) NULL DEFAULT 0.00 COMMENT ‘商品體積’, quota?int(10) NOT NULL DEFAULT 0 COMMENT ‘限購總數(shù)’, quota_show?int(10) NOT NULL DEFAULT 0 COMMENT ‘限購總數(shù)顯示’, once_num?int(11) NOT NULL DEFAULT 0 COMMENT ‘單次購買個(gè)數(shù)’, PRIMARY KEY (id) USING BTREE, INDEX?product_id(product_id) USING BTREE, INDEX?start_time(start_time,?stop_time) USING BTREE, INDEX?is_del(is_del) USING BTREE, INDEX?is_hot(is_hot) USING BTREE, INDEX?is_show(status) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?sort(sort) USING BTREE, INDEX?is_postage(is_postage) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品秒殺商品表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_seckill_time

DROP TABLE IF EXISTS?eb_store_seckill_time; CREATE TABLE?eb_store_seckill_time?( seckill_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘秒殺活動(dòng)ID’, time_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘秒殺時(shí)間段ID’ ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘秒殺時(shí)段表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_service

DROP TABLE IF EXISTS?eb_store_service; CREATE TABLE?eb_store_service?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘客服id’, mer_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘商戶id’, uid?int(11) NOT NULL COMMENT ‘客服uid’, online?tinyint(1) NOT NULL COMMENT ‘是否在線’, account?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘賬號(hào)’, password?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘密碼’, avatar?varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘客服頭像’, nickname?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘代理名稱’, phone?varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘客服電話’, add_time?int(11) NOT NULL COMMENT ‘添加時(shí)間’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘0隱藏1顯示’, notify?int(2) NULL DEFAULT 0 COMMENT ‘訂單通知1開啟0關(guān)閉’, customer?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否展示統(tǒng)計(jì)管理’, uniqid?varchar(35) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘客服表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_service_feedback

DROP TABLE IF EXISTS?eb_store_service_feedback; CREATE TABLE?eb_store_service_feedback?( id?int(11) NOT NULL AUTO_INCREMENT, uid?int(10) NOT NULL DEFAULT 0 COMMENT ‘用戶UID’, rela_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘姓名’, phone?varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘電話’, content?varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘反饋內(nèi)容’, make?varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘備注’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘狀態(tài)0=未查看，1=已查看’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?uid(uid) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = ‘反饋’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_service_log

DROP TABLE IF EXISTS?eb_store_service_log; CREATE TABLE?eb_store_service_log?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘客服用戶對(duì)話記錄表ID’, mer_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘商戶id’, msn?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘消息內(nèi)容’, uid?int(11) NOT NULL COMMENT ‘發(fā)送人uid’, to_uid?int(11) NOT NULL COMMENT ‘接收人uid’, is_tourist?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘1=游客模式，0=非游客’, time_node?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘時(shí)間節(jié)點(diǎn)’, add_time?int(11) NOT NULL COMMENT ‘發(fā)送時(shí)間’, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否已讀（0：否；1：是；）’, remind?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否提醒過’, msn_type?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘消息類型 1=文字 2=表情 3=圖片 4=語音’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘客服用戶對(duì)話記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_service_record

DROP TABLE IF EXISTS?eb_store_service_record; CREATE TABLE?eb_store_service_record?( id?int(10) NOT NULL AUTO_INCREMENT, user_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘發(fā)送人的uid’, to_uid?int(10) NOT NULL DEFAULT 0 COMMENT ‘送達(dá)人的uid’, nickname?varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶昵稱’, avatar?varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶頭像’, is_tourist?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否是游客’, online?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否在線’, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0 = pc,1=微信，2=小程序，3=H5’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, update_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘更新時(shí)間’, mssage_num?int(10) NOT NULL DEFAULT 0 COMMENT ‘消息條數(shù)’, message?text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT ‘內(nèi)容’, message_type?tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id) USING BTREE, INDEX?to_uid(to_uid) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = ‘客服聊天用戶記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_service_speechcraft

DROP TABLE IF EXISTS?eb_store_service_speechcraft; CREATE TABLE?eb_store_service_speechcraft?( id?int(11) NOT NULL AUTO_INCREMENT, kefu_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘0為全局話術(shù)’, cate_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘0為不分類全局話術(shù)’, title?varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘話術(shù)標(biāo)題’, message?varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘話術(shù)內(nèi)容’, sort?int(10) NOT NULL DEFAULT 0 COMMENT ‘排序’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?kefu_id(kefu_id) USING BTREE, INDEX?cate_id(cate_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = ‘客服話術(shù)’ ROW_FORMAT = Dynamic;

— Table structure for eb_store_visit

DROP TABLE IF EXISTS?eb_store_visit; CREATE TABLE?eb_store_visit?( id?int(10) NOT NULL AUTO_INCREMENT, product_id?int(11) NULL DEFAULT NULL COMMENT ‘商品ID’, product_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘商品類型’, cate_id?int(11) NULL DEFAULT NULL COMMENT ‘商品分類ID’, type?char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘商品類型’, uid?int(11) NULL DEFAULT NULL COMMENT ‘用戶ID’, count?int(11) NULL DEFAULT NULL COMMENT ‘訪問次數(shù)’, content?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘備注描述’, add_time?int(11) NULL DEFAULT NULL COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?product_id(product_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商品瀏覽分析表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_admin

DROP TABLE IF EXISTS?eb_system_admin; CREATE TABLE?eb_system_admin?( id?smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘后臺(tái)管理員表ID’, account?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘后臺(tái)管理員賬號(hào)’, head_pic?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’, pwd?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘后臺(tái)管理員密碼’, real_name?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘后臺(tái)管理員姓名’, roles?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘后臺(tái)管理員權(quán)限(menus_id)’, last_ip?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘后臺(tái)管理員最后一次登錄ip’, last_time?int(10) UNSIGNED NULL DEFAULT NULL COMMENT ‘后臺(tái)管理員最后一次登錄時(shí)間’, add_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘后臺(tái)管理員添加時(shí)間’, login_count?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘登錄次數(shù)’, level?tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘后臺(tái)管理員級(jí)別’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘后臺(tái)管理員狀態(tài) 1有效0無效’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (id) USING BTREE, INDEX?account(account) USING BTREE, INDEX?status(status) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘后臺(tái)管理員表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_attachment

DROP TABLE IF EXISTS?eb_system_attachment; CREATE TABLE?eb_system_attachment?( att_id?int(10) NOT NULL AUTO_INCREMENT, name?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘附件名稱’, att_dir?varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘附件路徑’, satt_dir?varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘壓縮圖片路徑’, att_size?char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘附件大小’, att_type?char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘附件類型’, pid?int(10) NOT NULL DEFAULT 0 COMMENT ‘分類ID0編輯器,1商品圖片,2拼團(tuán)圖片,3砍價(jià)圖片,4秒殺圖片,5文章圖片,6組合數(shù)據(jù)圖’, time?int(11) NOT NULL DEFAULT 0 COMMENT ‘上傳時(shí)間’, image_type?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘圖片上傳類型 1本地 2七牛云 3OSS 4COS ‘, module_type?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘圖片上傳模塊類型 1 后臺(tái)上傳 2 用戶生成’, real_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘原始文件名’, PRIMARY KEY (att_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘附件管理表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_attachment_category

DROP TABLE IF EXISTS?eb_system_attachment_category; CREATE TABLE?eb_system_attachment_category?( id?int(11) NOT NULL AUTO_INCREMENT, pid?int(11) NULL DEFAULT 0 COMMENT ‘父級(jí)ID’, name?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘分類名稱’, enname?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘分類目錄’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?id(id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘附件分類表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_city

DROP TABLE IF EXISTS?eb_system_city; CREATE TABLE?eb_system_city?( id?int(11) NOT NULL AUTO_INCREMENT, city_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘城市id’, level?int(11) NOT NULL DEFAULT 0 COMMENT ‘省市級(jí)別’, parent_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘父級(jí)id’, area_code?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘區(qū)號(hào)’, name?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘名稱’, merger_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘合并名稱’, lng?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘經(jīng)度’, lat?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘緯度’, is_show?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘是否展示’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘城市表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_config

DROP TABLE IF EXISTS?eb_system_config; CREATE TABLE?eb_system_config?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘配置id’, menu_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘字段名稱’, type?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘類型(文本框,單選按鈕…)’, input_type?varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘input’ COMMENT ‘表單類型’, config_tab_id?int(10) UNSIGNED NOT NULL COMMENT ‘配置分類id’, parameter?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘規(guī)則 單選框和多選框’, upload_type?tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT ‘上傳文件格式1單圖2多圖3文件’, required?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘規(guī)則’, width?int(10) UNSIGNED NULL DEFAULT NULL COMMENT ‘多行文本框的寬度’, high?int(10) UNSIGNED NULL DEFAULT NULL COMMENT ‘多行文框的高度’, value?varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘默認(rèn)值’, info?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘配置名稱’, desc?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘配置簡介’, sort?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘排序’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否隱藏’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘配置表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_config_tab

DROP TABLE IF EXISTS?eb_system_config_tab; CREATE TABLE?eb_system_config_tab?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘配置分類id’, pid?int(11) NOT NULL DEFAULT 0 COMMENT ‘上級(jí)分類id’, title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘配置分類名稱’, eng_title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘配置分類英文名稱’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘配置分類狀態(tài)’, info?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘配置分類是否顯示’, icon?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘圖標(biāo)’, type?int(2) NULL DEFAULT 0 COMMENT ‘配置類型’, sort?int(11) NOT NULL DEFAULT 0 COMMENT ‘排序’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘配置分類表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_file

DROP TABLE IF EXISTS?eb_system_file; CREATE TABLE?eb_system_file?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘文件對(duì)比ID’, cthash?char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘文件內(nèi)容’, filename?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘文價(jià)名稱’, atime?char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘上次訪問時(shí)間’, mtime?char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘上次修改時(shí)間’, ctime?char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘上次改變時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘文件對(duì)比表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_group

DROP TABLE IF EXISTS?eb_system_group; CREATE TABLE?eb_system_group?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘組合數(shù)據(jù)ID’, cate_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘分類id’, name?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘?dāng)?shù)據(jù)組名稱’, info?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘?dāng)?shù)據(jù)提示’, config_name?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘?dāng)?shù)據(jù)字段’, fields?text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT ‘?dāng)?shù)據(jù)組字段以及類型（json數(shù)據(jù)）’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?config_name(config_name) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘組合數(shù)據(jù)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_group_data

DROP TABLE IF EXISTS?eb_system_group_data; CREATE TABLE?eb_system_group_data?( id?int(11) NOT NULL AUTO_INCREMENT COMMENT ‘組合數(shù)據(jù)詳情ID’, gid?int(11) NOT NULL DEFAULT 0 COMMENT ‘對(duì)應(yīng)的數(shù)據(jù)組id’, value?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘?dāng)?shù)據(jù)組對(duì)應(yīng)的數(shù)據(jù)值（json數(shù)據(jù)）’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加數(shù)據(jù)時(shí)間’, sort?int(11) NOT NULL DEFAULT 0 COMMENT ‘?dāng)?shù)據(jù)排序’, status?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘狀態(tài)（1：開啟；2：關(guān)閉；）’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘組合數(shù)據(jù)詳情表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_log

DROP TABLE IF EXISTS?eb_system_log; CREATE TABLE?eb_system_log?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘管理員操作記錄ID’, admin_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘管理員id’, admin_name?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘管理員姓名’, path?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘鏈接’, page?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘行為’, method?varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘訪問類型’, ip?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘登錄IP’, type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘類型’, add_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘操作時(shí)間’, merchant_id?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘商戶id’, PRIMARY KEY (id) USING BTREE, INDEX?admin_id(admin_id) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?type(type) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘管理員操作記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_menus

DROP TABLE IF EXISTS?eb_system_menus; CREATE TABLE?eb_system_menus?( id?smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘菜單ID’, pid?smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘父級(jí)id’, icon?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘圖標(biāo)’, menu_name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘按鈕名’, module?varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘’ COMMENT ‘模塊名’, controller?varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT ‘控制器’, action?varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘’ COMMENT ‘方法名’, api_url?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘a(chǎn)pi接口地址’, methods?varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘提交方式POST GET PUT DELETE’, params?varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘[]’ COMMENT ‘參數(shù)’, sort?tinyint(3) NOT NULL DEFAULT 1 COMMENT ‘排序’, is_show?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘是否為隱藏菜單0=隱藏菜單,1=顯示菜單’, is_show_path?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否為隱藏菜單供前臺(tái)使用’, access?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘子管理員是否可用’, menu_path?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘路由名稱 前端使用’, auth_type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否為菜單 1菜單 2功能’, header?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘頂部菜單標(biāo)示’, is_header?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否頂部菜單1是0否’, unique_auth?varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘前臺(tái)唯一標(biāo)識(shí)’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, PRIMARY KEY (id) USING BTREE, INDEX?pid(pid) USING BTREE, INDEX?is_show(is_show) USING BTREE, INDEX?access(access) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘菜單表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_notice

DROP TABLE IF EXISTS?eb_system_notice; CREATE TABLE?eb_system_notice?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘通知模板id’, title?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘通知標(biāo)題’, type?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘通知類型’, icon?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘圖標(biāo)’, url?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘鏈接’, table_title?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘通知數(shù)據(jù)’, template?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘通知模板’, push_admin?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘通知管理員id’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘狀態(tài)’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?type(type) USING BTREE, INDEX?status(status) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘通知模板表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_notice_admin

DROP TABLE IF EXISTS?eb_system_notice_admin; CREATE TABLE?eb_system_notice_admin?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘通知記錄ID’, notice_type?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘通知類型’, admin_id?smallint(5) UNSIGNED NOT NULL COMMENT ‘通知的管理員’, link_id?int(10) UNSIGNED NOT NULL COMMENT ‘關(guān)聯(lián)ID’, table_data?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘通知的數(shù)據(jù)’, is_click?tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘點(diǎn)擊次數(shù)’, is_visit?tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘訪問次數(shù)’, visit_time?int(11) NOT NULL COMMENT ‘訪問時(shí)間’, add_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘通知時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?admin_id(admin_id,?notice_type) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?is_visit(is_visit) USING BTREE, INDEX?is_click(is_click) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘通知記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_role

DROP TABLE IF EXISTS?eb_system_role; CREATE TABLE?eb_system_role?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘身份管理id’, role_name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘身份管理名稱’, rules?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘身份管理權(quán)限(menus_id)’, level?tinyint(3) UNSIGNED NOT NULL DEFAULT 0, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘狀態(tài)’, PRIMARY KEY (id) USING BTREE, INDEX?status(status) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘身份管理表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_store

DROP TABLE IF EXISTS?eb_system_store; CREATE TABLE?eb_system_store?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT, name?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘門店名稱’, introduction?varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘簡介’, phone?char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘手機(jī)號(hào)碼’, address?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘省市區(qū)’, detailed_address?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘詳細(xì)地址’, image?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘門店logo’, latitude?char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘緯度’, longitude?char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘經(jīng)度’, valid_time?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘核銷有效日期’, day_time?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘每日營業(yè)開關(guān)時(shí)間’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, is_show?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否顯示’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, PRIMARY KEY (id) USING BTREE, INDEX?phone(phone) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘門店自提’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_store_staff

DROP TABLE IF EXISTS?eb_system_store_staff; CREATE TABLE?eb_system_store_staff?( id?int(11) UNSIGNED NOT NULL AUTO_INCREMENT, uid?int(10) UNSIGNED NOT NULL COMMENT ‘微信用戶id’, avatar?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘店員頭像’, store_id?int(11) NOT NULL COMMENT ‘門店id’, staff_name?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘’ COMMENT ‘店員名稱’, phone?char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘手機(jī)號(hào)碼’, verify_status?tinyint(2) NOT NULL DEFAULT 0 COMMENT ‘核銷開關(guān)’, status?tinyint(2) NULL DEFAULT 1 COMMENT ‘狀態(tài)’, add_time?int(10) NULL DEFAULT NULL COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘門店店員表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_user_level

DROP TABLE IF EXISTS?eb_system_user_level; CREATE TABLE?eb_system_user_level?( id?int(11) NOT NULL AUTO_INCREMENT, mer_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘商戶id’, name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘會(huì)員名稱’, money?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘購買金額’, valid_date?int(11) NOT NULL DEFAULT 0 COMMENT ‘有效時(shí)間’, is_forever?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否為永久會(huì)員’, is_pay?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否購買,1=購買,0=不購買’, is_show?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否顯示 1=顯示,0=隱藏’, grade?int(11) NOT NULL DEFAULT 0 COMMENT ‘會(huì)員等級(jí)’, discount?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘享受折扣’, image?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘會(huì)員卡背景’, icon?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘會(huì)員圖標(biāo)’, explain?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘說明’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否刪除.1=刪除,0=未刪除’, exp_num?int(10) NOT NULL DEFAULT 0 COMMENT ‘升級(jí)經(jīng)驗(yàn)’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘設(shè)置用戶等級(jí)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_system_user_task

DROP TABLE IF EXISTS?eb_system_user_task; CREATE TABLE?eb_system_user_task?( id?int(11) NOT NULL AUTO_INCREMENT, name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘任務(wù)名稱’, real_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘配置原名’, task_type?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘任務(wù)類型’, number?int(11) NOT NULL DEFAULT 0 COMMENT ‘限定數(shù)’, level_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘等級(jí)id’, sort?int(11) NOT NULL DEFAULT 0 COMMENT ‘排序’, is_show?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否顯示’, is_must?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否務(wù)必達(dá)成任務(wù),1務(wù)必達(dá)成,0=滿足其一’, illustrate?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘任務(wù)說明’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘新增時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘等級(jí)任務(wù)設(shè)置’ ROW_FORMAT = Dynamic;

— Table structure for eb_template_message

DROP TABLE IF EXISTS?eb_template_message; CREATE TABLE?eb_template_message?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘模板id’, type?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0=訂閱消息,1=微信模板消息’, tempkey?char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘模板編號(hào)’, name?char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘模板名’, kid?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’, content?varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘回復(fù)內(nèi)容’, tempid?char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘模板ID’, add_time?varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘添加時(shí)間’, status?tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘狀態(tài)’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘微信模板’ ROW_FORMAT = COMPACT;

— Table structure for eb_user

DROP TABLE IF EXISTS?eb_user; CREATE TABLE?eb_user?( uid?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘用戶id’, account?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶賬號(hào)’, pwd?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶密碼’, real_name?varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘真實(shí)姓名’, birthday?int(11) NOT NULL DEFAULT 0 COMMENT ‘生日’, card_id?varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘身份證號(hào)碼’, mark?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶備注’, partner_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘合伙人id’, group_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘用戶分組id’, nickname?varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶昵稱’, avatar?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶頭像’, phone?char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘手機(jī)號(hào)碼’, add_time?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, add_ip?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘添加ip’, last_time?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘最后一次登錄時(shí)間’, last_ip?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘最后一次登錄ip’, now_money?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘用戶余額’, brokerage_price?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘傭金金額’, integral?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘用戶剩余積分’, exp?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘會(huì)員經(jīng)驗(yàn)’, sign_num?int(11) NOT NULL DEFAULT 0 COMMENT ‘連續(xù)簽到天數(shù)’, status?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘1為正常，0為禁止’, level?tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘等級(jí)’, spread_uid?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘推廣元id’, spread_time?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘推廣員關(guān)聯(lián)時(shí)間’, user_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶類型’, is_promoter?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否為推廣員’, pay_count?int(11) UNSIGNED NULL DEFAULT 0 COMMENT ‘用戶購買次數(shù)’, spread_count?int(11) NULL DEFAULT 0 COMMENT ‘下級(jí)人數(shù)’, clean_time?int(11) NULL DEFAULT 0 COMMENT ‘清理會(huì)員時(shí)間’, addres?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘詳細(xì)地址’, adminid?int(11) UNSIGNED NULL DEFAULT 0 COMMENT ‘管理員編號(hào) ‘, login_type?varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶登陸類型，h5,wechat,routine’, record_phone?varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘記錄臨時(shí)電話’, is_money_level?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘會(huì)員來源 0: 購買商品升級(jí) 1：花錢購買的會(huì)員2: 會(huì)員卡領(lǐng)取’, is_ever_level?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否永久性會(huì)員 0: 非永久會(huì)員 1：永久會(huì)員’, overdue_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘會(huì)員到期時(shí)間’, uniqid?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’, PRIMARY KEY (uid) USING BTREE, INDEX?account(account) USING BTREE, INDEX?spreaduid(spread_uid) USING BTREE, INDEX?level(level) USING BTREE, INDEX?status(status) USING BTREE, INDEX?is_promoter(is_promoter) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_address

DROP TABLE IF EXISTS?eb_user_address; CREATE TABLE?eb_user_address?( id?mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘用戶地址id’, uid?int(10) UNSIGNED NOT NULL COMMENT ‘用戶id’, real_name?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收貨人姓名’, phone?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收貨人電話’, province?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收貨人所在省’, city?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收貨人所在市’, city_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘城市id’, district?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收貨人所在區(qū)’, detail?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收貨人詳細(xì)地址’, post_code?int(10) UNSIGNED NOT NULL COMMENT ‘郵編’, longitude?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘經(jīng)度’, latitude?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘緯度’, is_default?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否默認(rèn)’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, add_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?uid(uid) USING BTREE, INDEX?is_default(is_default) USING BTREE, INDEX?is_del(is_del) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶地址表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_bill

DROP TABLE IF EXISTS?eb_user_bill; CREATE TABLE?eb_user_bill?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘用戶賬單id’, uid?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘用戶uid’, link_id?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘關(guān)聯(lián)id’, pm?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘0 = 支出 1 = 獲得’, title?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘賬單標(biāo)題’, category?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘明細(xì)種類’, type?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘明細(xì)類型’, number?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘明細(xì)數(shù)字’, balance?decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT ‘剩余’, mark?varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘備注’, add_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, status?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘0 = 帶確定 1 = 有效 -1 = 無效’, take?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0 = 未收貨 1 = 已收貨’, PRIMARY KEY (id) USING BTREE, INDEX?openid(uid) USING BTREE, INDEX?status(status) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?pm(pm) USING BTREE, INDEX?type(category,?type,?link_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶賬單表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_brokerage_frozen

DROP TABLE IF EXISTS?eb_user_brokerage_frozen; CREATE TABLE?eb_user_brokerage_frozen?( id?int(10) NOT NULL AUTO_INCREMENT, uid?int(10) NOT NULL DEFAULT 0 COMMENT ‘用戶uid’, price?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘金額’, uill_id?int(10) NOT NULL DEFAULT 0 COMMENT ‘關(guān)聯(lián)id’, frozen_time?int(10) NOT NULL COMMENT ‘凍結(jié)到期時(shí)間’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否有效’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, order_id?varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘訂單id’, PRIMARY KEY (id) USING BTREE, INDEX?uid(uid,?status) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = ‘用戶傭金凍結(jié)記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_enter

DROP TABLE IF EXISTS?eb_user_enter; CREATE TABLE?eb_user_enter?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘商戶申請(qǐng)ID’, uid?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘用戶ID’, province?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商戶所在省’, city?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商戶所在市’, district?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商戶所在區(qū)’, address?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商戶詳細(xì)地址’, merchant_name?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商戶名稱’, link_user?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’, link_tel?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商戶電話’, charter?varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商戶證書’, add_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, apply_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘審核時(shí)間’, success_time?int(11) NOT NULL COMMENT ‘通過時(shí)間’, fail_message?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘未通過原因’, fail_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘未通過時(shí)間’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘-1 審核未通過 0未審核 1審核通過’, is_lock?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘0 = 開啟 1= 關(guān)閉’, is_del?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否刪除’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?uid(uid) USING BTREE, INDEX?province(province,?city,?district) USING BTREE, INDEX?is_lock(is_lock) USING BTREE, INDEX?is_del(is_del) USING BTREE, INDEX?status(status) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘商戶申請(qǐng)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_extract

DROP TABLE IF EXISTS?eb_user_extract; CREATE TABLE?eb_user_extract?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT, uid?int(10) UNSIGNED NULL DEFAULT NULL, real_name?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘名稱’, extract_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘bank’ COMMENT ‘bank = 銀行卡 alipay = 支付寶wx=微信’, bank_code?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘0’ COMMENT ‘銀行卡’, bank_address?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘’ COMMENT ‘開戶地址’, alipay_code?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘’ COMMENT ‘支付寶賬號(hào)’, extract_price?decimal(8, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT ‘提現(xiàn)金額’, mark?varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, balance?decimal(8, 2) UNSIGNED NULL DEFAULT 0.00, fail_msg?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘無效原因’, fail_time?int(10) UNSIGNED NULL DEFAULT NULL, add_time?int(10) UNSIGNED NULL DEFAULT NULL COMMENT ‘添加時(shí)間’, status?tinyint(2) NULL DEFAULT 0 COMMENT ‘-1 未通過 0 審核中 1 已提現(xiàn)’, wechat?varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘微信號(hào)’, qrcode_url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘二維碼地址’, PRIMARY KEY (id) USING BTREE, INDEX?extract_type(extract_type) USING BTREE, INDEX?status(status) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?openid(uid) USING BTREE, INDEX?fail_time(fail_time) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶提現(xiàn)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_friends

DROP TABLE IF EXISTS?eb_user_friends; CREATE TABLE?eb_user_friends?( id?int(10) NOT NULL AUTO_INCREMENT, uid?int(10) NOT NULL DEFAULT 0 COMMENT ‘用戶uid’, friends_uid?int(10) NOT NULL DEFAULT 0 COMMENT ‘好友uid’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?uid(uid) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = ‘用戶好友關(guān)系’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_group

DROP TABLE IF EXISTS?eb_user_group; CREATE TABLE?eb_user_group?( id?smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, group_name?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘用戶分組名稱’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶分組表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_invoice

DROP TABLE IF EXISTS?eb_user_invoice; CREATE TABLE?eb_user_invoice?( id?int(10) NOT NULL AUTO_INCREMENT, uid?int(10) NOT NULL DEFAULT 0, header_type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘抬頭類型1:個(gè)人2：企業(yè)’, type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘發(fā)票類型1：普通2：專用’, name?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘名稱（發(fā)票抬頭）’, duty_number?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘稅號(hào)’, drawer_phone?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘開票人手機(jī)號(hào)’, email?varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘開票人郵箱’, tell?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘注冊(cè)電話’, address?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘注冊(cè)地址’, bank?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘注冊(cè)開戶銀行’, card_number?varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘銀行卡號(hào)’, is_default?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否默認(rèn)’, is_del?tinyint(1) NOT NULL DEFAULT 0, add_time?int(10) NOT NULL DEFAULT 0, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶發(fā)票管理表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_user_label

DROP TABLE IF EXISTS?eb_user_label; CREATE TABLE?eb_user_label?( id?int(11) NOT NULL AUTO_INCREMENT, label_cate?int(10) NULL DEFAULT 0 COMMENT ‘標(biāo)簽分類’, label_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘標(biāo)簽名稱’, PRIMARY KEY (id) USING BTREE, INDEX?label_cate(label_cate) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶標(biāo)簽表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_label_relation

DROP TABLE IF EXISTS?eb_user_label_relation; CREATE TABLE?eb_user_label_relation?( uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘用戶ID’, label_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘標(biāo)簽ID’ ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶標(biāo)簽關(guān)聯(lián)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_level

DROP TABLE IF EXISTS?eb_user_level; CREATE TABLE?eb_user_level?( id?int(11) NOT NULL AUTO_INCREMENT, uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘用戶uid’, level_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘等級(jí)vip’, grade?int(11) NOT NULL DEFAULT 0 COMMENT ‘會(huì)員等級(jí)’, valid_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘過期時(shí)間’, is_forever?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否永久’, mer_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘商戶id’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘0:禁止,1:正常’, mark?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘備注’, remind?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否已通知’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否刪除,0=未刪除,1=刪除’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, discount?int(11) NOT NULL DEFAULT 0 COMMENT ‘享受折扣’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?id(id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶等級(jí)記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_notice

DROP TABLE IF EXISTS?eb_user_notice; CREATE TABLE?eb_user_notice?( id?int(11) NOT NULL AUTO_INCREMENT, uid?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘接收消息的用戶id（類型：json數(shù)據(jù)）’, type?tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘消息通知類型（1：系統(tǒng)消息；2：用戶通知）’, user?varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘發(fā)送人’, title?varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘通知消息的標(biāo)題信息’, content?varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘通知消息的內(nèi)容’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘通知消息發(fā)送的時(shí)間’, is_send?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否發(fā)送（0：未發(fā)送；1：已發(fā)送）’, send_time?int(11) NOT NULL COMMENT ‘發(fā)送時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶通知表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_notice_see

DROP TABLE IF EXISTS?eb_user_notice_see; CREATE TABLE?eb_user_notice_see?( id?int(11) NOT NULL AUTO_INCREMENT, nid?int(11) NOT NULL DEFAULT 0 COMMENT ‘查看的通知id’, uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘查看通知的用戶id’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘查看通知的時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶通知發(fā)送記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_recharge

DROP TABLE IF EXISTS?eb_user_recharge; CREATE TABLE?eb_user_recharge?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT, uid?int(10) NULL DEFAULT NULL COMMENT ‘充值用戶UID’, order_id?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘訂單號(hào)’, price?decimal(8, 2) NULL DEFAULT NULL COMMENT ‘充值金額’, give_price?decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT ‘購買贈(zèng)送金額’, recharge_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘充值類型’, paid?tinyint(1) NULL DEFAULT NULL COMMENT ‘是否充值’, pay_time?int(10) NULL DEFAULT NULL COMMENT ‘充值支付時(shí)間’, add_time?int(12) NULL DEFAULT NULL COMMENT ‘充值時(shí)間’, refund_price?decimal(10, 2) NULL DEFAULT 0.00 COMMENT ‘退款金額’, channel_type?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶訪問端標(biāo)識(shí)’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?order_id(order_id) USING BTREE, INDEX?uid(uid) USING BTREE, INDEX?recharge_type(recharge_type) USING BTREE, INDEX?paid(paid) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶充值表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_search

DROP TABLE IF EXISTS?eb_user_search; CREATE TABLE?eb_user_search?( id?int(10) NOT NULL AUTO_INCREMENT, uid?int(10) NOT NULL DEFAULT 0 COMMENT ‘用戶uid’, keyword?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘搜索關(guān)鍵詞’, num?int(8) NOT NULL DEFAULT 1 COMMENT ‘搜索次數(shù)’, result?text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT ‘搜索結(jié)果’, is_del?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘刪除’, add_time?int(10) NOT NULL DEFAULT 0 COMMENT ‘時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— Table structure for eb_user_sign

DROP TABLE IF EXISTS?eb_user_sign; CREATE TABLE?eb_user_sign?( id?int(11) NOT NULL AUTO_INCREMENT, uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘用戶uid’, title?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘簽到說明’, number?int(11) NOT NULL DEFAULT 0 COMMENT ‘獲得積分’, balance?int(11) NOT NULL DEFAULT 0 COMMENT ‘剩余積分’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?uid(uid) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘簽到記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_task_finish

DROP TABLE IF EXISTS?eb_user_task_finish; CREATE TABLE?eb_user_task_finish?( id?int(11) NOT NULL AUTO_INCREMENT, task_id?int(11) NOT NULL DEFAULT 0 COMMENT ‘任務(wù)id’, uid?int(11) NOT NULL DEFAULT 0 COMMENT ‘用戶id’, status?tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘是否有效’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?id(id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶任務(wù)完成記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_user_token

DROP TABLE IF EXISTS?eb_user_token; CREATE TABLE?eb_user_token?( id?int(11) NOT NULL AUTO_INCREMENT, uid?int(10) UNSIGNED NOT NULL COMMENT ‘用戶 id’, token?varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘token’, create_time?datetime(0) NOT NULL COMMENT ‘創(chuàng)建時(shí)間’, expires_time?datetime(0) NOT NULL COMMENT ‘到期事件’, login_ip?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘登錄ip’, PRIMARY KEY (id) USING BTREE, INDEX?uid(uid) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— Table structure for eb_user_visit

DROP TABLE IF EXISTS?eb_user_visit; CREATE TABLE?eb_user_visit?( id?int(11) NOT NULL AUTO_INCREMENT, uid?int(11) NOT NULL COMMENT ‘用戶uid’, url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘訪問路徑’, ip?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶ip’, stay_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘頁面停留時(shí)間(秒)’, add_time?int(11) NOT NULL DEFAULT 0 COMMENT ‘訪問時(shí)間’, channel_type?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶訪問端標(biāo)識(shí)’, province?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘’ COMMENT ‘用戶省份’, PRIMARY KEY (id) USING BTREE, INDEX?time(channel_type,?add_time) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶訪問表’ ROW_FORMAT = Dynamic;

— Table structure for eb_wechat_key

DROP TABLE IF EXISTS?eb_wechat_key; CREATE TABLE?eb_wechat_key?( id?mediumint(8) NOT NULL AUTO_INCREMENT, reply_id?mediumint(8) NOT NULL COMMENT ‘回復(fù)內(nèi)容id’, keys?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘關(guān)鍵詞’, PRIMARY KEY (id) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘微信回復(fù)關(guān)鍵詞輔助表’ ROW_FORMAT = DYNAMIC;

— Table structure for eb_wechat_media

DROP TABLE IF EXISTS?eb_wechat_media; CREATE TABLE?eb_wechat_media?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘微信視頻音頻id’, type?varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘回復(fù)類型’, path?varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘文件路徑’, media_id?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘微信服務(wù)器返回的id’, url?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘地址’, temporary?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否永久或者臨時(shí) 0永久1臨時(shí)’, add_time?int(10) UNSIGNED NOT NULL COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?type(type,?media_id) USING BTREE, INDEX?type_2(type) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘微信回復(fù)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_wechat_message

DROP TABLE IF EXISTS?eb_wechat_message; CREATE TABLE?eb_wechat_message?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘用戶行為記錄id’, openid?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用戶openid’, type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘操作類型’, result?varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘操作詳細(xì)記錄’, add_time?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘操作時(shí)間’, PRIMARY KEY (id) USING BTREE, INDEX?openid(openid) USING BTREE, INDEX?type(type) USING BTREE, INDEX?add_time(add_time) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘用戶行為記錄表’ ROW_FORMAT = Dynamic;

— Table structure for eb_wechat_news_category

DROP TABLE IF EXISTS?eb_wechat_news_category; CREATE TABLE?eb_wechat_news_category?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘圖文消息管理ID’, cate_name?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘圖文名稱’, sort?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘排序’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘狀態(tài)’, new_id?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘文章id’, add_time?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘添加時(shí)間’, PRIMARY KEY (id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘圖文消息管理表’ ROW_FORMAT = Dynamic;

— Table structure for eb_wechat_qrcode

DROP TABLE IF EXISTS?eb_wechat_qrcode; CREATE TABLE?eb_wechat_qrcode?( id?int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘微信二維碼ID’, third_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘二維碼類型’, third_id?int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘用戶id’, ticket?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘二維碼參數(shù)’, expire_seconds?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘二維碼有效時(shí)間’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘狀態(tài)’, add_time?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘0’ COMMENT ‘添加時(shí)間’, url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘微信訪問url’, qrcode_url?varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘微信二維碼url’, scan?int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘被掃的次數(shù)’, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?third_type(third_type,?third_id) USING BTREE, INDEX?ticket(ticket) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘微信二維碼管理表’ ROW_FORMAT = Dynamic;

— Table structure for eb_wechat_reply

DROP TABLE IF EXISTS?eb_wechat_reply; CREATE TABLE?eb_wechat_reply?( id?mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘微信關(guān)鍵字回復(fù)id’, type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘回復(fù)類型’, data?text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘回復(fù)數(shù)據(jù)’, status?tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT ‘0=不可用 1 =可用’, hide?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘是否隱藏’, PRIMARY KEY (id) USING BTREE, INDEX?type(type) USING BTREE, INDEX?status(status) USING BTREE, INDEX?hide(hide) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘微信關(guān)鍵字回復(fù)表’ ROW_FORMAT = Dynamic;

— Table structure for eb_wechat_user

DROP TABLE IF EXISTS?eb_wechat_user; CREATE TABLE?eb_wechat_user?( id?int(11) NOT NULL AUTO_INCREMENT, uid?int(10) UNSIGNED NOT NULL COMMENT ‘微信用戶id’, unionid?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘只有在用戶將公眾號(hào)綁定到微信開放平臺(tái)帳號(hào)后，才會(huì)出現(xiàn)該字段’, openid?varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘用戶的標(biāo)識(shí)，對(duì)當(dāng)前公眾號(hào)唯一’, nickname?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶的昵稱’, headimgurl?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶頭像’, sex?tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT ‘用戶的性別，值為1時(shí)是男性，值為2時(shí)是女性，值為0時(shí)是未知’, city?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶所在城市’, language?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶的語言，簡體中文為zh_CN’, province?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶所在省份’, country?varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘用戶所在國家’, remark?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘公眾號(hào)運(yùn)營者對(duì)粉絲的備注，公眾號(hào)運(yùn)營者可在微信公眾平臺(tái)用戶管理界面對(duì)粉絲添加備注’, groupid?smallint(5) UNSIGNED NULL DEFAULT 0 COMMENT ‘用戶所在的分組ID（兼容舊的用戶分組接口）’, tagid_list?varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘用戶被打上的標(biāo)簽ID列表’, subscribe?tinyint(3) UNSIGNED NULL DEFAULT 1 COMMENT ‘用戶是否訂閱該公眾號(hào)標(biāo)識(shí)’, subscribe_time?int(10) UNSIGNED NULL DEFAULT NULL COMMENT ‘關(guān)注公眾號(hào)時(shí)間’, add_time?int(10) UNSIGNED NULL DEFAULT NULL COMMENT ‘添加時(shí)間’, second?int(11) UNSIGNED NULL DEFAULT NULL COMMENT ‘二級(jí)推薦人’, user_type?varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘wechat’ COMMENT ‘用戶類型’, is_complete?tinyint(1) NULL DEFAULT 0, PRIMARY KEY (id) USING BTREE, UNIQUE INDEX?openid(openid) USING BTREE, INDEX?groupid(groupid) USING BTREE, INDEX?subscribe_time(subscribe_time) USING BTREE, INDEX?add_time(add_time) USING BTREE, INDEX?subscribe(subscribe) USING BTREE, INDEX?unionid(unionid) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ‘微信用戶表’ ROW_FORMAT = Dynamic;