1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473 |
- <?xml version="1.0" encoding="utf-8"?>
- <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
- <!-- EF Runtime content -->
- <edmx:Runtime>
- <!-- SSDL content -->
- <edmx:StorageModels>
- <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">
- <EntityType Name="COM_CONTENT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="FK_RELATIONID" Type="nvarchar" MaxLength="72" Nullable="false" />
- <Property Name="CONTENT" Type="ntext" />
- <Property Name="CONTENTBLOB" Type="varbinary(max)" />
- <Property Name="FK_TABLE" Type="nvarchar" MaxLength="200" Nullable="false" />
- <Property Name="CREATEDATE" Type="date" Nullable="false" />
- <Property Name="ISDEL" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="COM_CUSCONTACT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NAME" Type="nvarchar" MaxLength="50" />
- <Property Name="SEX" Type="int" />
- <Property Name="PHOME" Type="nvarchar" MaxLength="50" />
- <Property Name="TELNO" Type="nvarchar" MaxLength="50" />
- <Property Name="SECONDPHONE" Type="nvarchar" MaxLength="50" />
- <Property Name="QQ" Type="nvarchar" MaxLength="20" />
- <Property Name="EMAIL" Type="nvarchar" MaxLength="20" />
- <Property Name="WX" Type="nvarchar" MaxLength="100" />
- <Property Name="COMPANY" Type="nvarchar" MaxLength="300" />
- <Property Name="COMPADDRESS" Type="nvarchar" MaxLength="500" />
- <Property Name="ZW" Type="nvarchar" MaxLength="20" />
- <Property Name="ADDRESS" Type="nvarchar" MaxLength="500" />
- <Property Name="PROV" Type="nvarchar" MaxLength="20" />
- <Property Name="CITY" Type="nvarchar" MaxLength="20" />
- <Property Name="REMARK" Type="nvarchar" MaxLength="2000" />
- <Property Name="FK_USERID" Type="int" Nullable="false" />
- <Property Name="CREATETIME" Type="datetime" Nullable="false" />
- <Property Name="FK_TYPE" Type="nvarchar" MaxLength="36" />
- </EntityType>
- <EntityType Name="COM_DOWNLOAD">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="FK_USERID" Type="int" />
- <Property Name="DLOPERATOR" Type="nvarchar" MaxLength="100" />
- <Property Name="DLIP" Type="nvarchar" MaxLength="40" />
- <Property Name="DLNUM" Type="int" />
- <Property Name="FK_UPID" Type="nvarchar" MaxLength="72" />
- <Property Name="DLDATE" Type="datetime" />
- </EntityType>
- <EntityType Name="COM_FLOWINFO">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="FLOWNO" Type="nvarchar" MaxLength="200" Nullable="false" />
- <Property Name="PATH" Type="nvarchar" MaxLength="1000" Nullable="false" />
- <Property Name="SHOW" Type="nvarchar" MaxLength="1000" Nullable="false" />
- <Property Name="TABLENAME" Type="nvarchar" MaxLength="100" Nullable="false" />
- <Property Name="REMARK" Type="nvarchar" MaxLength="400" Nullable="false" />
- <Property Name="CREATETIME" Type="datetime" Nullable="false" />
- <Property Name="CREATEUSER" Type="nvarchar" MaxLength="100" Nullable="false" />
- <Property Name="UPDATETIME" Type="datetime" Nullable="false" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="100" Nullable="false" />
- </EntityType>
- <EntityType Name="COM_INDEX">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="TITLE" Type="nvarchar" MaxLength="200" Nullable="false" />
- <Property Name="ICON" Type="nvarchar" MaxLength="200" />
- <Property Name="COLOR" Type="nvarchar" MaxLength="50" />
- <Property Name="BACKGROUNDCOLOR" Type="nvarchar" MaxLength="50" />
- <Property Name="SHOWORDER" Type="int" Nullable="false" />
- <Property Name="PATH" Type="nvarchar" MaxLength="500" />
- <Property Name="SHOWTYPE" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="COM_UPLOAD">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="FK_USERID" Type="nvarchar" MaxLength="72" />
- <Property Name="UPOPEATOR" Type="nvarchar" MaxLength="100" />
- <Property Name="UPTIME" Type="datetime" />
- <Property Name="UPOLDNAME" Type="nvarchar" MaxLength="400" />
- <Property Name="UPNEWNAME" Type="nvarchar" MaxLength="400" />
- <Property Name="UPFILESIZE" Type="int" />
- <Property Name="UPFILEUNIT" Type="nvarchar" MaxLength="20" />
- <Property Name="UPFILEPATH" Type="nvarchar" MaxLength="2000" />
- <Property Name="UPFILESUFFIX" Type="nvarchar" MaxLength="40" />
- <Property Name="UPFILETHUMBNAIL" Type="nvarchar" MaxLength="2000" />
- <Property Name="UPFILETHUMBNAILFORPAD" Type="nvarchar" MaxLength="2000" />
- <Property Name="UPFILETHUMBNAILFORPHONE" Type="nvarchar" MaxLength="2000" />
- <Property Name="UPFILEIP" Type="nvarchar" MaxLength="40" />
- <Property Name="UPFILEURL" Type="nvarchar" MaxLength="1000" />
- </EntityType>
- <EntityType Name="SYS_BEUSER">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="72" Nullable="false" />
- <Property Name="FK_USERID" Type="nvarchar" MaxLength="72" Nullable="false" />
- <Property Name="FK_TOUSER" Type="nvarchar" MaxLength="72" Nullable="false" />
- <Property Name="TONUMBER" Type="numeric" Precision="20" Scale="0" Nullable="false" />
- <Property Name="CREATETIME" Type="date" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_CODE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="CODETYPE" Type="nvarchar" MaxLength="50" />
- <Property Name="NAMETEXT" Type="nvarchar" MaxLength="200" />
- <Property Name="CODEVALUE" Type="nvarchar" MaxLength="100" />
- <Property Name="SHOWORDER" Type="int" />
- <Property Name="ISCODE" Type="int" />
- <Property Name="REMARK" Type="nvarchar" MaxLength="2000" />
- <Property Name="CREATEDATE" Type="datetime" />
- <Property Name="CREATEUSER" Type="nvarchar" MaxLength="36" />
- <Property Name="UPDATEDATE" Type="datetime" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
- <Property Name="PARENTID" Type="int" />
- </EntityType>
- <EntityType Name="SYS_CODE_AREA">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="varchar" MaxLength="50" Nullable="false" />
- <Property Name="PID" Type="varchar" MaxLength="50" Nullable="false" />
- <Property Name="NAME" Type="nvarchar" MaxLength="200" />
- <Property Name="LEVELS" Type="tinyint" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_DISTRIBUTORS">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="CODE" Type="nvarchar" MaxLength="100" />
- <Property Name="DealerNumber" Type="nvarchar" MaxLength="100" />
- <Property Name="NAME" Type="nvarchar" MaxLength="200" />
- <Property Name="BUSINESSLEVEL" Type="int" />
- <Property Name="SHOWORDER" Type="int" />
- <Property Name="Address" Type="nvarchar" MaxLength="100" />
- <Property Name="PARENTCODE" Type="nvarchar" MaxLength="100" />
- <Property Name="ParentName" Type="nvarchar" MaxLength="200" />
- <Property Name="LICENSEURL" Type="nvarchar" MaxLength="200" />
- <Property Name="LICENSEVALUE" Type="nvarchar" MaxLength="4000" />
- <Property Name="PARENTID" Type="nvarchar" MaxLength="36" />
- <Property Name="ProvinceCity" Type="varchar" MaxLength="200" />
- <Property Name="Province" Type="int" />
- <Property Name="City" Type="int" />
- <Property Name="Area" Type="int" />
- <Property Name="CREATEPERID" Type="nvarchar" MaxLength="36" />
- <Property Name="CREATEDATE" Type="date" />
- <Property Name="UPDATEDATE" Type="date" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
- <Property Name="FenceID" Type="nvarchar" MaxLength="36" />
- <Property Name="FenceRadius" Type="int" />
- <Property Name="Theodolite" Type="nvarchar" MaxLength="80" />
- <Property Name="SaleType" Type="int" />
- <Property Name="SaleCar" Type="nvarchar" MaxLength="400" />
- <Property Name="Notes" Type="nvarchar" MaxLength="500" />
- </EntityType>
- <EntityType Name="SYS_LOG">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="DATES" Type="datetime" />
- <Property Name="LEVELS" Type="nvarchar" MaxLength="20" />
- <Property Name="LOGGER" Type="nvarchar" MaxLength="200" />
- <Property Name="CLIENTUSER" Type="nvarchar" MaxLength="100" />
- <Property Name="CLIENTIP" Type="nvarchar" MaxLength="20" />
- <Property Name="REQUESTURL" Type="nvarchar" MaxLength="500" />
- <Property Name="ACTION" Type="nvarchar" MaxLength="20" />
- <Property Name="MESSAGE" Type="nvarchar" MaxLength="4000" />
- <Property Name="EXCEPTION" Type="nvarchar" MaxLength="4000" />
- </EntityType>
- <EntityType Name="SYS_MODULE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="FK_BELONGSYSTEM" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="PARENTID" Type="int" Nullable="false" />
- <Property Name="NAME" Type="nvarchar" MaxLength="50" />
- <Property Name="ALIAS" Type="nvarchar" MaxLength="50" />
- <Property Name="MODULETYPE" Type="int" Nullable="false" />
- <Property Name="ICON" Type="nvarchar" MaxLength="200" />
- <Property Name="MODULEPATH" Type="nvarchar" MaxLength="500" />
- <Property Name="ISSHOW" Type="int" Nullable="false" />
- <Property Name="SHOWORDER" Type="int" Nullable="false" />
- <Property Name="LEVELS" Type="int" Nullable="false" />
- <Property Name="CREATEUSER" Type="nvarchar" MaxLength="50" />
- <Property Name="CREATEDATE" Type="datetime" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
- <Property Name="UPDATEDATE" Type="datetime" />
- </EntityType>
- <EntityType Name="SYS_MSG">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="MSGNAME" Type="nvarchar" MaxLength="400" Nullable="false" />
- <Property Name="MSGTYPE" Type="nvarchar" MaxLength="100" />
- <Property Name="CREATEPER" Type="int" Nullable="false" />
- <Property Name="CREATEDATE" Type="datetime" Nullable="false" />
- <Property Name="DELETESTATUS" Type="int" Nullable="false" />
- <Property Name="MSGCONTENT" Type="text" />
- </EntityType>
- <EntityType Name="SYS_MSGATTACH">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="MSGID" Type="int" />
- <Property Name="FK_UPLOADID" Type="nvarchar" MaxLength="36" />
- <Property Name="CREATEDATE" Type="datetime" />
- </EntityType>
- <EntityType Name="SYS_MSGREV">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="MSGID" Type="int" Nullable="false" />
- <Property Name="USERID" Type="int" Nullable="false" />
- <Property Name="READSTATUS" Type="int" Nullable="false" />
- <Property Name="DELETESTATUS" Type="int" Nullable="false" />
- </EntityType>
- <!--生成过程中发现错误:
- 警告 6002: 表/视图“ChangFaMachinery.dbo.SYS_ONLINE”未定义主键。已推断出该键,并将定义创建为只读的表/视图。-->
- <EntityType Name="SYS_ONLINE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="LOGINTIME" Type="date" />
- <Property Name="TIMEOUTTIME" Type="numeric" Precision="38" Scale="0" />
- <Property Name="COOKIEID" Type="nvarchar" MaxLength="36" />
- <Property Name="ACCOUNT" Type="nvarchar" MaxLength="36" />
- <Property Name="LASTACCESSTIME" Type="date" />
- <Property Name="STATE" Type="numeric" Precision="38" Scale="0" />
- <Property Name="USERID" Type="nvarchar" MaxLength="36" />
- <Property Name="NAME" Type="nvarchar" MaxLength="100" />
- </EntityType>
- <EntityType Name="SYS_PERMISSION">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="MODULEID" Type="int" Nullable="false" />
- <Property Name="NAME" Type="nvarchar" MaxLength="36" />
- <Property Name="PERVALUE" Type="nvarchar" MaxLength="100" />
- <Property Name="ICON" Type="nvarchar" MaxLength="50" />
- <Property Name="SHOWORDER" Type="int" />
- <Property Name="CREATEDATE" Type="date" />
- <Property Name="CREATEUSER" Type="nvarchar" MaxLength="36" />
- <Property Name="UPDATEDATE" Type="date" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
- </EntityType>
- <EntityType Name="SYS_POST">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="POSTNAME" Type="nvarchar" MaxLength="100" />
- <Property Name="POSTTYPE" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="REMARK" Type="nvarchar" MaxLength="500" />
- <Property Name="SHOWORDER" Type="int" />
- <Property Name="CREATEUSERID" Type="int" />
- <Property Name="CREATEDATE" Type="datetime" Nullable="false" />
- <Property Name="UPDATEDATE" Type="datetime" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
- </EntityType>
- <EntityType Name="SYS_POST_DEPARTMENT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="FK_DEPARTMENT_ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="FK_POST_ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_POST_USER">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="FK_USERID" Type="int" Nullable="false" />
- <Property Name="FK_POST_DEPARTMENTID" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_ROLE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="ROLENAME" Type="nvarchar" MaxLength="50" />
- <Property Name="ISCUSTOM" Type="int" Nullable="false" />
- <Property Name="ROLEDESC" Type="nvarchar" MaxLength="1000" />
- <Property Name="CREATEPERID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="CREATEDATE" Type="datetime" Nullable="false" />
- <Property Name="UPDATEDATE" Type="datetime" Nullable="false" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
- </EntityType>
- <EntityType Name="SYS_ROLE_PERMISSION">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="ROLEID" Type="int" Nullable="false" />
- <Property Name="PERMISSIONID" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_SMS">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="100" Nullable="false" />
- <Property Name="SENDER" Type="nvarchar" MaxLength="200" />
- <Property Name="SENDTOEMPID" Type="nvarchar" MaxLength="200" />
- <Property Name="RDT" Type="nvarchar" MaxLength="50" />
- <Property Name="TEL" Type="nvarchar" MaxLength="200" />
- <Property Name="TELSTA" Type="numeric" Precision="38" Scale="0" />
- <Property Name="EMAIL" Type="nvarchar" MaxLength="200" />
- <Property Name="EMAISTA" Type="numeric" Precision="38" Scale="0" />
- <Property Name="TITLE" Type="nvarchar" MaxLength="3000" />
- <Property Name="DOC" Type="nvarchar" MaxLength="4000" />
- <Property Name="SENDDT" Type="nvarchar" MaxLength="50" />
- <Property Name="ISREAD" Type="numeric" Precision="38" Scale="0" />
- <Property Name="ISALERT" Type="numeric" Precision="38" Scale="0" />
- <Property Name="MSGFLAG" Type="nvarchar" MaxLength="200" />
- <Property Name="WORKID" Type="numeric" Precision="38" Scale="0" />
- <Property Name="FLOWNO" Type="nvarchar" MaxLength="200" />
- </EntityType>
- <EntityType Name="SYS_SYSTEM">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="NAME" Type="nvarchar" MaxLength="200" />
- <Property Name="SITEURL" Type="nvarchar" MaxLength="500" />
- <Property Name="IS_LOGIN" Type="tinyint" />
- <Property Name="DOCKUSER" Type="nvarchar" MaxLength="100" />
- <Property Name="DOCKPASS" Type="nvarchar" MaxLength="200" />
- <Property Name="CREATEDATE" Type="date" />
- <Property Name="REMARK" Type="nvarchar" MaxLength="2000" />
- </EntityType>
- <EntityType Name="SYS_USER">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="NAME" Type="nvarchar" MaxLength="50" />
- <Property Name="ACCOUNT" Type="nvarchar" MaxLength="20" />
- <Property Name="PASSWORD" Type="nvarchar" MaxLength="50" />
- <Property Name="PHONE" Type="varchar" MaxLength="50" />
- <Property Name="ISCANLOGIN" Type="bit" />
- <Property Name="SHOWORDER1" Type="int" />
- <Property Name="SHOWORDER2" Type="int" />
- <Property Name="VERIFICATION" Type="varchar" MaxLength="50" />
- <Property Name="EXPIRYDATE" Type="datetime" />
- <Property Name="PINYIN1" Type="nvarchar" MaxLength="50" />
- <Property Name="PINYIN2" Type="nvarchar" MaxLength="50" />
- <Property Name="FACE_IMG" Type="nvarchar" MaxLength="200" />
- <Property Name="LEVELS" Type="nvarchar" MaxLength="36" />
- <Property Name="DPTID" Type="nvarchar" MaxLength="36" />
- <Property Name="WORKNUMBER" Type="nvarchar" MaxLength="50" />
- <Property Name="Location" Type="nvarchar" MaxLength="100" />
- <Property Name="USERTYPE" Type="int" />
- <Property Name="ISDEL" Type="bit" />
- <Property Name="LANG" Type="varchar" MaxLength="10" />
- <Property Name="CREATEPER" Type="nvarchar" MaxLength="36" />
- <Property Name="CREATEDATE" Type="datetime" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
- <Property Name="UPDATEDATE" Type="datetime" />
- </EntityType>
- <EntityType Name="SYS_USER_DEPARTMENT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="USER_ID" Type="int" Nullable="false" />
- <Property Name="DEPARTMENT_ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_USER_PERMISSION">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="FK_USERID" Type="int" Nullable="false" />
- <Property Name="FK_PERMISSIONID" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_USER_ROLE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="FK_USERID" Type="int" Nullable="false" />
- <Property Name="FK_ROLEID" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_USERINFO">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="USERID" Type="int" Nullable="false" />
- <Property Name="POSTCODE" Type="int" />
- <Property Name="PHONE" Type="nvarchar" MaxLength="200" />
- <Property Name="OFFICEPHONE" Type="nvarchar" MaxLength="200" />
- <Property Name="EMAILADDRESS" Type="nvarchar" MaxLength="200" />
- <Property Name="SECONDPHONE" Type="nvarchar" MaxLength="200" />
- <Property Name="WORKCODE" Type="int" />
- <Property Name="SEXCODE" Type="int" />
- <Property Name="BIRTHDAY" Type="datetime" />
- <Property Name="NATIONCODE" Type="int" />
- <Property Name="IDNUMBER" Type="nvarchar" MaxLength="30" />
- <Property Name="MARRYCODE" Type="int" />
- <Property Name="IDENTITYCODE" Type="int" />
- <Property Name="HomeTown" Type="nvarchar" MaxLength="200" />
- <Property Name="ACCOUNTLOCATION" Type="nvarchar" MaxLength="200" />
- <Property Name="XUELI" Type="int" />
- <Property Name="ZHICHENG" Type="int" />
- <Property Name="GRADUATIONSCHOOL" Type="nvarchar" MaxLength="200" />
- <Property Name="SPECIALTY" Type="nvarchar" MaxLength="200" />
- <Property Name="PHOTOOLDNAME" Type="nvarchar" MaxLength="200" />
- <Property Name="PHOTONEWNAME" Type="nvarchar" MaxLength="200" />
- <Property Name="PHOTOTYPE" Type="nvarchar" MaxLength="200" />
- <Property Name="RESUMEOLDNAME" Type="nvarchar" MaxLength="200" />
- <Property Name="RESUMENEWNAME" Type="nvarchar" MaxLength="200" />
- <Property Name="RESUMETYPE" Type="nvarchar" MaxLength="200" />
- <Property Name="HuJiSuoZaiDi" Type="nvarchar" MaxLength="200" />
- <Property Name="HUJIPAICHUSUO" Type="nvarchar" MaxLength="200" />
- <Property Name="WORKDATE" Type="datetime" />
- <Property Name="JINRUDATE" Type="datetime" />
- <Property Name="CARNUMBER" Type="nvarchar" MaxLength="200" />
- <Property Name="QQ" Type="nvarchar" MaxLength="15" />
- <Property Name="WEBCHATOPENID" Type="nvarchar" MaxLength="200" />
- <Property Name="CREATEDATE" Type="datetime" />
- <Property Name="CREATEUSER" Type="nvarchar" MaxLength="36" />
- <Property Name="UPDATEDATE" Type="datetime" />
- <Property Name="UPDATEUSER" Type="nvarchar" MaxLength="36" />
- </EntityType>
- <EntityType Name="SYS_WEBCHAT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="nvarchar" MaxLength="36" Nullable="false" />
- <Property Name="OPENID" Type="nvarchar" MaxLength="100" />
- <Property Name="SMSCODE" Type="nvarchar" MaxLength="100" />
- <Property Name="CREATETIME" Type="date" />
- <Property Name="SENDTIME" Type="date" />
- <Property Name="TELPHONE" Type="nvarchar" MaxLength="11" />
- </EntityType>
- <EntityType Name="YW_Bicycle">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
- <Property Name="IMSI" Type="nvarchar" MaxLength="36" />
- <Property Name="ICCID" Type="nvarchar" MaxLength="36" />
- <Property Name="UserId" Type="nvarchar" MaxLength="36" />
- <Property Name="SalesId" Type="nvarchar" MaxLength="36" />
- <Property Name="DistributorsID" Type="nvarchar" MaxLength="36" />
- <Property Name="DistributorsName" Type="nvarchar" MaxLength="200" />
- <Property Name="WarehouseID" Type="nvarchar" MaxLength="36" />
- <Property Name="WarehouseName" Type="nvarchar" MaxLength="200" />
- <Property Name="CarID" Type="nvarchar" MaxLength="60" />
- <Property Name="CarModel" Type="nvarchar" MaxLength="60" />
- <Property Name="CarNumber" Type="nvarchar" MaxLength="60" />
- <Property Name="carBar" Type="nvarchar" MaxLength="36" />
- <Property Name="ProductLine" Type="int" />
- <Property Name="CarName" Type="nvarchar" MaxLength="100" />
- <Property Name="productionDate" Type="datetime" />
- <Property Name="LeaseStatus" Type="int" />
- <Property Name="CarSate" Type="int" />
- <Property Name="LockState" Type="bit" />
- <Property Name="lang" Type="nvarchar" MaxLength="60" />
- <Property Name="carType" Type="int" />
- <Property Name="smallClass" Type="int" />
- <Property Name="Createper" Type="nvarchar" MaxLength="36" />
- <Property Name="CreateDate" Type="datetime" />
- <Property Name="OutDate" Type="datetime" />
- <Property Name="InputDate" Type="datetime" />
- <Property Name="SaleDate" Type="datetime" />
- <Property Name="UpdateUser" Type="nvarchar" MaxLength="36" />
- <Property Name="UpdateDate" Type="datetime" />
- <Property Name="FenceState" Type="int" />
- <Property Name="CustomerCode" Type="nvarchar" MaxLength="36" />
- <Property Name="CustomerName" Type="nvarchar" MaxLength="200" />
- <Property Name="FactoryNumber" Type="nvarchar" MaxLength="36" />
- <Property Name="OutFenceDate" Type="datetime" />
- <Property Name="InFenceDate" Type="datetime" />
- <Property Name="IsLockable" Type="bit" />
- </EntityType>
- <EntityType Name="YW_CarParamDetails">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
- <Property Name="imei" Type="nvarchar" MaxLength="36" />
- <Property Name="hydraulic" Type="nvarchar" MaxLength="36" />
- <Property Name="temperature" Type="nvarchar" MaxLength="36" />
- <Property Name="voltage" Type="nvarchar" MaxLength="36" />
- <Property Name="speed" Type="nvarchar" MaxLength="36" />
- <Property Name="timestamp" Type="nvarchar" MaxLength="36" />
- <Property Name="cartype" Type="int" />
- <Property Name="add_time" Type="datetime" />
- </EntityType>
- <EntityType Name="YW_CarPurchaser">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
- <Property Name="carId" Type="nvarchar" MaxLength="36" />
- <Property Name="carBar" Type="nvarchar" MaxLength="36" />
- <Property Name="imei" Type="nvarchar" MaxLength="36" />
- <Property Name="userName" Type="nvarchar" MaxLength="36" />
- <Property Name="userTel" Type="nvarchar" MaxLength="36" />
- <Property Name="userAddress" Type="nvarchar" MaxLength="150" />
- <Property Name="userCode" Type="nvarchar" MaxLength="36" />
- <Property Name="addDate" Type="datetime" />
- <Property Name="addName" Type="nvarchar" MaxLength="36" />
- <Property Name="updateDate" Type="datetime" />
- <Property Name="updateName" Type="nvarchar" MaxLength="36" />
- <Property Name="distributorsID" Type="nvarchar" MaxLength="36" />
- <Property Name="SaleDate" Type="datetime" />
- </EntityType>
- <EntityType Name="YW_Notice">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
- <Property Name="Title" Type="nvarchar" MaxLength="200" />
- <Property Name="Content" Type="nvarchar" MaxLength="2000" />
- <Property Name="RoleId" Type="int" />
- <Property Name="Noticetype" Type="int" />
- <Property Name="IsRead" Type="bit" />
- <Property Name="IsDel" Type="bit" />
- <Property Name="createper" Type="nvarchar" MaxLength="36" />
- <Property Name="createDate" Type="datetime" />
- <Property Name="updateUser" Type="nvarchar" MaxLength="36" />
- <Property Name="updateDate" Type="datetime" />
- <Property Name="ImgUrl" Type="nvarchar" MaxLength="200" />
- </EntityType>
- <EntityType Name="YW_User_Notice">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
- <Property Name="userID" Type="varchar" MaxLength="36" />
- <Property Name="noticeID" Type="varchar" MaxLength="36" />
- </EntityType>
- <EntityType Name="YW_UserCar">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
- <Property Name="userId" Type="nvarchar" MaxLength="36" />
- <Property Name="carId" Type="nvarchar" MaxLength="36" />
- <Property Name="note" Type="nvarchar" MaxLength="200" />
- <Property Name="add_time" Type="datetime" />
- <Property Name="add_name" Type="nvarchar" MaxLength="50" />
- <Property Name="update_time" Type="datetime" />
- <Property Name="update_name" Type="nvarchar" MaxLength="50" />
- <Property Name="userTel" Type="nvarchar" MaxLength="50" />
- <Property Name="userName" Type="nvarchar" MaxLength="50" />
- <Property Name="userIdentity" Type="int" />
- </EntityType>
- <EntityType Name="YW_UserDistributor">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="uniqueidentifier" Nullable="false" />
- <Property Name="userId" Type="int" />
- <Property Name="distributorId" Type="nvarchar" MaxLength="36" />
- <Property Name="add_name" Type="nvarchar" MaxLength="36" />
- <Property Name="add_time" Type="datetime" />
- <Property Name="ProductLine" Type="int" />
- <Property Name="ProductLine1" Type="int" />
- <Property Name="ProductLine2" Type="int" />
- <Property Name="ProductLine3" Type="int" />
- <Property Name="ProductLine4" Type="int" />
- <Property Name="ProductLine5" Type="int" />
- <Property Name="distype" Type="int" />
- </EntityType>
- <EntityType Name="YW_UserToken">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="UserType" Type="int" />
- <Property Name="UserToken" Type="nvarchar" MaxLength="36" />
- <Property Name="UID" Type="nvarchar" MaxLength="36" />
- <Property Name="AddTime" Type="datetime" />
- </EntityType>
- <Association Name="FK_SYS_MODULE_SYSTEMID">
- <End Role="SYS_SYSTEM" Type="Self.SYS_SYSTEM" Multiplicity="1" />
- <End Role="SYS_MODULE" Type="Self.SYS_MODULE" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_SYSTEM">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_MODULE">
- <PropertyRef Name="FK_BELONGSYSTEM" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_PERMISSION_MODULEID">
- <End Role="SYS_MODULE" Type="Self.SYS_MODULE" Multiplicity="1" />
- <End Role="SYS_PERMISSION" Type="Self.SYS_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_MODULE">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_PERMISSION">
- <PropertyRef Name="MODULEID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_POST_DEPARTMENT_DPTID">
- <End Role="SYS_DISTRIBUTORS" Type="Self.SYS_DISTRIBUTORS" Multiplicity="1" />
- <End Role="SYS_POST_DEPARTMENT" Type="Self.SYS_POST_DEPARTMENT" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_DISTRIBUTORS">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_POST_DEPARTMENT">
- <PropertyRef Name="FK_DEPARTMENT_ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_POST_DEPARTMENT_POSTID">
- <End Role="SYS_POST" Type="Self.SYS_POST" Multiplicity="1" />
- <End Role="SYS_POST_DEPARTMENT" Type="Self.SYS_POST_DEPARTMENT" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_POST">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_POST_DEPARTMENT">
- <PropertyRef Name="FK_POST_ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_POST_USER_POSTDPTID">
- <End Role="SYS_POST_DEPARTMENT" Type="Self.SYS_POST_DEPARTMENT" Multiplicity="1" />
- <End Role="SYS_POST_USER" Type="Self.SYS_POST_USER" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_POST_DEPARTMENT">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_POST_USER">
- <PropertyRef Name="FK_POST_DEPARTMENTID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_POST_USER_USERID">
- <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
- <End Role="SYS_POST_USER" Type="Self.SYS_POST_USER" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_POST_USER">
- <PropertyRef Name="FK_USERID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_ROLE_PERMISSION_PERID">
- <End Role="SYS_PERMISSION" Type="Self.SYS_PERMISSION" Multiplicity="1" />
- <End Role="SYS_ROLE_PERMISSION" Type="Self.SYS_ROLE_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_PERMISSION">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_ROLE_PERMISSION">
- <PropertyRef Name="PERMISSIONID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_ROLE_PERMISSION_ROLEID">
- <End Role="SYS_ROLE" Type="Self.SYS_ROLE" Multiplicity="1" />
- <End Role="SYS_ROLE_PERMISSION" Type="Self.SYS_ROLE_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_ROLE">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_ROLE_PERMISSION">
- <PropertyRef Name="ROLEID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_DEPARTMENT_DPTID">
- <End Role="SYS_DISTRIBUTORS" Type="Self.SYS_DISTRIBUTORS" Multiplicity="1" />
- <End Role="SYS_USER_DEPARTMENT" Type="Self.SYS_USER_DEPARTMENT" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_DISTRIBUTORS">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_DEPARTMENT">
- <PropertyRef Name="DEPARTMENT_ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_DEPARTMENT_USERID">
- <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
- <End Role="SYS_USER_DEPARTMENT" Type="Self.SYS_USER_DEPARTMENT" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_DEPARTMENT">
- <PropertyRef Name="USER_ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_PERMISSION_PERID">
- <End Role="SYS_PERMISSION" Type="Self.SYS_PERMISSION" Multiplicity="1" />
- <End Role="SYS_USER_PERMISSION" Type="Self.SYS_USER_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_PERMISSION">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_PERMISSION">
- <PropertyRef Name="FK_PERMISSIONID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_PERMISSION_USERID">
- <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
- <End Role="SYS_USER_PERMISSION" Type="Self.SYS_USER_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_PERMISSION">
- <PropertyRef Name="FK_USERID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_ROLE_ROLEID">
- <End Role="SYS_ROLE" Type="Self.SYS_ROLE" Multiplicity="1" />
- <End Role="SYS_USER_ROLE" Type="Self.SYS_USER_ROLE" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_ROLE">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_ROLE">
- <PropertyRef Name="FK_ROLEID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_ROLE_USERID">
- <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
- <End Role="SYS_USER_ROLE" Type="Self.SYS_USER_ROLE" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_ROLE">
- <PropertyRef Name="FK_USERID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USERINFO_SYSUSERID">
- <End Role="SYS_USER" Type="Self.SYS_USER" Multiplicity="1" />
- <End Role="SYS_USERINFO" Type="Self.SYS_USERINFO" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USERINFO">
- <PropertyRef Name="USERID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Function Name="PaginationByRowNumber" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
- <Parameter Name="Table" Type="varchar" Mode="In" />
- <Parameter Name="Sort" Type="varchar" Mode="In" />
- <Parameter Name="CurrentPage" Type="int" Mode="In" />
- <Parameter Name="PageSize" Type="int" Mode="In" />
- <Parameter Name="Fields" Type="varchar" Mode="In" />
- <Parameter Name="Filter" Type="varchar" Mode="In" />
- </Function>
- <EntityContainer Name="wk_dbModelStoreContainer">
- <EntitySet Name="COM_CONTENT" EntityType="Self.COM_CONTENT" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="COM_CUSCONTACT" EntityType="Self.COM_CUSCONTACT" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="COM_DOWNLOAD" EntityType="Self.COM_DOWNLOAD" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="COM_FLOWINFO" EntityType="Self.COM_FLOWINFO" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="COM_INDEX" EntityType="Self.COM_INDEX" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="COM_UPLOAD" EntityType="Self.COM_UPLOAD" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_BEUSER" EntityType="Self.SYS_BEUSER" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_CODE" EntityType="Self.SYS_CODE" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_CODE_AREA" EntityType="Self.SYS_CODE_AREA" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_DISTRIBUTORS" EntityType="Self.SYS_DISTRIBUTORS" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_LOG" EntityType="Self.SYS_LOG" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_MODULE" EntityType="Self.SYS_MODULE" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_MSG" EntityType="Self.SYS_MSG" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_MSGATTACH" EntityType="Self.SYS_MSGATTACH" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_MSGREV" EntityType="Self.SYS_MSGREV" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_PERMISSION" EntityType="Self.SYS_PERMISSION" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_POST" EntityType="Self.SYS_POST" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_POST_DEPARTMENT" EntityType="Self.SYS_POST_DEPARTMENT" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_POST_USER" EntityType="Self.SYS_POST_USER" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_ROLE" EntityType="Self.SYS_ROLE" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_ROLE_PERMISSION" EntityType="Self.SYS_ROLE_PERMISSION" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_SMS" EntityType="Self.SYS_SMS" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_SYSTEM" EntityType="Self.SYS_SYSTEM" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_USER" EntityType="Self.SYS_USER" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_USER_DEPARTMENT" EntityType="Self.SYS_USER_DEPARTMENT" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_USER_PERMISSION" EntityType="Self.SYS_USER_PERMISSION" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_USER_ROLE" EntityType="Self.SYS_USER_ROLE" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_USERINFO" EntityType="Self.SYS_USERINFO" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_WEBCHAT" EntityType="Self.SYS_WEBCHAT" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="YW_Bicycle" EntityType="Self.YW_Bicycle" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="YW_CarParamDetails" EntityType="Self.YW_CarParamDetails" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="YW_CarPurchaser" EntityType="Self.YW_CarPurchaser" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="YW_Notice" EntityType="Self.YW_Notice" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="YW_User_Notice" EntityType="Self.YW_User_Notice" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="YW_UserCar" EntityType="Self.YW_UserCar" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="YW_UserDistributor" EntityType="Self.YW_UserDistributor" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="YW_UserToken" EntityType="Self.YW_UserToken" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SYS_ONLINE" EntityType="Self.SYS_ONLINE" store:Type="Tables" store:Schema="dbo">
- <DefiningQuery>SELECT
- [SYS_ONLINE].[ID] AS [ID],
- [SYS_ONLINE].[LOGINTIME] AS [LOGINTIME],
- [SYS_ONLINE].[TIMEOUTTIME] AS [TIMEOUTTIME],
- [SYS_ONLINE].[COOKIEID] AS [COOKIEID],
- [SYS_ONLINE].[ACCOUNT] AS [ACCOUNT],
- [SYS_ONLINE].[LASTACCESSTIME] AS [LASTACCESSTIME],
- [SYS_ONLINE].[STATE] AS [STATE],
- [SYS_ONLINE].[USERID] AS [USERID],
- [SYS_ONLINE].[NAME] AS [NAME]
- FROM [dbo].[SYS_ONLINE] AS [SYS_ONLINE]</DefiningQuery>
- </EntitySet>
- <AssociationSet Name="FK_SYS_MODULE_SYSTEMID" Association="Self.FK_SYS_MODULE_SYSTEMID">
- <End Role="SYS_SYSTEM" EntitySet="SYS_SYSTEM" />
- <End Role="SYS_MODULE" EntitySet="SYS_MODULE" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_PERMISSION_MODULEID" Association="Self.FK_SYS_PERMISSION_MODULEID">
- <End Role="SYS_MODULE" EntitySet="SYS_MODULE" />
- <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_POST_DEPARTMENT_DPTID" Association="Self.FK_SYS_POST_DEPARTMENT_DPTID">
- <End Role="SYS_DISTRIBUTORS" EntitySet="SYS_DISTRIBUTORS" />
- <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_POST_DEPARTMENT_POSTID" Association="Self.FK_SYS_POST_DEPARTMENT_POSTID">
- <End Role="SYS_POST" EntitySet="SYS_POST" />
- <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_POST_USER_POSTDPTID" Association="Self.FK_SYS_POST_USER_POSTDPTID">
- <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
- <End Role="SYS_POST_USER" EntitySet="SYS_POST_USER" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_POST_USER_USERID" Association="Self.FK_SYS_POST_USER_USERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_POST_USER" EntitySet="SYS_POST_USER" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_ROLE_PERMISSION_PERID" Association="Self.FK_SYS_ROLE_PERMISSION_PERID">
- <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
- <End Role="SYS_ROLE_PERMISSION" EntitySet="SYS_ROLE_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_ROLE_PERMISSION_ROLEID" Association="Self.FK_SYS_ROLE_PERMISSION_ROLEID">
- <End Role="SYS_ROLE" EntitySet="SYS_ROLE" />
- <End Role="SYS_ROLE_PERMISSION" EntitySet="SYS_ROLE_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_DEPARTMENT_DPTID" Association="Self.FK_SYS_USER_DEPARTMENT_DPTID">
- <End Role="SYS_DISTRIBUTORS" EntitySet="SYS_DISTRIBUTORS" />
- <End Role="SYS_USER_DEPARTMENT" EntitySet="SYS_USER_DEPARTMENT" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_DEPARTMENT_USERID" Association="Self.FK_SYS_USER_DEPARTMENT_USERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_USER_DEPARTMENT" EntitySet="SYS_USER_DEPARTMENT" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_PERMISSION_PERID" Association="Self.FK_SYS_USER_PERMISSION_PERID">
- <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
- <End Role="SYS_USER_PERMISSION" EntitySet="SYS_USER_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_PERMISSION_USERID" Association="Self.FK_SYS_USER_PERMISSION_USERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_USER_PERMISSION" EntitySet="SYS_USER_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_ROLE_ROLEID" Association="Self.FK_SYS_USER_ROLE_ROLEID">
- <End Role="SYS_ROLE" EntitySet="SYS_ROLE" />
- <End Role="SYS_USER_ROLE" EntitySet="SYS_USER_ROLE" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_ROLE_USERID" Association="Self.FK_SYS_USER_ROLE_USERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_USER_ROLE" EntitySet="SYS_USER_ROLE" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USERINFO_SYSUSERID" Association="Self.FK_SYS_USERINFO_SYSUSERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_USERINFO" EntitySet="SYS_USERINFO" />
- </AssociationSet>
- </EntityContainer>
- </Schema></edmx:StorageModels>
- <!-- CSDL content -->
- <edmx:ConceptualModels>
- <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">
- <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
- <FunctionImport Name="PaginationByRowNumber">
- <Parameter Name="Table" Mode="In" Type="String" />
- <Parameter Name="Sort" Mode="In" Type="String" />
- <Parameter Name="CurrentPage" Mode="In" Type="Int32" />
- <Parameter Name="PageSize" Mode="In" Type="Int32" />
- <Parameter Name="Fields" Mode="In" Type="String" />
- <Parameter Name="Filter" Mode="In" Type="String" />
- </FunctionImport>
- <EntitySet Name="COM_CONTENT" EntityType="wk_dbModel.COM_CONTENT" />
- <EntitySet Name="COM_CUSCONTACT" EntityType="wk_dbModel.COM_CUSCONTACT" />
- <EntitySet Name="COM_DOWNLOAD" EntityType="wk_dbModel.COM_DOWNLOAD" />
- <EntitySet Name="COM_FLOWINFO" EntityType="wk_dbModel.COM_FLOWINFO" />
- <EntitySet Name="COM_INDEX" EntityType="wk_dbModel.COM_INDEX" />
- <EntitySet Name="COM_UPLOAD" EntityType="wk_dbModel.COM_UPLOAD" />
- <EntitySet Name="SYS_BEUSER" EntityType="wk_dbModel.SYS_BEUSER" />
- <EntitySet Name="SYS_CODE" EntityType="wk_dbModel.SYS_CODE" />
- <EntitySet Name="SYS_CODE_AREA" EntityType="wk_dbModel.SYS_CODE_AREA" />
- <EntitySet Name="SYS_LOG" EntityType="wk_dbModel.SYS_LOG" />
- <EntitySet Name="SYS_MODULE" EntityType="wk_dbModel.SYS_MODULE" />
- <EntitySet Name="SYS_MSG" EntityType="wk_dbModel.SYS_MSG" />
- <EntitySet Name="SYS_MSGATTACH" EntityType="wk_dbModel.SYS_MSGATTACH" />
- <EntitySet Name="SYS_MSGREV" EntityType="wk_dbModel.SYS_MSGREV" />
- <EntitySet Name="SYS_PERMISSION" EntityType="wk_dbModel.SYS_PERMISSION" />
- <EntitySet Name="SYS_POST" EntityType="wk_dbModel.SYS_POST" />
- <EntitySet Name="SYS_POST_DEPARTMENT" EntityType="wk_dbModel.SYS_POST_DEPARTMENT" />
- <EntitySet Name="SYS_POST_USER" EntityType="wk_dbModel.SYS_POST_USER" />
- <EntitySet Name="SYS_ROLE" EntityType="wk_dbModel.SYS_ROLE" />
- <EntitySet Name="SYS_ROLE_PERMISSION" EntityType="wk_dbModel.SYS_ROLE_PERMISSION" />
- <EntitySet Name="SYS_SMS" EntityType="wk_dbModel.SYS_SMS" />
- <EntitySet Name="SYS_SYSTEM" EntityType="wk_dbModel.SYS_SYSTEM" />
- <EntitySet Name="SYS_USER" EntityType="wk_dbModel.SYS_USER" />
- <EntitySet Name="SYS_USER_DEPARTMENT" EntityType="wk_dbModel.SYS_USER_DEPARTMENT" />
- <EntitySet Name="SYS_USER_PERMISSION" EntityType="wk_dbModel.SYS_USER_PERMISSION" />
- <EntitySet Name="SYS_USER_ROLE" EntityType="wk_dbModel.SYS_USER_ROLE" />
- <EntitySet Name="SYS_USERINFO" EntityType="wk_dbModel.SYS_USERINFO" />
- <EntitySet Name="SYS_WEBCHAT" EntityType="wk_dbModel.SYS_WEBCHAT" />
- <EntitySet Name="YW_Bicycle" EntityType="wk_dbModel.YW_Bicycle" />
- <EntitySet Name="YW_CarParamDetails" EntityType="wk_dbModel.YW_CarParamDetails" />
- <EntitySet Name="YW_CarPurchaser" EntityType="wk_dbModel.YW_CarPurchaser" />
- <EntitySet Name="YW_Notice" EntityType="wk_dbModel.YW_Notice" />
- <EntitySet Name="YW_User_Notice" EntityType="wk_dbModel.YW_User_Notice" />
- <EntitySet Name="YW_UserCar" EntityType="wk_dbModel.YW_UserCar" />
- <EntitySet Name="YW_UserDistributor" EntityType="wk_dbModel.YW_UserDistributor" />
- <EntitySet Name="YW_UserToken" EntityType="wk_dbModel.YW_UserToken" />
- <EntitySet Name="SYS_ONLINE" EntityType="wk_dbModel.SYS_ONLINE" />
- <AssociationSet Name="FK_SYS_MODULE_SYSTEMID" Association="wk_dbModel.FK_SYS_MODULE_SYSTEMID">
- <End Role="SYS_SYSTEM" EntitySet="SYS_SYSTEM" />
- <End Role="SYS_MODULE" EntitySet="SYS_MODULE" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_PERMISSION_MODULEID" Association="wk_dbModel.FK_SYS_PERMISSION_MODULEID">
- <End Role="SYS_MODULE" EntitySet="SYS_MODULE" />
- <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_ROLE_PERMISSION_PERID" Association="wk_dbModel.FK_SYS_ROLE_PERMISSION_PERID">
- <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
- <End Role="SYS_ROLE_PERMISSION" EntitySet="SYS_ROLE_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_PERMISSION_PERID" Association="wk_dbModel.FK_SYS_USER_PERMISSION_PERID">
- <End Role="SYS_PERMISSION" EntitySet="SYS_PERMISSION" />
- <End Role="SYS_USER_PERMISSION" EntitySet="SYS_USER_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_POST_DEPARTMENT_POSTID" Association="wk_dbModel.FK_SYS_POST_DEPARTMENT_POSTID">
- <End Role="SYS_POST" EntitySet="SYS_POST" />
- <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_POST_USER_POSTDPTID" Association="wk_dbModel.FK_SYS_POST_USER_POSTDPTID">
- <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
- <End Role="SYS_POST_USER" EntitySet="SYS_POST_USER" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_POST_USER_USERID" Association="wk_dbModel.FK_SYS_POST_USER_USERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_POST_USER" EntitySet="SYS_POST_USER" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_ROLE_PERMISSION_ROLEID" Association="wk_dbModel.FK_SYS_ROLE_PERMISSION_ROLEID">
- <End Role="SYS_ROLE" EntitySet="SYS_ROLE" />
- <End Role="SYS_ROLE_PERMISSION" EntitySet="SYS_ROLE_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_ROLE_ROLEID" Association="wk_dbModel.FK_SYS_USER_ROLE_ROLEID">
- <End Role="SYS_ROLE" EntitySet="SYS_ROLE" />
- <End Role="SYS_USER_ROLE" EntitySet="SYS_USER_ROLE" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_DEPARTMENT_USERID" Association="wk_dbModel.FK_SYS_USER_DEPARTMENT_USERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_USER_DEPARTMENT" EntitySet="SYS_USER_DEPARTMENT" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_PERMISSION_USERID" Association="wk_dbModel.FK_SYS_USER_PERMISSION_USERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_USER_PERMISSION" EntitySet="SYS_USER_PERMISSION" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_ROLE_USERID" Association="wk_dbModel.FK_SYS_USER_ROLE_USERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_USER_ROLE" EntitySet="SYS_USER_ROLE" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USERINFO_SYSUSERID" Association="wk_dbModel.FK_SYS_USERINFO_SYSUSERID">
- <End Role="SYS_USER" EntitySet="SYS_USER" />
- <End Role="SYS_USERINFO" EntitySet="SYS_USERINFO" />
- </AssociationSet>
- <EntitySet Name="SYS_DISTRIBUTORS" EntityType="wk_dbModel.SYS_DISTRIBUTORS" />
- <AssociationSet Name="FK_SYS_POST_DEPARTMENT_DPTID" Association="wk_dbModel.FK_SYS_POST_DEPARTMENT_DPTID">
- <End Role="SYS_DISTRIBUTORS" EntitySet="SYS_DISTRIBUTORS" />
- <End Role="SYS_POST_DEPARTMENT" EntitySet="SYS_POST_DEPARTMENT" />
- </AssociationSet>
- <AssociationSet Name="FK_SYS_USER_DEPARTMENT_DPTID" Association="wk_dbModel.FK_SYS_USER_DEPARTMENT_DPTID">
- <End Role="SYS_DISTRIBUTORS" EntitySet="SYS_DISTRIBUTORS" />
- <End Role="SYS_USER_DEPARTMENT" EntitySet="SYS_USER_DEPARTMENT" />
- </AssociationSet>
- </EntityContainer>
- <EntityType Name="COM_CONTENT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="FK_RELATIONID" Type="String" Nullable="false" MaxLength="72" FixedLength="false" Unicode="true" />
- <Property Name="CONTENT" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="CONTENTBLOB" Type="Binary" MaxLength="Max" FixedLength="false" />
- <Property Name="FK_TABLE" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Nullable="false" Precision="0" />
- <Property Name="ISDEL" Type="Int32" Nullable="false" />
- </EntityType>
- <EntityType Name="COM_CUSCONTACT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="SEX" Type="Int32" />
- <Property Name="PHOME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="TELNO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="SECONDPHONE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="QQ" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="EMAIL" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="WX" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="COMPANY" Type="String" MaxLength="300" FixedLength="false" Unicode="true" />
- <Property Name="COMPADDRESS" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
- <Property Name="ZW" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="ADDRESS" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
- <Property Name="PROV" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="CITY" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="REMARK" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
- <Property Name="FK_USERID" Type="Int32" Nullable="false" />
- <Property Name="CREATETIME" Type="DateTime" Nullable="false" Precision="3" />
- <Property Name="FK_TYPE" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- </EntityType>
- <EntityType Name="COM_DOWNLOAD">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="FK_USERID" Type="Int32" />
- <Property Name="DLOPERATOR" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="DLIP" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
- <Property Name="DLNUM" Type="Int32" />
- <Property Name="FK_UPID" Type="String" MaxLength="72" FixedLength="false" Unicode="true" />
- <Property Name="DLDATE" Type="DateTime" Precision="3" />
- </EntityType>
- <EntityType Name="COM_FLOWINFO">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="FLOWNO" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="PATH" Type="String" Nullable="false" MaxLength="1000" FixedLength="false" Unicode="true" />
- <Property Name="SHOW" Type="String" Nullable="false" MaxLength="1000" FixedLength="false" Unicode="true" />
- <Property Name="TABLENAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="REMARK" Type="String" Nullable="false" MaxLength="400" FixedLength="false" Unicode="true" />
- <Property Name="CREATETIME" Type="DateTime" Nullable="false" Precision="3" />
- <Property Name="CREATEUSER" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="UPDATETIME" Type="DateTime" Nullable="false" Precision="3" />
- <Property Name="UPDATEUSER" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
- </EntityType>
- <EntityType Name="COM_INDEX">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="TITLE" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="ICON" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="COLOR" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="BACKGROUNDCOLOR" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="SHOWORDER" Type="Int32" Nullable="false" />
- <Property Name="PATH" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
- <Property Name="SHOWTYPE" Type="Int32" Nullable="false" />
- </EntityType>
- <EntityType Name="COM_UPLOAD">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="FK_USERID" Type="String" MaxLength="72" FixedLength="false" Unicode="true" />
- <Property Name="UPOPEATOR" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="UPTIME" Type="DateTime" Precision="3" />
- <Property Name="UPOLDNAME" Type="String" MaxLength="400" FixedLength="false" Unicode="true" />
- <Property Name="UPNEWNAME" Type="String" MaxLength="400" FixedLength="false" Unicode="true" />
- <Property Name="UPFILESIZE" Type="Int32" />
- <Property Name="UPFILEUNIT" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="UPFILEPATH" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
- <Property Name="UPFILESUFFIX" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
- <Property Name="UPFILETHUMBNAIL" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
- <Property Name="UPFILETHUMBNAILFORPAD" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
- <Property Name="UPFILETHUMBNAILFORPHONE" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
- <Property Name="UPFILEIP" Type="String" MaxLength="40" FixedLength="false" Unicode="true" />
- <Property Name="UPFILEURL" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
- </EntityType>
- <EntityType Name="SYS_BEUSER">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="72" FixedLength="false" Unicode="true" />
- <Property Name="FK_USERID" Type="String" Nullable="false" MaxLength="72" FixedLength="false" Unicode="true" />
- <Property Name="FK_TOUSER" Type="String" Nullable="false" MaxLength="72" FixedLength="false" Unicode="true" />
- <Property Name="TONUMBER" Type="Decimal" Nullable="false" Precision="20" Scale="0" />
- <Property Name="CREATETIME" Type="DateTime" Nullable="false" Precision="0" />
- </EntityType>
- <EntityType Name="SYS_CODE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="CODETYPE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="NAMETEXT" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="CODEVALUE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="SHOWORDER" Type="Int32" />
- <Property Name="ISCODE" Type="Int32" />
- <Property Name="REMARK" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
- <Property Name="CREATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
- <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="PARENTID" Type="Int32" />
- </EntityType>
- <EntityType Name="SYS_CODE_AREA">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="PID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="LEVELS" Type="Byte" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_LOG">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="DATES" Type="DateTime" Precision="3" />
- <Property Name="LEVELS" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="LOGGER" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="CLIENTUSER" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="CLIENTIP" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="REQUESTURL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
- <Property Name="ACTION" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="MESSAGE" Type="String" MaxLength="4000" FixedLength="false" Unicode="true" />
- <Property Name="EXCEPTION" Type="String" MaxLength="4000" FixedLength="false" Unicode="true" />
- </EntityType>
- <EntityType Name="SYS_MODULE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="FK_BELONGSYSTEM" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="PARENTID" Type="Int32" Nullable="false" />
- <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="ALIAS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="MODULETYPE" Type="Int32" Nullable="false" />
- <Property Name="ICON" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="MODULEPATH" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
- <Property Name="ISSHOW" Type="Int32" Nullable="false" />
- <Property Name="SHOWORDER" Type="Int32" Nullable="false" />
- <Property Name="LEVELS" Type="Int32" Nullable="false" />
- <Property Name="CREATEUSER" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
- <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
- <NavigationProperty Name="SYS_SYSTEM" Relationship="wk_dbModel.FK_SYS_MODULE_SYSTEMID" FromRole="SYS_MODULE" ToRole="SYS_SYSTEM" />
- <NavigationProperty Name="SYS_PERMISSION" Relationship="wk_dbModel.FK_SYS_PERMISSION_MODULEID" FromRole="SYS_MODULE" ToRole="SYS_PERMISSION" />
- </EntityType>
- <EntityType Name="SYS_MSG">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="MSGNAME" Type="String" Nullable="false" MaxLength="400" FixedLength="false" Unicode="true" />
- <Property Name="MSGTYPE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="CREATEPER" Type="Int32" Nullable="false" />
- <Property Name="CREATEDATE" Type="DateTime" Nullable="false" Precision="3" />
- <Property Name="DELETESTATUS" Type="Int32" Nullable="false" />
- <Property Name="MSGCONTENT" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
- </EntityType>
- <EntityType Name="SYS_MSGATTACH">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="MSGID" Type="Int32" />
- <Property Name="FK_UPLOADID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
- </EntityType>
- <EntityType Name="SYS_MSGREV">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="MSGID" Type="Int32" Nullable="false" />
- <Property Name="USERID" Type="Int32" Nullable="false" />
- <Property Name="READSTATUS" Type="Int32" Nullable="false" />
- <Property Name="DELETESTATUS" Type="Int32" Nullable="false" />
- </EntityType>
- <EntityType Name="SYS_PERMISSION">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="MODULEID" Type="Int32" Nullable="false" />
- <Property Name="NAME" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="PERVALUE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="ICON" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="SHOWORDER" Type="Int32" />
- <Property Name="CREATEDATE" Type="DateTime" Precision="0" />
- <Property Name="CREATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="UPDATEDATE" Type="DateTime" Precision="0" />
- <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="SYS_MODULE" Relationship="wk_dbModel.FK_SYS_PERMISSION_MODULEID" FromRole="SYS_PERMISSION" ToRole="SYS_MODULE" />
- <NavigationProperty Name="SYS_ROLE_PERMISSION" Relationship="wk_dbModel.FK_SYS_ROLE_PERMISSION_PERID" FromRole="SYS_PERMISSION" ToRole="SYS_ROLE_PERMISSION" />
- <NavigationProperty Name="SYS_USER_PERMISSION" Relationship="wk_dbModel.FK_SYS_USER_PERMISSION_PERID" FromRole="SYS_PERMISSION" ToRole="SYS_USER_PERMISSION" />
- </EntityType>
- <EntityType Name="SYS_POST">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="POSTNAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="POSTTYPE" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="REMARK" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
- <Property Name="SHOWORDER" Type="Int32" />
- <Property Name="CREATEUSERID" Type="Int32" />
- <Property Name="CREATEDATE" Type="DateTime" Nullable="false" Precision="3" />
- <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
- <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="SYS_POST_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_POST_DEPARTMENT_POSTID" FromRole="SYS_POST" ToRole="SYS_POST_DEPARTMENT" />
- </EntityType>
- <EntityType Name="SYS_POST_DEPARTMENT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="FK_DEPARTMENT_ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="FK_POST_ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="SYS_POST" Relationship="wk_dbModel.FK_SYS_POST_DEPARTMENT_POSTID" FromRole="SYS_POST_DEPARTMENT" ToRole="SYS_POST" />
- <NavigationProperty Name="SYS_POST_USER" Relationship="wk_dbModel.FK_SYS_POST_USER_POSTDPTID" FromRole="SYS_POST_DEPARTMENT" ToRole="SYS_POST_USER" />
- <NavigationProperty Name="SYS_DISTRIBUTORS" Relationship="wk_dbModel.FK_SYS_POST_DEPARTMENT_DPTID" FromRole="SYS_POST_DEPARTMENT" ToRole="SYS_DISTRIBUTORS" />
- </EntityType>
- <EntityType Name="SYS_POST_USER">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="FK_USERID" Type="Int32" Nullable="false" />
- <Property Name="FK_POST_DEPARTMENTID" Type="Int32" Nullable="false" />
- <NavigationProperty Name="SYS_POST_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_POST_USER_POSTDPTID" FromRole="SYS_POST_USER" ToRole="SYS_POST_DEPARTMENT" />
- <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_POST_USER_USERID" FromRole="SYS_POST_USER" ToRole="SYS_USER" />
- </EntityType>
- <EntityType Name="SYS_ROLE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="ROLENAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="ISCUSTOM" Type="Int32" Nullable="false" />
- <Property Name="ROLEDESC" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
- <Property Name="CREATEPERID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Nullable="false" Precision="3" />
- <Property Name="UPDATEDATE" Type="DateTime" Nullable="false" Precision="3" />
- <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="SYS_ROLE_PERMISSION" Relationship="wk_dbModel.FK_SYS_ROLE_PERMISSION_ROLEID" FromRole="SYS_ROLE" ToRole="SYS_ROLE_PERMISSION" />
- <NavigationProperty Name="SYS_USER_ROLE" Relationship="wk_dbModel.FK_SYS_USER_ROLE_ROLEID" FromRole="SYS_ROLE" ToRole="SYS_USER_ROLE" />
- </EntityType>
- <EntityType Name="SYS_ROLE_PERMISSION">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="ROLEID" Type="Int32" Nullable="false" />
- <Property Name="PERMISSIONID" Type="Int32" Nullable="false" />
- <NavigationProperty Name="SYS_PERMISSION" Relationship="wk_dbModel.FK_SYS_ROLE_PERMISSION_PERID" FromRole="SYS_ROLE_PERMISSION" ToRole="SYS_PERMISSION" />
- <NavigationProperty Name="SYS_ROLE" Relationship="wk_dbModel.FK_SYS_ROLE_PERMISSION_ROLEID" FromRole="SYS_ROLE_PERMISSION" ToRole="SYS_ROLE" />
- </EntityType>
- <EntityType Name="SYS_SMS">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="SENDER" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="SENDTOEMPID" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="RDT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="TEL" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="TELSTA" Type="Decimal" Precision="38" Scale="0" />
- <Property Name="EMAIL" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="EMAISTA" Type="Decimal" Precision="38" Scale="0" />
- <Property Name="TITLE" Type="String" MaxLength="3000" FixedLength="false" Unicode="true" />
- <Property Name="DOC" Type="String" MaxLength="4000" FixedLength="false" Unicode="true" />
- <Property Name="SENDDT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="ISREAD" Type="Decimal" Precision="38" Scale="0" />
- <Property Name="ISALERT" Type="Decimal" Precision="38" Scale="0" />
- <Property Name="MSGFLAG" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="WORKID" Type="Decimal" Precision="38" Scale="0" />
- <Property Name="FLOWNO" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- </EntityType>
- <EntityType Name="SYS_SYSTEM">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="SITEURL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
- <Property Name="IS_LOGIN" Type="Byte" />
- <Property Name="DOCKUSER" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="DOCKPASS" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Precision="0" />
- <Property Name="REMARK" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="SYS_MODULE" Relationship="wk_dbModel.FK_SYS_MODULE_SYSTEMID" FromRole="SYS_SYSTEM" ToRole="SYS_MODULE" />
- </EntityType>
- <EntityType Name="SYS_USER">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="ACCOUNT" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
- <Property Name="PASSWORD" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="PHONE" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="ISCANLOGIN" Type="Boolean" />
- <Property Name="SHOWORDER1" Type="Int32" />
- <Property Name="SHOWORDER2" Type="Int32" />
- <Property Name="VERIFICATION" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
- <Property Name="EXPIRYDATE" Type="DateTime" Precision="3" />
- <Property Name="PINYIN1" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="PINYIN2" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="FACE_IMG" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="LEVELS" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="DPTID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="WORKNUMBER" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="USERTYPE" Type="Int32" />
- <Property Name="ISDEL" Type="Boolean" />
- <Property Name="LANG" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
- <Property Name="CREATEPER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
- <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
- <NavigationProperty Name="SYS_POST_USER" Relationship="wk_dbModel.FK_SYS_POST_USER_USERID" FromRole="SYS_USER" ToRole="SYS_POST_USER" />
- <NavigationProperty Name="SYS_USER_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_USER_DEPARTMENT_USERID" FromRole="SYS_USER" ToRole="SYS_USER_DEPARTMENT" />
- <NavigationProperty Name="SYS_USER_PERMISSION" Relationship="wk_dbModel.FK_SYS_USER_PERMISSION_USERID" FromRole="SYS_USER" ToRole="SYS_USER_PERMISSION" />
- <NavigationProperty Name="SYS_USER_ROLE" Relationship="wk_dbModel.FK_SYS_USER_ROLE_USERID" FromRole="SYS_USER" ToRole="SYS_USER_ROLE" />
- <NavigationProperty Name="SYS_USERINFO" Relationship="wk_dbModel.FK_SYS_USERINFO_SYSUSERID" FromRole="SYS_USER" ToRole="SYS_USERINFO" />
- <Property Name="Location" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- </EntityType>
- <EntityType Name="SYS_USER_DEPARTMENT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="USER_ID" Type="Int32" Nullable="false" />
- <Property Name="DEPARTMENT_ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_USER_DEPARTMENT_USERID" FromRole="SYS_USER_DEPARTMENT" ToRole="SYS_USER" />
- <NavigationProperty Name="SYS_DISTRIBUTORS" Relationship="wk_dbModel.FK_SYS_USER_DEPARTMENT_DPTID" FromRole="SYS_USER_DEPARTMENT" ToRole="SYS_DISTRIBUTORS" />
- </EntityType>
- <EntityType Name="SYS_USER_PERMISSION">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="FK_USERID" Type="Int32" Nullable="false" />
- <Property Name="FK_PERMISSIONID" Type="Int32" Nullable="false" />
- <NavigationProperty Name="SYS_PERMISSION" Relationship="wk_dbModel.FK_SYS_USER_PERMISSION_PERID" FromRole="SYS_USER_PERMISSION" ToRole="SYS_PERMISSION" />
- <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_USER_PERMISSION_USERID" FromRole="SYS_USER_PERMISSION" ToRole="SYS_USER" />
- </EntityType>
- <EntityType Name="SYS_USER_ROLE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="FK_USERID" Type="Int32" Nullable="false" />
- <Property Name="FK_ROLEID" Type="Int32" Nullable="false" />
- <NavigationProperty Name="SYS_ROLE" Relationship="wk_dbModel.FK_SYS_USER_ROLE_ROLEID" FromRole="SYS_USER_ROLE" ToRole="SYS_ROLE" />
- <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_USER_ROLE_USERID" FromRole="SYS_USER_ROLE" ToRole="SYS_USER" />
- </EntityType>
- <EntityType Name="SYS_USERINFO">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="USERID" Type="Int32" Nullable="false" />
- <Property Name="POSTCODE" Type="Int32" />
- <Property Name="PHONE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="OFFICEPHONE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="EMAILADDRESS" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="SECONDPHONE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="WORKCODE" Type="Int32" />
- <Property Name="SEXCODE" Type="Int32" />
- <Property Name="BIRTHDAY" Type="DateTime" Precision="3" />
- <Property Name="NATIONCODE" Type="Int32" />
- <Property Name="IDNUMBER" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
- <Property Name="MARRYCODE" Type="Int32" />
- <Property Name="IDENTITYCODE" Type="Int32" />
- <Property Name="HomeTown" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="ACCOUNTLOCATION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="XUELI" Type="Int32" />
- <Property Name="ZHICHENG" Type="Int32" />
- <Property Name="GRADUATIONSCHOOL" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="SPECIALTY" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="PHOTOOLDNAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="PHOTONEWNAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="PHOTOTYPE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="RESUMEOLDNAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="RESUMENEWNAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="RESUMETYPE" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="HuJiSuoZaiDi" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="HUJIPAICHUSUO" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="WORKDATE" Type="DateTime" Precision="3" />
- <Property Name="JINRUDATE" Type="DateTime" Precision="3" />
- <Property Name="CARNUMBER" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="QQ" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
- <Property Name="WEBCHATOPENID" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Precision="3" />
- <Property Name="CREATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="UPDATEDATE" Type="DateTime" Precision="3" />
- <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="SYS_USER" Relationship="wk_dbModel.FK_SYS_USERINFO_SYSUSERID" FromRole="SYS_USERINFO" ToRole="SYS_USER" />
- </EntityType>
- <EntityType Name="SYS_WEBCHAT">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="OPENID" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="SMSCODE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="CREATETIME" Type="DateTime" Precision="0" />
- <Property Name="SENDTIME" Type="DateTime" Precision="0" />
- <Property Name="TELPHONE" Type="String" MaxLength="11" FixedLength="false" Unicode="true" />
- </EntityType>
- <EntityType Name="YW_Bicycle">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Guid" Nullable="false" />
- <Property Name="UserId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="DistributorsID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="DistributorsName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="CarID" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
- <Property Name="CarModel" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
- <Property Name="CarNumber" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
- <Property Name="carBar" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="CarName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="productionDate" Type="DateTime" Precision="3" />
- <Property Name="LeaseStatus" Type="Int32" />
- <Property Name="CarSate" Type="Int32" />
- <Property Name="lang" Type="String" MaxLength="60" FixedLength="false" Unicode="true" />
- <Property Name="carType" Type="Int32" />
- <Property Name="Createper" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="CreateDate" Type="DateTime" Precision="3" />
- <Property Name="UpdateUser" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="UpdateDate" Type="DateTime" Precision="3" />
- <Property Name="LockState" Type="Boolean" />
- <Property Name="OutDate" Type="DateTime" Precision="3" />
- <Property Name="InputDate" Type="DateTime" Precision="3" />
- <Property Name="SaleDate" Type="DateTime" Precision="3" />
- <Property Name="IMSI" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="ICCID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="SalesId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="WarehouseID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="WarehouseName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="FenceState" Type="Int32" />
- <Property Name="CustomerCode" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="CustomerName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="FactoryNumber" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="ProductLine" Type="Int32" />
- <Property Name="smallClass" Type="Int32" />
- <Property Name="OutFenceDate" Type="DateTime" Precision="3" />
- <Property Name="InFenceDate" Type="DateTime" Precision="3" />
- <Property Name="IsLockable" Type="Boolean" />
- </EntityType>
- <EntityType Name="YW_CarParamDetails">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Guid" Nullable="false" />
- <Property Name="imei" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="hydraulic" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="temperature" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="voltage" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="speed" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="timestamp" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="cartype" Type="Int32" />
- <Property Name="add_time" Type="DateTime" Precision="3" />
- </EntityType>
- <EntityType Name="YW_CarPurchaser">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Guid" Nullable="false" />
- <Property Name="carId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="carBar" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="imei" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="userName" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="userTel" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="userAddress" Type="String" MaxLength="150" FixedLength="false" Unicode="true" />
- <Property Name="userCode" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="addDate" Type="DateTime" Precision="3" />
- <Property Name="addName" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="updateDate" Type="DateTime" Precision="3" />
- <Property Name="updateName" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="distributorsID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="SaleDate" Type="DateTime" Precision="3" />
- </EntityType>
- <EntityType Name="YW_Notice">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Guid" Nullable="false" />
- <Property Name="Title" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="Content" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
- <Property Name="RoleId" Type="Int32" />
- <Property Name="Noticetype" Type="Int32" />
- <Property Name="IsRead" Type="Boolean" />
- <Property Name="IsDel" Type="Boolean" />
- <Property Name="createper" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="createDate" Type="DateTime" Precision="3" />
- <Property Name="updateUser" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="updateDate" Type="DateTime" Precision="3" />
- <Property Name="ImgUrl" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- </EntityType>
- <EntityType Name="YW_User_Notice">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Guid" Nullable="false" />
- <Property Name="userID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
- <Property Name="noticeID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
- </EntityType>
- <EntityType Name="YW_UserCar">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Guid" Nullable="false" />
- <Property Name="userId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="carId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="note" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="add_time" Type="DateTime" Precision="3" />
- <Property Name="add_name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="update_time" Type="DateTime" Precision="3" />
- <Property Name="update_name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="userTel" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="userName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
- <Property Name="userIdentity" Type="Int32" />
- </EntityType>
- <EntityType Name="YW_UserDistributor">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Guid" Nullable="false" />
- <Property Name="userId" Type="Int32" />
- <Property Name="distributorId" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="add_name" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="add_time" Type="DateTime" Precision="3" />
- <Property Name="ProductLine" Type="Int32" />
- <Property Name="ProductLine1" Type="Int32" />
- <Property Name="ProductLine2" Type="Int32" />
- <Property Name="ProductLine3" Type="Int32" />
- <Property Name="ProductLine4" Type="Int32" />
- <Property Name="ProductLine5" Type="Int32" />
- <Property Name="distype" Type="Int32" />
- </EntityType>
- <EntityType Name="YW_UserToken">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="UserType" Type="Int32" />
- <Property Name="UserToken" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="UID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="AddTime" Type="DateTime" Precision="3" />
- </EntityType>
- <EntityType Name="SYS_ONLINE">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="LOGINTIME" Type="DateTime" Precision="0" />
- <Property Name="TIMEOUTTIME" Type="Decimal" Precision="38" Scale="0" />
- <Property Name="COOKIEID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="ACCOUNT" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="LASTACCESSTIME" Type="DateTime" Precision="0" />
- <Property Name="STATE" Type="Decimal" Precision="38" Scale="0" />
- <Property Name="USERID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- </EntityType>
- <Association Name="FK_SYS_MODULE_SYSTEMID">
- <End Type="wk_dbModel.SYS_SYSTEM" Role="SYS_SYSTEM" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_MODULE" Role="SYS_MODULE" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_SYSTEM">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_MODULE">
- <PropertyRef Name="FK_BELONGSYSTEM" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_PERMISSION_MODULEID">
- <End Type="wk_dbModel.SYS_MODULE" Role="SYS_MODULE" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_PERMISSION" Role="SYS_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_MODULE">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_PERMISSION">
- <PropertyRef Name="MODULEID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_ROLE_PERMISSION_PERID">
- <End Type="wk_dbModel.SYS_PERMISSION" Role="SYS_PERMISSION" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_ROLE_PERMISSION" Role="SYS_ROLE_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_PERMISSION">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_ROLE_PERMISSION">
- <PropertyRef Name="PERMISSIONID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_PERMISSION_PERID">
- <End Type="wk_dbModel.SYS_PERMISSION" Role="SYS_PERMISSION" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_USER_PERMISSION" Role="SYS_USER_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_PERMISSION">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_PERMISSION">
- <PropertyRef Name="FK_PERMISSIONID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_POST_DEPARTMENT_POSTID">
- <End Type="wk_dbModel.SYS_POST" Role="SYS_POST" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_POST_DEPARTMENT" Role="SYS_POST_DEPARTMENT" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_POST">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_POST_DEPARTMENT">
- <PropertyRef Name="FK_POST_ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_POST_USER_POSTDPTID">
- <End Type="wk_dbModel.SYS_POST_DEPARTMENT" Role="SYS_POST_DEPARTMENT" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_POST_USER" Role="SYS_POST_USER" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_POST_DEPARTMENT">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_POST_USER">
- <PropertyRef Name="FK_POST_DEPARTMENTID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_POST_USER_USERID">
- <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_POST_USER" Role="SYS_POST_USER" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_POST_USER">
- <PropertyRef Name="FK_USERID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_ROLE_PERMISSION_ROLEID">
- <End Type="wk_dbModel.SYS_ROLE" Role="SYS_ROLE" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_ROLE_PERMISSION" Role="SYS_ROLE_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_ROLE">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_ROLE_PERMISSION">
- <PropertyRef Name="ROLEID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_ROLE_ROLEID">
- <End Type="wk_dbModel.SYS_ROLE" Role="SYS_ROLE" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_USER_ROLE" Role="SYS_USER_ROLE" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_ROLE">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_ROLE">
- <PropertyRef Name="FK_ROLEID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_DEPARTMENT_USERID">
- <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_USER_DEPARTMENT" Role="SYS_USER_DEPARTMENT" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_DEPARTMENT">
- <PropertyRef Name="USER_ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_PERMISSION_USERID">
- <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_USER_PERMISSION" Role="SYS_USER_PERMISSION" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_PERMISSION">
- <PropertyRef Name="FK_USERID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_ROLE_USERID">
- <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_USER_ROLE" Role="SYS_USER_ROLE" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_ROLE">
- <PropertyRef Name="FK_USERID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USERINFO_SYSUSERID">
- <End Type="wk_dbModel.SYS_USER" Role="SYS_USER" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_USERINFO" Role="SYS_USERINFO" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_USER">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USERINFO">
- <PropertyRef Name="USERID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <EntityType Name="SYS_DISTRIBUTORS">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="CODE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="BUSINESSLEVEL" Type="Int32" />
- <Property Name="SHOWORDER" Type="Int32" />
- <Property Name="Address" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="PARENTCODE" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="ParentName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="LICENSEURL" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
- <Property Name="LICENSEVALUE" Type="String" MaxLength="4000" FixedLength="false" Unicode="true" />
- <Property Name="PARENTID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="ProvinceCity" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
- <Property Name="Province" Type="Int32" />
- <Property Name="City" Type="Int32" />
- <Property Name="Area" Type="Int32" />
- <Property Name="CREATEPERID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="CREATEDATE" Type="DateTime" Precision="0" />
- <Property Name="UPDATEDATE" Type="DateTime" Precision="0" />
- <Property Name="UPDATEUSER" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="FenceID" Type="String" MaxLength="36" FixedLength="false" Unicode="true" />
- <Property Name="FenceRadius" Type="Int32" />
- <Property Name="Theodolite" Type="String" MaxLength="80" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="SYS_POST_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_POST_DEPARTMENT_DPTID" FromRole="SYS_DISTRIBUTORS" ToRole="SYS_POST_DEPARTMENT" />
- <NavigationProperty Name="SYS_USER_DEPARTMENT" Relationship="wk_dbModel.FK_SYS_USER_DEPARTMENT_DPTID" FromRole="SYS_DISTRIBUTORS" ToRole="SYS_USER_DEPARTMENT" />
- <Property Name="DealerNumber" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
- <Property Name="SaleType" Type="Int32" />
- <Property Name="SaleCar" Type="String" MaxLength="400" FixedLength="false" Unicode="true" />
- <Property Name="Notes" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
- </EntityType>
- <Association Name="FK_SYS_POST_DEPARTMENT_DPTID">
- <End Type="wk_dbModel.SYS_DISTRIBUTORS" Role="SYS_DISTRIBUTORS" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_POST_DEPARTMENT" Role="SYS_POST_DEPARTMENT" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_DISTRIBUTORS">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_POST_DEPARTMENT">
- <PropertyRef Name="FK_DEPARTMENT_ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SYS_USER_DEPARTMENT_DPTID">
- <End Type="wk_dbModel.SYS_DISTRIBUTORS" Role="SYS_DISTRIBUTORS" Multiplicity="1" />
- <End Type="wk_dbModel.SYS_USER_DEPARTMENT" Role="SYS_USER_DEPARTMENT" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SYS_DISTRIBUTORS">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SYS_USER_DEPARTMENT">
- <PropertyRef Name="DEPARTMENT_ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- </Schema>
- </edmx:ConceptualModels>
- <!-- C-S mapping content -->
- <edmx:Mappings>
- <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
- <EntityContainerMapping StorageEntityContainer="wk_dbModelStoreContainer" CdmEntityContainer="Entities">
- <FunctionImportMapping FunctionImportName="PaginationByRowNumber" FunctionName="wk_dbModel.Store.PaginationByRowNumber" />
- <EntitySetMapping Name="COM_CONTENT">
- <EntityTypeMapping TypeName="wk_dbModel.COM_CONTENT">
- <MappingFragment StoreEntitySet="COM_CONTENT">
- <ScalarProperty Name="ISDEL" ColumnName="ISDEL" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="FK_TABLE" ColumnName="FK_TABLE" />
- <ScalarProperty Name="CONTENTBLOB" ColumnName="CONTENTBLOB" />
- <ScalarProperty Name="CONTENT" ColumnName="CONTENT" />
- <ScalarProperty Name="FK_RELATIONID" ColumnName="FK_RELATIONID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="COM_CUSCONTACT">
- <EntityTypeMapping TypeName="wk_dbModel.COM_CUSCONTACT">
- <MappingFragment StoreEntitySet="COM_CUSCONTACT">
- <ScalarProperty Name="FK_TYPE" ColumnName="FK_TYPE" />
- <ScalarProperty Name="CREATETIME" ColumnName="CREATETIME" />
- <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
- <ScalarProperty Name="REMARK" ColumnName="REMARK" />
- <ScalarProperty Name="CITY" ColumnName="CITY" />
- <ScalarProperty Name="PROV" ColumnName="PROV" />
- <ScalarProperty Name="ADDRESS" ColumnName="ADDRESS" />
- <ScalarProperty Name="ZW" ColumnName="ZW" />
- <ScalarProperty Name="COMPADDRESS" ColumnName="COMPADDRESS" />
- <ScalarProperty Name="COMPANY" ColumnName="COMPANY" />
- <ScalarProperty Name="WX" ColumnName="WX" />
- <ScalarProperty Name="EMAIL" ColumnName="EMAIL" />
- <ScalarProperty Name="QQ" ColumnName="QQ" />
- <ScalarProperty Name="SECONDPHONE" ColumnName="SECONDPHONE" />
- <ScalarProperty Name="TELNO" ColumnName="TELNO" />
- <ScalarProperty Name="PHOME" ColumnName="PHOME" />
- <ScalarProperty Name="SEX" ColumnName="SEX" />
- <ScalarProperty Name="NAME" ColumnName="NAME" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="COM_DOWNLOAD">
- <EntityTypeMapping TypeName="wk_dbModel.COM_DOWNLOAD">
- <MappingFragment StoreEntitySet="COM_DOWNLOAD">
- <ScalarProperty Name="DLDATE" ColumnName="DLDATE" />
- <ScalarProperty Name="FK_UPID" ColumnName="FK_UPID" />
- <ScalarProperty Name="DLNUM" ColumnName="DLNUM" />
- <ScalarProperty Name="DLIP" ColumnName="DLIP" />
- <ScalarProperty Name="DLOPERATOR" ColumnName="DLOPERATOR" />
- <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="COM_FLOWINFO">
- <EntityTypeMapping TypeName="wk_dbModel.COM_FLOWINFO">
- <MappingFragment StoreEntitySet="COM_FLOWINFO">
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="UPDATETIME" ColumnName="UPDATETIME" />
- <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
- <ScalarProperty Name="CREATETIME" ColumnName="CREATETIME" />
- <ScalarProperty Name="REMARK" ColumnName="REMARK" />
- <ScalarProperty Name="TABLENAME" ColumnName="TABLENAME" />
- <ScalarProperty Name="SHOW" ColumnName="SHOW" />
- <ScalarProperty Name="PATH" ColumnName="PATH" />
- <ScalarProperty Name="FLOWNO" ColumnName="FLOWNO" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="COM_INDEX">
- <EntityTypeMapping TypeName="wk_dbModel.COM_INDEX">
- <MappingFragment StoreEntitySet="COM_INDEX">
- <ScalarProperty Name="SHOWTYPE" ColumnName="SHOWTYPE" />
- <ScalarProperty Name="PATH" ColumnName="PATH" />
- <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
- <ScalarProperty Name="BACKGROUNDCOLOR" ColumnName="BACKGROUNDCOLOR" />
- <ScalarProperty Name="COLOR" ColumnName="COLOR" />
- <ScalarProperty Name="ICON" ColumnName="ICON" />
- <ScalarProperty Name="TITLE" ColumnName="TITLE" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="COM_UPLOAD">
- <EntityTypeMapping TypeName="wk_dbModel.COM_UPLOAD">
- <MappingFragment StoreEntitySet="COM_UPLOAD">
- <ScalarProperty Name="UPFILEURL" ColumnName="UPFILEURL" />
- <ScalarProperty Name="UPFILEIP" ColumnName="UPFILEIP" />
- <ScalarProperty Name="UPFILETHUMBNAILFORPHONE" ColumnName="UPFILETHUMBNAILFORPHONE" />
- <ScalarProperty Name="UPFILETHUMBNAILFORPAD" ColumnName="UPFILETHUMBNAILFORPAD" />
- <ScalarProperty Name="UPFILETHUMBNAIL" ColumnName="UPFILETHUMBNAIL" />
- <ScalarProperty Name="UPFILESUFFIX" ColumnName="UPFILESUFFIX" />
- <ScalarProperty Name="UPFILEPATH" ColumnName="UPFILEPATH" />
- <ScalarProperty Name="UPFILEUNIT" ColumnName="UPFILEUNIT" />
- <ScalarProperty Name="UPFILESIZE" ColumnName="UPFILESIZE" />
- <ScalarProperty Name="UPNEWNAME" ColumnName="UPNEWNAME" />
- <ScalarProperty Name="UPOLDNAME" ColumnName="UPOLDNAME" />
- <ScalarProperty Name="UPTIME" ColumnName="UPTIME" />
- <ScalarProperty Name="UPOPEATOR" ColumnName="UPOPEATOR" />
- <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_BEUSER">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_BEUSER">
- <MappingFragment StoreEntitySet="SYS_BEUSER">
- <ScalarProperty Name="CREATETIME" ColumnName="CREATETIME" />
- <ScalarProperty Name="TONUMBER" ColumnName="TONUMBER" />
- <ScalarProperty Name="FK_TOUSER" ColumnName="FK_TOUSER" />
- <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_CODE">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_CODE">
- <MappingFragment StoreEntitySet="SYS_CODE">
- <ScalarProperty Name="PARENTID" ColumnName="PARENTID" />
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
- <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="REMARK" ColumnName="REMARK" />
- <ScalarProperty Name="ISCODE" ColumnName="ISCODE" />
- <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
- <ScalarProperty Name="CODEVALUE" ColumnName="CODEVALUE" />
- <ScalarProperty Name="NAMETEXT" ColumnName="NAMETEXT" />
- <ScalarProperty Name="CODETYPE" ColumnName="CODETYPE" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_CODE_AREA">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_CODE_AREA">
- <MappingFragment StoreEntitySet="SYS_CODE_AREA">
- <ScalarProperty Name="LEVELS" ColumnName="LEVELS" />
- <ScalarProperty Name="NAME" ColumnName="NAME" />
- <ScalarProperty Name="PID" ColumnName="PID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_LOG">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_LOG">
- <MappingFragment StoreEntitySet="SYS_LOG">
- <ScalarProperty Name="EXCEPTION" ColumnName="EXCEPTION" />
- <ScalarProperty Name="MESSAGE" ColumnName="MESSAGE" />
- <ScalarProperty Name="ACTION" ColumnName="ACTION" />
- <ScalarProperty Name="REQUESTURL" ColumnName="REQUESTURL" />
- <ScalarProperty Name="CLIENTIP" ColumnName="CLIENTIP" />
- <ScalarProperty Name="CLIENTUSER" ColumnName="CLIENTUSER" />
- <ScalarProperty Name="LOGGER" ColumnName="LOGGER" />
- <ScalarProperty Name="LEVELS" ColumnName="LEVELS" />
- <ScalarProperty Name="DATES" ColumnName="DATES" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_MODULE">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_MODULE">
- <MappingFragment StoreEntitySet="SYS_MODULE">
- <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
- <ScalarProperty Name="LEVELS" ColumnName="LEVELS" />
- <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
- <ScalarProperty Name="ISSHOW" ColumnName="ISSHOW" />
- <ScalarProperty Name="MODULEPATH" ColumnName="MODULEPATH" />
- <ScalarProperty Name="ICON" ColumnName="ICON" />
- <ScalarProperty Name="MODULETYPE" ColumnName="MODULETYPE" />
- <ScalarProperty Name="ALIAS" ColumnName="ALIAS" />
- <ScalarProperty Name="NAME" ColumnName="NAME" />
- <ScalarProperty Name="PARENTID" ColumnName="PARENTID" />
- <ScalarProperty Name="FK_BELONGSYSTEM" ColumnName="FK_BELONGSYSTEM" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_MSG">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_MSG">
- <MappingFragment StoreEntitySet="SYS_MSG">
- <ScalarProperty Name="MSGCONTENT" ColumnName="MSGCONTENT" />
- <ScalarProperty Name="DELETESTATUS" ColumnName="DELETESTATUS" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="CREATEPER" ColumnName="CREATEPER" />
- <ScalarProperty Name="MSGTYPE" ColumnName="MSGTYPE" />
- <ScalarProperty Name="MSGNAME" ColumnName="MSGNAME" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_MSGATTACH">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_MSGATTACH">
- <MappingFragment StoreEntitySet="SYS_MSGATTACH">
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="FK_UPLOADID" ColumnName="FK_UPLOADID" />
- <ScalarProperty Name="MSGID" ColumnName="MSGID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_MSGREV">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_MSGREV">
- <MappingFragment StoreEntitySet="SYS_MSGREV">
- <ScalarProperty Name="DELETESTATUS" ColumnName="DELETESTATUS" />
- <ScalarProperty Name="READSTATUS" ColumnName="READSTATUS" />
- <ScalarProperty Name="USERID" ColumnName="USERID" />
- <ScalarProperty Name="MSGID" ColumnName="MSGID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_PERMISSION">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_PERMISSION">
- <MappingFragment StoreEntitySet="SYS_PERMISSION">
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
- <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
- <ScalarProperty Name="ICON" ColumnName="ICON" />
- <ScalarProperty Name="PERVALUE" ColumnName="PERVALUE" />
- <ScalarProperty Name="NAME" ColumnName="NAME" />
- <ScalarProperty Name="MODULEID" ColumnName="MODULEID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_POST">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_POST">
- <MappingFragment StoreEntitySet="SYS_POST">
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="CREATEUSERID" ColumnName="CREATEUSERID" />
- <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
- <ScalarProperty Name="REMARK" ColumnName="REMARK" />
- <ScalarProperty Name="POSTTYPE" ColumnName="POSTTYPE" />
- <ScalarProperty Name="POSTNAME" ColumnName="POSTNAME" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_POST_DEPARTMENT">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_POST_DEPARTMENT">
- <MappingFragment StoreEntitySet="SYS_POST_DEPARTMENT">
- <ScalarProperty Name="FK_POST_ID" ColumnName="FK_POST_ID" />
- <ScalarProperty Name="FK_DEPARTMENT_ID" ColumnName="FK_DEPARTMENT_ID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_POST_USER">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_POST_USER">
- <MappingFragment StoreEntitySet="SYS_POST_USER">
- <ScalarProperty Name="FK_POST_DEPARTMENTID" ColumnName="FK_POST_DEPARTMENTID" />
- <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_ROLE">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_ROLE">
- <MappingFragment StoreEntitySet="SYS_ROLE">
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="CREATEPERID" ColumnName="CREATEPERID" />
- <ScalarProperty Name="ROLEDESC" ColumnName="ROLEDESC" />
- <ScalarProperty Name="ISCUSTOM" ColumnName="ISCUSTOM" />
- <ScalarProperty Name="ROLENAME" ColumnName="ROLENAME" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_ROLE_PERMISSION">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_ROLE_PERMISSION">
- <MappingFragment StoreEntitySet="SYS_ROLE_PERMISSION">
- <ScalarProperty Name="PERMISSIONID" ColumnName="PERMISSIONID" />
- <ScalarProperty Name="ROLEID" ColumnName="ROLEID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_SMS">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_SMS">
- <MappingFragment StoreEntitySet="SYS_SMS">
- <ScalarProperty Name="FLOWNO" ColumnName="FLOWNO" />
- <ScalarProperty Name="WORKID" ColumnName="WORKID" />
- <ScalarProperty Name="MSGFLAG" ColumnName="MSGFLAG" />
- <ScalarProperty Name="ISALERT" ColumnName="ISALERT" />
- <ScalarProperty Name="ISREAD" ColumnName="ISREAD" />
- <ScalarProperty Name="SENDDT" ColumnName="SENDDT" />
- <ScalarProperty Name="DOC" ColumnName="DOC" />
- <ScalarProperty Name="TITLE" ColumnName="TITLE" />
- <ScalarProperty Name="EMAISTA" ColumnName="EMAISTA" />
- <ScalarProperty Name="EMAIL" ColumnName="EMAIL" />
- <ScalarProperty Name="TELSTA" ColumnName="TELSTA" />
- <ScalarProperty Name="TEL" ColumnName="TEL" />
- <ScalarProperty Name="RDT" ColumnName="RDT" />
- <ScalarProperty Name="SENDTOEMPID" ColumnName="SENDTOEMPID" />
- <ScalarProperty Name="SENDER" ColumnName="SENDER" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_SYSTEM">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_SYSTEM">
- <MappingFragment StoreEntitySet="SYS_SYSTEM">
- <ScalarProperty Name="REMARK" ColumnName="REMARK" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="DOCKPASS" ColumnName="DOCKPASS" />
- <ScalarProperty Name="DOCKUSER" ColumnName="DOCKUSER" />
- <ScalarProperty Name="IS_LOGIN" ColumnName="IS_LOGIN" />
- <ScalarProperty Name="SITEURL" ColumnName="SITEURL" />
- <ScalarProperty Name="NAME" ColumnName="NAME" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_USER">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_USER">
- <MappingFragment StoreEntitySet="SYS_USER">
- <ScalarProperty Name="Location" ColumnName="Location" />
- <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="CREATEPER" ColumnName="CREATEPER" />
- <ScalarProperty Name="LANG" ColumnName="LANG" />
- <ScalarProperty Name="ISDEL" ColumnName="ISDEL" />
- <ScalarProperty Name="USERTYPE" ColumnName="USERTYPE" />
- <ScalarProperty Name="WORKNUMBER" ColumnName="WORKNUMBER" />
- <ScalarProperty Name="DPTID" ColumnName="DPTID" />
- <ScalarProperty Name="LEVELS" ColumnName="LEVELS" />
- <ScalarProperty Name="FACE_IMG" ColumnName="FACE_IMG" />
- <ScalarProperty Name="PINYIN2" ColumnName="PINYIN2" />
- <ScalarProperty Name="PINYIN1" ColumnName="PINYIN1" />
- <ScalarProperty Name="EXPIRYDATE" ColumnName="EXPIRYDATE" />
- <ScalarProperty Name="VERIFICATION" ColumnName="VERIFICATION" />
- <ScalarProperty Name="SHOWORDER2" ColumnName="SHOWORDER2" />
- <ScalarProperty Name="SHOWORDER1" ColumnName="SHOWORDER1" />
- <ScalarProperty Name="ISCANLOGIN" ColumnName="ISCANLOGIN" />
- <ScalarProperty Name="PHONE" ColumnName="PHONE" />
- <ScalarProperty Name="PASSWORD" ColumnName="PASSWORD" />
- <ScalarProperty Name="ACCOUNT" ColumnName="ACCOUNT" />
- <ScalarProperty Name="NAME" ColumnName="NAME" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_USER_DEPARTMENT">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_USER_DEPARTMENT">
- <MappingFragment StoreEntitySet="SYS_USER_DEPARTMENT">
- <ScalarProperty Name="DEPARTMENT_ID" ColumnName="DEPARTMENT_ID" />
- <ScalarProperty Name="USER_ID" ColumnName="USER_ID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_USER_PERMISSION">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_USER_PERMISSION">
- <MappingFragment StoreEntitySet="SYS_USER_PERMISSION">
- <ScalarProperty Name="FK_PERMISSIONID" ColumnName="FK_PERMISSIONID" />
- <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_USER_ROLE">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_USER_ROLE">
- <MappingFragment StoreEntitySet="SYS_USER_ROLE">
- <ScalarProperty Name="FK_ROLEID" ColumnName="FK_ROLEID" />
- <ScalarProperty Name="FK_USERID" ColumnName="FK_USERID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_USERINFO">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_USERINFO">
- <MappingFragment StoreEntitySet="SYS_USERINFO">
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
- <ScalarProperty Name="CREATEUSER" ColumnName="CREATEUSER" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="WEBCHATOPENID" ColumnName="WEBCHATOPENID" />
- <ScalarProperty Name="QQ" ColumnName="QQ" />
- <ScalarProperty Name="CARNUMBER" ColumnName="CARNUMBER" />
- <ScalarProperty Name="JINRUDATE" ColumnName="JINRUDATE" />
- <ScalarProperty Name="WORKDATE" ColumnName="WORKDATE" />
- <ScalarProperty Name="HUJIPAICHUSUO" ColumnName="HUJIPAICHUSUO" />
- <ScalarProperty Name="HuJiSuoZaiDi" ColumnName="HuJiSuoZaiDi" />
- <ScalarProperty Name="RESUMETYPE" ColumnName="RESUMETYPE" />
- <ScalarProperty Name="RESUMENEWNAME" ColumnName="RESUMENEWNAME" />
- <ScalarProperty Name="RESUMEOLDNAME" ColumnName="RESUMEOLDNAME" />
- <ScalarProperty Name="PHOTOTYPE" ColumnName="PHOTOTYPE" />
- <ScalarProperty Name="PHOTONEWNAME" ColumnName="PHOTONEWNAME" />
- <ScalarProperty Name="PHOTOOLDNAME" ColumnName="PHOTOOLDNAME" />
- <ScalarProperty Name="SPECIALTY" ColumnName="SPECIALTY" />
- <ScalarProperty Name="GRADUATIONSCHOOL" ColumnName="GRADUATIONSCHOOL" />
- <ScalarProperty Name="ZHICHENG" ColumnName="ZHICHENG" />
- <ScalarProperty Name="XUELI" ColumnName="XUELI" />
- <ScalarProperty Name="ACCOUNTLOCATION" ColumnName="ACCOUNTLOCATION" />
- <ScalarProperty Name="HomeTown" ColumnName="HomeTown" />
- <ScalarProperty Name="IDENTITYCODE" ColumnName="IDENTITYCODE" />
- <ScalarProperty Name="MARRYCODE" ColumnName="MARRYCODE" />
- <ScalarProperty Name="IDNUMBER" ColumnName="IDNUMBER" />
- <ScalarProperty Name="NATIONCODE" ColumnName="NATIONCODE" />
- <ScalarProperty Name="BIRTHDAY" ColumnName="BIRTHDAY" />
- <ScalarProperty Name="SEXCODE" ColumnName="SEXCODE" />
- <ScalarProperty Name="WORKCODE" ColumnName="WORKCODE" />
- <ScalarProperty Name="SECONDPHONE" ColumnName="SECONDPHONE" />
- <ScalarProperty Name="EMAILADDRESS" ColumnName="EMAILADDRESS" />
- <ScalarProperty Name="OFFICEPHONE" ColumnName="OFFICEPHONE" />
- <ScalarProperty Name="PHONE" ColumnName="PHONE" />
- <ScalarProperty Name="POSTCODE" ColumnName="POSTCODE" />
- <ScalarProperty Name="USERID" ColumnName="USERID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_WEBCHAT">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_WEBCHAT">
- <MappingFragment StoreEntitySet="SYS_WEBCHAT">
- <ScalarProperty Name="TELPHONE" ColumnName="TELPHONE" />
- <ScalarProperty Name="SENDTIME" ColumnName="SENDTIME" />
- <ScalarProperty Name="CREATETIME" ColumnName="CREATETIME" />
- <ScalarProperty Name="SMSCODE" ColumnName="SMSCODE" />
- <ScalarProperty Name="OPENID" ColumnName="OPENID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="YW_Bicycle">
- <EntityTypeMapping TypeName="wk_dbModel.YW_Bicycle">
- <MappingFragment StoreEntitySet="YW_Bicycle">
- <ScalarProperty Name="IsLockable" ColumnName="IsLockable" />
- <ScalarProperty Name="InFenceDate" ColumnName="InFenceDate" />
- <ScalarProperty Name="OutFenceDate" ColumnName="OutFenceDate" />
- <ScalarProperty Name="smallClass" ColumnName="smallClass" />
- <ScalarProperty Name="ProductLine" ColumnName="ProductLine" />
- <ScalarProperty Name="FactoryNumber" ColumnName="FactoryNumber" />
- <ScalarProperty Name="CustomerName" ColumnName="CustomerName" />
- <ScalarProperty Name="CustomerCode" ColumnName="CustomerCode" />
- <ScalarProperty Name="FenceState" ColumnName="FenceState" />
- <ScalarProperty Name="WarehouseName" ColumnName="WarehouseName" />
- <ScalarProperty Name="WarehouseID" ColumnName="WarehouseID" />
- <ScalarProperty Name="SalesId" ColumnName="SalesId" />
- <ScalarProperty Name="ICCID" ColumnName="ICCID" />
- <ScalarProperty Name="IMSI" ColumnName="IMSI" />
- <ScalarProperty Name="SaleDate" ColumnName="SaleDate" />
- <ScalarProperty Name="InputDate" ColumnName="InputDate" />
- <ScalarProperty Name="OutDate" ColumnName="OutDate" />
- <ScalarProperty Name="LockState" ColumnName="LockState" />
- <ScalarProperty Name="UpdateDate" ColumnName="UpdateDate" />
- <ScalarProperty Name="UpdateUser" ColumnName="UpdateUser" />
- <ScalarProperty Name="CreateDate" ColumnName="CreateDate" />
- <ScalarProperty Name="Createper" ColumnName="Createper" />
- <ScalarProperty Name="carType" ColumnName="carType" />
- <ScalarProperty Name="lang" ColumnName="lang" />
- <ScalarProperty Name="CarSate" ColumnName="CarSate" />
- <ScalarProperty Name="LeaseStatus" ColumnName="LeaseStatus" />
- <ScalarProperty Name="productionDate" ColumnName="productionDate" />
- <ScalarProperty Name="CarName" ColumnName="CarName" />
- <ScalarProperty Name="carBar" ColumnName="carBar" />
- <ScalarProperty Name="CarNumber" ColumnName="CarNumber" />
- <ScalarProperty Name="CarModel" ColumnName="CarModel" />
- <ScalarProperty Name="CarID" ColumnName="CarID" />
- <ScalarProperty Name="DistributorsName" ColumnName="DistributorsName" />
- <ScalarProperty Name="DistributorsID" ColumnName="DistributorsID" />
- <ScalarProperty Name="UserId" ColumnName="UserId" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="YW_CarParamDetails">
- <EntityTypeMapping TypeName="wk_dbModel.YW_CarParamDetails">
- <MappingFragment StoreEntitySet="YW_CarParamDetails">
- <ScalarProperty Name="add_time" ColumnName="add_time" />
- <ScalarProperty Name="cartype" ColumnName="cartype" />
- <ScalarProperty Name="timestamp" ColumnName="timestamp" />
- <ScalarProperty Name="speed" ColumnName="speed" />
- <ScalarProperty Name="voltage" ColumnName="voltage" />
- <ScalarProperty Name="temperature" ColumnName="temperature" />
- <ScalarProperty Name="hydraulic" ColumnName="hydraulic" />
- <ScalarProperty Name="imei" ColumnName="imei" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="YW_CarPurchaser">
- <EntityTypeMapping TypeName="wk_dbModel.YW_CarPurchaser">
- <MappingFragment StoreEntitySet="YW_CarPurchaser">
- <ScalarProperty Name="SaleDate" ColumnName="SaleDate" />
- <ScalarProperty Name="distributorsID" ColumnName="distributorsID" />
- <ScalarProperty Name="updateName" ColumnName="updateName" />
- <ScalarProperty Name="updateDate" ColumnName="updateDate" />
- <ScalarProperty Name="addName" ColumnName="addName" />
- <ScalarProperty Name="addDate" ColumnName="addDate" />
- <ScalarProperty Name="userCode" ColumnName="userCode" />
- <ScalarProperty Name="userAddress" ColumnName="userAddress" />
- <ScalarProperty Name="userTel" ColumnName="userTel" />
- <ScalarProperty Name="userName" ColumnName="userName" />
- <ScalarProperty Name="imei" ColumnName="imei" />
- <ScalarProperty Name="carBar" ColumnName="carBar" />
- <ScalarProperty Name="carId" ColumnName="carId" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="YW_Notice">
- <EntityTypeMapping TypeName="wk_dbModel.YW_Notice">
- <MappingFragment StoreEntitySet="YW_Notice">
- <ScalarProperty Name="ImgUrl" ColumnName="ImgUrl" />
- <ScalarProperty Name="updateDate" ColumnName="updateDate" />
- <ScalarProperty Name="updateUser" ColumnName="updateUser" />
- <ScalarProperty Name="createDate" ColumnName="createDate" />
- <ScalarProperty Name="createper" ColumnName="createper" />
- <ScalarProperty Name="IsDel" ColumnName="IsDel" />
- <ScalarProperty Name="IsRead" ColumnName="IsRead" />
- <ScalarProperty Name="Noticetype" ColumnName="Noticetype" />
- <ScalarProperty Name="RoleId" ColumnName="RoleId" />
- <ScalarProperty Name="Content" ColumnName="Content" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="YW_User_Notice">
- <EntityTypeMapping TypeName="wk_dbModel.YW_User_Notice">
- <MappingFragment StoreEntitySet="YW_User_Notice">
- <ScalarProperty Name="noticeID" ColumnName="noticeID" />
- <ScalarProperty Name="userID" ColumnName="userID" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="YW_UserCar">
- <EntityTypeMapping TypeName="wk_dbModel.YW_UserCar">
- <MappingFragment StoreEntitySet="YW_UserCar">
- <ScalarProperty Name="userIdentity" ColumnName="userIdentity" />
- <ScalarProperty Name="userName" ColumnName="userName" />
- <ScalarProperty Name="userTel" ColumnName="userTel" />
- <ScalarProperty Name="update_name" ColumnName="update_name" />
- <ScalarProperty Name="update_time" ColumnName="update_time" />
- <ScalarProperty Name="add_name" ColumnName="add_name" />
- <ScalarProperty Name="add_time" ColumnName="add_time" />
- <ScalarProperty Name="note" ColumnName="note" />
- <ScalarProperty Name="carId" ColumnName="carId" />
- <ScalarProperty Name="userId" ColumnName="userId" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="YW_UserDistributor">
- <EntityTypeMapping TypeName="wk_dbModel.YW_UserDistributor">
- <MappingFragment StoreEntitySet="YW_UserDistributor">
- <ScalarProperty Name="distype" ColumnName="distype" />
- <ScalarProperty Name="ProductLine5" ColumnName="ProductLine5" />
- <ScalarProperty Name="ProductLine4" ColumnName="ProductLine4" />
- <ScalarProperty Name="ProductLine3" ColumnName="ProductLine3" />
- <ScalarProperty Name="ProductLine2" ColumnName="ProductLine2" />
- <ScalarProperty Name="ProductLine1" ColumnName="ProductLine1" />
- <ScalarProperty Name="ProductLine" ColumnName="ProductLine" />
- <ScalarProperty Name="add_time" ColumnName="add_time" />
- <ScalarProperty Name="add_name" ColumnName="add_name" />
- <ScalarProperty Name="distributorId" ColumnName="distributorId" />
- <ScalarProperty Name="userId" ColumnName="userId" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="YW_UserToken">
- <EntityTypeMapping TypeName="wk_dbModel.YW_UserToken">
- <MappingFragment StoreEntitySet="YW_UserToken">
- <ScalarProperty Name="AddTime" ColumnName="AddTime" />
- <ScalarProperty Name="UID" ColumnName="UID" />
- <ScalarProperty Name="UserToken" ColumnName="UserToken" />
- <ScalarProperty Name="UserType" ColumnName="UserType" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_ONLINE">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_ONLINE">
- <MappingFragment StoreEntitySet="SYS_ONLINE">
- <ScalarProperty Name="NAME" ColumnName="NAME" />
- <ScalarProperty Name="USERID" ColumnName="USERID" />
- <ScalarProperty Name="STATE" ColumnName="STATE" />
- <ScalarProperty Name="LASTACCESSTIME" ColumnName="LASTACCESSTIME" />
- <ScalarProperty Name="ACCOUNT" ColumnName="ACCOUNT" />
- <ScalarProperty Name="COOKIEID" ColumnName="COOKIEID" />
- <ScalarProperty Name="TIMEOUTTIME" ColumnName="TIMEOUTTIME" />
- <ScalarProperty Name="LOGINTIME" ColumnName="LOGINTIME" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SYS_DISTRIBUTORS">
- <EntityTypeMapping TypeName="wk_dbModel.SYS_DISTRIBUTORS">
- <MappingFragment StoreEntitySet="SYS_DISTRIBUTORS">
- <ScalarProperty Name="Notes" ColumnName="Notes" />
- <ScalarProperty Name="SaleCar" ColumnName="SaleCar" />
- <ScalarProperty Name="SaleType" ColumnName="SaleType" />
- <ScalarProperty Name="DealerNumber" ColumnName="DealerNumber" />
- <ScalarProperty Name="Theodolite" ColumnName="Theodolite" />
- <ScalarProperty Name="FenceRadius" ColumnName="FenceRadius" />
- <ScalarProperty Name="FenceID" ColumnName="FenceID" />
- <ScalarProperty Name="UPDATEUSER" ColumnName="UPDATEUSER" />
- <ScalarProperty Name="UPDATEDATE" ColumnName="UPDATEDATE" />
- <ScalarProperty Name="CREATEDATE" ColumnName="CREATEDATE" />
- <ScalarProperty Name="CREATEPERID" ColumnName="CREATEPERID" />
- <ScalarProperty Name="Area" ColumnName="Area" />
- <ScalarProperty Name="City" ColumnName="City" />
- <ScalarProperty Name="Province" ColumnName="Province" />
- <ScalarProperty Name="ProvinceCity" ColumnName="ProvinceCity" />
- <ScalarProperty Name="PARENTID" ColumnName="PARENTID" />
- <ScalarProperty Name="LICENSEVALUE" ColumnName="LICENSEVALUE" />
- <ScalarProperty Name="LICENSEURL" ColumnName="LICENSEURL" />
- <ScalarProperty Name="ParentName" ColumnName="ParentName" />
- <ScalarProperty Name="PARENTCODE" ColumnName="PARENTCODE" />
- <ScalarProperty Name="Address" ColumnName="Address" />
- <ScalarProperty Name="SHOWORDER" ColumnName="SHOWORDER" />
- <ScalarProperty Name="BUSINESSLEVEL" ColumnName="BUSINESSLEVEL" />
- <ScalarProperty Name="NAME" ColumnName="NAME" />
- <ScalarProperty Name="CODE" ColumnName="CODE" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- </EntityContainerMapping>
- </Mapping>
- </edmx:Mappings>
- </edmx:Runtime>
- <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
- <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
- <Connection>
- <DesignerInfoPropertySet>
- <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
- </DesignerInfoPropertySet>
- </Connection>
- <Options>
- <DesignerInfoPropertySet>
- <DesignerProperty Name="ValidateOnBuild" Value="true" />
- <DesignerProperty Name="EnablePluralization" Value="false" />
- <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
- <DesignerProperty Name="UseLegacyProvider" Value="false" />
- <DesignerProperty Name="CodeGenerationStrategy" Value="无" />
- </DesignerInfoPropertySet>
- </Options>
- <!-- Diagram content (shape and connector positions) -->
- <Diagrams></Diagrams>
- </Designer>
- </edmx:Edmx>
|