-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64) -- -- Host: 192.168.1.111 Database: aft_dev -- ------------------------------------------------------ -- Server version 5.7.18-0ubuntu0.16.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `achievement` -- DROP TABLE IF EXISTS `achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement` ( `id` varchar(36) NOT NULL, `serial_number` int(36) NOT NULL AUTO_INCREMENT COMMENT '编号', `data_category` int(1) NOT NULL COMMENT '数据类别 (0--成果, 1--技术, 2--项目)', `name` varchar(32) NOT NULL COMMENT '名称', `keyword` varchar(45) NOT NULL COMMENT '关键词', `category` int(1) NOT NULL COMMENT '类型(0--专利, 2--软著, 3--项目, 4--版权, 5--工业设计, 6--配方, 7--非标)', `summary` varchar(300) DEFAULT NULL COMMENT '摘要', `introduction` varchar(300) DEFAULT NULL COMMENT '成果简介', `technical_picture_url` varchar(500) DEFAULT NULL COMMENT '技术图片', `field_a` int(3) DEFAULT NULL COMMENT '应用领域1', `field_b` int(3) DEFAULT NULL COMMENT '应用领域2', `field_c` int(3) DEFAULT NULL COMMENT '应用领域3', `maturity` int(1) DEFAULT NULL COMMENT '成熟度(0--正在研发, 1-- 已有样品, 2-- 通过小试, 3-- 通过中试, 4-- 可以量产)', `maturity_picture_url` longtext COMMENT '成熟度资料--图片URL', `maturity_text_file_url` varchar(255) DEFAULT NULL COMMENT '成熟度资料--文本文件URL', `maturity_video_url` varchar(255) DEFAULT NULL COMMENT '成熟度资料--视屏URL', `innovation` int(1) DEFAULT NULL COMMENT '创新度(0--行业先进,1--行业领先,2--国内先进,3--国内领先,4--国际先进,5--国际领先)', `owner_id` varchar(36) DEFAULT NULL COMMENT '所有人ID', `owner_name` varchar(32) DEFAULT NULL COMMENT '成果所有人名称', `owner_type` int(1) DEFAULT NULL COMMENT '所有人类型(0-个人,1-组织)', `owner_id_number` varchar(36) DEFAULT NULL COMMENT '所有人证件号', `owner_mobile` varchar(12) DEFAULT NULL COMMENT '所有人联系电话', `owner_email` varchar(255) DEFAULT NULL COMMENT '所有人电子邮箱', `owner_postal_address` varchar(255) DEFAULT NULL COMMENT '所有人通讯地址', `cooperation_mode` int(1) NOT NULL COMMENT '合作方式(0--技术转让,1--授权生产)', `transfer_mode` int(1) DEFAULT NULL COMMENT '转让方式(0--完全转让,1--许可转让,2--技术入股)', `bargaining_mode` int(1) DEFAULT NULL COMMENT '议价方式(0--面议,1--定价)', `transfer_price` decimal(8,2) DEFAULT NULL COMMENT '转让价格', `technical_scene` varchar(300) DEFAULT NULL COMMENT '技术场景', `breakthrough` varchar(300) DEFAULT NULL COMMENT '技术突破', `patent_case` varchar(300) DEFAULT NULL COMMENT '专利情况', `awards` varchar(300) DEFAULT NULL COMMENT '获奖情况', `team_des` varchar(300) DEFAULT NULL COMMENT '技术团队情况', `parameter` varchar(255) DEFAULT NULL COMMENT '技术参数', `tech_plan_url` varchar(255) DEFAULT NULL COMMENT '技术方案URL', `business_plan_url` varchar(255) DEFAULT NULL COMMENT '商业计划书URL', `org_id` varchar(36) DEFAULT NULL COMMENT '所属组织ID', `org_name` varchar(45) DEFAULT NULL COMMENT '所属组织名称', `org_address` varchar(255) DEFAULT NULL COMMENT '所属组织地址', `org_email` varchar(255) DEFAULT NULL COMMENT '所属组织邮箱', `org_contacts` varchar(45) DEFAULT NULL COMMENT '所属组织联系人名称', `org_contacts_mobile` varchar(45) DEFAULT NULL COMMENT '所属组织联系人电话', `contacts` int(1) DEFAULT NULL COMMENT '联系人及方式', `manager_id` varchar(36) DEFAULT NULL COMMENT '客户经理ID', `salesman_id` varchar(36) DEFAULT NULL COMMENT '营销员ID', `status` int(1) DEFAULT NULL COMMENT '状态', `create_time` datetime DEFAULT NULL COMMENT '成果记录创建时间', `release_status` int(1) DEFAULT NULL COMMENT '是否发布(0--未发布,1--已发布)', `release_date` datetime DEFAULT NULL COMMENT '发布时间', `deleted_sign` int(1) NOT NULL COMMENT '删除标记', `audit_status` int(1) DEFAULT NULL COMMENT '审核状态(0--未提交审核草稿,1,--提交审核,2--审核中,3--审核通过,4--审核未通过)', `tech_broker_id` varchar(36) DEFAULT NULL COMMENT '技术经纪人ID', PRIMARY KEY (`id`), KEY `serialNumber` (`serial_number`) ) ENGINE=InnoDB AUTO_INCREMENT=600063 DEFAULT CHARSET=utf8 COMMENT='技术成果'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_demand` -- DROP TABLE IF EXISTS `achievement_demand`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_demand` ( `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID', `demand_id` varchar(36) NOT NULL COMMENT '科技需求ID', PRIMARY KEY (`achievement_id`,`demand_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果及科技需求匹配'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_demand_count` -- DROP TABLE IF EXISTS `achievement_demand_count`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_demand_count` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL COMMENT '用户ID', `achievement_count` int(4) DEFAULT NULL COMMENT '已发布科技成果数量', `demand_count` int(4) DEFAULT NULL COMMENT '已发布科技需求数量', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户已发布科技成果及已发布科技需求数量'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_interest` -- DROP TABLE IF EXISTS `achievement_interest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_interest` ( `id` varchar(36) NOT NULL, `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID', `uid` varchar(36) NOT NULL COMMENT '感兴趣人ID', `create_time` datetime NOT NULL COMMENT '记录创建时间(关注时间)', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果"感兴趣(关注)"'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_keyword` -- DROP TABLE IF EXISTS `achievement_keyword`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_keyword` ( `id` varchar(36) NOT NULL, `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID', `keyword` varchar(16) NOT NULL COMMENT '科技成果关键词', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果关键词'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_order` -- DROP TABLE IF EXISTS `achievement_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_order` ( `id` varchar(36) NOT NULL, `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号', `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID', `uid` varchar(36) DEFAULT NULL COMMENT '购买科技成果人ID', `create_time` datetime DEFAULT NULL COMMENT '购买时间', `status` int(1) DEFAULT NULL COMMENT '流程变动(0--初始意向,1--意向金,2--签订合同,3--合同金,4--佣金,5--服务金,6--关闭(未签合同),7--关闭(已签合同))', `intention_money` int(8) DEFAULT NULL COMMENT '意向金', `contract_money` int(8) DEFAULT NULL COMMENT '合同金', `commission` int(8) DEFAULT NULL COMMENT '佣金', `service_money` int(8) DEFAULT NULL COMMENT '服务金', `refund` int(1) DEFAULT NULL COMMENT '是否退款(0--未退款,1--已退款)', `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记(0--未删除,1--已删除)', PRIMARY KEY (`id`), KEY `serialNumber` (`serial_number`) ) ENGINE=InnoDB AUTO_INCREMENT=600005 DEFAULT CHARSET=utf8 COMMENT='科技成果意向单/交易单'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_order_log` -- DROP TABLE IF EXISTS `achievement_order_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_order_log` ( `id` varchar(36) NOT NULL, `achievement_order_id` varchar(36) DEFAULT NULL COMMENT '科技成果订单ID', `record_time` datetime DEFAULT NULL, `status` int(1) DEFAULT NULL COMMENT '状态', `operator` varchar(36) DEFAULT NULL COMMENT '记录操作人', `comment` varchar(128) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果意向单/交易单log'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `admin` -- DROP TABLE IF EXISTS `admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `admin` ( `id` varchar(36) NOT NULL, `mobile` varchar(12) DEFAULT NULL COMMENT '手机号(登录帐号)', `name` varchar(16) DEFAULT NULL COMMENT '用户名', `password` varchar(32) DEFAULT NULL COMMENT '密码', `email` varchar(255) DEFAULT NULL COMMENT '邮箱', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `number` int(6) NOT NULL AUTO_INCREMENT, `province` varchar(12) DEFAULT NULL COMMENT '所在省份', `position` varchar(32) DEFAULT NULL COMMENT '职位', `superior_id` varchar(36) DEFAULT NULL COMMENT '上级管理用户ID', `city` varchar(16) DEFAULT NULL COMMENT '所在市', PRIMARY KEY (`id`), KEY `index_number` (`number`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `admin_location` -- DROP TABLE IF EXISTS `admin_location`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `admin_location` ( `id` varchar(36) NOT NULL, `admin_id` varchar(36) NOT NULL COMMENT '管理员ID', `province` int(2) NOT NULL COMMENT '省份', `city` int(3) DEFAULT NULL COMMENT '市', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员地区'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `aft_file` -- DROP TABLE IF EXISTS `aft_file`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aft_file` ( `id` varchar(36) NOT NULL, `uid` varchar(36) DEFAULT NULL COMMENT '用户id', `file_name` varchar(32) DEFAULT NULL COMMENT '文件名称', `file_path` varchar(255) NOT NULL COMMENT '文件路径', `sign` varchar(45) DEFAULT NULL COMMENT '模版标记', `comment` varchar(45) DEFAULT NULL COMMENT '备注', `deleleted_sign` int(1) NOT NULL DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract` -- DROP TABLE IF EXISTS `contract`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `contacts` int(1) DEFAULT NULL COMMENT '联系人', `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '合同编号', `name` varchar(36) DEFAULT NULL COMMENT '合同名称(预留字段)', `type` int(1) DEFAULT NULL COMMENT '合同类型(1-专利类型合同,2-软著类型合同,3-高企认定类型合同,4-科技项目类型合同)', `sign_date` datetime DEFAULT NULL COMMENT '合同签订时间', `founder` varchar(36) DEFAULT NULL COMMENT '合同记录创建人', `depict` varchar(128) DEFAULT NULL COMMENT '合同描述', `status` int(1) DEFAULT NULL COMMENT '合同状态(0-草稿,1-签订,2-分发流转,3-完成(已结款))', `patent_num` int(2) DEFAULT NULL COMMENT '专利数量', `patent_status` int(1) DEFAULT NULL COMMENT '专利创建状态(0-未创建,1-已创建)', `copyright_num` int(2) DEFAULT NULL COMMENT '软著数量', `copyright_status` int(1) DEFAULT NULL COMMENT '软著创建状态(0-未创建,1-已创建)', `cognizance_year` int(4) DEFAULT NULL COMMENT '高企申请年份', `cognizance_status` int(1) DEFAULT NULL COMMENT '高企认定创建状态(1-未创建,1-已创建)', `tech_project_num` int(2) DEFAULT NULL COMMENT '科技项目数量', `tech_project_status` int(1) DEFAULT NULL COMMENT '科技项目创建状态(0-未创建,1-已创建)', `comment` varchar(45) DEFAULT NULL COMMENT '合同创建备注', `create_time` datetime DEFAULT NULL COMMENT '记录创建时间', `complete_date` datetime DEFAULT NULL COMMENT '合同完成(结款)日期', `deleted_sign` int(1) DEFAULT NULL, `previous_fee` varchar(8) DEFAULT NULL COMMENT '前期费用', PRIMARY KEY (`id`), KEY `serialNumber` (`serial_number`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='合同'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract_log` -- DROP TABLE IF EXISTS `contract_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract_log` ( `id` varchar(36) NOT NULL, `cid` varchar(36) DEFAULT NULL COMMENT '合同表主键', `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间', `status` int(1) DEFAULT NULL COMMENT '状态', `principal` varchar(36) DEFAULT NULL COMMENT '负责人', `operator` varchar(36) DEFAULT NULL COMMENT '操作人', `comment` varchar(128) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='合同日志'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `copyright_info` -- DROP TABLE IF EXISTS `copyright_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `copyright_info` ( `id` varchar(36) NOT NULL COMMENT '主键', `uid` varchar(36) NOT NULL COMMENT '用户主键', `contract_id` varchar(36) DEFAULT NULL COMMENT '合同ID', `serial_number` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `accept_time` datetime DEFAULT NULL COMMENT '受理时间', `principal` varchar(36) DEFAULT NULL COMMENT '负责人', `contact` int(1) DEFAULT NULL COMMENT '联系人', `copyright_info` varchar(255) DEFAULT NULL COMMENT '软著简介', `copyright_name` varchar(60) DEFAULT NULL COMMENT '软著名字', `status` int(1) DEFAULT NULL COMMENT '申请状态', `work_issue` varchar(128) DEFAULT NULL COMMENT '派单信息', `comment` varchar(128) DEFAULT NULL COMMENT '备注', `outsource` varchar(60) DEFAULT NULL COMMENT '外包公司', `in_urgent` int(3) DEFAULT NULL COMMENT '加急天数', `authorized_date` datetime DEFAULT NULL COMMENT '下证日', `certificate_url` varchar(255) DEFAULT NULL COMMENT '证书附件地址', `application_url` varchar(255) DEFAULT NULL COMMENT '申请书附件地址', `delete_sign` int(1) NOT NULL DEFAULT '0' COMMENT '删除标记', `copyright_number` varchar(18) DEFAULT NULL, `founder` varchar(36) DEFAULT NULL COMMENT '申请创建人ID', PRIMARY KEY (`id`), UNIQUE KEY `serial_number_UNIQUE` (`serial_number`) ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `copyright_log` -- DROP TABLE IF EXISTS `copyright_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `copyright_log` ( `id` varchar(36) NOT NULL COMMENT '主键', `cid` varchar(36) NOT NULL COMMENT '软著申请id', `record_time` datetime DEFAULT NULL COMMENT '状态流转时间', `status` int(1) DEFAULT NULL COMMENT '状态', `principal` varchar(36) DEFAULT NULL COMMENT '负责人', `operator` varchar(36) DEFAULT NULL COMMENT '操作人', `comment` varchar(128) DEFAULT NULL COMMENT '备注', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '日志创建时间', PRIMARY KEY (`id`), KEY `fk_copyright_log_copyright_info1_idx` (`cid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `demand` -- DROP TABLE IF EXISTS `demand`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `demand` ( `id` varchar(36) NOT NULL, `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号', `data_category` int(1) DEFAULT NULL COMMENT '数据类别(0-个人需求,1-单位需求)', `name` varchar(32) NOT NULL COMMENT '名称', `keyword` varchar(45) NOT NULL COMMENT '关键词', `info_sources` int(1) NOT NULL COMMENT '信息来源(0-平台采集,1-客户发布)', `industry_category_a` int(3) DEFAULT NULL COMMENT '行业类别下拉A', `industry_category_b` int(3) DEFAULT NULL COMMENT '行业类别下拉B', `industry_category_c` int(3) DEFAULT NULL COMMENT '行业类别下拉C', `demand_type` int(1) NOT NULL COMMENT '需求类型', `problem_des` varchar(256) NOT NULL COMMENT '问题说明', `technical_requirements` varchar(256) DEFAULT NULL COMMENT '技术指标要求', `picture_url` longtext COMMENT '需求文件--图片URL', `text_file_url` varchar(255) DEFAULT NULL COMMENT '需求文件--文本文件', `video_url` varchar(255) DEFAULT NULL COMMENT '需求文件--视屏文件URL', `fixed_budget` decimal(8,2) DEFAULT NULL COMMENT '固定预算', `fixed_cycle` varchar(12) DEFAULT NULL COMMENT '固定周期', `people_number` int(5) DEFAULT NULL COMMENT '固定人数', `fixed_scheme` varchar(200) DEFAULT NULL COMMENT '固定方案', `cost_escrow` decimal(8,2) DEFAULT NULL COMMENT '费用托管', `budget_cost` decimal(8,2) DEFAULT NULL COMMENT '预算费用', `validity_period` datetime DEFAULT NULL COMMENT '有效期限', `employer_id` varchar(36) DEFAULT NULL COMMENT '雇主客户ID', `employer_name` varchar(16) DEFAULT NULL COMMENT '雇主名称', `employer_address` varchar(128) DEFAULT NULL COMMENT '雇主地址', `employer_contacts` varchar(16) DEFAULT NULL COMMENT '雇主联系人名称', `employer_contacts_mobile` varchar(11) DEFAULT NULL COMMENT '雇主联系人电话', `employer_contacts_mailbox` varchar(255) DEFAULT NULL COMMENT '雇主联系人邮箱', `contacts` int(1) DEFAULT NULL COMMENT '联系人&联系方式', `status` int(1) DEFAULT NULL COMMENT '需求状态(0-进行中,1-未解决,2-已解决)', `release_status` int(1) DEFAULT NULL COMMENT '是否发布(0-未发布,1-发布)', `release_date` datetime DEFAULT NULL COMMENT '发布时间', `create_time` datetime DEFAULT NULL COMMENT '需求记录创建时间', `principal_id` varchar(36) DEFAULT NULL COMMENT '负责人(营销员)', `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记', `audit_status` int(1) DEFAULT NULL COMMENT '审核状态(0--未提交审核草稿,1--审核中,2--审核通过,3--审核未通过)', `tech_broker_id` varchar(36) DEFAULT NULL COMMENT '技术经纪人ID', PRIMARY KEY (`id`), KEY `serialNumber` (`serial_number`) ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='技术需求'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `demand_interest` -- DROP TABLE IF EXISTS `demand_interest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `demand_interest` ( `id` varchar(36) NOT NULL, `demand_id` varchar(36) NOT NULL COMMENT '需求主键', `uid` varchar(36) NOT NULL COMMENT '关注人ID', `create_time` datetime NOT NULL COMMENT '关注时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技需求"感兴趣(关注)"'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `demand_keyword` -- DROP TABLE IF EXISTS `demand_keyword`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `demand_keyword` ( `id` varchar(36) NOT NULL, `demand_id` varchar(36) NOT NULL COMMENT '科技需求ID', `keyword` varchar(16) NOT NULL COMMENT '关键词', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技需求关键词'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `demand_log` -- DROP TABLE IF EXISTS `demand_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `demand_log` ( `id` varchar(36) NOT NULL, `demand_id` varchar(36) NOT NULL COMMENT '需求表主键', `status` int(1) NOT NULL COMMENT '状态', `operator` varchar(36) DEFAULT NULL COMMENT '操作人', `principal` varchar(36) DEFAULT NULL, `recored_time` datetime NOT NULL COMMENT '记录时间', `comment` varchar(128) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `demand_order` -- DROP TABLE IF EXISTS `demand_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `demand_order` ( `id` varchar(36) NOT NULL, `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号', `demand_id` varchar(36) NOT NULL COMMENT '科技需求ID', `uid` varchar(36) DEFAULT NULL COMMENT '接单人ID', `create_time` datetime DEFAULT NULL COMMENT '接单时间', `enclosure_url` varchar(255) DEFAULT NULL COMMENT '附件URL', `status` int(1) DEFAULT NULL COMMENT '流程变动(0--初始意向,1--意向金,2--签订合同,3--合同金,4--佣金,5--服务金,6--关闭)', `intention_money` int(8) DEFAULT NULL COMMENT '意向金', `contract_money` int(8) DEFAULT NULL COMMENT '合同金', `commission` int(8) DEFAULT NULL COMMENT '佣金', `service_money` int(8) DEFAULT NULL COMMENT '服务金', `refund` int(1) DEFAULT NULL COMMENT '是否退款(0--未退款,1--已退款)', `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记(0--未删除,1--已删除)', PRIMARY KEY (`id`), KEY `serialNumber` (`serial_number`) ) ENGINE=InnoDB AUTO_INCREMENT=600004 DEFAULT CHARSET=utf8 COMMENT='科技需求意向单/交易单'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `demand_order_log` -- DROP TABLE IF EXISTS `demand_order_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `demand_order_log` ( `id` varchar(36) NOT NULL, `demand_order_id` varchar(36) NOT NULL COMMENT '科技需求意向单/交易单ID', `record_time` datetime DEFAULT NULL, `status` int(1) DEFAULT NULL COMMENT '状态', `operator` varchar(36) DEFAULT NULL COMMENT '记录操作人', `comment` varchar(128) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技需求意向单/交易单日志'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `district_glossory` -- DROP TABLE IF EXISTS `district_glossory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `district_glossory` ( `id` int(4) NOT NULL, `name` varchar(16) DEFAULT NULL COMMENT '名称', `pid` int(4) DEFAULT NULL COMMENT '上级ID', `level` int(1) DEFAULT NULL COMMENT '层级', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='地区数据字典'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `field_glossory` -- DROP TABLE IF EXISTS `field_glossory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `field_glossory` ( `id` int(4) NOT NULL, `name` varchar(32) DEFAULT NULL COMMENT '名称', `pid` int(4) DEFAULT NULL COMMENT '上级ID', `level` int(1) DEFAULT NULL COMMENT '层级', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='领域类别'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `html_fragment` -- DROP TABLE IF EXISTS `html_fragment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `html_fragment` ( `id` varchar(36) NOT NULL, `content` longtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `industry_category` -- DROP TABLE IF EXISTS `industry_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `industry_category` ( `id` int(11) NOT NULL, `name` varchar(45) DEFAULT NULL, `pid` int(11) DEFAULT NULL, `value` decimal(4,2) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `legal_person_ownership` -- DROP TABLE IF EXISTS `legal_person_ownership`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `legal_person_ownership` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `type` int(1) DEFAULT NULL COMMENT '法人类型(0--中国企业法人,1--外国企业法人)', `name` varchar(32) DEFAULT NULL COMMENT '名称', `org_code` varchar(32) DEFAULT NULL COMMENT '组织机构代码或统一社会信用代码', `investment` decimal(8,2) DEFAULT NULL COMMENT '投资(万元)', `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='法人股权表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `nature_ownership` -- DROP TABLE IF EXISTS `nature_ownership`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nature_ownership` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `type` int(1) DEFAULT NULL COMMENT '类型 (0--中国公民,1--外籍公民)', `name` varchar(32) DEFAULT NULL COMMENT '姓名', `id_number` varchar(18) DEFAULT NULL COMMENT '身份证(护照)号', `investment` decimal(8,2) DEFAULT NULL COMMENT '投资额(万元)', `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='自然人股权表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `notice` -- DROP TABLE IF EXISTS `notice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notice` ( `id` varchar(36) NOT NULL, `aid` varchar(36) DEFAULT NULL, `notice_type` int(1) DEFAULT NULL COMMENT '通知类型', `content` varchar(36) DEFAULT NULL COMMENT '通知内容', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `readed` int(1) DEFAULT NULL, `uid` varchar(36) DEFAULT NULL COMMENT '用户ID', `pid` varchar(36) DEFAULT NULL COMMENT '录入信息业务员ID', `rid` varchar(36) DEFAULT NULL COMMENT '业务记录ID', `year` int(4) DEFAULT NULL COMMENT '高企记录申报年份', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='流转状态通知表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_activity` -- DROP TABLE IF EXISTS `org_activity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_activity` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `activity_number` varchar(32) DEFAULT NULL COMMENT '研发活动编号', `activity_name` varchar(32) DEFAULT NULL COMMENT '研发活动名称', `start_date` datetime DEFAULT NULL COMMENT '开始日期', `end_date` datetime DEFAULT NULL COMMENT '结束日期', `participant` varchar(255) DEFAULT NULL COMMENT '参与人员', `project_mode` int(1) DEFAULT NULL COMMENT '是否是内部立项', `technical_field1` varchar(3) DEFAULT NULL COMMENT '技术领域1st select', `technical_field2` varchar(3) DEFAULT NULL COMMENT '技术领域2nd select', `technical_field3` varchar(3) DEFAULT NULL COMMENT '技术领域3rd select', `technical_source` int(1) DEFAULT NULL COMMENT '技术来源', `intellectual_property_number` varchar(500) DEFAULT NULL COMMENT '知识产权编号', `budget` decimal(8,2) DEFAULT NULL COMMENT '预算(万元)', `first_year_expenditure` decimal(8,2) DEFAULT NULL COMMENT '第一年研发经费支出(万元)', `second_year_expenditure` decimal(8,2) DEFAULT NULL COMMENT '第二年研发经费支出(万元)', `third_year_expenditure` decimal(8,2) DEFAULT NULL COMMENT '第三年研发经费支出(万元)', `implement` varchar(500) DEFAULT NULL COMMENT '目的及组织实施方式', `technology_innovation` varchar(500) DEFAULT NULL COMMENT '核心技术及创新点', `achievement` varchar(500) DEFAULT NULL COMMENT '取得的阶段性成果', `proof_url` varchar(255) DEFAULT NULL COMMENT '立项证明材料URL', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_activity_cost` -- DROP TABLE IF EXISTS `org_activity_cost`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_activity_cost` ( `id` varchar(36) NOT NULL, `aid` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `year` int(4) DEFAULT NULL COMMENT '年份', `activity_number` varchar(32) DEFAULT NULL COMMENT '项目编号', `internal_labor_cost` decimal(8,2) DEFAULT NULL COMMENT '内部人员人工费用(万元)', `internal_direct_cost` decimal(8,2) DEFAULT NULL COMMENT '内部直接投入费用(万元)', `internal_depreciation_cost` decimal(8,2) DEFAULT NULL COMMENT '内部折旧费用与长期待摊费用(万元)', `internal_amortization_cost` decimal(8,2) DEFAULT NULL COMMENT '内部无形资产摊销费用(万元)', `internal_design_cost` decimal(8,2) DEFAULT NULL COMMENT '内部设计费用(万元)', `internal_equipment_cost` decimal(8,2) DEFAULT NULL COMMENT '内部装备调试费用与实验费用(万元)', `internal_other_cost` decimal(8,2) DEFAULT NULL COMMENT '内部其他费用(万元)', `external_total_cost` decimal(8,2) DEFAULT NULL COMMENT '委托外部研究开发总费用(万元)', `external_abroad_cost` decimal(8,2) DEFAULT NULL COMMENT '委托外部境内的外部研发费用(万元)', `enterprise_filler` varchar(16) DEFAULT NULL COMMENT '企业填报人', `sign_date` datetime DEFAULT NULL COMMENT '企业填报人签字日期', `sort_number` varchar(32) DEFAULT NULL COMMENT '排序号', `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `account_url` varchar(255) DEFAULT NULL COMMENT '台帐URL', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `fk_org_activity_cost_org_activity1_idx` (`aid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_annual_report` -- DROP TABLE IF EXISTS `org_annual_report`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_annual_report` ( `id` varchar(36) NOT NULL, `uid` varchar(36) DEFAULT NULL, `create_time` datetime DEFAULT NULL COMMENT '创建时间', `last_update_time` datetime DEFAULT NULL COMMENT '最近跟新时间', `total_tax` decimal(8,2) DEFAULT NULL COMMENT '纳税总额(万元)', `income_tax_relief` decimal(8,2) DEFAULT NULL COMMENT '所得税减免(万元)', `total_export_volume` decimal(8,2) DEFAULT NULL COMMENT '出口创汇总额(万元)', `basic_research_cost` decimal(8,2) DEFAULT NULL COMMENT '基础研究投入费用', `year` int(4) DEFAULT NULL COMMENT '年份', `state` int(1) DEFAULT '0' COMMENT '年报状态', `deleted_sign` int(1) NOT NULL DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_cognizance` -- DROP TABLE IF EXISTS `org_cognizance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_cognizance` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `contract_id` varchar(36) DEFAULT NULL COMMENT '合同ID', `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号', `contacts` int(1) DEFAULT NULL COMMENT '联系人及联系方式', `comment` varchar(128) DEFAULT NULL COMMENT '派单信息', `consultant` varchar(36) DEFAULT NULL COMMENT '咨询师', `technical_field1` int(3) DEFAULT NULL COMMENT '技术领域1st select', `technical_field2` int(3) DEFAULT NULL COMMENT '技术领域2nd select', `technical_field3` int(3) DEFAULT NULL COMMENT '技术领域3rd select', `basic_research_cost` decimal(8,2) DEFAULT NULL COMMENT '基础研究投入费用总额(万元)', `accident` int(1) DEFAULT NULL COMMENT '申请认定前一年内是否发生过重大安全、重大质量或严重环境违法行为', `create_time` datetime DEFAULT NULL COMMENT '派单日', `accept_date` datetime DEFAULT NULL COMMENT '受理日', `issuing_date` datetime DEFAULT NULL COMMENT '发证日', `certificate_number` varchar(36) DEFAULT NULL COMMENT '证书编号', `certificate_url` varchar(255) DEFAULT NULL COMMENT '证书URL', `state` int(2) DEFAULT NULL COMMENT '高企认定状态', `year` int(4) DEFAULT NULL COMMENT '申请年份', `record_time` datetime DEFAULT NULL COMMENT '高企申请时间', `large_order` int(1) DEFAULT NULL COMMENT '是否为大额订单 ', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', `founder` varchar(36) DEFAULT NULL COMMENT '申请创建人ID', `tech_principal` varchar(36) DEFAULT NULL COMMENT '高企技术负责人', PRIMARY KEY (`id`), KEY `serialNumber_UNIQUE` (`serial_number`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=60000029 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_cognizance_log` -- DROP TABLE IF EXISTS `org_cognizance_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_cognizance_log` ( `id` varchar(36) NOT NULL, `cid` varchar(36) NOT NULL, `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间', `state` int(2) DEFAULT NULL COMMENT '高企认定状态', `principal` varchar(36) DEFAULT NULL COMMENT '负责人', `operator` varchar(36) DEFAULT NULL COMMENT '操作人', `comment` varchar(128) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`), KEY `fk_org_cognizance_log_org_cognizance1_idx` (`cid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_cognizance_proportion` -- DROP TABLE IF EXISTS `org_cognizance_proportion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_cognizance_proportion` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `institution` int(1) DEFAULT NULL COMMENT '企业研发机构', `activity` int(1) DEFAULT NULL COMMENT '研发活动', `activity_cost` int(1) DEFAULT NULL COMMENT '研发活动费用详情', `tech_project` int(1) DEFAULT NULL COMMENT '高新技术产品', `intellectual_property` int(1) DEFAULT NULL COMMENT '知识产权', `achievement` int(1) DEFAULT NULL COMMENT '科技成果转化', `ratepay` int(1) DEFAULT NULL COMMENT '企业所得税纳税申报表', `finance` int(1) DEFAULT NULL COMMENT '财务报表', `human_resource` int(1) DEFAULT NULL COMMENT '企业人员情况', `honor_datum` int(1) DEFAULT NULL COMMENT '企业荣誉及其他证明材料', `standard` int(1) DEFAULT NULL COMMENT '标准制定情况', `ability` int(1) DEFAULT NULL COMMENT '企业创新能力', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='高企培育进度权重表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_finance` -- DROP TABLE IF EXISTS `org_finance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_finance` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `main_business_income` decimal(8,2) DEFAULT NULL COMMENT '主营业务收入(万元)', `management_cost` decimal(8,2) DEFAULT NULL COMMENT '管理费用(万元)', `operating_profit` decimal(8,2) DEFAULT NULL COMMENT '营业利润(万元)', `various_tax` decimal(8,2) DEFAULT NULL COMMENT '支付的各项税费(万元)', `current_asset` decimal(8,2) DEFAULT NULL COMMENT '流动资产(万元)', `net_fixed_asset` decimal(8,2) DEFAULT NULL COMMENT '固定资产净额(万元)', `total_asset` decimal(8,2) DEFAULT NULL COMMENT '资产总额(万元)', `net_asset` decimal(8,2) DEFAULT NULL COMMENT '所有者权益合计(万元)', `gross_profit` decimal(8,2) DEFAULT NULL COMMENT '利润总额(万元)', `net_profit` decimal(8,2) DEFAULT NULL COMMENT '净利润(万元)', `sales_revenue` decimal(8,2) DEFAULT NULL COMMENT '销售收入(万元)', `year` int(4) DEFAULT NULL COMMENT '年份', `finance_url` varchar(255) DEFAULT NULL COMMENT '财务报表URL', `research_cost` decimal(8,2) DEFAULT NULL COMMENT '研发费用', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `fk_org_finance_user1_idx` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_honor_datum` -- DROP TABLE IF EXISTS `org_honor_datum`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_honor_datum` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `name` varchar(32) DEFAULT NULL COMMENT '荣誉或证明材料名称', `issuing_mechanism` varchar(36) DEFAULT NULL COMMENT '发证机构', `issuing_time` datetime DEFAULT NULL COMMENT '发证时间', `enclosure_url` varchar(255) DEFAULT NULL COMMENT '附件材料URL', `year` int(4) DEFAULT NULL COMMENT '荣誉及其他证明材料获取年份', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `fk_org_honor_datum_user1_idx` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_human_resource` -- DROP TABLE IF EXISTS `org_human_resource`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_human_resource` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `firm_total` int(6) DEFAULT NULL COMMENT '企业职工总数', `tech_total` int(6) DEFAULT NULL COMMENT '科技人员总数', `firm_in_service` int(6) DEFAULT NULL COMMENT '企业在职员工人数', `tech_in_service` int(6) DEFAULT NULL COMMENT '科技在职员工人数', `firm_part_time` int(6) DEFAULT NULL COMMENT '企业兼职人数', `tech_part_time` int(6) DEFAULT NULL COMMENT '科技人员兼职人数', `firm_temporary` int(6) DEFAULT NULL COMMENT '企业临时聘用人数', `tech_temporary` int(6) DEFAULT NULL COMMENT '科技人员临时聘用人数', `firm_foreign` int(6) DEFAULT NULL COMMENT '企业外籍人员数', `tech_foreign` int(6) DEFAULT NULL COMMENT '外籍科技人员数', `firm_abroad` int(6) DEFAULT NULL COMMENT '企业留学归国人员数', `tech_abroad` int(6) DEFAULT NULL COMMENT '留学归国科技人员数', `firm_core` int(6) DEFAULT NULL COMMENT '企业千人计划人数', `tech_core` int(6) DEFAULT NULL COMMENT '千人计划科技人员数', `doctor` int(6) DEFAULT NULL COMMENT '博士人数', `master` int(6) DEFAULT NULL COMMENT '硕士人数', `undergraduate` int(6) DEFAULT NULL COMMENT '本科人数', `college` int(6) DEFAULT NULL COMMENT '大专人数', `senior_title` int(6) DEFAULT NULL COMMENT '高级职称人数', `intermediate_title` int(6) DEFAULT NULL COMMENT '中级职称人数', `junior_title` int(6) DEFAULT NULL COMMENT '初级职称人数', `senior_mechanic` int(6) DEFAULT NULL COMMENT '高级技工人数', `below_thirty` int(6) DEFAULT NULL COMMENT '三十岁及以下员工人数', `thirtyone_to_thirtyfour` int(6) DEFAULT NULL COMMENT '三十一至三十四岁员工人数', `fortyone_to_fifty` int(6) DEFAULT NULL COMMENT '四十一至五十岁员工人数', `above_fifty` int(6) DEFAULT NULL COMMENT '五十岁以上员工人数', `year` int(4) DEFAULT NULL COMMENT '年份', `new_employment` int(6) DEFAULT NULL COMMENT '新增就业人数', `graduate_number` int(6) DEFAULT NULL COMMENT '高校应届毕业生人数', `roster_url` varchar(255) DEFAULT NULL COMMENT '花名册URL', `social_security_url` varchar(255) DEFAULT NULL COMMENT '社保情况URL', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_intellectual_property` -- DROP TABLE IF EXISTS `org_intellectual_property`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_intellectual_property` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `pid` varchar(36) DEFAULT NULL COMMENT '专利记录ID', `intellectual_property_number` varchar(32) DEFAULT NULL COMMENT '知识产权编号', `intellectual_property_name` varchar(32) DEFAULT NULL COMMENT '知识产权名称', `sort_number` varchar(36) DEFAULT NULL COMMENT '排序号', `catagory` int(2) DEFAULT NULL COMMENT '类别', `obtain_way` int(1) DEFAULT NULL COMMENT '获得方式', `authorization_number` varchar(32) DEFAULT NULL COMMENT '授权号', `authorization_date` datetime DEFAULT NULL COMMENT '授权日期', `evaluation_category` int(1) DEFAULT NULL COMMENT '0--Ⅰ类, 1--Ⅱ类', `property_right_url` varchar(255) DEFAULT NULL COMMENT '知识产权证书URL', `type` int(1) DEFAULT NULL COMMENT '知识产权类型(0--非系统申请知识产权,1--专利,2--软著)', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `fk_org_intellectual_property_user1_idx` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_ratepay` -- DROP TABLE IF EXISTS `org_ratepay`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_ratepay` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `operating_income` decimal(8,2) DEFAULT NULL COMMENT '营业收入(万元)', `management_cost` decimal(8,2) DEFAULT NULL COMMENT '管理费用(万元)', `operating_profit` decimal(8,2) DEFAULT NULL COMMENT '营业利润(万元)', `non_operating_income` decimal(8,2) DEFAULT NULL COMMENT '营业外收入(万元)', `non_taxable_income` decimal(8,2) DEFAULT NULL COMMENT '不征税收入(万元)', `tax_exempt_income` decimal(8,2) DEFAULT NULL COMMENT '免税收入(万元)', `subsidy_income` decimal(8,2) DEFAULT NULL COMMENT '政府补助收入(万元)', `gross_profit` decimal(8,2) DEFAULT NULL COMMENT '利润总额(万元)', `research_cost` decimal(8,2) DEFAULT NULL COMMENT '研发费用(万元)', `year` int(4) DEFAULT NULL COMMENT '年份', `tax_return_url` varchar(255) DEFAULT NULL COMMENT '纳税申报表url', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `fk_org_ratepay_user1_idx` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_standard` -- DROP TABLE IF EXISTS `org_standard`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_standard` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `standard_name` varchar(32) DEFAULT NULL COMMENT '标准名称', `standard_number` varchar(36) DEFAULT NULL COMMENT '标准编号', `standard_level` int(1) DEFAULT NULL COMMENT '标准级别', `participate_way` int(1) DEFAULT NULL COMMENT '参与方式', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `year` int(4) DEFAULT NULL COMMENT '标准指定年份', `enclosure_url` varchar(255) DEFAULT NULL COMMENT '附件URL', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_tech_achievement` -- DROP TABLE IF EXISTS `org_tech_achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_tech_achievement` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `achievement_name` varchar(32) DEFAULT NULL COMMENT '成果名称', `source` varchar(36) DEFAULT NULL COMMENT '来源', `conversion_form` int(1) DEFAULT NULL COMMENT '转化形式', `conversion_result` varchar(255) DEFAULT NULL COMMENT '转化结果', `year` int(4) DEFAULT NULL COMMENT '转化年份', `enclosure_url` varchar(255) DEFAULT NULL COMMENT '证明材料附件URL', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `fk_org_tech_achievment_user1_idx` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_tech_center` -- DROP TABLE IF EXISTS `org_tech_center`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_tech_center` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `center_name` varchar(36) DEFAULT NULL COMMENT '技术中心名称', `founding_time` datetime DEFAULT NULL COMMENT '成立时间', `principal` varchar(32) DEFAULT NULL COMMENT '负责人', `system_catalog` longtext COMMENT '制度目录', `comment` varchar(1000) DEFAULT NULL, `system_url` varchar(255) DEFAULT NULL COMMENT '制度目录URL', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `fk_org_tech_center_user1_idx` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_tech_center_detail` -- DROP TABLE IF EXISTS `org_tech_center_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_tech_center_detail` ( `id` varchar(36) NOT NULL, `cid` varchar(36) NOT NULL, `project_time` datetime DEFAULT NULL COMMENT '产学研时间', `project_name` varchar(32) DEFAULT NULL COMMENT '产学研名称', `term_start_time` datetime DEFAULT NULL COMMENT '期限开始时间', `term_end_time` datetime DEFAULT NULL COMMENT '期限结束时间', `institution` varchar(32) DEFAULT NULL COMMENT '大学机构', `protocol_url` varchar(255) DEFAULT NULL COMMENT '协议URL', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', PRIMARY KEY (`id`), KEY `fk_org_tech_center_detail_org_tech_center1_idx` (`cid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `org_tech_product` -- DROP TABLE IF EXISTS `org_tech_product`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `org_tech_product` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `serial_number` varchar(32) DEFAULT NULL COMMENT '编号', `product_name` varchar(32) DEFAULT NULL COMMENT '产品名称', `technical_field1` int(3) DEFAULT NULL COMMENT '技术领域1st select', `technical_field2` int(3) DEFAULT NULL COMMENT '技术领域2nd select', `technical_field3` int(3) DEFAULT NULL COMMENT '技术领域3rd select', `technical_source` int(1) DEFAULT NULL COMMENT '技术来源', `last_year_revenue` decimal(8,2) DEFAULT NULL COMMENT '上年度销售收入(万元)', `main_product` int(1) DEFAULT NULL COMMENT '是否是主要产品(服务)', `intellectual_property_number` varchar(500) DEFAULT NULL COMMENT '知识产权编号', `key_technology` varchar(500) DEFAULT NULL COMMENT '关键技术及主要技术指标', `competitive_edge` varchar(500) DEFAULT NULL COMMENT '与同类产品(服务)的竞争优势', `condition_effect` varchar(500) DEFAULT NULL COMMENT '知识产权获得情况及其对产品(服务)在技术上发挥的支持作用', `year` int(6) DEFAULT NULL COMMENT '年份', `create_time` datetime DEFAULT NULL COMMENT '记录创建时间', `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记', `account_url` varchar(255) DEFAULT NULL COMMENT '台帐URL', PRIMARY KEY (`id`), KEY `fk_org_tech_product_user1_idx` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `organization_identity` -- DROP TABLE IF EXISTS `organization_identity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `organization_identity` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `contacts` varchar(16) DEFAULT NULL COMMENT '联系人', `contact_mobile` varchar(16) DEFAULT NULL COMMENT '联系方式', `fixed_tel` varchar(16) DEFAULT NULL COMMENT '固定电话', `qq` varchar(16) DEFAULT NULL COMMENT 'QQ号', `postal_address` varchar(255) DEFAULT NULL COMMENT '通讯地址', `postcode` varchar(8) DEFAULT NULL COMMENT '邮政编码', `unit_name` varchar(45) DEFAULT NULL COMMENT '单位名称', `registered_capital` decimal(8,2) DEFAULT NULL COMMENT '注册资金', `licence_number` varchar(32) DEFAULT NULL COMMENT '营业执照注册号', `licence_province` int(2) DEFAULT NULL COMMENT '营业执照所在地--省', `licence_city` int(3) DEFAULT NULL COMMENT '营业执照所在地-市', `licence_area` int(4) DEFAULT NULL COMMENT '营业执照所在地-区(县)', `licence_scanning_url` varchar(255) DEFAULT NULL COMMENT '营业执照副本扫描件URL', `org_code` varchar(32) DEFAULT NULL COMMENT '组织机构代码证号码', `org_code_url` varchar(255) DEFAULT NULL COMMENT '组织机构代码证URL', `bank_account` varchar(32) DEFAULT NULL COMMENT '银行账号', `banks` varchar(32) DEFAULT NULL COMMENT '开户行', `bank_branch` varchar(32) DEFAULT NULL COMMENT '开户行支行', `bank_card_number` varchar(32) DEFAULT NULL COMMENT '银行卡号', `validation_amount` decimal(6,4) DEFAULT '0.0000' COMMENT '打入账内信息', `identity_type` int(1) DEFAULT NULL COMMENT '身份类型', `location_province` int(2) DEFAULT NULL COMMENT '开户行所在地-省', `location_city` int(3) DEFAULT NULL COMMENT '开户行所在地-市', `location_area` int(4) DEFAULT NULL COMMENT '开户行所在地-区(县)', `legal_person` varchar(16) DEFAULT NULL COMMENT '法人', `legal_person_id_card` varchar(32) DEFAULT NULL COMMENT '法人身份证号', `last_year_tax_report_url` varchar(255) DEFAULT NULL COMMENT '上年度纳税报表', `audit_status` int(1) DEFAULT '0' COMMENT '审核状态', `process` int(1) DEFAULT '0' COMMENT '实名认证流程', `wrong_count` int(1) DEFAULT '0' COMMENT '输入打款金额错误次数', `payment_date` datetime DEFAULT NULL COMMENT '打款日期', `first_contacts` varchar(16) DEFAULT NULL, `first_mobile` varchar(16) DEFAULT NULL, `second_contacts` varchar(16) DEFAULT NULL, `second_mobile` varchar(16) DEFAULT NULL, `third_contacts` varchar(16) DEFAULT NULL, `third_mobile` varchar(16) DEFAULT NULL, `listed` int(1) DEFAULT NULL COMMENT '是否上市', `listed_date` datetime DEFAULT NULL COMMENT '上市时间', `listed_type` int(1) DEFAULT NULL COMMENT '上市类型', `stock_code` varchar(32) DEFAULT NULL COMMENT '股票代码', `certificate_number` varchar(36) DEFAULT NULL COMMENT '高企认定证书编号', `issuing_date` datetime DEFAULT NULL COMMENT '高企认定发证日期', `cog_contacts` int(1) DEFAULT NULL COMMENT '高企认定联系人及联系方式', `tech_principal` varchar(36) DEFAULT NULL COMMENT '高企技术负责人', `contacts_fixed_tel` varchar(16) DEFAULT NULL COMMENT '联系人固定电话', `contacts_fax` varchar(16) DEFAULT NULL COMMENT '联系人传真', `legal_person_tel` varchar(16) DEFAULT NULL COMMENT '法人电话', `legal_person_fax` varchar(16) DEFAULT NULL COMMENT '法人传真', `legal_person_email` varchar(128) DEFAULT NULL COMMENT '法人Email', `registration_time` datetime DEFAULT NULL COMMENT '注册时间', `ratepay_code` varchar(36) DEFAULT NULL COMMENT '税务登记号', `industry` int(2) DEFAULT NULL COMMENT '所属行业', `enterprise_scale` int(1) DEFAULT NULL COMMENT '企业规模', `register_type` varchar(8) DEFAULT NULL COMMENT '注册类型', `foreign_investment` varchar(32) DEFAULT NULL COMMENT '外资来源地', `field` varchar(16) DEFAULT NULL COMMENT '领域', `tax_authority` int(1) DEFAULT NULL COMMENT '企业所得税主管税务机关(0--国税,1--地税)', `ratepay_method` int(1) DEFAULT NULL COMMENT '企业所得税征收方式(0--查账征收,1--核定征收)', `high_tech_zone` int(1) DEFAULT NULL COMMENT '是否属于国家级高新区内企业(0--否,1--是)', `risk_investment` int(1) DEFAULT NULL COMMENT '是否引入风险投资(0--否,1--是)', `business_scope` varchar(400) DEFAULT NULL COMMENT '经营范围', `high_tech_name` varchar(32) DEFAULT NULL COMMENT '国家级高新区名称', `patent_prory_statement_url` varchar(255) DEFAULT NULL COMMENT '专利代理委托书URL', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `organization_info` -- DROP TABLE IF EXISTS `organization_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `organization_info` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `identity_type` varchar(6) DEFAULT NULL COMMENT '身份类型', `company_name` varchar(45) DEFAULT NULL COMMENT '公司名称', `location_province` int(2) DEFAULT NULL COMMENT '所在地-省份', `location_city` int(3) DEFAULT NULL COMMENT '所在地--市', `location_area` int(4) DEFAULT NULL COMMENT '所在地--区', `unit_size` varchar(12) DEFAULT NULL COMMENT '单位规模', `company_introduction` varchar(1002) DEFAULT NULL COMMENT '单位简介', `home_unit` varchar(45) DEFAULT NULL COMMENT '所属单位', `logo_url` varchar(255) DEFAULT NULL COMMENT 'logo图', `publicity_picture_url` varchar(1000) DEFAULT NULL COMMENT '宣传图片', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `organization_properties` -- DROP TABLE IF EXISTS `organization_properties`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `organization_properties` ( `id` varchar(36) NOT NULL, `oid` varchar(36) NOT NULL, `qualification` varchar(45) DEFAULT NULL COMMENT '企业资质', `turnover` int(8) DEFAULT NULL COMMENT '年营业额', `college_attribute` varchar(45) DEFAULT NULL COMMENT '院校属性', `college_establish_time` varchar(12) DEFAULT NULL COMMENT '院校创办时间', `academician` int(5) DEFAULT NULL COMMENT '院士', `doctoral_tutor` int(5) DEFAULT NULL COMMENT '博士生导师', `master_tutor` int(5) DEFAULT NULL COMMENT '硕士生导师', `other_expert` int(5) DEFAULT NULL COMMENT '其他专家', `national_lab` int(5) DEFAULT NULL COMMENT '国家重点实验室', `education_lab` int(5) DEFAULT NULL COMMENT '教育部重点实验室', `enterprise_center` int(5) DEFAULT NULL COMMENT '企业共建研究中心', `other_center` int(5) DEFAULT NULL COMMENT '其他研究中心', `institution_establish_time` varchar(12) DEFAULT NULL COMMENT '研究机构创办时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `organization_tech` -- DROP TABLE IF EXISTS `organization_tech`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `organization_tech` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `technical_people_num` varchar(12) DEFAULT NULL COMMENT '技术人员数量', `search_area_category` varchar(255) DEFAULT NULL COMMENT '重点研究领域类别', `search_area_det` varchar(32) DEFAULT NULL COMMENT '重点研究领域明细', `specialty` varchar(32) DEFAULT NULL COMMENT '擅长领域', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `patent_cost` -- DROP TABLE IF EXISTS `patent_cost`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `patent_cost` ( `id` varchar(36) NOT NULL, `pid` varchar(36) NOT NULL, `annual_fee` int(6) DEFAULT NULL COMMENT '年登印费', `annual_fee_state` int(1) DEFAULT '0' COMMENT '年登印费缴费状态', `application_fee` int(6) DEFAULT NULL COMMENT '申请费', `trial_fee` int(6) DEFAULT NULL COMMENT '实审费', `printing_fee` int(6) DEFAULT NULL COMMENT '文印费', `funds` int(1) DEFAULT NULL COMMENT '是否请款', `reimbursement` int(1) DEFAULT NULL COMMENT '是否报销', `payment_state` int(1) DEFAULT '0' COMMENT '缴费状态', PRIMARY KEY (`id`), KEY `fk_patent_cost_patent_info1_idx` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `patent_info` -- DROP TABLE IF EXISTS `patent_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `patent_info` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL DEFAULT '', `contract_id` varchar(36) DEFAULT NULL COMMENT '合同ID', `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号', `patent_number` varchar(20) DEFAULT NULL COMMENT '申请号/专利号', `patent_name` varchar(64) DEFAULT NULL COMMENT '专利名称', `patent_catagory` int(1) DEFAULT NULL COMMENT '专利类型', `patent_state` int(2) DEFAULT NULL COMMENT '专利状态', `patent_field` int(2) DEFAULT NULL COMMENT '专利领域', `patent_des` varchar(128) DEFAULT NULL COMMENT '专利简介', `patent_prory_statement_url` varchar(255) DEFAULT NULL COMMENT '专利代理委托书', `patent_writing_url` varchar(255) DEFAULT NULL COMMENT '专利稿件', `authorization_notice_url` varchar(255) DEFAULT NULL COMMENT '授权通知书', `patent_certificate_url` varchar(255) DEFAULT NULL COMMENT '专利证书', `patent_application_date` datetime DEFAULT NULL COMMENT '申请日/受理日', `first_inventor_name` varchar(32) DEFAULT NULL COMMENT '第一发明人', `first_inventor_nationality` varchar(16) DEFAULT NULL COMMENT '第一发明人国籍', `first_inventor_id_number` varchar(18) DEFAULT NULL COMMENT '第一发明人身份证号', `first_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第一发明人是否公布(0--不公布,1--公布)', `second_inventor_name` varchar(32) DEFAULT NULL COMMENT '第二发明人姓名', `second_inventor_nationality` varchar(16) DEFAULT NULL COMMENT '第二发明人国际', `second_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第二发明人是否公布(0--不公布,1--公布)', `third_inventor_name` varchar(32) DEFAULT NULL COMMENT '第三发明人姓名', `third_inventor_nationality` varchar(12) DEFAULT NULL COMMENT '第三发明人国籍', `third_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第三发明人是否公布(0--不公布,1--公布)', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `author` varchar(36) DEFAULT NULL COMMENT '专利资料撰写人', `authorized_date` datetime DEFAULT NULL COMMENT '授权日/发文日', `office` varchar(16) DEFAULT NULL COMMENT '事务所', `principal` varchar(36) DEFAULT NULL COMMENT '负责人', `confirm_state` int(1) DEFAULT '0' COMMENT '用户确认申报材料', `record_time` datetime DEFAULT NULL COMMENT '发文日期时间', `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记', `contacts` int(1) DEFAULT NULL COMMENT '联系人及联系方式', `founder` varchar(36) DEFAULT NULL COMMENT '申请创建人ID', PRIMARY KEY (`id`), KEY `serialNumber_UNIQUE` (`serial_number`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=60000046 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `patent_log` -- DROP TABLE IF EXISTS `patent_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `patent_log` ( `id` varchar(36) NOT NULL, `pid` varchar(36) NOT NULL, `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间', `state` int(2) DEFAULT NULL COMMENT '专利状态', `principal` varchar(36) DEFAULT NULL COMMENT '负责人', `operator` varchar(36) DEFAULT NULL COMMENT '操作人', `comment` varchar(128) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`), KEY `fk_patent_log_patent_info1_idx` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `patent_registration` -- DROP TABLE IF EXISTS `patent_registration`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `patent_registration` ( `id` varchar(36) NOT NULL, `pid` varchar(36) NOT NULL, `acceptance_receive_time` datetime DEFAULT NULL COMMENT '受理通知书收到时间', `acceptance_issue_time` datetime DEFAULT NULL COMMENT '受理通知书发出时间', `acceptance_tracking_number` varchar(16) DEFAULT NULL COMMENT '受理通知书发出快递单号', `acceptance_express_company` varchar(8) DEFAULT NULL COMMENT '受理通知书快递公司', `authorization_receive_time` datetime DEFAULT NULL COMMENT '授权通知书收到时间', `authorization_issue_time` datetime DEFAULT NULL COMMENT '授权通知书发出时间', `authorization_tracking_number` varchar(16) DEFAULT NULL COMMENT '授权通知书快递单号', `authorization_express_company` varchar(8) DEFAULT NULL COMMENT '授权通知书快递公司', `certificate_recieve_time` datetime DEFAULT NULL COMMENT '专利证书收到时间', `certificate_issue_time` datetime DEFAULT NULL COMMENT '专利证书发出时间', `certificate_tracking_number` varchar(16) DEFAULT NULL COMMENT '专利证书快递单号', `certificate_express_company` varchar(8) DEFAULT NULL COMMENT '专利证书快递公司', PRIMARY KEY (`id`), KEY `fk_table1_patent_info1_idx` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `permission` -- DROP TABLE IF EXISTS `permission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `permission` ( `id` varchar(36) NOT NULL, `url` varchar(128) NOT NULL COMMENT '权限对应的url path', `name` varchar(45) DEFAULT NULL COMMENT '权限名字', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `role` -- DROP TABLE IF EXISTS `role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role` ( `id` varchar(36) NOT NULL, `role_name` varchar(16) DEFAULT NULL, `role_type` int(6) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `role_permission` -- DROP TABLE IF EXISTS `role_permission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role_permission` ( `rid` varchar(36) NOT NULL, `pid` varchar(36) NOT NULL, PRIMARY KEY (`rid`,`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sys_dict` -- DROP TABLE IF EXISTS `sys_dict`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sys_dict` ( `id` varchar(36) NOT NULL, `value` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tech_project` -- DROP TABLE IF EXISTS `tech_project`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tech_project` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `contract_id` varchar(36) DEFAULT NULL COMMENT '合同ID', `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号', `contacts` int(1) DEFAULT NULL COMMENT '联系人', `department` varchar(45) DEFAULT NULL COMMENT '科技项目申报部门', `dispatch_info` varchar(128) DEFAULT NULL COMMENT '派单信息', `project_name` varchar(45) DEFAULT NULL COMMENT '项目名称', `project_catagory` varchar(45) DEFAULT NULL COMMENT '项目类型', `tech_field` varchar(45) DEFAULT NULL COMMENT '技术领域', `project_des` varchar(600) DEFAULT NULL COMMENT '项目简介', `project_mode` int(1) DEFAULT NULL COMMENT '是否立项', `project_approval` decimal(8,2) DEFAULT NULL COMMENT '立项金额', `subsidy` int(1) DEFAULT NULL COMMENT '是否补助', `consultant` varchar(36) DEFAULT NULL COMMENT '咨询师', `approval_url` varchar(255) DEFAULT NULL COMMENT '项目材料URL', `state` int(2) DEFAULT NULL COMMENT '科技项目状态', `create_time` datetime DEFAULT NULL COMMENT '派单日', `accept_date` datetime DEFAULT NULL COMMENT '受理日', `approved_date` datetime DEFAULT NULL COMMENT '项目批复日期', `record_time` datetime DEFAULT NULL COMMENT '记录创建日期', `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记', `founder` varchar(36) DEFAULT NULL COMMENT '申请创建人ID', `principal` varchar(36) DEFAULT NULL COMMENT '负责人', PRIMARY KEY (`id`), KEY `serialNumber` (`serial_number`) ) ENGINE=InnoDB AUTO_INCREMENT=600050 DEFAULT CHARSET=utf8 COMMENT='科技项目申请表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tech_project_log` -- DROP TABLE IF EXISTS `tech_project_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tech_project_log` ( `id` varchar(36) NOT NULL, `pid` varchar(36) NOT NULL, `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间', `state` int(2) DEFAULT NULL COMMENT '科技项目状态状态', `principal` varchar(36) DEFAULT NULL COMMENT '负责人', `operator` varchar(36) DEFAULT NULL COMMENT '操作人', `comment` varchar(128) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技项目申报log'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tech_website` -- DROP TABLE IF EXISTS `tech_website`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tech_website` ( `id` varchar(36) NOT NULL, `uid` varchar(36) DEFAULT NULL, `department` varchar(45) DEFAULT NULL COMMENT '科技部门名称', `website` varchar(255) DEFAULT NULL COMMENT '网址', `account_number` varchar(45) DEFAULT NULL COMMENT '帐号', `password` varchar(32) DEFAULT NULL COMMENT '密码', `create_time` datetime DEFAULT NULL COMMENT '创建日期', `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技项目申报网址'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user` ( `id` varchar(36) NOT NULL, `mobile` varchar(12) NOT NULL COMMENT '用户注册手机号,作为登录依据', `password` varchar(32) NOT NULL COMMENT '密码,md5+salt', `nickname` varchar(16) DEFAULT NULL COMMENT '用户昵称', `email` varchar(255) DEFAULT NULL COMMENT '用户邮箱', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间', `number` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户编号', `lvl` int(2) DEFAULT '0', `type` int(1) NOT NULL DEFAULT '0' COMMENT '个人账号还是组织账号\n默认0为个人账号,1为组织账号', `aid` varchar(36) DEFAULT NULL COMMENT '管理员ID', `mid` varchar(36) DEFAULT NULL COMMENT '客户经理ID', PRIMARY KEY (`id`), UNIQUE KEY `number_UNIQUE` (`number`) USING HASH ) ENGINE=InnoDB AUTO_INCREMENT=800032 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_ability` -- DROP TABLE IF EXISTS `user_ability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_ability` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `ability_label` varchar(255) DEFAULT NULL COMMENT '能力标签', `intellect_right` varchar(500) DEFAULT NULL COMMENT '知识产权对企业竞争力的作用 ', `science_achievement` varchar(500) DEFAULT NULL COMMENT ' 科技成果转化情况', `research_innovation` varchar(500) DEFAULT NULL COMMENT '研究开发与技术创新组织管理情况', `personnel` varchar(500) DEFAULT NULL COMMENT ' 管理与科技人员情况', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_career` -- DROP TABLE IF EXISTS `user_career`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_career` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `engaged_field` varchar(255) DEFAULT NULL COMMENT '从事领域', `working_age` varchar(3) DEFAULT NULL COMMENT '从业工龄', `professional_title` varchar(45) DEFAULT NULL COMMENT '职称名字', `professional_title_gettime` varchar(6) DEFAULT NULL COMMENT '职称取得时间(年份)', `professional_certificate_url` varchar(255) DEFAULT NULL COMMENT '职称证明图', `qualification` varchar(45) DEFAULT NULL COMMENT '执业资格', `qualification_gettime` varchar(6) DEFAULT NULL COMMENT '执业资格取得时间(年份)', `qualification_certificate_url` varchar(255) DEFAULT NULL COMMENT '执业资格证明图', `work_unit` varchar(32) DEFAULT NULL COMMENT '工作单位', `position` varchar(16) DEFAULT NULL COMMENT '职位/职务/头衔', `experiences` varchar(1000) DEFAULT NULL COMMENT '从业经历', `achievement` varchar(1000) DEFAULT NULL COMMENT '主要成就', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_edu` -- DROP TABLE IF EXISTS `user_edu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_edu` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `education` varchar(16) DEFAULT NULL COMMENT '学历', `major_category` varchar(8) DEFAULT NULL COMMENT '专业类别', `major_name` varchar(16) DEFAULT NULL COMMENT '专业名称', `graduate_school` varchar(45) DEFAULT NULL COMMENT '毕业学校', `graduation_time_year` varchar(4) DEFAULT NULL COMMENT '毕业时间(年份)', `graduation_time_month` varchar(2) DEFAULT NULL COMMENT '毕业时间--月', `graduation_time_day` varchar(2) DEFAULT NULL COMMENT '毕业时间--日', `diploma_url` varchar(255) DEFAULT NULL COMMENT '毕业证图', `diploma_code` varchar(32) DEFAULT NULL COMMENT '毕业证编号', `degree_diploma_url` varchar(255) DEFAULT NULL COMMENT '学位证明图', `degree_code` varchar(32) DEFAULT NULL COMMENT '学位证编号', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_identity` -- DROP TABLE IF EXISTS `user_identity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_identity` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `username` varchar(16) DEFAULT NULL COMMENT '姓名', `sex` varchar(2) DEFAULT NULL COMMENT '性别', `date_of_birth_year` varchar(4) DEFAULT NULL COMMENT '出生年', `date_of_birth_month` varchar(2) DEFAULT NULL COMMENT '出生月', `id_number` varchar(20) DEFAULT NULL COMMENT '省份证号码', `positive_id_url` varchar(255) DEFAULT NULL COMMENT '身份证正面照', `opposite_id_url` varchar(255) DEFAULT NULL COMMENT '身份证反面照', `province` int(2) DEFAULT NULL COMMENT '所在地-省份', `city` int(3) DEFAULT NULL COMMENT '所在地--市', `area` int(4) DEFAULT NULL COMMENT '所在地--区', `contact_mobile` varchar(16) DEFAULT NULL COMMENT '联系方式', `bank_name` varchar(32) DEFAULT NULL COMMENT '银行开户名', `bank_account` varchar(32) DEFAULT NULL COMMENT '开户银行', `bank_card_number` varchar(32) DEFAULT NULL COMMENT '银行卡号', `amount_money` decimal(6,4) DEFAULT NULL COMMENT '打款金额', `audit_status` int(1) DEFAULT '0' COMMENT '审核状态(0--未提交审核,1-提交审核,2-审核未打款,3-审核已打款,4-审核未通过,5-审核通过)', `process` int(1) DEFAULT '0' COMMENT '实名认证流程', `wrong_count` int(1) DEFAULT '0' COMMENT '输入打款金额错误次数', `payment_date` datetime DEFAULT NULL COMMENT '打款日期', `expert` int(1) DEFAULT NULL COMMENT '专家(0--否,1--是)', `celebrity` int(1) DEFAULT NULL COMMENT '明星(0--否,1--是)', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_info` -- DROP TABLE IF EXISTS `user_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_info` ( `id` varchar(36) NOT NULL, `uid` varchar(36) NOT NULL, `residence_province` int(2) DEFAULT NULL COMMENT '居住地--省', `residence_city` int(3) DEFAULT NULL COMMENT '居住地--市', `residence_area` int(4) DEFAULT NULL COMMENT '居住地--区', `person_portrait_url` varchar(255) DEFAULT NULL COMMENT '个人头像', `life_photo_url` varchar(255) DEFAULT NULL COMMENT '生活照', `personal_profile` varchar(1000) DEFAULT NULL COMMENT '个人简介', `fixed_tel_area` varchar(8) DEFAULT NULL COMMENT '固定电话 区号', `fixed_tel` varchar(12) DEFAULT NULL COMMENT '固定电话', `fixed_tel_extension` varchar(8) DEFAULT NULL COMMENT '固定电话分机号', `qq` varchar(16) DEFAULT NULL COMMENT 'QQ号码', `postal_address` varchar(255) DEFAULT NULL COMMENT '通讯地址', `postcode` varchar(8) DEFAULT NULL COMMENT '邮政编码', PRIMARY KEY (`id`), KEY `user_id_idx` (`uid`), CONSTRAINT `uid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_interest` -- DROP TABLE IF EXISTS `user_interest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_interest` ( `id` varchar(36) NOT NULL, `from_uid` varchar(36) NOT NULL COMMENT '关注发起用户ID', `to_uid` varchar(36) NOT NULL COMMENT '被关注用户ID', `create_time` datetime NOT NULL COMMENT '关注时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户关注'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_role` -- DROP TABLE IF EXISTS `user_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_role` ( `uid` varchar(36) NOT NULL, `rid` varchar(36) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `value_evaluation` -- DROP TABLE IF EXISTS `value_evaluation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `value_evaluation` ( `id` bigint(18) NOT NULL, `uid` varchar(36) DEFAULT NULL COMMENT '用户id', `create_time` datetime NOT NULL DEFAULT current_timestamp() COMMENT '创建时间', `name` varchar(128) DEFAULT NULL COMMENT '技术名称', `value` bigint(18) DEFAULT NULL COMMENT '评估值', `step` int(2) DEFAULT NULL COMMENT '当前步骤', `log` longtext DEFAULT NULL COMMENT '步骤记录', PRIMARY KEY (`id`), KEY `uid_index` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-06-21 20:13:48