jeesite.erm 68 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <diagram>
  3. <dbsetting>
  4. <dbsystem>MySQL</dbsystem>
  5. <server>localhost</server>
  6. <port>3306</port>
  7. <database>jeesite</database>
  8. <user>root</user>
  9. <password>123456</password>
  10. <use_default_driver>true</use_default_driver>
  11. <url>jdbc:mysql://localhost:3306/jeesite</url>
  12. <driver_class_name>com.mysql.jdbc.Driver</driver_class_name>
  13. </dbsetting>
  14. <page_setting>
  15. <direction_horizontal>true</direction_horizontal>
  16. <scale>100</scale>
  17. <paper_size>A4 210 x 297 mm</paper_size>
  18. <top_margin>30</top_margin>
  19. <left_margin>30</left_margin>
  20. <bottom_margin>30</bottom_margin>
  21. <right_margin>30</right_margin>
  22. </page_setting>
  23. <category_index>0</category_index>
  24. <zoom>1.0</zoom>
  25. <x>0</x>
  26. <y>0</y>
  27. <default_color>
  28. <r>128</r>
  29. <g>128</g>
  30. <b>192</b>
  31. </default_color>
  32. <color>
  33. <r>255</r>
  34. <g>255</g>
  35. <b>255</b>
  36. </color>
  37. <font_name></font_name>
  38. <font_size>9</font_size>
  39. <settings>
  40. <database>Oracle</database>
  41. <capital>false</capital>
  42. <table_style></table_style>
  43. <notation>IE</notation>
  44. <notation_level>0</notation_level>
  45. <notation_expand_group>true</notation_expand_group>
  46. <view_mode>2</view_mode>
  47. <outline_view_mode>2</outline_view_mode>
  48. <view_order_by>1</view_order_by>
  49. <auto_ime_change>false</auto_ime_change>
  50. <validate_physical_name>true</validate_physical_name>
  51. <use_bezier_curve>false</use_bezier_curve>
  52. <suspend_validator>false</suspend_validator>
  53. <export_setting>
  54. <category_name_to_export>All</category_name_to_export>
  55. <ddl_output>D:\GitHub\jeesite\db\oa\jeesite_oracle.sql</ddl_output>
  56. <excel_output>D:\GitHub\jeesite\jeesite\db\oa\jeesite-oa.xls</excel_output>
  57. <excel_template>Default(English)</excel_template>
  58. <image_output>D:\GitHub\jeesite\jeesite\db\oa\jeesite-oa.png</image_output>
  59. <put_diagram_on_excel>false</put_diagram_on_excel>
  60. <use_logical_name_as_sheet>false</use_logical_name_as_sheet>
  61. <open_after_saved>false</open_after_saved>
  62. <create_comment>true</create_comment>
  63. <create_foreignKey>false</create_foreignKey>
  64. <create_index>true</create_index>
  65. <create_sequence>false</create_sequence>
  66. <create_table>true</create_table>
  67. <create_tablespace>false</create_tablespace>
  68. <create_trigger>false</create_trigger>
  69. <create_view>true</create_view>
  70. <drop_index>false</drop_index>
  71. <drop_sequence>false</drop_sequence>
  72. <drop_table>true</drop_table>
  73. <drop_tablespace>false</drop_tablespace>
  74. <drop_trigger>false</drop_trigger>
  75. <drop_view>true</drop_view>
  76. <inline_column_comment>false</inline_column_comment>
  77. <inline_table_comment>false</inline_table_comment>
  78. <comment_value_description>false</comment_value_description>
  79. <comment_value_logical_name>true</comment_value_logical_name>
  80. <comment_value_logical_name_description>false</comment_value_logical_name_description>
  81. <comment_replace_line_feed>false</comment_replace_line_feed>
  82. <comment_replace_string></comment_replace_string>
  83. <export_java_setting>
  84. <java_output>D:\GitHub\jeesite\db\oa</java_output>
  85. <package_name></package_name>
  86. <class_name_suffix></class_name_suffix>
  87. <src_file_encoding>UTF-8</src_file_encoding>
  88. <with_hibernate>false</with_hibernate>
  89. </export_java_setting>
  90. <export_testdata_setting>
  91. <file_encoding></file_encoding>
  92. <file_path></file_path>
  93. <format>0</format>
  94. </export_testdata_setting>
  95. </export_setting>
  96. <category_settings>
  97. <free_layout>false</free_layout>
  98. <show_referred_tables>true</show_referred_tables>
  99. <categories>
  100. </categories>
  101. </category_settings>
  102. <translation_settings>
  103. <use>false</use>
  104. <translations>
  105. </translations>
  106. </translation_settings>
  107. <model_properties>
  108. <id></id>
  109. <height>-1</height>
  110. <width>-1</width>
  111. <font_name>Microsoft YaHei UI</font_name>
  112. <font_size>9</font_size>
  113. <x>47</x>
  114. <y>298</y>
  115. <color>
  116. <r>255</r>
  117. <g>255</g>
  118. <b>255</b>
  119. </color>
  120. <connections>
  121. </connections>
  122. <display>false</display>
  123. <creation_date>2013-04-23 21:13:37</creation_date>
  124. <updated_date>2014-04-08 10:48:46</updated_date>
  125. <model_property>
  126. <name>Project Name</name>
  127. <value>JeeSite</value>
  128. </model_property>
  129. <model_property>
  130. <name>Model Name</name>
  131. <value>SYS、CMS</value>
  132. </model_property>
  133. <model_property>
  134. <name>Version</name>
  135. <value>V1.0</value>
  136. </model_property>
  137. <model_property>
  138. <name>Compnay</name>
  139. <value>ThinkGem</value>
  140. </model_property>
  141. <model_property>
  142. <name>Author</name>
  143. <value>ThinkGem</value>
  144. </model_property>
  145. </model_properties>
  146. <table_properties>
  147. <schema></schema>
  148. </table_properties>
  149. <environment_setting>
  150. <environment>
  151. <id>0</id>
  152. <name>Default</name>
  153. </environment>
  154. </environment_setting>
  155. </settings>
  156. <dictionary>
  157. <word>
  158. <id>0</id>
  159. <length>255</length>
  160. <decimal>null</decimal>
  161. <array>false</array>
  162. <array_dimension>null</array_dimension>
  163. <unsigned>false</unsigned>
  164. <args></args>
  165. <description>月增资</description>
  166. <logical_name>月增资</logical_name>
  167. <physical_name>ADD_NUM</physical_name>
  168. <type>varchar(n)</type>
  169. </word>
  170. <word>
  171. <id>1</id>
  172. <length>1</length>
  173. <decimal>null</decimal>
  174. <array>false</array>
  175. <array_dimension>null</array_dimension>
  176. <unsigned>false</unsigned>
  177. <args></args>
  178. <description>性别</description>
  179. <logical_name>性别</logical_name>
  180. <physical_name>AGE</physical_name>
  181. <type>character(n)</type>
  182. </word>
  183. <word>
  184. <id>2</id>
  185. <length>null</length>
  186. <decimal>null</decimal>
  187. <array>false</array>
  188. <array_dimension>null</array_dimension>
  189. <unsigned>false</unsigned>
  190. <args></args>
  191. <description>申请时间</description>
  192. <logical_name>申请时间</logical_name>
  193. <physical_name>apply_time</physical_name>
  194. <type>datetime</type>
  195. </word>
  196. <word>
  197. <id>3</id>
  198. <length>2000</length>
  199. <decimal>null</decimal>
  200. <array>false</array>
  201. <array_dimension>null</array_dimension>
  202. <unsigned>false</unsigned>
  203. <args></args>
  204. <description>内容</description>
  205. <logical_name>内容</logical_name>
  206. <physical_name>content</physical_name>
  207. <type>nvarchar(n)</type>
  208. </word>
  209. <word>
  210. <id>4</id>
  211. <length>255</length>
  212. <decimal>null</decimal>
  213. <array>false</array>
  214. <array_dimension>null</array_dimension>
  215. <unsigned>false</unsigned>
  216. <args></args>
  217. <description>调整原因</description>
  218. <logical_name>调整原因</logical_name>
  219. <physical_name>CONTENT</physical_name>
  220. <type>nvarchar(n)</type>
  221. </word>
  222. <word>
  223. <id>5</id>
  224. <length>64</length>
  225. <decimal>null</decimal>
  226. <array>false</array>
  227. <array_dimension>null</array_dimension>
  228. <unsigned>false</unsigned>
  229. <args></args>
  230. <description>创建者</description>
  231. <logical_name>创建者</logical_name>
  232. <physical_name>create_by</physical_name>
  233. <type>varchar(n)</type>
  234. </word>
  235. <word>
  236. <id>6</id>
  237. <length>null</length>
  238. <decimal>null</decimal>
  239. <array>false</array>
  240. <array_dimension>null</array_dimension>
  241. <unsigned>false</unsigned>
  242. <args></args>
  243. <description>创建时间</description>
  244. <logical_name>创建时间</logical_name>
  245. <physical_name>create_date</physical_name>
  246. <type>datetime</type>
  247. </word>
  248. <word>
  249. <id>7</id>
  250. <length>1</length>
  251. <decimal>null</decimal>
  252. <array>false</array>
  253. <array_dimension>null</array_dimension>
  254. <unsigned>false</unsigned>
  255. <args></args>
  256. <description>删除标记(0:正常;1:删除)</description>
  257. <logical_name>删除标记</logical_name>
  258. <physical_name>del_flag</physical_name>
  259. <type>character(n)</type>
  260. </word>
  261. <word>
  262. <id>8</id>
  263. <length>255</length>
  264. <decimal>null</decimal>
  265. <array>false</array>
  266. <array_dimension>null</array_dimension>
  267. <unsigned>false</unsigned>
  268. <args></args>
  269. <description>学历</description>
  270. <logical_name>学历</logical_name>
  271. <physical_name>EDU</physical_name>
  272. <type>nvarchar(n)</type>
  273. </word>
  274. <word>
  275. <id>9</id>
  276. <length>null</length>
  277. <decimal>null</decimal>
  278. <array>false</array>
  279. <array_dimension>null</array_dimension>
  280. <unsigned>false</unsigned>
  281. <args></args>
  282. <description>结束时间</description>
  283. <logical_name>结束时间</logical_name>
  284. <physical_name>end_time</physical_name>
  285. <type>datetime</type>
  286. </word>
  287. <word>
  288. <id>10</id>
  289. <length>255</length>
  290. <decimal>null</decimal>
  291. <array>false</array>
  292. <array_dimension>null</array_dimension>
  293. <unsigned>false</unsigned>
  294. <args></args>
  295. <description>执行时间</description>
  296. <logical_name>执行时间</logical_name>
  297. <physical_name>EXE_DATE</physical_name>
  298. <type>varchar(n)</type>
  299. </word>
  300. <word>
  301. <id>11</id>
  302. <length>2000</length>
  303. <decimal>null</decimal>
  304. <array>false</array>
  305. <array_dimension>null</array_dimension>
  306. <unsigned>false</unsigned>
  307. <args></args>
  308. <description>附件</description>
  309. <logical_name>附件</logical_name>
  310. <physical_name>files</physical_name>
  311. <type>nvarchar(n)</type>
  312. </word>
  313. <word>
  314. <id>12</id>
  315. <length>255</length>
  316. <decimal>null</decimal>
  317. <array>false</array>
  318. <array_dimension>null</array_dimension>
  319. <unsigned>false</unsigned>
  320. <args></args>
  321. <description>人力资源部门意见</description>
  322. <logical_name>人力资源部门意见</logical_name>
  323. <physical_name>HR_TEXT</physical_name>
  324. <type>nvarchar(n)</type>
  325. </word>
  326. <word>
  327. <id>13</id>
  328. <length>64</length>
  329. <decimal>null</decimal>
  330. <array>false</array>
  331. <array_dimension>null</array_dimension>
  332. <unsigned>false</unsigned>
  333. <args></args>
  334. <description>编号</description>
  335. <logical_name>编号</logical_name>
  336. <physical_name>id</physical_name>
  337. <type>varchar(n)</type>
  338. </word>
  339. <word>
  340. <id>14</id>
  341. <length>255</length>
  342. <decimal>null</decimal>
  343. <array>false</array>
  344. <array_dimension>null</array_dimension>
  345. <unsigned>false</unsigned>
  346. <args></args>
  347. <description>分管领导意见</description>
  348. <logical_name>分管领导意见</logical_name>
  349. <physical_name>LEAD_TEXT</physical_name>
  350. <type>nvarchar(n)</type>
  351. </word>
  352. <word>
  353. <id>15</id>
  354. <length>20</length>
  355. <decimal>null</decimal>
  356. <array>false</array>
  357. <array_dimension>null</array_dimension>
  358. <unsigned>false</unsigned>
  359. <args></args>
  360. <description>请假类型</description>
  361. <logical_name>请假类型</logical_name>
  362. <physical_name>leave_type</physical_name>
  363. <type>varchar(n)</type>
  364. </word>
  365. <word>
  366. <id>16</id>
  367. <length>255</length>
  368. <decimal>null</decimal>
  369. <array>false</array>
  370. <array_dimension>null</array_dimension>
  371. <unsigned>false</unsigned>
  372. <args></args>
  373. <description>集团主要领导意见</description>
  374. <logical_name>集团主要领导意见</logical_name>
  375. <physical_name>MAIN_LEAD_TEXT</physical_name>
  376. <type>nvarchar(n)</type>
  377. </word>
  378. <word>
  379. <id>17</id>
  380. <length>255</length>
  381. <decimal>null</decimal>
  382. <array>false</array>
  383. <array_dimension>null</array_dimension>
  384. <unsigned>false</unsigned>
  385. <args></args>
  386. <description>调整后标准 薪酬档级</description>
  387. <logical_name>调整后标准 薪酬档级</logical_name>
  388. <physical_name>NEWA</physical_name>
  389. <type>varchar(n)</type>
  390. </word>
  391. <word>
  392. <id>18</id>
  393. <length>255</length>
  394. <decimal>null</decimal>
  395. <array>false</array>
  396. <array_dimension>null</array_dimension>
  397. <unsigned>false</unsigned>
  398. <args></args>
  399. <description>调整后标准 月工资额</description>
  400. <logical_name>调整后标准 月工资额</logical_name>
  401. <physical_name>NEWB</physical_name>
  402. <type>varchar(n)</type>
  403. </word>
  404. <word>
  405. <id>19</id>
  406. <length>255</length>
  407. <decimal>null</decimal>
  408. <array>false</array>
  409. <array_dimension>null</array_dimension>
  410. <unsigned>false</unsigned>
  411. <args></args>
  412. <description>调整后标准 年薪总额</description>
  413. <logical_name>调整后标准 年薪总额</logical_name>
  414. <physical_name>NEWC</physical_name>
  415. <type>varchar(n)</type>
  416. </word>
  417. <word>
  418. <id>20</id>
  419. <length>64</length>
  420. <decimal>null</decimal>
  421. <array>false</array>
  422. <array_dimension>null</array_dimension>
  423. <unsigned>false</unsigned>
  424. <args></args>
  425. <description>归属部门</description>
  426. <logical_name>归属部门</logical_name>
  427. <physical_name>OFFICE_ID</physical_name>
  428. <type>varchar(n)</type>
  429. </word>
  430. <word>
  431. <id>21</id>
  432. <length>255</length>
  433. <decimal>null</decimal>
  434. <array>false</array>
  435. <array_dimension>null</array_dimension>
  436. <unsigned>false</unsigned>
  437. <args></args>
  438. <description>现行标准 薪酬档级</description>
  439. <logical_name>现行标准 薪酬档级</logical_name>
  440. <physical_name>OLDA</physical_name>
  441. <type>varchar(n)</type>
  442. </word>
  443. <word>
  444. <id>22</id>
  445. <length>255</length>
  446. <decimal>null</decimal>
  447. <array>false</array>
  448. <array_dimension>null</array_dimension>
  449. <unsigned>false</unsigned>
  450. <args></args>
  451. <description>现行标准 月工资额</description>
  452. <logical_name>现行标准 月工资额</logical_name>
  453. <physical_name>OLDB</physical_name>
  454. <type>varchar(n)</type>
  455. </word>
  456. <word>
  457. <id>23</id>
  458. <length>255</length>
  459. <decimal>null</decimal>
  460. <array>false</array>
  461. <array_dimension>null</array_dimension>
  462. <unsigned>false</unsigned>
  463. <args></args>
  464. <description>现行标准 年薪总额</description>
  465. <logical_name>现行标准 年薪总额</logical_name>
  466. <physical_name>OLDC</physical_name>
  467. <type>varchar(n)</type>
  468. </word>
  469. <word>
  470. <id>24</id>
  471. <length>255</length>
  472. <decimal>null</decimal>
  473. <array>false</array>
  474. <array_dimension>null</array_dimension>
  475. <unsigned>false</unsigned>
  476. <args></args>
  477. <description>岗位</description>
  478. <logical_name>岗位</logical_name>
  479. <physical_name>POST</physical_name>
  480. <type>nvarchar(n)</type>
  481. </word>
  482. <word>
  483. <id>25</id>
  484. <length>64</length>
  485. <decimal>null</decimal>
  486. <array>false</array>
  487. <array_dimension>null</array_dimension>
  488. <unsigned>false</unsigned>
  489. <args></args>
  490. <description>流程实例编号</description>
  491. <logical_name>流程实例编号</logical_name>
  492. <physical_name>process_instance_id</physical_name>
  493. <type>varchar(n)</type>
  494. </word>
  495. <word>
  496. <id>26</id>
  497. <length>64</length>
  498. <decimal>null</decimal>
  499. <array>false</array>
  500. <array_dimension>null</array_dimension>
  501. <unsigned>false</unsigned>
  502. <args></args>
  503. <description>流程实例ID</description>
  504. <logical_name>流程实例ID</logical_name>
  505. <physical_name>PROC_INS_ID</physical_name>
  506. <type>varchar(n)</type>
  507. </word>
  508. <word>
  509. <id>27</id>
  510. <length>null</length>
  511. <decimal>null</decimal>
  512. <array>false</array>
  513. <array_dimension>null</array_dimension>
  514. <unsigned>false</unsigned>
  515. <args></args>
  516. <description>阅读时间</description>
  517. <logical_name>阅读时间</logical_name>
  518. <physical_name>read_date</physical_name>
  519. <type>date</type>
  520. </word>
  521. <word>
  522. <id>28</id>
  523. <length>1</length>
  524. <decimal>null</decimal>
  525. <array>false</array>
  526. <array_dimension>null</array_dimension>
  527. <unsigned>false</unsigned>
  528. <args></args>
  529. <description>阅读标记(0:未读;1:已读)</description>
  530. <logical_name>阅读标记</logical_name>
  531. <physical_name>read_flag</physical_name>
  532. <type>character(n)</type>
  533. </word>
  534. <word>
  535. <id>29</id>
  536. <length>null</length>
  537. <decimal>null</decimal>
  538. <array>false</array>
  539. <array_dimension>null</array_dimension>
  540. <unsigned>false</unsigned>
  541. <args></args>
  542. <description>实际结束时间</description>
  543. <logical_name>实际结束时间</logical_name>
  544. <physical_name>reality_end_time</physical_name>
  545. <type>datetime</type>
  546. </word>
  547. <word>
  548. <id>30</id>
  549. <length>null</length>
  550. <decimal>null</decimal>
  551. <array>false</array>
  552. <array_dimension>null</array_dimension>
  553. <unsigned>false</unsigned>
  554. <args></args>
  555. <description>实际开始时间</description>
  556. <logical_name>实际开始时间</logical_name>
  557. <physical_name>reality_start_time</physical_name>
  558. <type>datetime</type>
  559. </word>
  560. <word>
  561. <id>31</id>
  562. <length>255</length>
  563. <decimal>null</decimal>
  564. <array>false</array>
  565. <array_dimension>null</array_dimension>
  566. <unsigned>false</unsigned>
  567. <args></args>
  568. <description>请假理由</description>
  569. <logical_name>请假理由</logical_name>
  570. <physical_name>reason</physical_name>
  571. <type>nvarchar(n)</type>
  572. </word>
  573. <word>
  574. <id>32</id>
  575. <length>255</length>
  576. <decimal>null</decimal>
  577. <array>false</array>
  578. <array_dimension>null</array_dimension>
  579. <unsigned>false</unsigned>
  580. <args></args>
  581. <description>备注信息</description>
  582. <logical_name>备注信息</logical_name>
  583. <physical_name>remarks</physical_name>
  584. <type>nvarchar(n)</type>
  585. </word>
  586. <word>
  587. <id>33</id>
  588. <length>null</length>
  589. <decimal>null</decimal>
  590. <array>false</array>
  591. <array_dimension>null</array_dimension>
  592. <unsigned>false</unsigned>
  593. <args></args>
  594. <description>开始时间</description>
  595. <logical_name>开始时间</logical_name>
  596. <physical_name>start_time</physical_name>
  597. <type>datetime</type>
  598. </word>
  599. <word>
  600. <id>34</id>
  601. <length>1</length>
  602. <decimal>null</decimal>
  603. <array>false</array>
  604. <array_dimension>null</array_dimension>
  605. <unsigned>false</unsigned>
  606. <args></args>
  607. <description>状态</description>
  608. <logical_name>状态</logical_name>
  609. <physical_name>status</physical_name>
  610. <type>character(n)</type>
  611. </word>
  612. <word>
  613. <id>35</id>
  614. <length>200</length>
  615. <decimal>null</decimal>
  616. <array>false</array>
  617. <array_dimension>null</array_dimension>
  618. <unsigned>false</unsigned>
  619. <args></args>
  620. <description>标题</description>
  621. <logical_name>标题</logical_name>
  622. <physical_name>title</physical_name>
  623. <type>nvarchar(n)</type>
  624. </word>
  625. <word>
  626. <id>36</id>
  627. <length>1</length>
  628. <decimal>null</decimal>
  629. <array>false</array>
  630. <array_dimension>null</array_dimension>
  631. <unsigned>false</unsigned>
  632. <args></args>
  633. <description>类型</description>
  634. <logical_name>类型</logical_name>
  635. <physical_name>type</physical_name>
  636. <type>character(n)</type>
  637. </word>
  638. <word>
  639. <id>37</id>
  640. <length>64</length>
  641. <decimal>null</decimal>
  642. <array>false</array>
  643. <array_dimension>null</array_dimension>
  644. <unsigned>false</unsigned>
  645. <args></args>
  646. <description>更新者</description>
  647. <logical_name>更新者</logical_name>
  648. <physical_name>update_by</physical_name>
  649. <type>varchar(n)</type>
  650. </word>
  651. <word>
  652. <id>38</id>
  653. <length>null</length>
  654. <decimal>null</decimal>
  655. <array>false</array>
  656. <array_dimension>null</array_dimension>
  657. <unsigned>false</unsigned>
  658. <args></args>
  659. <description>更新时间</description>
  660. <logical_name>更新时间</logical_name>
  661. <physical_name>update_date</physical_name>
  662. <type>datetime</type>
  663. </word>
  664. <word>
  665. <id>39</id>
  666. <length>64</length>
  667. <decimal>null</decimal>
  668. <array>false</array>
  669. <array_dimension>null</array_dimension>
  670. <unsigned>false</unsigned>
  671. <args></args>
  672. <description>变动用户</description>
  673. <logical_name>变动用户</logical_name>
  674. <physical_name>USER_ID</physical_name>
  675. <type>varchar(n)</type>
  676. </word>
  677. <word>
  678. <id>40</id>
  679. <length>64</length>
  680. <decimal>null</decimal>
  681. <array>false</array>
  682. <array_dimension>null</array_dimension>
  683. <unsigned>false</unsigned>
  684. <args></args>
  685. <description>接受人</description>
  686. <logical_name>接受人</logical_name>
  687. <physical_name>user_id</physical_name>
  688. <type>varchar(n)</type>
  689. </word>
  690. </dictionary>
  691. <tablespace_set>
  692. </tablespace_set>
  693. <contents>
  694. <table>
  695. <id>0</id>
  696. <height>-1</height>
  697. <width>-1</width>
  698. <font_name>Segoe UI</font_name>
  699. <font_size>9</font_size>
  700. <x>23</x>
  701. <y>32</y>
  702. <color>
  703. <r>128</r>
  704. <g>128</g>
  705. <b>192</b>
  706. </color>
  707. <connections>
  708. </connections>
  709. <physical_name>oa_leave</physical_name>
  710. <logical_name>请假流程表</logical_name>
  711. <description>请假流程表</description>
  712. <constraint></constraint>
  713. <primary_key_name></primary_key_name>
  714. <option></option>
  715. <columns>
  716. <normal_column>
  717. <word_id>13</word_id>
  718. <id>6</id>
  719. <description></description>
  720. <unique_key_name></unique_key_name>
  721. <logical_name></logical_name>
  722. <physical_name></physical_name>
  723. <type>varchar(n)</type>
  724. <constraint></constraint>
  725. <default_value></default_value>
  726. <auto_increment>false</auto_increment>
  727. <foreign_key>false</foreign_key>
  728. <not_null>true</not_null>
  729. <primary_key>true</primary_key>
  730. <unique_key>false</unique_key>
  731. <character_set></character_set>
  732. <collation></collation>
  733. <sequence>
  734. <name></name>
  735. <schema></schema>
  736. <increment></increment>
  737. <min_value></min_value>
  738. <max_value></max_value>
  739. <start></start>
  740. <cache></cache>
  741. <cycle>false</cycle>
  742. <order>false</order>
  743. <description></description>
  744. <data_type></data_type>
  745. <decimal_size>0</decimal_size>
  746. </sequence>
  747. </normal_column>
  748. <normal_column>
  749. <word_id>25</word_id>
  750. <id>7</id>
  751. <description></description>
  752. <unique_key_name></unique_key_name>
  753. <logical_name></logical_name>
  754. <physical_name></physical_name>
  755. <type>varchar(n)</type>
  756. <constraint></constraint>
  757. <default_value></default_value>
  758. <auto_increment>false</auto_increment>
  759. <foreign_key>false</foreign_key>
  760. <not_null>false</not_null>
  761. <primary_key>false</primary_key>
  762. <unique_key>false</unique_key>
  763. <character_set></character_set>
  764. <collation></collation>
  765. <sequence>
  766. <name></name>
  767. <schema></schema>
  768. <increment></increment>
  769. <min_value></min_value>
  770. <max_value></max_value>
  771. <start></start>
  772. <cache></cache>
  773. <cycle>false</cycle>
  774. <order>false</order>
  775. <description></description>
  776. <data_type></data_type>
  777. <decimal_size>0</decimal_size>
  778. </sequence>
  779. </normal_column>
  780. <normal_column>
  781. <word_id>33</word_id>
  782. <id>8</id>
  783. <description></description>
  784. <unique_key_name></unique_key_name>
  785. <logical_name></logical_name>
  786. <physical_name></physical_name>
  787. <type>datetime</type>
  788. <constraint></constraint>
  789. <default_value></default_value>
  790. <auto_increment>false</auto_increment>
  791. <foreign_key>false</foreign_key>
  792. <not_null>false</not_null>
  793. <primary_key>false</primary_key>
  794. <unique_key>false</unique_key>
  795. <character_set></character_set>
  796. <collation></collation>
  797. <sequence>
  798. <name></name>
  799. <schema></schema>
  800. <increment></increment>
  801. <min_value></min_value>
  802. <max_value></max_value>
  803. <start></start>
  804. <cache></cache>
  805. <cycle>false</cycle>
  806. <order>false</order>
  807. <description></description>
  808. <data_type></data_type>
  809. <decimal_size>0</decimal_size>
  810. </sequence>
  811. </normal_column>
  812. <normal_column>
  813. <word_id>9</word_id>
  814. <id>9</id>
  815. <description></description>
  816. <unique_key_name></unique_key_name>
  817. <logical_name></logical_name>
  818. <physical_name></physical_name>
  819. <type>datetime</type>
  820. <constraint></constraint>
  821. <default_value></default_value>
  822. <auto_increment>false</auto_increment>
  823. <foreign_key>false</foreign_key>
  824. <not_null>false</not_null>
  825. <primary_key>false</primary_key>
  826. <unique_key>false</unique_key>
  827. <character_set></character_set>
  828. <collation></collation>
  829. <sequence>
  830. <name></name>
  831. <schema></schema>
  832. <increment></increment>
  833. <min_value></min_value>
  834. <max_value></max_value>
  835. <start></start>
  836. <cache></cache>
  837. <cycle>false</cycle>
  838. <order>false</order>
  839. <description></description>
  840. <data_type></data_type>
  841. <decimal_size>0</decimal_size>
  842. </sequence>
  843. </normal_column>
  844. <normal_column>
  845. <word_id>15</word_id>
  846. <id>10</id>
  847. <description></description>
  848. <unique_key_name></unique_key_name>
  849. <logical_name></logical_name>
  850. <physical_name></physical_name>
  851. <type>varchar(n)</type>
  852. <constraint></constraint>
  853. <default_value></default_value>
  854. <auto_increment>false</auto_increment>
  855. <foreign_key>false</foreign_key>
  856. <not_null>false</not_null>
  857. <primary_key>false</primary_key>
  858. <unique_key>false</unique_key>
  859. <character_set></character_set>
  860. <collation></collation>
  861. <sequence>
  862. <name></name>
  863. <schema></schema>
  864. <increment></increment>
  865. <min_value></min_value>
  866. <max_value></max_value>
  867. <start></start>
  868. <cache></cache>
  869. <cycle>false</cycle>
  870. <order>false</order>
  871. <description></description>
  872. <data_type></data_type>
  873. <decimal_size>0</decimal_size>
  874. </sequence>
  875. </normal_column>
  876. <normal_column>
  877. <word_id>31</word_id>
  878. <id>11</id>
  879. <description></description>
  880. <unique_key_name></unique_key_name>
  881. <logical_name></logical_name>
  882. <physical_name></physical_name>
  883. <type>nvarchar(n)</type>
  884. <constraint></constraint>
  885. <default_value></default_value>
  886. <auto_increment>false</auto_increment>
  887. <foreign_key>false</foreign_key>
  888. <not_null>false</not_null>
  889. <primary_key>false</primary_key>
  890. <unique_key>false</unique_key>
  891. <character_set></character_set>
  892. <collation></collation>
  893. <sequence>
  894. <name></name>
  895. <schema></schema>
  896. <increment></increment>
  897. <min_value></min_value>
  898. <max_value></max_value>
  899. <start></start>
  900. <cache></cache>
  901. <cycle>false</cycle>
  902. <order>false</order>
  903. <description></description>
  904. <data_type></data_type>
  905. <decimal_size>0</decimal_size>
  906. </sequence>
  907. </normal_column>
  908. <normal_column>
  909. <word_id>2</word_id>
  910. <id>12</id>
  911. <description></description>
  912. <unique_key_name></unique_key_name>
  913. <logical_name></logical_name>
  914. <physical_name></physical_name>
  915. <type>datetime</type>
  916. <constraint></constraint>
  917. <default_value></default_value>
  918. <auto_increment>false</auto_increment>
  919. <foreign_key>false</foreign_key>
  920. <not_null>false</not_null>
  921. <primary_key>false</primary_key>
  922. <unique_key>false</unique_key>
  923. <character_set></character_set>
  924. <collation></collation>
  925. <sequence>
  926. <name></name>
  927. <schema></schema>
  928. <increment></increment>
  929. <min_value></min_value>
  930. <max_value></max_value>
  931. <start></start>
  932. <cache></cache>
  933. <cycle>false</cycle>
  934. <order>false</order>
  935. <description></description>
  936. <data_type></data_type>
  937. <decimal_size>0</decimal_size>
  938. </sequence>
  939. </normal_column>
  940. <normal_column>
  941. <word_id>30</word_id>
  942. <id>13</id>
  943. <description></description>
  944. <unique_key_name></unique_key_name>
  945. <logical_name></logical_name>
  946. <physical_name></physical_name>
  947. <type>datetime</type>
  948. <constraint></constraint>
  949. <default_value></default_value>
  950. <auto_increment>false</auto_increment>
  951. <foreign_key>false</foreign_key>
  952. <not_null>false</not_null>
  953. <primary_key>false</primary_key>
  954. <unique_key>false</unique_key>
  955. <character_set></character_set>
  956. <collation></collation>
  957. <sequence>
  958. <name></name>
  959. <schema></schema>
  960. <increment></increment>
  961. <min_value></min_value>
  962. <max_value></max_value>
  963. <start></start>
  964. <cache></cache>
  965. <cycle>false</cycle>
  966. <order>false</order>
  967. <description></description>
  968. <data_type></data_type>
  969. <decimal_size>0</decimal_size>
  970. </sequence>
  971. </normal_column>
  972. <normal_column>
  973. <word_id>29</word_id>
  974. <id>14</id>
  975. <description></description>
  976. <unique_key_name></unique_key_name>
  977. <logical_name></logical_name>
  978. <physical_name></physical_name>
  979. <type>datetime</type>
  980. <constraint></constraint>
  981. <default_value></default_value>
  982. <auto_increment>false</auto_increment>
  983. <foreign_key>false</foreign_key>
  984. <not_null>false</not_null>
  985. <primary_key>false</primary_key>
  986. <unique_key>false</unique_key>
  987. <character_set></character_set>
  988. <collation></collation>
  989. <sequence>
  990. <name></name>
  991. <schema></schema>
  992. <increment></increment>
  993. <min_value></min_value>
  994. <max_value></max_value>
  995. <start></start>
  996. <cache></cache>
  997. <cycle>false</cycle>
  998. <order>false</order>
  999. <description></description>
  1000. <data_type></data_type>
  1001. <decimal_size>0</decimal_size>
  1002. </sequence>
  1003. </normal_column>
  1004. <column_group>0</column_group>
  1005. </columns>
  1006. <indexes>
  1007. <inidex>
  1008. <full_text>false</full_text>
  1009. <non_unique>true</non_unique>
  1010. <name>oa_leave_create_by</name>
  1011. <type></type>
  1012. <description></description>
  1013. <columns>
  1014. <column>
  1015. <id>0</id>
  1016. <desc>false</desc>
  1017. </column>
  1018. </columns>
  1019. </inidex>
  1020. <inidex>
  1021. <full_text>false</full_text>
  1022. <non_unique>true</non_unique>
  1023. <name>oa_leave_process_instance_id</name>
  1024. <type></type>
  1025. <description></description>
  1026. <columns>
  1027. <column>
  1028. <id>7</id>
  1029. <desc>false</desc>
  1030. </column>
  1031. </columns>
  1032. </inidex>
  1033. <inidex>
  1034. <full_text>false</full_text>
  1035. <non_unique>true</non_unique>
  1036. <name>oa_leave_del_flag</name>
  1037. <type></type>
  1038. <description></description>
  1039. <columns>
  1040. <column>
  1041. <id>5</id>
  1042. <desc>false</desc>
  1043. </column>
  1044. </columns>
  1045. </inidex>
  1046. </indexes>
  1047. <complex_unique_key_list>
  1048. </complex_unique_key_list>
  1049. <table_properties>
  1050. <schema></schema>
  1051. </table_properties>
  1052. </table>
  1053. <table>
  1054. <id>1</id>
  1055. <height>-1</height>
  1056. <width>-1</width>
  1057. <font_name>Segoe UI</font_name>
  1058. <font_size>9</font_size>
  1059. <x>363</x>
  1060. <y>32</y>
  1061. <color>
  1062. <r>128</r>
  1063. <g>128</g>
  1064. <b>192</b>
  1065. </color>
  1066. <connections>
  1067. </connections>
  1068. <physical_name>OA_TEST_AUDIT</physical_name>
  1069. <logical_name>审批流程测试表</logical_name>
  1070. <description>审批流程测试表</description>
  1071. <constraint></constraint>
  1072. <primary_key_name>SYS_C0016476</primary_key_name>
  1073. <option></option>
  1074. <columns>
  1075. <normal_column>
  1076. <word_id>13</word_id>
  1077. <id>15</id>
  1078. <description></description>
  1079. <unique_key_name></unique_key_name>
  1080. <logical_name></logical_name>
  1081. <physical_name></physical_name>
  1082. <type>varchar(n)</type>
  1083. <constraint></constraint>
  1084. <default_value></default_value>
  1085. <auto_increment>false</auto_increment>
  1086. <foreign_key>false</foreign_key>
  1087. <not_null>true</not_null>
  1088. <primary_key>true</primary_key>
  1089. <unique_key>false</unique_key>
  1090. <character_set></character_set>
  1091. <collation></collation>
  1092. <sequence>
  1093. <name></name>
  1094. <schema></schema>
  1095. <increment></increment>
  1096. <min_value></min_value>
  1097. <max_value></max_value>
  1098. <start></start>
  1099. <cache></cache>
  1100. <cycle>false</cycle>
  1101. <order>false</order>
  1102. <description></description>
  1103. <data_type></data_type>
  1104. <decimal_size>0</decimal_size>
  1105. </sequence>
  1106. </normal_column>
  1107. <normal_column>
  1108. <word_id>26</word_id>
  1109. <id>16</id>
  1110. <description></description>
  1111. <unique_key_name></unique_key_name>
  1112. <logical_name></logical_name>
  1113. <physical_name></physical_name>
  1114. <type>varchar(n)</type>
  1115. <constraint></constraint>
  1116. <default_value></default_value>
  1117. <auto_increment>false</auto_increment>
  1118. <foreign_key>false</foreign_key>
  1119. <not_null>false</not_null>
  1120. <primary_key>false</primary_key>
  1121. <unique_key>false</unique_key>
  1122. <character_set></character_set>
  1123. <collation></collation>
  1124. <sequence>
  1125. <name></name>
  1126. <schema></schema>
  1127. <increment></increment>
  1128. <min_value></min_value>
  1129. <max_value></max_value>
  1130. <start></start>
  1131. <cache></cache>
  1132. <cycle>false</cycle>
  1133. <order>false</order>
  1134. <description></description>
  1135. <data_type></data_type>
  1136. <decimal_size>0</decimal_size>
  1137. </sequence>
  1138. </normal_column>
  1139. <normal_column>
  1140. <word_id>39</word_id>
  1141. <id>17</id>
  1142. <description></description>
  1143. <unique_key_name></unique_key_name>
  1144. <logical_name></logical_name>
  1145. <physical_name></physical_name>
  1146. <type>varchar(n)</type>
  1147. <constraint></constraint>
  1148. <default_value></default_value>
  1149. <auto_increment>false</auto_increment>
  1150. <foreign_key>false</foreign_key>
  1151. <not_null>false</not_null>
  1152. <primary_key>false</primary_key>
  1153. <unique_key>false</unique_key>
  1154. <character_set></character_set>
  1155. <collation></collation>
  1156. <sequence>
  1157. <name></name>
  1158. <schema></schema>
  1159. <increment></increment>
  1160. <min_value></min_value>
  1161. <max_value></max_value>
  1162. <start></start>
  1163. <cache></cache>
  1164. <cycle>false</cycle>
  1165. <order>false</order>
  1166. <description></description>
  1167. <data_type></data_type>
  1168. <decimal_size>0</decimal_size>
  1169. </sequence>
  1170. </normal_column>
  1171. <normal_column>
  1172. <word_id>20</word_id>
  1173. <id>18</id>
  1174. <description></description>
  1175. <unique_key_name></unique_key_name>
  1176. <logical_name></logical_name>
  1177. <physical_name></physical_name>
  1178. <type>varchar(n)</type>
  1179. <constraint></constraint>
  1180. <default_value></default_value>
  1181. <auto_increment>false</auto_increment>
  1182. <foreign_key>false</foreign_key>
  1183. <not_null>false</not_null>
  1184. <primary_key>false</primary_key>
  1185. <unique_key>false</unique_key>
  1186. <character_set></character_set>
  1187. <collation></collation>
  1188. <sequence>
  1189. <name></name>
  1190. <schema></schema>
  1191. <increment></increment>
  1192. <min_value></min_value>
  1193. <max_value></max_value>
  1194. <start></start>
  1195. <cache></cache>
  1196. <cycle>false</cycle>
  1197. <order>false</order>
  1198. <description></description>
  1199. <data_type></data_type>
  1200. <decimal_size>0</decimal_size>
  1201. </sequence>
  1202. </normal_column>
  1203. <normal_column>
  1204. <word_id>24</word_id>
  1205. <id>19</id>
  1206. <description></description>
  1207. <unique_key_name></unique_key_name>
  1208. <logical_name></logical_name>
  1209. <physical_name></physical_name>
  1210. <type>nvarchar(n)</type>
  1211. <constraint></constraint>
  1212. <default_value></default_value>
  1213. <auto_increment>false</auto_increment>
  1214. <foreign_key>false</foreign_key>
  1215. <not_null>false</not_null>
  1216. <primary_key>false</primary_key>
  1217. <unique_key>false</unique_key>
  1218. <character_set></character_set>
  1219. <collation></collation>
  1220. <sequence>
  1221. <name></name>
  1222. <schema></schema>
  1223. <increment></increment>
  1224. <min_value></min_value>
  1225. <max_value></max_value>
  1226. <start></start>
  1227. <cache></cache>
  1228. <cycle>false</cycle>
  1229. <order>false</order>
  1230. <description></description>
  1231. <data_type></data_type>
  1232. <decimal_size>0</decimal_size>
  1233. </sequence>
  1234. </normal_column>
  1235. <normal_column>
  1236. <word_id>1</word_id>
  1237. <id>20</id>
  1238. <description></description>
  1239. <unique_key_name></unique_key_name>
  1240. <logical_name></logical_name>
  1241. <physical_name></physical_name>
  1242. <type>character(n)</type>
  1243. <constraint></constraint>
  1244. <default_value></default_value>
  1245. <auto_increment>false</auto_increment>
  1246. <foreign_key>false</foreign_key>
  1247. <not_null>false</not_null>
  1248. <primary_key>false</primary_key>
  1249. <unique_key>false</unique_key>
  1250. <character_set></character_set>
  1251. <collation></collation>
  1252. <sequence>
  1253. <name></name>
  1254. <schema></schema>
  1255. <increment></increment>
  1256. <min_value></min_value>
  1257. <max_value></max_value>
  1258. <start></start>
  1259. <cache></cache>
  1260. <cycle>false</cycle>
  1261. <order>false</order>
  1262. <description></description>
  1263. <data_type></data_type>
  1264. <decimal_size>0</decimal_size>
  1265. </sequence>
  1266. </normal_column>
  1267. <normal_column>
  1268. <word_id>8</word_id>
  1269. <id>21</id>
  1270. <description></description>
  1271. <unique_key_name></unique_key_name>
  1272. <logical_name></logical_name>
  1273. <physical_name></physical_name>
  1274. <type>nvarchar(n)</type>
  1275. <constraint></constraint>
  1276. <default_value></default_value>
  1277. <auto_increment>false</auto_increment>
  1278. <foreign_key>false</foreign_key>
  1279. <not_null>false</not_null>
  1280. <primary_key>false</primary_key>
  1281. <unique_key>false</unique_key>
  1282. <character_set></character_set>
  1283. <collation></collation>
  1284. <sequence>
  1285. <name></name>
  1286. <schema></schema>
  1287. <increment></increment>
  1288. <min_value></min_value>
  1289. <max_value></max_value>
  1290. <start></start>
  1291. <cache></cache>
  1292. <cycle>false</cycle>
  1293. <order>false</order>
  1294. <description></description>
  1295. <data_type></data_type>
  1296. <decimal_size>0</decimal_size>
  1297. </sequence>
  1298. </normal_column>
  1299. <normal_column>
  1300. <word_id>4</word_id>
  1301. <id>22</id>
  1302. <description></description>
  1303. <unique_key_name></unique_key_name>
  1304. <logical_name></logical_name>
  1305. <physical_name></physical_name>
  1306. <type>nvarchar(n)</type>
  1307. <constraint></constraint>
  1308. <default_value></default_value>
  1309. <auto_increment>false</auto_increment>
  1310. <foreign_key>false</foreign_key>
  1311. <not_null>false</not_null>
  1312. <primary_key>false</primary_key>
  1313. <unique_key>false</unique_key>
  1314. <character_set></character_set>
  1315. <collation></collation>
  1316. <sequence>
  1317. <name></name>
  1318. <schema></schema>
  1319. <increment></increment>
  1320. <min_value></min_value>
  1321. <max_value></max_value>
  1322. <start></start>
  1323. <cache></cache>
  1324. <cycle>false</cycle>
  1325. <order>false</order>
  1326. <description></description>
  1327. <data_type></data_type>
  1328. <decimal_size>0</decimal_size>
  1329. </sequence>
  1330. </normal_column>
  1331. <normal_column>
  1332. <word_id>21</word_id>
  1333. <id>23</id>
  1334. <description></description>
  1335. <unique_key_name></unique_key_name>
  1336. <logical_name></logical_name>
  1337. <physical_name></physical_name>
  1338. <type>varchar(n)</type>
  1339. <constraint></constraint>
  1340. <default_value></default_value>
  1341. <auto_increment>false</auto_increment>
  1342. <foreign_key>false</foreign_key>
  1343. <not_null>false</not_null>
  1344. <primary_key>false</primary_key>
  1345. <unique_key>false</unique_key>
  1346. <character_set></character_set>
  1347. <collation></collation>
  1348. <sequence>
  1349. <name></name>
  1350. <schema></schema>
  1351. <increment></increment>
  1352. <min_value></min_value>
  1353. <max_value></max_value>
  1354. <start></start>
  1355. <cache></cache>
  1356. <cycle>false</cycle>
  1357. <order>false</order>
  1358. <description></description>
  1359. <data_type></data_type>
  1360. <decimal_size>0</decimal_size>
  1361. </sequence>
  1362. </normal_column>
  1363. <normal_column>
  1364. <word_id>22</word_id>
  1365. <id>24</id>
  1366. <description></description>
  1367. <unique_key_name></unique_key_name>
  1368. <logical_name></logical_name>
  1369. <physical_name></physical_name>
  1370. <type>varchar(n)</type>
  1371. <constraint></constraint>
  1372. <default_value></default_value>
  1373. <auto_increment>false</auto_increment>
  1374. <foreign_key>false</foreign_key>
  1375. <not_null>false</not_null>
  1376. <primary_key>false</primary_key>
  1377. <unique_key>false</unique_key>
  1378. <character_set></character_set>
  1379. <collation></collation>
  1380. <sequence>
  1381. <name></name>
  1382. <schema></schema>
  1383. <increment></increment>
  1384. <min_value></min_value>
  1385. <max_value></max_value>
  1386. <start></start>
  1387. <cache></cache>
  1388. <cycle>false</cycle>
  1389. <order>false</order>
  1390. <description></description>
  1391. <data_type></data_type>
  1392. <decimal_size>0</decimal_size>
  1393. </sequence>
  1394. </normal_column>
  1395. <normal_column>
  1396. <word_id>23</word_id>
  1397. <id>25</id>
  1398. <description></description>
  1399. <unique_key_name></unique_key_name>
  1400. <logical_name></logical_name>
  1401. <physical_name></physical_name>
  1402. <type>varchar(n)</type>
  1403. <constraint></constraint>
  1404. <default_value></default_value>
  1405. <auto_increment>false</auto_increment>
  1406. <foreign_key>false</foreign_key>
  1407. <not_null>false</not_null>
  1408. <primary_key>false</primary_key>
  1409. <unique_key>false</unique_key>
  1410. <character_set></character_set>
  1411. <collation></collation>
  1412. <sequence>
  1413. <name></name>
  1414. <schema></schema>
  1415. <increment></increment>
  1416. <min_value></min_value>
  1417. <max_value></max_value>
  1418. <start></start>
  1419. <cache></cache>
  1420. <cycle>false</cycle>
  1421. <order>false</order>
  1422. <description></description>
  1423. <data_type></data_type>
  1424. <decimal_size>0</decimal_size>
  1425. </sequence>
  1426. </normal_column>
  1427. <normal_column>
  1428. <word_id>17</word_id>
  1429. <id>26</id>
  1430. <description></description>
  1431. <unique_key_name></unique_key_name>
  1432. <logical_name></logical_name>
  1433. <physical_name></physical_name>
  1434. <type>varchar(n)</type>
  1435. <constraint></constraint>
  1436. <default_value></default_value>
  1437. <auto_increment>false</auto_increment>
  1438. <foreign_key>false</foreign_key>
  1439. <not_null>false</not_null>
  1440. <primary_key>false</primary_key>
  1441. <unique_key>false</unique_key>
  1442. <character_set></character_set>
  1443. <collation></collation>
  1444. <sequence>
  1445. <name></name>
  1446. <schema></schema>
  1447. <increment></increment>
  1448. <min_value></min_value>
  1449. <max_value></max_value>
  1450. <start></start>
  1451. <cache></cache>
  1452. <cycle>false</cycle>
  1453. <order>false</order>
  1454. <description></description>
  1455. <data_type></data_type>
  1456. <decimal_size>0</decimal_size>
  1457. </sequence>
  1458. </normal_column>
  1459. <normal_column>
  1460. <word_id>18</word_id>
  1461. <id>27</id>
  1462. <description></description>
  1463. <unique_key_name></unique_key_name>
  1464. <logical_name></logical_name>
  1465. <physical_name></physical_name>
  1466. <type>varchar(n)</type>
  1467. <constraint></constraint>
  1468. <default_value></default_value>
  1469. <auto_increment>false</auto_increment>
  1470. <foreign_key>false</foreign_key>
  1471. <not_null>false</not_null>
  1472. <primary_key>false</primary_key>
  1473. <unique_key>false</unique_key>
  1474. <character_set></character_set>
  1475. <collation></collation>
  1476. <sequence>
  1477. <name></name>
  1478. <schema></schema>
  1479. <increment></increment>
  1480. <min_value></min_value>
  1481. <max_value></max_value>
  1482. <start></start>
  1483. <cache></cache>
  1484. <cycle>false</cycle>
  1485. <order>false</order>
  1486. <description></description>
  1487. <data_type></data_type>
  1488. <decimal_size>0</decimal_size>
  1489. </sequence>
  1490. </normal_column>
  1491. <normal_column>
  1492. <word_id>19</word_id>
  1493. <id>28</id>
  1494. <description></description>
  1495. <unique_key_name></unique_key_name>
  1496. <logical_name></logical_name>
  1497. <physical_name></physical_name>
  1498. <type>varchar(n)</type>
  1499. <constraint></constraint>
  1500. <default_value></default_value>
  1501. <auto_increment>false</auto_increment>
  1502. <foreign_key>false</foreign_key>
  1503. <not_null>false</not_null>
  1504. <primary_key>false</primary_key>
  1505. <unique_key>false</unique_key>
  1506. <character_set></character_set>
  1507. <collation></collation>
  1508. <sequence>
  1509. <name></name>
  1510. <schema></schema>
  1511. <increment></increment>
  1512. <min_value></min_value>
  1513. <max_value></max_value>
  1514. <start></start>
  1515. <cache></cache>
  1516. <cycle>false</cycle>
  1517. <order>false</order>
  1518. <description></description>
  1519. <data_type></data_type>
  1520. <decimal_size>0</decimal_size>
  1521. </sequence>
  1522. </normal_column>
  1523. <normal_column>
  1524. <word_id>0</word_id>
  1525. <id>29</id>
  1526. <description></description>
  1527. <unique_key_name></unique_key_name>
  1528. <logical_name></logical_name>
  1529. <physical_name></physical_name>
  1530. <type>varchar(n)</type>
  1531. <constraint></constraint>
  1532. <default_value></default_value>
  1533. <auto_increment>false</auto_increment>
  1534. <foreign_key>false</foreign_key>
  1535. <not_null>false</not_null>
  1536. <primary_key>false</primary_key>
  1537. <unique_key>false</unique_key>
  1538. <character_set></character_set>
  1539. <collation></collation>
  1540. <sequence>
  1541. <name></name>
  1542. <schema></schema>
  1543. <increment></increment>
  1544. <min_value></min_value>
  1545. <max_value></max_value>
  1546. <start></start>
  1547. <cache></cache>
  1548. <cycle>false</cycle>
  1549. <order>false</order>
  1550. <description></description>
  1551. <data_type></data_type>
  1552. <decimal_size>0</decimal_size>
  1553. </sequence>
  1554. </normal_column>
  1555. <normal_column>
  1556. <word_id>10</word_id>
  1557. <id>30</id>
  1558. <description></description>
  1559. <unique_key_name></unique_key_name>
  1560. <logical_name></logical_name>
  1561. <physical_name></physical_name>
  1562. <type>varchar(n)</type>
  1563. <constraint></constraint>
  1564. <default_value></default_value>
  1565. <auto_increment>false</auto_increment>
  1566. <foreign_key>false</foreign_key>
  1567. <not_null>false</not_null>
  1568. <primary_key>false</primary_key>
  1569. <unique_key>false</unique_key>
  1570. <character_set></character_set>
  1571. <collation></collation>
  1572. <sequence>
  1573. <name></name>
  1574. <schema></schema>
  1575. <increment></increment>
  1576. <min_value></min_value>
  1577. <max_value></max_value>
  1578. <start></start>
  1579. <cache></cache>
  1580. <cycle>false</cycle>
  1581. <order>false</order>
  1582. <description></description>
  1583. <data_type></data_type>
  1584. <decimal_size>0</decimal_size>
  1585. </sequence>
  1586. </normal_column>
  1587. <normal_column>
  1588. <word_id>12</word_id>
  1589. <id>31</id>
  1590. <description></description>
  1591. <unique_key_name></unique_key_name>
  1592. <logical_name></logical_name>
  1593. <physical_name></physical_name>
  1594. <type>nvarchar(n)</type>
  1595. <constraint></constraint>
  1596. <default_value></default_value>
  1597. <auto_increment>false</auto_increment>
  1598. <foreign_key>false</foreign_key>
  1599. <not_null>false</not_null>
  1600. <primary_key>false</primary_key>
  1601. <unique_key>false</unique_key>
  1602. <character_set></character_set>
  1603. <collation></collation>
  1604. <sequence>
  1605. <name></name>
  1606. <schema></schema>
  1607. <increment></increment>
  1608. <min_value></min_value>
  1609. <max_value></max_value>
  1610. <start></start>
  1611. <cache></cache>
  1612. <cycle>false</cycle>
  1613. <order>false</order>
  1614. <description></description>
  1615. <data_type></data_type>
  1616. <decimal_size>0</decimal_size>
  1617. </sequence>
  1618. </normal_column>
  1619. <normal_column>
  1620. <word_id>14</word_id>
  1621. <id>32</id>
  1622. <description></description>
  1623. <unique_key_name></unique_key_name>
  1624. <logical_name></logical_name>
  1625. <physical_name></physical_name>
  1626. <type>nvarchar(n)</type>
  1627. <constraint></constraint>
  1628. <default_value></default_value>
  1629. <auto_increment>false</auto_increment>
  1630. <foreign_key>false</foreign_key>
  1631. <not_null>false</not_null>
  1632. <primary_key>false</primary_key>
  1633. <unique_key>false</unique_key>
  1634. <character_set></character_set>
  1635. <collation></collation>
  1636. <sequence>
  1637. <name></name>
  1638. <schema></schema>
  1639. <increment></increment>
  1640. <min_value></min_value>
  1641. <max_value></max_value>
  1642. <start></start>
  1643. <cache></cache>
  1644. <cycle>false</cycle>
  1645. <order>false</order>
  1646. <description></description>
  1647. <data_type></data_type>
  1648. <decimal_size>0</decimal_size>
  1649. </sequence>
  1650. </normal_column>
  1651. <normal_column>
  1652. <word_id>16</word_id>
  1653. <id>33</id>
  1654. <description></description>
  1655. <unique_key_name></unique_key_name>
  1656. <logical_name></logical_name>
  1657. <physical_name></physical_name>
  1658. <type>nvarchar(n)</type>
  1659. <constraint></constraint>
  1660. <default_value></default_value>
  1661. <auto_increment>false</auto_increment>
  1662. <foreign_key>false</foreign_key>
  1663. <not_null>false</not_null>
  1664. <primary_key>false</primary_key>
  1665. <unique_key>false</unique_key>
  1666. <character_set></character_set>
  1667. <collation></collation>
  1668. <sequence>
  1669. <name></name>
  1670. <schema></schema>
  1671. <increment></increment>
  1672. <min_value></min_value>
  1673. <max_value></max_value>
  1674. <start></start>
  1675. <cache></cache>
  1676. <cycle>false</cycle>
  1677. <order>false</order>
  1678. <description></description>
  1679. <data_type></data_type>
  1680. <decimal_size>0</decimal_size>
  1681. </sequence>
  1682. </normal_column>
  1683. <column_group>0</column_group>
  1684. </columns>
  1685. <indexes>
  1686. <inidex>
  1687. <full_text>false</full_text>
  1688. <non_unique>true</non_unique>
  1689. <name>OA_TEST_AUDIT_del_flag</name>
  1690. <type></type>
  1691. <description></description>
  1692. <columns>
  1693. <column>
  1694. <id>5</id>
  1695. <desc>false</desc>
  1696. </column>
  1697. </columns>
  1698. </inidex>
  1699. </indexes>
  1700. <complex_unique_key_list>
  1701. </complex_unique_key_list>
  1702. <table_properties>
  1703. <schema></schema>
  1704. </table_properties>
  1705. </table>
  1706. <table>
  1707. <id>2</id>
  1708. <height>275</height>
  1709. <width>234</width>
  1710. <font_name>Segoe UI</font_name>
  1711. <font_size>9</font_size>
  1712. <x>739</x>
  1713. <y>34</y>
  1714. <color>
  1715. <r>128</r>
  1716. <g>128</g>
  1717. <b>192</b>
  1718. </color>
  1719. <connections>
  1720. </connections>
  1721. <physical_name>oa_notify</physical_name>
  1722. <logical_name>通知通告</logical_name>
  1723. <description>通知通告</description>
  1724. <constraint></constraint>
  1725. <primary_key_name></primary_key_name>
  1726. <option></option>
  1727. <columns>
  1728. <normal_column>
  1729. <word_id>13</word_id>
  1730. <id>34</id>
  1731. <description></description>
  1732. <unique_key_name></unique_key_name>
  1733. <logical_name></logical_name>
  1734. <physical_name></physical_name>
  1735. <type>varchar(n)</type>
  1736. <constraint></constraint>
  1737. <default_value></default_value>
  1738. <auto_increment>false</auto_increment>
  1739. <foreign_key>false</foreign_key>
  1740. <not_null>true</not_null>
  1741. <primary_key>true</primary_key>
  1742. <unique_key>false</unique_key>
  1743. <character_set></character_set>
  1744. <collation></collation>
  1745. <sequence>
  1746. <name></name>
  1747. <schema></schema>
  1748. <increment></increment>
  1749. <min_value></min_value>
  1750. <max_value></max_value>
  1751. <start></start>
  1752. <cache></cache>
  1753. <cycle>false</cycle>
  1754. <order>false</order>
  1755. <description></description>
  1756. <data_type></data_type>
  1757. <decimal_size>0</decimal_size>
  1758. </sequence>
  1759. </normal_column>
  1760. <normal_column>
  1761. <word_id>36</word_id>
  1762. <id>35</id>
  1763. <description></description>
  1764. <unique_key_name></unique_key_name>
  1765. <logical_name></logical_name>
  1766. <physical_name></physical_name>
  1767. <type>character(n)</type>
  1768. <constraint></constraint>
  1769. <default_value></default_value>
  1770. <auto_increment>false</auto_increment>
  1771. <foreign_key>false</foreign_key>
  1772. <not_null>false</not_null>
  1773. <primary_key>false</primary_key>
  1774. <unique_key>false</unique_key>
  1775. <character_set></character_set>
  1776. <collation></collation>
  1777. <sequence>
  1778. <name></name>
  1779. <schema></schema>
  1780. <increment></increment>
  1781. <min_value></min_value>
  1782. <max_value></max_value>
  1783. <start></start>
  1784. <cache></cache>
  1785. <cycle>false</cycle>
  1786. <order>false</order>
  1787. <description></description>
  1788. <data_type></data_type>
  1789. <decimal_size>0</decimal_size>
  1790. </sequence>
  1791. </normal_column>
  1792. <normal_column>
  1793. <word_id>35</word_id>
  1794. <id>36</id>
  1795. <description></description>
  1796. <unique_key_name></unique_key_name>
  1797. <logical_name></logical_name>
  1798. <physical_name></physical_name>
  1799. <type>nvarchar(n)</type>
  1800. <constraint></constraint>
  1801. <default_value></default_value>
  1802. <auto_increment>false</auto_increment>
  1803. <foreign_key>false</foreign_key>
  1804. <not_null>false</not_null>
  1805. <primary_key>false</primary_key>
  1806. <unique_key>false</unique_key>
  1807. <character_set></character_set>
  1808. <collation></collation>
  1809. <sequence>
  1810. <name></name>
  1811. <schema></schema>
  1812. <increment></increment>
  1813. <min_value></min_value>
  1814. <max_value></max_value>
  1815. <start></start>
  1816. <cache></cache>
  1817. <cycle>false</cycle>
  1818. <order>false</order>
  1819. <description></description>
  1820. <data_type></data_type>
  1821. <decimal_size>0</decimal_size>
  1822. </sequence>
  1823. </normal_column>
  1824. <normal_column>
  1825. <word_id>3</word_id>
  1826. <id>37</id>
  1827. <description></description>
  1828. <unique_key_name></unique_key_name>
  1829. <logical_name></logical_name>
  1830. <physical_name></physical_name>
  1831. <type>nvarchar(n)</type>
  1832. <constraint></constraint>
  1833. <default_value></default_value>
  1834. <auto_increment>false</auto_increment>
  1835. <foreign_key>false</foreign_key>
  1836. <not_null>false</not_null>
  1837. <primary_key>false</primary_key>
  1838. <unique_key>false</unique_key>
  1839. <character_set></character_set>
  1840. <collation></collation>
  1841. <sequence>
  1842. <name></name>
  1843. <schema></schema>
  1844. <increment></increment>
  1845. <min_value></min_value>
  1846. <max_value></max_value>
  1847. <start></start>
  1848. <cache></cache>
  1849. <cycle>false</cycle>
  1850. <order>false</order>
  1851. <description></description>
  1852. <data_type></data_type>
  1853. <decimal_size>0</decimal_size>
  1854. </sequence>
  1855. </normal_column>
  1856. <normal_column>
  1857. <word_id>11</word_id>
  1858. <id>38</id>
  1859. <description></description>
  1860. <unique_key_name></unique_key_name>
  1861. <logical_name></logical_name>
  1862. <physical_name></physical_name>
  1863. <type>nvarchar(n)</type>
  1864. <constraint></constraint>
  1865. <default_value></default_value>
  1866. <auto_increment>false</auto_increment>
  1867. <foreign_key>false</foreign_key>
  1868. <not_null>false</not_null>
  1869. <primary_key>false</primary_key>
  1870. <unique_key>false</unique_key>
  1871. <character_set></character_set>
  1872. <collation></collation>
  1873. <sequence>
  1874. <name></name>
  1875. <schema></schema>
  1876. <increment></increment>
  1877. <min_value></min_value>
  1878. <max_value></max_value>
  1879. <start></start>
  1880. <cache></cache>
  1881. <cycle>false</cycle>
  1882. <order>false</order>
  1883. <description></description>
  1884. <data_type></data_type>
  1885. <decimal_size>0</decimal_size>
  1886. </sequence>
  1887. </normal_column>
  1888. <normal_column>
  1889. <word_id>34</word_id>
  1890. <id>39</id>
  1891. <description></description>
  1892. <unique_key_name></unique_key_name>
  1893. <logical_name></logical_name>
  1894. <physical_name></physical_name>
  1895. <type>character(n)</type>
  1896. <constraint></constraint>
  1897. <default_value></default_value>
  1898. <auto_increment>false</auto_increment>
  1899. <foreign_key>false</foreign_key>
  1900. <not_null>false</not_null>
  1901. <primary_key>false</primary_key>
  1902. <unique_key>false</unique_key>
  1903. <character_set></character_set>
  1904. <collation></collation>
  1905. <sequence>
  1906. <name></name>
  1907. <schema></schema>
  1908. <increment></increment>
  1909. <min_value></min_value>
  1910. <max_value></max_value>
  1911. <start></start>
  1912. <cache></cache>
  1913. <cycle>false</cycle>
  1914. <order>false</order>
  1915. <description></description>
  1916. <data_type></data_type>
  1917. <decimal_size>0</decimal_size>
  1918. </sequence>
  1919. </normal_column>
  1920. <column_group>0</column_group>
  1921. </columns>
  1922. <indexes>
  1923. <inidex>
  1924. <full_text>false</full_text>
  1925. <non_unique>true</non_unique>
  1926. <name>oa_notify_del_flag</name>
  1927. <type></type>
  1928. <description></description>
  1929. <columns>
  1930. <column>
  1931. <id>5</id>
  1932. <desc>false</desc>
  1933. </column>
  1934. </columns>
  1935. </inidex>
  1936. </indexes>
  1937. <complex_unique_key_list>
  1938. </complex_unique_key_list>
  1939. <table_properties>
  1940. <schema></schema>
  1941. </table_properties>
  1942. </table>
  1943. <table>
  1944. <id>3</id>
  1945. <height>149</height>
  1946. <width>252</width>
  1947. <font_name>Segoe UI</font_name>
  1948. <font_size>9</font_size>
  1949. <x>741</x>
  1950. <y>365</y>
  1951. <color>
  1952. <r>128</r>
  1953. <g>128</g>
  1954. <b>192</b>
  1955. </color>
  1956. <connections>
  1957. <relation>
  1958. <id>0</id>
  1959. <source>2</source>
  1960. <target>3</target>
  1961. <child_cardinality>1..n</child_cardinality>
  1962. <parent_cardinality>1</parent_cardinality>
  1963. <reference_for_pk>true</reference_for_pk>
  1964. <name></name>
  1965. <on_delete_action>RESTRICT</on_delete_action>
  1966. <on_update_action>RESTRICT</on_update_action>
  1967. <source_xp>-1</source_xp>
  1968. <source_yp>-1</source_yp>
  1969. <target_xp>-1</target_xp>
  1970. <target_yp>-1</target_yp>
  1971. <referenced_column>null</referenced_column>
  1972. <referenced_complex_unique_key>null</referenced_complex_unique_key>
  1973. </relation>
  1974. </connections>
  1975. <physical_name>oa_notify_record</physical_name>
  1976. <logical_name>通知通告发送记录</logical_name>
  1977. <description>通知通告发送记录</description>
  1978. <constraint></constraint>
  1979. <primary_key_name></primary_key_name>
  1980. <option></option>
  1981. <columns>
  1982. <normal_column>
  1983. <word_id>13</word_id>
  1984. <id>40</id>
  1985. <description></description>
  1986. <unique_key_name></unique_key_name>
  1987. <logical_name></logical_name>
  1988. <physical_name></physical_name>
  1989. <type>varchar(n)</type>
  1990. <constraint></constraint>
  1991. <default_value></default_value>
  1992. <auto_increment>false</auto_increment>
  1993. <foreign_key>false</foreign_key>
  1994. <not_null>true</not_null>
  1995. <primary_key>true</primary_key>
  1996. <unique_key>false</unique_key>
  1997. <character_set></character_set>
  1998. <collation></collation>
  1999. <sequence>
  2000. <name></name>
  2001. <schema></schema>
  2002. <increment></increment>
  2003. <min_value></min_value>
  2004. <max_value></max_value>
  2005. <start></start>
  2006. <cache></cache>
  2007. <cycle>false</cycle>
  2008. <order>false</order>
  2009. <description></description>
  2010. <data_type></data_type>
  2011. <decimal_size>0</decimal_size>
  2012. </sequence>
  2013. </normal_column>
  2014. <normal_column>
  2015. <id>41</id>
  2016. <referenced_column>34</referenced_column>
  2017. <relation>0</relation>
  2018. <description></description>
  2019. <unique_key_name></unique_key_name>
  2020. <logical_name>通知通告ID</logical_name>
  2021. <physical_name>oa_notify_id</physical_name>
  2022. <type>varchar(n)</type>
  2023. <constraint></constraint>
  2024. <default_value></default_value>
  2025. <auto_increment>false</auto_increment>
  2026. <foreign_key>true</foreign_key>
  2027. <not_null>false</not_null>
  2028. <primary_key>false</primary_key>
  2029. <unique_key>false</unique_key>
  2030. <character_set></character_set>
  2031. <collation></collation>
  2032. <sequence>
  2033. <name></name>
  2034. <schema></schema>
  2035. <increment></increment>
  2036. <min_value></min_value>
  2037. <max_value></max_value>
  2038. <start></start>
  2039. <cache></cache>
  2040. <cycle>false</cycle>
  2041. <order>false</order>
  2042. <description></description>
  2043. <data_type></data_type>
  2044. <decimal_size>0</decimal_size>
  2045. </sequence>
  2046. </normal_column>
  2047. <normal_column>
  2048. <word_id>40</word_id>
  2049. <id>42</id>
  2050. <description></description>
  2051. <unique_key_name></unique_key_name>
  2052. <logical_name></logical_name>
  2053. <physical_name></physical_name>
  2054. <type>varchar(n)</type>
  2055. <constraint></constraint>
  2056. <default_value></default_value>
  2057. <auto_increment>false</auto_increment>
  2058. <foreign_key>false</foreign_key>
  2059. <not_null>false</not_null>
  2060. <primary_key>false</primary_key>
  2061. <unique_key>false</unique_key>
  2062. <character_set></character_set>
  2063. <collation></collation>
  2064. <sequence>
  2065. <name></name>
  2066. <schema></schema>
  2067. <increment></increment>
  2068. <min_value></min_value>
  2069. <max_value></max_value>
  2070. <start></start>
  2071. <cache></cache>
  2072. <cycle>false</cycle>
  2073. <order>false</order>
  2074. <description></description>
  2075. <data_type></data_type>
  2076. <decimal_size>0</decimal_size>
  2077. </sequence>
  2078. </normal_column>
  2079. <normal_column>
  2080. <word_id>28</word_id>
  2081. <id>43</id>
  2082. <description></description>
  2083. <unique_key_name></unique_key_name>
  2084. <logical_name></logical_name>
  2085. <physical_name></physical_name>
  2086. <type>character(n)</type>
  2087. <constraint></constraint>
  2088. <default_value>0</default_value>
  2089. <auto_increment>false</auto_increment>
  2090. <foreign_key>false</foreign_key>
  2091. <not_null>false</not_null>
  2092. <primary_key>false</primary_key>
  2093. <unique_key>false</unique_key>
  2094. <character_set></character_set>
  2095. <collation></collation>
  2096. <sequence>
  2097. <name></name>
  2098. <schema></schema>
  2099. <increment></increment>
  2100. <min_value></min_value>
  2101. <max_value></max_value>
  2102. <start></start>
  2103. <cache></cache>
  2104. <cycle>false</cycle>
  2105. <order>false</order>
  2106. <description></description>
  2107. <data_type></data_type>
  2108. <decimal_size>0</decimal_size>
  2109. </sequence>
  2110. </normal_column>
  2111. <normal_column>
  2112. <word_id>27</word_id>
  2113. <id>44</id>
  2114. <description></description>
  2115. <unique_key_name></unique_key_name>
  2116. <logical_name></logical_name>
  2117. <physical_name></physical_name>
  2118. <type>date</type>
  2119. <constraint></constraint>
  2120. <default_value></default_value>
  2121. <auto_increment>false</auto_increment>
  2122. <foreign_key>false</foreign_key>
  2123. <not_null>false</not_null>
  2124. <primary_key>false</primary_key>
  2125. <unique_key>false</unique_key>
  2126. <character_set></character_set>
  2127. <collation></collation>
  2128. <sequence>
  2129. <name></name>
  2130. <schema></schema>
  2131. <increment></increment>
  2132. <min_value></min_value>
  2133. <max_value></max_value>
  2134. <start></start>
  2135. <cache></cache>
  2136. <cycle>false</cycle>
  2137. <order>false</order>
  2138. <description></description>
  2139. <data_type></data_type>
  2140. <decimal_size>0</decimal_size>
  2141. </sequence>
  2142. </normal_column>
  2143. </columns>
  2144. <indexes>
  2145. <inidex>
  2146. <full_text>false</full_text>
  2147. <non_unique>true</non_unique>
  2148. <name>oa_notify_record_notify_id</name>
  2149. <type></type>
  2150. <description></description>
  2151. <columns>
  2152. <column>
  2153. <id>41</id>
  2154. <desc>false</desc>
  2155. </column>
  2156. </columns>
  2157. </inidex>
  2158. <inidex>
  2159. <full_text>false</full_text>
  2160. <non_unique>true</non_unique>
  2161. <name>oa_notify_record_user_id</name>
  2162. <type></type>
  2163. <description></description>
  2164. <columns>
  2165. <column>
  2166. <id>42</id>
  2167. <desc>false</desc>
  2168. </column>
  2169. </columns>
  2170. </inidex>
  2171. <inidex>
  2172. <full_text>false</full_text>
  2173. <non_unique>true</non_unique>
  2174. <name>oa_notify_record_read_flag</name>
  2175. <type></type>
  2176. <description></description>
  2177. <columns>
  2178. <column>
  2179. <id>43</id>
  2180. <desc>false</desc>
  2181. </column>
  2182. </columns>
  2183. </inidex>
  2184. </indexes>
  2185. <complex_unique_key_list>
  2186. </complex_unique_key_list>
  2187. <table_properties>
  2188. <schema></schema>
  2189. </table_properties>
  2190. </table>
  2191. </contents>
  2192. <column_groups>
  2193. <column_group>
  2194. <id>0</id>
  2195. <group_name>common</group_name>
  2196. <columns>
  2197. <normal_column>
  2198. <word_id>5</word_id>
  2199. <id>0</id>
  2200. <description></description>
  2201. <unique_key_name></unique_key_name>
  2202. <logical_name></logical_name>
  2203. <physical_name></physical_name>
  2204. <type>varchar(n)</type>
  2205. <constraint></constraint>
  2206. <default_value></default_value>
  2207. <auto_increment>false</auto_increment>
  2208. <foreign_key>false</foreign_key>
  2209. <not_null>true</not_null>
  2210. <primary_key>false</primary_key>
  2211. <unique_key>false</unique_key>
  2212. <character_set></character_set>
  2213. <collation></collation>
  2214. <sequence>
  2215. <name></name>
  2216. <schema></schema>
  2217. <increment></increment>
  2218. <min_value></min_value>
  2219. <max_value></max_value>
  2220. <start></start>
  2221. <cache></cache>
  2222. <cycle>false</cycle>
  2223. <order>false</order>
  2224. <description></description>
  2225. <data_type></data_type>
  2226. <decimal_size>0</decimal_size>
  2227. </sequence>
  2228. </normal_column>
  2229. <normal_column>
  2230. <word_id>6</word_id>
  2231. <id>1</id>
  2232. <description></description>
  2233. <unique_key_name></unique_key_name>
  2234. <logical_name></logical_name>
  2235. <physical_name></physical_name>
  2236. <type>datetime</type>
  2237. <constraint></constraint>
  2238. <default_value></default_value>
  2239. <auto_increment>false</auto_increment>
  2240. <foreign_key>false</foreign_key>
  2241. <not_null>true</not_null>
  2242. <primary_key>false</primary_key>
  2243. <unique_key>false</unique_key>
  2244. <character_set></character_set>
  2245. <collation></collation>
  2246. <sequence>
  2247. <name></name>
  2248. <schema></schema>
  2249. <increment></increment>
  2250. <min_value></min_value>
  2251. <max_value></max_value>
  2252. <start></start>
  2253. <cache></cache>
  2254. <cycle>false</cycle>
  2255. <order>false</order>
  2256. <description></description>
  2257. <data_type></data_type>
  2258. <decimal_size>0</decimal_size>
  2259. </sequence>
  2260. </normal_column>
  2261. <normal_column>
  2262. <word_id>37</word_id>
  2263. <id>2</id>
  2264. <description></description>
  2265. <unique_key_name></unique_key_name>
  2266. <logical_name></logical_name>
  2267. <physical_name></physical_name>
  2268. <type>varchar(n)</type>
  2269. <constraint></constraint>
  2270. <default_value></default_value>
  2271. <auto_increment>false</auto_increment>
  2272. <foreign_key>false</foreign_key>
  2273. <not_null>true</not_null>
  2274. <primary_key>false</primary_key>
  2275. <unique_key>false</unique_key>
  2276. <character_set></character_set>
  2277. <collation></collation>
  2278. <sequence>
  2279. <name></name>
  2280. <schema></schema>
  2281. <increment></increment>
  2282. <min_value></min_value>
  2283. <max_value></max_value>
  2284. <start></start>
  2285. <cache></cache>
  2286. <cycle>false</cycle>
  2287. <order>false</order>
  2288. <description></description>
  2289. <data_type></data_type>
  2290. <decimal_size>0</decimal_size>
  2291. </sequence>
  2292. </normal_column>
  2293. <normal_column>
  2294. <word_id>38</word_id>
  2295. <id>3</id>
  2296. <description></description>
  2297. <unique_key_name></unique_key_name>
  2298. <logical_name></logical_name>
  2299. <physical_name></physical_name>
  2300. <type>datetime</type>
  2301. <constraint></constraint>
  2302. <default_value></default_value>
  2303. <auto_increment>false</auto_increment>
  2304. <foreign_key>false</foreign_key>
  2305. <not_null>true</not_null>
  2306. <primary_key>false</primary_key>
  2307. <unique_key>false</unique_key>
  2308. <character_set></character_set>
  2309. <collation></collation>
  2310. <sequence>
  2311. <name></name>
  2312. <schema></schema>
  2313. <increment></increment>
  2314. <min_value></min_value>
  2315. <max_value></max_value>
  2316. <start></start>
  2317. <cache></cache>
  2318. <cycle>false</cycle>
  2319. <order>false</order>
  2320. <description></description>
  2321. <data_type></data_type>
  2322. <decimal_size>0</decimal_size>
  2323. </sequence>
  2324. </normal_column>
  2325. <normal_column>
  2326. <word_id>32</word_id>
  2327. <id>4</id>
  2328. <description></description>
  2329. <unique_key_name></unique_key_name>
  2330. <logical_name></logical_name>
  2331. <physical_name></physical_name>
  2332. <type>nvarchar(n)</type>
  2333. <constraint></constraint>
  2334. <default_value></default_value>
  2335. <auto_increment>false</auto_increment>
  2336. <foreign_key>false</foreign_key>
  2337. <not_null>false</not_null>
  2338. <primary_key>false</primary_key>
  2339. <unique_key>false</unique_key>
  2340. <character_set></character_set>
  2341. <collation></collation>
  2342. <sequence>
  2343. <name></name>
  2344. <schema></schema>
  2345. <increment></increment>
  2346. <min_value></min_value>
  2347. <max_value></max_value>
  2348. <start></start>
  2349. <cache></cache>
  2350. <cycle>false</cycle>
  2351. <order>false</order>
  2352. <description></description>
  2353. <data_type></data_type>
  2354. <decimal_size>0</decimal_size>
  2355. </sequence>
  2356. </normal_column>
  2357. <normal_column>
  2358. <word_id>7</word_id>
  2359. <id>5</id>
  2360. <description></description>
  2361. <unique_key_name></unique_key_name>
  2362. <logical_name></logical_name>
  2363. <physical_name></physical_name>
  2364. <type>character(n)</type>
  2365. <constraint></constraint>
  2366. <default_value>0</default_value>
  2367. <auto_increment>false</auto_increment>
  2368. <foreign_key>false</foreign_key>
  2369. <not_null>true</not_null>
  2370. <primary_key>false</primary_key>
  2371. <unique_key>false</unique_key>
  2372. <character_set></character_set>
  2373. <collation></collation>
  2374. <sequence>
  2375. <name></name>
  2376. <schema></schema>
  2377. <increment></increment>
  2378. <min_value></min_value>
  2379. <max_value></max_value>
  2380. <start></start>
  2381. <cache></cache>
  2382. <cycle>false</cycle>
  2383. <order>false</order>
  2384. <description></description>
  2385. <data_type></data_type>
  2386. <decimal_size>0</decimal_size>
  2387. </sequence>
  2388. </normal_column>
  2389. </columns>
  2390. </column_group>
  2391. </column_groups>
  2392. <test_data_list>
  2393. </test_data_list>
  2394. <sequence_set>
  2395. <sequence>
  2396. <name>seq_oa_leave</name>
  2397. <schema></schema>
  2398. <increment>1</increment>
  2399. <min_value></min_value>
  2400. <max_value></max_value>
  2401. <start>100</start>
  2402. <cache></cache>
  2403. <cycle>false</cycle>
  2404. <order>false</order>
  2405. <description></description>
  2406. <data_type></data_type>
  2407. <decimal_size>0</decimal_size>
  2408. </sequence>
  2409. <sequence>
  2410. <name>SEQ_OA_TEST_AUDIT</name>
  2411. <schema>JEESITE</schema>
  2412. <increment>1</increment>
  2413. <min_value>1</min_value>
  2414. <max_value>999999999999999999999999999</max_value>
  2415. <start>61</start>
  2416. <cache>20</cache>
  2417. <cycle>false</cycle>
  2418. <order>false</order>
  2419. <description></description>
  2420. <data_type></data_type>
  2421. <decimal_size>0</decimal_size>
  2422. </sequence>
  2423. </sequence_set>
  2424. <trigger_set>
  2425. </trigger_set>
  2426. <change_tracking_list>
  2427. </change_tracking_list>
  2428. </diagram>