文章模型 · 優行到家后端程序

~~~[sql] CREATE TABLE `xi_article` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `cate_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分類ID', `created_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '創建者ID', `updated_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新者ID', `auditd_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '審核者ID', `identity` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '身份，1=>會員，2=>配送員，3=>商家，4=>平臺', `title` varchar(32) NOT NULL DEFAULT '' COMMENT '標題', `thumb` varchar(255) NOT NULL DEFAULT 'http://oss.dgyouduo.com/static/img/no-image.png' COMMENT '縮略圖', `banner` varchar(512) NOT NULL DEFAULT 'a:1:{i:0;s:53:"http://oss.dgyouduo.com/static/img/no-image-16x10.png";}' COMMENT '橫幅', `summary` varchar(128) NOT NULL DEFAULT '' COMMENT '摘要', `content` text NOT NULL COMMENT '內容', `author` varchar(16) NOT NULL DEFAULT '' COMMENT '作者', `source_name` varchar(16) NOT NULL COMMENT '來源站點', `source_url` varchar(64) NOT NULL COMMENT '來源網址', `view_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '查看次數', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_audit` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否審核，0=>未審核，1=>審核通過，2=>審核駁回', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', `auditd_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '審核時間', PRIMARY KEY (`id`), UNIQUE KEY `title` (`title`,`cate_id`,`is_trash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章'; ~~~ ~~~[sql] CREATE TABLE `xi_article_audit_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `article_id` int(11) unsigned NOT NULL COMMENT '文章ID', `admin_id` int(11) unsigned NOT NULL COMMENT '用戶ID', `operate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '操作，1=>審核通過，2=>審核駁回', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章審核日志'; ~~~ ~~~[sql] CREATE TABLE `xi_article_category` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父ID', `parent_id_path` varchar(32) NOT NULL DEFAULT '' COMMENT '父ID路徑', `level` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '級別', `identity` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '身份，1=>會員，2=>配送員，3=>商家，4=>平臺', `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名稱', `thumb` varchar(255) NOT NULL DEFAULT 'http://oss.dgyouduo.com/static/img/no-image.png' COMMENT '縮略圖', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`parent_id`,`identity`,`is_trash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文章分類'; ~~~