init.sql 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827
  1. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  2. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  3. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  4. /*!40101 SET NAMES utf8 */;
  5. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  6. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  7. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  8. # Dump of table admin
  9. # ------------------------------------------------------------
  10. DROP TABLE IF EXISTS `admin`;
  11. CREATE TABLE `admin` (
  12. `id` varchar(32) NOT NULL,
  13. `mobile` varchar(12) DEFAULT NULL COMMENT '手机号(登录帐号)',
  14. `name` varchar(6) DEFAULT NULL COMMENT '用户名',
  15. `password` varchar(32) DEFAULT NULL COMMENT '密码',
  16. `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  17. `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  18. `number` int(6) DEFAULT NULL COMMENT '员工工号',
  19. PRIMARY KEY (`id`)
  20. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  21. # Dump of table org_activity
  22. # ------------------------------------------------------------
  23. DROP TABLE IF EXISTS `org_activity`;
  24. CREATE TABLE `org_activity` (
  25. `id` varchar(36) NOT NULL,
  26. `uid` varchar(36) NOT NULL,
  27. `activity_number` varchar(32) DEFAULT NULL COMMENT '研发活动编号',
  28. `activity_name` varchar(32) DEFAULT NULL COMMENT '研发活动名称',
  29. `start_date` datetime DEFAULT NULL COMMENT '开始日期',
  30. `end_date` datetime DEFAULT NULL COMMENT '结束日期',
  31. `participant` varchar(255) DEFAULT NULL COMMENT '参与人员',
  32. `project_mode` int(1) DEFAULT NULL COMMENT '是否是内部立项',
  33. `technical_field1` varchar(3) DEFAULT NULL COMMENT '技术领域1st select',
  34. `technical_field2` varchar(3) DEFAULT NULL COMMENT '技术领域2nd select',
  35. `technical_field3` varchar(3) DEFAULT NULL COMMENT '技术领域3rd select',
  36. `technical_source` int(1) DEFAULT NULL COMMENT '技术来源',
  37. `intellectual_property_number` varchar(500) DEFAULT NULL COMMENT '知识产权编号',
  38. `budget` int(6) DEFAULT NULL COMMENT '研发经费总预算(万元)',
  39. `first_year_expenditure` int(6) DEFAULT NULL COMMENT '第一年研发经费支出(万元)',
  40. `second_year_expenditure` int(6) DEFAULT NULL COMMENT '第二年研发经费支出(万元)',
  41. `third_year_expenditure` int(6) DEFAULT NULL COMMENT '第三年研发经费支出(万元)',
  42. `implement` varchar(500) DEFAULT NULL COMMENT '目的及组织实施方式',
  43. `technology_innovation` varchar(500) DEFAULT NULL COMMENT '核心技术及创新点',
  44. `achievement` varchar(500) DEFAULT NULL COMMENT '取得的阶段性成果',
  45. `proof_url` varchar(255) DEFAULT NULL COMMENT '立项证明材料URL',
  46. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  47. PRIMARY KEY (`id`)
  48. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  49. # Dump of table org_activity_cost
  50. # ------------------------------------------------------------
  51. DROP TABLE IF EXISTS `org_activity_cost`;
  52. CREATE TABLE `org_activity_cost` (
  53. `id` varchar(36) NOT NULL,
  54. `aid` varchar(36) NOT NULL,
  55. `uid` varchar(36) NOT NULL,
  56. `activity_number` varchar(32) DEFAULT NULL COMMENT '项目编号',
  57. `internal_labor_cost` int(6) DEFAULT NULL COMMENT '内部人员人工费用(万元)',
  58. `internal_direct_cost` int(6) DEFAULT NULL COMMENT '内部直接投入费用(万元)',
  59. `internal_depreciation_cost` int(6) DEFAULT NULL COMMENT '内部折旧费用与长期待摊费用(万元)',
  60. `internal_amortization_cost` int(6) DEFAULT NULL COMMENT '内部无形资产摊销费用(万元)',
  61. `internal_design_cost` int(6) DEFAULT NULL COMMENT '内部设计费用(万元)',
  62. `internal_equipment_cost` int(6) DEFAULT NULL COMMENT '内部装备调试费用与实验费用(万元)',
  63. `internal_other_cost` int(6) DEFAULT NULL COMMENT '内部其他费用(万元)',
  64. `external_total_cost` int(6) DEFAULT NULL COMMENT '委托外部研究开发总费用(万元)',
  65. `external_abroad_cost` int(6) DEFAULT NULL COMMENT '委托外部境内的外部研发费用(万元)',
  66. `enterprise_filler` varchar(16) DEFAULT NULL COMMENT '企业填报人',
  67. `sign_date` datetime DEFAULT NULL COMMENT '企业填报人签字日期',
  68. `sort_number` varchar(32) DEFAULT NULL COMMENT '排序号',
  69. `start_date` datetime DEFAULT NULL,
  70. `end_date` datetime DEFAULT NULL,
  71. `account_url` varchar(255) DEFAULT NULL COMMENT '台帐URL',
  72. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  73. PRIMARY KEY (`id`),
  74. KEY `fk_org_activity_cost_org_activity1_idx` (`aid`)
  75. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  76. # Dump of table org_cognizance
  77. # ------------------------------------------------------------
  78. DROP TABLE IF EXISTS `org_cognizance`;
  79. CREATE TABLE `org_cognizance` (
  80. `id` varchar(36) NOT NULL,
  81. `uid` varchar(36) NOT NULL,
  82. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号',
  83. `contacts` varchar(36) DEFAULT NULL COMMENT '联系人及联系方式',
  84. `comment` varchar(1000) DEFAULT NULL COMMENT '备注',
  85. `consultant` varchar(32) DEFAULT NULL COMMENT '咨询师',
  86. `technical_field1` int(3) DEFAULT NULL COMMENT '技术领域1st select',
  87. `technical_field2` int(3) DEFAULT NULL COMMENT '技术领域2nd select',
  88. `technical_field3` int(3) DEFAULT NULL COMMENT '技术领域3rd select',
  89. `basic_research_cost` int(6) DEFAULT NULL COMMENT '基础研究投入费用总额(万元)',
  90. `accident` int(1) DEFAULT NULL COMMENT '申请认定前一年内是否发生过重大安全、重大质量或严重环境违法行为',
  91. `create_time` datetime DEFAULT NULL COMMENT '派单日',
  92. `accept_date` datetime DEFAULT NULL COMMENT '受理日',
  93. `issuing_date` datetime DEFAULT NULL COMMENT '发证日',
  94. `certificate_number` varchar(36) DEFAULT NULL COMMENT '证书编号',
  95. `certificate_url` varchar(255) DEFAULT NULL COMMENT '证书URL',
  96. `state` int(1) DEFAULT NULL COMMENT '状态',
  97. `year` int(4) DEFAULT NULL COMMENT '申请年份',
  98. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  99. PRIMARY KEY (`id`),
  100. KEY `serialNumber_UNIQUE` (`serial_number`) USING BTREE
  101. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  102. # Dump of table org_cognizance_log
  103. # ------------------------------------------------------------
  104. DROP TABLE IF EXISTS `org_cognizance_log`;
  105. CREATE TABLE `org_cognizance_log` (
  106. `id` varchar(36) NOT NULL,
  107. `cid` varchar(36) NOT NULL,
  108. `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间',
  109. `state` int(1) DEFAULT NULL COMMENT '状态',
  110. `principal` varchar(32) DEFAULT NULL COMMENT '负责人',
  111. `operator` varchar(32) DEFAULT NULL COMMENT '操作人',
  112. `comment` varchar(45) DEFAULT NULL COMMENT '备注',
  113. PRIMARY KEY (`id`),
  114. KEY `fk_org_cognizance_log_org_cognizance1_idx` (`cid`),
  115. CONSTRAINT `fk_org_cognizance_log_org_cognizance1` FOREIGN KEY (`cid`) REFERENCES `org_cognizance` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  116. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  117. # Dump of table org_finance
  118. # ------------------------------------------------------------
  119. DROP TABLE IF EXISTS `org_finance`;
  120. CREATE TABLE `org_finance` (
  121. `id` varchar(36) NOT NULL,
  122. `uid` varchar(36) NOT NULL,
  123. `main_business_income` int(6) DEFAULT NULL COMMENT '主营业务收入\r(万元)',
  124. `management_cost` int(6) DEFAULT NULL COMMENT '管理费用(万元)',
  125. `operating_profit` int(6) DEFAULT NULL COMMENT '营业利润(万元)',
  126. `various_tax` int(6) DEFAULT NULL COMMENT '支付的各项税费(万元)',
  127. `current_asset` int(6) DEFAULT NULL COMMENT '流动资产',
  128. `net_fixed_asset` int(6) DEFAULT NULL COMMENT '固定资产净额\r(万元)',
  129. `total_asset` int(6) DEFAULT NULL COMMENT '资产总额(万元)',
  130. `net_asset` int(6) DEFAULT NULL COMMENT '所有者权益合计(万元)',
  131. `gross_profit` int(6) DEFAULT NULL COMMENT '利润总额(万元)',
  132. `net_profit` int(6) DEFAULT NULL COMMENT '净利润(万元)',
  133. `sales_revenue` int(6) DEFAULT NULL COMMENT '销售收入(万元)',
  134. `year` int(4) DEFAULT NULL COMMENT '年份',
  135. `finance_url` varchar(255) DEFAULT NULL COMMENT '财务报表URL',
  136. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  137. PRIMARY KEY (`id`),
  138. KEY `fk_org_finance_user1_idx` (`uid`)
  139. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  140. # Dump of table org_honor_datum
  141. # ------------------------------------------------------------
  142. DROP TABLE IF EXISTS `org_honor_datum`;
  143. CREATE TABLE `org_honor_datum` (
  144. `id` varchar(36) NOT NULL,
  145. `uid` varchar(36) NOT NULL,
  146. `name` varchar(32) DEFAULT NULL COMMENT '荣誉或证明材料名称',
  147. `issuing_mechanism` varchar(36) DEFAULT NULL COMMENT '发证机构',
  148. `issuing_time` datetime DEFAULT NULL COMMENT '发证时间',
  149. `enclosure_url` varchar(255) DEFAULT NULL COMMENT '附件材料URL',
  150. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  151. PRIMARY KEY (`id`),
  152. KEY `fk_org_honor_datum_user1_idx` (`uid`)
  153. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  154. # Dump of table org_human_resource
  155. # ------------------------------------------------------------
  156. DROP TABLE IF EXISTS `org_human_resource`;
  157. CREATE TABLE `org_human_resource` (
  158. `id` varchar(36) NOT NULL,
  159. `uid` varchar(36) NOT NULL,
  160. `firm_total` int(6) DEFAULT NULL COMMENT '企业职工总数',
  161. `tech_total` int(6) DEFAULT NULL COMMENT '科技人员总数',
  162. `firm_in_service` int(6) DEFAULT NULL COMMENT '企业在职员工人数',
  163. `tech_in_service` int(6) DEFAULT NULL COMMENT '科技在职员工人数',
  164. `firm_part_time` int(6) DEFAULT NULL COMMENT '企业兼职人数',
  165. `tech_part_time` int(6) DEFAULT NULL COMMENT '科技人员兼职人数',
  166. `firm_temporary` int(6) DEFAULT NULL COMMENT '企业临时聘用人数',
  167. `tech_temporary` int(6) DEFAULT NULL COMMENT '科技人员临时聘用人数',
  168. `firm_foreign` int(6) DEFAULT NULL COMMENT '企业外籍人员数',
  169. `tech_foreign` int(6) DEFAULT NULL COMMENT '外籍科技人员数',
  170. `firm_abroad` int(6) DEFAULT NULL COMMENT '企业留学归国人员数',
  171. `tech_abroad` int(6) DEFAULT NULL COMMENT '留学归国科技人员数',
  172. `firm_core` int(6) DEFAULT NULL COMMENT '企业千人计划人数',
  173. `tech_core` int(6) DEFAULT NULL COMMENT '千人计划科技人员数',
  174. `doctor` int(6) DEFAULT NULL COMMENT '博士人数',
  175. `master` int(6) DEFAULT NULL COMMENT '硕士人数',
  176. `undergraduate` int(6) DEFAULT NULL COMMENT '本科人数',
  177. `college` int(6) DEFAULT NULL COMMENT '大专人数',
  178. `senior_title` int(6) DEFAULT NULL COMMENT '高级职称人数',
  179. `intermediate_title` int(6) DEFAULT NULL COMMENT '中级职称人数',
  180. `junior_title` int(6) DEFAULT NULL COMMENT '初级职称人数',
  181. `senior_mechanic` int(6) DEFAULT NULL COMMENT '高级技工人数',
  182. `below_thirty` int(6) DEFAULT NULL COMMENT '三十岁及以下员工人数',
  183. `thirtyone_to_thirtyfour` int(6) DEFAULT NULL COMMENT '三十一至三十四岁员工人数',
  184. `fortyone_to_fifty` int(6) DEFAULT NULL COMMENT '四十一至五十岁员工人数',
  185. `above_fifty` int(6) DEFAULT NULL COMMENT '五十岁以上员工人数',
  186. `year` int(4) DEFAULT NULL COMMENT '年份',
  187. `roster_url` varchar(255) DEFAULT NULL COMMENT '花名册URL',
  188. `social_security_url` varchar(255) DEFAULT NULL COMMENT '社保情况URL',
  189. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  190. PRIMARY KEY (`id`)
  191. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  192. # Dump of table org_intellectual_property
  193. # ------------------------------------------------------------
  194. DROP TABLE IF EXISTS `org_intellectual_property`;
  195. CREATE TABLE `org_intellectual_property` (
  196. `id` varchar(36) NOT NULL,
  197. `uid` varchar(36) NOT NULL,
  198. `pid` varchar(36) DEFAULT NULL COMMENT '专利记录ID',
  199. `intellectual_property_number` varchar(32) DEFAULT NULL COMMENT '知识产权编号',
  200. `intellectual_property_name` varchar(32) DEFAULT NULL COMMENT '知识产权名称',
  201. `sort_number` varchar(36) DEFAULT NULL COMMENT '排序号',
  202. `catagory` int(2) DEFAULT NULL COMMENT '类别',
  203. `obtain_way` int(1) DEFAULT NULL COMMENT '获得方式',
  204. `authorization_number` varchar(32) DEFAULT NULL COMMENT '授权号',
  205. `authorization_date` datetime DEFAULT NULL COMMENT '授权日期',
  206. `evaluation_category` int(1) DEFAULT NULL COMMENT '0--Ⅰ类, 1--Ⅱ类',
  207. `property_right_url` varchar(255) DEFAULT NULL COMMENT '知识产权证书URL',
  208. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  209. PRIMARY KEY (`id`),
  210. KEY `fk_org_intellectual_property_user1_idx` (`uid`)
  211. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  212. # Dump of table org_ratepay
  213. # ------------------------------------------------------------
  214. DROP TABLE IF EXISTS `org_ratepay`;
  215. CREATE TABLE `org_ratepay` (
  216. `id` varchar(36) NOT NULL,
  217. `uid` varchar(36) NOT NULL,
  218. `operating_income` int(6) DEFAULT NULL COMMENT '营业收入(万元)',
  219. `management_cost` int(6) DEFAULT NULL COMMENT '管理费用(万元)',
  220. `operating_profit` int(6) DEFAULT NULL COMMENT '营业利润\r(万元)',
  221. `non_operating_income` int(6) DEFAULT NULL COMMENT '营业外收入(万元)',
  222. `non_taxable_income` int(6) DEFAULT NULL COMMENT '不征税收入\r(万元)',
  223. `tax_exempt_income` int(6) DEFAULT NULL COMMENT '免税收入(万元)',
  224. `subsidy_income` int(6) DEFAULT NULL COMMENT '政府补助收入(万元)',
  225. `year` int(4) DEFAULT NULL COMMENT '年份',
  226. `tax_return_url` varchar(255) DEFAULT NULL COMMENT '纳税申报表url',
  227. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  228. PRIMARY KEY (`id`),
  229. KEY `fk_org_ratepay_user1_idx` (`uid`)
  230. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  231. # Dump of table org_standard
  232. # ------------------------------------------------------------
  233. DROP TABLE IF EXISTS `org_standard`;
  234. CREATE TABLE `org_standard` (
  235. `id` varchar(36) NOT NULL,
  236. `uid` varchar(36) NOT NULL,
  237. `standard_name` varchar(32) DEFAULT NULL COMMENT '标准名称',
  238. `standard_number` varchar(36) DEFAULT NULL COMMENT '标准编号',
  239. `standard_level` int(1) DEFAULT NULL COMMENT '标准级别',
  240. `participate_way` int(11) DEFAULT NULL COMMENT '参与方式',
  241. `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  242. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  243. PRIMARY KEY (`id`)
  244. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  245. # Dump of table org_tech_achievement
  246. # ------------------------------------------------------------
  247. DROP TABLE IF EXISTS `org_tech_achievement`;
  248. CREATE TABLE `org_tech_achievement` (
  249. `id` varchar(36) NOT NULL,
  250. `uid` varchar(36) NOT NULL,
  251. `achievement_name` varchar(32) DEFAULT NULL COMMENT '成果名称',
  252. `source` varchar(36) DEFAULT NULL COMMENT '来源',
  253. `conversion_form` int(1) DEFAULT NULL COMMENT '转化形式',
  254. `conversion_result` varchar(255) DEFAULT NULL COMMENT '转化结果',
  255. `year` int(4) DEFAULT NULL COMMENT '转化年份',
  256. `enclosure_url` varchar(255) DEFAULT NULL COMMENT '证明材料附件URL',
  257. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  258. PRIMARY KEY (`id`),
  259. KEY `fk_org_tech_achievment_user1_idx` (`uid`)
  260. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  261. # Dump of table org_tech_center
  262. # ------------------------------------------------------------
  263. DROP TABLE IF EXISTS `org_tech_center`;
  264. CREATE TABLE `org_tech_center` (
  265. `id` varchar(36) NOT NULL,
  266. `uid` varchar(36) NOT NULL,
  267. `center_name` varchar(36) DEFAULT NULL COMMENT '技术中心名称',
  268. `founding_time` datetime DEFAULT NULL COMMENT '成立时间',
  269. `principal` varchar(32) DEFAULT NULL COMMENT '负责人',
  270. `system_catalog` longtext COMMENT '制度目录',
  271. `comment` varchar(1000) DEFAULT NULL,
  272. `system_url` varchar(255) DEFAULT NULL COMMENT '制度目录URL',
  273. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  274. PRIMARY KEY (`id`),
  275. KEY `fk_org_tech_center_user1_idx` (`uid`)
  276. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  277. # Dump of table org_tech_center_detail
  278. # ------------------------------------------------------------
  279. DROP TABLE IF EXISTS `org_tech_center_detail`;
  280. CREATE TABLE `org_tech_center_detail` (
  281. `id` varchar(36) NOT NULL,
  282. `cid` varchar(36) NOT NULL,
  283. `project_time` datetime DEFAULT NULL COMMENT '产学研时间',
  284. `project_name` varchar(32) DEFAULT NULL COMMENT '产学研名称',
  285. `term_time` datetime DEFAULT NULL COMMENT '期限',
  286. `institution` varchar(32) DEFAULT NULL COMMENT '大学机构',
  287. `protocol_url` varchar(255) DEFAULT NULL COMMENT '协议URL',
  288. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  289. PRIMARY KEY (`id`),
  290. KEY `fk_org_tech_center_detail_org_tech_center1_idx` (`cid`)
  291. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  292. # Dump of table org_tech_product
  293. # ------------------------------------------------------------
  294. DROP TABLE IF EXISTS `org_tech_product`;
  295. CREATE TABLE `org_tech_product` (
  296. `id` varchar(36) NOT NULL,
  297. `uid` varchar(36) NOT NULL,
  298. `serial_number` varchar(32) DEFAULT NULL COMMENT '编号',
  299. `product_name` varchar(32) DEFAULT NULL COMMENT '产品名称',
  300. `technical_field1` int(3) DEFAULT NULL COMMENT '技术领域1st select',
  301. `technical_field2` int(3) DEFAULT NULL COMMENT '技术领域2nd select',
  302. `technical_field3` int(3) DEFAULT NULL COMMENT '技术领域3rd select',
  303. `technical_source` int(1) DEFAULT NULL COMMENT '技术来源',
  304. `last_year_revenue` varchar(45) DEFAULT NULL COMMENT '上年度销售收入',
  305. `main_product` int(1) DEFAULT NULL COMMENT '是否是主要产品(服务)',
  306. `intellectual_property_number` varchar(500) DEFAULT NULL COMMENT '知识产权编号',
  307. `key_technology` varchar(500) DEFAULT NULL COMMENT '关键技术及主要技术指标',
  308. `competitive_edge` varchar(500) DEFAULT NULL COMMENT '与同类产品(服务)的竞争优势',
  309. `condition_effect` varchar(500) DEFAULT NULL COMMENT '知识产权获得情况及其对产品(服务)在技术上发挥的支持作用',
  310. `year` int(6) DEFAULT NULL COMMENT '年份',
  311. `create_time` datetime DEFAULT NULL COMMENT '记录创建时间',
  312. `deleted_sign` int(1) DEFAULT '0' COMMENT '删除标记',
  313. PRIMARY KEY (`id`),
  314. KEY `fk_org_tech_product_user1_idx` (`uid`)
  315. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  316. # Dump of table organization_identity
  317. # ------------------------------------------------------------
  318. DROP TABLE IF EXISTS `organization_identity`;
  319. CREATE TABLE `organization_identity` (
  320. `id` varchar(36) NOT NULL,
  321. `uid` varchar(36) NOT NULL,
  322. `contacts` varchar(6) DEFAULT NULL COMMENT '联系人',
  323. `contact_mobile` varchar(16) DEFAULT NULL COMMENT '联系方式',
  324. `fixed_tel` varchar(16) DEFAULT NULL COMMENT '固定电话',
  325. `qq` varchar(16) DEFAULT NULL COMMENT 'QQ号',
  326. `postal_address` varchar(255) DEFAULT NULL COMMENT '通讯地址',
  327. `postcode` varchar(8) DEFAULT NULL COMMENT '邮政编码',
  328. `aft_username` varchar(32) DEFAULT NULL COMMENT '用户名',
  329. `unit_name` varchar(45) DEFAULT NULL COMMENT '单位名称',
  330. `registered_capital` int(6) DEFAULT NULL COMMENT '注册资金',
  331. `licence_number` varchar(32) DEFAULT NULL COMMENT '营业执照注册号',
  332. `licence_province` varchar(12) DEFAULT NULL COMMENT '营业执照所在地--省',
  333. `licence_city` varchar(12) DEFAULT NULL COMMENT '营业执照所在地-市',
  334. `licence_area` varchar(12) DEFAULT NULL COMMENT '营业执照所在地-区(县)',
  335. `licence_scanning_url` varchar(255) DEFAULT NULL COMMENT '营业执照副本扫描件URL',
  336. `org_code` varchar(32) DEFAULT NULL COMMENT '组织机构代码证号码',
  337. `org_code_url` varchar(255) DEFAULT NULL COMMENT '组织机构代码证URL',
  338. `bank_account` varchar(32) DEFAULT NULL COMMENT '银行账号',
  339. `banks` varchar(32) DEFAULT NULL COMMENT '开户行',
  340. `bank_branch` varchar(32) DEFAULT NULL COMMENT '开户行支行',
  341. `bank_card_number` varchar(32) DEFAULT NULL COMMENT '银行卡号',
  342. `validation_amount` decimal(6,4) DEFAULT '0.0000' COMMENT '打入账内信息',
  343. `identity_type` int(1) DEFAULT NULL COMMENT '身份类型',
  344. `location_province` varchar(12) DEFAULT NULL COMMENT '开户行所在地-省',
  345. `location_city` varchar(12) DEFAULT NULL COMMENT '开户行所在地-市',
  346. `location_area` varchar(12) DEFAULT NULL COMMENT '开户行所在地-区(县)',
  347. `legal_person` varchar(16) DEFAULT NULL COMMENT '法人',
  348. `legal_person_id_card` varchar(32) DEFAULT NULL COMMENT '法人身份证号',
  349. `last_year_tax_report_url` varchar(255) DEFAULT NULL COMMENT '上年度纳税报表',
  350. `audit_status` int(1) DEFAULT '0' COMMENT '审核状态',
  351. `process` int(1) DEFAULT '0' COMMENT '实名认证流程',
  352. `wrong_count` int(1) DEFAULT '0' COMMENT '输入打款金额错误次数',
  353. `payment_date` datetime DEFAULT NULL COMMENT '打款日期',
  354. `first_contacts` varchar(16) DEFAULT NULL,
  355. `first_mobile` varchar(16) DEFAULT NULL,
  356. `second_contacts` varchar(16) DEFAULT NULL,
  357. `second_mobile` varchar(16) DEFAULT NULL,
  358. `third_contacts` varchar(16) DEFAULT NULL,
  359. `third_mobile` varchar(16) DEFAULT NULL,
  360. PRIMARY KEY (`id`)
  361. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  362. # Dump of table organization_info
  363. # ------------------------------------------------------------
  364. DROP TABLE IF EXISTS `organization_info`;
  365. CREATE TABLE `organization_info` (
  366. `id` varchar(36) NOT NULL,
  367. `uid` varchar(36) NOT NULL,
  368. `identity_type` varchar(6) DEFAULT NULL COMMENT '身份类型',
  369. `company_name` varchar(45) DEFAULT NULL COMMENT '公司名称',
  370. `legal_person` varchar(6) DEFAULT NULL COMMENT '法人代表',
  371. `location_province` varchar(12) DEFAULT NULL COMMENT '所在地--省',
  372. `location_city` varchar(12) DEFAULT NULL COMMENT '所在地--市',
  373. `location_area` varchar(12) DEFAULT NULL COMMENT '所在地--区',
  374. `unit_size` varchar(12) DEFAULT NULL COMMENT '单位规模',
  375. `company_introduction` varchar(1002) DEFAULT NULL COMMENT '单位简介',
  376. `home_unit` varchar(45) DEFAULT NULL COMMENT '所属单位',
  377. `logo_url` varchar(255) DEFAULT NULL COMMENT 'logo图',
  378. `publicity_picture_url` longtext COMMENT '宣传图片',
  379. PRIMARY KEY (`id`)
  380. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  381. # Dump of table organization_properties
  382. # ------------------------------------------------------------
  383. DROP TABLE IF EXISTS `organization_properties`;
  384. CREATE TABLE `organization_properties` (
  385. `id` varchar(36) NOT NULL,
  386. `oid` varchar(36) NOT NULL,
  387. `qualification` varchar(45) DEFAULT NULL COMMENT '企业资质',
  388. `turnover` int(8) DEFAULT NULL COMMENT '年营业额',
  389. `college_attribute` varchar(45) DEFAULT NULL COMMENT '院校属性',
  390. `college_establish_time` varchar(12) DEFAULT NULL COMMENT '院校创办时间',
  391. `academician` int(5) DEFAULT NULL COMMENT '院士',
  392. `doctoral_tutor` int(5) DEFAULT NULL COMMENT '博士生导师',
  393. `master_tutor` int(5) DEFAULT NULL COMMENT '硕士生导师',
  394. `other_expert` int(5) DEFAULT NULL COMMENT '其他专家',
  395. `national_lab` int(5) DEFAULT NULL COMMENT '国家重点实验室',
  396. `education_lab` int(5) DEFAULT NULL,
  397. `enterprise_center` int(5) DEFAULT NULL COMMENT '企业共建研究中心',
  398. `other_center` int(5) DEFAULT NULL COMMENT '其他研究中心',
  399. `institution_establish_time` varchar(12) DEFAULT NULL COMMENT '研究机构创办时间',
  400. PRIMARY KEY (`id`)
  401. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  402. # Dump of table organization_tech
  403. # ------------------------------------------------------------
  404. DROP TABLE IF EXISTS `organization_tech`;
  405. CREATE TABLE `organization_tech` (
  406. `id` varchar(36) NOT NULL,
  407. `uid` varchar(36) NOT NULL,
  408. `technical_people_num` varchar(12) DEFAULT NULL COMMENT '技术人员数量',
  409. `search_area_category` varchar(255) DEFAULT NULL COMMENT '重点研究领域类别',
  410. `search_area_det` varchar(32) DEFAULT NULL COMMENT '重点研究领域明细',
  411. `specialty` varchar(32) DEFAULT NULL COMMENT '擅长领域',
  412. PRIMARY KEY (`id`)
  413. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  414. # Dump of table patent_cost
  415. # ------------------------------------------------------------
  416. DROP TABLE IF EXISTS `patent_cost`;
  417. CREATE TABLE `patent_cost` (
  418. `id` varchar(36) NOT NULL,
  419. `pid` varchar(36) NOT NULL,
  420. `annual_fee` int(6) DEFAULT NULL COMMENT '年登印费',
  421. `annual_fee_state` int(1) DEFAULT '0' COMMENT '年登印费缴费状态',
  422. `application_fee` int(6) DEFAULT NULL COMMENT '申请费',
  423. `trial_fee` int(6) DEFAULT NULL COMMENT '实审费',
  424. `printing_fee` int(6) DEFAULT NULL COMMENT '文印费',
  425. `funds` int(1) DEFAULT NULL COMMENT '是否请款',
  426. `reimbursement` int(1) DEFAULT NULL COMMENT '是否报销',
  427. `payment_state` int(1) DEFAULT '0' COMMENT '缴费状态',
  428. PRIMARY KEY (`id`),
  429. KEY `fk_patent_cost_patent_info1_idx` (`pid`)
  430. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  431. # Dump of table patent_info
  432. # ------------------------------------------------------------
  433. DROP TABLE IF EXISTS `patent_info`;
  434. CREATE TABLE `patent_info` (
  435. `id` varchar(36) NOT NULL,
  436. `uid` varchar(36) NOT NULL,
  437. `serial_number` int(8) NOT NULL AUTO_INCREMENT COMMENT '编号',
  438. `patent_number` varchar(16) DEFAULT NULL COMMENT '申请号/专利号',
  439. `patent_name` varchar(16) DEFAULT NULL COMMENT '专利名称',
  440. `patent_catagory` int(1) DEFAULT NULL COMMENT '专利类型',
  441. `patent_state` int(1) DEFAULT NULL COMMENT '专利状态',
  442. `patent_field` int(2) DEFAULT NULL COMMENT '专利领域',
  443. `patent_des` varchar(1000) DEFAULT NULL COMMENT '专利简介',
  444. `patent_prory_statement_url` varchar(255) DEFAULT NULL COMMENT '专利代理委托书',
  445. `patent_writing_url` varchar(255) DEFAULT NULL COMMENT '专利稿件',
  446. `authorization_notice_url` varchar(255) DEFAULT NULL COMMENT '授权通知书',
  447. `patent_certificate_url` varchar(255) DEFAULT NULL COMMENT '专利证书',
  448. `patent_application_date` datetime DEFAULT NULL COMMENT '申请日/受理日',
  449. `first_inventor_name` varchar(32) DEFAULT NULL COMMENT '第一发明人',
  450. `first_inventor_nationality` varchar(16) DEFAULT NULL COMMENT '第一发明人国籍',
  451. `first_inventor_id_number` varchar(18) DEFAULT NULL COMMENT '第一发明人身份证号',
  452. `first_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第一发明人是否公布(0--不公布,1--公布)',
  453. `second_inventor_name` varchar(32) DEFAULT NULL COMMENT '第二发明人姓名',
  454. `second_inventor_nationality` varchar(16) DEFAULT NULL COMMENT '第二发明人国际',
  455. `second_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第二发明人是否公布(0--不公布,1--公布)',
  456. `third_inventor_name` varchar(32) DEFAULT NULL COMMENT '第三发明人姓名',
  457. `third_inventor_nationality` varchar(12) DEFAULT NULL COMMENT '第三发明人国籍',
  458. `third_inventor_is_publish` int(1) DEFAULT '0' COMMENT '第三发明人是否公布(0--不公布,1--公布)',
  459. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  460. `author` varchar(32) DEFAULT NULL COMMENT '撰写人',
  461. `authorized_date` datetime DEFAULT NULL COMMENT '授权日/发文日',
  462. `office` varchar(16) DEFAULT NULL COMMENT '事务所',
  463. `principal` varchar(32) DEFAULT NULL COMMENT '负责人',
  464. `confirm_state` int(1) DEFAULT '0' COMMENT '用户确认申报材料',
  465. PRIMARY KEY (`id`),
  466. KEY `serialNumber_UNIQUE` (`serial_number`) USING BTREE
  467. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  468. # Dump of table patent_log
  469. # ------------------------------------------------------------
  470. DROP TABLE IF EXISTS `patent_log`;
  471. CREATE TABLE `patent_log` (
  472. `id` varchar(36) NOT NULL,
  473. `pid` varchar(36) NOT NULL,
  474. `record_time` datetime DEFAULT NULL COMMENT '状态变更录入时间',
  475. `state` int(1) DEFAULT NULL COMMENT '状态',
  476. `principal` varchar(32) DEFAULT NULL COMMENT '负责人',
  477. `operator` varchar(32) DEFAULT NULL COMMENT '操作人',
  478. `comment` varchar(45) DEFAULT NULL COMMENT '备注',
  479. PRIMARY KEY (`id`),
  480. KEY `fk_patent_log_patent_info1_idx` (`pid`)
  481. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  482. # Dump of table patent_registration
  483. # ------------------------------------------------------------
  484. DROP TABLE IF EXISTS `patent_registration`;
  485. CREATE TABLE `patent_registration` (
  486. `id` varchar(36) NOT NULL,
  487. `pid` varchar(36) NOT NULL,
  488. `acceptance_receive_time` datetime DEFAULT NULL COMMENT '受理通知书收到时间',
  489. `acceptance_issue_time` datetime DEFAULT NULL COMMENT '受理通知书发出时间',
  490. `acceptance_tracking_number` varchar(16) DEFAULT NULL COMMENT '受理通知书发出快递单号',
  491. `acceptance_express_company` varchar(8) DEFAULT NULL COMMENT '受理通知书快递公司',
  492. `authorization_receive_time` datetime DEFAULT NULL COMMENT '授权通知书收到时间',
  493. `authorization_issue_time` datetime DEFAULT NULL COMMENT '授权通知书发出时间',
  494. `authorization_tracking_number` varchar(16) DEFAULT NULL COMMENT '授权通知书快递单号',
  495. `authorization_express_company` varchar(8) DEFAULT NULL COMMENT '授权通知书快递公司',
  496. `certificate_recieve_time` datetime DEFAULT NULL COMMENT '专利证书收到时间',
  497. `certificate_issue_time` datetime DEFAULT NULL COMMENT '专利证书发出时间',
  498. `certificate_tracking_number` varchar(16) DEFAULT NULL COMMENT '专利证书快递单号',
  499. `certificate_express_company` varchar(8) DEFAULT NULL COMMENT '专利证书快递公司',
  500. PRIMARY KEY (`id`),
  501. KEY `fk_table1_patent_info1_idx` (`pid`)
  502. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  503. # Dump of table permission
  504. # ------------------------------------------------------------
  505. DROP TABLE IF EXISTS `permission`;
  506. CREATE TABLE `permission` (
  507. `id` varchar(36) NOT NULL,
  508. `url` varchar(128) NOT NULL COMMENT '权限对应的url path',
  509. `name` varchar(45) DEFAULT NULL COMMENT '权限名字',
  510. PRIMARY KEY (`id`)
  511. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  512. # Dump of table role
  513. # ------------------------------------------------------------
  514. DROP TABLE IF EXISTS `role`;
  515. CREATE TABLE `role` (
  516. `id` varchar(36) NOT NULL,
  517. `role_name` varchar(16) DEFAULT NULL,
  518. `role_type` int(6) DEFAULT NULL,
  519. PRIMARY KEY (`id`)
  520. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  521. # Dump of table role_permission
  522. # ------------------------------------------------------------
  523. DROP TABLE IF EXISTS `role_permission`;
  524. CREATE TABLE `role_permission` (
  525. `rid` varchar(36) NOT NULL,
  526. `pid` varchar(36) NOT NULL
  527. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  528. # Dump of table user
  529. # ------------------------------------------------------------
  530. DROP TABLE IF EXISTS `user`;
  531. CREATE TABLE `user` (
  532. `id` varchar(36) NOT NULL,
  533. `mobile` varchar(12) NOT NULL COMMENT '用户注册手机号,作为登录依据',
  534. `password` varchar(32) NOT NULL COMMENT '密码,md5+salt',
  535. `nickname` varchar(16) DEFAULT NULL COMMENT '用户昵称',
  536. `email` varchar(255) DEFAULT NULL COMMENT '用户邮箱',
  537. `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  538. `number` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
  539. `lvl` int(2) DEFAULT '0',
  540. `type` int(1) NOT NULL DEFAULT '0' COMMENT '个人账号还是组织账号\n默认0为个人账号,1为组织账号',
  541. PRIMARY KEY (`id`),
  542. UNIQUE KEY `number_UNIQUE` (`number`)
  543. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  544. # Dump of table user_ability
  545. # ------------------------------------------------------------
  546. DROP TABLE IF EXISTS `user_ability`;
  547. CREATE TABLE `user_ability` (
  548. `id` varchar(36) NOT NULL,
  549. `uid` varchar(36) NOT NULL,
  550. `ability_label` varchar(255) DEFAULT NULL COMMENT '能力标签',
  551. `intellect_right` varchar(500) DEFAULT NULL COMMENT '知识产权对企业竞争力的作用 ',
  552. `science_achievement` varchar(500) DEFAULT NULL COMMENT ' 科技成果转化情况',
  553. `research_innovation` varchar(500) DEFAULT NULL COMMENT '研究开发与技术创新组织管理情况',
  554. `personnel` varchar(500) DEFAULT NULL COMMENT ' 管理与科技人员情况',
  555. PRIMARY KEY (`id`)
  556. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  557. # Dump of table user_career
  558. # ------------------------------------------------------------
  559. DROP TABLE IF EXISTS `user_career`;
  560. CREATE TABLE `user_career` (
  561. `id` varchar(36) NOT NULL,
  562. `uid` varchar(36) NOT NULL,
  563. `engaged_field` varchar(255) DEFAULT NULL COMMENT '从事领域',
  564. `working_age` varchar(3) DEFAULT NULL COMMENT '从业工龄',
  565. `professional_title` varchar(45) DEFAULT NULL COMMENT '职称名字',
  566. `professional_title_gettime` varchar(6) DEFAULT NULL COMMENT '职称取得时间(年份)',
  567. `professional_certificate_url` varchar(255) DEFAULT NULL COMMENT '职称证明图',
  568. `qualification` varchar(45) DEFAULT NULL COMMENT '执业资格',
  569. `qualification_gettime` varchar(6) DEFAULT NULL COMMENT '执业资格取得时间(年份)',
  570. `qualification_certificate_url` varchar(255) DEFAULT NULL COMMENT '执业资格证明图',
  571. `work_unit` varchar(32) DEFAULT NULL COMMENT '工作单位',
  572. `position` varchar(16) DEFAULT NULL COMMENT '职位/职务/头衔',
  573. `experiences` longtext COMMENT '从业经历',
  574. `achievement` longtext COMMENT '主要成就',
  575. PRIMARY KEY (`id`)
  576. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  577. # Dump of table user_edu
  578. # ------------------------------------------------------------
  579. DROP TABLE IF EXISTS `user_edu`;
  580. CREATE TABLE `user_edu` (
  581. `id` varchar(36) NOT NULL,
  582. `uid` varchar(36) NOT NULL,
  583. `education` varchar(16) DEFAULT NULL COMMENT '学历',
  584. `major_category` varchar(8) DEFAULT NULL COMMENT '专业类别',
  585. `major_name` varchar(16) DEFAULT NULL COMMENT '专业名称',
  586. `graduate_school` varchar(45) DEFAULT NULL COMMENT '毕业学校',
  587. `graduation_time_year` varchar(4) DEFAULT NULL COMMENT '毕业时间(年份)',
  588. `graduation_time_month` varchar(2) DEFAULT NULL COMMENT '毕业时间--月',
  589. `graduation_time_day` varchar(2) DEFAULT NULL COMMENT '毕业时间--日',
  590. `diploma_url` varchar(255) DEFAULT NULL COMMENT '毕业证图',
  591. `diploma_code` varchar(32) DEFAULT NULL COMMENT '毕业证编号',
  592. `degree_diploma_url` varchar(255) DEFAULT NULL COMMENT '学位证明图',
  593. `degree_code` varchar(32) CHARACTER SET big5 DEFAULT NULL COMMENT '学位证编号',
  594. PRIMARY KEY (`id`)
  595. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  596. # Dump of table user_identity
  597. # ------------------------------------------------------------
  598. DROP TABLE IF EXISTS `user_identity`;
  599. CREATE TABLE `user_identity` (
  600. `id` varchar(36) NOT NULL,
  601. `uid` varchar(36) NOT NULL,
  602. `username` varchar(16) DEFAULT NULL COMMENT '姓名',
  603. `sex` varchar(2) DEFAULT NULL COMMENT '性别',
  604. `date_of_birth_year` varchar(4) DEFAULT NULL COMMENT '出生年',
  605. `date_of_birth_month` varchar(2) DEFAULT NULL COMMENT '出生月',
  606. `id_number` varchar(20) DEFAULT NULL COMMENT '省份证号码',
  607. `positive_id_url` varchar(255) DEFAULT NULL COMMENT '身份证正面照',
  608. `opposite_id_url` varchar(255) DEFAULT NULL COMMENT '身份证反面照',
  609. `aft_username` varchar(16) DEFAULT NULL COMMENT '用户名',
  610. `province` varchar(16) DEFAULT NULL COMMENT '所在地-省份',
  611. `city` varchar(16) DEFAULT NULL COMMENT '所在地--市',
  612. `area` varchar(16) DEFAULT NULL COMMENT '所在地--区',
  613. `contact_mobile` varchar(16) DEFAULT NULL COMMENT '联系方式',
  614. `bank_name` varchar(32) DEFAULT NULL COMMENT '银行开户名',
  615. `bank_account` varchar(32) DEFAULT NULL COMMENT '开户银行',
  616. `bank_card_number` varchar(32) DEFAULT NULL COMMENT '银行卡号',
  617. `amount_money` decimal(6,4) DEFAULT NULL COMMENT '打款金额',
  618. `audit_status` int(1) DEFAULT '0' COMMENT '审核状态(0--未提交审核,1-提交审核,2-审核未打款,3-审核已打款,4-审核未通过,5-审核通过)',
  619. `process` int(1) DEFAULT '0' COMMENT '实名认证流程',
  620. `wrong_count` int(1) DEFAULT '0' COMMENT '输入打款金额错误次数',
  621. `payment_date` datetime DEFAULT NULL COMMENT '打款日期',
  622. PRIMARY KEY (`id`)
  623. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  624. # Dump of table user_info
  625. # ------------------------------------------------------------
  626. DROP TABLE IF EXISTS `user_info`;
  627. CREATE TABLE `user_info` (
  628. `id` varchar(36) NOT NULL,
  629. `uid` varchar(36) NOT NULL,
  630. `residence_province` varchar(8) DEFAULT NULL COMMENT '居住地--省',
  631. `residence_city` varchar(12) DEFAULT NULL COMMENT '居住地--市',
  632. `residence_area` varchar(12) DEFAULT NULL COMMENT '居住地--区',
  633. `person_portrait_url` varchar(255) DEFAULT NULL COMMENT '个人头像',
  634. `life_photo_url` varchar(255) DEFAULT NULL COMMENT '生活照',
  635. `personal_profile` longtext COMMENT '个人简介',
  636. `fixed_tel_area` varchar(8) DEFAULT NULL COMMENT '固定电话 区号',
  637. `fixed_tel` varchar(12) DEFAULT NULL COMMENT '固定电话',
  638. `fixed_tel_extension` varchar(8) DEFAULT NULL COMMENT '固定电话分机号',
  639. `qq` varchar(16) DEFAULT NULL COMMENT 'QQ号码',
  640. `postal_address` varchar(255) DEFAULT NULL COMMENT '通讯地址',
  641. `postcode` varchar(8) DEFAULT NULL COMMENT '邮政编码',
  642. PRIMARY KEY (`id`),
  643. KEY `user_id_idx` (`uid`),
  644. CONSTRAINT `uid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  645. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  646. # Dump of table user_role
  647. # ------------------------------------------------------------
  648. DROP TABLE IF EXISTS `user_role`;
  649. CREATE TABLE `user_role` (
  650. `uid` varchar(36) NOT NULL,
  651. `rid` varchar(36) NOT NULL
  652. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  653. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  654. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  655. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  656. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  657. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  658. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;