數據字典 · 遠傳禮品平臺API文檔

### 數據字典 ```sql /* Navicat MySQL Data Transfer Source Server : 127.0.0.1_3306 Source Server Version : 50714 Source Host : 127.0.0.1:3306 Source Database : lipin Target Server Type : MYSQL Target Server Version : 50714 File Encoding : 65001 Date: 2017-3-31 02:58:32 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `lipin_user` -- ---------------------------- DROP TABLE IF EXISTS `lipin_user`; CREATE TABLE `lipin_user` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用戶ID', `nickname` char(16) NOT NULL DEFAULT '' COMMENT '昵稱', `imei` varchar(250) NULL DEFAULT NULL COMMENT 'imei', `avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '頭像', `qq` char(10) NOT NULL DEFAULT '' COMMENT 'qq號', `password` char(40) NOT NULL DEFAULT '' COMMENT '用戶密碼', `salt` char(32) NOT NULL DEFAULT '' COMMENT '用于保護用戶密碼安全的鹽值', -- 這個用戶郵箱和手機是唯一的，但是有的人開始并沒有綁定郵箱或手機，所以也不能為空串，不然唯一沖突，所以只能允許為空null了，并且默認為null `email` char(32) NULL DEFAULT NULL COMMENT '用戶郵箱', `mobile` char(15) NULL DEFAULT NULL COMMENT '用戶手機', `score` mediumint(8) NOT NULL DEFAULT 0 COMMENT '用戶積分', `login` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '登錄次數', `create_ip` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '注冊IP', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '注冊時間', `last_login_ip` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '最后登錄IP', `last_login_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '最后登錄時間', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新時間', `status` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT '狀態', PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) USING BTREE, UNIQUE KEY `mobile` (`mobile`) USING BTREE, UNIQUE KEY `imei` (`imei`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用戶表'; -- ---------------------------- -- Records of lipin_user -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_products_library` -- ---------------------------- DROP TABLE IF EXISTS `lipin_products_library`; CREATE TABLE `lipin_products_library` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(250) NOT NULL DEFAULT '' COMMENT '產品名稱', `describe` longtext NULL COMMENT '產品描述/簡介', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '指導價格', `img` varchar(500) NOT NULL DEFAULT '' COMMENT 'img，產品大圖', `min_img` varchar(500) NOT NULL DEFAULT '' COMMENT 'min_img，產品圖標/小圖', `pic` text NULL COMMENT '產品相冊，使用,分割多圖', `video` varchar(500) NOT NULL DEFAULT '' COMMENT '產品介紹視頻', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新時間', `status` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT '狀態，0-停用，1-啟用', PRIMARY KEY (`id`), KEY `status` (`status`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='產品庫表'; -- ---------------------------- -- Records of lipin_products_library -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_video_qrcode` -- ---------------------------- DROP TABLE IF EXISTS `lipin_video_qrcode`; CREATE TABLE `lipin_video_qrcode` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `products_library_id` int(10) unsigned NOT NULL COMMENT '產品庫ID', `bind_user` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '綁定的用戶ID，表示哪個用戶為此產品添加小視屏', `bind_user_note` varchar(250) NOT NULL DEFAULT '綁定的用戶的備注' COMMENT '綁定的用戶的備注', `view_num` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '查看次數', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新時間', `bind_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '綁定時間', `active_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '活躍時間', `status` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT '狀態，0-停用，1-啟用', PRIMARY KEY (`id`), KEY `status` (`status`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='小視屏二維碼'; -- ---------------------------- -- Records of lipin_video_qrcode -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_track_qrcode` -- ---------------------------- DROP TABLE IF EXISTS `lipin_track_qrcode`; CREATE TABLE `lipin_track_qrcode` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `products_library_id` int(10) unsigned NOT NULL COMMENT '產品庫ID', `track_user` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '監控的用戶ID，表示哪個用戶監控此產品', `be_track_user` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '被監控的用戶，也就是只監控一個人', `track_user_note` varchar(250) NOT NULL DEFAULT '監控的用戶的備注' COMMENT '監控的用戶的備注', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新時間', `track_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '監控時間', `active_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '活躍時間', `status` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT '狀態，0-停用，1-啟用', PRIMARY KEY (`id`), KEY `status` (`status`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='監控/定位二維碼'; -- ---------------------------- -- Records of lipin_track_qrcode -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_mini_video` -- ---------------------------- DROP TABLE IF EXISTS `lipin_mini_video`; CREATE TABLE `lipin_mini_video` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `video_qrcode_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所屬視頻二維碼ID', `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用戶ID', -- 文本的要設置為允許為空，因為它不能設置默認值（實際上默認值就是NULL），如果插入數據時沒有值會報錯的（沒有值時就用缺省值，而缺省值就是默認值） `content` longtext NULL COMMENT 'content', `main_img` varchar(500) NOT NULL DEFAULT '' COMMENT '主圖，備用字段', `pic` text NULL COMMENT '相冊，使用,分割多圖', `video` varchar(500) NOT NULL DEFAULT '' COMMENT '視頻', `address` varchar(250) NOT NULL DEFAULT '' COMMENT '地址', `longitude` varchar(250) NOT NULL DEFAULT '' COMMENT '經度', `latitude` varchar(250) NOT NULL DEFAULT '' COMMENT '緯度', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='小視頻'; -- ---------------------------- -- Records of lipin_mini_video -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_track_record` -- ---------------------------- DROP TABLE IF EXISTS `lipin_track_record`; CREATE TABLE `lipin_track_record` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `track_qrcode_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '定位二維碼ID', `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '用戶ID', `longitude` varchar(250) NULL DEFAULT '' COMMENT '經度', `latitude` varchar(250) NULL DEFAULT '' COMMENT '緯度', `address` varchar(250) NOT NULL DEFAULT '' COMMENT '地址', `create_ip` bigint(20) unsigned NULL DEFAULT 0 COMMENT '請求IP', `create_time` int(10) unsigned NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NULL DEFAULT 0 COMMENT '更新時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='禮物跟蹤記錄表'; -- ---------------------------- -- Records of lipin_track_record -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_tag` -- ---------------------------- DROP TABLE IF EXISTS `lipin_tag`; CREATE TABLE `lipin_tag` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '所屬資料庫ID', `tagid` varchar(100) NOT NULL DEFAULT 0 COMMENT 'NFC標簽ID', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新時間', `status` tinyint(4) DEFAULT 0 COMMENT '狀態，0-停用，1-啟用', PRIMARY KEY (`id`), UNIQUE KEY `tagid` (`tagid`) USING BTREE, KEY `status` (`status`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='標簽庫表'; -- ---------------------------- -- Records of lipin_tag -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_device` -- ---------------------------- DROP TABLE IF EXISTS `lipin_device`; CREATE TABLE `lipin_device` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `imei` varchar(250) NOT NULL DEFAULT '' COMMENT '設備imei', `user_name` varchar(250) NULL DEFAULT '' COMMENT 'user_name', `mobile` char(15) NULL COMMENT 'mobile', `status` tinyint(4) DEFAULT 0 COMMENT '狀態，0-禁止，1-允許', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新時間', `active_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '活躍時間', PRIMARY KEY (`id`), UNIQUE KEY `imei` (`imei`) USING BTREE, KEY `status` (`status`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='設備表'; -- ---------------------------- -- Records of lipin_device -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_validation_log` -- ---------------------------- DROP TABLE IF EXISTS `lipin_validation_log`; CREATE TABLE `lipin_validation_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tagid` varchar(100) NOT NULL DEFAULT 0 COMMENT 'NFC標簽ID', `imei` varchar(100) NULL DEFAULT '' COMMENT '設備imei', `mobile` char(15) NULL DEFAULT '' COMMENT 'mobile', `longitude` varchar(250) NULL DEFAULT '' COMMENT '經度', `latitude` varchar(250) NULL DEFAULT '' COMMENT '緯度', `request_ip` bigint(20) NULL DEFAULT 0 COMMENT '請求IP', `color` varchar(20) NULL DEFAULT 0 COMMENT 'color', `result` varchar(250) NULL DEFAULT '' COMMENT 'result', `create_time` int(10) unsigned NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NULL DEFAULT 0 COMMENT '更新時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='請求日志表'; -- ---------------------------- -- Records of lipin_validation_log -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_gps_log` -- ---------------------------- DROP TABLE IF EXISTS `lipin_gps_log`; CREATE TABLE `lipin_gps_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `imei` varchar(100) NULL DEFAULT '' COMMENT '設備imei', `longitude` varchar(250) NULL DEFAULT '' COMMENT '經度', `latitude` varchar(250) NULL DEFAULT '' COMMENT '緯度', `request_ip` bigint(20) NULL DEFAULT 0 COMMENT '請求IP', `str` varchar(500) NULL DEFAULT '' COMMENT 'str', `create_time` int(10) unsigned NULL DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='gps日志表'; -- ---------------------------- -- Records of lipin_gps_log -- ---------------------------- -- ---------------------------- -- Table structure for `lipin_release` -- ---------------------------- DROP TABLE IF EXISTS `lipin_release`; CREATE TABLE `lipin_release` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ver` varchar(250) NOT NULL DEFAULT '' COMMENT 'ver', `url` varchar(250) NOT NULL DEFAULT '' COMMENT 'url', `size` varchar(250) NOT NULL DEFAULT '' COMMENT 'size', `md5` varchar(250) NOT NULL DEFAULT '' COMMENT 'md5', `text` varchar(500) NOT NULL DEFAULT '' COMMENT 'text', `type` tinyint(4) DEFAULT 0 COMMENT '類型，0-穩定版，1-測試版，2-重要版', `downloads` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '下載次數', `create_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '創建時間', `update_time` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '更新時間', PRIMARY KEY (`id`), KEY `type` (`type`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='軟件發布表'; -- ---------------------------- -- Records of lipin_release -- ---------------------------- ``` update time: 2017-3-31 21:05:41