jy/doc/mysql表结构/infotype.sql

/*
Navicat MySQL Data Transfer

Source Server         : 推送历史
Source Server Version : 50727
Source Host           : 10.66.39.130:3306
Source Database       : jianyu

Target Server Type    : MYSQL
Target Server Version : 50727
File Encoding         : 65001

Date: 2019-12-16 09:43:20
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `infotype`
-- ----------------------------
DROP TABLE IF EXISTS `infotype`;
CREATE TABLE `infotype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '1招标一级,2招标二级, 3采购单位行业',
  `pid` tinyint(4) NOT NULL DEFAULT '0' COMMENT '父id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of infotype
-- ----------------------------
INSERT INTO `infotype` VALUES ('1', '招标', '1', '0');
INSERT INTO `infotype` VALUES ('2', '拟建', '1', '0');
INSERT INTO `infotype` VALUES ('3', '预告', '1', '0');
INSERT INTO `infotype` VALUES ('4', '结果', '1', '0');
INSERT INTO `infotype` VALUES ('5', '其它', '1', '0');
INSERT INTO `infotype` VALUES ('6', '拟建', '2', '2');
INSERT INTO `infotype` VALUES ('7', '预告', '2', '3');
INSERT INTO `infotype` VALUES ('8', '招标', '2', '1');
INSERT INTO `infotype` VALUES ('9', '邀标', '2', '1');
INSERT INTO `infotype` VALUES ('10', '询价', '2', '1');
INSERT INTO `infotype` VALUES ('11', '竞谈', '2', '1');
INSERT INTO `infotype` VALUES ('12', '单一', '2', '1');
INSERT INTO `infotype` VALUES ('13', '竞价', '2', '1');
INSERT INTO `infotype` VALUES ('14', '变更', '2', '1');
INSERT INTO `infotype` VALUES ('15', '其它', '2', '1');
INSERT INTO `infotype` VALUES ('16', '中标', '2', '4');
INSERT INTO `infotype` VALUES ('17', '成交', '2', '4');
INSERT INTO `infotype` VALUES ('18', '废标', '2', '4');
INSERT INTO `infotype` VALUES ('19', '流标', '2', '4');
INSERT INTO `infotype` VALUES ('20', '合同', '2', '5');
INSERT INTO `infotype` VALUES ('21', '验收', '2', '5');
INSERT INTO `infotype` VALUES ('22', '违规', '2', '5');
INSERT INTO `infotype` VALUES ('23', '民政', '3', '0');
INSERT INTO `infotype` VALUES ('24', '出版广电', '3', '0');
INSERT INTO `infotype` VALUES ('25', '体育', '3', '0');
INSERT INTO `infotype` VALUES ('26', '机关事务', '3', '0');
INSERT INTO `infotype` VALUES ('27', '市政', '3', '0');
INSERT INTO `infotype` VALUES ('28', '住宿餐饮', '3', '0');
INSERT INTO `infotype` VALUES ('29', '金融业', '3', '0');
INSERT INTO `infotype` VALUES ('30', '组织', '3', '0');
INSERT INTO `infotype` VALUES ('31', '水利', '3', '0');
INSERT INTO `infotype` VALUES ('32', '国资委', '3', '0');
INSERT INTO `infotype` VALUES ('33', '人大', '3', '0');
INSERT INTO `infotype` VALUES ('34', '社会团体', '3', '0');
INSERT INTO `infotype` VALUES ('35', '气象', '3', '0');
INSERT INTO `infotype` VALUES ('36', '保监', '3', '0');
INSERT INTO `infotype` VALUES ('37', '运输物流', '3', '0');
INSERT INTO `infotype` VALUES ('38', '发改', '3', '0');
INSERT INTO `infotype` VALUES ('39', '商务', '3', '0');
INSERT INTO `infotype` VALUES ('40', '食药', '3', '0');
INSERT INTO `infotype` VALUES ('41', '传媒', '3', '0');
INSERT INTO `infotype` VALUES ('42', '学校', '3', '0');
INSERT INTO `infotype` VALUES ('43', '采矿业', '3', '0');
INSERT INTO `infotype` VALUES ('44', '党委办', '3', '0');
INSERT INTO `infotype` VALUES ('45', '文化', '3', '0');
INSERT INTO `infotype` VALUES ('46', '安监', '3', '0');
INSERT INTO `infotype` VALUES ('47', '政协', '3', '0');
INSERT INTO `infotype` VALUES ('48', '军队', '3', '0');
INSERT INTO `infotype` VALUES ('49', '信息技术', '3', '0');
INSERT INTO `infotype` VALUES ('50', '审计', '3', '0');
INSERT INTO `infotype` VALUES ('51', '城管', '3', '0');
INSERT INTO `infotype` VALUES ('52', '制造业', '3', '0');
INSERT INTO `infotype` VALUES ('53', '宣传', '3', '0');
INSERT INTO `infotype` VALUES ('54', '科技', '3', '0');
INSERT INTO `infotype` VALUES ('55', '财政', '3', '0');
INSERT INTO `infotype` VALUES ('56', '人社', '3', '0');
INSERT INTO `infotype` VALUES ('57', '交通', '3', '0');
INSERT INTO `infotype` VALUES ('58', '税务', '3', '0');
INSERT INTO `infotype` VALUES ('59', '统计', '3', '0');
INSERT INTO `infotype` VALUES ('60', '纪委', '3', '0');
INSERT INTO `infotype` VALUES ('61', '政府办', '3', '0');
INSERT INTO `infotype` VALUES ('62', '环保', '3', '0');
INSERT INTO `infotype` VALUES ('63', '农业', '3', '0');
INSERT INTO `infotype` VALUES ('64', '林业', '3', '0');
INSERT INTO `infotype` VALUES ('65', '档案', '3', '0');
INSERT INTO `infotype` VALUES ('66', '电信行业', '3', '0');
INSERT INTO `infotype` VALUES ('67', '教育', '3', '0');
INSERT INTO `infotype` VALUES ('68', '能源化工', '3', '0');
INSERT INTO `infotype` VALUES ('69', '批发零售', '3', '0');
INSERT INTO `infotype` VALUES ('70', '法院', '3', '0');
INSERT INTO `infotype` VALUES ('71', '地震', '3', '0');
INSERT INTO `infotype` VALUES ('72', '司法', '3', '0');
INSERT INTO `infotype` VALUES ('73', '住建', '3', '0');
INSERT INTO `infotype` VALUES ('74', '人行', '3', '0');
INSERT INTO `infotype` VALUES ('75', '统战', '3', '0');
INSERT INTO `infotype` VALUES ('76', '公安', '3', '0');
INSERT INTO `infotype` VALUES ('77', '医疗', '3', '0');
INSERT INTO `infotype` VALUES ('78', '银监', '3', '0');
INSERT INTO `infotype` VALUES ('79', '旅游', '3', '0');
INSERT INTO `infotype` VALUES ('80', '政务中心', '3', '0');
INSERT INTO `infotype` VALUES ('81', '民宗', '3', '0');
INSERT INTO `infotype` VALUES ('82', '检察院', '3', '0');
INSERT INTO `infotype` VALUES ('83', '卫生', '3', '0');
INSERT INTO `infotype` VALUES ('84', '质监', '3', '0');
INSERT INTO `infotype` VALUES ('85', '公共资源交易', '3', '0');
INSERT INTO `infotype` VALUES ('86', '农林牧渔', '3', '0');
INSERT INTO `infotype` VALUES ('87', '建筑业', '3', '0');
INSERT INTO `infotype` VALUES ('88', '工信', '3', '0');
INSERT INTO `infotype` VALUES ('89', '国土', '3', '0');
INSERT INTO `infotype` VALUES ('90', '海关', '3', '0');
INSERT INTO `infotype` VALUES ('91', '工商', '3', '0');
INSERT INTO `infotype` VALUES ('92', '证监', '3', '0');
INSERT INTO `infotype` VALUES ('93', '其它', '3', '0');
INSERT INTO `infotype` VALUES ('94', '结果变更', '2', '4');