| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682 |
- -- 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
|