Sql_Wkdb.edmx 151 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  3. <!-- EF Runtime content -->
  4. <edmx:Runtime>
  5. <!-- SSDL content -->
  6. <edmx:StorageModels>
  7. <Schema Namespace="wk_dbModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
  8. <EntityType Name="COM_CONTENT">
  9. <Key>
  10. <PropertyRef Name="ID" />
  11. </Key>
  12. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="FK_RELATIONID" Type="nvarchar" MaxLength="72" Nullable="false" />
  14. <Property Name="CONTENT" Type="ntext" />
  15. <Property Name="CONTENTBLOB" Type="varbinary(max)" />
  16. <Property Name="FK_TABLE" Type="nvarchar" MaxLength="200" Nullable="false" />
  17. <Property Name="CREATEDATE" Type="date" Nullable="false" />
  18. <Property Name="ISDEL" Type="int" Nullable="false" />
  19. </EntityType>
  20. <EntityType Name="COM_CUSCONTACT">
  21. <Key>
  22. <PropertyRef Name="ID" />
  23. </Key>
  24. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  25. <Property Name="NAME" Type="nvarchar" MaxLength="50" />
  26. <Property Name="SEX" Type="int" />
  27. <Property Name="PHOME" Type="nvarchar" MaxLength="50" />
  28. <Property Name="TELNO" Type="nvarchar" MaxLength="50" />
  29. <Property Name="SECONDPHONE" Type="nvarchar" MaxLength="50" />
  30. <Property Name="QQ" Type="nvarchar" MaxLength="20" />
  31. <Property Name="EMAIL" Type="nvarchar" MaxLength="20" />
  32. <Property Name="WX" Type="nvarchar" MaxLength="100" />
  33. <Property Name="COMPANY" Type="nvarchar" MaxLength="300" />
  34. <Property Name="COMPADDRESS" Type="nvarchar" MaxLength="500" />
  35. <Property Name="ZW" Type="nvarchar" MaxLength="20" />
  36. <Property Name="ADDRESS" Type="nvarchar" MaxLength="500" />
  37. <Property Name="PROV" Type="nvarchar" MaxLength="20" />
  38. <Property Name="CITY" Type="nvarchar" MaxLength="20" />
  39. <Property Name="REMARK" Type="nvarchar" MaxLength="2000" />
  40. <Property Name="FK_USERID" Type="int" Nullable="false" />
  41. <Property Name="CREATETIME" Type="datetime" Nullable="false" />
  42. <Property Name="FK_TYPE" Type="nvarchar" MaxLength="36" />
  43. </EntityType>
  44. <EntityType Name="COM_DOWNLOAD">
  45. <Key>
  46. <PropertyRef Name="ID" />
  47. </Key>
  48. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  49. <Property Name="FK_USERID" Type="int" />
  50. <Property Name="DLOPERATOR" Type="nvarchar" MaxLength="100" />
  51. <Property Name="DLIP" Type="nvarchar" MaxLength="40" />
  52. <Property Name="DLNUM" Type="int" />
  53. <Property Name="FK_UPID" Type="nvarchar" MaxLength="72" />
  54. <Property Name="DLDATE" Type="datetime" />
  55. </EntityType>
  56. <EntityType Name="COM_FLOWINFO">
  57. <Key>
  58. <PropertyRef Name="ID" />
  59. </Key>
  60. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  61. <Property Name="FLOWNO" Type="nvarchar" MaxLength="200" Nullable="false" />
  62. <Property Name="PATH" Type="nvarchar" MaxLength="1000" Nullable="false" />
  63. <Property Name="SHOW" Type="nvarchar" MaxLength="1000" Nullable="false" />
  64. <Property Name="TABLENAME" Type="nvarchar" MaxLength="100" Nullable="false" />
  65. <Property Name="REMARK" Type="nvarchar" MaxLength="400" Nullable="false" />
  66. <Property Name="CREATETIME" Type="datetime" Nullable="false" />
  67. <Property Name="CREATEUSER" Type="nvarchar" MaxLength="100" Nullable="false" />
  68. <Property Name="UPDATETIME" Type="datetime" Nullable="false" />
  69. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="100" Nullable="false" />
  70. </EntityType>
  71. <EntityType Name="COM_INDEX">
  72. <Key>
  73. <PropertyRef Name="ID" />
  74. </Key>
  75. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  76. <Property Name="TITLE" Type="nvarchar" MaxLength="200" Nullable="false" />
  77. <Property Name="ICON" Type="nvarchar" MaxLength="200" />
  78. <Property Name="COLOR" Type="nvarchar" MaxLength="50" />
  79. <Property Name="BACKGROUNDCOLOR" Type="nvarchar" MaxLength="50" />
  80. <Property Name="SHOWORDER" Type="int" Nullable="false" />
  81. <Property Name="PATH" Type="nvarchar" MaxLength="500" />
  82. <Property Name="SHOWTYPE" Type="int" Nullable="false" />
  83. </EntityType>
  84. <EntityType Name="COM_UPLOAD">
  85. <Key>
  86. <PropertyRef Name="ID" />
  87. </Key>
  88. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  89. <Property Name="FK_USERID" Type="nvarchar" MaxLength="72" />
  90. <Property Name="UPOPEATOR" Type="nvarchar" MaxLength="100" />
  91. <Property Name="UPTIME" Type="datetime" />
  92. <Property Name="UPOLDNAME" Type="nvarchar" MaxLength="400" />
  93. <Property Name="UPNEWNAME" Type="nvarchar" MaxLength="400" />
  94. <Property Name="UPFILESIZE" Type="int" />
  95. <Property Name="UPFILEUNIT" Type="nvarchar" MaxLength="20" />
  96. <Property Name="UPFILEPATH" Type="nvarchar" MaxLength="2000" />
  97. <Property Name="UPFILESUFFIX" Type="nvarchar" MaxLength="40" />
  98. <Property Name="UPFILETHUMBNAIL" Type="nvarchar" MaxLength="2000" />
  99. <Property Name="UPFILETHUMBNAILFORPAD" Type="nvarchar" MaxLength="2000" />
  100. <Property Name="UPFILETHUMBNAILFORPHONE" Type="nvarchar" MaxLength="2000" />
  101. <Property Name="UPFILEIP" Type="nvarchar" MaxLength="40" />
  102. <Property Name="UPFILEURL" Type="nvarchar" MaxLength="1000" />
  103. </EntityType>
  104. <EntityType Name="SYS_BEUSER">
  105. <Key>
  106. <PropertyRef Name="ID" />
  107. </Key>
  108. <Property Name="ID" Type="nvarchar" MaxLength="72" Nullable="false" />
  109. <Property Name="FK_USERID" Type="nvarchar" MaxLength="72" Nullable="false" />
  110. <Property Name="FK_TOUSER" Type="nvarchar" MaxLength="72" Nullable="false" />
  111. <Property Name="TONUMBER" Type="numeric" Precision="20" Scale="0" Nullable="false" />
  112. <Property Name="CREATETIME" Type="date" Nullable="false" />
  113. </EntityType>
  114. <EntityType Name="SYS_CODE">
  115. <Key>
  116. <PropertyRef Name="ID" />
  117. </Key>
  118. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  119. <Property Name="CODETYPE" Type="nvarchar" MaxLength="50" />
  120. <Property Name="NAMETEXT" Type="nvarchar" MaxLength="200" />
  121. <Property Name="CODEVALUE" Type="nvarchar" MaxLength="100" />
  122. <Property Name="SHOWORDER" Type="int" />
  123. <Property Name="ISCODE" Type="int" />
  124. <Property Name="REMARK" Type="nvarchar" MaxLength="2000" />
  125. <Property Name="CREATEDATE" Type="datetime" />
  126. <Property Name="CREATEUSER" Type="nvarchar" MaxLength="36" />
  127. <Property Name="UPDATEDATE" Type="datetime" />
  128. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
  129. <Property Name="PARENTID" Type="int" />
  130. </EntityType>
  131. <EntityType Name="SYS_CODE_AREA">
  132. <Key>
  133. <PropertyRef Name="ID" />
  134. </Key>
  135. <Property Name="ID" Type="varchar" MaxLength="50" Nullable="false" />
  136. <Property Name="PID" Type="varchar" MaxLength="50" Nullable="false" />
  137. <Property Name="NAME" Type="nvarchar" MaxLength="200" />
  138. <Property Name="LEVELS" Type="tinyint" Nullable="false" />
  139. </EntityType>
  140. <EntityType Name="SYS_DISTRIBUTORS">
  141. <Key>
  142. <PropertyRef Name="ID" />
  143. </Key>
  144. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  145. <Property Name="CODE" Type="nvarchar" MaxLength="100" />
  146. <Property Name="DealerNumber" Type="nvarchar" MaxLength="100" />
  147. <Property Name="NAME" Type="nvarchar" MaxLength="200" />
  148. <Property Name="BUSINESSLEVEL" Type="int" />
  149. <Property Name="SHOWORDER" Type="int" />
  150. <Property Name="Address" Type="nvarchar" MaxLength="100" />
  151. <Property Name="PARENTCODE" Type="nvarchar" MaxLength="100" />
  152. <Property Name="ParentName" Type="nvarchar" MaxLength="200" />
  153. <Property Name="LICENSEURL" Type="nvarchar" MaxLength="200" />
  154. <Property Name="LICENSEVALUE" Type="nvarchar" MaxLength="4000" />
  155. <Property Name="PARENTID" Type="nvarchar" MaxLength="36" />
  156. <Property Name="ProvinceCity" Type="varchar" MaxLength="200" />
  157. <Property Name="Province" Type="int" />
  158. <Property Name="City" Type="int" />
  159. <Property Name="Area" Type="int" />
  160. <Property Name="CREATEPERID" Type="nvarchar" MaxLength="36" />
  161. <Property Name="CREATEDATE" Type="date" />
  162. <Property Name="UPDATEDATE" Type="date" />
  163. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
  164. <Property Name="FenceID" Type="nvarchar" MaxLength="36" />
  165. <Property Name="FenceRadius" Type="int" />
  166. <Property Name="Theodolite" Type="nvarchar" MaxLength="80" />
  167. <Property Name="SaleType" Type="int" />
  168. <Property Name="SaleCar" Type="nvarchar" MaxLength="400" />
  169. <Property Name="Notes" Type="nvarchar" MaxLength="500" />
  170. </EntityType>
  171. <EntityType Name="SYS_LOG">
  172. <Key>
  173. <PropertyRef Name="ID" />
  174. </Key>
  175. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  176. <Property Name="DATES" Type="datetime" />
  177. <Property Name="LEVELS" Type="nvarchar" MaxLength="20" />
  178. <Property Name="LOGGER" Type="nvarchar" MaxLength="200" />
  179. <Property Name="CLIENTUSER" Type="nvarchar" MaxLength="100" />
  180. <Property Name="CLIENTIP" Type="nvarchar" MaxLength="20" />
  181. <Property Name="REQUESTURL" Type="nvarchar" MaxLength="500" />
  182. <Property Name="ACTION" Type="nvarchar" MaxLength="20" />
  183. <Property Name="MESSAGE" Type="nvarchar" MaxLength="4000" />
  184. <Property Name="EXCEPTION" Type="nvarchar" MaxLength="4000" />
  185. </EntityType>
  186. <EntityType Name="SYS_MODULE">
  187. <Key>
  188. <PropertyRef Name="ID" />
  189. </Key>
  190. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  191. <Property Name="FK_BELONGSYSTEM" Type="nvarchar" MaxLength="36" Nullable="false" />
  192. <Property Name="PARENTID" Type="int" Nullable="false" />
  193. <Property Name="NAME" Type="nvarchar" MaxLength="50" />
  194. <Property Name="ALIAS" Type="nvarchar" MaxLength="50" />
  195. <Property Name="MODULETYPE" Type="int" Nullable="false" />
  196. <Property Name="ICON" Type="nvarchar" MaxLength="200" />
  197. <Property Name="MODULEPATH" Type="nvarchar" MaxLength="500" />
  198. <Property Name="ISSHOW" Type="int" Nullable="false" />
  199. <Property Name="SHOWORDER" Type="int" Nullable="false" />
  200. <Property Name="LEVELS" Type="int" Nullable="false" />
  201. <Property Name="CREATEUSER" Type="nvarchar" MaxLength="50" />
  202. <Property Name="CREATEDATE" Type="datetime" />
  203. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
  204. <Property Name="UPDATEDATE" Type="datetime" />
  205. </EntityType>
  206. <EntityType Name="SYS_MSG">
  207. <Key>
  208. <PropertyRef Name="ID" />
  209. </Key>
  210. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  211. <Property Name="MSGNAME" Type="nvarchar" MaxLength="400" Nullable="false" />
  212. <Property Name="MSGTYPE" Type="nvarchar" MaxLength="100" />
  213. <Property Name="CREATEPER" Type="int" Nullable="false" />
  214. <Property Name="CREATEDATE" Type="datetime" Nullable="false" />
  215. <Property Name="DELETESTATUS" Type="int" Nullable="false" />
  216. <Property Name="MSGCONTENT" Type="text" />
  217. </EntityType>
  218. <EntityType Name="SYS_MSGATTACH">
  219. <Key>
  220. <PropertyRef Name="ID" />
  221. </Key>
  222. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  223. <Property Name="MSGID" Type="int" />
  224. <Property Name="FK_UPLOADID" Type="nvarchar" MaxLength="36" />
  225. <Property Name="CREATEDATE" Type="datetime" />
  226. </EntityType>
  227. <EntityType Name="SYS_MSGREV">
  228. <Key>
  229. <PropertyRef Name="ID" />
  230. </Key>
  231. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  232. <Property Name="MSGID" Type="int" Nullable="false" />
  233. <Property Name="USERID" Type="int" Nullable="false" />
  234. <Property Name="READSTATUS" Type="int" Nullable="false" />
  235. <Property Name="DELETESTATUS" Type="int" Nullable="false" />
  236. </EntityType>
  237. <!--生成过程中发现错误:
  238. 警告 6002: 表/视图“ChangFaMachinery.dbo.SYS_ONLINE”未定义主键。已推断出该键,并将定义创建为只读的表/视图。-->
  239. <EntityType Name="SYS_ONLINE">
  240. <Key>
  241. <PropertyRef Name="ID" />
  242. </Key>
  243. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  244. <Property Name="LOGINTIME" Type="date" />
  245. <Property Name="TIMEOUTTIME" Type="numeric" Precision="38" Scale="0" />
  246. <Property Name="COOKIEID" Type="nvarchar" MaxLength="36" />
  247. <Property Name="ACCOUNT" Type="nvarchar" MaxLength="36" />
  248. <Property Name="LASTACCESSTIME" Type="date" />
  249. <Property Name="STATE" Type="numeric" Precision="38" Scale="0" />
  250. <Property Name="USERID" Type="nvarchar" MaxLength="36" />
  251. <Property Name="NAME" Type="nvarchar" MaxLength="100" />
  252. </EntityType>
  253. <EntityType Name="SYS_PERMISSION">
  254. <Key>
  255. <PropertyRef Name="ID" />
  256. </Key>
  257. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  258. <Property Name="MODULEID" Type="int" Nullable="false" />
  259. <Property Name="NAME" Type="nvarchar" MaxLength="36" />
  260. <Property Name="PERVALUE" Type="nvarchar" MaxLength="100" />
  261. <Property Name="ICON" Type="nvarchar" MaxLength="50" />
  262. <Property Name="SHOWORDER" Type="int" />
  263. <Property Name="CREATEDATE" Type="date" />
  264. <Property Name="CREATEUSER" Type="nvarchar" MaxLength="36" />
  265. <Property Name="UPDATEDATE" Type="date" />
  266. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
  267. </EntityType>
  268. <EntityType Name="SYS_POST">
  269. <Key>
  270. <PropertyRef Name="ID" />
  271. </Key>
  272. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  273. <Property Name="POSTNAME" Type="nvarchar" MaxLength="100" />
  274. <Property Name="POSTTYPE" Type="nvarchar" MaxLength="36" Nullable="false" />
  275. <Property Name="REMARK" Type="nvarchar" MaxLength="500" />
  276. <Property Name="SHOWORDER" Type="int" />
  277. <Property Name="CREATEUSERID" Type="int" />
  278. <Property Name="CREATEDATE" Type="datetime" Nullable="false" />
  279. <Property Name="UPDATEDATE" Type="datetime" />
  280. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
  281. </EntityType>
  282. <EntityType Name="SYS_POST_DEPARTMENT">
  283. <Key>
  284. <PropertyRef Name="ID" />
  285. </Key>
  286. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  287. <Property Name="FK_DEPARTMENT_ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  288. <Property Name="FK_POST_ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  289. </EntityType>
  290. <EntityType Name="SYS_POST_USER">
  291. <Key>
  292. <PropertyRef Name="ID" />
  293. </Key>
  294. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  295. <Property Name="FK_USERID" Type="int" Nullable="false" />
  296. <Property Name="FK_POST_DEPARTMENTID" Type="int" Nullable="false" />
  297. </EntityType>
  298. <EntityType Name="SYS_ROLE">
  299. <Key>
  300. <PropertyRef Name="ID" />
  301. </Key>
  302. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  303. <Property Name="ROLENAME" Type="nvarchar" MaxLength="50" />
  304. <Property Name="ISCUSTOM" Type="int" Nullable="false" />
  305. <Property Name="ROLEDESC" Type="nvarchar" MaxLength="1000" />
  306. <Property Name="CREATEPERID" Type="nvarchar" MaxLength="36" Nullable="false" />
  307. <Property Name="CREATEDATE" Type="datetime" Nullable="false" />
  308. <Property Name="UPDATEDATE" Type="datetime" Nullable="false" />
  309. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
  310. </EntityType>
  311. <EntityType Name="SYS_ROLE_PERMISSION">
  312. <Key>
  313. <PropertyRef Name="ID" />
  314. </Key>
  315. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  316. <Property Name="ROLEID" Type="int" Nullable="false" />
  317. <Property Name="PERMISSIONID" Type="int" Nullable="false" />
  318. </EntityType>
  319. <EntityType Name="SYS_SMS">
  320. <Key>
  321. <PropertyRef Name="ID" />
  322. </Key>
  323. <Property Name="ID" Type="nvarchar" MaxLength="100" Nullable="false" />
  324. <Property Name="SENDER" Type="nvarchar" MaxLength="200" />
  325. <Property Name="SENDTOEMPID" Type="nvarchar" MaxLength="200" />
  326. <Property Name="RDT" Type="nvarchar" MaxLength="50" />
  327. <Property Name="TEL" Type="nvarchar" MaxLength="200" />
  328. <Property Name="TELSTA" Type="numeric" Precision="38" Scale="0" />
  329. <Property Name="EMAIL" Type="nvarchar" MaxLength="200" />
  330. <Property Name="EMAISTA" Type="numeric" Precision="38" Scale="0" />
  331. <Property Name="TITLE" Type="nvarchar" MaxLength="3000" />
  332. <Property Name="DOC" Type="nvarchar" MaxLength="4000" />
  333. <Property Name="SENDDT" Type="nvarchar" MaxLength="50" />
  334. <Property Name="ISREAD" Type="numeric" Precision="38" Scale="0" />
  335. <Property Name="ISALERT" Type="numeric" Precision="38" Scale="0" />
  336. <Property Name="MSGFLAG" Type="nvarchar" MaxLength="200" />
  337. <Property Name="WORKID" Type="numeric" Precision="38" Scale="0" />
  338. <Property Name="FLOWNO" Type="nvarchar" MaxLength="200" />
  339. </EntityType>
  340. <EntityType Name="SYS_SYSTEM">
  341. <Key>
  342. <PropertyRef Name="ID" />
  343. </Key>
  344. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  345. <Property Name="NAME" Type="nvarchar" MaxLength="200" />
  346. <Property Name="SITEURL" Type="nvarchar" MaxLength="500" />
  347. <Property Name="IS_LOGIN" Type="tinyint" />
  348. <Property Name="DOCKUSER" Type="nvarchar" MaxLength="100" />
  349. <Property Name="DOCKPASS" Type="nvarchar" MaxLength="200" />
  350. <Property Name="CREATEDATE" Type="date" />
  351. <Property Name="REMARK" Type="nvarchar" MaxLength="2000" />
  352. </EntityType>
  353. <EntityType Name="SYS_USER">
  354. <Key>
  355. <PropertyRef Name="ID" />
  356. </Key>
  357. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  358. <Property Name="NAME" Type="nvarchar" MaxLength="50" />
  359. <Property Name="ACCOUNT" Type="nvarchar" MaxLength="20" />
  360. <Property Name="PASSWORD" Type="nvarchar" MaxLength="50" />
  361. <Property Name="PHONE" Type="varchar" MaxLength="50" />
  362. <Property Name="ISCANLOGIN" Type="bit" />
  363. <Property Name="SHOWORDER1" Type="int" />
  364. <Property Name="SHOWORDER2" Type="int" />
  365. <Property Name="VERIFICATION" Type="varchar" MaxLength="50" />
  366. <Property Name="EXPIRYDATE" Type="datetime" />
  367. <Property Name="PINYIN1" Type="nvarchar" MaxLength="50" />
  368. <Property Name="PINYIN2" Type="nvarchar" MaxLength="50" />
  369. <Property Name="FACE_IMG" Type="nvarchar" MaxLength="200" />
  370. <Property Name="LEVELS" Type="nvarchar" MaxLength="36" />
  371. <Property Name="DPTID" Type="nvarchar" MaxLength="36" />
  372. <Property Name="WORKNUMBER" Type="nvarchar" MaxLength="50" />
  373. <Property Name="Location" Type="nvarchar" MaxLength="100" />
  374. <Property Name="USERTYPE" Type="int" />
  375. <Property Name="ISDEL" Type="bit" />
  376. <Property Name="LANG" Type="varchar" MaxLength="10" />
  377. <Property Name="CREATEPER" Type="nvarchar" MaxLength="36" />
  378. <Property Name="CREATEDATE" Type="datetime" />
  379. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
  380. <Property Name="UPDATEDATE" Type="datetime" />
  381. </EntityType>
  382. <EntityType Name="SYS_USER_DEPARTMENT">
  383. <Key>
  384. <PropertyRef Name="ID" />
  385. </Key>
  386. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  387. <Property Name="USER_ID" Type="int" Nullable="false" />
  388. <Property Name="DEPARTMENT_ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  389. </EntityType>
  390. <EntityType Name="SYS_USER_PERMISSION">
  391. <Key>
  392. <PropertyRef Name="ID" />
  393. </Key>
  394. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  395. <Property Name="FK_USERID" Type="int" Nullable="false" />
  396. <Property Name="FK_PERMISSIONID" Type="int" Nullable="false" />
  397. </EntityType>
  398. <EntityType Name="SYS_USER_ROLE">
  399. <Key>
  400. <PropertyRef Name="ID" />
  401. </Key>
  402. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  403. <Property Name="FK_USERID" Type="int" Nullable="false" />
  404. <Property Name="FK_ROLEID" Type="int" Nullable="false" />
  405. </EntityType>
  406. <EntityType Name="SYS_USERINFO">
  407. <Key>
  408. <PropertyRef Name="ID" />
  409. </Key>
  410. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  411. <Property Name="USERID" Type="int" Nullable="false" />
  412. <Property Name="POSTCODE" Type="int" />
  413. <Property Name="PHONE" Type="nvarchar" MaxLength="200" />
  414. <Property Name="OFFICEPHONE" Type="nvarchar" MaxLength="200" />
  415. <Property Name="EMAILADDRESS" Type="nvarchar" MaxLength="200" />
  416. <Property Name="SECONDPHONE" Type="nvarchar" MaxLength="200" />
  417. <Property Name="WORKCODE" Type="int" />
  418. <Property Name="SEXCODE" Type="int" />
  419. <Property Name="BIRTHDAY" Type="datetime" />
  420. <Property Name="NATIONCODE" Type="int" />
  421. <Property Name="IDNUMBER" Type="nvarchar" MaxLength="30" />
  422. <Property Name="MARRYCODE" Type="int" />
  423. <Property Name="IDENTITYCODE" Type="int" />
  424. <Property Name="HomeTown" Type="nvarchar" MaxLength="200" />
  425. <Property Name="ACCOUNTLOCATION" Type="nvarchar" MaxLength="200" />
  426. <Property Name="XUELI" Type="int" />
  427. <Property Name="ZHICHENG" Type="int" />
  428. <Property Name="GRADUATIONSCHOOL" Type="nvarchar" MaxLength="200" />
  429. <Property Name="SPECIALTY" Type="nvarchar" MaxLength="200" />
  430. <Property Name="PHOTOOLDNAME" Type="nvarchar" MaxLength="200" />
  431. <Property Name="PHOTONEWNAME" Type="nvarchar" MaxLength="200" />
  432. <Property Name="PHOTOTYPE" Type="nvarchar" MaxLength="200" />
  433. <Property Name="RESUMEOLDNAME" Type="nvarchar" MaxLength="200" />
  434. <Property Name="RESUMENEWNAME" Type="nvarchar" MaxLength="200" />
  435. <Property Name="RESUMETYPE" Type="nvarchar" MaxLength="200" />
  436. <Property Name="HuJiSuoZaiDi" Type="nvarchar" MaxLength="200" />
  437. <Property Name="HUJIPAICHUSUO" Type="nvarchar" MaxLength="200" />
  438. <Property Name="WORKDATE" Type="datetime" />
  439. <Property Name="JINRUDATE" Type="datetime" />
  440. <Property Name="CARNUMBER" Type="nvarchar" MaxLength="200" />
  441. <Property Name="QQ" Type="nvarchar" MaxLength="15" />
  442. <Property Name="WEBCHATOPENID" Type="nvarchar" MaxLength="200" />
  443. <Property Name="CREATEDATE" Type="datetime" />
  444. <Property Name="CREATEUSER" Type="nvarchar" MaxLength="36" />
  445. <Property Name="UPDATEDATE" Type="datetime" />
  446. <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
  447. </EntityType>
  448. <EntityType Name="SYS_WEBCHAT">
  449. <Key>
  450. <PropertyRef Name="ID" />
  451. </Key>
  452. <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
  453. <Property Name="OPENID" Type="nvarchar" MaxLength="100" />
  454. <Property Name="SMSCODE" Type="nvarchar" MaxLength="100" />
  455. <Property Name="CREATETIME" Type="date" />
  456. <Property Name="SENDTIME" Type="date" />
  457. <Property Name="TELPHONE" Type="nvarchar" MaxLength="11" />
  458. </EntityType>
  459. <EntityType Name="YW_Bicycle">
  460. <Key>
  461. <PropertyRef Name="ID" />
  462. </Key>
  463. <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
  464. <Property Name="IMSI" Type="nvarchar" MaxLength="36" />
  465. <Property Name="ICCID" Type="nvarchar" MaxLength="36" />
  466. <Property Name="UserId" Type="nvarchar" MaxLength="36" />
  467. <Property Name="SalesId" Type="nvarchar" MaxLength="36" />
  468. <Property Name="DistributorsID" Type="nvarchar" MaxLength="36" />
  469. <Property Name="DistributorsName" Type="nvarchar" MaxLength="200" />
  470. <Property Name="WarehouseID" Type="nvarchar" MaxLength="36" />
  471. <Property Name="WarehouseName" Type="nvarchar" MaxLength="200" />
  472. <Property Name="CarID" Type="nvarchar" MaxLength="60" />
  473. <Property Name="CarModel" Type="nvarchar" MaxLength="60" />
  474. <Property Name="CarNumber" Type="nvarchar" MaxLength="60" />
  475. <Property Name="carBar" Type="nvarchar" MaxLength="36" />
  476. <Property Name="ProductLine" Type="int" />
  477. <Property Name="CarName" Type="nvarchar" MaxLength="100" />
  478. <Property Name="productionDate" Type="datetime" />
  479. <Property Name="LeaseStatus" Type="int" />
  480. <Property Name="CarSate" Type="int" />
  481. <Property Name="LockState" Type="bit" />
  482. <Property Name="lang" Type="nvarchar" MaxLength="60" />
  483. <Property Name="carType" Type="int" />
  484. <Property Name="smallClass" Type="int" />
  485. <Property Name="Createper" Type="nvarchar" MaxLength="36" />
  486. <Property Name="CreateDate" Type="datetime" />
  487. <Property Name="OutDate" Type="datetime" />
  488. <Property Name="InputDate" Type="datetime" />
  489. <Property Name="SaleDate" Type="datetime" />
  490. <Property Name="UpdateUser" Type="nvarchar" MaxLength="36" />
  491. <Property Name="UpdateDate" Type="datetime" />
  492. <Property Name="FenceState" Type="int" />
  493. <Property Name="CustomerCode" Type="nvarchar" MaxLength="36" />
  494. <Property Name="CustomerName" Type="nvarchar" MaxLength="200" />
  495. <Property Name="FactoryNumber" Type="nvarchar" MaxLength="36" />
  496. <Property Name="OutFenceDate" Type="datetime" />
  497. <Property Name="InFenceDate" Type="datetime" />
  498. <Property Name="IsLockable" Type="bit" />
  499. </EntityType>
  500. <EntityType Name="YW_CarParamDetails">
  501. <Key>
  502. <PropertyRef Name="ID" />
  503. </Key>
  504. <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
  505. <Property Name="imei" Type="nvarchar" MaxLength="36" />
  506. <Property Name="hydraulic" Type="nvarchar" MaxLength="36" />
  507. <Property Name="temperature" Type="nvarchar" MaxLength="36" />
  508. <Property Name="voltage" Type="nvarchar" MaxLength="36" />
  509. <Property Name="speed" Type="nvarchar" MaxLength="36" />
  510. <Property Name="timestamp" Type="nvarchar" MaxLength="36" />
  511. <Property Name="cartype" Type="int" />
  512. <Property Name="add_time" Type="datetime" />
  513. </EntityType>
  514. <EntityType Name="YW_CarPurchaser">
  515. <Key>
  516. <PropertyRef Name="ID" />
  517. </Key>
  518. <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
  519. <Property Name="carId" Type="nvarchar" MaxLength="36" />
  520. <Property Name="carBar" Type="nvarchar" MaxLength="36" />
  521. <Property Name="imei" Type="nvarchar" MaxLength="36" />
  522. <Property Name="userName" Type="nvarchar" MaxLength="36" />
  523. <Property Name="userTel" Type="nvarchar" MaxLength="36" />
  524. <Property Name="userAddress" Type="nvarchar" MaxLength="150" />
  525. <Property Name="userCode" Type="nvarchar" MaxLength="36" />
  526. <Property Name="addDate" Type="datetime" />
  527. <Property Name="addName" Type="nvarchar" MaxLength="36" />
  528. <Property Name="updateDate" Type="datetime" />
  529. <Property Name="updateName" Type="nvarchar" MaxLength="36" />
  530. <Property Name="distributorsID" Type="nvarchar" MaxLength="36" />
  531. <Property Name="SaleDate" Type="datetime" />
  532. </EntityType>
  533. <EntityType Name="YW_Notice">
  534. <Key>
  535. <PropertyRef Name="ID" />
  536. </Key>
  537. <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
  538. <Property Name="Title" Type="nvarchar" MaxLength="200" />
  539. <Property Name="Content" Type="nvarchar" MaxLength="2000" />
  540. <Property Name="RoleId" Type="int" />
  541. <Property Name="Noticetype" Type="int" />
  542. <Property Name="IsRead" Type="bit" />
  543. <Property Name="IsDel" Type="bit" />
  544. <Property Name="createper" Type="nvarchar" MaxLength="36" />
  545. <Property Name="createDate" Type="datetime" />
  546. <Property Name="updateUser" Type="nvarchar" MaxLength="36" />
  547. <Property Name="updateDate" Type="datetime" />
  548. <Property Name="ImgUrl" Type="nvarchar" MaxLength="200" />
  549. </EntityType>
  550. <EntityType Name="YW_User_Notice">
  551. <Key>
  552. <PropertyRef Name="ID" />
  553. </Key>
  554. <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
  555. <Property Name="userID" Type="varchar" MaxLength="36" />
  556. <Property Name="noticeID" Type="varchar" MaxLength="36" />
  557. </EntityType>
  558. <EntityType Name="YW_UserCar">
  559. <Key>
  560. <PropertyRef Name="ID" />
  561. </Key>
  562. <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
  563. <Property Name="userId" Type="nvarchar" MaxLength="36" />
  564. <Property Name="carId" Type="nvarchar" MaxLength="36" />
  565. <Property Name="note" Type="nvarchar" MaxLength="200" />
  566. <Property Name="add_time" Type="datetime" />
  567. <Property Name="add_name" Type="nvarchar" MaxLength="50" />
  568. <Property Name="update_time" Type="datetime" />
  569. <Property Name="update_name" Type="nvarchar" MaxLength="50" />
  570. <Property Name="userTel" Type="nvarchar" MaxLength="50" />
  571. <Property Name="userName" Type="nvarchar" MaxLength="50" />
  572. <Property Name="userIdentity" Type="int" />
  573. </EntityType>
  574. <EntityType Name="YW_UserDistributor">
  575. <Key>
  576. <PropertyRef Name="ID" />
  577. </Key>
  578. <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
  579. <Property Name="userId" Type="int" />
  580. <Property Name="distributorId" Type="nvarchar" MaxLength="36" />
  581. <Property Name="add_name" Type="nvarchar" MaxLength="36" />
  582. <Property Name="add_time" Type="datetime" />
  583. <Property Name="ProductLine" Type="int" />
  584. <Property Name="ProductLine1" Type="int" />
  585. <Property Name="ProductLine2" Type="int" />
  586. <Property Name="ProductLine3" Type="int" />
  587. <Property Name="ProductLine4" Type="int" />
  588. <Property Name="ProductLine5" Type="int" />
  589. <Property Name="distype" Type="int" />
  590. </EntityType>
  591. <EntityType Name="YW_UserToken">
  592. <Key>
  593. <PropertyRef Name="ID" />
  594. </Key>
  595. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  596. <Property Name="UserType" Type="int" />
  597. <Property Name="UserToken" Type="nvarchar" MaxLength="36" />
  598. <Property Name="UID" Type="nvarchar" MaxLength="36" />
  599. <Property Name="AddTime" Type="datetime" />
  600. </EntityType>
  601. <Association Name="FK_SYS_MODULE_SYSTEMID">
  602. <End Role="SYS_SYSTEM" Type="Self.SYS_SYSTEM" Multiplicity="1" />
  603. <End Role="SYS_MODULE" Type="Self.SYS_MODULE" Multiplicity="*" />
  604. <ReferentialConstraint>
  605. <Principal Role="SYS_SYSTEM">
  606. <PropertyRef Name="ID" />
  607. </Principal>
  608. <Dependent Role="SYS_MODULE">
  609. <PropertyRef Name="FK_BELONGSYSTEM" />
  610. </Dependent>
  611. </ReferentialConstraint>
  612. </Association>
  613. <Association Name="FK_SYS_PERMISSION_MODULEID">
  614. <End Role="SYS_MODULE" Type="Self.SYS_MODULE" Multiplicity="1" />
  615. <End Role="SYS_PERMISSION" Type="Self.SYS_PERMISSION" Multiplicity="*" />
  616. <ReferentialConstraint>
  617. <Principal Role="SYS_MODULE">
  618. <PropertyRef Name="ID" />
  619. </Principal>
  620. <Dependent Role="SYS_PERMISSION">
  621. <PropertyRef Name="MODULEID" />
  622. </Dependent>
  623. </ReferentialConstraint>
  624. </Association>
  625. <Association Name="FK_SYS_POST_DEPARTMENT_DPTID">
  626. <End Role="SYS_DISTRIBUTORS" Type="Self.SYS_DISTRIBUTORS" Multiplicity="1" />
  627. <End Role="SYS_POST_DEPARTMENT" Type="Self.SYS_POST_DEPARTMENT" Multiplicity="*" />
  628. <ReferentialConstraint>
  629. <Principal Role="SYS_DISTRIBUTORS">
  630. <PropertyRef Name="ID" />
  631. </Principal>
  632. <Dependent Role="SYS_POST_DEPARTMENT">
  633. <PropertyRef Name="FK_DEPARTMENT_ID" />
  634. </Dependent>
  635. </ReferentialConstraint>
  636. </Association>
  637. <Association Name="FK_SYS_POST_DEPARTMENT_POSTID">
  638. <End Role="SYS_POST" Type="Self.SYS_POST" Multiplicity="1" />
  639. <End Role="SYS_POST_DEPARTMENT" Type="Self.SYS_POST_DEPARTMENT" Multiplicity="*" />
  640. <ReferentialConstraint>
  641. <Principal Role="SYS_POST">
  642. <PropertyRef Name="ID" />
  643. </Principal>
  644. <Dependent Role="SYS_POST_DEPARTMENT">
  645. <PropertyRef Name="FK_POST_ID" />
  646. </Dependent>
  647. </ReferentialConstraint>
  648. </Association>
  649. <Association Name="FK_SYS_POST_USER_POSTDPTID">
  650. <End Role="SYS_POST_DEPARTMENT" Type="Self.SYS_POST_DEPARTMENT" Multiplicity="1" />
  651. <End Role="SYS_POST_USER" Type="Self.SYS_POST_USER" Multiplicity="*" />
  652. <ReferentialConstraint>
  653. <Principal Role="SYS_POST_DEPARTMENT">
  654. <PropertyRef Name="ID" />
  655. </Principal>
  656. <Dependent Role="SYS_POST_USER">
  657. <PropertyRef Name="FK_POST_DEPARTMENTID" />
  658. </Dependent>
  659. </ReferentialConstraint>
  660. </Association>
  661. <Association Name="FK_SYS_POST_USER_USERID">
  662. <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
  663. <End Role="SYS_POST_USER" Type="Self.SYS_POST_USER" Multiplicity="*" />
  664. <ReferentialConstraint>
  665. <Principal Role="SYS_USER">
  666. <PropertyRef Name="ID" />
  667. </Principal>
  668. <Dependent Role="SYS_POST_USER">
  669. <PropertyRef Name="FK_USERID" />
  670. </Dependent>
  671. </ReferentialConstraint>
  672. </Association>
  673. <Association Name="FK_SYS_ROLE_PERMISSION_PERID">
  674. <End Role="SYS_PERMISSION" Type="Self.SYS_PERMISSION" Multiplicity="1" />
  675. <End Role="SYS_ROLE_PERMISSION" Type="Self.SYS_ROLE_PERMISSION" Multiplicity="*" />
  676. <ReferentialConstraint>
  677. <Principal Role="SYS_PERMISSION">
  678. <PropertyRef Name="ID" />
  679. </Principal>
  680. <Dependent Role="SYS_ROLE_PERMISSION">
  681. <PropertyRef Name="PERMISSIONID" />
  682. </Dependent>
  683. </ReferentialConstraint>
  684. </Association>
  685. <Association Name="FK_SYS_ROLE_PERMISSION_ROLEID">
  686. <End Role="SYS_ROLE" Type="Self.SYS_ROLE" Multiplicity="1" />
  687. <End Role="SYS_ROLE_PERMISSION" Type="Self.SYS_ROLE_PERMISSION" Multiplicity="*" />
  688. <ReferentialConstraint>
  689. <Principal Role="SYS_ROLE">
  690. <PropertyRef Name="ID" />
  691. </Principal>
  692. <Dependent Role="SYS_ROLE_PERMISSION">
  693. <PropertyRef Name="ROLEID" />
  694. </Dependent>
  695. </ReferentialConstraint>
  696. </Association>
  697. <Association Name="FK_SYS_USER_DEPARTMENT_DPTID">
  698. <End Role="SYS_DISTRIBUTORS" Type="Self.SYS_DISTRIBUTORS" Multiplicity="1" />
  699. <End Role="SYS_USER_DEPARTMENT" Type="Self.SYS_USER_DEPARTMENT" Multiplicity="*" />
  700. <ReferentialConstraint>
  701. <Principal Role="SYS_DISTRIBUTORS">
  702. <PropertyRef Name="ID" />
  703. </Principal>
  704. <Dependent Role="SYS_USER_DEPARTMENT">
  705. <PropertyRef Name="DEPARTMENT_ID" />
  706. </Dependent>
  707. </ReferentialConstraint>
  708. </Association>
  709. <Association Name="FK_SYS_USER_DEPARTMENT_USERID">
  710. <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
  711. <End Role="SYS_USER_DEPARTMENT" Type="Self.SYS_USER_DEPARTMENT" Multiplicity="*" />
  712. <ReferentialConstraint>
  713. <Principal Role="SYS_USER">
  714. <PropertyRef Name="ID" />
  715. </Principal>
  716. <Dependent Role="SYS_USER_DEPARTMENT">
  717. <PropertyRef Name="USER_ID" />
  718. </Dependent>
  719. </ReferentialConstraint>
  720. </Association>
  721. <Association Name="FK_SYS_USER_PERMISSION_PERID">
  722. <End Role="SYS_PERMISSION" Type="Self.SYS_PERMISSION" Multiplicity="1" />
  723. <End Role="SYS_USER_PERMISSION" Type="Self.SYS_USER_PERMISSION" Multiplicity="*" />
  724. <ReferentialConstraint>
  725. <Principal Role="SYS_PERMISSION">
  726. <PropertyRef Name="ID" />
  727. </Principal>
  728. <Dependent Role="SYS_USER_PERMISSION">
  729. <PropertyRef Name="FK_PERMISSIONID" />
  730. </Dependent>
  731. </ReferentialConstraint>
  732. </Association>
  733. <Association Name="FK_SYS_USER_PERMISSION_USERID">
  734. <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
  735. <End Role="SYS_USER_PERMISSION" Type="Self.SYS_USER_PERMISSION" Multiplicity="*" />
  736. <ReferentialConstraint>
  737. <Principal Role="SYS_USER">
  738. <PropertyRef Name="ID" />
  739. </Principal>
  740. <Dependent Role="SYS_USER_PERMISSION">
  741. <PropertyRef Name="FK_USERID" />
  742. </Dependent>
  743. </ReferentialConstraint>
  744. </Association>
  745. <Association Name="FK_SYS_USER_ROLE_ROLEID">
  746. <End Role="SYS_ROLE" Type="Self.SYS_ROLE" Multiplicity="1" />
  747. <End Role="SYS_USER_ROLE" Type="Self.SYS_USER_ROLE" Multiplicity="*" />
  748. <ReferentialConstraint>
  749. <Principal Role="SYS_ROLE">
  750. <PropertyRef Name="ID" />
  751. </Principal>
  752. <Dependent Role="SYS_USER_ROLE">
  753. <PropertyRef Name="FK_ROLEID" />
  754. </Dependent>
  755. </ReferentialConstraint>
  756. </Association>
  757. <Association Name="FK_SYS_USER_ROLE_USERID">
  758. <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
  759. <End Role="SYS_USER_ROLE" Type="Self.SYS_USER_ROLE" Multiplicity="*" />
  760. <ReferentialConstraint>
  761. <Principal Role="SYS_USER">
  762. <PropertyRef Name="ID" />
  763. </Principal>
  764. <Dependent Role="SYS_USER_ROLE">
  765. <PropertyRef Name="FK_USERID" />
  766. </Dependent>
  767. </ReferentialConstraint>
  768. </Association>
  769. <Association Name="FK_SYS_USERINFO_SYSUSERID">
  770. <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
  771. <End Role="SYS_USERINFO" Type="Self.SYS_USERINFO" Multiplicity="*" />
  772. <ReferentialConstraint>
  773. <Principal Role="SYS_USER">
  774. <PropertyRef Name="ID" />
  775. </Principal>
  776. <Dependent Role="SYS_USERINFO">
  777. <PropertyRef Name="USERID" />
  778. </Dependent>
  779. </ReferentialConstraint>
  780. </Association>
  781. <Function Name="PaginationByRowNumber" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
  782. <Parameter Name="Table" Type="varchar" Mode="In" />
  783. <Parameter Name="Sort" Type="varchar" Mode="In" />
  784. <Parameter Name="CurrentPage" Type="int" Mode="In" />
  785. <Parameter Name="PageSize" Type="int" Mode="In" />
  786. <Parameter Name="Fields" Type="varchar" Mode="In" />
  787. <Parameter Name="Filter" Type="varchar" Mode="In" />
  788. </Function>
  789. <EntityContainer Name="wk_dbModelStoreContainer">
  790. <EntitySet Name="COM_CONTENT" EntityType="Self.COM_CONTENT" Schema="dbo" store:Type="Tables" />
  791. <EntitySet Name="COM_CUSCONTACT" EntityType="Self.COM_CUSCONTACT" Schema="dbo" store:Type="Tables" />
  792. <EntitySet Name="COM_DOWNLOAD" EntityType="Self.COM_DOWNLOAD" Schema="dbo" store:Type="Tables" />
  793. <EntitySet Name="COM_FLOWINFO" EntityType="Self.COM_FLOWINFO" Schema="dbo" store:Type="Tables" />
  794. <EntitySet Name="COM_INDEX" EntityType="Self.COM_INDEX" Schema="dbo" store:Type="Tables" />
  795. <EntitySet Name="COM_UPLOAD" EntityType="Self.COM_UPLOAD" Schema="dbo" store:Type="Tables" />
  796. <EntitySet Name="SYS_BEUSER" EntityType="Self.SYS_BEUSER" Schema="dbo" store:Type="Tables" />
  797. <EntitySet Name="SYS_CODE" EntityType="Self.SYS_CODE" Schema="dbo" store:Type="Tables" />
  798. <EntitySet Name="SYS_CODE_AREA" EntityType="Self.SYS_CODE_AREA" Schema="dbo" store:Type="Tables" />
  799. <EntitySet Name="SYS_DISTRIBUTORS" EntityType="Self.SYS_DISTRIBUTORS" Schema="dbo" store:Type="Tables" />
  800. <EntitySet Name="SYS_LOG" EntityType="Self.SYS_LOG" Schema="dbo" store:Type="Tables" />
  801. <EntitySet Name="SYS_MODULE" EntityType="Self.SYS_MODULE" Schema="dbo" store:Type="Tables" />
  802. <EntitySet Name="SYS_MSG" EntityType="Self.SYS_MSG" Schema="dbo" store:Type="Tables" />
  803. <EntitySet Name="SYS_MSGATTACH" EntityType="Self.SYS_MSGATTACH" Schema="dbo" store:Type="Tables" />
  804. <EntitySet Name="SYS_MSGREV" EntityType="Self.SYS_MSGREV" Schema="dbo" store:Type="Tables" />
  805. <EntitySet Name="SYS_PERMISSION" EntityType="Self.SYS_PERMISSION" Schema="dbo" store:Type="Tables" />
  806. <EntitySet Name="SYS_POST" EntityType="Self.SYS_POST" Schema="dbo" store:Type="Tables" />
  807. <EntitySet Name="SYS_POST_DEPARTMENT" EntityType="Self.SYS_POST_DEPARTMENT" Schema="dbo" store:Type="Tables" />
  808. <EntitySet Name="SYS_POST_USER" EntityType="Self.SYS_POST_USER" Schema="dbo" store:Type="Tables" />
  809. <EntitySet Name="SYS_ROLE" EntityType="Self.SYS_ROLE" Schema="dbo" store:Type="Tables" />
  810. <EntitySet Name="SYS_ROLE_PERMISSION" EntityType="Self.SYS_ROLE_PERMISSION" Schema="dbo" store:Type="Tables" />
  811. <EntitySet Name="SYS_SMS" EntityType="Self.SYS_SMS" Schema="dbo" store:Type="Tables" />
  812. <EntitySet Name="SYS_SYSTEM" EntityType="Self.SYS_SYSTEM" Schema="dbo" store:Type="Tables" />
  813. <EntitySet Name="SYS_USER" EntityType="Self.SYS_USER" Schema="dbo" store:Type="Tables" />
  814. <EntitySet Name="SYS_USER_DEPARTMENT" EntityType="Self.SYS_USER_DEPARTMENT" Schema="dbo" store:Type="Tables" />
  815. <EntitySet Name="SYS_USER_PERMISSION" EntityType="Self.SYS_USER_PERMISSION" Schema="dbo" store:Type="Tables" />
  816. <EntitySet Name="SYS_USER_ROLE" EntityType="Self.SYS_USER_ROLE" Schema="dbo" store:Type="Tables" />
  817. <EntitySet Name="SYS_USERINFO" EntityType="Self.SYS_USERINFO" Schema="dbo" store:Type="Tables" />
  818. <EntitySet Name="SYS_WEBCHAT" EntityType="Self.SYS_WEBCHAT" Schema="dbo" store:Type="Tables" />
  819. <EntitySet Name="YW_Bicycle" EntityType="Self.YW_Bicycle" Schema="dbo" store:Type="Tables" />
  820. <EntitySet Name="YW_CarParamDetails" EntityType="Self.YW_CarParamDetails" Schema="dbo" store:Type="Tables" />
  821. <EntitySet Name="YW_CarPurchaser" EntityType="Self.YW_CarPurchaser" Schema="dbo" store:Type="Tables" />
  822. <EntitySet Name="YW_Notice" EntityType="Self.YW_Notice" Schema="dbo" store:Type="Tables" />
  823. <EntitySet Name="YW_User_Notice" EntityType="Self.YW_User_Notice" Schema="dbo" store:Type="Tables" />
  824. <EntitySet Name="YW_UserCar" EntityType="Self.YW_UserCar" Schema="dbo" store:Type="Tables" />
  825. <EntitySet Name="YW_UserDistributor" EntityType="Self.YW_UserDistributor" Schema="dbo" store:Type="Tables" />
  826. <EntitySet Name="YW_UserToken" EntityType="Self.YW_UserToken" Schema="dbo" store:Type="Tables" />
  827. <EntitySet Name="SYS_ONLINE" EntityType="Self.SYS_ONLINE" store:Type="Tables" store:Schema="dbo">
  828. <DefiningQuery>SELECT
  829. [SYS_ONLINE].[ID] AS [ID],
  830. [SYS_ONLINE].[LOGINTIME] AS [LOGINTIME],
  831. [SYS_ONLINE].[TIMEOUTTIME] AS [TIMEOUTTIME],
  832. [SYS_ONLINE].[COOKIEID] AS [COOKIEID],
  833. [SYS_ONLINE].[ACCOUNT] AS [ACCOUNT],
  834. [SYS_ONLINE].[LASTACCESSTIME] AS [LASTACCESSTIME],
  835. [SYS_ONLINE].[STATE] AS [STATE],
  836. [SYS_ONLINE].[USERID] AS [USERID],
  837. [SYS_ONLINE].[NAME] AS [NAME]
  838. FROM [dbo].[SYS_ONLINE] AS [SYS_ONLINE]</DefiningQuery>
  839. </EntitySet>
  840. <AssociationSet Name="FK_SYS_MODULE_SYSTEMID" Association="Self.FK_SYS_MODULE_SYSTEMID">
  841. <End Role="SYS_SYSTEM" EntitySet="SYS_SYSTEM" />
  842. <End Role="SYS_MODULE" EntitySet="SYS_MODULE" />
  843. </AssociationSet>
  844. <AssociationSet Name="FK_SYS_PERMISSION_MODULEID" Association="Self.FK_SYS_PERMISSION_MODULEID">
  845. <End Role="SYS_MODULE" EntitySet="SYS_MODULE" />
  846. <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
  847. </AssociationSet>
  848. <AssociationSet Name="FK_SYS_POST_DEPARTMENT_DPTID" Association="Self.FK_SYS_POST_DEPARTMENT_DPTID">
  849. <End Role="SYS_DISTRIBUTORS" EntitySet="SYS_DISTRIBUTORS" />
  850. <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
  851. </AssociationSet>
  852. <AssociationSet Name="FK_SYS_POST_DEPARTMENT_POSTID" Association="Self.FK_SYS_POST_DEPARTMENT_POSTID">
  853. <End Role="SYS_POST" EntitySet="SYS_POST" />
  854. <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
  855. </AssociationSet>
  856. <AssociationSet Name="FK_SYS_POST_USER_POSTDPTID" Association="Self.FK_SYS_POST_USER_POSTDPTID">
  857. <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
  858. <End Role="SYS_POST_USER" EntitySet="SYS_POST_USER" />
  859. </AssociationSet>
  860. <AssociationSet Name="FK_SYS_POST_USER_USERID" Association="Self.FK_SYS_POST_USER_USERID">
  861. <End Role="SYS_USER" EntitySet="SYS_USER" />
  862. <End Role="SYS_POST_USER" EntitySet="SYS_POST_USER" />
  863. </AssociationSet>
  864. <AssociationSet Name="FK_SYS_ROLE_PERMISSION_PERID" Association="Self.FK_SYS_ROLE_PERMISSION_PERID">
  865. <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
  866. <End Role="SYS_ROLE_PERMISSION" EntitySet="SYS_ROLE_PERMISSION" />
  867. </AssociationSet>
  868. <AssociationSet Name="FK_SYS_ROLE_PERMISSION_ROLEID" Association="Self.FK_SYS_ROLE_PERMISSION_ROLEID">
  869. <End Role="SYS_ROLE" EntitySet="SYS_ROLE" />
  870. <End Role="SYS_ROLE_PERMISSION" EntitySet="SYS_ROLE_PERMISSION" />
  871. </AssociationSet>
  872. <AssociationSet Name="FK_SYS_USER_DEPARTMENT_DPTID" Association="Self.FK_SYS_USER_DEPARTMENT_DPTID">
  873. <End Role="SYS_DISTRIBUTORS" EntitySet="SYS_DISTRIBUTORS" />
  874. <End Role="SYS_USER_DEPARTMENT" EntitySet="SYS_USER_DEPARTMENT" />
  875. </AssociationSet>
  876. <AssociationSet Name="FK_SYS_USER_DEPARTMENT_USERID" Association="Self.FK_SYS_USER_DEPARTMENT_USERID">
  877. <End Role="SYS_USER" EntitySet="SYS_USER" />
  878. <End Role="SYS_USER_DEPARTMENT" EntitySet="SYS_USER_DEPARTMENT" />
  879. </AssociationSet>
  880. <AssociationSet Name="FK_SYS_USER_PERMISSION_PERID" Association="Self.FK_SYS_USER_PERMISSION_PERID">
  881. <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
  882. <End Role="SYS_USER_PERMISSION" EntitySet="SYS_USER_PERMISSION" />
  883. </AssociationSet>
  884. <AssociationSet Name="FK_SYS_USER_PERMISSION_USERID" Association="Self.FK_SYS_USER_PERMISSION_USERID">
  885. <End Role="SYS_USER" EntitySet="SYS_USER" />
  886. <End Role="SYS_USER_PERMISSION" EntitySet="SYS_USER_PERMISSION" />
  887. </AssociationSet>
  888. <AssociationSet Name="FK_SYS_USER_ROLE_ROLEID" Association="Self.FK_SYS_USER_ROLE_ROLEID">
  889. <End Role="SYS_ROLE" EntitySet="SYS_ROLE" />
  890. <End Role="SYS_USER_ROLE" EntitySet="SYS_USER_ROLE" />
  891. </AssociationSet>
  892. <AssociationSet Name="FK_SYS_USER_ROLE_USERID" Association="Self.FK_SYS_USER_ROLE_USERID">
  893. <End Role="SYS_USER" EntitySet="SYS_USER" />
  894. <End Role="SYS_USER_ROLE" EntitySet="SYS_USER_ROLE" />
  895. </AssociationSet>
  896. <AssociationSet Name="FK_SYS_USERINFO_SYSUSERID" Association="Self.FK_SYS_USERINFO_SYSUSERID">
  897. <End Role="SYS_USER" EntitySet="SYS_USER" />
  898. <End Role="SYS_USERINFO" EntitySet="SYS_USERINFO" />
  899. </AssociationSet>
  900. </EntityContainer>
  901. </Schema></edmx:StorageModels>
  902. <!-- CSDL content -->
  903. <edmx:ConceptualModels>
  904. <Schema Namespace="wk_dbModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  905. <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
  906. <FunctionImport Name="PaginationByRowNumber">
  907. <Parameter Name="Table" Mode="In" Type="String" />
  908. <Parameter Name="Sort" Mode="In" Type="String" />
  909. <Parameter Name="CurrentPage" Mode="In" Type="Int32" />
  910. <Parameter Name="PageSize" Mode="In" Type="Int32" />
  911. <Parameter Name="Fields" Mode="In" Type="String" />
  912. <Parameter Name="Filter" Mode="In" Type="String" />
  913. </FunctionImport>
  914. <EntitySet Name="COM_CONTENT" EntityType="wk_dbModel.COM_CONTENT" />
  915. <EntitySet Name="COM_CUSCONTACT" EntityType="wk_dbModel.COM_CUSCONTACT" />
  916. <EntitySet Name="COM_DOWNLOAD" EntityType="wk_dbModel.COM_DOWNLOAD" />
  917. <EntitySet Name="COM_FLOWINFO" EntityType="wk_dbModel.COM_FLOWINFO" />
  918. <EntitySet Name="COM_INDEX" EntityType="wk_dbModel.COM_INDEX" />
  919. <EntitySet Name="COM_UPLOAD" EntityType="wk_dbModel.COM_UPLOAD" />
  920. <EntitySet Name="SYS_BEUSER" EntityType="wk_dbModel.SYS_BEUSER" />
  921. <EntitySet Name="SYS_CODE" EntityType="wk_dbModel.SYS_CODE" />
  922. <EntitySet Name="SYS_CODE_AREA" EntityType="wk_dbModel.SYS_CODE_AREA" />
  923. <EntitySet Name="SYS_LOG" EntityType="wk_dbModel.SYS_LOG" />
  924. <EntitySet Name="SYS_MODULE" EntityType="wk_dbModel.SYS_MODULE" />
  925. <EntitySet Name="SYS_MSG" EntityType="wk_dbModel.SYS_MSG" />
  926. <EntitySet Name="SYS_MSGATTACH" EntityType="wk_dbModel.SYS_MSGATTACH" />
  927. <EntitySet Name="SYS_MSGREV" EntityType="wk_dbModel.SYS_MSGREV" />
  928. <EntitySet Name="SYS_PERMISSION" EntityType="wk_dbModel.SYS_PERMISSION" />
  929. <EntitySet Name="SYS_POST" EntityType="wk_dbModel.SYS_POST" />
  930. <EntitySet Name="SYS_POST_DEPARTMENT" EntityType="wk_dbModel.SYS_POST_DEPARTMENT" />
  931. <EntitySet Name="SYS_POST_USER" EntityType="wk_dbModel.SYS_POST_USER" />
  932. <EntitySet Name="SYS_ROLE" EntityType="wk_dbModel.SYS_ROLE" />
  933. <EntitySet Name="SYS_ROLE_PERMISSION" EntityType="wk_dbModel.SYS_ROLE_PERMISSION" />
  934. <EntitySet Name="SYS_SMS" EntityType="wk_dbModel.SYS_SMS" />
  935. <EntitySet Name="SYS_SYSTEM" EntityType="wk_dbModel.SYS_SYSTEM" />
  936. <EntitySet Name="SYS_USER" EntityType="wk_dbModel.SYS_USER" />
  937. <EntitySet Name="SYS_USER_DEPARTMENT" EntityType="wk_dbModel.SYS_USER_DEPARTMENT" />
  938. <EntitySet Name="SYS_USER_PERMISSION" EntityType="wk_dbModel.SYS_USER_PERMISSION" />
  939. <EntitySet Name="SYS_USER_ROLE" EntityType="wk_dbModel.SYS_USER_ROLE" />
  940. <EntitySet Name="SYS_USERINFO" EntityType="wk_dbModel.SYS_USERINFO" />
  941. <EntitySet Name="SYS_WEBCHAT" EntityType="wk_dbModel.SYS_WEBCHAT" />
  942. <EntitySet Name="YW_Bicycle" EntityType="wk_dbModel.YW_Bicycle" />
  943. <EntitySet Name="YW_CarParamDetails" EntityType="wk_dbModel.YW_CarParamDetails" />
  944. <EntitySet Name="YW_CarPurchaser" EntityType="wk_dbModel.YW_CarPurchaser" />
  945. <EntitySet Name="YW_Notice" EntityType="wk_dbModel.YW_Notice" />
  946. <EntitySet Name="YW_User_Notice" EntityType="wk_dbModel.YW_User_Notice" />
  947. <EntitySet Name="YW_UserCar" EntityType="wk_dbModel.YW_UserCar" />
  948. <EntitySet Name="YW_UserDistributor" EntityType="wk_dbModel.YW_UserDistributor" />
  949. <EntitySet Name="YW_UserToken" EntityType="wk_dbModel.YW_UserToken" />
  950. <EntitySet Name="SYS_ONLINE" EntityType="wk_dbModel.SYS_ONLINE" />
  951. <AssociationSet Name="FK_SYS_MODULE_SYSTEMID" Association="wk_dbModel.FK_SYS_MODULE_SYSTEMID">
  952. <End Role="SYS_SYSTEM" EntitySet="SYS_SYSTEM" />
  953. <End Role="SYS_MODULE" EntitySet="SYS_MODULE" />
  954. </AssociationSet>
  955. <AssociationSet Name="FK_SYS_PERMISSION_MODULEID" Association="wk_dbModel.FK_SYS_PERMISSION_MODULEID">
  956. <End Role="SYS_MODULE" EntitySet="SYS_MODULE" />
  957. <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
  958. </AssociationSet>
  959. <AssociationSet Name="FK_SYS_ROLE_PERMISSION_PERID" Association="wk_dbModel.FK_SYS_ROLE_PERMISSION_PERID">
  960. <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
  961. <End Role="SYS_ROLE_PERMISSION" EntitySet="SYS_ROLE_PERMISSION" />
  962. </AssociationSet>
  963. <AssociationSet Name="FK_SYS_USER_PERMISSION_PERID" Association="wk_dbModel.FK_SYS_USER_PERMISSION_PERID">
  964. <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
  965. <End Role="SYS_USER_PERMISSION" EntitySet="SYS_USER_PERMISSION" />
  966. </AssociationSet>
  967. <AssociationSet Name="FK_SYS_POST_DEPARTMENT_POSTID" Association="wk_dbModel.FK_SYS_POST_DEPARTMENT_POSTID">
  968. <End Role="SYS_POST" EntitySet="SYS_POST" />
  969. <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
  970. </AssociationSet>
  971. <AssociationSet Name="FK_SYS_POST_USER_POSTDPTID" Association="wk_dbModel.FK_SYS_POST_USER_POSTDPTID">
  972. <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
  973. <End Role="SYS_POST_USER" EntitySet="SYS_POST_USER" />
  974. </AssociationSet>
  975. <AssociationSet Name="FK_SYS_POST_USER_USERID" Association="wk_dbModel.FK_SYS_POST_USER_USERID">
  976. <End Role="SYS_USER" EntitySet="SYS_USER" />
  977. <End Role="SYS_POST_USER" EntitySet="SYS_POST_USER" />
  978. </AssociationSet>
  979. <AssociationSet Name="FK_SYS_ROLE_PERMISSION_ROLEID" Association="wk_dbModel.FK_SYS_ROLE_PERMISSION_ROLEID">
  980. <End Role="SYS_ROLE" EntitySet="SYS_ROLE" />
  981. <End Role="SYS_ROLE_PERMISSION" EntitySet="SYS_ROLE_PERMISSION" />
  982. </AssociationSet>
  983. <AssociationSet Name="FK_SYS_USER_ROLE_ROLEID" Association="wk_dbModel.FK_SYS_USER_ROLE_ROLEID">
  984. <End Role="SYS_ROLE" EntitySet="SYS_ROLE" />
  985. <End Role="SYS_USER_ROLE" EntitySet="SYS_USER_ROLE" />
  986. </AssociationSet>
  987. <AssociationSet Name="FK_SYS_USER_DEPARTMENT_USERID" Association="wk_dbModel.FK_SYS_USER_DEPARTMENT_USERID">
  988. <End Role="SYS_USER" EntitySet="SYS_USER" />
  989. <End Role="SYS_USER_DEPARTMENT" EntitySet="SYS_USER_DEPARTMENT" />
  990. </AssociationSet>
  991. <AssociationSet Name="FK_SYS_USER_PERMISSION_USERID" Association="wk_dbModel.FK_SYS_USER_PERMISSION_USERID">
  992. <End Role="SYS_USER" EntitySet="SYS_USER" />
  993. <End Role="SYS_USER_PERMISSION" EntitySet="SYS_USER_PERMISSION" />
  994. </AssociationSet>
  995. <AssociationSet Name="FK_SYS_USER_ROLE_USERID" Association="wk_dbModel.FK_SYS_USER_ROLE_USERID">
  996. <End Role="SYS_USER" EntitySet="SYS_USER" />
  997. <End Role="SYS_USER_ROLE" EntitySet="SYS_USER_ROLE" />
  998. </AssociationSet>
  999. <AssociationSet Name="FK_SYS_USERINFO_SYSUSERID" Association="wk_dbModel.FK_SYS_USERINFO_SYSUSERID">
  1000. <End Role="SYS_USER" EntitySet="SYS_USER" />
  1001. <End Role="SYS_USERINFO" EntitySet="SYS_USERINFO" />
  1002. </AssociationSet>
  1003. <EntitySet Name="SYS_DISTRIBUTORS" EntityType="wk_dbModel.SYS_DISTRIBUTORS" />
  1004. <AssociationSet Name="FK_SYS_POST_DEPARTMENT_DPTID" Association="wk_dbModel.FK_SYS_POST_DEPARTMENT_DPTID">
  1005. <End Role="SYS_DISTRIBUTORS" EntitySet="SYS_DISTRIBUTORS" />
  1006. <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
  1007. </AssociationSet>
  1008. <AssociationSet Name="FK_SYS_USER_DEPARTMENT_DPTID" Association="wk_dbModel.FK_SYS_USER_DEPARTMENT_DPTID">
  1009. <End Role="SYS_DISTRIBUTORS" EntitySet="SYS_DISTRIBUTORS" />
  1010. <End Role="SYS_USER_DEPARTMENT" EntitySet="SYS_USER_DEPARTMENT" />
  1011. </AssociationSet>
  1012. </EntityContainer>
  1013. <EntityType Name="COM_CONTENT">
  1014. <Key>
  1015. <PropertyRef Name="ID" />
  1016. </Key>
  1017. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1018. <Property Name="FK_RELATIONID" Type="String" Nullable="false" MaxLength="72" FixedLength="false" Unicode="true" />
  1019. <Property Name="CONTENT" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  1020. <Property Name="CONTENTBLOB" Type="Binary" MaxLength="Max" FixedLength="false" />
  1021. <Property Name="FK_TABLE" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
  1022. <Property Name="CREATEDATE" Type="DateTime" Nullable="false" Precision="0" />
  1023. <Property Name="ISDEL" Type="Int32" Nullable="false" />
  1024. </EntityType>
  1025. <EntityType Name="COM_CUSCONTACT">
  1026. <Key>
  1027. <PropertyRef Name="ID" />
  1028. </Key>
  1029. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1030. <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1031. <Property Name="SEX" Type="Int32" />
  1032. <Property Name="PHOME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1033. <Property Name="TELNO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1034. <Property Name="SECONDPHONE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1035. <Property Name="QQ" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1036. <Property Name="EMAIL" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1037. <Property Name="WX" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1038. <Property Name="COMPANY" Type="String" MaxLength="300" FixedLength="false" Unicode="true" />
  1039. <Property Name="COMPADDRESS" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
  1040. <Property Name="ZW" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1041. <Property Name="ADDRESS" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
  1042. <Property Name="PROV" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1043. <Property Name="CITY" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1044. <Property Name="REMARK" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
  1045. <Property Name="FK_USERID" Type="Int32" Nullable="false" />
  1046. <Property Name="CREATETIME" Type="DateTime" Nullable="false" Precision="3" />
  1047. <Property Name="FK_TYPE" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1048. </EntityType>
  1049. <EntityType Name="COM_DOWNLOAD">
  1050. <Key>
  1051. <PropertyRef Name="ID" />
  1052. </Key>
  1053. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1054. <Property Name="FK_USERID" Type="Int32" />
  1055. <Property Name="DLOPERATOR" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1056. <Property Name="DLIP" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
  1057. <Property Name="DLNUM" Type="Int32" />
  1058. <Property Name="FK_UPID" Type="String" MaxLength="72" FixedLength="false" Unicode="true" />
  1059. <Property Name="DLDATE" Type="DateTime" Precision="3" />
  1060. </EntityType>
  1061. <EntityType Name="COM_FLOWINFO">
  1062. <Key>
  1063. <PropertyRef Name="ID" />
  1064. </Key>
  1065. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1066. <Property Name="FLOWNO" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
  1067. <Property Name="PATH" Type="String" Nullable="false" MaxLength="1000" FixedLength="false" Unicode="true" />
  1068. <Property Name="SHOW" Type="String" Nullable="false" MaxLength="1000" FixedLength="false" Unicode="true" />
  1069. <Property Name="TABLENAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
  1070. <Property Name="REMARK" Type="String" Nullable="false" MaxLength="400" FixedLength="false" Unicode="true" />
  1071. <Property Name="CREATETIME" Type="DateTime" Nullable="false" Precision="3" />
  1072. <Property Name="CREATEUSER" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
  1073. <Property Name="UPDATETIME" Type="DateTime" Nullable="false" Precision="3" />
  1074. <Property Name="UPDATEUSER" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
  1075. </EntityType>
  1076. <EntityType Name="COM_INDEX">
  1077. <Key>
  1078. <PropertyRef Name="ID" />
  1079. </Key>
  1080. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1081. <Property Name="TITLE" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
  1082. <Property Name="ICON" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1083. <Property Name="COLOR" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1084. <Property Name="BACKGROUNDCOLOR" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1085. <Property Name="SHOWORDER" Type="Int32" Nullable="false" />
  1086. <Property Name="PATH" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
  1087. <Property Name="SHOWTYPE" Type="Int32" Nullable="false" />
  1088. </EntityType>
  1089. <EntityType Name="COM_UPLOAD">
  1090. <Key>
  1091. <PropertyRef Name="ID" />
  1092. </Key>
  1093. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1094. <Property Name="FK_USERID" Type="String" MaxLength="72" FixedLength="false" Unicode="true" />
  1095. <Property Name="UPOPEATOR" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1096. <Property Name="UPTIME" Type="DateTime" Precision="3" />
  1097. <Property Name="UPOLDNAME" Type="String" MaxLength="400" FixedLength="false" Unicode="true" />
  1098. <Property Name="UPNEWNAME" Type="String" MaxLength="400" FixedLength="false" Unicode="true" />
  1099. <Property Name="UPFILESIZE" Type="Int32" />
  1100. <Property Name="UPFILEUNIT" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1101. <Property Name="UPFILEPATH" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
  1102. <Property Name="UPFILESUFFIX" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
  1103. <Property Name="UPFILETHUMBNAIL" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
  1104. <Property Name="UPFILETHUMBNAILFORPAD" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
  1105. <Property Name="UPFILETHUMBNAILFORPHONE" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
  1106. <Property Name="UPFILEIP" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
  1107. <Property Name="UPFILEURL" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
  1108. </EntityType>
  1109. <EntityType Name="SYS_BEUSER">
  1110. <Key>
  1111. <PropertyRef Name="ID" />
  1112. </Key>
  1113. <Property Name="ID" Type="String" Nullable="false" MaxLength="72" FixedLength="false" Unicode="true" />
  1114. <Property Name="FK_USERID" Type="String" Nullable="false" MaxLength="72" FixedLength="false" Unicode="true" />
  1115. <Property Name="FK_TOUSER" Type="String" Nullable="false" MaxLength="72" FixedLength="false" Unicode="true" />
  1116. <Property Name="TONUMBER" Type="Decimal" Nullable="false" Precision="20" Scale="0" />
  1117. <Property Name="CREATETIME" Type="DateTime" Nullable="false" Precision="0" />
  1118. </EntityType>
  1119. <EntityType Name="SYS_CODE">
  1120. <Key>
  1121. <PropertyRef Name="ID" />
  1122. </Key>
  1123. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1124. <Property Name="CODETYPE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1125. <Property Name="NAMETEXT" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1126. <Property Name="CODEVALUE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1127. <Property Name="SHOWORDER" Type="Int32" />
  1128. <Property Name="ISCODE" Type="Int32" />
  1129. <Property Name="REMARK" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
  1130. <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
  1131. <Property Name="CREATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1132. <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
  1133. <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1134. <Property Name="PARENTID" Type="Int32" />
  1135. </EntityType>
  1136. <EntityType Name="SYS_CODE_AREA">
  1137. <Key>
  1138. <PropertyRef Name="ID" />
  1139. </Key>
  1140. <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
  1141. <Property Name="PID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
  1142. <Property Name="NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1143. <Property Name="LEVELS" Type="Byte" Nullable="false" />
  1144. </EntityType>
  1145. <EntityType Name="SYS_LOG">
  1146. <Key>
  1147. <PropertyRef Name="ID" />
  1148. </Key>
  1149. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1150. <Property Name="DATES" Type="DateTime" Precision="3" />
  1151. <Property Name="LEVELS" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1152. <Property Name="LOGGER" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1153. <Property Name="CLIENTUSER" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1154. <Property Name="CLIENTIP" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1155. <Property Name="REQUESTURL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
  1156. <Property Name="ACTION" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1157. <Property Name="MESSAGE" Type="String" MaxLength="4000" FixedLength="false" Unicode="true" />
  1158. <Property Name="EXCEPTION" Type="String" MaxLength="4000" FixedLength="false" Unicode="true" />
  1159. </EntityType>
  1160. <EntityType Name="SYS_MODULE">
  1161. <Key>
  1162. <PropertyRef Name="ID" />
  1163. </Key>
  1164. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1165. <Property Name="FK_BELONGSYSTEM" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1166. <Property Name="PARENTID" Type="Int32" Nullable="false" />
  1167. <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1168. <Property Name="ALIAS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1169. <Property Name="MODULETYPE" Type="Int32" Nullable="false" />
  1170. <Property Name="ICON" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1171. <Property Name="MODULEPATH" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
  1172. <Property Name="ISSHOW" Type="Int32" Nullable="false" />
  1173. <Property Name="SHOWORDER" Type="Int32" Nullable="false" />
  1174. <Property Name="LEVELS" Type="Int32" Nullable="false" />
  1175. <Property Name="CREATEUSER" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1176. <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
  1177. <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1178. <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
  1179. <NavigationProperty Name="SYS_SYSTEM" Relationship="wk_dbModel.FK_SYS_MODULE_SYSTEMID" FromRole="SYS_MODULE" ToRole="SYS_SYSTEM" />
  1180. <NavigationProperty Name="SYS_PERMISSION" Relationship="wk_dbModel.FK_SYS_PERMISSION_MODULEID" FromRole="SYS_MODULE" ToRole="SYS_PERMISSION" />
  1181. </EntityType>
  1182. <EntityType Name="SYS_MSG">
  1183. <Key>
  1184. <PropertyRef Name="ID" />
  1185. </Key>
  1186. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1187. <Property Name="MSGNAME" Type="String" Nullable="false" MaxLength="400" FixedLength="false" Unicode="true" />
  1188. <Property Name="MSGTYPE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1189. <Property Name="CREATEPER" Type="Int32" Nullable="false" />
  1190. <Property Name="CREATEDATE" Type="DateTime" Nullable="false" Precision="3" />
  1191. <Property Name="DELETESTATUS" Type="Int32" Nullable="false" />
  1192. <Property Name="MSGCONTENT" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
  1193. </EntityType>
  1194. <EntityType Name="SYS_MSGATTACH">
  1195. <Key>
  1196. <PropertyRef Name="ID" />
  1197. </Key>
  1198. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1199. <Property Name="MSGID" Type="Int32" />
  1200. <Property Name="FK_UPLOADID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1201. <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
  1202. </EntityType>
  1203. <EntityType Name="SYS_MSGREV">
  1204. <Key>
  1205. <PropertyRef Name="ID" />
  1206. </Key>
  1207. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1208. <Property Name="MSGID" Type="Int32" Nullable="false" />
  1209. <Property Name="USERID" Type="Int32" Nullable="false" />
  1210. <Property Name="READSTATUS" Type="Int32" Nullable="false" />
  1211. <Property Name="DELETESTATUS" Type="Int32" Nullable="false" />
  1212. </EntityType>
  1213. <EntityType Name="SYS_PERMISSION">
  1214. <Key>
  1215. <PropertyRef Name="ID" />
  1216. </Key>
  1217. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1218. <Property Name="MODULEID" Type="Int32" Nullable="false" />
  1219. <Property Name="NAME" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1220. <Property Name="PERVALUE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1221. <Property Name="ICON" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1222. <Property Name="SHOWORDER" Type="Int32" />
  1223. <Property Name="CREATEDATE" Type="DateTime" Precision="0" />
  1224. <Property Name="CREATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1225. <Property Name="UPDATEDATE" Type="DateTime" Precision="0" />
  1226. <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1227. <NavigationProperty Name="SYS_MODULE" Relationship="wk_dbModel.FK_SYS_PERMISSION_MODULEID" FromRole="SYS_PERMISSION" ToRole="SYS_MODULE" />
  1228. <NavigationProperty Name="SYS_ROLE_PERMISSION" Relationship="wk_dbModel.FK_SYS_ROLE_PERMISSION_PERID" FromRole="SYS_PERMISSION" ToRole="SYS_ROLE_PERMISSION" />
  1229. <NavigationProperty Name="SYS_USER_PERMISSION" Relationship="wk_dbModel.FK_SYS_USER_PERMISSION_PERID" FromRole="SYS_PERMISSION" ToRole="SYS_USER_PERMISSION" />
  1230. </EntityType>
  1231. <EntityType Name="SYS_POST">
  1232. <Key>
  1233. <PropertyRef Name="ID" />
  1234. </Key>
  1235. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1236. <Property Name="POSTNAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1237. <Property Name="POSTTYPE" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1238. <Property Name="REMARK" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
  1239. <Property Name="SHOWORDER" Type="Int32" />
  1240. <Property Name="CREATEUSERID" Type="Int32" />
  1241. <Property Name="CREATEDATE" Type="DateTime" Nullable="false" Precision="3" />
  1242. <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
  1243. <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1244. <NavigationProperty Name="SYS_POST_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_POST_DEPARTMENT_POSTID" FromRole="SYS_POST" ToRole="SYS_POST_DEPARTMENT" />
  1245. </EntityType>
  1246. <EntityType Name="SYS_POST_DEPARTMENT">
  1247. <Key>
  1248. <PropertyRef Name="ID" />
  1249. </Key>
  1250. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1251. <Property Name="FK_DEPARTMENT_ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1252. <Property Name="FK_POST_ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1253. <NavigationProperty Name="SYS_POST" Relationship="wk_dbModel.FK_SYS_POST_DEPARTMENT_POSTID" FromRole="SYS_POST_DEPARTMENT" ToRole="SYS_POST" />
  1254. <NavigationProperty Name="SYS_POST_USER" Relationship="wk_dbModel.FK_SYS_POST_USER_POSTDPTID" FromRole="SYS_POST_DEPARTMENT" ToRole="SYS_POST_USER" />
  1255. <NavigationProperty Name="SYS_DISTRIBUTORS" Relationship="wk_dbModel.FK_SYS_POST_DEPARTMENT_DPTID" FromRole="SYS_POST_DEPARTMENT" ToRole="SYS_DISTRIBUTORS" />
  1256. </EntityType>
  1257. <EntityType Name="SYS_POST_USER">
  1258. <Key>
  1259. <PropertyRef Name="ID" />
  1260. </Key>
  1261. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1262. <Property Name="FK_USERID" Type="Int32" Nullable="false" />
  1263. <Property Name="FK_POST_DEPARTMENTID" Type="Int32" Nullable="false" />
  1264. <NavigationProperty Name="SYS_POST_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_POST_USER_POSTDPTID" FromRole="SYS_POST_USER" ToRole="SYS_POST_DEPARTMENT" />
  1265. <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_POST_USER_USERID" FromRole="SYS_POST_USER" ToRole="SYS_USER" />
  1266. </EntityType>
  1267. <EntityType Name="SYS_ROLE">
  1268. <Key>
  1269. <PropertyRef Name="ID" />
  1270. </Key>
  1271. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1272. <Property Name="ROLENAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1273. <Property Name="ISCUSTOM" Type="Int32" Nullable="false" />
  1274. <Property Name="ROLEDESC" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
  1275. <Property Name="CREATEPERID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1276. <Property Name="CREATEDATE" Type="DateTime" Nullable="false" Precision="3" />
  1277. <Property Name="UPDATEDATE" Type="DateTime" Nullable="false" Precision="3" />
  1278. <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1279. <NavigationProperty Name="SYS_ROLE_PERMISSION" Relationship="wk_dbModel.FK_SYS_ROLE_PERMISSION_ROLEID" FromRole="SYS_ROLE" ToRole="SYS_ROLE_PERMISSION" />
  1280. <NavigationProperty Name="SYS_USER_ROLE" Relationship="wk_dbModel.FK_SYS_USER_ROLE_ROLEID" FromRole="SYS_ROLE" ToRole="SYS_USER_ROLE" />
  1281. </EntityType>
  1282. <EntityType Name="SYS_ROLE_PERMISSION">
  1283. <Key>
  1284. <PropertyRef Name="ID" />
  1285. </Key>
  1286. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1287. <Property Name="ROLEID" Type="Int32" Nullable="false" />
  1288. <Property Name="PERMISSIONID" Type="Int32" Nullable="false" />
  1289. <NavigationProperty Name="SYS_PERMISSION" Relationship="wk_dbModel.FK_SYS_ROLE_PERMISSION_PERID" FromRole="SYS_ROLE_PERMISSION" ToRole="SYS_PERMISSION" />
  1290. <NavigationProperty Name="SYS_ROLE" Relationship="wk_dbModel.FK_SYS_ROLE_PERMISSION_ROLEID" FromRole="SYS_ROLE_PERMISSION" ToRole="SYS_ROLE" />
  1291. </EntityType>
  1292. <EntityType Name="SYS_SMS">
  1293. <Key>
  1294. <PropertyRef Name="ID" />
  1295. </Key>
  1296. <Property Name="ID" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
  1297. <Property Name="SENDER" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1298. <Property Name="SENDTOEMPID" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1299. <Property Name="RDT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1300. <Property Name="TEL" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1301. <Property Name="TELSTA" Type="Decimal" Precision="38" Scale="0" />
  1302. <Property Name="EMAIL" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1303. <Property Name="EMAISTA" Type="Decimal" Precision="38" Scale="0" />
  1304. <Property Name="TITLE" Type="String" MaxLength="3000" FixedLength="false" Unicode="true" />
  1305. <Property Name="DOC" Type="String" MaxLength="4000" FixedLength="false" Unicode="true" />
  1306. <Property Name="SENDDT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1307. <Property Name="ISREAD" Type="Decimal" Precision="38" Scale="0" />
  1308. <Property Name="ISALERT" Type="Decimal" Precision="38" Scale="0" />
  1309. <Property Name="MSGFLAG" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1310. <Property Name="WORKID" Type="Decimal" Precision="38" Scale="0" />
  1311. <Property Name="FLOWNO" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1312. </EntityType>
  1313. <EntityType Name="SYS_SYSTEM">
  1314. <Key>
  1315. <PropertyRef Name="ID" />
  1316. </Key>
  1317. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1318. <Property Name="NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1319. <Property Name="SITEURL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
  1320. <Property Name="IS_LOGIN" Type="Byte" />
  1321. <Property Name="DOCKUSER" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1322. <Property Name="DOCKPASS" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1323. <Property Name="CREATEDATE" Type="DateTime" Precision="0" />
  1324. <Property Name="REMARK" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
  1325. <NavigationProperty Name="SYS_MODULE" Relationship="wk_dbModel.FK_SYS_MODULE_SYSTEMID" FromRole="SYS_SYSTEM" ToRole="SYS_MODULE" />
  1326. </EntityType>
  1327. <EntityType Name="SYS_USER">
  1328. <Key>
  1329. <PropertyRef Name="ID" />
  1330. </Key>
  1331. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1332. <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1333. <Property Name="ACCOUNT" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
  1334. <Property Name="PASSWORD" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1335. <Property Name="PHONE" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1336. <Property Name="ISCANLOGIN" Type="Boolean" />
  1337. <Property Name="SHOWORDER1" Type="Int32" />
  1338. <Property Name="SHOWORDER2" Type="Int32" />
  1339. <Property Name="VERIFICATION" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
  1340. <Property Name="EXPIRYDATE" Type="DateTime" Precision="3" />
  1341. <Property Name="PINYIN1" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1342. <Property Name="PINYIN2" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1343. <Property Name="FACE_IMG" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1344. <Property Name="LEVELS" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1345. <Property Name="DPTID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1346. <Property Name="WORKNUMBER" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1347. <Property Name="USERTYPE" Type="Int32" />
  1348. <Property Name="ISDEL" Type="Boolean" />
  1349. <Property Name="LANG" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
  1350. <Property Name="CREATEPER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1351. <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
  1352. <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1353. <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
  1354. <NavigationProperty Name="SYS_POST_USER" Relationship="wk_dbModel.FK_SYS_POST_USER_USERID" FromRole="SYS_USER" ToRole="SYS_POST_USER" />
  1355. <NavigationProperty Name="SYS_USER_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_USER_DEPARTMENT_USERID" FromRole="SYS_USER" ToRole="SYS_USER_DEPARTMENT" />
  1356. <NavigationProperty Name="SYS_USER_PERMISSION" Relationship="wk_dbModel.FK_SYS_USER_PERMISSION_USERID" FromRole="SYS_USER" ToRole="SYS_USER_PERMISSION" />
  1357. <NavigationProperty Name="SYS_USER_ROLE" Relationship="wk_dbModel.FK_SYS_USER_ROLE_USERID" FromRole="SYS_USER" ToRole="SYS_USER_ROLE" />
  1358. <NavigationProperty Name="SYS_USERINFO" Relationship="wk_dbModel.FK_SYS_USERINFO_SYSUSERID" FromRole="SYS_USER" ToRole="SYS_USERINFO" />
  1359. <Property Name="Location" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1360. </EntityType>
  1361. <EntityType Name="SYS_USER_DEPARTMENT">
  1362. <Key>
  1363. <PropertyRef Name="ID" />
  1364. </Key>
  1365. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1366. <Property Name="USER_ID" Type="Int32" Nullable="false" />
  1367. <Property Name="DEPARTMENT_ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1368. <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_USER_DEPARTMENT_USERID" FromRole="SYS_USER_DEPARTMENT" ToRole="SYS_USER" />
  1369. <NavigationProperty Name="SYS_DISTRIBUTORS" Relationship="wk_dbModel.FK_SYS_USER_DEPARTMENT_DPTID" FromRole="SYS_USER_DEPARTMENT" ToRole="SYS_DISTRIBUTORS" />
  1370. </EntityType>
  1371. <EntityType Name="SYS_USER_PERMISSION">
  1372. <Key>
  1373. <PropertyRef Name="ID" />
  1374. </Key>
  1375. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1376. <Property Name="FK_USERID" Type="Int32" Nullable="false" />
  1377. <Property Name="FK_PERMISSIONID" Type="Int32" Nullable="false" />
  1378. <NavigationProperty Name="SYS_PERMISSION" Relationship="wk_dbModel.FK_SYS_USER_PERMISSION_PERID" FromRole="SYS_USER_PERMISSION" ToRole="SYS_PERMISSION" />
  1379. <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_USER_PERMISSION_USERID" FromRole="SYS_USER_PERMISSION" ToRole="SYS_USER" />
  1380. </EntityType>
  1381. <EntityType Name="SYS_USER_ROLE">
  1382. <Key>
  1383. <PropertyRef Name="ID" />
  1384. </Key>
  1385. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1386. <Property Name="FK_USERID" Type="Int32" Nullable="false" />
  1387. <Property Name="FK_ROLEID" Type="Int32" Nullable="false" />
  1388. <NavigationProperty Name="SYS_ROLE" Relationship="wk_dbModel.FK_SYS_USER_ROLE_ROLEID" FromRole="SYS_USER_ROLE" ToRole="SYS_ROLE" />
  1389. <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_USER_ROLE_USERID" FromRole="SYS_USER_ROLE" ToRole="SYS_USER" />
  1390. </EntityType>
  1391. <EntityType Name="SYS_USERINFO">
  1392. <Key>
  1393. <PropertyRef Name="ID" />
  1394. </Key>
  1395. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1396. <Property Name="USERID" Type="Int32" Nullable="false" />
  1397. <Property Name="POSTCODE" Type="Int32" />
  1398. <Property Name="PHONE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1399. <Property Name="OFFICEPHONE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1400. <Property Name="EMAILADDRESS" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1401. <Property Name="SECONDPHONE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1402. <Property Name="WORKCODE" Type="Int32" />
  1403. <Property Name="SEXCODE" Type="Int32" />
  1404. <Property Name="BIRTHDAY" Type="DateTime" Precision="3" />
  1405. <Property Name="NATIONCODE" Type="Int32" />
  1406. <Property Name="IDNUMBER" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
  1407. <Property Name="MARRYCODE" Type="Int32" />
  1408. <Property Name="IDENTITYCODE" Type="Int32" />
  1409. <Property Name="HomeTown" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1410. <Property Name="ACCOUNTLOCATION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1411. <Property Name="XUELI" Type="Int32" />
  1412. <Property Name="ZHICHENG" Type="Int32" />
  1413. <Property Name="GRADUATIONSCHOOL" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1414. <Property Name="SPECIALTY" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1415. <Property Name="PHOTOOLDNAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1416. <Property Name="PHOTONEWNAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1417. <Property Name="PHOTOTYPE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1418. <Property Name="RESUMEOLDNAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1419. <Property Name="RESUMENEWNAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1420. <Property Name="RESUMETYPE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1421. <Property Name="HuJiSuoZaiDi" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1422. <Property Name="HUJIPAICHUSUO" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1423. <Property Name="WORKDATE" Type="DateTime" Precision="3" />
  1424. <Property Name="JINRUDATE" Type="DateTime" Precision="3" />
  1425. <Property Name="CARNUMBER" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1426. <Property Name="QQ" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
  1427. <Property Name="WEBCHATOPENID" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1428. <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
  1429. <Property Name="CREATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1430. <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
  1431. <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1432. <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_USERINFO_SYSUSERID" FromRole="SYS_USERINFO" ToRole="SYS_USER" />
  1433. </EntityType>
  1434. <EntityType Name="SYS_WEBCHAT">
  1435. <Key>
  1436. <PropertyRef Name="ID" />
  1437. </Key>
  1438. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1439. <Property Name="OPENID" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1440. <Property Name="SMSCODE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1441. <Property Name="CREATETIME" Type="DateTime" Precision="0" />
  1442. <Property Name="SENDTIME" Type="DateTime" Precision="0" />
  1443. <Property Name="TELPHONE" Type="String" MaxLength="11" FixedLength="false" Unicode="true" />
  1444. </EntityType>
  1445. <EntityType Name="YW_Bicycle">
  1446. <Key>
  1447. <PropertyRef Name="ID" />
  1448. </Key>
  1449. <Property Name="ID" Type="Guid" Nullable="false" />
  1450. <Property Name="UserId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1451. <Property Name="DistributorsID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1452. <Property Name="DistributorsName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1453. <Property Name="CarID" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
  1454. <Property Name="CarModel" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
  1455. <Property Name="CarNumber" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
  1456. <Property Name="carBar" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1457. <Property Name="CarName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1458. <Property Name="productionDate" Type="DateTime" Precision="3" />
  1459. <Property Name="LeaseStatus" Type="Int32" />
  1460. <Property Name="CarSate" Type="Int32" />
  1461. <Property Name="lang" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
  1462. <Property Name="carType" Type="Int32" />
  1463. <Property Name="Createper" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1464. <Property Name="CreateDate" Type="DateTime" Precision="3" />
  1465. <Property Name="UpdateUser" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1466. <Property Name="UpdateDate" Type="DateTime" Precision="3" />
  1467. <Property Name="LockState" Type="Boolean" />
  1468. <Property Name="OutDate" Type="DateTime" Precision="3" />
  1469. <Property Name="InputDate" Type="DateTime" Precision="3" />
  1470. <Property Name="SaleDate" Type="DateTime" Precision="3" />
  1471. <Property Name="IMSI" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1472. <Property Name="ICCID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1473. <Property Name="SalesId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1474. <Property Name="WarehouseID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1475. <Property Name="WarehouseName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1476. <Property Name="FenceState" Type="Int32" />
  1477. <Property Name="CustomerCode" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1478. <Property Name="CustomerName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1479. <Property Name="FactoryNumber" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1480. <Property Name="ProductLine" Type="Int32" />
  1481. <Property Name="smallClass" Type="Int32" />
  1482. <Property Name="OutFenceDate" Type="DateTime" Precision="3" />
  1483. <Property Name="InFenceDate" Type="DateTime" Precision="3" />
  1484. <Property Name="IsLockable" Type="Boolean" />
  1485. </EntityType>
  1486. <EntityType Name="YW_CarParamDetails">
  1487. <Key>
  1488. <PropertyRef Name="ID" />
  1489. </Key>
  1490. <Property Name="ID" Type="Guid" Nullable="false" />
  1491. <Property Name="imei" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1492. <Property Name="hydraulic" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1493. <Property Name="temperature" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1494. <Property Name="voltage" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1495. <Property Name="speed" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1496. <Property Name="timestamp" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1497. <Property Name="cartype" Type="Int32" />
  1498. <Property Name="add_time" Type="DateTime" Precision="3" />
  1499. </EntityType>
  1500. <EntityType Name="YW_CarPurchaser">
  1501. <Key>
  1502. <PropertyRef Name="ID" />
  1503. </Key>
  1504. <Property Name="ID" Type="Guid" Nullable="false" />
  1505. <Property Name="carId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1506. <Property Name="carBar" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1507. <Property Name="imei" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1508. <Property Name="userName" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1509. <Property Name="userTel" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1510. <Property Name="userAddress" Type="String" MaxLength="150" FixedLength="false" Unicode="true" />
  1511. <Property Name="userCode" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1512. <Property Name="addDate" Type="DateTime" Precision="3" />
  1513. <Property Name="addName" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1514. <Property Name="updateDate" Type="DateTime" Precision="3" />
  1515. <Property Name="updateName" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1516. <Property Name="distributorsID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1517. <Property Name="SaleDate" Type="DateTime" Precision="3" />
  1518. </EntityType>
  1519. <EntityType Name="YW_Notice">
  1520. <Key>
  1521. <PropertyRef Name="ID" />
  1522. </Key>
  1523. <Property Name="ID" Type="Guid" Nullable="false" />
  1524. <Property Name="Title" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1525. <Property Name="Content" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
  1526. <Property Name="RoleId" Type="Int32" />
  1527. <Property Name="Noticetype" Type="Int32" />
  1528. <Property Name="IsRead" Type="Boolean" />
  1529. <Property Name="IsDel" Type="Boolean" />
  1530. <Property Name="createper" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1531. <Property Name="createDate" Type="DateTime" Precision="3" />
  1532. <Property Name="updateUser" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1533. <Property Name="updateDate" Type="DateTime" Precision="3" />
  1534. <Property Name="ImgUrl" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1535. </EntityType>
  1536. <EntityType Name="YW_User_Notice">
  1537. <Key>
  1538. <PropertyRef Name="ID" />
  1539. </Key>
  1540. <Property Name="ID" Type="Guid" Nullable="false" />
  1541. <Property Name="userID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
  1542. <Property Name="noticeID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
  1543. </EntityType>
  1544. <EntityType Name="YW_UserCar">
  1545. <Key>
  1546. <PropertyRef Name="ID" />
  1547. </Key>
  1548. <Property Name="ID" Type="Guid" Nullable="false" />
  1549. <Property Name="userId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1550. <Property Name="carId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1551. <Property Name="note" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1552. <Property Name="add_time" Type="DateTime" Precision="3" />
  1553. <Property Name="add_name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1554. <Property Name="update_time" Type="DateTime" Precision="3" />
  1555. <Property Name="update_name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1556. <Property Name="userTel" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1557. <Property Name="userName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  1558. <Property Name="userIdentity" Type="Int32" />
  1559. </EntityType>
  1560. <EntityType Name="YW_UserDistributor">
  1561. <Key>
  1562. <PropertyRef Name="ID" />
  1563. </Key>
  1564. <Property Name="ID" Type="Guid" Nullable="false" />
  1565. <Property Name="userId" Type="Int32" />
  1566. <Property Name="distributorId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1567. <Property Name="add_name" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1568. <Property Name="add_time" Type="DateTime" Precision="3" />
  1569. <Property Name="ProductLine" Type="Int32" />
  1570. <Property Name="ProductLine1" Type="Int32" />
  1571. <Property Name="ProductLine2" Type="Int32" />
  1572. <Property Name="ProductLine3" Type="Int32" />
  1573. <Property Name="ProductLine4" Type="Int32" />
  1574. <Property Name="ProductLine5" Type="Int32" />
  1575. <Property Name="distype" Type="Int32" />
  1576. </EntityType>
  1577. <EntityType Name="YW_UserToken">
  1578. <Key>
  1579. <PropertyRef Name="ID" />
  1580. </Key>
  1581. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  1582. <Property Name="UserType" Type="Int32" />
  1583. <Property Name="UserToken" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1584. <Property Name="UID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1585. <Property Name="AddTime" Type="DateTime" Precision="3" />
  1586. </EntityType>
  1587. <EntityType Name="SYS_ONLINE">
  1588. <Key>
  1589. <PropertyRef Name="ID" />
  1590. </Key>
  1591. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1592. <Property Name="LOGINTIME" Type="DateTime" Precision="0" />
  1593. <Property Name="TIMEOUTTIME" Type="Decimal" Precision="38" Scale="0" />
  1594. <Property Name="COOKIEID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1595. <Property Name="ACCOUNT" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1596. <Property Name="LASTACCESSTIME" Type="DateTime" Precision="0" />
  1597. <Property Name="STATE" Type="Decimal" Precision="38" Scale="0" />
  1598. <Property Name="USERID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1599. <Property Name="NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1600. </EntityType>
  1601. <Association Name="FK_SYS_MODULE_SYSTEMID">
  1602. <End Type="wk_dbModel.SYS_SYSTEM" Role="SYS_SYSTEM" Multiplicity="1" />
  1603. <End Type="wk_dbModel.SYS_MODULE" Role="SYS_MODULE" Multiplicity="*" />
  1604. <ReferentialConstraint>
  1605. <Principal Role="SYS_SYSTEM">
  1606. <PropertyRef Name="ID" />
  1607. </Principal>
  1608. <Dependent Role="SYS_MODULE">
  1609. <PropertyRef Name="FK_BELONGSYSTEM" />
  1610. </Dependent>
  1611. </ReferentialConstraint>
  1612. </Association>
  1613. <Association Name="FK_SYS_PERMISSION_MODULEID">
  1614. <End Type="wk_dbModel.SYS_MODULE" Role="SYS_MODULE" Multiplicity="1" />
  1615. <End Type="wk_dbModel.SYS_PERMISSION" Role="SYS_PERMISSION" Multiplicity="*" />
  1616. <ReferentialConstraint>
  1617. <Principal Role="SYS_MODULE">
  1618. <PropertyRef Name="ID" />
  1619. </Principal>
  1620. <Dependent Role="SYS_PERMISSION">
  1621. <PropertyRef Name="MODULEID" />
  1622. </Dependent>
  1623. </ReferentialConstraint>
  1624. </Association>
  1625. <Association Name="FK_SYS_ROLE_PERMISSION_PERID">
  1626. <End Type="wk_dbModel.SYS_PERMISSION" Role="SYS_PERMISSION" Multiplicity="1" />
  1627. <End Type="wk_dbModel.SYS_ROLE_PERMISSION" Role="SYS_ROLE_PERMISSION" Multiplicity="*" />
  1628. <ReferentialConstraint>
  1629. <Principal Role="SYS_PERMISSION">
  1630. <PropertyRef Name="ID" />
  1631. </Principal>
  1632. <Dependent Role="SYS_ROLE_PERMISSION">
  1633. <PropertyRef Name="PERMISSIONID" />
  1634. </Dependent>
  1635. </ReferentialConstraint>
  1636. </Association>
  1637. <Association Name="FK_SYS_USER_PERMISSION_PERID">
  1638. <End Type="wk_dbModel.SYS_PERMISSION" Role="SYS_PERMISSION" Multiplicity="1" />
  1639. <End Type="wk_dbModel.SYS_USER_PERMISSION" Role="SYS_USER_PERMISSION" Multiplicity="*" />
  1640. <ReferentialConstraint>
  1641. <Principal Role="SYS_PERMISSION">
  1642. <PropertyRef Name="ID" />
  1643. </Principal>
  1644. <Dependent Role="SYS_USER_PERMISSION">
  1645. <PropertyRef Name="FK_PERMISSIONID" />
  1646. </Dependent>
  1647. </ReferentialConstraint>
  1648. </Association>
  1649. <Association Name="FK_SYS_POST_DEPARTMENT_POSTID">
  1650. <End Type="wk_dbModel.SYS_POST" Role="SYS_POST" Multiplicity="1" />
  1651. <End Type="wk_dbModel.SYS_POST_DEPARTMENT" Role="SYS_POST_DEPARTMENT" Multiplicity="*" />
  1652. <ReferentialConstraint>
  1653. <Principal Role="SYS_POST">
  1654. <PropertyRef Name="ID" />
  1655. </Principal>
  1656. <Dependent Role="SYS_POST_DEPARTMENT">
  1657. <PropertyRef Name="FK_POST_ID" />
  1658. </Dependent>
  1659. </ReferentialConstraint>
  1660. </Association>
  1661. <Association Name="FK_SYS_POST_USER_POSTDPTID">
  1662. <End Type="wk_dbModel.SYS_POST_DEPARTMENT" Role="SYS_POST_DEPARTMENT" Multiplicity="1" />
  1663. <End Type="wk_dbModel.SYS_POST_USER" Role="SYS_POST_USER" Multiplicity="*" />
  1664. <ReferentialConstraint>
  1665. <Principal Role="SYS_POST_DEPARTMENT">
  1666. <PropertyRef Name="ID" />
  1667. </Principal>
  1668. <Dependent Role="SYS_POST_USER">
  1669. <PropertyRef Name="FK_POST_DEPARTMENTID" />
  1670. </Dependent>
  1671. </ReferentialConstraint>
  1672. </Association>
  1673. <Association Name="FK_SYS_POST_USER_USERID">
  1674. <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
  1675. <End Type="wk_dbModel.SYS_POST_USER" Role="SYS_POST_USER" Multiplicity="*" />
  1676. <ReferentialConstraint>
  1677. <Principal Role="SYS_USER">
  1678. <PropertyRef Name="ID" />
  1679. </Principal>
  1680. <Dependent Role="SYS_POST_USER">
  1681. <PropertyRef Name="FK_USERID" />
  1682. </Dependent>
  1683. </ReferentialConstraint>
  1684. </Association>
  1685. <Association Name="FK_SYS_ROLE_PERMISSION_ROLEID">
  1686. <End Type="wk_dbModel.SYS_ROLE" Role="SYS_ROLE" Multiplicity="1" />
  1687. <End Type="wk_dbModel.SYS_ROLE_PERMISSION" Role="SYS_ROLE_PERMISSION" Multiplicity="*" />
  1688. <ReferentialConstraint>
  1689. <Principal Role="SYS_ROLE">
  1690. <PropertyRef Name="ID" />
  1691. </Principal>
  1692. <Dependent Role="SYS_ROLE_PERMISSION">
  1693. <PropertyRef Name="ROLEID" />
  1694. </Dependent>
  1695. </ReferentialConstraint>
  1696. </Association>
  1697. <Association Name="FK_SYS_USER_ROLE_ROLEID">
  1698. <End Type="wk_dbModel.SYS_ROLE" Role="SYS_ROLE" Multiplicity="1" />
  1699. <End Type="wk_dbModel.SYS_USER_ROLE" Role="SYS_USER_ROLE" Multiplicity="*" />
  1700. <ReferentialConstraint>
  1701. <Principal Role="SYS_ROLE">
  1702. <PropertyRef Name="ID" />
  1703. </Principal>
  1704. <Dependent Role="SYS_USER_ROLE">
  1705. <PropertyRef Name="FK_ROLEID" />
  1706. </Dependent>
  1707. </ReferentialConstraint>
  1708. </Association>
  1709. <Association Name="FK_SYS_USER_DEPARTMENT_USERID">
  1710. <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
  1711. <End Type="wk_dbModel.SYS_USER_DEPARTMENT" Role="SYS_USER_DEPARTMENT" Multiplicity="*" />
  1712. <ReferentialConstraint>
  1713. <Principal Role="SYS_USER">
  1714. <PropertyRef Name="ID" />
  1715. </Principal>
  1716. <Dependent Role="SYS_USER_DEPARTMENT">
  1717. <PropertyRef Name="USER_ID" />
  1718. </Dependent>
  1719. </ReferentialConstraint>
  1720. </Association>
  1721. <Association Name="FK_SYS_USER_PERMISSION_USERID">
  1722. <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
  1723. <End Type="wk_dbModel.SYS_USER_PERMISSION" Role="SYS_USER_PERMISSION" Multiplicity="*" />
  1724. <ReferentialConstraint>
  1725. <Principal Role="SYS_USER">
  1726. <PropertyRef Name="ID" />
  1727. </Principal>
  1728. <Dependent Role="SYS_USER_PERMISSION">
  1729. <PropertyRef Name="FK_USERID" />
  1730. </Dependent>
  1731. </ReferentialConstraint>
  1732. </Association>
  1733. <Association Name="FK_SYS_USER_ROLE_USERID">
  1734. <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
  1735. <End Type="wk_dbModel.SYS_USER_ROLE" Role="SYS_USER_ROLE" Multiplicity="*" />
  1736. <ReferentialConstraint>
  1737. <Principal Role="SYS_USER">
  1738. <PropertyRef Name="ID" />
  1739. </Principal>
  1740. <Dependent Role="SYS_USER_ROLE">
  1741. <PropertyRef Name="FK_USERID" />
  1742. </Dependent>
  1743. </ReferentialConstraint>
  1744. </Association>
  1745. <Association Name="FK_SYS_USERINFO_SYSUSERID">
  1746. <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
  1747. <End Type="wk_dbModel.SYS_USERINFO" Role="SYS_USERINFO" Multiplicity="*" />
  1748. <ReferentialConstraint>
  1749. <Principal Role="SYS_USER">
  1750. <PropertyRef Name="ID" />
  1751. </Principal>
  1752. <Dependent Role="SYS_USERINFO">
  1753. <PropertyRef Name="USERID" />
  1754. </Dependent>
  1755. </ReferentialConstraint>
  1756. </Association>
  1757. <EntityType Name="SYS_DISTRIBUTORS">
  1758. <Key>
  1759. <PropertyRef Name="ID" />
  1760. </Key>
  1761. <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
  1762. <Property Name="CODE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1763. <Property Name="NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1764. <Property Name="BUSINESSLEVEL" Type="Int32" />
  1765. <Property Name="SHOWORDER" Type="Int32" />
  1766. <Property Name="Address" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1767. <Property Name="PARENTCODE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1768. <Property Name="ParentName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1769. <Property Name="LICENSEURL" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
  1770. <Property Name="LICENSEVALUE" Type="String" MaxLength="4000" FixedLength="false" Unicode="true" />
  1771. <Property Name="PARENTID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1772. <Property Name="ProvinceCity" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
  1773. <Property Name="Province" Type="Int32" />
  1774. <Property Name="City" Type="Int32" />
  1775. <Property Name="Area" Type="Int32" />
  1776. <Property Name="CREATEPERID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1777. <Property Name="CREATEDATE" Type="DateTime" Precision="0" />
  1778. <Property Name="UPDATEDATE" Type="DateTime" Precision="0" />
  1779. <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1780. <Property Name="FenceID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
  1781. <Property Name="FenceRadius" Type="Int32" />
  1782. <Property Name="Theodolite" Type="String" MaxLength="80" FixedLength="false" Unicode="true" />
  1783. <NavigationProperty Name="SYS_POST_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_POST_DEPARTMENT_DPTID" FromRole="SYS_DISTRIBUTORS" ToRole="SYS_POST_DEPARTMENT" />
  1784. <NavigationProperty Name="SYS_USER_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_USER_DEPARTMENT_DPTID" FromRole="SYS_DISTRIBUTORS" ToRole="SYS_USER_DEPARTMENT" />
  1785. <Property Name="DealerNumber" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
  1786. <Property Name="SaleType" Type="Int32" />
  1787. <Property Name="SaleCar" Type="String" MaxLength="400" FixedLength="false" Unicode="true" />
  1788. <Property Name="Notes" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
  1789. </EntityType>
  1790. <Association Name="FK_SYS_POST_DEPARTMENT_DPTID">
  1791. <End Type="wk_dbModel.SYS_DISTRIBUTORS" Role="SYS_DISTRIBUTORS" Multiplicity="1" />
  1792. <End Type="wk_dbModel.SYS_POST_DEPARTMENT" Role="SYS_POST_DEPARTMENT" Multiplicity="*" />
  1793. <ReferentialConstraint>
  1794. <Principal Role="SYS_DISTRIBUTORS">
  1795. <PropertyRef Name="ID" />
  1796. </Principal>
  1797. <Dependent Role="SYS_POST_DEPARTMENT">
  1798. <PropertyRef Name="FK_DEPARTMENT_ID" />
  1799. </Dependent>
  1800. </ReferentialConstraint>
  1801. </Association>
  1802. <Association Name="FK_SYS_USER_DEPARTMENT_DPTID">
  1803. <End Type="wk_dbModel.SYS_DISTRIBUTORS" Role="SYS_DISTRIBUTORS" Multiplicity="1" />
  1804. <End Type="wk_dbModel.SYS_USER_DEPARTMENT" Role="SYS_USER_DEPARTMENT" Multiplicity="*" />
  1805. <ReferentialConstraint>
  1806. <Principal Role="SYS_DISTRIBUTORS">
  1807. <PropertyRef Name="ID" />
  1808. </Principal>
  1809. <Dependent Role="SYS_USER_DEPARTMENT">
  1810. <PropertyRef Name="DEPARTMENT_ID" />
  1811. </Dependent>
  1812. </ReferentialConstraint>
  1813. </Association>
  1814. </Schema>
  1815. </edmx:ConceptualModels>
  1816. <!-- C-S mapping content -->
  1817. <edmx:Mappings>
  1818. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  1819. <EntityContainerMapping StorageEntityContainer="wk_dbModelStoreContainer" CdmEntityContainer="Entities">
  1820. <FunctionImportMapping FunctionImportName="PaginationByRowNumber" FunctionName="wk_dbModel.Store.PaginationByRowNumber" />
  1821. <EntitySetMapping Name="COM_CONTENT">
  1822. <EntityTypeMapping TypeName="wk_dbModel.COM_CONTENT">
  1823. <MappingFragment StoreEntitySet="COM_CONTENT">
  1824. <ScalarProperty Name="ISDEL" ColumnName="ISDEL" />
  1825. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  1826. <ScalarProperty Name="FK_TABLE" ColumnName="FK_TABLE" />
  1827. <ScalarProperty Name="CONTENTBLOB" ColumnName="CONTENTBLOB" />
  1828. <ScalarProperty Name="CONTENT" ColumnName="CONTENT" />
  1829. <ScalarProperty Name="FK_RELATIONID" ColumnName="FK_RELATIONID" />
  1830. <ScalarProperty Name="ID" ColumnName="ID" />
  1831. </MappingFragment>
  1832. </EntityTypeMapping>
  1833. </EntitySetMapping>
  1834. <EntitySetMapping Name="COM_CUSCONTACT">
  1835. <EntityTypeMapping TypeName="wk_dbModel.COM_CUSCONTACT">
  1836. <MappingFragment StoreEntitySet="COM_CUSCONTACT">
  1837. <ScalarProperty Name="FK_TYPE" ColumnName="FK_TYPE" />
  1838. <ScalarProperty Name="CREATETIME" ColumnName="CREATETIME" />
  1839. <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
  1840. <ScalarProperty Name="REMARK" ColumnName="REMARK" />
  1841. <ScalarProperty Name="CITY" ColumnName="CITY" />
  1842. <ScalarProperty Name="PROV" ColumnName="PROV" />
  1843. <ScalarProperty Name="ADDRESS" ColumnName="ADDRESS" />
  1844. <ScalarProperty Name="ZW" ColumnName="ZW" />
  1845. <ScalarProperty Name="COMPADDRESS" ColumnName="COMPADDRESS" />
  1846. <ScalarProperty Name="COMPANY" ColumnName="COMPANY" />
  1847. <ScalarProperty Name="WX" ColumnName="WX" />
  1848. <ScalarProperty Name="EMAIL" ColumnName="EMAIL" />
  1849. <ScalarProperty Name="QQ" ColumnName="QQ" />
  1850. <ScalarProperty Name="SECONDPHONE" ColumnName="SECONDPHONE" />
  1851. <ScalarProperty Name="TELNO" ColumnName="TELNO" />
  1852. <ScalarProperty Name="PHOME" ColumnName="PHOME" />
  1853. <ScalarProperty Name="SEX" ColumnName="SEX" />
  1854. <ScalarProperty Name="NAME" ColumnName="NAME" />
  1855. <ScalarProperty Name="ID" ColumnName="ID" />
  1856. </MappingFragment>
  1857. </EntityTypeMapping>
  1858. </EntitySetMapping>
  1859. <EntitySetMapping Name="COM_DOWNLOAD">
  1860. <EntityTypeMapping TypeName="wk_dbModel.COM_DOWNLOAD">
  1861. <MappingFragment StoreEntitySet="COM_DOWNLOAD">
  1862. <ScalarProperty Name="DLDATE" ColumnName="DLDATE" />
  1863. <ScalarProperty Name="FK_UPID" ColumnName="FK_UPID" />
  1864. <ScalarProperty Name="DLNUM" ColumnName="DLNUM" />
  1865. <ScalarProperty Name="DLIP" ColumnName="DLIP" />
  1866. <ScalarProperty Name="DLOPERATOR" ColumnName="DLOPERATOR" />
  1867. <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
  1868. <ScalarProperty Name="ID" ColumnName="ID" />
  1869. </MappingFragment>
  1870. </EntityTypeMapping>
  1871. </EntitySetMapping>
  1872. <EntitySetMapping Name="COM_FLOWINFO">
  1873. <EntityTypeMapping TypeName="wk_dbModel.COM_FLOWINFO">
  1874. <MappingFragment StoreEntitySet="COM_FLOWINFO">
  1875. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  1876. <ScalarProperty Name="UPDATETIME" ColumnName="UPDATETIME" />
  1877. <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
  1878. <ScalarProperty Name="CREATETIME" ColumnName="CREATETIME" />
  1879. <ScalarProperty Name="REMARK" ColumnName="REMARK" />
  1880. <ScalarProperty Name="TABLENAME" ColumnName="TABLENAME" />
  1881. <ScalarProperty Name="SHOW" ColumnName="SHOW" />
  1882. <ScalarProperty Name="PATH" ColumnName="PATH" />
  1883. <ScalarProperty Name="FLOWNO" ColumnName="FLOWNO" />
  1884. <ScalarProperty Name="ID" ColumnName="ID" />
  1885. </MappingFragment>
  1886. </EntityTypeMapping>
  1887. </EntitySetMapping>
  1888. <EntitySetMapping Name="COM_INDEX">
  1889. <EntityTypeMapping TypeName="wk_dbModel.COM_INDEX">
  1890. <MappingFragment StoreEntitySet="COM_INDEX">
  1891. <ScalarProperty Name="SHOWTYPE" ColumnName="SHOWTYPE" />
  1892. <ScalarProperty Name="PATH" ColumnName="PATH" />
  1893. <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
  1894. <ScalarProperty Name="BACKGROUNDCOLOR" ColumnName="BACKGROUNDCOLOR" />
  1895. <ScalarProperty Name="COLOR" ColumnName="COLOR" />
  1896. <ScalarProperty Name="ICON" ColumnName="ICON" />
  1897. <ScalarProperty Name="TITLE" ColumnName="TITLE" />
  1898. <ScalarProperty Name="ID" ColumnName="ID" />
  1899. </MappingFragment>
  1900. </EntityTypeMapping>
  1901. </EntitySetMapping>
  1902. <EntitySetMapping Name="COM_UPLOAD">
  1903. <EntityTypeMapping TypeName="wk_dbModel.COM_UPLOAD">
  1904. <MappingFragment StoreEntitySet="COM_UPLOAD">
  1905. <ScalarProperty Name="UPFILEURL" ColumnName="UPFILEURL" />
  1906. <ScalarProperty Name="UPFILEIP" ColumnName="UPFILEIP" />
  1907. <ScalarProperty Name="UPFILETHUMBNAILFORPHONE" ColumnName="UPFILETHUMBNAILFORPHONE" />
  1908. <ScalarProperty Name="UPFILETHUMBNAILFORPAD" ColumnName="UPFILETHUMBNAILFORPAD" />
  1909. <ScalarProperty Name="UPFILETHUMBNAIL" ColumnName="UPFILETHUMBNAIL" />
  1910. <ScalarProperty Name="UPFILESUFFIX" ColumnName="UPFILESUFFIX" />
  1911. <ScalarProperty Name="UPFILEPATH" ColumnName="UPFILEPATH" />
  1912. <ScalarProperty Name="UPFILEUNIT" ColumnName="UPFILEUNIT" />
  1913. <ScalarProperty Name="UPFILESIZE" ColumnName="UPFILESIZE" />
  1914. <ScalarProperty Name="UPNEWNAME" ColumnName="UPNEWNAME" />
  1915. <ScalarProperty Name="UPOLDNAME" ColumnName="UPOLDNAME" />
  1916. <ScalarProperty Name="UPTIME" ColumnName="UPTIME" />
  1917. <ScalarProperty Name="UPOPEATOR" ColumnName="UPOPEATOR" />
  1918. <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
  1919. <ScalarProperty Name="ID" ColumnName="ID" />
  1920. </MappingFragment>
  1921. </EntityTypeMapping>
  1922. </EntitySetMapping>
  1923. <EntitySetMapping Name="SYS_BEUSER">
  1924. <EntityTypeMapping TypeName="wk_dbModel.SYS_BEUSER">
  1925. <MappingFragment StoreEntitySet="SYS_BEUSER">
  1926. <ScalarProperty Name="CREATETIME" ColumnName="CREATETIME" />
  1927. <ScalarProperty Name="TONUMBER" ColumnName="TONUMBER" />
  1928. <ScalarProperty Name="FK_TOUSER" ColumnName="FK_TOUSER" />
  1929. <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
  1930. <ScalarProperty Name="ID" ColumnName="ID" />
  1931. </MappingFragment>
  1932. </EntityTypeMapping>
  1933. </EntitySetMapping>
  1934. <EntitySetMapping Name="SYS_CODE">
  1935. <EntityTypeMapping TypeName="wk_dbModel.SYS_CODE">
  1936. <MappingFragment StoreEntitySet="SYS_CODE">
  1937. <ScalarProperty Name="PARENTID" ColumnName="PARENTID" />
  1938. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  1939. <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
  1940. <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
  1941. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  1942. <ScalarProperty Name="REMARK" ColumnName="REMARK" />
  1943. <ScalarProperty Name="ISCODE" ColumnName="ISCODE" />
  1944. <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
  1945. <ScalarProperty Name="CODEVALUE" ColumnName="CODEVALUE" />
  1946. <ScalarProperty Name="NAMETEXT" ColumnName="NAMETEXT" />
  1947. <ScalarProperty Name="CODETYPE" ColumnName="CODETYPE" />
  1948. <ScalarProperty Name="ID" ColumnName="ID" />
  1949. </MappingFragment>
  1950. </EntityTypeMapping>
  1951. </EntitySetMapping>
  1952. <EntitySetMapping Name="SYS_CODE_AREA">
  1953. <EntityTypeMapping TypeName="wk_dbModel.SYS_CODE_AREA">
  1954. <MappingFragment StoreEntitySet="SYS_CODE_AREA">
  1955. <ScalarProperty Name="LEVELS" ColumnName="LEVELS" />
  1956. <ScalarProperty Name="NAME" ColumnName="NAME" />
  1957. <ScalarProperty Name="PID" ColumnName="PID" />
  1958. <ScalarProperty Name="ID" ColumnName="ID" />
  1959. </MappingFragment>
  1960. </EntityTypeMapping>
  1961. </EntitySetMapping>
  1962. <EntitySetMapping Name="SYS_LOG">
  1963. <EntityTypeMapping TypeName="wk_dbModel.SYS_LOG">
  1964. <MappingFragment StoreEntitySet="SYS_LOG">
  1965. <ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" />
  1966. <ScalarProperty Name="MESSAGE" ColumnName="MESSAGE" />
  1967. <ScalarProperty Name="ACTION" ColumnName="ACTION" />
  1968. <ScalarProperty Name="REQUESTURL" ColumnName="REQUESTURL" />
  1969. <ScalarProperty Name="CLIENTIP" ColumnName="CLIENTIP" />
  1970. <ScalarProperty Name="CLIENTUSER" ColumnName="CLIENTUSER" />
  1971. <ScalarProperty Name="LOGGER" ColumnName="LOGGER" />
  1972. <ScalarProperty Name="LEVELS" ColumnName="LEVELS" />
  1973. <ScalarProperty Name="DATES" ColumnName="DATES" />
  1974. <ScalarProperty Name="ID" ColumnName="ID" />
  1975. </MappingFragment>
  1976. </EntityTypeMapping>
  1977. </EntitySetMapping>
  1978. <EntitySetMapping Name="SYS_MODULE">
  1979. <EntityTypeMapping TypeName="wk_dbModel.SYS_MODULE">
  1980. <MappingFragment StoreEntitySet="SYS_MODULE">
  1981. <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
  1982. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  1983. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  1984. <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
  1985. <ScalarProperty Name="LEVELS" ColumnName="LEVELS" />
  1986. <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
  1987. <ScalarProperty Name="ISSHOW" ColumnName="ISSHOW" />
  1988. <ScalarProperty Name="MODULEPATH" ColumnName="MODULEPATH" />
  1989. <ScalarProperty Name="ICON" ColumnName="ICON" />
  1990. <ScalarProperty Name="MODULETYPE" ColumnName="MODULETYPE" />
  1991. <ScalarProperty Name="ALIAS" ColumnName="ALIAS" />
  1992. <ScalarProperty Name="NAME" ColumnName="NAME" />
  1993. <ScalarProperty Name="PARENTID" ColumnName="PARENTID" />
  1994. <ScalarProperty Name="FK_BELONGSYSTEM" ColumnName="FK_BELONGSYSTEM" />
  1995. <ScalarProperty Name="ID" ColumnName="ID" />
  1996. </MappingFragment>
  1997. </EntityTypeMapping>
  1998. </EntitySetMapping>
  1999. <EntitySetMapping Name="SYS_MSG">
  2000. <EntityTypeMapping TypeName="wk_dbModel.SYS_MSG">
  2001. <MappingFragment StoreEntitySet="SYS_MSG">
  2002. <ScalarProperty Name="MSGCONTENT" ColumnName="MSGCONTENT" />
  2003. <ScalarProperty Name="DELETESTATUS" ColumnName="DELETESTATUS" />
  2004. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2005. <ScalarProperty Name="CREATEPER" ColumnName="CREATEPER" />
  2006. <ScalarProperty Name="MSGTYPE" ColumnName="MSGTYPE" />
  2007. <ScalarProperty Name="MSGNAME" ColumnName="MSGNAME" />
  2008. <ScalarProperty Name="ID" ColumnName="ID" />
  2009. </MappingFragment>
  2010. </EntityTypeMapping>
  2011. </EntitySetMapping>
  2012. <EntitySetMapping Name="SYS_MSGATTACH">
  2013. <EntityTypeMapping TypeName="wk_dbModel.SYS_MSGATTACH">
  2014. <MappingFragment StoreEntitySet="SYS_MSGATTACH">
  2015. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2016. <ScalarProperty Name="FK_UPLOADID" ColumnName="FK_UPLOADID" />
  2017. <ScalarProperty Name="MSGID" ColumnName="MSGID" />
  2018. <ScalarProperty Name="ID" ColumnName="ID" />
  2019. </MappingFragment>
  2020. </EntityTypeMapping>
  2021. </EntitySetMapping>
  2022. <EntitySetMapping Name="SYS_MSGREV">
  2023. <EntityTypeMapping TypeName="wk_dbModel.SYS_MSGREV">
  2024. <MappingFragment StoreEntitySet="SYS_MSGREV">
  2025. <ScalarProperty Name="DELETESTATUS" ColumnName="DELETESTATUS" />
  2026. <ScalarProperty Name="READSTATUS" ColumnName="READSTATUS" />
  2027. <ScalarProperty Name="USERID" ColumnName="USERID" />
  2028. <ScalarProperty Name="MSGID" ColumnName="MSGID" />
  2029. <ScalarProperty Name="ID" ColumnName="ID" />
  2030. </MappingFragment>
  2031. </EntityTypeMapping>
  2032. </EntitySetMapping>
  2033. <EntitySetMapping Name="SYS_PERMISSION">
  2034. <EntityTypeMapping TypeName="wk_dbModel.SYS_PERMISSION">
  2035. <MappingFragment StoreEntitySet="SYS_PERMISSION">
  2036. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  2037. <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
  2038. <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
  2039. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2040. <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
  2041. <ScalarProperty Name="ICON" ColumnName="ICON" />
  2042. <ScalarProperty Name="PERVALUE" ColumnName="PERVALUE" />
  2043. <ScalarProperty Name="NAME" ColumnName="NAME" />
  2044. <ScalarProperty Name="MODULEID" ColumnName="MODULEID" />
  2045. <ScalarProperty Name="ID" ColumnName="ID" />
  2046. </MappingFragment>
  2047. </EntityTypeMapping>
  2048. </EntitySetMapping>
  2049. <EntitySetMapping Name="SYS_POST">
  2050. <EntityTypeMapping TypeName="wk_dbModel.SYS_POST">
  2051. <MappingFragment StoreEntitySet="SYS_POST">
  2052. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  2053. <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
  2054. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2055. <ScalarProperty Name="CREATEUSERID" ColumnName="CREATEUSERID" />
  2056. <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
  2057. <ScalarProperty Name="REMARK" ColumnName="REMARK" />
  2058. <ScalarProperty Name="POSTTYPE" ColumnName="POSTTYPE" />
  2059. <ScalarProperty Name="POSTNAME" ColumnName="POSTNAME" />
  2060. <ScalarProperty Name="ID" ColumnName="ID" />
  2061. </MappingFragment>
  2062. </EntityTypeMapping>
  2063. </EntitySetMapping>
  2064. <EntitySetMapping Name="SYS_POST_DEPARTMENT">
  2065. <EntityTypeMapping TypeName="wk_dbModel.SYS_POST_DEPARTMENT">
  2066. <MappingFragment StoreEntitySet="SYS_POST_DEPARTMENT">
  2067. <ScalarProperty Name="FK_POST_ID" ColumnName="FK_POST_ID" />
  2068. <ScalarProperty Name="FK_DEPARTMENT_ID" ColumnName="FK_DEPARTMENT_ID" />
  2069. <ScalarProperty Name="ID" ColumnName="ID" />
  2070. </MappingFragment>
  2071. </EntityTypeMapping>
  2072. </EntitySetMapping>
  2073. <EntitySetMapping Name="SYS_POST_USER">
  2074. <EntityTypeMapping TypeName="wk_dbModel.SYS_POST_USER">
  2075. <MappingFragment StoreEntitySet="SYS_POST_USER">
  2076. <ScalarProperty Name="FK_POST_DEPARTMENTID" ColumnName="FK_POST_DEPARTMENTID" />
  2077. <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
  2078. <ScalarProperty Name="ID" ColumnName="ID" />
  2079. </MappingFragment>
  2080. </EntityTypeMapping>
  2081. </EntitySetMapping>
  2082. <EntitySetMapping Name="SYS_ROLE">
  2083. <EntityTypeMapping TypeName="wk_dbModel.SYS_ROLE">
  2084. <MappingFragment StoreEntitySet="SYS_ROLE">
  2085. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  2086. <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
  2087. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2088. <ScalarProperty Name="CREATEPERID" ColumnName="CREATEPERID" />
  2089. <ScalarProperty Name="ROLEDESC" ColumnName="ROLEDESC" />
  2090. <ScalarProperty Name="ISCUSTOM" ColumnName="ISCUSTOM" />
  2091. <ScalarProperty Name="ROLENAME" ColumnName="ROLENAME" />
  2092. <ScalarProperty Name="ID" ColumnName="ID" />
  2093. </MappingFragment>
  2094. </EntityTypeMapping>
  2095. </EntitySetMapping>
  2096. <EntitySetMapping Name="SYS_ROLE_PERMISSION">
  2097. <EntityTypeMapping TypeName="wk_dbModel.SYS_ROLE_PERMISSION">
  2098. <MappingFragment StoreEntitySet="SYS_ROLE_PERMISSION">
  2099. <ScalarProperty Name="PERMISSIONID" ColumnName="PERMISSIONID" />
  2100. <ScalarProperty Name="ROLEID" ColumnName="ROLEID" />
  2101. <ScalarProperty Name="ID" ColumnName="ID" />
  2102. </MappingFragment>
  2103. </EntityTypeMapping>
  2104. </EntitySetMapping>
  2105. <EntitySetMapping Name="SYS_SMS">
  2106. <EntityTypeMapping TypeName="wk_dbModel.SYS_SMS">
  2107. <MappingFragment StoreEntitySet="SYS_SMS">
  2108. <ScalarProperty Name="FLOWNO" ColumnName="FLOWNO" />
  2109. <ScalarProperty Name="WORKID" ColumnName="WORKID" />
  2110. <ScalarProperty Name="MSGFLAG" ColumnName="MSGFLAG" />
  2111. <ScalarProperty Name="ISALERT" ColumnName="ISALERT" />
  2112. <ScalarProperty Name="ISREAD" ColumnName="ISREAD" />
  2113. <ScalarProperty Name="SENDDT" ColumnName="SENDDT" />
  2114. <ScalarProperty Name="DOC" ColumnName="DOC" />
  2115. <ScalarProperty Name="TITLE" ColumnName="TITLE" />
  2116. <ScalarProperty Name="EMAISTA" ColumnName="EMAISTA" />
  2117. <ScalarProperty Name="EMAIL" ColumnName="EMAIL" />
  2118. <ScalarProperty Name="TELSTA" ColumnName="TELSTA" />
  2119. <ScalarProperty Name="TEL" ColumnName="TEL" />
  2120. <ScalarProperty Name="RDT" ColumnName="RDT" />
  2121. <ScalarProperty Name="SENDTOEMPID" ColumnName="SENDTOEMPID" />
  2122. <ScalarProperty Name="SENDER" ColumnName="SENDER" />
  2123. <ScalarProperty Name="ID" ColumnName="ID" />
  2124. </MappingFragment>
  2125. </EntityTypeMapping>
  2126. </EntitySetMapping>
  2127. <EntitySetMapping Name="SYS_SYSTEM">
  2128. <EntityTypeMapping TypeName="wk_dbModel.SYS_SYSTEM">
  2129. <MappingFragment StoreEntitySet="SYS_SYSTEM">
  2130. <ScalarProperty Name="REMARK" ColumnName="REMARK" />
  2131. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2132. <ScalarProperty Name="DOCKPASS" ColumnName="DOCKPASS" />
  2133. <ScalarProperty Name="DOCKUSER" ColumnName="DOCKUSER" />
  2134. <ScalarProperty Name="IS_LOGIN" ColumnName="IS_LOGIN" />
  2135. <ScalarProperty Name="SITEURL" ColumnName="SITEURL" />
  2136. <ScalarProperty Name="NAME" ColumnName="NAME" />
  2137. <ScalarProperty Name="ID" ColumnName="ID" />
  2138. </MappingFragment>
  2139. </EntityTypeMapping>
  2140. </EntitySetMapping>
  2141. <EntitySetMapping Name="SYS_USER">
  2142. <EntityTypeMapping TypeName="wk_dbModel.SYS_USER">
  2143. <MappingFragment StoreEntitySet="SYS_USER">
  2144. <ScalarProperty Name="Location" ColumnName="Location" />
  2145. <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
  2146. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  2147. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2148. <ScalarProperty Name="CREATEPER" ColumnName="CREATEPER" />
  2149. <ScalarProperty Name="LANG" ColumnName="LANG" />
  2150. <ScalarProperty Name="ISDEL" ColumnName="ISDEL" />
  2151. <ScalarProperty Name="USERTYPE" ColumnName="USERTYPE" />
  2152. <ScalarProperty Name="WORKNUMBER" ColumnName="WORKNUMBER" />
  2153. <ScalarProperty Name="DPTID" ColumnName="DPTID" />
  2154. <ScalarProperty Name="LEVELS" ColumnName="LEVELS" />
  2155. <ScalarProperty Name="FACE_IMG" ColumnName="FACE_IMG" />
  2156. <ScalarProperty Name="PINYIN2" ColumnName="PINYIN2" />
  2157. <ScalarProperty Name="PINYIN1" ColumnName="PINYIN1" />
  2158. <ScalarProperty Name="EXPIRYDATE" ColumnName="EXPIRYDATE" />
  2159. <ScalarProperty Name="VERIFICATION" ColumnName="VERIFICATION" />
  2160. <ScalarProperty Name="SHOWORDER2" ColumnName="SHOWORDER2" />
  2161. <ScalarProperty Name="SHOWORDER1" ColumnName="SHOWORDER1" />
  2162. <ScalarProperty Name="ISCANLOGIN" ColumnName="ISCANLOGIN" />
  2163. <ScalarProperty Name="PHONE" ColumnName="PHONE" />
  2164. <ScalarProperty Name="PASSWORD" ColumnName="PASSWORD" />
  2165. <ScalarProperty Name="ACCOUNT" ColumnName="ACCOUNT" />
  2166. <ScalarProperty Name="NAME" ColumnName="NAME" />
  2167. <ScalarProperty Name="ID" ColumnName="ID" />
  2168. </MappingFragment>
  2169. </EntityTypeMapping>
  2170. </EntitySetMapping>
  2171. <EntitySetMapping Name="SYS_USER_DEPARTMENT">
  2172. <EntityTypeMapping TypeName="wk_dbModel.SYS_USER_DEPARTMENT">
  2173. <MappingFragment StoreEntitySet="SYS_USER_DEPARTMENT">
  2174. <ScalarProperty Name="DEPARTMENT_ID" ColumnName="DEPARTMENT_ID" />
  2175. <ScalarProperty Name="USER_ID" ColumnName="USER_ID" />
  2176. <ScalarProperty Name="ID" ColumnName="ID" />
  2177. </MappingFragment>
  2178. </EntityTypeMapping>
  2179. </EntitySetMapping>
  2180. <EntitySetMapping Name="SYS_USER_PERMISSION">
  2181. <EntityTypeMapping TypeName="wk_dbModel.SYS_USER_PERMISSION">
  2182. <MappingFragment StoreEntitySet="SYS_USER_PERMISSION">
  2183. <ScalarProperty Name="FK_PERMISSIONID" ColumnName="FK_PERMISSIONID" />
  2184. <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
  2185. <ScalarProperty Name="ID" ColumnName="ID" />
  2186. </MappingFragment>
  2187. </EntityTypeMapping>
  2188. </EntitySetMapping>
  2189. <EntitySetMapping Name="SYS_USER_ROLE">
  2190. <EntityTypeMapping TypeName="wk_dbModel.SYS_USER_ROLE">
  2191. <MappingFragment StoreEntitySet="SYS_USER_ROLE">
  2192. <ScalarProperty Name="FK_ROLEID" ColumnName="FK_ROLEID" />
  2193. <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
  2194. <ScalarProperty Name="ID" ColumnName="ID" />
  2195. </MappingFragment>
  2196. </EntityTypeMapping>
  2197. </EntitySetMapping>
  2198. <EntitySetMapping Name="SYS_USERINFO">
  2199. <EntityTypeMapping TypeName="wk_dbModel.SYS_USERINFO">
  2200. <MappingFragment StoreEntitySet="SYS_USERINFO">
  2201. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  2202. <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
  2203. <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
  2204. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2205. <ScalarProperty Name="WEBCHATOPENID" ColumnName="WEBCHATOPENID" />
  2206. <ScalarProperty Name="QQ" ColumnName="QQ" />
  2207. <ScalarProperty Name="CARNUMBER" ColumnName="CARNUMBER" />
  2208. <ScalarProperty Name="JINRUDATE" ColumnName="JINRUDATE" />
  2209. <ScalarProperty Name="WORKDATE" ColumnName="WORKDATE" />
  2210. <ScalarProperty Name="HUJIPAICHUSUO" ColumnName="HUJIPAICHUSUO" />
  2211. <ScalarProperty Name="HuJiSuoZaiDi" ColumnName="HuJiSuoZaiDi" />
  2212. <ScalarProperty Name="RESUMETYPE" ColumnName="RESUMETYPE" />
  2213. <ScalarProperty Name="RESUMENEWNAME" ColumnName="RESUMENEWNAME" />
  2214. <ScalarProperty Name="RESUMEOLDNAME" ColumnName="RESUMEOLDNAME" />
  2215. <ScalarProperty Name="PHOTOTYPE" ColumnName="PHOTOTYPE" />
  2216. <ScalarProperty Name="PHOTONEWNAME" ColumnName="PHOTONEWNAME" />
  2217. <ScalarProperty Name="PHOTOOLDNAME" ColumnName="PHOTOOLDNAME" />
  2218. <ScalarProperty Name="SPECIALTY" ColumnName="SPECIALTY" />
  2219. <ScalarProperty Name="GRADUATIONSCHOOL" ColumnName="GRADUATIONSCHOOL" />
  2220. <ScalarProperty Name="ZHICHENG" ColumnName="ZHICHENG" />
  2221. <ScalarProperty Name="XUELI" ColumnName="XUELI" />
  2222. <ScalarProperty Name="ACCOUNTLOCATION" ColumnName="ACCOUNTLOCATION" />
  2223. <ScalarProperty Name="HomeTown" ColumnName="HomeTown" />
  2224. <ScalarProperty Name="IDENTITYCODE" ColumnName="IDENTITYCODE" />
  2225. <ScalarProperty Name="MARRYCODE" ColumnName="MARRYCODE" />
  2226. <ScalarProperty Name="IDNUMBER" ColumnName="IDNUMBER" />
  2227. <ScalarProperty Name="NATIONCODE" ColumnName="NATIONCODE" />
  2228. <ScalarProperty Name="BIRTHDAY" ColumnName="BIRTHDAY" />
  2229. <ScalarProperty Name="SEXCODE" ColumnName="SEXCODE" />
  2230. <ScalarProperty Name="WORKCODE" ColumnName="WORKCODE" />
  2231. <ScalarProperty Name="SECONDPHONE" ColumnName="SECONDPHONE" />
  2232. <ScalarProperty Name="EMAILADDRESS" ColumnName="EMAILADDRESS" />
  2233. <ScalarProperty Name="OFFICEPHONE" ColumnName="OFFICEPHONE" />
  2234. <ScalarProperty Name="PHONE" ColumnName="PHONE" />
  2235. <ScalarProperty Name="POSTCODE" ColumnName="POSTCODE" />
  2236. <ScalarProperty Name="USERID" ColumnName="USERID" />
  2237. <ScalarProperty Name="ID" ColumnName="ID" />
  2238. </MappingFragment>
  2239. </EntityTypeMapping>
  2240. </EntitySetMapping>
  2241. <EntitySetMapping Name="SYS_WEBCHAT">
  2242. <EntityTypeMapping TypeName="wk_dbModel.SYS_WEBCHAT">
  2243. <MappingFragment StoreEntitySet="SYS_WEBCHAT">
  2244. <ScalarProperty Name="TELPHONE" ColumnName="TELPHONE" />
  2245. <ScalarProperty Name="SENDTIME" ColumnName="SENDTIME" />
  2246. <ScalarProperty Name="CREATETIME" ColumnName="CREATETIME" />
  2247. <ScalarProperty Name="SMSCODE" ColumnName="SMSCODE" />
  2248. <ScalarProperty Name="OPENID" ColumnName="OPENID" />
  2249. <ScalarProperty Name="ID" ColumnName="ID" />
  2250. </MappingFragment>
  2251. </EntityTypeMapping>
  2252. </EntitySetMapping>
  2253. <EntitySetMapping Name="YW_Bicycle">
  2254. <EntityTypeMapping TypeName="wk_dbModel.YW_Bicycle">
  2255. <MappingFragment StoreEntitySet="YW_Bicycle">
  2256. <ScalarProperty Name="IsLockable" ColumnName="IsLockable" />
  2257. <ScalarProperty Name="InFenceDate" ColumnName="InFenceDate" />
  2258. <ScalarProperty Name="OutFenceDate" ColumnName="OutFenceDate" />
  2259. <ScalarProperty Name="smallClass" ColumnName="smallClass" />
  2260. <ScalarProperty Name="ProductLine" ColumnName="ProductLine" />
  2261. <ScalarProperty Name="FactoryNumber" ColumnName="FactoryNumber" />
  2262. <ScalarProperty Name="CustomerName" ColumnName="CustomerName" />
  2263. <ScalarProperty Name="CustomerCode" ColumnName="CustomerCode" />
  2264. <ScalarProperty Name="FenceState" ColumnName="FenceState" />
  2265. <ScalarProperty Name="WarehouseName" ColumnName="WarehouseName" />
  2266. <ScalarProperty Name="WarehouseID" ColumnName="WarehouseID" />
  2267. <ScalarProperty Name="SalesId" ColumnName="SalesId" />
  2268. <ScalarProperty Name="ICCID" ColumnName="ICCID" />
  2269. <ScalarProperty Name="IMSI" ColumnName="IMSI" />
  2270. <ScalarProperty Name="SaleDate" ColumnName="SaleDate" />
  2271. <ScalarProperty Name="InputDate" ColumnName="InputDate" />
  2272. <ScalarProperty Name="OutDate" ColumnName="OutDate" />
  2273. <ScalarProperty Name="LockState" ColumnName="LockState" />
  2274. <ScalarProperty Name="UpdateDate" ColumnName="UpdateDate" />
  2275. <ScalarProperty Name="UpdateUser" ColumnName="UpdateUser" />
  2276. <ScalarProperty Name="CreateDate" ColumnName="CreateDate" />
  2277. <ScalarProperty Name="Createper" ColumnName="Createper" />
  2278. <ScalarProperty Name="carType" ColumnName="carType" />
  2279. <ScalarProperty Name="lang" ColumnName="lang" />
  2280. <ScalarProperty Name="CarSate" ColumnName="CarSate" />
  2281. <ScalarProperty Name="LeaseStatus" ColumnName="LeaseStatus" />
  2282. <ScalarProperty Name="productionDate" ColumnName="productionDate" />
  2283. <ScalarProperty Name="CarName" ColumnName="CarName" />
  2284. <ScalarProperty Name="carBar" ColumnName="carBar" />
  2285. <ScalarProperty Name="CarNumber" ColumnName="CarNumber" />
  2286. <ScalarProperty Name="CarModel" ColumnName="CarModel" />
  2287. <ScalarProperty Name="CarID" ColumnName="CarID" />
  2288. <ScalarProperty Name="DistributorsName" ColumnName="DistributorsName" />
  2289. <ScalarProperty Name="DistributorsID" ColumnName="DistributorsID" />
  2290. <ScalarProperty Name="UserId" ColumnName="UserId" />
  2291. <ScalarProperty Name="ID" ColumnName="ID" />
  2292. </MappingFragment>
  2293. </EntityTypeMapping>
  2294. </EntitySetMapping>
  2295. <EntitySetMapping Name="YW_CarParamDetails">
  2296. <EntityTypeMapping TypeName="wk_dbModel.YW_CarParamDetails">
  2297. <MappingFragment StoreEntitySet="YW_CarParamDetails">
  2298. <ScalarProperty Name="add_time" ColumnName="add_time" />
  2299. <ScalarProperty Name="cartype" ColumnName="cartype" />
  2300. <ScalarProperty Name="timestamp" ColumnName="timestamp" />
  2301. <ScalarProperty Name="speed" ColumnName="speed" />
  2302. <ScalarProperty Name="voltage" ColumnName="voltage" />
  2303. <ScalarProperty Name="temperature" ColumnName="temperature" />
  2304. <ScalarProperty Name="hydraulic" ColumnName="hydraulic" />
  2305. <ScalarProperty Name="imei" ColumnName="imei" />
  2306. <ScalarProperty Name="ID" ColumnName="ID" />
  2307. </MappingFragment>
  2308. </EntityTypeMapping>
  2309. </EntitySetMapping>
  2310. <EntitySetMapping Name="YW_CarPurchaser">
  2311. <EntityTypeMapping TypeName="wk_dbModel.YW_CarPurchaser">
  2312. <MappingFragment StoreEntitySet="YW_CarPurchaser">
  2313. <ScalarProperty Name="SaleDate" ColumnName="SaleDate" />
  2314. <ScalarProperty Name="distributorsID" ColumnName="distributorsID" />
  2315. <ScalarProperty Name="updateName" ColumnName="updateName" />
  2316. <ScalarProperty Name="updateDate" ColumnName="updateDate" />
  2317. <ScalarProperty Name="addName" ColumnName="addName" />
  2318. <ScalarProperty Name="addDate" ColumnName="addDate" />
  2319. <ScalarProperty Name="userCode" ColumnName="userCode" />
  2320. <ScalarProperty Name="userAddress" ColumnName="userAddress" />
  2321. <ScalarProperty Name="userTel" ColumnName="userTel" />
  2322. <ScalarProperty Name="userName" ColumnName="userName" />
  2323. <ScalarProperty Name="imei" ColumnName="imei" />
  2324. <ScalarProperty Name="carBar" ColumnName="carBar" />
  2325. <ScalarProperty Name="carId" ColumnName="carId" />
  2326. <ScalarProperty Name="ID" ColumnName="ID" />
  2327. </MappingFragment>
  2328. </EntityTypeMapping>
  2329. </EntitySetMapping>
  2330. <EntitySetMapping Name="YW_Notice">
  2331. <EntityTypeMapping TypeName="wk_dbModel.YW_Notice">
  2332. <MappingFragment StoreEntitySet="YW_Notice">
  2333. <ScalarProperty Name="ImgUrl" ColumnName="ImgUrl" />
  2334. <ScalarProperty Name="updateDate" ColumnName="updateDate" />
  2335. <ScalarProperty Name="updateUser" ColumnName="updateUser" />
  2336. <ScalarProperty Name="createDate" ColumnName="createDate" />
  2337. <ScalarProperty Name="createper" ColumnName="createper" />
  2338. <ScalarProperty Name="IsDel" ColumnName="IsDel" />
  2339. <ScalarProperty Name="IsRead" ColumnName="IsRead" />
  2340. <ScalarProperty Name="Noticetype" ColumnName="Noticetype" />
  2341. <ScalarProperty Name="RoleId" ColumnName="RoleId" />
  2342. <ScalarProperty Name="Content" ColumnName="Content" />
  2343. <ScalarProperty Name="Title" ColumnName="Title" />
  2344. <ScalarProperty Name="ID" ColumnName="ID" />
  2345. </MappingFragment>
  2346. </EntityTypeMapping>
  2347. </EntitySetMapping>
  2348. <EntitySetMapping Name="YW_User_Notice">
  2349. <EntityTypeMapping TypeName="wk_dbModel.YW_User_Notice">
  2350. <MappingFragment StoreEntitySet="YW_User_Notice">
  2351. <ScalarProperty Name="noticeID" ColumnName="noticeID" />
  2352. <ScalarProperty Name="userID" ColumnName="userID" />
  2353. <ScalarProperty Name="ID" ColumnName="ID" />
  2354. </MappingFragment>
  2355. </EntityTypeMapping>
  2356. </EntitySetMapping>
  2357. <EntitySetMapping Name="YW_UserCar">
  2358. <EntityTypeMapping TypeName="wk_dbModel.YW_UserCar">
  2359. <MappingFragment StoreEntitySet="YW_UserCar">
  2360. <ScalarProperty Name="userIdentity" ColumnName="userIdentity" />
  2361. <ScalarProperty Name="userName" ColumnName="userName" />
  2362. <ScalarProperty Name="userTel" ColumnName="userTel" />
  2363. <ScalarProperty Name="update_name" ColumnName="update_name" />
  2364. <ScalarProperty Name="update_time" ColumnName="update_time" />
  2365. <ScalarProperty Name="add_name" ColumnName="add_name" />
  2366. <ScalarProperty Name="add_time" ColumnName="add_time" />
  2367. <ScalarProperty Name="note" ColumnName="note" />
  2368. <ScalarProperty Name="carId" ColumnName="carId" />
  2369. <ScalarProperty Name="userId" ColumnName="userId" />
  2370. <ScalarProperty Name="ID" ColumnName="ID" />
  2371. </MappingFragment>
  2372. </EntityTypeMapping>
  2373. </EntitySetMapping>
  2374. <EntitySetMapping Name="YW_UserDistributor">
  2375. <EntityTypeMapping TypeName="wk_dbModel.YW_UserDistributor">
  2376. <MappingFragment StoreEntitySet="YW_UserDistributor">
  2377. <ScalarProperty Name="distype" ColumnName="distype" />
  2378. <ScalarProperty Name="ProductLine5" ColumnName="ProductLine5" />
  2379. <ScalarProperty Name="ProductLine4" ColumnName="ProductLine4" />
  2380. <ScalarProperty Name="ProductLine3" ColumnName="ProductLine3" />
  2381. <ScalarProperty Name="ProductLine2" ColumnName="ProductLine2" />
  2382. <ScalarProperty Name="ProductLine1" ColumnName="ProductLine1" />
  2383. <ScalarProperty Name="ProductLine" ColumnName="ProductLine" />
  2384. <ScalarProperty Name="add_time" ColumnName="add_time" />
  2385. <ScalarProperty Name="add_name" ColumnName="add_name" />
  2386. <ScalarProperty Name="distributorId" ColumnName="distributorId" />
  2387. <ScalarProperty Name="userId" ColumnName="userId" />
  2388. <ScalarProperty Name="ID" ColumnName="ID" />
  2389. </MappingFragment>
  2390. </EntityTypeMapping>
  2391. </EntitySetMapping>
  2392. <EntitySetMapping Name="YW_UserToken">
  2393. <EntityTypeMapping TypeName="wk_dbModel.YW_UserToken">
  2394. <MappingFragment StoreEntitySet="YW_UserToken">
  2395. <ScalarProperty Name="AddTime" ColumnName="AddTime" />
  2396. <ScalarProperty Name="UID" ColumnName="UID" />
  2397. <ScalarProperty Name="UserToken" ColumnName="UserToken" />
  2398. <ScalarProperty Name="UserType" ColumnName="UserType" />
  2399. <ScalarProperty Name="ID" ColumnName="ID" />
  2400. </MappingFragment>
  2401. </EntityTypeMapping>
  2402. </EntitySetMapping>
  2403. <EntitySetMapping Name="SYS_ONLINE">
  2404. <EntityTypeMapping TypeName="wk_dbModel.SYS_ONLINE">
  2405. <MappingFragment StoreEntitySet="SYS_ONLINE">
  2406. <ScalarProperty Name="NAME" ColumnName="NAME" />
  2407. <ScalarProperty Name="USERID" ColumnName="USERID" />
  2408. <ScalarProperty Name="STATE" ColumnName="STATE" />
  2409. <ScalarProperty Name="LASTACCESSTIME" ColumnName="LASTACCESSTIME" />
  2410. <ScalarProperty Name="ACCOUNT" ColumnName="ACCOUNT" />
  2411. <ScalarProperty Name="COOKIEID" ColumnName="COOKIEID" />
  2412. <ScalarProperty Name="TIMEOUTTIME" ColumnName="TIMEOUTTIME" />
  2413. <ScalarProperty Name="LOGINTIME" ColumnName="LOGINTIME" />
  2414. <ScalarProperty Name="ID" ColumnName="ID" />
  2415. </MappingFragment>
  2416. </EntityTypeMapping>
  2417. </EntitySetMapping>
  2418. <EntitySetMapping Name="SYS_DISTRIBUTORS">
  2419. <EntityTypeMapping TypeName="wk_dbModel.SYS_DISTRIBUTORS">
  2420. <MappingFragment StoreEntitySet="SYS_DISTRIBUTORS">
  2421. <ScalarProperty Name="Notes" ColumnName="Notes" />
  2422. <ScalarProperty Name="SaleCar" ColumnName="SaleCar" />
  2423. <ScalarProperty Name="SaleType" ColumnName="SaleType" />
  2424. <ScalarProperty Name="DealerNumber" ColumnName="DealerNumber" />
  2425. <ScalarProperty Name="Theodolite" ColumnName="Theodolite" />
  2426. <ScalarProperty Name="FenceRadius" ColumnName="FenceRadius" />
  2427. <ScalarProperty Name="FenceID" ColumnName="FenceID" />
  2428. <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
  2429. <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
  2430. <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
  2431. <ScalarProperty Name="CREATEPERID" ColumnName="CREATEPERID" />
  2432. <ScalarProperty Name="Area" ColumnName="Area" />
  2433. <ScalarProperty Name="City" ColumnName="City" />
  2434. <ScalarProperty Name="Province" ColumnName="Province" />
  2435. <ScalarProperty Name="ProvinceCity" ColumnName="ProvinceCity" />
  2436. <ScalarProperty Name="PARENTID" ColumnName="PARENTID" />
  2437. <ScalarProperty Name="LICENSEVALUE" ColumnName="LICENSEVALUE" />
  2438. <ScalarProperty Name="LICENSEURL" ColumnName="LICENSEURL" />
  2439. <ScalarProperty Name="ParentName" ColumnName="ParentName" />
  2440. <ScalarProperty Name="PARENTCODE" ColumnName="PARENTCODE" />
  2441. <ScalarProperty Name="Address" ColumnName="Address" />
  2442. <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
  2443. <ScalarProperty Name="BUSINESSLEVEL" ColumnName="BUSINESSLEVEL" />
  2444. <ScalarProperty Name="NAME" ColumnName="NAME" />
  2445. <ScalarProperty Name="CODE" ColumnName="CODE" />
  2446. <ScalarProperty Name="ID" ColumnName="ID" />
  2447. </MappingFragment>
  2448. </EntityTypeMapping>
  2449. </EntitySetMapping>
  2450. </EntityContainerMapping>
  2451. </Mapping>
  2452. </edmx:Mappings>
  2453. </edmx:Runtime>
  2454. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  2455. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  2456. <Connection>
  2457. <DesignerInfoPropertySet>
  2458. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  2459. </DesignerInfoPropertySet>
  2460. </Connection>
  2461. <Options>
  2462. <DesignerInfoPropertySet>
  2463. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  2464. <DesignerProperty Name="EnablePluralization" Value="false" />
  2465. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  2466. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  2467. <DesignerProperty Name="CodeGenerationStrategy" Value="无" />
  2468. </DesignerInfoPropertySet>
  2469. </Options>
  2470. <!-- Diagram content (shape and connector positions) -->
  2471. <Diagrams></Diagrams>
  2472. </Designer>
  2473. </edmx:Edmx>