org.ddl.sql 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416
  1. ## 人员组织权限
  2. # 1、集团(多租户)
  3. create table org_group
  4. (
  5. id varchar(40) not null primary key ,
  6. code varchar(40) null,
  7. name varchar(255) null,
  8. create_by varchar(40) null,
  9. create_time timestamp null,
  10. update_by varchar(40) null,
  11. update_time timestamp null,
  12. remark varchar(500) null
  13. );
  14. # 2、公司
  15. create table org_company
  16. (
  17. id varchar(40) not null primary key ,
  18. name varchar(40) null,
  19. group_code varchar(40) not null ,
  20. parent_id varchar(40) null,
  21. create_by varchar(40) null,
  22. create_time timestamp null ,
  23. update_by varchar(40) null,
  24. update_time timestamp null,
  25. remark varchar(500) null
  26. );
  27. # 3、部门
  28. create table org_dept
  29. (
  30. id varchar(40) not null primary key ,
  31. name varchar(40) not null ,
  32. parent_dept_id varchar(40) not null ,
  33. parent_company_id varchar(40) not null ,
  34. project_id varchar(40) not null ,
  35. group_code varchar(40) not null ,
  36. type varchar(40) not null comment '部门分类',
  37. create_by varchar(40) null,
  38. create_time timestamp null,
  39. update_by varchar(40) null,
  40. update_time timestamp null,
  41. remark varchar(500)
  42. );
  43. # 4、岗位
  44. create table org_job
  45. (
  46. id varchar(40) not null primary key ,
  47. name varchar(40) not null ,
  48. project_id varchar(40) not null ,
  49. group_code varchar(40) not null ,
  50. type varchar(40) not null comment '岗位类型',
  51. create_by varchar(40) null,
  52. create_time timestamp null,
  53. update_by varchar(40) null,
  54. update_time timestamp null,
  55. remark varchar(500)
  56. );
  57. # 5、部门模板
  58. create table org_dept_template
  59. (
  60. id varchar(40) not null primary key ,
  61. name varchar(40) not null ,
  62. group_code varchar(40) not null ,
  63. create_by varchar(40) null,
  64. create_time timestamp null,
  65. update_by varchar(40) null,
  66. update_time timestamp null,
  67. remark varchar(500)
  68. );
  69. # 6、部门层级结构模版
  70. create table org_dept_lv_template
  71. (
  72. id varchar(40) not null primary key ,
  73. name varchar(40) not null ,
  74. parent_id varchar(40) not null ,
  75. group_code varchar(40) not null ,
  76. create_by varchar(40) null,
  77. create_time timestamp null,
  78. update_by varchar(40) null,
  79. update_time timestamp null,
  80. remark varchar(500)
  81. );
  82. # 7、岗位模版
  83. create table org_job_template
  84. (
  85. id varchar(40) not null primary key ,
  86. name varchar(40) not null ,
  87. group_code varchar(40) not null ,
  88. create_by varchar(40) null,
  89. create_time timestamp null,
  90. update_by varchar(40) null,
  91. update_time timestamp null,
  92. remark varchar(500)
  93. );
  94. # 8、岗位模版与部门模版关系表
  95. create table org_job_dept_template
  96. (
  97. id varchar(40) not null primary key ,
  98. name varchar(40) not null ,
  99. parent_id varchar(40) not null ,
  100. group_code varchar(40) not null ,
  101. create_by varchar(40) null,
  102. create_time timestamp null,
  103. update_by varchar(40) null,
  104. update_time timestamp null,
  105. remark varchar(500) null
  106. );
  107. # 9、人员
  108. create table org_person
  109. (
  110. id varchar(40) not null primary key ,
  111. person_name varchar(40) null ,
  112. gender int null ,
  113. status int not null ,
  114. create_by varchar(40) null,
  115. create_time timestamp null,
  116. update_by varchar(40) null,
  117. update_time timestamp null,
  118. remark varchar(500)
  119. );
  120. # 10、账号
  121. create table org_account
  122. (
  123. id varchar(40) not null primary key ,
  124. username varchar(40) null ,
  125. password varchar(40) null ,
  126. person_id varchar(40) null ,
  127. status int not null ,
  128. create_by varchar(40) null,
  129. create_time timestamp null,
  130. update_by varchar(40) null,
  131. update_time timestamp null,
  132. remark varchar(500)
  133. );
  134. # 11、项目数据权限
  135. create table org_auth_prj_data
  136. (
  137. id varchar(40) not null primary key ,
  138. name varchar(40) not null ,
  139. group_code varchar(40) null ,
  140. create_by varchar(40) null,
  141. create_time timestamp null,
  142. update_by varchar(40) null,
  143. update_time timestamp null,
  144. remark varchar(500)
  145. );
  146. # 12、公司下的项目数据权限表
  147. create table org_auth_company_prj
  148. (
  149. id varchar(40) not null primary key ,
  150. company_id varchar(40) not null ,
  151. project_id varchar(40) not null ,
  152. group_code varchar(40) not null ,
  153. create_by varchar(40) null,
  154. create_time timestamp null,
  155. update_by varchar(40) null,
  156. update_time timestamp null,
  157. remark varchar(500)
  158. );
  159. # 13、项目下的公司数据表
  160. create table org_rel_company_prj
  161. (
  162. id varchar(40) not null primary key ,
  163. company_id varchar(40) not null ,
  164. project_id varchar(40) not null ,
  165. group_code varchar(40) not null ,
  166. create_by varchar(40) null,
  167. create_time timestamp null,
  168. update_by varchar(40) null,
  169. update_time timestamp null,
  170. remark varchar(500)
  171. );
  172. # 14、部门的项目数据权限表
  173. create table org_auth_dept_prj
  174. (
  175. id varchar(40) not null primary key ,
  176. dept_id varchar(40) not null ,
  177. project_id varchar(40) not null ,
  178. group_code varchar(40) not null ,
  179. create_by varchar(40) null,
  180. create_time timestamp null,
  181. update_by varchar(40) null,
  182. update_time timestamp null,
  183. remark varchar(500)
  184. );
  185. # 15、岗位&部门关系表
  186. create table org_cfg_dept_job
  187. (
  188. id varchar(40) not null primary key ,
  189. dept_id varchar(40) not null comment '部门id',
  190. job_id varchar(40) not null comment '岗位id',
  191. status int not null ,
  192. create_by varchar(40) null,
  193. create_time timestamp null,
  194. update_by varchar(40) null,
  195. update_time timestamp null,
  196. remark varchar(500)
  197. );
  198. # 16、人员配置公司管理权限
  199. create table org_cfg_person_company
  200. (
  201. id varchar(40) not null primary key ,
  202. person_id varchar(40) not null comment '账号id',
  203. company_id varchar(40) not null comment '公司id',
  204. status int not null ,
  205. create_by varchar(40) null,
  206. create_time timestamp null,
  207. update_by varchar(40) null,
  208. update_time timestamp null,
  209. remark varchar(500)
  210. );
  211. # 17、人员配置项目数据权限
  212. create table org_cfg_person_prj
  213. (
  214. id varchar(40) not null primary key ,
  215. person_id varchar(40) not null comment '账号id',
  216. project_id varchar(40) not null comment '项目id',
  217. status int not null ,
  218. create_by varchar(40) null,
  219. create_time timestamp null,
  220. update_by varchar(40) null,
  221. update_time timestamp null,
  222. remark varchar(500)
  223. );
  224. # 18、人员与部门关系表
  225. create table org_cfg_person_dept
  226. (
  227. id varchar(40) not null primary key ,
  228. person_id varchar(40) not null comment '账号id',
  229. dept_id varchar(40) not null comment '部门id',
  230. major_dept int not null comment '是否为主部门',
  231. status int not null ,
  232. create_by varchar(40) null,
  233. create_time timestamp null,
  234. update_by varchar(40) null,
  235. update_time timestamp null,
  236. remark varchar(500)
  237. );
  238. # 19、人员与岗位关系表
  239. create table org_cfg_person_job
  240. (
  241. id varchar(40) not null primary key ,
  242. person_id varchar(40) not null comment '账号id',
  243. dept_job_id varchar(40) not null comment '部门岗位关系id',
  244. status int not null ,
  245. create_by varchar(40) null,
  246. create_time timestamp null,
  247. update_by varchar(40) null,
  248. update_time timestamp null,
  249. remark varchar(500)
  250. );
  251. # 20、产品线
  252. create table org_product
  253. (
  254. id varchar(40) not null primary key ,
  255. code varchar(40) not null ,
  256. name varchar(40) not null ,
  257. create_by varchar(40) null,
  258. create_time timestamp null,
  259. update_by varchar(40) null,
  260. update_time timestamp null,
  261. remark varchar(500)
  262. );
  263. # 21、应用
  264. create table org_application
  265. (
  266. id varchar(40) not null primary key ,
  267. code varchar(40) not null ,
  268. name varchar(40) not null ,
  269. category varchar(40) not null ,
  270. create_by varchar(40) null,
  271. create_time timestamp null,
  272. update_by varchar(40) null,
  273. update_time timestamp null,
  274. remark varchar(500)
  275. );
  276. # 22、功能
  277. create table org_function
  278. (
  279. id varchar(40) not null primary key ,
  280. code varchar(40) not null ,
  281. name varchar(40) not null ,
  282. app_code varchar(40) not null ,
  283. create_by varchar(40) null,
  284. create_time timestamp null,
  285. update_by varchar(40) null,
  286. update_time timestamp null,
  287. remark varchar(500)
  288. );
  289. # 23、功能层级
  290. create table org_function_lv
  291. (
  292. id varchar(40) not null primary key ,
  293. code varchar(40) not null ,
  294. name varchar(40) not null ,
  295. parent_id varchar(40) null ,
  296. create_by varchar(40) null,
  297. create_time timestamp null,
  298. update_by varchar(40) null,
  299. update_time timestamp null,
  300. remark varchar(500)
  301. );
  302. # 24、集团配置应用
  303. create table org_cfg_group_app
  304. (
  305. id varchar(40) not null primary key ,
  306. app_code varchar(40) not null ,
  307. group_code varchar(40) not null ,
  308. status int not null ,
  309. create_by varchar(40) null,
  310. create_time timestamp null,
  311. update_by varchar(40) null,
  312. update_time timestamp null,
  313. remark varchar(500)
  314. );
  315. # 25、集团配置功能
  316. create table org_cfg_group_func
  317. (
  318. id varchar(40) not null primary key ,
  319. func_code varchar(40) not null ,
  320. group_code varchar(40) not null ,
  321. status int not null ,
  322. create_by varchar(40) null,
  323. create_time timestamp null,
  324. update_by varchar(40) null,
  325. update_time timestamp null,
  326. remark varchar(500)
  327. );
  328. # 26、项目配置应用
  329. create table org_cfg_prj_app
  330. (
  331. id varchar(40) not null primary key ,
  332. app_code varchar(40) not null ,
  333. project_id varchar(40) not null ,
  334. group_code varchar(40) not null ,
  335. status int not null ,
  336. create_by varchar(40) null,
  337. create_time timestamp null,
  338. update_by varchar(40) null,
  339. update_time timestamp null,
  340. remark varchar(500)
  341. );
  342. # 27、项目配置功能
  343. create table org_cfg_prj_func
  344. (
  345. id varchar(40) not null primary key ,
  346. func_code varchar(40) not null ,
  347. project_id varchar(40) not null ,
  348. group_code varchar(40) not null ,
  349. status int not null ,
  350. create_by varchar(40) null,
  351. create_time timestamp null,
  352. update_by varchar(40) null,
  353. update_time timestamp null,
  354. remark varchar(500)
  355. );
  356. # 28、岗位配置应用
  357. create table org_cfg_job_app
  358. (
  359. id varchar(40) not null primary key ,
  360. app_code varchar(40) not null ,
  361. job_id varchar(40) not null ,
  362. group_code varchar(40) not null ,
  363. status int not null ,
  364. create_by varchar(40) null,
  365. create_time timestamp null,
  366. update_by varchar(40) null,
  367. update_time timestamp null,
  368. remark varchar(500)
  369. );
  370. # 29、岗位配置功能
  371. create table org_cfg_job_func
  372. (
  373. id varchar(40) not null primary key ,
  374. func_code varchar(40) not null ,
  375. app_code varchar(40) not null ,
  376. job_id varchar(40) not null ,
  377. group_code varchar(40) not null ,
  378. status int not null ,
  379. create_by varchar(40) null,
  380. create_time timestamp null,
  381. update_by varchar(40) null,
  382. update_time timestamp null,
  383. remark varchar(500)
  384. );