text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localohost
  Source Server Version : 50727
  Source Host           : localhost:3306
  Source Database       : image_search
  
  Target Server Type    : MYSQL
  Target Server Version : 50727
  File Encoding         : 65001
  
  Date: 2019-12-02 09:38:15
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for department
  -- ----------------------------
  DROP TABLE IF EXISTS `department`;
  CREATE TABLE `department` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `tenant_code` varchar(20) NOT NULL COMMENT '租户代码',
    `department_code` varchar(50) DEFAULT NULL COMMENT '部门代码',
    `department_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
    `contact` varchar(50) DEFAULT NULL COMMENT '联系人',
    `contact_phone` varchar(100) DEFAULT NULL COMMENT '联系电话',
    `description` varchar(255) DEFAULT NULL COMMENT '描述',
    `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `created_by` varchar(50) DEFAULT NULL COMMENT '联系电话',
    `updated_by` varchar(50) DEFAULT NULL COMMENT '联系电话',
    `deleted` tinyint(4) DEFAULT '0' COMMENT '删除标记',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
  