init.sql 79 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684
  1. -- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
  2. --
  3. -- Host: 192.168.1.111 Database: aft_dev
  4. -- ------------------------------------------------------
  5. -- Server version 5.7.18-0ubuntu0.16.04.1
  6. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  7. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  8. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  11. /*!40103 SET TIME_ZONE='+00:00' */;
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16. --
  17. -- Table structure for table `achievement`
  18. --
  19. DROP TABLE IF EXISTS `achievement`;
  20. /*!40101 SET @saved_cs_client = @@character_set_client */;
  21. /*!40101 SET character_set_client = utf8 */;
  22. CREATE TABLE `achievement` (
  23. `id` varchar(36) NOT NULL,
  24. `serial_number` int(36) NOT NULL AUTO_INCREMENT COMMENT '编号',
  25. `data_category` int(1) NOT NULL COMMENT '数据类别 (0--成果, 1--技术, 2--项目)',
  26. `name` varchar(32) NOT NULL COMMENT '名称',
  27. `keyword` varchar(45) NOT NULL COMMENT '关键词',
  28. `category` int(1) NOT NULL COMMENT '类型(0--专利, 2--软著, 3--项目, 4--版权, 5--工业设计, 6--配方, 7--非标)',
  29. `summary` varchar(300) DEFAULT NULL COMMENT '摘要',
  30. `introduction` varchar(300) DEFAULT NULL COMMENT '成果简介',
  31. `technical_picture_url` varchar(500) DEFAULT NULL COMMENT '技术图片',
  32. `field_a` int(3) DEFAULT NULL COMMENT '应用领域1',
  33. `field_b` int(3) DEFAULT NULL COMMENT '应用领域2',
  34. `field_c` int(3) DEFAULT NULL COMMENT '应用领域3',
  35. `maturity` int(1) DEFAULT NULL COMMENT '成熟度(0--正在研发, 1-- 已有样品, 2-- 通过小试, 3-- 通过中试, 4-- 可以量产)',
  36. `maturity_picture_url` longtext COMMENT '成熟度资料--图片URL',
  37. `maturity_text_file_url` varchar(255) DEFAULT NULL COMMENT '成熟度资料--文本文件URL',
  38. `maturity_video_url` varchar(255) DEFAULT NULL COMMENT '成熟度资料--视屏URL',
  39. `innovation` int(1) DEFAULT NULL COMMENT '创新度(0--行业先进,1--行业领先,2--国内先进,3--国内领先,4--国际先进,5--国际领先)',
  40. `owner_id` varchar(36) DEFAULT NULL COMMENT '所有人ID',
  41. `owner_name` varchar(32) DEFAULT NULL COMMENT '成果所有人名称',
  42. `owner_type` int(1) DEFAULT NULL COMMENT '所有人类型(0-个人,1-组织)',
  43. `owner_id_number` varchar(36) DEFAULT NULL COMMENT '所有人证件号',
  44. `owner_mobile` varchar(12) DEFAULT NULL COMMENT '所有人联系电话',
  45. `owner_email` varchar(255) DEFAULT NULL COMMENT '所有人电子邮箱',
  46. `owner_postal_address` varchar(255) DEFAULT NULL COMMENT '所有人通讯地址',
  47. `cooperation_mode` int(1) NOT NULL COMMENT '合作方式(0--技术转让,1--授权生产)',
  48. `transfer_mode` int(1) DEFAULT NULL COMMENT '转让方式(0--完全转让,1--许可转让,2--技术入股)',
  49. `bargaining_mode` int(1) DEFAULT NULL COMMENT '议价方式(0--面议,1--定价)',
  50. `transfer_price` decimal(8,2) DEFAULT NULL COMMENT '转让价格',
  51. `technical_scene` varchar(300) DEFAULT NULL COMMENT '技术场景',
  52. `breakthrough` varchar(300) DEFAULT NULL COMMENT '技术突破',
  53. `patent_case` varchar(300) DEFAULT NULL COMMENT '专利情况',
  54. `awards` varchar(300) DEFAULT NULL COMMENT '获奖情况',
  55. `team_des` varchar(300) DEFAULT NULL COMMENT '技术团队情况',
  56. `parameter` varchar(255) DEFAULT NULL COMMENT '技术参数',
  57. `tech_plan_url` varchar(255) DEFAULT NULL COMMENT '技术方案URL',
  58. `business_plan_url` varchar(255) DEFAULT NULL COMMENT '商业计划书URL',
  59. `org_id` varchar(36) DEFAULT NULL COMMENT '所属组织ID',
  60. `org_name` varchar(45) DEFAULT NULL COMMENT '所属组织名称',
  61. `org_address` varchar(255) DEFAULT NULL COMMENT '所属组织地址',
  62. `org_email` varchar(255) DEFAULT NULL COMMENT '所属组织邮箱',
  63. `org_contacts` varchar(45) DEFAULT NULL COMMENT '所属组织联系人名称',
  64. `org_contacts_mobile` varchar(45) DEFAULT NULL COMMENT '所属组织联系人电话',
  65. `contacts` int(1) DEFAULT NULL COMMENT '联系人及方式',
  66. `manager_id` varchar(36) DEFAULT NULL COMMENT '客户经理ID',
  67. `salesman_id` varchar(36) DEFAULT NULL COMMENT '营销员ID',
  68. `status` int(1) DEFAULT NULL COMMENT '状态',
  69. `create_time` datetime DEFAULT NULL COMMENT '成果记录创建时间',
  70. `release_status` int(1) DEFAULT NULL COMMENT '是否发布(0--未发布,1--已发布)',
  71. `release_date` datetime DEFAULT NULL COMMENT '发布时间',
  72. `deleted_sign` int(1) NOT NULL COMMENT '删除标记',
  73. `audit_status` int(1) DEFAULT NULL COMMENT '审核状态(0--未提交审核草稿,1,--提交审核,2--审核中,3--审核通过,4--审核未通过)',
  74. `tech_broker_id` varchar(36) DEFAULT NULL COMMENT '技术经纪人ID',
  75. PRIMARY KEY (`id`),
  76. KEY `serialNumber` (`serial_number`)
  77. ) ENGINE=InnoDB AUTO_INCREMENT=600063 DEFAULT CHARSET=utf8 COMMENT='技术成果';
  78. /*!40101 SET character_set_client = @saved_cs_client */;
  79. --
  80. -- Table structure for table `achievement_demand`
  81. --
  82. DROP TABLE IF EXISTS `achievement_demand`;
  83. /*!40101 SET @saved_cs_client = @@character_set_client */;
  84. /*!40101 SET character_set_client = utf8 */;
  85. CREATE TABLE `achievement_demand` (
  86. `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID',
  87. `demand_id` varchar(36) NOT NULL COMMENT '科技需求ID',
  88. PRIMARY KEY (`achievement_id`,`demand_id`)
  89. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果及科技需求匹配';
  90. /*!40101 SET character_set_client = @saved_cs_client */;
  91. --
  92. -- Table structure for table `achievement_demand_count`
  93. --
  94. DROP TABLE IF EXISTS `achievement_demand_count`;
  95. /*!40101 SET @saved_cs_client = @@character_set_client */;
  96. /*!40101 SET character_set_client = utf8 */;
  97. CREATE TABLE `achievement_demand_count` (
  98. `id` varchar(36) NOT NULL,
  99. `uid` varchar(36) NOT NULL COMMENT '用户ID',
  100. `achievement_count` int(4) DEFAULT NULL COMMENT '已发布科技成果数量',
  101. `demand_count` int(4) DEFAULT NULL COMMENT '已发布科技需求数量',
  102. PRIMARY KEY (`id`)
  103. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户已发布科技成果及已发布科技需求数量';
  104. /*!40101 SET character_set_client = @saved_cs_client */;
  105. --
  106. -- Table structure for table `achievement_interest`
  107. --
  108. DROP TABLE IF EXISTS `achievement_interest`;
  109. /*!40101 SET @saved_cs_client = @@character_set_client */;
  110. /*!40101 SET character_set_client = utf8 */;
  111. CREATE TABLE `achievement_interest` (
  112. `id` varchar(36) NOT NULL,
  113. `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID',
  114. `uid` varchar(36) NOT NULL COMMENT '感兴趣人ID',
  115. `create_time` datetime NOT NULL COMMENT '记录创建时间(关注时间)',
  116. PRIMARY KEY (`id`)
  117. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果"感兴趣(关注)"';
  118. /*!40101 SET character_set_client = @saved_cs_client */;
  119. --
  120. -- Table structure for table `achievement_keyword`
  121. --
  122. DROP TABLE IF EXISTS `achievement_keyword`;
  123. /*!40101 SET @saved_cs_client = @@character_set_client */;
  124. /*!40101 SET character_set_client = utf8 */;
  125. CREATE TABLE `achievement_keyword` (
  126. `id` varchar(36) NOT NULL,
  127. `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID',
  128. `keyword` varchar(16) NOT NULL COMMENT '科技成果关键词',
  129. PRIMARY KEY (`id`)
  130. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果关键词';
  131. /*!40101 SET character_set_client = @saved_cs_client */;
  132. --
  133. -- Table structure for table `achievement_order`
  134. --
  135. DROP TABLE IF EXISTS `achievement_order`;
  136. /*!40101 SET @saved_cs_client = @@character_set_client */;
  137. /*!40101 SET character_set_client = utf8 */;
  138. CREATE TABLE `achievement_order` (
  139. `id` varchar(36) NOT NULL,
  140. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号',
  141. `achievement_id` varchar(36) NOT NULL COMMENT '科技成果ID',
  142. `uid` varchar(36) DEFAULT NULL COMMENT '购买科技成果人ID',
  143. `create_time` datetime DEFAULT NULL COMMENT '购买时间',
  144. `status` int(1) DEFAULT NULL COMMENT '流程变动(0--初始意向,1--意向金,2--签订合同,3--合同金,4--佣金,5--服务金,6--关闭(未签合同),7--关闭(已签合同))',
  145. `intention_money` int(8) DEFAULT NULL COMMENT '意向金',
  146. `contract_money` int(8) DEFAULT NULL COMMENT '合同金',
  147. `commission` int(8) DEFAULT NULL COMMENT '佣金',
  148. `service_money` int(8) DEFAULT NULL COMMENT '服务金',
  149. `refund` int(1) DEFAULT NULL COMMENT '是否退款(0--未退款,1--已退款)',
  150. `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记(0--未删除,1--已删除)',
  151. PRIMARY KEY (`id`),
  152. KEY `serialNumber` (`serial_number`)
  153. ) ENGINE=InnoDB AUTO_INCREMENT=600005 DEFAULT CHARSET=utf8 COMMENT='科技成果意向单/交易单';
  154. /*!40101 SET character_set_client = @saved_cs_client */;
  155. --
  156. -- Table structure for table `achievement_order_log`
  157. --
  158. DROP TABLE IF EXISTS `achievement_order_log`;
  159. /*!40101 SET @saved_cs_client = @@character_set_client */;
  160. /*!40101 SET character_set_client = utf8 */;
  161. CREATE TABLE `achievement_order_log` (
  162. `id` varchar(36) NOT NULL,
  163. `achievement_order_id` varchar(36) DEFAULT NULL COMMENT '科技成果订单ID',
  164. `record_time` datetime DEFAULT NULL,
  165. `status` int(1) DEFAULT NULL COMMENT '状态',
  166. `operator` varchar(36) DEFAULT NULL COMMENT '记录操作人',
  167. `comment` varchar(128) DEFAULT NULL COMMENT '备注',
  168. PRIMARY KEY (`id`)
  169. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技成果意向单/交易单log';
  170. /*!40101 SET character_set_client = @saved_cs_client */;
  171. --
  172. -- Table structure for table `admin`
  173. --
  174. DROP TABLE IF EXISTS `admin`;
  175. /*!40101 SET @saved_cs_client = @@character_set_client */;
  176. /*!40101 SET character_set_client = utf8 */;
  177. CREATE TABLE `admin` (
  178. `id` varchar(36) NOT NULL,
  179. `mobile` varchar(12) DEFAULT NULL COMMENT '手机号(登录帐号)',
  180. `name` varchar(16) DEFAULT NULL COMMENT '用户名',
  181. `password` varchar(32) DEFAULT NULL COMMENT '密码',
  182. `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  183. `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  184. `number` int(6) NOT NULL AUTO_INCREMENT,
  185. `province` varchar(12) DEFAULT NULL COMMENT '所在省份',
  186. `position` varchar(32) DEFAULT NULL COMMENT '职位',
  187. `superior_id` varchar(36) DEFAULT NULL COMMENT '上级管理用户ID',
  188. `city` varchar(16) DEFAULT NULL COMMENT '所在市',
  189. PRIMARY KEY (`id`),
  190. KEY `index_number` (`number`)
  191. ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
  192. /*!40101 SET character_set_client = @saved_cs_client */;
  193. --
  194. -- Table structure for table `admin_location`
  195. --
  196. DROP TABLE IF EXISTS `admin_location`;
  197. /*!40101 SET @saved_cs_client = @@character_set_client */;
  198. /*!40101 SET character_set_client = utf8 */;
  199. CREATE TABLE `admin_location` (
  200. `id` varchar(36) NOT NULL,
  201. `admin_id` varchar(36) NOT NULL COMMENT '管理员ID',
  202. `province` int(2) NOT NULL COMMENT '省份',
  203. `city` int(3) DEFAULT NULL COMMENT '市',
  204. PRIMARY KEY (`id`)
  205. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员地区';
  206. /*!40101 SET character_set_client = @saved_cs_client */;
  207. --
  208. -- Table structure for table `aft_file`
  209. --
  210. DROP TABLE IF EXISTS `aft_file`;
  211. /*!40101 SET @saved_cs_client = @@character_set_client */;
  212. /*!40101 SET character_set_client = utf8 */;
  213. CREATE TABLE `aft_file` (
  214. `id` varchar(36) NOT NULL,
  215. `uid` varchar(36) DEFAULT NULL COMMENT '用户id',
  216. `file_name` varchar(32) DEFAULT NULL COMMENT '文件名称',
  217. `file_path` varchar(255) NOT NULL COMMENT '文件路径',
  218. `sign` varchar(45) DEFAULT NULL COMMENT '模版标记',
  219. `comment` varchar(45) DEFAULT NULL COMMENT '备注',
  220. `deleleted_sign` int(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  221. PRIMARY KEY (`id`)
  222. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  223. /*!40101 SET character_set_client = @saved_cs_client */;
  224. --
  225. -- Table structure for table `contract`
  226. --
  227. DROP TABLE IF EXISTS `contract`;
  228. /*!40101 SET @saved_cs_client = @@character_set_client */;
  229. /*!40101 SET character_set_client = utf8 */;
  230. CREATE TABLE `contract` (
  231. `id` varchar(36) NOT NULL,
  232. `uid` varchar(36) NOT NULL,
  233. `contacts` int(1) DEFAULT NULL COMMENT '联系人',
  234. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '合同编号',
  235. `name` varchar(36) DEFAULT NULL COMMENT '合同名称(预留字段)',
  236. `type` int(1) DEFAULT NULL COMMENT '合同类型(1-专利类型合同,2-软著类型合同,3-高企认定类型合同,4-科技项目类型合同)',
  237. `sign_date` datetime DEFAULT NULL COMMENT '合同签订时间',
  238. `founder` varchar(36) DEFAULT NULL COMMENT '合同记录创建人',
  239. `depict` varchar(128) DEFAULT NULL COMMENT '合同描述',
  240. `status` int(1) DEFAULT NULL COMMENT '合同状态(0-草稿,1-签订,2-分发流转,3-完成(已结款))',
  241. `patent_num` int(2) DEFAULT NULL COMMENT '专利数量',
  242. `patent_status` int(1) DEFAULT NULL COMMENT '专利创建状态(0-未创建,1-已创建)',
  243. `copyright_num` int(2) DEFAULT NULL COMMENT '软著数量',
  244. `copyright_status` int(1) DEFAULT NULL COMMENT '软著创建状态(0-未创建,1-已创建)',
  245. `cognizance_year` int(4) DEFAULT NULL COMMENT '高企申请年份',
  246. `cognizance_status` int(1) DEFAULT NULL COMMENT '高企认定创建状态(1-未创建,1-已创建)',
  247. `tech_project_num` int(2) DEFAULT NULL COMMENT '科技项目数量',
  248. `tech_project_status` int(1) DEFAULT NULL COMMENT '科技项目创建状态(0-未创建,1-已创建)',
  249. `comment` varchar(45) DEFAULT NULL COMMENT '合同创建备注',
  250. `create_time` datetime DEFAULT NULL COMMENT '记录创建时间',
  251. `complete_date` datetime DEFAULT NULL COMMENT '合同完成(结款)日期',
  252. `deleted_sign` int(1) DEFAULT NULL,
  253. `previous_fee` varchar(8) DEFAULT NULL COMMENT '前期费用',
  254. PRIMARY KEY (`id`),
  255. KEY `serialNumber` (`serial_number`)
  256. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='合同';
  257. /*!40101 SET character_set_client = @saved_cs_client */;
  258. --
  259. -- Table structure for table `contract_log`
  260. --
  261. DROP TABLE IF EXISTS `contract_log`;
  262. /*!40101 SET @saved_cs_client = @@character_set_client */;
  263. /*!40101 SET character_set_client = utf8 */;
  264. CREATE TABLE `contract_log` (
  265. `id` varchar(36) NOT NULL,
  266. `cid` varchar(36) DEFAULT NULL COMMENT '合同表主键',
  267. `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间',
  268. `status` int(1) DEFAULT NULL COMMENT '状态',
  269. `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
  270. `operator` varchar(36) DEFAULT NULL COMMENT '操作人',
  271. `comment` varchar(128) DEFAULT NULL COMMENT '备注',
  272. PRIMARY KEY (`id`)
  273. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='合同日志';
  274. /*!40101 SET character_set_client = @saved_cs_client */;
  275. --
  276. -- Table structure for table `copyright_info`
  277. --
  278. DROP TABLE IF EXISTS `copyright_info`;
  279. /*!40101 SET @saved_cs_client = @@character_set_client */;
  280. /*!40101 SET character_set_client = utf8 */;
  281. CREATE TABLE `copyright_info` (
  282. `id` varchar(36) NOT NULL COMMENT '主键',
  283. `uid` varchar(36) NOT NULL COMMENT '用户主键',
  284. `contract_id` varchar(36) DEFAULT NULL COMMENT '合同ID',
  285. `serial_number` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  286. `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  287. `accept_time` datetime DEFAULT NULL COMMENT '受理时间',
  288. `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
  289. `contact` int(1) DEFAULT NULL COMMENT '联系人',
  290. `copyright_info` varchar(255) DEFAULT NULL COMMENT '软著简介',
  291. `copyright_name` varchar(60) DEFAULT NULL COMMENT '软著名字',
  292. `status` int(1) DEFAULT NULL COMMENT '申请状态',
  293. `work_issue` varchar(128) DEFAULT NULL COMMENT '派单信息',
  294. `comment` varchar(128) DEFAULT NULL COMMENT '备注',
  295. `outsource` varchar(60) DEFAULT NULL COMMENT '外包公司',
  296. `in_urgent` int(3) DEFAULT NULL COMMENT '加急天数',
  297. `authorized_date` datetime DEFAULT NULL COMMENT '下证日',
  298. `certificate_url` varchar(255) DEFAULT NULL COMMENT '证书附件地址',
  299. `application_url` varchar(255) DEFAULT NULL COMMENT '申请书附件地址',
  300. `delete_sign` int(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  301. `copyright_number` varchar(18) DEFAULT NULL,
  302. `founder` varchar(36) DEFAULT NULL COMMENT '申请创建人ID',
  303. PRIMARY KEY (`id`),
  304. UNIQUE KEY `serial_number_UNIQUE` (`serial_number`)
  305. ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;
  306. /*!40101 SET character_set_client = @saved_cs_client */;
  307. --
  308. -- Table structure for table `copyright_log`
  309. --
  310. DROP TABLE IF EXISTS `copyright_log`;
  311. /*!40101 SET @saved_cs_client = @@character_set_client */;
  312. /*!40101 SET character_set_client = utf8 */;
  313. CREATE TABLE `copyright_log` (
  314. `id` varchar(36) NOT NULL COMMENT '主键',
  315. `cid` varchar(36) NOT NULL COMMENT '软著申请id',
  316. `record_time` datetime DEFAULT NULL COMMENT '状态流转时间',
  317. `status` int(1) DEFAULT NULL COMMENT '状态',
  318. `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
  319. `operator` varchar(36) DEFAULT NULL COMMENT '操作人',
  320. `comment` varchar(128) DEFAULT NULL COMMENT '备注',
  321. `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '日志创建时间',
  322. PRIMARY KEY (`id`),
  323. KEY `fk_copyright_log_copyright_info1_idx` (`cid`)
  324. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  325. /*!40101 SET character_set_client = @saved_cs_client */;
  326. --
  327. -- Table structure for table `demand`
  328. --
  329. DROP TABLE IF EXISTS `demand`;
  330. /*!40101 SET @saved_cs_client = @@character_set_client */;
  331. /*!40101 SET character_set_client = utf8 */;
  332. CREATE TABLE `demand` (
  333. `id` varchar(36) NOT NULL,
  334. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号',
  335. `data_category` int(1) DEFAULT NULL COMMENT '数据类别(0-个人需求,1-单位需求)',
  336. `name` varchar(32) NOT NULL COMMENT '名称',
  337. `keyword` varchar(45) NOT NULL COMMENT '关键词',
  338. `info_sources` int(1) NOT NULL COMMENT '信息来源(0-平台采集,1-客户发布)',
  339. `industry_category_a` int(3) DEFAULT NULL COMMENT '行业类别下拉A',
  340. `industry_category_b` int(3) DEFAULT NULL COMMENT '行业类别下拉B',
  341. `industry_category_c` int(3) DEFAULT NULL COMMENT '行业类别下拉C',
  342. `demand_type` int(1) NOT NULL COMMENT '需求类型',
  343. `problem_des` varchar(256) NOT NULL COMMENT '问题说明',
  344. `technical_requirements` varchar(256) DEFAULT NULL COMMENT '技术指标要求',
  345. `picture_url` longtext COMMENT '需求文件--图片URL',
  346. `text_file_url` varchar(255) DEFAULT NULL COMMENT '需求文件--文本文件',
  347. `video_url` varchar(255) DEFAULT NULL COMMENT '需求文件--视屏文件URL',
  348. `fixed_budget` decimal(8,2) DEFAULT NULL COMMENT '固定预算',
  349. `fixed_cycle` varchar(12) DEFAULT NULL COMMENT '固定周期',
  350. `people_number` int(5) DEFAULT NULL COMMENT '固定人数',
  351. `fixed_scheme` varchar(200) DEFAULT NULL COMMENT '固定方案',
  352. `cost_escrow` decimal(8,2) DEFAULT NULL COMMENT '费用托管',
  353. `budget_cost` decimal(8,2) DEFAULT NULL COMMENT '预算费用',
  354. `validity_period` datetime DEFAULT NULL COMMENT '有效期限',
  355. `employer_id` varchar(36) DEFAULT NULL COMMENT '雇主客户ID',
  356. `employer_name` varchar(16) DEFAULT NULL COMMENT '雇主名称',
  357. `employer_address` varchar(128) DEFAULT NULL COMMENT '雇主地址',
  358. `employer_contacts` varchar(16) DEFAULT NULL COMMENT '雇主联系人名称',
  359. `employer_contacts_mobile` varchar(11) DEFAULT NULL COMMENT '雇主联系人电话',
  360. `employer_contacts_mailbox` varchar(255) DEFAULT NULL COMMENT '雇主联系人邮箱',
  361. `contacts` int(1) DEFAULT NULL COMMENT '联系人&联系方式',
  362. `status` int(1) DEFAULT NULL COMMENT '需求状态(0-进行中,1-未解决,2-已解决)',
  363. `release_status` int(1) DEFAULT NULL COMMENT '是否发布(0-未发布,1-发布)',
  364. `release_date` datetime DEFAULT NULL COMMENT '发布时间',
  365. `create_time` datetime DEFAULT NULL COMMENT '需求记录创建时间',
  366. `principal_id` varchar(36) DEFAULT NULL COMMENT '负责人(营销员)',
  367. `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记',
  368. `audit_status` int(1) DEFAULT NULL COMMENT '审核状态(0--未提交审核草稿,1--审核中,2--审核通过,3--审核未通过)',
  369. `tech_broker_id` varchar(36) DEFAULT NULL COMMENT '技术经纪人ID',
  370. PRIMARY KEY (`id`),
  371. KEY `serialNumber` (`serial_number`)
  372. ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='技术需求';
  373. /*!40101 SET character_set_client = @saved_cs_client */;
  374. --
  375. -- Table structure for table `demand_interest`
  376. --
  377. DROP TABLE IF EXISTS `demand_interest`;
  378. /*!40101 SET @saved_cs_client = @@character_set_client */;
  379. /*!40101 SET character_set_client = utf8 */;
  380. CREATE TABLE `demand_interest` (
  381. `id` varchar(36) NOT NULL,
  382. `demand_id` varchar(36) NOT NULL COMMENT '需求主键',
  383. `uid` varchar(36) NOT NULL COMMENT '关注人ID',
  384. `create_time` datetime NOT NULL COMMENT '关注时间',
  385. PRIMARY KEY (`id`)
  386. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技需求"感兴趣(关注)"';
  387. /*!40101 SET character_set_client = @saved_cs_client */;
  388. --
  389. -- Table structure for table `demand_keyword`
  390. --
  391. DROP TABLE IF EXISTS `demand_keyword`;
  392. /*!40101 SET @saved_cs_client = @@character_set_client */;
  393. /*!40101 SET character_set_client = utf8 */;
  394. CREATE TABLE `demand_keyword` (
  395. `id` varchar(36) NOT NULL,
  396. `demand_id` varchar(36) NOT NULL COMMENT '科技需求ID',
  397. `keyword` varchar(16) NOT NULL COMMENT '关键词',
  398. PRIMARY KEY (`id`)
  399. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技需求关键词';
  400. /*!40101 SET character_set_client = @saved_cs_client */;
  401. --
  402. -- Table structure for table `demand_log`
  403. --
  404. DROP TABLE IF EXISTS `demand_log`;
  405. /*!40101 SET @saved_cs_client = @@character_set_client */;
  406. /*!40101 SET character_set_client = utf8 */;
  407. CREATE TABLE `demand_log` (
  408. `id` varchar(36) NOT NULL,
  409. `demand_id` varchar(36) NOT NULL COMMENT '需求表主键',
  410. `status` int(1) NOT NULL COMMENT '状态',
  411. `operator` varchar(36) DEFAULT NULL COMMENT '操作人',
  412. `principal` varchar(36) DEFAULT NULL,
  413. `recored_time` datetime NOT NULL COMMENT '记录时间',
  414. `comment` varchar(128) DEFAULT NULL COMMENT '备注',
  415. PRIMARY KEY (`id`)
  416. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  417. /*!40101 SET character_set_client = @saved_cs_client */;
  418. --
  419. -- Table structure for table `demand_order`
  420. --
  421. DROP TABLE IF EXISTS `demand_order`;
  422. /*!40101 SET @saved_cs_client = @@character_set_client */;
  423. /*!40101 SET character_set_client = utf8 */;
  424. CREATE TABLE `demand_order` (
  425. `id` varchar(36) NOT NULL,
  426. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号',
  427. `demand_id` varchar(36) NOT NULL COMMENT '科技需求ID',
  428. `uid` varchar(36) DEFAULT NULL COMMENT '接单人ID',
  429. `create_time` datetime DEFAULT NULL COMMENT '接单时间',
  430. `enclosure_url` varchar(255) DEFAULT NULL COMMENT '附件URL',
  431. `status` int(1) DEFAULT NULL COMMENT '流程变动(0--初始意向,1--意向金,2--签订合同,3--合同金,4--佣金,5--服务金,6--关闭)',
  432. `intention_money` int(8) DEFAULT NULL COMMENT '意向金',
  433. `contract_money` int(8) DEFAULT NULL COMMENT '合同金',
  434. `commission` int(8) DEFAULT NULL COMMENT '佣金',
  435. `service_money` int(8) DEFAULT NULL COMMENT '服务金',
  436. `refund` int(1) DEFAULT NULL COMMENT '是否退款(0--未退款,1--已退款)',
  437. `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记(0--未删除,1--已删除)',
  438. PRIMARY KEY (`id`),
  439. KEY `serialNumber` (`serial_number`)
  440. ) ENGINE=InnoDB AUTO_INCREMENT=600004 DEFAULT CHARSET=utf8 COMMENT='科技需求意向单/交易单';
  441. /*!40101 SET character_set_client = @saved_cs_client */;
  442. --
  443. -- Table structure for table `demand_order_log`
  444. --
  445. DROP TABLE IF EXISTS `demand_order_log`;
  446. /*!40101 SET @saved_cs_client = @@character_set_client */;
  447. /*!40101 SET character_set_client = utf8 */;
  448. CREATE TABLE `demand_order_log` (
  449. `id` varchar(36) NOT NULL,
  450. `demand_order_id` varchar(36) NOT NULL COMMENT '科技需求意向单/交易单ID',
  451. `record_time` datetime DEFAULT NULL,
  452. `status` int(1) DEFAULT NULL COMMENT '状态',
  453. `operator` varchar(36) DEFAULT NULL COMMENT '记录操作人',
  454. `comment` varchar(128) DEFAULT NULL,
  455. PRIMARY KEY (`id`)
  456. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技需求意向单/交易单日志';
  457. /*!40101 SET character_set_client = @saved_cs_client */;
  458. --
  459. -- Table structure for table `district_glossory`
  460. --
  461. DROP TABLE IF EXISTS `district_glossory`;
  462. /*!40101 SET @saved_cs_client = @@character_set_client */;
  463. /*!40101 SET character_set_client = utf8 */;
  464. CREATE TABLE `district_glossory` (
  465. `id` int(4) NOT NULL,
  466. `name` varchar(16) DEFAULT NULL COMMENT '名称',
  467. `pid` int(4) DEFAULT NULL COMMENT '上级ID',
  468. `level` int(1) DEFAULT NULL COMMENT '层级',
  469. PRIMARY KEY (`id`)
  470. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='地区数据字典';
  471. /*!40101 SET character_set_client = @saved_cs_client */;
  472. --
  473. -- Table structure for table `field_glossory`
  474. --
  475. DROP TABLE IF EXISTS `field_glossory`;
  476. /*!40101 SET @saved_cs_client = @@character_set_client */;
  477. /*!40101 SET character_set_client = utf8 */;
  478. CREATE TABLE `field_glossory` (
  479. `id` int(4) NOT NULL,
  480. `name` varchar(32) DEFAULT NULL COMMENT '名称',
  481. `pid` int(4) DEFAULT NULL COMMENT '上级ID',
  482. `level` int(1) DEFAULT NULL COMMENT '层级',
  483. PRIMARY KEY (`id`)
  484. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='领域类别';
  485. /*!40101 SET character_set_client = @saved_cs_client */;
  486. --
  487. -- Table structure for table `html_fragment`
  488. --
  489. DROP TABLE IF EXISTS `html_fragment`;
  490. /*!40101 SET @saved_cs_client = @@character_set_client */;
  491. /*!40101 SET character_set_client = utf8 */;
  492. CREATE TABLE `html_fragment` (
  493. `id` varchar(36) NOT NULL,
  494. `content` longtext,
  495. PRIMARY KEY (`id`)
  496. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  497. /*!40101 SET character_set_client = @saved_cs_client */;
  498. --
  499. -- Table structure for table `industry_category`
  500. --
  501. DROP TABLE IF EXISTS `industry_category`;
  502. /*!40101 SET @saved_cs_client = @@character_set_client */;
  503. /*!40101 SET character_set_client = utf8 */;
  504. CREATE TABLE `industry_category` (
  505. `id` int(11) NOT NULL,
  506. `name` varchar(45) DEFAULT NULL,
  507. `pid` int(11) DEFAULT NULL,
  508. `value` decimal(4,2) DEFAULT NULL,
  509. PRIMARY KEY (`id`)
  510. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  511. /*!40101 SET character_set_client = @saved_cs_client */;
  512. --
  513. -- Table structure for table `legal_person_ownership`
  514. --
  515. DROP TABLE IF EXISTS `legal_person_ownership`;
  516. /*!40101 SET @saved_cs_client = @@character_set_client */;
  517. /*!40101 SET character_set_client = utf8 */;
  518. CREATE TABLE `legal_person_ownership` (
  519. `id` varchar(36) NOT NULL,
  520. `uid` varchar(36) NOT NULL,
  521. `type` int(1) DEFAULT NULL COMMENT '法人类型(0--中国企业法人,1--外国企业法人)',
  522. `name` varchar(32) DEFAULT NULL COMMENT '名称',
  523. `org_code` varchar(32) DEFAULT NULL COMMENT '组织机构代码或统一社会信用代码',
  524. `investment` decimal(8,2) DEFAULT NULL COMMENT '投资(万元)',
  525. `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记',
  526. PRIMARY KEY (`id`)
  527. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='法人股权表';
  528. /*!40101 SET character_set_client = @saved_cs_client */;
  529. --
  530. -- Table structure for table `nature_ownership`
  531. --
  532. DROP TABLE IF EXISTS `nature_ownership`;
  533. /*!40101 SET @saved_cs_client = @@character_set_client */;
  534. /*!40101 SET character_set_client = utf8 */;
  535. CREATE TABLE `nature_ownership` (
  536. `id` varchar(36) NOT NULL,
  537. `uid` varchar(36) NOT NULL,
  538. `type` int(1) DEFAULT NULL COMMENT '类型 (0--中国公民,1--外籍公民)',
  539. `name` varchar(32) DEFAULT NULL COMMENT '姓名',
  540. `id_number` varchar(18) DEFAULT NULL COMMENT '身份证(护照)号',
  541. `investment` decimal(8,2) DEFAULT NULL COMMENT '投资额(万元)',
  542. `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记',
  543. PRIMARY KEY (`id`)
  544. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='自然人股权表';
  545. /*!40101 SET character_set_client = @saved_cs_client */;
  546. --
  547. -- Table structure for table `notice`
  548. --
  549. DROP TABLE IF EXISTS `notice`;
  550. /*!40101 SET @saved_cs_client = @@character_set_client */;
  551. /*!40101 SET character_set_client = utf8 */;
  552. CREATE TABLE `notice` (
  553. `id` varchar(36) NOT NULL,
  554. `aid` varchar(36) DEFAULT NULL,
  555. `notice_type` int(1) DEFAULT NULL COMMENT '通知类型',
  556. `content` varchar(36) DEFAULT NULL COMMENT '通知内容',
  557. `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  558. `readed` int(1) DEFAULT NULL,
  559. `uid` varchar(36) DEFAULT NULL COMMENT '用户ID',
  560. `pid` varchar(36) DEFAULT NULL COMMENT '录入信息业务员ID',
  561. `rid` varchar(36) DEFAULT NULL COMMENT '业务记录ID',
  562. `year` int(4) DEFAULT NULL COMMENT '高企记录申报年份',
  563. PRIMARY KEY (`id`)
  564. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='流转状态通知表';
  565. /*!40101 SET character_set_client = @saved_cs_client */;
  566. --
  567. -- Table structure for table `org_activity`
  568. --
  569. DROP TABLE IF EXISTS `org_activity`;
  570. /*!40101 SET @saved_cs_client = @@character_set_client */;
  571. /*!40101 SET character_set_client = utf8 */;
  572. CREATE TABLE `org_activity` (
  573. `id` varchar(36) NOT NULL,
  574. `uid` varchar(36) NOT NULL,
  575. `activity_number` varchar(32) DEFAULT NULL COMMENT '研发活动编号',
  576. `activity_name` varchar(32) DEFAULT NULL COMMENT '研发活动名称',
  577. `start_date` datetime DEFAULT NULL COMMENT '开始日期',
  578. `end_date` datetime DEFAULT NULL COMMENT '结束日期',
  579. `participant` varchar(255) DEFAULT NULL COMMENT '参与人员',
  580. `project_mode` int(1) DEFAULT NULL COMMENT '是否是内部立项',
  581. `technical_field1` varchar(3) DEFAULT NULL COMMENT '技术领域1st select',
  582. `technical_field2` varchar(3) DEFAULT NULL COMMENT '技术领域2nd select',
  583. `technical_field3` varchar(3) DEFAULT NULL COMMENT '技术领域3rd select',
  584. `technical_source` int(1) DEFAULT NULL COMMENT '技术来源',
  585. `intellectual_property_number` varchar(500) DEFAULT NULL COMMENT '知识产权编号',
  586. `budget` decimal(8,2) DEFAULT NULL COMMENT '预算(万元)',
  587. `first_year_expenditure` decimal(8,2) DEFAULT NULL COMMENT '第一年研发经费支出(万元)',
  588. `second_year_expenditure` decimal(8,2) DEFAULT NULL COMMENT '第二年研发经费支出(万元)',
  589. `third_year_expenditure` decimal(8,2) DEFAULT NULL COMMENT '第三年研发经费支出(万元)',
  590. `implement` varchar(500) DEFAULT NULL COMMENT '目的及组织实施方式',
  591. `technology_innovation` varchar(500) DEFAULT NULL COMMENT '核心技术及创新点',
  592. `achievement` varchar(500) DEFAULT NULL COMMENT '取得的阶段性成果',
  593. `proof_url` varchar(255) DEFAULT NULL COMMENT '立项证明材料URL',
  594. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  595. PRIMARY KEY (`id`)
  596. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  597. /*!40101 SET character_set_client = @saved_cs_client */;
  598. --
  599. -- Table structure for table `org_activity_cost`
  600. --
  601. DROP TABLE IF EXISTS `org_activity_cost`;
  602. /*!40101 SET @saved_cs_client = @@character_set_client */;
  603. /*!40101 SET character_set_client = utf8 */;
  604. CREATE TABLE `org_activity_cost` (
  605. `id` varchar(36) NOT NULL,
  606. `aid` varchar(36) NOT NULL,
  607. `uid` varchar(36) NOT NULL,
  608. `year` int(4) DEFAULT NULL COMMENT '年份',
  609. `activity_number` varchar(32) DEFAULT NULL COMMENT '项目编号',
  610. `internal_labor_cost` decimal(8,2) DEFAULT NULL COMMENT '内部人员人工费用(万元)',
  611. `internal_direct_cost` decimal(8,2) DEFAULT NULL COMMENT '内部直接投入费用(万元)',
  612. `internal_depreciation_cost` decimal(8,2) DEFAULT NULL COMMENT '内部折旧费用与长期待摊费用(万元)',
  613. `internal_amortization_cost` decimal(8,2) DEFAULT NULL COMMENT '内部无形资产摊销费用(万元)',
  614. `internal_design_cost` decimal(8,2) DEFAULT NULL COMMENT '内部设计费用(万元)',
  615. `internal_equipment_cost` decimal(8,2) DEFAULT NULL COMMENT '内部装备调试费用与实验费用(万元)',
  616. `internal_other_cost` decimal(8,2) DEFAULT NULL COMMENT '内部其他费用(万元)',
  617. `external_total_cost` decimal(8,2) DEFAULT NULL COMMENT '委托外部研究开发总费用(万元)',
  618. `external_abroad_cost` decimal(8,2) DEFAULT NULL COMMENT '委托外部境内的外部研发费用(万元)',
  619. `enterprise_filler` varchar(16) DEFAULT NULL COMMENT '企业填报人',
  620. `sign_date` datetime DEFAULT NULL COMMENT '企业填报人签字日期',
  621. `sort_number` varchar(32) DEFAULT NULL COMMENT '排序号',
  622. `start_date` datetime DEFAULT NULL,
  623. `end_date` datetime DEFAULT NULL,
  624. `account_url` varchar(255) DEFAULT NULL COMMENT '台帐URL',
  625. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  626. PRIMARY KEY (`id`),
  627. KEY `fk_org_activity_cost_org_activity1_idx` (`aid`)
  628. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  629. /*!40101 SET character_set_client = @saved_cs_client */;
  630. --
  631. -- Table structure for table `org_annual_report`
  632. --
  633. DROP TABLE IF EXISTS `org_annual_report`;
  634. /*!40101 SET @saved_cs_client = @@character_set_client */;
  635. /*!40101 SET character_set_client = utf8 */;
  636. CREATE TABLE `org_annual_report` (
  637. `id` varchar(36) NOT NULL,
  638. `uid` varchar(36) DEFAULT NULL,
  639. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  640. `last_update_time` datetime DEFAULT NULL COMMENT '最近跟新时间',
  641. `total_tax` decimal(8,2) DEFAULT NULL COMMENT '纳税总额(万元)',
  642. `income_tax_relief` decimal(8,2) DEFAULT NULL COMMENT '所得税减免(万元)',
  643. `total_export_volume` decimal(8,2) DEFAULT NULL COMMENT '出口创汇总额(万元)',
  644. `basic_research_cost` decimal(8,2) DEFAULT NULL COMMENT '基础研究投入费用',
  645. `year` int(4) DEFAULT NULL COMMENT '年份',
  646. `state` int(1) DEFAULT '0' COMMENT '年报状态',
  647. `deleted_sign` int(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  648. PRIMARY KEY (`id`)
  649. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  650. /*!40101 SET character_set_client = @saved_cs_client */;
  651. --
  652. -- Table structure for table `org_cognizance`
  653. --
  654. DROP TABLE IF EXISTS `org_cognizance`;
  655. /*!40101 SET @saved_cs_client = @@character_set_client */;
  656. /*!40101 SET character_set_client = utf8 */;
  657. CREATE TABLE `org_cognizance` (
  658. `id` varchar(36) NOT NULL,
  659. `uid` varchar(36) NOT NULL,
  660. `contract_id` varchar(36) DEFAULT NULL COMMENT '合同ID',
  661. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号',
  662. `contacts` int(1) DEFAULT NULL COMMENT '联系人及联系方式',
  663. `comment` varchar(128) DEFAULT NULL COMMENT '派单信息',
  664. `consultant` varchar(36) DEFAULT NULL COMMENT '咨询师',
  665. `technical_field1` int(3) DEFAULT NULL COMMENT '技术领域1st select',
  666. `technical_field2` int(3) DEFAULT NULL COMMENT '技术领域2nd select',
  667. `technical_field3` int(3) DEFAULT NULL COMMENT '技术领域3rd select',
  668. `basic_research_cost` decimal(8,2) DEFAULT NULL COMMENT '基础研究投入费用总额(万元)',
  669. `accident` int(1) DEFAULT NULL COMMENT '申请认定前一年内是否发生过重大安全、重大质量或严重环境违法行为',
  670. `create_time` datetime DEFAULT NULL COMMENT '派单日',
  671. `accept_date` datetime DEFAULT NULL COMMENT '受理日',
  672. `issuing_date` datetime DEFAULT NULL COMMENT '发证日',
  673. `certificate_number` varchar(36) DEFAULT NULL COMMENT '证书编号',
  674. `certificate_url` varchar(255) DEFAULT NULL COMMENT '证书URL',
  675. `state` int(2) DEFAULT NULL COMMENT '高企认定状态',
  676. `year` int(4) DEFAULT NULL COMMENT '申请年份',
  677. `record_time` datetime DEFAULT NULL COMMENT '高企申请时间',
  678. `large_order` int(1) DEFAULT NULL COMMENT '是否为大额订单 ',
  679. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  680. `founder` varchar(36) DEFAULT NULL COMMENT '申请创建人ID',
  681. `tech_principal` varchar(36) DEFAULT NULL COMMENT '高企技术负责人',
  682. PRIMARY KEY (`id`),
  683. KEY `serialNumber_UNIQUE` (`serial_number`) USING BTREE
  684. ) ENGINE=InnoDB AUTO_INCREMENT=60000029 DEFAULT CHARSET=utf8;
  685. /*!40101 SET character_set_client = @saved_cs_client */;
  686. --
  687. -- Table structure for table `org_cognizance_log`
  688. --
  689. DROP TABLE IF EXISTS `org_cognizance_log`;
  690. /*!40101 SET @saved_cs_client = @@character_set_client */;
  691. /*!40101 SET character_set_client = utf8 */;
  692. CREATE TABLE `org_cognizance_log` (
  693. `id` varchar(36) NOT NULL,
  694. `cid` varchar(36) NOT NULL,
  695. `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间',
  696. `state` int(2) DEFAULT NULL COMMENT '高企认定状态',
  697. `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
  698. `operator` varchar(36) DEFAULT NULL COMMENT '操作人',
  699. `comment` varchar(128) DEFAULT NULL COMMENT '备注',
  700. PRIMARY KEY (`id`),
  701. KEY `fk_org_cognizance_log_org_cognizance1_idx` (`cid`)
  702. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  703. /*!40101 SET character_set_client = @saved_cs_client */;
  704. --
  705. -- Table structure for table `org_cognizance_proportion`
  706. --
  707. DROP TABLE IF EXISTS `org_cognizance_proportion`;
  708. /*!40101 SET @saved_cs_client = @@character_set_client */;
  709. /*!40101 SET character_set_client = utf8 */;
  710. CREATE TABLE `org_cognizance_proportion` (
  711. `id` varchar(36) NOT NULL,
  712. `uid` varchar(36) NOT NULL,
  713. `institution` int(1) DEFAULT NULL COMMENT '企业研发机构',
  714. `activity` int(1) DEFAULT NULL COMMENT '研发活动',
  715. `activity_cost` int(1) DEFAULT NULL COMMENT '研发活动费用详情',
  716. `tech_project` int(1) DEFAULT NULL COMMENT '高新技术产品',
  717. `intellectual_property` int(1) DEFAULT NULL COMMENT '知识产权',
  718. `achievement` int(1) DEFAULT NULL COMMENT '科技成果转化',
  719. `ratepay` int(1) DEFAULT NULL COMMENT '企业所得税纳税申报表',
  720. `finance` int(1) DEFAULT NULL COMMENT '财务报表',
  721. `human_resource` int(1) DEFAULT NULL COMMENT '企业人员情况',
  722. `honor_datum` int(1) DEFAULT NULL COMMENT '企业荣誉及其他证明材料',
  723. `standard` int(1) DEFAULT NULL COMMENT '标准制定情况',
  724. `ability` int(1) DEFAULT NULL COMMENT '企业创新能力',
  725. PRIMARY KEY (`id`)
  726. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='高企培育进度权重表';
  727. /*!40101 SET character_set_client = @saved_cs_client */;
  728. --
  729. -- Table structure for table `org_finance`
  730. --
  731. DROP TABLE IF EXISTS `org_finance`;
  732. /*!40101 SET @saved_cs_client = @@character_set_client */;
  733. /*!40101 SET character_set_client = utf8 */;
  734. CREATE TABLE `org_finance` (
  735. `id` varchar(36) NOT NULL,
  736. `uid` varchar(36) NOT NULL,
  737. `main_business_income` decimal(8,2) DEFAULT NULL COMMENT '主营业务收入(万元)',
  738. `management_cost` decimal(8,2) DEFAULT NULL COMMENT '管理费用(万元)',
  739. `operating_profit` decimal(8,2) DEFAULT NULL COMMENT '营业利润(万元)',
  740. `various_tax` decimal(8,2) DEFAULT NULL COMMENT '支付的各项税费(万元)',
  741. `current_asset` decimal(8,2) DEFAULT NULL COMMENT '流动资产(万元)',
  742. `net_fixed_asset` decimal(8,2) DEFAULT NULL COMMENT '固定资产净额(万元)',
  743. `total_asset` decimal(8,2) DEFAULT NULL COMMENT '资产总额(万元)',
  744. `net_asset` decimal(8,2) DEFAULT NULL COMMENT '所有者权益合计(万元)',
  745. `gross_profit` decimal(8,2) DEFAULT NULL COMMENT '利润总额(万元)',
  746. `net_profit` decimal(8,2) DEFAULT NULL COMMENT '净利润(万元)',
  747. `sales_revenue` decimal(8,2) DEFAULT NULL COMMENT '销售收入(万元)',
  748. `year` int(4) DEFAULT NULL COMMENT '年份',
  749. `finance_url` varchar(255) DEFAULT NULL COMMENT '财务报表URL',
  750. `research_cost` decimal(8,2) DEFAULT NULL COMMENT '研发费用',
  751. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  752. PRIMARY KEY (`id`),
  753. KEY `fk_org_finance_user1_idx` (`uid`)
  754. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  755. /*!40101 SET character_set_client = @saved_cs_client */;
  756. --
  757. -- Table structure for table `org_honor_datum`
  758. --
  759. DROP TABLE IF EXISTS `org_honor_datum`;
  760. /*!40101 SET @saved_cs_client = @@character_set_client */;
  761. /*!40101 SET character_set_client = utf8 */;
  762. CREATE TABLE `org_honor_datum` (
  763. `id` varchar(36) NOT NULL,
  764. `uid` varchar(36) NOT NULL,
  765. `name` varchar(32) DEFAULT NULL COMMENT '荣誉或证明材料名称',
  766. `issuing_mechanism` varchar(36) DEFAULT NULL COMMENT '发证机构',
  767. `issuing_time` datetime DEFAULT NULL COMMENT '发证时间',
  768. `enclosure_url` varchar(255) DEFAULT NULL COMMENT '附件材料URL',
  769. `year` int(4) DEFAULT NULL COMMENT '荣誉及其他证明材料获取年份',
  770. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  771. PRIMARY KEY (`id`),
  772. KEY `fk_org_honor_datum_user1_idx` (`uid`)
  773. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  774. /*!40101 SET character_set_client = @saved_cs_client */;
  775. --
  776. -- Table structure for table `org_human_resource`
  777. --
  778. DROP TABLE IF EXISTS `org_human_resource`;
  779. /*!40101 SET @saved_cs_client = @@character_set_client */;
  780. /*!40101 SET character_set_client = utf8 */;
  781. CREATE TABLE `org_human_resource` (
  782. `id` varchar(36) NOT NULL,
  783. `uid` varchar(36) NOT NULL,
  784. `firm_total` int(6) DEFAULT NULL COMMENT '企业职工总数',
  785. `tech_total` int(6) DEFAULT NULL COMMENT '科技人员总数',
  786. `firm_in_service` int(6) DEFAULT NULL COMMENT '企业在职员工人数',
  787. `tech_in_service` int(6) DEFAULT NULL COMMENT '科技在职员工人数',
  788. `firm_part_time` int(6) DEFAULT NULL COMMENT '企业兼职人数',
  789. `tech_part_time` int(6) DEFAULT NULL COMMENT '科技人员兼职人数',
  790. `firm_temporary` int(6) DEFAULT NULL COMMENT '企业临时聘用人数',
  791. `tech_temporary` int(6) DEFAULT NULL COMMENT '科技人员临时聘用人数',
  792. `firm_foreign` int(6) DEFAULT NULL COMMENT '企业外籍人员数',
  793. `tech_foreign` int(6) DEFAULT NULL COMMENT '外籍科技人员数',
  794. `firm_abroad` int(6) DEFAULT NULL COMMENT '企业留学归国人员数',
  795. `tech_abroad` int(6) DEFAULT NULL COMMENT '留学归国科技人员数',
  796. `firm_core` int(6) DEFAULT NULL COMMENT '企业千人计划人数',
  797. `tech_core` int(6) DEFAULT NULL COMMENT '千人计划科技人员数',
  798. `doctor` int(6) DEFAULT NULL COMMENT '博士人数',
  799. `master` int(6) DEFAULT NULL COMMENT '硕士人数',
  800. `undergraduate` int(6) DEFAULT NULL COMMENT '本科人数',
  801. `college` int(6) DEFAULT NULL COMMENT '大专人数',
  802. `senior_title` int(6) DEFAULT NULL COMMENT '高级职称人数',
  803. `intermediate_title` int(6) DEFAULT NULL COMMENT '中级职称人数',
  804. `junior_title` int(6) DEFAULT NULL COMMENT '初级职称人数',
  805. `senior_mechanic` int(6) DEFAULT NULL COMMENT '高级技工人数',
  806. `below_thirty` int(6) DEFAULT NULL COMMENT '三十岁及以下员工人数',
  807. `thirtyone_to_thirtyfour` int(6) DEFAULT NULL COMMENT '三十一至三十四岁员工人数',
  808. `fortyone_to_fifty` int(6) DEFAULT NULL COMMENT '四十一至五十岁员工人数',
  809. `above_fifty` int(6) DEFAULT NULL COMMENT '五十岁以上员工人数',
  810. `year` int(4) DEFAULT NULL COMMENT '年份',
  811. `new_employment` int(6) DEFAULT NULL COMMENT '新增就业人数',
  812. `graduate_number` int(6) DEFAULT NULL COMMENT '高校应届毕业生人数',
  813. `roster_url` varchar(255) DEFAULT NULL COMMENT '花名册URL',
  814. `social_security_url` varchar(255) DEFAULT NULL COMMENT '社保情况URL',
  815. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  816. PRIMARY KEY (`id`)
  817. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  818. /*!40101 SET character_set_client = @saved_cs_client */;
  819. --
  820. -- Table structure for table `org_intellectual_property`
  821. --
  822. DROP TABLE IF EXISTS `org_intellectual_property`;
  823. /*!40101 SET @saved_cs_client = @@character_set_client */;
  824. /*!40101 SET character_set_client = utf8 */;
  825. CREATE TABLE `org_intellectual_property` (
  826. `id` varchar(36) NOT NULL,
  827. `uid` varchar(36) NOT NULL,
  828. `pid` varchar(36) DEFAULT NULL COMMENT '专利记录ID',
  829. `intellectual_property_number` varchar(32) DEFAULT NULL COMMENT '知识产权编号',
  830. `intellectual_property_name` varchar(32) DEFAULT NULL COMMENT '知识产权名称',
  831. `sort_number` varchar(36) DEFAULT NULL COMMENT '排序号',
  832. `catagory` int(2) DEFAULT NULL COMMENT '类别',
  833. `obtain_way` int(1) DEFAULT NULL COMMENT '获得方式',
  834. `authorization_number` varchar(32) DEFAULT NULL COMMENT '授权号',
  835. `authorization_date` datetime DEFAULT NULL COMMENT '授权日期',
  836. `evaluation_category` int(1) DEFAULT NULL COMMENT '0--Ⅰ类, 1--Ⅱ类',
  837. `property_right_url` varchar(255) DEFAULT NULL COMMENT '知识产权证书URL',
  838. `type` int(1) DEFAULT NULL COMMENT '知识产权类型(0--非系统申请知识产权,1--专利,2--软著)',
  839. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  840. PRIMARY KEY (`id`),
  841. KEY `fk_org_intellectual_property_user1_idx` (`uid`)
  842. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  843. /*!40101 SET character_set_client = @saved_cs_client */;
  844. --
  845. -- Table structure for table `org_ratepay`
  846. --
  847. DROP TABLE IF EXISTS `org_ratepay`;
  848. /*!40101 SET @saved_cs_client = @@character_set_client */;
  849. /*!40101 SET character_set_client = utf8 */;
  850. CREATE TABLE `org_ratepay` (
  851. `id` varchar(36) NOT NULL,
  852. `uid` varchar(36) NOT NULL,
  853. `operating_income` decimal(8,2) DEFAULT NULL COMMENT '营业收入(万元)',
  854. `management_cost` decimal(8,2) DEFAULT NULL COMMENT '管理费用(万元)',
  855. `operating_profit` decimal(8,2) DEFAULT NULL COMMENT '营业利润(万元)',
  856. `non_operating_income` decimal(8,2) DEFAULT NULL COMMENT '营业外收入(万元)',
  857. `non_taxable_income` decimal(8,2) DEFAULT NULL COMMENT '不征税收入(万元)',
  858. `tax_exempt_income` decimal(8,2) DEFAULT NULL COMMENT '免税收入(万元)',
  859. `subsidy_income` decimal(8,2) DEFAULT NULL COMMENT '政府补助收入(万元)',
  860. `gross_profit` decimal(8,2) DEFAULT NULL COMMENT '利润总额(万元)',
  861. `research_cost` decimal(8,2) DEFAULT NULL COMMENT '研发费用(万元)',
  862. `year` int(4) DEFAULT NULL COMMENT '年份',
  863. `tax_return_url` varchar(255) DEFAULT NULL COMMENT '纳税申报表url',
  864. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  865. PRIMARY KEY (`id`),
  866. KEY `fk_org_ratepay_user1_idx` (`uid`)
  867. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  868. /*!40101 SET character_set_client = @saved_cs_client */;
  869. --
  870. -- Table structure for table `org_standard`
  871. --
  872. DROP TABLE IF EXISTS `org_standard`;
  873. /*!40101 SET @saved_cs_client = @@character_set_client */;
  874. /*!40101 SET character_set_client = utf8 */;
  875. CREATE TABLE `org_standard` (
  876. `id` varchar(36) NOT NULL,
  877. `uid` varchar(36) NOT NULL,
  878. `standard_name` varchar(32) DEFAULT NULL COMMENT '标准名称',
  879. `standard_number` varchar(36) DEFAULT NULL COMMENT '标准编号',
  880. `standard_level` int(1) DEFAULT NULL COMMENT '标准级别',
  881. `participate_way` int(1) DEFAULT NULL COMMENT '参与方式',
  882. `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  883. `year` int(4) DEFAULT NULL COMMENT '标准指定年份',
  884. `enclosure_url` varchar(255) DEFAULT NULL COMMENT '附件URL',
  885. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  886. PRIMARY KEY (`id`)
  887. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  888. /*!40101 SET character_set_client = @saved_cs_client */;
  889. --
  890. -- Table structure for table `org_tech_achievement`
  891. --
  892. DROP TABLE IF EXISTS `org_tech_achievement`;
  893. /*!40101 SET @saved_cs_client = @@character_set_client */;
  894. /*!40101 SET character_set_client = utf8 */;
  895. CREATE TABLE `org_tech_achievement` (
  896. `id` varchar(36) NOT NULL,
  897. `uid` varchar(36) NOT NULL,
  898. `achievement_name` varchar(32) DEFAULT NULL COMMENT '成果名称',
  899. `source` varchar(36) DEFAULT NULL COMMENT '来源',
  900. `conversion_form` int(1) DEFAULT NULL COMMENT '转化形式',
  901. `conversion_result` varchar(255) DEFAULT NULL COMMENT '转化结果',
  902. `year` int(4) DEFAULT NULL COMMENT '转化年份',
  903. `enclosure_url` varchar(255) DEFAULT NULL COMMENT '证明材料附件URL',
  904. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  905. PRIMARY KEY (`id`),
  906. KEY `fk_org_tech_achievment_user1_idx` (`uid`)
  907. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  908. /*!40101 SET character_set_client = @saved_cs_client */;
  909. --
  910. -- Table structure for table `org_tech_center`
  911. --
  912. DROP TABLE IF EXISTS `org_tech_center`;
  913. /*!40101 SET @saved_cs_client = @@character_set_client */;
  914. /*!40101 SET character_set_client = utf8 */;
  915. CREATE TABLE `org_tech_center` (
  916. `id` varchar(36) NOT NULL,
  917. `uid` varchar(36) NOT NULL,
  918. `center_name` varchar(36) DEFAULT NULL COMMENT '技术中心名称',
  919. `founding_time` datetime DEFAULT NULL COMMENT '成立时间',
  920. `principal` varchar(32) DEFAULT NULL COMMENT '负责人',
  921. `system_catalog` longtext COMMENT '制度目录',
  922. `comment` varchar(1000) DEFAULT NULL,
  923. `system_url` varchar(255) DEFAULT NULL COMMENT '制度目录URL',
  924. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  925. PRIMARY KEY (`id`),
  926. KEY `fk_org_tech_center_user1_idx` (`uid`)
  927. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  928. /*!40101 SET character_set_client = @saved_cs_client */;
  929. --
  930. -- Table structure for table `org_tech_center_detail`
  931. --
  932. DROP TABLE IF EXISTS `org_tech_center_detail`;
  933. /*!40101 SET @saved_cs_client = @@character_set_client */;
  934. /*!40101 SET character_set_client = utf8 */;
  935. CREATE TABLE `org_tech_center_detail` (
  936. `id` varchar(36) NOT NULL,
  937. `cid` varchar(36) NOT NULL,
  938. `project_time` datetime DEFAULT NULL COMMENT '产学研时间',
  939. `project_name` varchar(32) DEFAULT NULL COMMENT '产学研名称',
  940. `term_start_time` datetime DEFAULT NULL COMMENT '期限开始时间',
  941. `term_end_time` datetime DEFAULT NULL COMMENT '期限结束时间',
  942. `institution` varchar(32) DEFAULT NULL COMMENT '大学机构',
  943. `protocol_url` varchar(255) DEFAULT NULL COMMENT '协议URL',
  944. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  945. PRIMARY KEY (`id`),
  946. KEY `fk_org_tech_center_detail_org_tech_center1_idx` (`cid`)
  947. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  948. /*!40101 SET character_set_client = @saved_cs_client */;
  949. --
  950. -- Table structure for table `org_tech_product`
  951. --
  952. DROP TABLE IF EXISTS `org_tech_product`;
  953. /*!40101 SET @saved_cs_client = @@character_set_client */;
  954. /*!40101 SET character_set_client = utf8 */;
  955. CREATE TABLE `org_tech_product` (
  956. `id` varchar(36) NOT NULL,
  957. `uid` varchar(36) NOT NULL,
  958. `serial_number` varchar(32) DEFAULT NULL COMMENT '编号',
  959. `product_name` varchar(32) DEFAULT NULL COMMENT '产品名称',
  960. `technical_field1` int(3) DEFAULT NULL COMMENT '技术领域1st select',
  961. `technical_field2` int(3) DEFAULT NULL COMMENT '技术领域2nd select',
  962. `technical_field3` int(3) DEFAULT NULL COMMENT '技术领域3rd select',
  963. `technical_source` int(1) DEFAULT NULL COMMENT '技术来源',
  964. `last_year_revenue` decimal(8,2) DEFAULT NULL COMMENT '上年度销售收入(万元)',
  965. `main_product` int(1) DEFAULT NULL COMMENT '是否是主要产品(服务)',
  966. `intellectual_property_number` varchar(500) DEFAULT NULL COMMENT '知识产权编号',
  967. `key_technology` varchar(500) DEFAULT NULL COMMENT '关键技术及主要技术指标',
  968. `competitive_edge` varchar(500) DEFAULT NULL COMMENT '与同类产品(服务)的竞争优势',
  969. `condition_effect` varchar(500) DEFAULT NULL COMMENT '知识产权获得情况及其对产品(服务)在技术上发挥的支持作用',
  970. `year` int(6) DEFAULT NULL COMMENT '年份',
  971. `create_time` datetime DEFAULT NULL COMMENT '记录创建时间',
  972. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  973. `account_url` varchar(255) DEFAULT NULL COMMENT '台帐URL',
  974. PRIMARY KEY (`id`),
  975. KEY `fk_org_tech_product_user1_idx` (`uid`)
  976. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  977. /*!40101 SET character_set_client = @saved_cs_client */;
  978. --
  979. -- Table structure for table `organization_identity`
  980. --
  981. DROP TABLE IF EXISTS `organization_identity`;
  982. /*!40101 SET @saved_cs_client = @@character_set_client */;
  983. /*!40101 SET character_set_client = utf8 */;
  984. CREATE TABLE `organization_identity` (
  985. `id` varchar(36) NOT NULL,
  986. `uid` varchar(36) NOT NULL,
  987. `contacts` varchar(16) DEFAULT NULL COMMENT '联系人',
  988. `contact_mobile` varchar(16) DEFAULT NULL COMMENT '联系方式',
  989. `fixed_tel` varchar(16) DEFAULT NULL COMMENT '固定电话',
  990. `qq` varchar(16) DEFAULT NULL COMMENT 'QQ号',
  991. `postal_address` varchar(255) DEFAULT NULL COMMENT '通讯地址',
  992. `postcode` varchar(8) DEFAULT NULL COMMENT '邮政编码',
  993. `aft_username` varchar(32) DEFAULT NULL COMMENT '用户名',
  994. `unit_name` varchar(45) DEFAULT NULL COMMENT '单位名称',
  995. `registered_capital` decimal(8,2) DEFAULT NULL COMMENT '注册资金',
  996. `licence_number` varchar(32) DEFAULT NULL COMMENT '营业执照注册号',
  997. `licence_province` int(2) DEFAULT NULL COMMENT '营业执照所在地--省',
  998. `licence_city` int(3) DEFAULT NULL COMMENT '营业执照所在地-市',
  999. `licence_area` int(4) DEFAULT NULL COMMENT '营业执照所在地-区(县)',
  1000. `licence_scanning_url` varchar(255) DEFAULT NULL COMMENT '营业执照副本扫描件URL',
  1001. `org_code` varchar(32) DEFAULT NULL COMMENT '组织机构代码证号码',
  1002. `org_code_url` varchar(255) DEFAULT NULL COMMENT '组织机构代码证URL',
  1003. `bank_account` varchar(32) DEFAULT NULL COMMENT '银行账号',
  1004. `banks` varchar(32) DEFAULT NULL COMMENT '开户行',
  1005. `bank_branch` varchar(32) DEFAULT NULL COMMENT '开户行支行',
  1006. `bank_card_number` varchar(32) DEFAULT NULL COMMENT '银行卡号',
  1007. `validation_amount` decimal(6,4) DEFAULT '0.0000' COMMENT '打入账内信息',
  1008. `identity_type` int(1) DEFAULT NULL COMMENT '身份类型',
  1009. `location_province` int(2) DEFAULT NULL COMMENT '开户行所在地-省',
  1010. `location_city` int(3) DEFAULT NULL COMMENT '开户行所在地-市',
  1011. `location_area` int(4) DEFAULT NULL COMMENT '开户行所在地-区(县)',
  1012. `legal_person` varchar(16) DEFAULT NULL COMMENT '法人',
  1013. `legal_person_id_card` varchar(32) DEFAULT NULL COMMENT '法人身份证号',
  1014. `last_year_tax_report_url` varchar(255) DEFAULT NULL COMMENT '上年度纳税报表',
  1015. `audit_status` int(1) DEFAULT '0' COMMENT '审核状态',
  1016. `process` int(1) DEFAULT '0' COMMENT '实名认证流程',
  1017. `wrong_count` int(1) DEFAULT '0' COMMENT '输入打款金额错误次数',
  1018. `payment_date` datetime DEFAULT NULL COMMENT '打款日期',
  1019. `first_contacts` varchar(16) DEFAULT NULL,
  1020. `first_mobile` varchar(16) DEFAULT NULL,
  1021. `second_contacts` varchar(16) DEFAULT NULL,
  1022. `second_mobile` varchar(16) DEFAULT NULL,
  1023. `third_contacts` varchar(16) DEFAULT NULL,
  1024. `third_mobile` varchar(16) DEFAULT NULL,
  1025. `listed` int(1) DEFAULT NULL COMMENT '是否上市',
  1026. `listed_date` datetime DEFAULT NULL COMMENT '上市时间',
  1027. `listed_type` int(1) DEFAULT NULL COMMENT '上市类型',
  1028. `stock_code` varchar(32) DEFAULT NULL COMMENT '股票代码',
  1029. `certificate_number` varchar(36) DEFAULT NULL COMMENT '高企认定证书编号',
  1030. `issuing_date` datetime DEFAULT NULL COMMENT '高企认定发证日期',
  1031. `cog_contacts` int(1) DEFAULT NULL COMMENT '高企认定联系人及联系方式',
  1032. `tech_principal` varchar(36) DEFAULT NULL COMMENT '高企技术负责人',
  1033. `contacts_fixed_tel` varchar(16) DEFAULT NULL COMMENT '联系人固定电话',
  1034. `contacts_fax` varchar(16) DEFAULT NULL COMMENT '联系人传真',
  1035. `legal_person_tel` varchar(16) DEFAULT NULL COMMENT '法人电话',
  1036. `legal_person_fax` varchar(16) DEFAULT NULL COMMENT '法人传真',
  1037. `legal_person_email` varchar(128) DEFAULT NULL COMMENT '法人Email',
  1038. `registration_time` datetime DEFAULT NULL COMMENT '注册时间',
  1039. `ratepay_code` varchar(36) DEFAULT NULL COMMENT '税务登记号',
  1040. `industry` int(2) DEFAULT NULL COMMENT '所属行业',
  1041. `enterprise_scale` int(1) DEFAULT NULL COMMENT '企业规模',
  1042. `register_type` varchar(8) DEFAULT NULL COMMENT '注册类型',
  1043. `foreign_investment` varchar(32) DEFAULT NULL COMMENT '外资来源地',
  1044. `field` varchar(16) DEFAULT NULL COMMENT '领域',
  1045. `tax_authority` int(1) DEFAULT NULL COMMENT '企业所得税主管税务机关(0--国税,1--地税)',
  1046. `ratepay_method` int(1) DEFAULT NULL COMMENT '企业所得税征收方式(0--查账征收,1--核定征收)',
  1047. `high_tech_zone` int(1) DEFAULT NULL COMMENT '是否属于国家级高新区内企业(0--否,1--是)',
  1048. `risk_investment` int(1) DEFAULT NULL COMMENT '是否引入风险投资(0--否,1--是)',
  1049. `business_scope` varchar(400) DEFAULT NULL COMMENT '经营范围',
  1050. `high_tech_name` varchar(32) DEFAULT NULL COMMENT '国家级高新区名称',
  1051. `patent_prory_statement_url` varchar(255) DEFAULT NULL COMMENT '专利代理委托书URL',
  1052. PRIMARY KEY (`id`)
  1053. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1054. /*!40101 SET character_set_client = @saved_cs_client */;
  1055. --
  1056. -- Table structure for table `organization_info`
  1057. --
  1058. DROP TABLE IF EXISTS `organization_info`;
  1059. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1060. /*!40101 SET character_set_client = utf8 */;
  1061. CREATE TABLE `organization_info` (
  1062. `id` varchar(36) NOT NULL,
  1063. `uid` varchar(36) NOT NULL,
  1064. `identity_type` varchar(6) DEFAULT NULL COMMENT '身份类型',
  1065. `company_name` varchar(45) DEFAULT NULL COMMENT '公司名称',
  1066. `location_province` int(2) DEFAULT NULL COMMENT '所在地-省份',
  1067. `location_city` int(3) DEFAULT NULL COMMENT '所在地--市',
  1068. `location_area` int(4) DEFAULT NULL COMMENT '所在地--区',
  1069. `unit_size` varchar(12) DEFAULT NULL COMMENT '单位规模',
  1070. `company_introduction` varchar(1002) DEFAULT NULL COMMENT '单位简介',
  1071. `home_unit` varchar(45) DEFAULT NULL COMMENT '所属单位',
  1072. `logo_url` varchar(255) DEFAULT NULL COMMENT 'logo图',
  1073. `publicity_picture_url` varchar(1000) DEFAULT NULL COMMENT '宣传图片',
  1074. PRIMARY KEY (`id`)
  1075. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1076. /*!40101 SET character_set_client = @saved_cs_client */;
  1077. --
  1078. -- Table structure for table `organization_properties`
  1079. --
  1080. DROP TABLE IF EXISTS `organization_properties`;
  1081. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1082. /*!40101 SET character_set_client = utf8 */;
  1083. CREATE TABLE `organization_properties` (
  1084. `id` varchar(36) NOT NULL,
  1085. `oid` varchar(36) NOT NULL,
  1086. `qualification` varchar(45) DEFAULT NULL COMMENT '企业资质',
  1087. `turnover` int(8) DEFAULT NULL COMMENT '年营业额',
  1088. `college_attribute` varchar(45) DEFAULT NULL COMMENT '院校属性',
  1089. `college_establish_time` varchar(12) DEFAULT NULL COMMENT '院校创办时间',
  1090. `academician` int(5) DEFAULT NULL COMMENT '院士',
  1091. `doctoral_tutor` int(5) DEFAULT NULL COMMENT '博士生导师',
  1092. `master_tutor` int(5) DEFAULT NULL COMMENT '硕士生导师',
  1093. `other_expert` int(5) DEFAULT NULL COMMENT '其他专家',
  1094. `national_lab` int(5) DEFAULT NULL COMMENT '国家重点实验室',
  1095. `education_lab` int(5) DEFAULT NULL COMMENT '教育部重点实验室',
  1096. `enterprise_center` int(5) DEFAULT NULL COMMENT '企业共建研究中心',
  1097. `other_center` int(5) DEFAULT NULL COMMENT '其他研究中心',
  1098. `institution_establish_time` varchar(12) DEFAULT NULL COMMENT '研究机构创办时间',
  1099. PRIMARY KEY (`id`)
  1100. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1101. /*!40101 SET character_set_client = @saved_cs_client */;
  1102. --
  1103. -- Table structure for table `organization_tech`
  1104. --
  1105. DROP TABLE IF EXISTS `organization_tech`;
  1106. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1107. /*!40101 SET character_set_client = utf8 */;
  1108. CREATE TABLE `organization_tech` (
  1109. `id` varchar(36) NOT NULL,
  1110. `uid` varchar(36) NOT NULL,
  1111. `technical_people_num` varchar(12) DEFAULT NULL COMMENT '技术人员数量',
  1112. `search_area_category` varchar(255) DEFAULT NULL COMMENT '重点研究领域类别',
  1113. `search_area_det` varchar(32) DEFAULT NULL COMMENT '重点研究领域明细',
  1114. `specialty` varchar(32) DEFAULT NULL COMMENT '擅长领域',
  1115. PRIMARY KEY (`id`)
  1116. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1117. /*!40101 SET character_set_client = @saved_cs_client */;
  1118. --
  1119. -- Table structure for table `patent_cost`
  1120. --
  1121. DROP TABLE IF EXISTS `patent_cost`;
  1122. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1123. /*!40101 SET character_set_client = utf8 */;
  1124. CREATE TABLE `patent_cost` (
  1125. `id` varchar(36) NOT NULL,
  1126. `pid` varchar(36) NOT NULL,
  1127. `annual_fee` int(6) DEFAULT NULL COMMENT '年登印费',
  1128. `annual_fee_state` int(1) DEFAULT '0' COMMENT '年登印费缴费状态',
  1129. `application_fee` int(6) DEFAULT NULL COMMENT '申请费',
  1130. `trial_fee` int(6) DEFAULT NULL COMMENT '实审费',
  1131. `printing_fee` int(6) DEFAULT NULL COMMENT '文印费',
  1132. `funds` int(1) DEFAULT NULL COMMENT '是否请款',
  1133. `reimbursement` int(1) DEFAULT NULL COMMENT '是否报销',
  1134. `payment_state` int(1) DEFAULT '0' COMMENT '缴费状态',
  1135. PRIMARY KEY (`id`),
  1136. KEY `fk_patent_cost_patent_info1_idx` (`pid`)
  1137. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1138. /*!40101 SET character_set_client = @saved_cs_client */;
  1139. --
  1140. -- Table structure for table `patent_info`
  1141. --
  1142. DROP TABLE IF EXISTS `patent_info`;
  1143. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1144. /*!40101 SET character_set_client = utf8 */;
  1145. CREATE TABLE `patent_info` (
  1146. `id` varchar(36) NOT NULL,
  1147. `uid` varchar(36) NOT NULL DEFAULT '',
  1148. `contract_id` varchar(36) DEFAULT NULL COMMENT '合同ID',
  1149. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号',
  1150. `patent_number` varchar(20) DEFAULT NULL COMMENT '申请号/专利号',
  1151. `patent_name` varchar(64) DEFAULT NULL COMMENT '专利名称',
  1152. `patent_catagory` int(1) DEFAULT NULL COMMENT '专利类型',
  1153. `patent_state` int(2) DEFAULT NULL COMMENT '专利状态',
  1154. `patent_field` int(2) DEFAULT NULL COMMENT '专利领域',
  1155. `patent_des` varchar(128) DEFAULT NULL COMMENT '专利简介',
  1156. `patent_prory_statement_url` varchar(255) DEFAULT NULL COMMENT '专利代理委托书',
  1157. `patent_writing_url` varchar(255) DEFAULT NULL COMMENT '专利稿件',
  1158. `authorization_notice_url` varchar(255) DEFAULT NULL COMMENT '授权通知书',
  1159. `patent_certificate_url` varchar(255) DEFAULT NULL COMMENT '专利证书',
  1160. `patent_application_date` datetime DEFAULT NULL COMMENT '申请日/受理日',
  1161. `first_inventor_name` varchar(32) DEFAULT NULL COMMENT '第一发明人',
  1162. `first_inventor_nationality` varchar(16) DEFAULT NULL COMMENT '第一发明人国籍',
  1163. `first_inventor_id_number` varchar(18) DEFAULT NULL COMMENT '第一发明人身份证号',
  1164. `first_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第一发明人是否公布(0--不公布,1--公布)',
  1165. `second_inventor_name` varchar(32) DEFAULT NULL COMMENT '第二发明人姓名',
  1166. `second_inventor_nationality` varchar(16) DEFAULT NULL COMMENT '第二发明人国际',
  1167. `second_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第二发明人是否公布(0--不公布,1--公布)',
  1168. `third_inventor_name` varchar(32) DEFAULT NULL COMMENT '第三发明人姓名',
  1169. `third_inventor_nationality` varchar(12) DEFAULT NULL COMMENT '第三发明人国籍',
  1170. `third_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第三发明人是否公布(0--不公布,1--公布)',
  1171. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  1172. `author` varchar(36) DEFAULT NULL COMMENT '专利资料撰写人',
  1173. `authorized_date` datetime DEFAULT NULL COMMENT '授权日/发文日',
  1174. `office` varchar(16) DEFAULT NULL COMMENT '事务所',
  1175. `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
  1176. `confirm_state` int(1) DEFAULT '0' COMMENT '用户确认申报材料',
  1177. `record_time` datetime DEFAULT NULL COMMENT '发文日期时间',
  1178. `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记',
  1179. `contacts` int(1) DEFAULT NULL COMMENT '联系人及联系方式',
  1180. `founder` varchar(36) DEFAULT NULL COMMENT '申请创建人ID',
  1181. PRIMARY KEY (`id`),
  1182. KEY `serialNumber_UNIQUE` (`serial_number`) USING BTREE
  1183. ) ENGINE=InnoDB AUTO_INCREMENT=60000046 DEFAULT CHARSET=utf8;
  1184. /*!40101 SET character_set_client = @saved_cs_client */;
  1185. --
  1186. -- Table structure for table `patent_log`
  1187. --
  1188. DROP TABLE IF EXISTS `patent_log`;
  1189. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1190. /*!40101 SET character_set_client = utf8 */;
  1191. CREATE TABLE `patent_log` (
  1192. `id` varchar(36) NOT NULL,
  1193. `pid` varchar(36) NOT NULL,
  1194. `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间',
  1195. `state` int(2) DEFAULT NULL COMMENT '专利状态',
  1196. `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
  1197. `operator` varchar(36) DEFAULT NULL COMMENT '操作人',
  1198. `comment` varchar(128) DEFAULT NULL COMMENT '备注',
  1199. PRIMARY KEY (`id`),
  1200. KEY `fk_patent_log_patent_info1_idx` (`pid`)
  1201. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1202. /*!40101 SET character_set_client = @saved_cs_client */;
  1203. --
  1204. -- Table structure for table `patent_registration`
  1205. --
  1206. DROP TABLE IF EXISTS `patent_registration`;
  1207. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1208. /*!40101 SET character_set_client = utf8 */;
  1209. CREATE TABLE `patent_registration` (
  1210. `id` varchar(36) NOT NULL,
  1211. `pid` varchar(36) NOT NULL,
  1212. `acceptance_receive_time` datetime DEFAULT NULL COMMENT '受理通知书收到时间',
  1213. `acceptance_issue_time` datetime DEFAULT NULL COMMENT '受理通知书发出时间',
  1214. `acceptance_tracking_number` varchar(16) DEFAULT NULL COMMENT '受理通知书发出快递单号',
  1215. `acceptance_express_company` varchar(8) DEFAULT NULL COMMENT '受理通知书快递公司',
  1216. `authorization_receive_time` datetime DEFAULT NULL COMMENT '授权通知书收到时间',
  1217. `authorization_issue_time` datetime DEFAULT NULL COMMENT '授权通知书发出时间',
  1218. `authorization_tracking_number` varchar(16) DEFAULT NULL COMMENT '授权通知书快递单号',
  1219. `authorization_express_company` varchar(8) DEFAULT NULL COMMENT '授权通知书快递公司',
  1220. `certificate_recieve_time` datetime DEFAULT NULL COMMENT '专利证书收到时间',
  1221. `certificate_issue_time` datetime DEFAULT NULL COMMENT '专利证书发出时间',
  1222. `certificate_tracking_number` varchar(16) DEFAULT NULL COMMENT '专利证书快递单号',
  1223. `certificate_express_company` varchar(8) DEFAULT NULL COMMENT '专利证书快递公司',
  1224. PRIMARY KEY (`id`),
  1225. KEY `fk_table1_patent_info1_idx` (`pid`)
  1226. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1227. /*!40101 SET character_set_client = @saved_cs_client */;
  1228. --
  1229. -- Table structure for table `permission`
  1230. --
  1231. DROP TABLE IF EXISTS `permission`;
  1232. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1233. /*!40101 SET character_set_client = utf8 */;
  1234. CREATE TABLE `permission` (
  1235. `id` varchar(36) NOT NULL,
  1236. `url` varchar(128) NOT NULL COMMENT '权限对应的url path',
  1237. `name` varchar(45) DEFAULT NULL COMMENT '权限名字',
  1238. PRIMARY KEY (`id`)
  1239. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1240. /*!40101 SET character_set_client = @saved_cs_client */;
  1241. --
  1242. -- Table structure for table `role`
  1243. --
  1244. DROP TABLE IF EXISTS `role`;
  1245. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1246. /*!40101 SET character_set_client = utf8 */;
  1247. CREATE TABLE `role` (
  1248. `id` varchar(36) NOT NULL,
  1249. `role_name` varchar(16) DEFAULT NULL,
  1250. `role_type` int(6) NOT NULL DEFAULT '1',
  1251. PRIMARY KEY (`id`)
  1252. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1253. /*!40101 SET character_set_client = @saved_cs_client */;
  1254. --
  1255. -- Table structure for table `role_permission`
  1256. --
  1257. DROP TABLE IF EXISTS `role_permission`;
  1258. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1259. /*!40101 SET character_set_client = utf8 */;
  1260. CREATE TABLE `role_permission` (
  1261. `rid` varchar(36) NOT NULL,
  1262. `pid` varchar(36) NOT NULL,
  1263. PRIMARY KEY (`rid`,`pid`)
  1264. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1265. /*!40101 SET character_set_client = @saved_cs_client */;
  1266. --
  1267. -- Table structure for table `sys_dict`
  1268. --
  1269. DROP TABLE IF EXISTS `sys_dict`;
  1270. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1271. /*!40101 SET character_set_client = utf8 */;
  1272. CREATE TABLE `sys_dict` (
  1273. `id` varchar(36) NOT NULL,
  1274. `value` varchar(64) DEFAULT NULL,
  1275. PRIMARY KEY (`id`)
  1276. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1277. /*!40101 SET character_set_client = @saved_cs_client */;
  1278. --
  1279. -- Table structure for table `tech_project`
  1280. --
  1281. DROP TABLE IF EXISTS `tech_project`;
  1282. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1283. /*!40101 SET character_set_client = utf8 */;
  1284. CREATE TABLE `tech_project` (
  1285. `id` varchar(36) NOT NULL,
  1286. `uid` varchar(36) NOT NULL,
  1287. `contract_id` varchar(36) DEFAULT NULL COMMENT '合同ID',
  1288. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号',
  1289. `contacts` int(1) DEFAULT NULL COMMENT '联系人',
  1290. `department` varchar(45) DEFAULT NULL COMMENT '科技项目申报部门',
  1291. `dispatch_info` varchar(128) DEFAULT NULL COMMENT '派单信息',
  1292. `project_name` varchar(45) DEFAULT NULL COMMENT '项目名称',
  1293. `project_catagory` varchar(45) DEFAULT NULL COMMENT '项目类型',
  1294. `tech_field` varchar(45) DEFAULT NULL COMMENT '技术领域',
  1295. `project_des` varchar(600) DEFAULT NULL COMMENT '项目简介',
  1296. `project_mode` int(1) DEFAULT NULL COMMENT '是否立项',
  1297. `project_approval` decimal(8,2) DEFAULT NULL COMMENT '立项金额',
  1298. `subsidy` int(1) DEFAULT NULL COMMENT '是否补助',
  1299. `consultant` varchar(36) DEFAULT NULL COMMENT '咨询师',
  1300. `approval_url` varchar(255) DEFAULT NULL COMMENT '项目材料URL',
  1301. `state` int(2) DEFAULT NULL COMMENT '科技项目状态',
  1302. `create_time` datetime DEFAULT NULL COMMENT '派单日',
  1303. `accept_date` datetime DEFAULT NULL COMMENT '受理日',
  1304. `approved_date` datetime DEFAULT NULL COMMENT '项目批复日期',
  1305. `record_time` datetime DEFAULT NULL COMMENT '记录创建日期',
  1306. `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记',
  1307. `founder` varchar(36) DEFAULT NULL COMMENT '申请创建人ID',
  1308. `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
  1309. PRIMARY KEY (`id`),
  1310. KEY `serialNumber` (`serial_number`)
  1311. ) ENGINE=InnoDB AUTO_INCREMENT=600050 DEFAULT CHARSET=utf8 COMMENT='科技项目申请表';
  1312. /*!40101 SET character_set_client = @saved_cs_client */;
  1313. --
  1314. -- Table structure for table `tech_project_log`
  1315. --
  1316. DROP TABLE IF EXISTS `tech_project_log`;
  1317. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1318. /*!40101 SET character_set_client = utf8 */;
  1319. CREATE TABLE `tech_project_log` (
  1320. `id` varchar(36) NOT NULL,
  1321. `pid` varchar(36) NOT NULL,
  1322. `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间',
  1323. `state` int(2) DEFAULT NULL COMMENT '科技项目状态状态',
  1324. `principal` varchar(36) DEFAULT NULL COMMENT '负责人',
  1325. `operator` varchar(36) DEFAULT NULL COMMENT '操作人',
  1326. `comment` varchar(128) DEFAULT NULL COMMENT '备注',
  1327. PRIMARY KEY (`id`)
  1328. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技项目申报log';
  1329. /*!40101 SET character_set_client = @saved_cs_client */;
  1330. --
  1331. -- Table structure for table `tech_website`
  1332. --
  1333. DROP TABLE IF EXISTS `tech_website`;
  1334. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1335. /*!40101 SET character_set_client = utf8 */;
  1336. CREATE TABLE `tech_website` (
  1337. `id` varchar(36) NOT NULL,
  1338. `uid` varchar(36) DEFAULT NULL,
  1339. `department` varchar(45) DEFAULT NULL COMMENT '科技部门名称',
  1340. `website` varchar(255) DEFAULT NULL COMMENT '网址',
  1341. `account_number` varchar(45) DEFAULT NULL COMMENT '帐号',
  1342. `password` varchar(32) DEFAULT NULL COMMENT '密码',
  1343. `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  1344. `deleted_sign` int(1) DEFAULT NULL COMMENT '删除标记',
  1345. PRIMARY KEY (`id`)
  1346. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='科技项目申报网址';
  1347. /*!40101 SET character_set_client = @saved_cs_client */;
  1348. --
  1349. -- Table structure for table `user`
  1350. --
  1351. DROP TABLE IF EXISTS `user`;
  1352. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1353. /*!40101 SET character_set_client = utf8 */;
  1354. CREATE TABLE `user` (
  1355. `id` varchar(36) NOT NULL,
  1356. `mobile` varchar(12) NOT NULL COMMENT '用户注册手机号,作为登录依据',
  1357. `password` varchar(32) NOT NULL COMMENT '密码,md5+salt',
  1358. `nickname` varchar(16) DEFAULT NULL COMMENT '用户昵称',
  1359. `email` varchar(255) DEFAULT NULL COMMENT '用户邮箱',
  1360. `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  1361. `number` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
  1362. `lvl` int(2) DEFAULT '0',
  1363. `type` int(1) NOT NULL DEFAULT '0' COMMENT '个人账号还是组织账号\n默认0为个人账号,1为组织账号',
  1364. `aid` varchar(36) DEFAULT NULL COMMENT '管理员ID',
  1365. `mid` varchar(36) DEFAULT NULL COMMENT '客户经理ID',
  1366. PRIMARY KEY (`id`),
  1367. UNIQUE KEY `number_UNIQUE` (`number`) USING HASH
  1368. ) ENGINE=InnoDB AUTO_INCREMENT=800032 DEFAULT CHARSET=utf8;
  1369. /*!40101 SET character_set_client = @saved_cs_client */;
  1370. --
  1371. -- Table structure for table `user_ability`
  1372. --
  1373. DROP TABLE IF EXISTS `user_ability`;
  1374. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1375. /*!40101 SET character_set_client = utf8 */;
  1376. CREATE TABLE `user_ability` (
  1377. `id` varchar(36) NOT NULL,
  1378. `uid` varchar(36) NOT NULL,
  1379. `ability_label` varchar(255) DEFAULT NULL COMMENT '能力标签',
  1380. `intellect_right` varchar(500) DEFAULT NULL COMMENT '知识产权对企业竞争力的作用 ',
  1381. `science_achievement` varchar(500) DEFAULT NULL COMMENT ' 科技成果转化情况',
  1382. `research_innovation` varchar(500) DEFAULT NULL COMMENT '研究开发与技术创新组织管理情况',
  1383. `personnel` varchar(500) DEFAULT NULL COMMENT ' 管理与科技人员情况',
  1384. PRIMARY KEY (`id`)
  1385. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1386. /*!40101 SET character_set_client = @saved_cs_client */;
  1387. --
  1388. -- Table structure for table `user_career`
  1389. --
  1390. DROP TABLE IF EXISTS `user_career`;
  1391. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1392. /*!40101 SET character_set_client = utf8 */;
  1393. CREATE TABLE `user_career` (
  1394. `id` varchar(36) NOT NULL,
  1395. `uid` varchar(36) NOT NULL,
  1396. `engaged_field` varchar(255) DEFAULT NULL COMMENT '从事领域',
  1397. `working_age` varchar(3) DEFAULT NULL COMMENT '从业工龄',
  1398. `professional_title` varchar(45) DEFAULT NULL COMMENT '职称名字',
  1399. `professional_title_gettime` varchar(6) DEFAULT NULL COMMENT '职称取得时间(年份)',
  1400. `professional_certificate_url` varchar(255) DEFAULT NULL COMMENT '职称证明图',
  1401. `qualification` varchar(45) DEFAULT NULL COMMENT '执业资格',
  1402. `qualification_gettime` varchar(6) DEFAULT NULL COMMENT '执业资格取得时间(年份)',
  1403. `qualification_certificate_url` varchar(255) DEFAULT NULL COMMENT '执业资格证明图',
  1404. `work_unit` varchar(32) DEFAULT NULL COMMENT '工作单位',
  1405. `position` varchar(16) DEFAULT NULL COMMENT '职位/职务/头衔',
  1406. `experiences` varchar(1000) DEFAULT NULL COMMENT '从业经历',
  1407. `achievement` varchar(1000) DEFAULT NULL COMMENT '主要成就',
  1408. PRIMARY KEY (`id`)
  1409. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1410. /*!40101 SET character_set_client = @saved_cs_client */;
  1411. --
  1412. -- Table structure for table `user_edu`
  1413. --
  1414. DROP TABLE IF EXISTS `user_edu`;
  1415. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1416. /*!40101 SET character_set_client = utf8 */;
  1417. CREATE TABLE `user_edu` (
  1418. `id` varchar(36) NOT NULL,
  1419. `uid` varchar(36) NOT NULL,
  1420. `education` varchar(16) DEFAULT NULL COMMENT '学历',
  1421. `major_category` varchar(8) DEFAULT NULL COMMENT '专业类别',
  1422. `major_name` varchar(16) DEFAULT NULL COMMENT '专业名称',
  1423. `graduate_school` varchar(45) DEFAULT NULL COMMENT '毕业学校',
  1424. `graduation_time_year` varchar(4) DEFAULT NULL COMMENT '毕业时间(年份)',
  1425. `graduation_time_month` varchar(2) DEFAULT NULL COMMENT '毕业时间--月',
  1426. `graduation_time_day` varchar(2) DEFAULT NULL COMMENT '毕业时间--日',
  1427. `diploma_url` varchar(255) DEFAULT NULL COMMENT '毕业证图',
  1428. `diploma_code` varchar(32) DEFAULT NULL COMMENT '毕业证编号',
  1429. `degree_diploma_url` varchar(255) DEFAULT NULL COMMENT '学位证明图',
  1430. `degree_code` varchar(32) DEFAULT NULL COMMENT '学位证编号',
  1431. PRIMARY KEY (`id`)
  1432. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1433. /*!40101 SET character_set_client = @saved_cs_client */;
  1434. --
  1435. -- Table structure for table `user_identity`
  1436. --
  1437. DROP TABLE IF EXISTS `user_identity`;
  1438. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1439. /*!40101 SET character_set_client = utf8 */;
  1440. CREATE TABLE `user_identity` (
  1441. `id` varchar(36) NOT NULL,
  1442. `uid` varchar(36) NOT NULL,
  1443. `username` varchar(16) DEFAULT NULL COMMENT '姓名',
  1444. `sex` varchar(2) DEFAULT NULL COMMENT '性别',
  1445. `date_of_birth_year` varchar(4) DEFAULT NULL COMMENT '出生年',
  1446. `date_of_birth_month` varchar(2) DEFAULT NULL COMMENT '出生月',
  1447. `id_number` varchar(20) DEFAULT NULL COMMENT '省份证号码',
  1448. `positive_id_url` varchar(255) DEFAULT NULL COMMENT '身份证正面照',
  1449. `opposite_id_url` varchar(255) DEFAULT NULL COMMENT '身份证反面照',
  1450. `aft_username` varchar(16) DEFAULT NULL COMMENT '用户名',
  1451. `province` int(2) DEFAULT NULL COMMENT '所在地-省份',
  1452. `city` int(3) DEFAULT NULL COMMENT '所在地--市',
  1453. `area` int(4) DEFAULT NULL COMMENT '所在地--区',
  1454. `contact_mobile` varchar(16) DEFAULT NULL COMMENT '联系方式',
  1455. `bank_name` varchar(32) DEFAULT NULL COMMENT '银行开户名',
  1456. `bank_account` varchar(32) DEFAULT NULL COMMENT '开户银行',
  1457. `bank_card_number` varchar(32) DEFAULT NULL COMMENT '银行卡号',
  1458. `amount_money` decimal(6,4) DEFAULT NULL COMMENT '打款金额',
  1459. `audit_status` int(1) DEFAULT '0' COMMENT '审核状态(0--未提交审核,1-提交审核,2-审核未打款,3-审核已打款,4-审核未通过,5-审核通过)',
  1460. `process` int(1) DEFAULT '0' COMMENT '实名认证流程',
  1461. `wrong_count` int(1) DEFAULT '0' COMMENT '输入打款金额错误次数',
  1462. `payment_date` datetime DEFAULT NULL COMMENT '打款日期',
  1463. `expert` int(1) DEFAULT NULL COMMENT '专家(0--否,1--是)',
  1464. `celebrity` int(1) DEFAULT NULL COMMENT '明星(0--否,1--是)',
  1465. PRIMARY KEY (`id`)
  1466. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1467. /*!40101 SET character_set_client = @saved_cs_client */;
  1468. --
  1469. -- Table structure for table `user_info`
  1470. --
  1471. DROP TABLE IF EXISTS `user_info`;
  1472. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1473. /*!40101 SET character_set_client = utf8 */;
  1474. CREATE TABLE `user_info` (
  1475. `id` varchar(36) NOT NULL,
  1476. `uid` varchar(36) NOT NULL,
  1477. `residence_province` int(2) DEFAULT NULL COMMENT '居住地--省',
  1478. `residence_city` int(3) DEFAULT NULL COMMENT '居住地--市',
  1479. `residence_area` int(4) DEFAULT NULL COMMENT '居住地--区',
  1480. `person_portrait_url` varchar(255) DEFAULT NULL COMMENT '个人头像',
  1481. `life_photo_url` varchar(255) DEFAULT NULL COMMENT '生活照',
  1482. `personal_profile` varchar(1000) DEFAULT NULL COMMENT '个人简介',
  1483. `fixed_tel_area` varchar(8) DEFAULT NULL COMMENT '固定电话 区号',
  1484. `fixed_tel` varchar(12) DEFAULT NULL COMMENT '固定电话',
  1485. `fixed_tel_extension` varchar(8) DEFAULT NULL COMMENT '固定电话分机号',
  1486. `qq` varchar(16) DEFAULT NULL COMMENT 'QQ号码',
  1487. `postal_address` varchar(255) DEFAULT NULL COMMENT '通讯地址',
  1488. `postcode` varchar(8) DEFAULT NULL COMMENT '邮政编码',
  1489. PRIMARY KEY (`id`),
  1490. KEY `user_id_idx` (`uid`),
  1491. CONSTRAINT `uid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  1492. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1493. /*!40101 SET character_set_client = @saved_cs_client */;
  1494. --
  1495. -- Table structure for table `user_interest`
  1496. --
  1497. DROP TABLE IF EXISTS `user_interest`;
  1498. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1499. /*!40101 SET character_set_client = utf8 */;
  1500. CREATE TABLE `user_interest` (
  1501. `id` varchar(36) NOT NULL,
  1502. `from_uid` varchar(36) NOT NULL COMMENT '关注发起用户ID',
  1503. `to_uid` varchar(36) NOT NULL COMMENT '被关注用户ID',
  1504. `create_time` datetime NOT NULL COMMENT '关注时间',
  1505. PRIMARY KEY (`id`)
  1506. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户关注';
  1507. /*!40101 SET character_set_client = @saved_cs_client */;
  1508. --
  1509. -- Table structure for table `user_role`
  1510. --
  1511. DROP TABLE IF EXISTS `user_role`;
  1512. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1513. /*!40101 SET character_set_client = utf8 */;
  1514. CREATE TABLE `user_role` (
  1515. `uid` varchar(36) NOT NULL,
  1516. `rid` varchar(36) NOT NULL
  1517. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1518. /*!40101 SET character_set_client = @saved_cs_client */;
  1519. --
  1520. -- Table structure for table `value_evaluation`
  1521. --
  1522. DROP TABLE IF EXISTS `value_evaluation`;
  1523. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1524. /*!40101 SET character_set_client = utf8 */;
  1525. CREATE TABLE `value_evaluation` (
  1526. `id` bigint(18) NOT NULL,
  1527. `uid` varchar(36) DEFAULT NULL COMMENT '用户id',
  1528. `create_time` datetime NOT NULL DEFAULT current_timestamp() COMMENT '创建时间',
  1529. `name` varchar(128) DEFAULT NULL COMMENT '技术名称',
  1530. `value` bigint(18) DEFAULT NULL COMMENT '评估值',
  1531. `step` int(2) DEFAULT NULL COMMENT '当前步骤',
  1532. `log` longtext DEFAULT NULL COMMENT '步骤记录',
  1533. PRIMARY KEY (`id`),
  1534. KEY `uid_index` (`uid`)
  1535. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1536. /*!40101 SET character_set_client = @saved_cs_client */;
  1537. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  1538. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  1539. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  1540. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  1541. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1542. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1543. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  1544. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  1545. -- Dump completed on 2017-06-21 20:13:48