091557AE-D156-45C5-BB6F-99B56918CFED 参与者参与者 1464592449 weixin 1577159328 Administrator [FolderOptions] [FolderOptions\Physical Objects] GenerationCheckModel=Yes GenerationPath= GenerationOptions= GenerationTasks= GenerationTargets= GenerationSelections= RevPkey=Yes RevFkey=Yes RevAkey=Yes RevCheck=Yes RevIndx=Yes RevOpts=Yes RevViewAsTabl=No RevViewOpts=Yes RevSystAsTabl=Yes RevTablPerm=No RevViewPerm=No RevProcPerm=No RevDbpkPerm=No RevSqncPerm=No RevAdtPerm=No RevUserPriv=No RevUserOpts=No RevGrpePriv=No RevRolePriv=No RevDtbsOpts=Yes RevDtbsPerm=No RevViewIndx=Yes RevJidxOpts=Yes RevStats=No RevTspcPerm=No RevCaseSensitive=No GenTrgrStdMsg=Yes GenTrgrMsgTab= GenTrgrMsgNo= GenTrgrMsgTxt= TrgrPreserve=No TrgrIns=Yes TrgrUpd=Yes TrgrDel=Yes TrgrC2Ins=Yes TrgrC2Upd=Yes TrgrC3=Yes TrgrC4=Yes TrgrC5=Yes TrgrC6=Yes TrgrC7=Yes TrgrC8=Yes TrgrC9=Yes TrgrC10=Yes TrgrC11=Yes TrgrC1=Yes TrgrC12Ins=Yes TrgrC12Upd=Yes TrgrC13=Yes UpdateTableStatistics=Yes UpdateColumnStatistics=Yes [FolderOptions\Physical Objects\Database Generation] GenScriptName=crebas GenScriptName0= GenScriptName1= GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName=D:\ibps\ GenSingleFile=Yes GenODBC=No GenCheckModel=Yes GenScriptPrev=Yes GenArchiveModel=No GenUseSync=No GenSyncChoice=0 GenSyncArch= GenSyncRmg=0 [FolderOptions\Physical Objects\Database Generation\Format] GenScriptTitle=Yes GenScriptNamLabl=No GenScriptQDtbs=No GenScriptQOwnr=Yes GenScriptCase=0 GenScriptEncoding=ANSI GenScriptNAcct=No IdentifierDelimiter=" [FolderOptions\Physical Objects\Database Generation\Database] Create=Yes Open=Yes Close=Yes Drop=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Database\Create] Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Tablespace] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Tablespace\Create] Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Storage] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\User] Create=Yes Drop=Yes Comment=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\User\Create] Physical Options=No [FolderOptions\Physical Objects\Database Generation\Group] Create=Yes Drop=Yes Comment=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\Role] Create=Yes Drop=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\UserDefinedDataType] Create=Yes Comment=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\UserDefinedDataType\Create] Default value=Yes Check=Yes [FolderOptions\Physical Objects\Database Generation\AbstractDataType] Create=Yes Header=Yes Footer=Yes Drop=Yes Comment=Yes Install JAVA class=Yes Remove JAVA class=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Rule] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Default] Create=Yes Comment=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Sequence] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Table&&Column] [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create] Check=Yes Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create\Check] Constraint declaration=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Column] User datatype=No Default value=Yes Check=Yes Physical Options=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Column\Check] Constraint declaration=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key] [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key\Create] Constraint declaration=No Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key\Create] Constraint declaration=No Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key\Create] Constraint declaration=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Create] Constraint declaration=Yes Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Filter] Primary key=No Foreign key=No Alternate key=No Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [FolderOptions\Physical Objects\Database Generation\View] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\View\Create] Force Column list=No Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewColumn] Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Create] Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Filter] Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\View\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [FolderOptions\Physical Objects\Database Generation\DBMSTrigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Synonym] Create=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Synonym\Filter] Table=Yes View=Yes Proc=Yes Synonym=Yes Database Package=Yes Sequence=Yes [FolderOptions\Physical Objects\Database Generation\JoinIndex] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\JoinIndex\Create] Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Procedure] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Procedure\Create] Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\DatabasePackage] Create=Yes Drop=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\WebService] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Dimension] Create=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Synchronization] GenBackupTabl=1 GenKeepBackTabl=1 GenTmpTablDrop=No GenKeepTablOpts=No [FolderOptions\Physical Objects\Test Data] GenDataPathName= GenDataSinglefile=Yes GenDataScriptName=testdata GenDataScriptName0= GenDataScriptName1= GenDataScriptName2= GenDataScriptName3= GenDataScriptName4= GenDataScriptName5= GenDataScriptName6= GenDataScriptName7= GenDataScriptName8= GenDataScriptName9= GenDataOdbc=0 GenDataDelOld=No GenDataTitle=No GenDataDefNumRows=20 GenDataCommit=0 GenDataPacket=0 GenDataOwner=No GenDataProfNumb= GenDataProfChar= GenDataProfDate= GenDataCSVSeparator=, GenDataFileFormat=CSV GenDataUseWizard=No [FolderOptions\Pdm] IndxIQName=%COLUMN%_%INDEXTYPE% IndxPK=Yes IndxFK=Yes IndxAK=Yes IndxPKName=%TABLE%_PK IndxFKName=%REFR%_FK IndxAKName=%AKEY%_AK IndxPreserve=No IndxThreshold=0 IndxStats=No RefrPreserve=No JidxPreserve=No RbldMultiFact=Yes RbldMultiDim=Yes RbldMultiJidx=Yes CubePreserve=No TablStProcPreserve=No ProcDepPreserve=Yes TrgrDepPreserve=Yes CubeScriptPath= CubeScriptCase=0 CubeScriptEncoding=ANSI CubeScriptNacct=No CubeScriptHeader=No CubeScriptExt=csv CubeScriptExt0=txt CubeScriptExt1= CubeScriptExt2= CubeScriptSep=, CubeScriptDeli=" EstimationYears=0 DfltDomnName=D_%.U:VALUE% DfltColnName=D_%.U:VALUE% DfltReuse=Yes DfltDrop=Yes [ModelOptions] [ModelOptions\Physical Objects] CaseSensitive=No DisplayName=Yes EnableTrans=No UseTerm=No EnableRequirements=No EnableFullShortcut=Yes DefaultDttp= IgnoreOwner=No RebuildTrigger=Yes RefrUnique=No RefrAutoMigrate=Yes RefrMigrateReuse=Yes RefrMigrateDomain=Yes RefrMigrateCheck=Yes RefrMigrateRule=Yes RefrMigrateExtd=No RefrMigrDefaultLink=No RefrDfltImpl=D RefrPrgtColn=No RefrMigrateToEnd=No RebuildTriggerDep=No ColnFKName=%.3:PARENT%_%COLUMN% ColnFKNameUse=No DomnCopyDttp=Yes DomnCopyChck=No DomnCopyRule=No DomnCopyMand=No DomnCopyExtd=No DomnCopyProf=No Notation=0 DomnDefaultMandatory=No ColnDefaultMandatory=No TablDefaultOwner= ViewDefaultOwner= TrgrDefaultOwnerTabl= TrgrDefaultOwnerView= IdxDefaultOwnerTabl= IdxDefaultOwnerView= JdxDefaultOwner= DBPackDefaultOwner= SeqDefaultOwner= ProcDefaultOwner= DBMSTrgrDefaultOwner= Currency=USD RefrDeleteConstraint=1 RefrUpdateConstraint=1 RefrParentMandatory=No RefrParentChangeAllow=Yes RefrCheckOnCommit=No [ModelOptions\Physical Objects\NamingOptionsTemplates] [ModelOptions\Physical Objects\ClssNamingOptions] [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG] [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN] [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN\Code] Template= MaxLen=30 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\TABL] [ModelOptions\Physical Objects\ClssNamingOptions\TABL\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\TABL\Code] Template= MaxLen=128 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\COLN] [ModelOptions\Physical Objects\ClssNamingOptions\COLN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\COLN\Code] Template= MaxLen=128 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\INDX] [ModelOptions\Physical Objects\ClssNamingOptions\INDX\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\INDX\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\REFR] [ModelOptions\Physical Objects\ClssNamingOptions\REFR\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\REFR\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VREF] [ModelOptions\Physical Objects\ClssNamingOptions\VREF\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VREF\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEW] [ModelOptions\Physical Objects\ClssNamingOptions\VIEW\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEW\Code] Template= MaxLen=128 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC] [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV] [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV\Code] Template= MaxLen=128 Case=M ValidChar='a'-'z','A'-'Z','0'-'9',"/-_.!~*'()" InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP] [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP\Code] Template= MaxLen=128 Case=M ValidChar='a'-'z','A'-'Z','0'-'9',"/-_.!~*'()" InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM] [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FACT] [ModelOptions\Physical Objects\ClssNamingOptions\FACT\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FACT\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DIMN] [ModelOptions\Physical Objects\ClssNamingOptions\DIMN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DIMN\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\MEAS] [ModelOptions\Physical Objects\ClssNamingOptions\MEAS\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\MEAS\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DATTR] [ModelOptions\Physical Objects\ClssNamingOptions\DATTR\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DATTR\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FILO] [ModelOptions\Physical Objects\ClssNamingOptions\FILO\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FILO\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ] [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK] [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass] [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Connection] [ModelOptions\Pdm] [ModelOptions\Generate] [ModelOptions\Generate\Xsm] GenRootElement=Yes GenComplexType=No GenAttribute=Yes CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=No [ModelOptions\Generate\Pdm] RRMapping=No [ModelOptions\Generate\Cdm] CheckModel=Yes SaveLinks=Yes NameToCode=No Notation=2 [ModelOptions\Generate\Oom] CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=Yes ClassPrefix= [ModelOptions\Generate\Ldm] CheckModel=Yes SaveLinks=Yes NameToCode=No [ModelOptions\Default Opts] [ModelOptions\Default Opts\TABL] PhysOpts= [ModelOptions\Default Opts\COLN] PhysOpts= [ModelOptions\Default Opts\INDX] PhysOpts= [ModelOptions\Default Opts\AKEY] PhysOpts= [ModelOptions\Default Opts\PKEY] PhysOpts= [ModelOptions\Default Opts\STOR] PhysOpts= [ModelOptions\Default Opts\TSPC] PhysOpts= [ModelOptions\Default Opts\SQNC] PhysOpts= [ModelOptions\Default Opts\DTBS] PhysOpts= [ModelOptions\Default Opts\USER] PhysOpts= [ModelOptions\Default Opts\JIDX] PhysOpts= {B2B54B83-1563-48B2-8C35-1C370B4B3DB3},SYASA12,75={F651E222-A195-471F-959B-1F216FBE9D98},AutoFixMaterializedViewDone,4=true 516E1E82-7DC9-4B34-BE65-B5BE2D284CFB MySQL 5.0 MYSQL50 1464597234 weixin 1464597234 weixin F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B F97F1BF4-8620-4E13-BF41-BC7B61FD3B64 参与者参与者 1464592449 weixin 1577159328 Administrator [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Show Links intersections=Yes Activate automatic link routing=Yes Grid size=800 Graphic unit=2 Window color=255 255 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255 255 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Show Icon=No Mode=2 Trunc Length=40 Word Length=40 Word Text=!"#$%&')*+,-./:;=>?@\]^_`|}~ Shortcut IntIcon=Yes Shortcut IntLoct=Yes Shortcut IntFullPath=No Shortcut IntLastPackage=Yes Shortcut ExtIcon=Yes Shortcut ExtLoct=No Shortcut ExtFullPath=No Shortcut ExtLastPackage=Yes Shortcut ExtIncludeModl=Yes EObjShowStrn=Yes ExtendedObject.Comment=No ExtendedObject.IconPicture=No ExtendedObject.TextStyle=No ExtendedObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Object Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Source" >[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] </Form>[CRLF]</Form> FileObject.Stereotype=No FileObject.DisplayName=Yes FileObject.LocationOrName=No FileObject.IconPicture=No FileObject.TextStyle=No FileObject.IconMode=Yes FileObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Location" Attribute="LocationOrName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Package.Stereotype=Yes Package.Comment=No Package.IconPicture=No Package.TextStyle=No Package_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Display Model Version=Yes Table.Stereotype=Yes Table.DisplayName=Yes Table.OwnerDisplayName=No Table.Columns=Yes Table.Columns._Filter="All Columns" PDMCOLNALL Table.Columns._Columns=Stereotype DataType KeyIndicator NullStatus Table.Columns._Limit=-5 Table.Keys=No Table.Keys._Columns=Stereotype Indicator Table.Indexes=No Table.Indexes._Columns=Stereotype Table.Triggers=No Table.Triggers._Columns=Stereotype Table.Comment=No Table.IconPicture=No Table.TextStyle=No Table_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="Stereotype No\r\nDisplayName Yes\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nDomain No\r\nKeyIndicator No\r\nIndexIndicator No\r\nNullStatus No" Filters=""All Columns" PDMCOLNALL ""\r\n"PK Columns" PDMCOLNPK "\"PRIM \"TRUE\" TRUE\""\r\n"Key Columns" PDMCOLNKEY "\"KEYS \"TRUE\" TRUE\""" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Keys" Collection="Keys" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Triggers" Collection="Triggers" Columns="Stereotype No\r\nDisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> View.Stereotype=Yes View.DisplayName=Yes View.OwnerDisplayName=No View.Columns=Yes View.Columns._Columns=DisplayName View.Columns._Limit=-5 View.TemporaryVTables=Yes View.Indexes=No View.Comment=No View.IconPicture=No View.TextStyle=No View_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="DisplayName No\r\nExpression No\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nIndexIndicator No" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Tables" Collection="TemporaryVTables" Columns="Name Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="DisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Procedure.Stereotype=No Procedure.DisplayName=Yes Procedure.OwnerDisplayName=No Procedure.Comment=No Procedure.IconPicture=No Procedure.TextStyle=No Procedure_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Reference.Cardinality=No Reference.ImplementationType=No Reference.ChildRole=Yes Reference.Stereotype=Yes Reference.DisplayName=No Reference.ForeignKeyConstraintName=No Reference.JoinExpression=No Reference.Integrity=No Reference.ParentRole=Yes Reference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Cardinality" Attribute="Cardinality" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Implementation" Attribute="ImplementationType" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Cons&traint Name" Attribute="ForeignKeyConstraintName" Prefix="" Suffix="" Caption="Cons&traint Name" Mandatory="No" />[CRLF] <StandardAttribute Name="Join" Attribute="JoinExpression" Prefix="" Suffix="" Caption="Join" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Referential integrity" Attribute="Integrity" Prefix="" Suffix="" Caption="Referential integrity" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> ViewReference.ChildRole=Yes ViewReference.Stereotype=Yes ViewReference.DisplayName=No ViewReference.JoinExpression=No ViewReference.ParentRole=Yes ViewReference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Join Expression" Attribute="JoinExpression" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=6000 Height=2000 Brush color=255 255 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=64 Brush gradient color=192 192 192 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 255 128 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FRMELNK] CENTERFont=新宋体,8,N CENTERFont color=0 0 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FILO] OBJSTRNFont=新宋体,8,N OBJSTRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 LCNMFont=新宋体,8,N LCNMFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PDMPCKG] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0 0 0 ColumnsFont=新宋体,8,N ColumnsFont color=0 0 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0 0 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0 0 0 KeysFont=新宋体,8,N KeysFont color=0 0 0 IndexesFont=新宋体,8,N IndexesFont color=0 0 0 TriggersFont=新宋体,8,N TriggersFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=178 214 252 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0 0 0 ColumnsFont=新宋体,8,N ColumnsFont color=0 0 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0 0 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0 0 0 TemporaryVTablesFont=新宋体,8,N TemporaryVTablesFont color=0 0 0 IndexesFont=新宋体,8,N IndexesFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=208 208 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4000 Height=1000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 108 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] SOURCEFont=新宋体,8,N SOURCEFont color=0 0 0 CENTERFont=新宋体,8,N CENTERFont color=0 0 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0 0 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] SOURCEFont=新宋体,8,N SOURCEFont color=0 0 0 CENTERFont=新宋体,8,N CENTERFont color=0 0 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0 0 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=新宋体,8,N OBJXSTRFont color=0 0 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0 0 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 (8268, 11693) ((315,354), (433,354)) 1 15 1577159303 1577159304 -1 ((-2401,-57936), (2398,-53937)) 11711154 12648447 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 E4564E5A-71B6-4A3D-98B1-B7921CDD5DBC 参与者参与者 1577159303 Administrator 1591788557 Administrator 0B6335F2-2E27-4003-8AB2-6CD8AB6BA2B9 参与者参与者 1577159306 Administrator 1577159330 Administrator [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Show Links intersections=Yes Activate automatic link routing=Yes Grid size=800 Graphic unit=2 Window color=255 255 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255 255 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Show Icon=No Mode=2 Trunc Length=40 Word Length=40 Word Text=!"#$%&')*+,-./:;=>?@\]^_`|}~ Shortcut IntIcon=Yes Shortcut IntLoct=Yes Shortcut IntFullPath=No Shortcut IntLastPackage=Yes Shortcut ExtIcon=Yes Shortcut ExtLoct=No Shortcut ExtFullPath=No Shortcut ExtLastPackage=Yes Shortcut ExtIncludeModl=Yes EObjShowStrn=Yes ExtendedObject.Comment=No ExtendedObject.IconPicture=No ExtendedObject.TextStyle=No ExtendedObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Object Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Source" >[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] </Form>[CRLF]</Form> FileObject.Stereotype=No FileObject.DisplayName=Yes FileObject.LocationOrName=No FileObject.IconPicture=No FileObject.TextStyle=No FileObject.IconMode=Yes FileObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Location" Attribute="LocationOrName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Package.Stereotype=Yes Package.Comment=No Package.IconPicture=No Package.TextStyle=No Package_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Display Model Version=Yes Table.Stereotype=Yes Table.DisplayName=Yes Table.OwnerDisplayName=No Table.Columns=Yes Table.Columns._Filter="All Columns" PDMCOLNALL Table.Columns._Columns=Stereotype DataType KeyIndicator NullStatus Table.Columns._Limit=-5 Table.Keys=No Table.Keys._Columns=Stereotype Indicator Table.Indexes=No Table.Indexes._Columns=Stereotype Table.Triggers=No Table.Triggers._Columns=Stereotype Table.Comment=No Table.IconPicture=No Table.TextStyle=No Table_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="Stereotype No\r\nDisplayName Yes\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nDomain No\r\nKeyIndicator No\r\nIndexIndicator No\r\nNullStatus No" Filters=""All Columns" PDMCOLNALL ""\r\n"PK Columns" PDMCOLNPK "\"PRIM \"TRUE\" TRUE\""\r\n"Key Columns" PDMCOLNKEY "\"KEYS \"TRUE\" TRUE\""" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Keys" Collection="Keys" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Triggers" Collection="Triggers" Columns="Stereotype No\r\nDisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> View.Stereotype=Yes View.DisplayName=Yes View.OwnerDisplayName=No View.Columns=Yes View.Columns._Columns=DisplayName View.Columns._Limit=-5 View.TemporaryVTables=Yes View.Indexes=No View.Comment=No View.IconPicture=No View.TextStyle=No View_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="DisplayName No\r\nExpression No\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nIndexIndicator No" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Tables" Collection="TemporaryVTables" Columns="Name Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="DisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Procedure.Stereotype=No Procedure.DisplayName=Yes Procedure.OwnerDisplayName=No Procedure.Comment=No Procedure.IconPicture=No Procedure.TextStyle=No Procedure_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Reference.Cardinality=No Reference.ImplementationType=No Reference.ChildRole=Yes Reference.Stereotype=Yes Reference.DisplayName=No Reference.ForeignKeyConstraintName=No Reference.JoinExpression=No Reference.Integrity=No Reference.ParentRole=Yes Reference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Cardinality" Attribute="Cardinality" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Implementation" Attribute="ImplementationType" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Cons&traint Name" Attribute="ForeignKeyConstraintName" Prefix="" Suffix="" Caption="Cons&traint Name" Mandatory="No" />[CRLF] <StandardAttribute Name="Join" Attribute="JoinExpression" Prefix="" Suffix="" Caption="Join" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Referential integrity" Attribute="Integrity" Prefix="" Suffix="" Caption="Referential integrity" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> ViewReference.ChildRole=Yes ViewReference.Stereotype=Yes ViewReference.DisplayName=No ViewReference.JoinExpression=No ViewReference.ParentRole=Yes ViewReference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Join Expression" Attribute="JoinExpression" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=6000 Height=2000 Brush color=255 255 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=64 Brush gradient color=192 192 192 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 255 128 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FRMELNK] CENTERFont=新宋体,8,N CENTERFont color=0 0 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FILO] OBJSTRNFont=新宋体,8,N OBJSTRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 LCNMFont=新宋体,8,N LCNMFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PDMPCKG] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0 0 0 ColumnsFont=新宋体,8,N ColumnsFont color=0 0 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0 0 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0 0 0 KeysFont=新宋体,8,N KeysFont color=0 0 0 IndexesFont=新宋体,8,N IndexesFont color=0 0 0 TriggersFont=新宋体,8,N TriggersFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=178 214 252 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0 0 0 ColumnsFont=新宋体,8,N ColumnsFont color=0 0 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0 0 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0 0 0 TemporaryVTablesFont=新宋体,8,N TemporaryVTablesFont color=0 0 0 IndexesFont=新宋体,8,N IndexesFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=208 208 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=新宋体,8,N STRNFont color=0 0 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0 0 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0 0 0 LABLFont=新宋体,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4000 Height=1000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 108 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] SOURCEFont=新宋体,8,N SOURCEFont color=0 0 0 CENTERFont=新宋体,8,N CENTERFont color=0 0 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0 0 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] SOURCEFont=新宋体,8,N SOURCEFont color=0 0 0 CENTERFont=新宋体,8,N CENTERFont color=0 0 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0 0 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=新宋体,8,N OBJXSTRFont color=0 0 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0 0 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 (8268, 11693) ((315,354), (433,354)) 1 15 三种参与者类型，优先级排序：组织 > 岗位 > 员工所以建立两种参与者关系时，优先级高的作为主参与者。 1577159330 1577159330 ((11838,22228), (31064,26928)) 4130 0 16711680 16777215 12632256 新宋体,8,N 1 目前只有员工才有用户。对于不同的系统，有用户的参与者会有客户、供应商等。 1577159330 1577159330 ((-29665,-6860), (-18247,-12196)) 4130 0 16711680 16777215 12632256 新宋体,8,N 1 参与者抽象表和具体表是一对一关系。但是参与者抽象表只是维护一个树形结构。没有任何其它内容，所以平时查询具体列表时，是不需要左联参与者表的。 1577159330 1577159330 ((-12092,10237), (5208,5538)) 4130 16711680 16777215 12632256 新宋体,8,N 角色、权限相关表待完善 1577159330 1577159330 ((-53301,6484), (-42567,2884)) 4130 0 16711680 16777215 12632256 新宋体,8,N 1 1、员工只会归属一个组织。直接通过员工表维护。 2、员工和组织如果还有其它关系，通过参与者关系表维护。 3、员工可以关联 1~N个岗位，但是必须至少关联一个。（可以可以设置一个保底的岗位，比如叫：员工） 4、组织可以配置 0~N 个角色，表示归属这个组织的员工默认会拥有的角色，在设置归属的时候自动设置到员工对应的用户的【用户-角色】关联表中。（在界面上可以调整） 5、岗位从属1个组织（必须），可以关联1~N个角色 6、员工分配岗位时，自动将岗位关联的角色设置到员工的角色输入框中（多个），（实际存储是存储到员工对应的用户的用户-角色关联表中） 1577159330 1577159330 ((1623,-9881), (34447,-19741)) 4129 0 16711680 16777215 12632256 新宋体,8,N 1 1577159330 1577159330 -1 ((-11851,11336), (6251,22996)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1577159330 1577159330 -1 ((13387,11952), (29171,20800)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-39797,23805), (-22855,33477)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-64421,26919), (-49025,32467)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-11687,24520), (3709,31718)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-36828,-5405), (-19500,2617)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-39169,14394), (-23773,20766)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((1861,-4714), (22665,4134)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-17141,-10498), (-199,4124)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((26480,-6617), (43036,3881)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-54287,-3477), (-40049,2071)) 12615680 8454143 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-50076,-12318), (-35838,-7595)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((46321,-4376), (64421,3646)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-33915,-25000), (-19444,-20277)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-54146,-25489), (-38363,-19941)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1577159330 1577159330 -1 ((-56374,-33477), (-42136,-27105)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 E3847AF9-A8BE-466C-9867-5E6A3FBFC14B IBPS_PARTY_ENTITY【参与者】 IBPS_PARTY_ENTITY 1373340198 Administrator 1577159330 Administrator 参与者 1CDAAD84-3066-4170-8806-ECD948407202 ID ID_ 1373340200 Administrator 1577159330 Administrator ID varchar(64) 64 1 772CF755-EDEA-40D8-BB86-8355BC5FB517 参与者类型 PARTY_TYPE_ 1468845980 Administrator 1577159330 Administrator 参与者类型。org=组织；employee=员工；position=岗位 varchar(64) 64 1 4C7758C9-3F7C-4F3B-A85E-DCC0319ADFCF 参与者别名 PARTY_ALIAS_ 1476419050 Administrator 1577159330 Administrator 参与者别名 varchar(64) 64 F4680177-3634-4377-A06F-CFEE600B7E54 业务主键 PARTY_KEY_ 1474161780 Administrator 1577159330 Administrator 业务主键，实体表的别名字段 varchar(64) 64 F96A1EDB-C74B-4773-AE99-F337614A182B 参与者名称 NAME_ 1468897400 Administrator 1577159330 Administrator 参与者名称 varchar(64) 64 FA815E2B-4565-44EA-AAFD-D527B48B7D11 树 - 父参与者 ID PARENT_ID_ 1373340351 Administrator 1577159330 Administrator 树 - 父参与者 ID varchar(64) 64 03943CE0-87CA-4C34-BAAE-32660D6FA582 树 - 路径 PATH_ 1373340370 Administrator 1577159330 Administrator 树 - 路径 varchar(1024) 1024 49B01138-33FC-44B0-93C7-117A6D91D01E 树 - 所属层次 DEPTH_ 1373340389 Administrator 1577159330 Administrator 树 - 所属层次 int 17044A05-A9C2-4348-AAD8-21A6F4D929F3 创建者 CREATE_BY_ 1358166325 Administrator 1577159330 Administrator 创建者 varchar(64) 64 0D7A084B-EB8E-41A8-AA36-5EC0995E38FD 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime 7E42F343-E324-4FE9-B3DC-2243F4281C35 更新者 UPDATE_BY_ 1358166325 Administrator 1577159330 Administrator 更新者 varchar(64) 64 D366D8D3-216E-40FB-B213-6B3D2C0347A7 更新时间 UPDATE_TIME_ 1358166325 Administrator 1577159330 Administrator 更新时间 datetime 2E615ED1-AEF7-4360-B025-DE73BD3B6337 排序 SN_ 1535102421 Administrator 1577159330 Administrator 排序 int B806521C-DA5C-4317-BB8E-17A6B1E8464E 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 776ABB1A-4925-4FC5-BC21-E18B31883EB3 key_1 key_1 1373340200 Administrator 1577159330 Administrator 95D3C4B5-7BD8-4997-9F07-FE4CB984FB40 idx_e_p_t idx_e_p_t 1571881095 Administrator 1577159330 Administrator ABA835CC-AE80-41EA-8CDB-82D9299F2AC9 1571881141 Administrator 1577159330 Administrator D482814A-558B-4846-B319-A79D4338ABBD idx_e_p_a idx_e_p_a 1571881141 Administrator 1577159330 Administrator 68754FA8-4D2B-43B8-9BCD-1C220407CD4D 1571881156 Administrator 1577159330 Administrator 298CC3A2-F93A-4965-AF7C-0354B6B6C2C2 idx_e_p_id idx_e_p_id 1571881156 Administrator 1577159330 Administrator 28EC65BF-259F-41E0-882F-C563D3552C15 1571881213 Administrator 1577159330 Administrator 0173D762-2CDF-4189-8CAE-5FB8DEFCEB57 idx_e_p_k idx_e_p_k 1571881156 Administrator 1577159330 Administrator 1F520659-6D41-4A07-ABA1-29A9963F7880 1571881175 Administrator 1577159330 Administrator 6C830F21-EF80-42A2-BD01-51303C24B7C8 idx_e_t_id idx_e_t_id 1571881156 Administrator 1577159330 Administrator 74C5C525-0E86-48E2-A666-19DDDA6EF990 1571881242 Administrator 1577159330 Administrator 7385F77B-2DE6-4EDA-B59E-D78CE24788A3 idx_e_c_id idx_e_c_id 1571899655 Administrator 1577159330 Administrator A650A175-B7DD-4A8A-9543-9707D427EF9A 1571899678 Administrator 1577159330 Administrator 94810350-510C-4C22-B282-521918F4804A idx_e_u_id idx_e_u_id 1571899678 Administrator 1577159330 Administrator 20F083A6-DD91-426B-9B59-C746A99ECD35 1571899694 Administrator 1577159330 Administrator AF5CE761-4D72-4CDD-AD06-645C87F81CD9 IBPS_PARTY_REL【参与者关系】 IBPS_PARTY_REL 1404035148 Administrator 1577159330 Administrator 参与者关系 816852E1-7D23-47EF-95D3-11867B6848D8 关系 ID ID_ 1404035611 Administrator 1577159330 Administrator 关系 ID varchar(64) 64 1 EB8B0167-EC20-453D-A0D1-1126DEC12889 主参与者ID MAIN_PID_ 1526550466 Administrator 1577159330 Administrator 主参与者ID varchar(64) 64 BE22BA60-3946-4A9F-BF32-611C4BF436B8 主参与者类型 MAIN_TYPE_ 1466673793 Administrator 1577159330 Administrator 主参与者类型 varchar(64) 64 1 BC8A5F6B-C3C5-4BC4-B5EF-FE8E7A1AC182 从参与者ID SUB_PID_ 1526550658 Administrator 1577159330 Administrator 从参与者ID varchar(64) 64 5723596A-F0CC-47CC-9E87-10E48BFA48F6 从参与者类型 SUB_TYPE_ 1466673793 Administrator 1577159330 Administrator 从参与者类型 varchar(64) 64 1 2AC351B4-EDEE-4476-B3A9-47AE6B91E3B2 关系类型 BIZ_ 1418735559 Administrator 1577159330 Administrator 关系类型。枚举方式维护。 varchar(64) 64 1 97DAD798-40A6-4050-ADDB-2FC8EA5A6AFE 有效时间结束 END_TIME_ 1389751991 Administrator 1577159330 Administrator 有效时间起始。结束时间小于当前时间就表示该关系结束了。 datetime 7FB7CBC5-7570-49D8-9F20-F8075052E8DC 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime D2AB88CD-39D0-4CE8-89C7-59227BFCD579 更新时间 UPDATE_TIME_ 1358166325 Administrator 1577159330 Administrator 更新时间 datetime 9C1A398D-4F17-470E-8728-09F241D4964F Key_1 Key_1 1404036039 Administrator 1577159330 Administrator 8DB09A5F-765F-4DF4-9E61-8577F1F4B9F1 idx_r_m_p_id idx_r_m_p_id 1571898415 Administrator 1577159330 Administrator 1AB37D2E-F97F-45CF-96BD-96C02543EBD8 1571898533 Administrator 1577159330 Administrator 5F4E396E-036A-4CE2-8E18-0805ABDBADAE idx_r_m_p_t idx_r_m_p_t 1571898533 Administrator 1577159330 Administrator 1B8D93EB-CB70-409F-9F9B-5CF63E2DDB85 1571898546 Administrator 1577159330 Administrator 627773DB-004A-414F-B787-6174B8D71614 idx_r_s_p_id idx_r_s_p_id 1571898546 Administrator 1577159330 Administrator BB6099A1-EC41-4F7E-90A8-4666C9C54ECD 1571898561 Administrator 1577159330 Administrator 87C74152-CE33-4231-BCB5-3A8317B30F4A idx_r_s_p_t idx_r_s_p_t 1571898561 Administrator 1577159330 Administrator 761E5A57-7527-401C-B29B-D588CB2577E7 1571898574 Administrator 1577159330 Administrator DA667B8A-94A2-4CBC-A343-8E6361C728D8 idx_r_b idx_r_b 1571898561 Administrator 1577159330 Administrator C764E61B-2D08-475C-BEDB-5D699E5EB0FE 1571898599 Administrator 1577159330 Administrator 2FA04AB4-8FA7-4B06-9B42-60B3FBBAFFB1 IBPS_PARTY_ATTR【参与者属性】 IBPS_PARTY_ATTR 1464579828 Administrator 1577159330 Administrator 参与者属性 0D73D446-B395-461E-8300-E3799E1A175E ID ID_ 1464580445 Administrator 1577159330 Administrator ID varchar(64) 64 1 2FD0E2C6-D028-4573-B28B-B9F9E0F61450 业务主键 KEY_ 1473839317 Administrator 1577159330 Administrator 业务主键 varchar(64) 64 1 C8F41320-7BF5-4A17-AE12-3369D5EEAC55 属性名称 NAME_ 1471504365 Administrator 1577159330 Administrator 属性名称 varchar(128) 128 4E7961D8-868D-497D-9DE5-6117B4CF2F8D 所属参与者类型 PARTY_TYPE_ 1468845980 Administrator 1577159330 Administrator 所属参与者类型。org=组织；employee=员工；position=岗位 varchar(64) 64 1 E22007E3-80CB-40C8-8747-A6BF0D160DFD 属性类型 TYPE_ 1464586686 Administrator 1577159330 Administrator 属性类型。desc=描述属性；query=查询属性 varchar(64) 64 1 382C1523-D6F1-4B78-89EA-E8F7EAECFADD 数据类型 DATA_TYPE_ 1464586686 Administrator 1577159330 Administrator 数据类型。string=字符串；日期=date；int=整型；double=浮点；boolean=是否（字符串）option=选项 varchar(64) 64 1 32173402-3FDE-4D01-AB40-2EEEE016731B 是否多选 IS_MULTI_ 1464589989 Administrator 1577159330 Administrator 是否多选。针对数据类型是option 选项的字段 char(1) 1 1 2066393A-DD01-4EAE-9D55-54CD239D40DE 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime 1 63BFD095-414B-4897-A24A-6754D9A9FC8B 更新时间 UPDATE_TIME_ 1358166325 Administrator 1577159330 Administrator 更新时间 datetime 3D0E5A59-F0CB-4C5B-A96B-ED14AFB74072 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 30ECC3CF-680F-41D7-9BE9-2002A81D4BBB Key_1 Key_1 1464580445 Administrator 1577159330 Administrator EF48CC12-90F6-4563-844C-3E777C69A83E idx_a_k idx_a_k 1571879261 Administrator 1577159330 Administrator 21171514-9468-40DA-AC83-149E9A0BD27E 1571879365 Administrator 1577159330 Administrator C34A879B-0CA4-447C-9975-3075CBC05338 idx_a_p_t idx_a_p_t 1571879365 Administrator 1577159330 Administrator AAC3BB9F-D0F8-4848-968B-6545C7ACF4E8 1571879428 Administrator 1577159330 Administrator 87E890EA-2C55-42A8-839A-9E0C68030C08 idx_a_t idx_a_t 1571879428 Administrator 1577159330 Administrator 419C5B40-E588-46A2-BA5E-654C78BAE779 1571879487 Administrator 1577159330 Administrator 9B3F9FEA-1DA7-41BF-866C-2547C6E5B996 idx_a_t_id idx_a_t_id 1571879486 Administrator 1577159330 Administrator F915D7FF-9ADF-4B29-AEDF-C197501233C4 1571879519 Administrator 1577159330 Administrator 24BD2B84-BC76-4676-97A1-D4B2FCAFEB16 IBPS_PARTY_ATTR_OPT【属性选项】 IBPS_PARTY_ATTR_OPT 1464586854 Administrator 1577159330 Administrator 属性选项 68405C14-B054-477D-95FA-5E6B60F7DB6E ID ID_ 1464586868 Administrator 1577159330 Administrator ID varchar(64) 64 1 4FA458C2-5DA4-421B-9422-C6CE5A31EBB4 所属属性 ID ATTR_ID_ 1526550102 Administrator 1577159330 Administrator 所属属性 ID varchar(64) 64 B1FFB57A-4D2F-4CF7-BD20-F5196609439B 分组名 GROUP_NAME_ 1464586868 Administrator 1577159330 Administrator 分组名。只有一个分组则是默认 varchar(64) 64 1 F966184D-DE53-4311-9277-90B3AA6002CA 选项 VALUE_ 1464586914 Administrator 1577159330 Administrator 选项 varchar(64) 64 1 BB34D5CC-8D0F-4DBF-B0AB-FB52EDA0F470 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime 1 EEC97A68-D2B5-4C7C-9072-E934AFD19FB5 Key_1 Key_1 1464586868 Administrator 1577159330 Administrator 063C46A5-E764-47C2-B8E0-7FEE2BADAD76 idx_a_o_a_id idx_a_o_a_id 1571878964 Administrator 1577159330 Administrator FADE6D6B-BA44-4D6C-8F5B-FC3C2F1BB56F 1571878986 Administrator 1577159330 Administrator A5108611-836C-4113-A617-4F27C2E476EA IBPS_PARTY_LEVEL【参与者等级】 IBPS_PARTY_LEVEL 1464596828 Administrator 1577159330 Administrator 参与者等级 B74152C7-FB1D-450D-8AEE-1A21959BBAC4 ID ID_ 1464597344 Administrator 1577159330 Administrator ID varchar(64) 64 1 EA3B82D9-EE03-4745-B305-F2C7D0FB9653 参与者类型 TYPE_ 1468845980 Administrator 1577159330 Administrator 参与者类型。org=组织；employee=员工；position=岗位 varchar(64) 64 1 7444F0D9-9C57-4F09-B759-F71749AAD5CA 名称 NAME_ 1389401160 Administrator 1577159330 Administrator 名称 varchar(255) 255 1 3DA474C2-A840-4399-846F-5ABD40354D37 级别数值 LEVEL_ 1389401160 Administrator 1577159330 Administrator 级别数值 int 1 5713B9BD-276F-4AD2-BA95-1E80B5E34E77 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime 1 B5CD7365-931E-407A-9CD6-FB815080DD62 更新时间 UPDATE_TIME_ 1358166325 Administrator 1577159330 Administrator 更新时间 datetime 2C130408-3723-4043-A305-802666A2042E 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 54A1AEBB-B563-422D-82F5-2F68711E9819 Key_1 Key_1 1464597344 Administrator 1577159330 Administrator 9CB90742-DC02-41FF-BD7A-D912F45439A1 idx_l_t idx_l_t 1571897932 Administrator 1577159330 Administrator 827923A4-273F-4D28-843A-57FCBB1E8B8B 1571897959 Administrator 1577159330 Administrator 5D78B47E-F1B4-466D-933C-902ECACDD4DD idx_l_l idx_l_l 1571897959 Administrator 1577159330 Administrator 82FACC65-9A62-4743-B3BE-02155A0B6052 1571897976 Administrator 1577159330 Administrator 73CDAB38-A61A-4F2B-8792-BB16D892B367 idx_l_t_id idx_l_t_id 1571897976 Administrator 1577159330 Administrator D6F29569-34C4-4AC7-9D62-FDCE156DCB58 1571897994 Administrator 1577159330 Administrator 38BF626C-FE3E-46FE-9002-D3FE7775777C IBPS_PARTY_USER【用户帐号】 IBPS_PARTY_USER 1464597794 Administrator 1577159330 Administrator 用户帐号 86F6FF52-2AAB-4576-B918-D00AD4B88317 ID ID_ 1468548407 Administrator 1577159330 Administrator ID varchar(64) 64 1 1D7EC0E5-D254-4946-B66C-4494C2F2D672 登录账号 ACCOUNT_ 1358166754 Administrator 1577159330 Administrator 登录账号 varchar(64) 64 1 E1C21E0E-5B31-484E-833F-9FDD9F61FEB6 密码 PASSWORD_ 1358166754 Administrator 1577159330 Administrator 密码 varchar(1024) 1024 1 8DFF986D-3D41-4EBC-9594-E2AF62A6ADD9 是否超级管理员 IS_SUPER_ 1453269307 Administrator 1577159330 Administrator 是否超级管理员 char(1) 1 1 6735E12C-B3F3-48B2-B6CA-317068D9D9E1 数据校验码 DATA_CHECK_ 1453269334 Administrator 1577159330 Administrator 数据校验码。由帐号、铭文密码和是否超级管理员三者一起加密形成校验码 varchar(1024) 1024 1 C22BFF3D-941E-42D5-B0D9-F239D3CE6213 创建时间 CREATE_TIME_ 1358166754 Administrator 1577159330 Administrator 创建时间 datetime 1 0B602A13-6F64-41C3-8ACA-D4143413C402 更新时间 UPDATE_TIME_ 1358166754 Administrator 1577159330 Administrator 更新时间 datetime 02C559BE-66F5-42D6-80F0-83465EB56EDC 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 BE8C285F-8638-47A0-AF56-02FA9D8E21A0 Key_1 Key_1 1468548481 Administrator 1577159330 Administrator 99619D3A-A179-4577-875A-2717EB25244A idx_u_acc idx_u_acc 1571898858 Administrator 1577159330 Administrator C2A7B082-8D52-4A99-BC92-77DC0DAC2918 1571898912 Administrator 1577159330 Administrator 222103E5-E353-44BC-AF28-A731CE3E61D7 idx_u_i_s idx_u_i_s 1571898858 Administrator 1577159330 Administrator 3C556393-2F45-4707-8760-0715D959B0F9 1571898905 Administrator 1577159330 Administrator 65AA4BC7-C1D9-4DFE-9D65-B189395541D8 idx_u_t_id idx_u_t_id 1571898858 Administrator 1577159330 Administrator 31CE5C3F-619D-4A8C-B03F-C3F7E0B6E8E7 1571898900 Administrator 1577159330 Administrator 51C8DF30-EDA3-4166-BF0F-84C67B3C6E40 IBPS_PARTY_ATTR_VALUE【参与者属性值】 IBPS_PARTY_ATTR_VALUE 1464598452 Administrator 1577159330 Administrator 参与者属性值 662DBB8E-791B-44C7-90D2-E75DBC9EDD71 ID ID_ 1464598482 Administrator 1577159330 Administrator ID varchar(64) 64 1 C276D7A6-B317-4A0C-95AA-FB9F3101B480 参与者 ID PARTY_ID_ 1526550187 Administrator 1577159330 Administrator 参与者 ID varchar(64) 64 92770D0A-0315-45B5-A94E-AA5280C92D82 属性 ID ATTR_ID_ 1526550259 Administrator 1577159330 Administrator 属性 ID varchar(64) 64 926A8591-AE5D-4629-9FAC-7D495659ACF3 属性值 VALUE_ 1464598482 Administrator 1577159330 Administrator 属性值 varchar(1024) 1024 1 C013E37A-1256-4A6A-B501-360B9FF4C314 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime 1 A1289BD5-81E6-46C1-A326-F101C5D07511 更新时间 UPDATE_TIME_ 1358166325 Administrator 1577159330 Administrator 更新时间 datetime 36BF1C3E-4018-4953-AEC2-A770DA7D832C Key_1 Key_1 1464598482 Administrator 1577159330 Administrator A9FD7E00-F1C7-42DC-B5B9-22437E5CC4EE idx_a_v_p_id idx_a_v_p_id 1571879067 Administrator 1577159330 Administrator 4C738582-F1AE-410D-9AC7-8DC9F8AEF935 1571879116 Administrator 1577159330 Administrator 6352EB32-BDD8-422D-BB24-0D46AE65E4D1 idx_a_v_a_id idx_a_v_a_id 1571879067 Administrator 1577159330 Administrator 50482A46-809F-4113-BCC8-CCD30676052D 1571879127 Administrator 1577159330 Administrator D428ABC4-F6D1-495C-AEF0-81B7F79ADA84 IBPS_PARTY_ORG【机构】 IBPS_PARTY_ORG 1468846086 Administrator 1577159330 Administrator 机构 9822BDF4-5294-4D28-AC04-8F7CF06536E5 ID ID_ 1468846088 Administrator 1577159330 Administrator ID varchar(64) 64 1 AB784A52-125C-4BD6-BCF4-5ABE43961564 名称 NAME_ 1468846143 Administrator 1577159330 Administrator 名称 varchar(64) 64 1 071482D3-887E-47C0-AAAF-F8199316E350 别名 ORG_ALIAS_ 1472606834 Administrator 1577159330 Administrator 机构别名，业务主键，唯一 varchar(64) 64 1 BA0C538F-3759-462D-92AA-06FA83A88B74 状态 STATUS_ 1373340426 Administrator 1577159330 Administrator 状态。inactive=未激活；actived=激活； varchar(64) 64 3639B1AF-8D34-4153-ACA0-E892B06DB101 等级ID LEVEL_ID_ 1470629010 Administrator 1577159330 Administrator 等级ID varchar(64) 64 CB6118E8-497F-4E40-AC68-D42E4D1CAF99 机构员工默认拥有角色IDs ROLE_IDS_ 1470822542 Administrator 1577159330 Administrator 机构员工默认拥有角色IDs varchar(1024) 1024 063052CF-4549-4B0C-A654-DCB036D49E25 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime 1 59FFCF1C-8484-4CF6-8861-83ED5AAE0D32 更新时间 UPDATE_TIME_ 1358166325 Administrator 1577159330 Administrator 更新时间 datetime 46E89F67-F085-4098-87ED-F334D96CC929 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 493D82AF-D1B9-4200-80E1-DDD6B750AEB5 Key_1 Key_1 1468846088 Administrator 1577159330 Administrator B03E533D-06B1-4429-A749-96F9482E0715 idx_o_o_a idx_o_o_a 1571898202 Administrator 1577159330 Administrator 258A8CAA-B261-46D5-97E5-C4206CE0EECD 1571898234 Administrator 1577159330 Administrator 48EB055A-16A9-4514-A74D-84A75C1BD355 idx_o_s idx_o_s 1571898234 Administrator 1577159330 Administrator 7864D36E-31B9-4E55-800F-C5E1BD3DA90A 1571898252 Administrator 1577159330 Administrator 8D1F49DB-0F8B-44D8-B45B-22D730D293CC idx_o_l_id idx_o_l_id 1571898252 Administrator 1577159330 Administrator 277FB52E-BDA1-4629-9356-D1C36B9CFE29 1571898273 Administrator 1577159330 Administrator E86274A1-3D23-437D-B89C-D5810E28DCFE idx_o_t_id idx_o_t_id 1571898273 Administrator 1577159330 Administrator 4E7FFA49-9899-432E-B760-F6C3386C8833 1571898293 Administrator 1577159330 Administrator 922A1837-1B84-43FD-B8B3-75C1030EBA68 IBPS_PARTY_EMPLOYEE【员工】 IBPS_PARTY_EMPLOYEE 1468846452 Administrator 1577159330 Administrator 员工 98528191-2F76-41BA-874A-437A72C78AF0 ID ID_ 1468846088 Administrator 1577159330 Administrator ID varchar(64) 64 1 C05E0794-D648-4795-82AA-2D414385506F 名称 NAME_ 1468846143 Administrator 1577159330 Administrator 名称 varchar(64) 64 1 F257859C-C3D6-44B2-AE3C-B448B8FF3359 图片 PROFILE_ 1427937745 Administrator 1577159330 Administrator 图片 varchar(255) 255 9AE6EB67-8523-483E-9784-395C2DE0791F 状态 STATUS_ 1373340426 Administrator 1577159330 Administrator 状态。inactive=未激活；actived=激活； varchar(64) 64 372E7EB5-5396-4CE7-B3FB-C9B623DA6C37 性别 GENDER_ 1468548721 Administrator 1577159330 Administrator 性别 varchar(64) 64 25429E53-4385-4646-A2CE-662C858955B0 邮箱 EMAIL_ 1468548824 Administrator 1577159330 Administrator 邮箱 varchar(64) 64 22A7717C-4D57-4C65-9AF4-3B56D301DEE7 地址 ADDRESS_ 1468548824 Administrator 1577159330 Administrator 地址 varchar(255) 255 2618B0D1-6350-4B73-B861-CCCE60522139 电话 MOBILE_ 1468549189 Administrator 1577159330 Administrator 电话 varchar(40) 40 D7EE5DCC-26CC-47C9-BDD9-1862D2C28AF4 QQ QQ_ 1468549189 Administrator 1577159330 Administrator QQ varchar(20) 20 A3730D8F-FE26-4341-B3D4-01B8CBC3CD92 照片 PHOTO_ 1468549315 Administrator 1577159330 Administrator 照片 varchar(255) 255 B643F239-DC23-4C36-ADD0-819E9C29CABC 岗位（1~N个） POSITIONS_ 1463478064 Administrator 1577159330 Administrator 岗位（1~N个）。通过数据字典维护，默认是普通员工，employee=普通员工；mgr=经理；teamleader=组长；auditor=订单审单员 varchar(1024) 1024 8657E607-0926-474C-8FA0-2EB14CA21A9B 归属组织 ID GROUP_ID_ 1470305174 Administrator 1577159330 Administrator 归属组织 ID varchar(64) 64 FC495CC6-6E83-4249-8F3C-28D408DF00E3 微信账号 WC_ACCOUNT_ 1526467224 Administrator 1577159330 Administrator 微信账号 varchar(64) 64 460687D5-0DFC-4CBE-AF90-4733F2523799 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime 1 16FD5973-337A-4103-ACC0-5DD313B196F9 更新时间 UPDATE_TIME_ 1358166325 Administrator 1577159330 Administrator 更新时间 datetime 7FE2D282-C301-4974-940F-E7E46C4A9A75 租户ID TENANT_ID_ 1530865571 Administrator 1577159330 Administrator 租户ID varchar(64) 64 721000BD-53DA-456F-9AEB-4F1338D0E20F Key_1 Key_1 1472865780 Administrator 1577159330 Administrator FD85184E-7F85-4602-88ED-86F4F02E4D63 idx_e_g_id idx_e_g_id 1571899590 Administrator 1577159330 Administrator 9BDDD269-A03F-4CF3-925E-3EFF60E42802 1571899631 Administrator 1577159330 Administrator ADA037B6-6863-4D41-9BBC-980279EA9F7F idx_e_t1_id idx_e_t1_id 1571899590 Administrator 1577408803 Administrator A43340CF-CDB2-4E14-A8C3-D8AC2A524734 1571899641 Administrator 1577159330 Administrator 21E81AEE-EB42-4138-8BDA-C4832E888F2E idx_e_s idx_e_s 1571899826 Administrator 1577159330 Administrator E00E04CF-D3E0-4C53-B0A4-234F3822C697 1571899842 Administrator 1577159330 Administrator 845BB8F4-EA0A-4563-8781-E6961B78BD40 IBPS_PARTY_POSITION【岗位】 IBPS_PARTY_POSITION 1468846733 Administrator 1577159330 Administrator 岗位 6334CC85-6585-4187-94A6-BEF2CB8498FD ID ID_ 1468846737 Administrator 1577159330 Administrator ID varchar(64) 64 1 8E67212F-B182-428A-B0EA-6DAECBC92370 岗位名称 NAME_ 1468375510 Administrator 1577159330 Administrator 岗位名称 varchar(64) 64 1 0F34A3E0-3EB5-4D01-BD72-0C3447385FA5 别名 POS_ALIAS_ 1472606955 Administrator 1577159330 Administrator 岗位别名，业务主键，唯一 varchar(64) 64 1 28503CA7-60A0-4F47-A578-30186D9708E3 等级ID LEVEL_ID_ 1470815775 Administrator 1577159330 Administrator 等级ID varchar(64) 64 8F5FB662-D90C-4966-B2B4-F867F8552433 岗位业务类型 TYPE_ 1468378254 Administrator 1577159330 Administrator 岗位业务类型。从枚举获得，一个岗位关联一个业务类型。 varchar(64) 64 D56FB81F-5A3F-4E30-96C9-AE1FBC4300DA 岗位说明 DESC_ 1468380884 Administrator 1577159330 Administrator 岗位说明 varchar(512) 512 6352CF5F-31B1-403E-916D-788FBAE6D811 关联组织 ID ORG_ID_ 1471319115 Administrator 1577159330 Administrator 关联组织 ID varchar(64) 64 4D052674-952C-4869-A675-C19F07E1CCF2 关联角色 IDs REL_ROLES_ 1468381752 Administrator 1577159330 Administrator 关联角色 IDs。保存角色ID的串，多个之间逗号分隔。 varchar(1024) 1024 65F693DA-1D4A-4140-ACAA-A05DDDA0327F 创建时间 CREATE_TIME_ 1358166325 Administrator 1577159330 Administrator 创建时间 datetime 1 2F8AEFAE-1971-423B-ACB6-FABB6D8FBA98 更新时间 UPDATE_TIME_ 1358166325 Administrator 1577159330 Administrator 更新时间 datetime C8484549-BCEA-42AC-9643-D13B8609DB39 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 80CF6CED-83AC-4932-9D9C-0565C746CC2B Key_1 Key_1 1468846737 Administrator 1577159330 Administrator F42A2CED-03B3-40A8-97A0-CB7B02ED3E77 idx_p_p_a idx_p_p_a 1571898304 Administrator 1577159330 Administrator 407C410D-BC2A-4BDA-9954-FAED2DD6A366 1571898347 Administrator 1577159330 Administrator 5E3CD541-A1FC-40DE-A443-251B3E4EEEA4 idx_p_l_id idx_p_l_id 1571898347 Administrator 1577159330 Administrator 32D9735A-D5D6-40B5-BA19-279E627BDC55 1571898365 Administrator 1577159330 Administrator 4622FDD0-699E-4D3C-ABA4-E71C7FC53BEF idx_p_o_id idx_p_o_id 1571898365 Administrator 1577159330 Administrator 91F8C663-50CA-4795-8B4D-721F598B0D71 1571898383 Administrator 1577159330 Administrator 749C99FA-5C0B-4AAC-9137-27DF7BFC4D0F idx_p_t_id idx_p_t_id 1571898383 Administrator 1577159330 Administrator 16195C83-355B-4283-B985-CE4D15B736C8 1571898402 Administrator 1577159330 Administrator 7DB0A552-5931-4F88-A618-3ED4EFEBBA27 IBPS_PARTY_ROLE【角色表】 IBPS_PARTY_ROLE 1469003919 Administrator 1577159330 Administrator 角色表 9250B1AF-77A6-4CA7-B545-289025CEFAEF 主键 ID_ 1469003970 Administrator 1577159330 Administrator 主键 varchar(64) 64 1 90E2EE03-2FF7-4038-AF5E-26603FAF17D1 角色名 NAME_ 1469003970 Administrator 1577159330 Administrator 角色名 varchar(64) 64 1 1E8155F2-2871-481B-AD72-9681E532A24C 角色别名 ROLE_ALIAS_ 1469003970 Administrator 1577159330 Administrator 角色别名 varchar(64) 64 1 97CAEE6E-2A8D-47D7-B8BE-22E5158EAA00 角色描述 ROLE_NOTE_ 1526544083 Administrator 1577159330 Administrator 角色描述 longtext DBA8E12F-F80F-46B8-BA32-8966D7E12E0A 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 666A3D60-5BAF-4A9F-AF00-F268EBEC16CC Key_1 Key_1 1469003970 Administrator 1577159330 Administrator 5F9FBA7B-AC99-4303-8AB6-A21CE4B927B1 idx_r_r_a idx_r_r_a 1571898616 Administrator 1577159330 Administrator 70C13F16-775C-4FBE-A902-DE3A7A9B716A 1571898643 Administrator 1577159330 Administrator 077D81DA-D578-4B1A-A70E-531602656F33 idx_r_t_id idx_r_t_id 1571898616 Administrator 1577159330 Administrator BE613AEF-90D4-42D6-973E-04A276FB6980 1571898651 Administrator 1577159330 Administrator 13230D91-CEAF-4E3A-9BD8-A1DA0ACDFAD2 IBPS_PARTY_USER_ROLE【用户角色】 IBPS_PARTY_USER_ROLE 1471673651 Administrator 1577159330 Administrator 用户角色关联信息 3968F38E-A82B-4DEF-BDED-7E1EE322111A 主键 ID_ 1471673715 Administrator 1577159330 Administrator 主键 varchar(64) 64 1 CC50120A-5F0B-4088-A57E-D131097C10A6 用户ID USER_ID_ 1526550787 Administrator 1577159330 Administrator 用户ID varchar(64) 64 27555D1A-BF7F-4860-95AF-3C3399DCF4C8 角色ID ROLE_ID_ 1526550787 Administrator 1577159330 Administrator 角色ID varchar(64) 64 C284B959-E6CC-4F05-A70B-A93CA544A27D 创建时间 CREATE_TIME_ 1472868442 Administrator 1577159330 Administrator 创建时间 datetime 1 0332BCC0-E147-4D0F-9763-51B8DBE61F85 Key_1 Key_1 1471673715 Administrator 1577159330 Administrator 3ADFAC91-2D19-4CD1-9FC1-DEBAF3F3D6A4 idx_u_r_u_id idx_u_r_u_id 1571898821 Administrator 1577159330 Administrator C67D1943-5A30-467B-BEA5-4FF31D510EA4 1571898843 Administrator 1577159330 Administrator 8BFA4C06-4F07-4D69-A9BF-370C881D2509 idx_u_r_r_id idx_u_r_r_id 1571898821 Administrator 1577159330 Administrator B66898BB-EF79-40D4-9CE0-65BA822BB102 1571898849 Administrator 1577159330 Administrator 4A773539-8159-46BB-9429-96374CC1FCB5 IBPS_PARTY_ORG_AUTH【分级管理】 IBPS_PARTY_ORG_AUTH 1472117745 Administrator 1577159330 Administrator 分级管理授权 32BE31FE-1DAA-48C8-97FD-9FC5B23F5AC3 主键 ID_ 1472117798 Administrator 1577159330 Administrator varchar(64) 64 1 4E67C433-70E4-416D-BF0F-34505EB8ECBF 分级管理员ID MANAGER_ID_ 1472117798 Administrator 1577159330 Administrator 被授权的管理员ID varchar(64) 64 77760AA6-42D7-4473-A03C-8EA071B64324 被授权组织ID ORG_ID_ 1472117798 Administrator 1577159330 Administrator 被授权组织ID varchar(64) 64 AD7C6BA2-4BE4-4EC4-B18A-32493CEB7C77 子用户组管理权限 ORG_PERMS_ 1472117798 Administrator 1577159330 Administrator 子用户组管理权限，授权组织的管理权限 varchar(4000) 4000 AFC22CB4-B6AD-4B32-A954-F144D0830EC6 关联用户管理权限 USER_PERMS_ 1472117798 Administrator 1577159330 Administrator 关联用户管理权限 varchar(4000) 4000 E71DA3A4-5E91-4050-AA8B-F9EDFBE23A02 创建时间 CREATE_TIME_ 1472118069 Administrator 1577159330 Administrator 创建时间 datetime 20F3333C-C089-48B2-A65E-6274176799D4 更新时间 UPDATE_TIME_ 1472118069 Administrator 1577159330 Administrator 更新时间 datetime DEEBF468-6292-4A33-B0DC-958C63E24EAA 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 00640C5E-652C-4046-B104-AA8ED1734F1B Key_1 Key_1 1472117798 Administrator 1577159330 Administrator A1D6E28E-E910-49F9-A921-B24643BF142C idx_o_a_m_id idx_o_a_m_id 1571898119 Administrator 1577159330 Administrator B82A3CE3-870A-4B76-B836-5B8F1D578209 1571898152 Administrator 1577159330 Administrator 0B9C2B78-0C3C-435F-9ABE-E1EB51CD922A idx_o_a_o_id idx_o_a_o_id 1571898152 Administrator 1577159330 Administrator 830C3881-9FD9-489E-8C54-67D735C91687 1571898169 Administrator 1577159330 Administrator 89011F31-96BE-40C6-B30B-8E105960FBB8 idx_o_a_t_id idx_o_a_t_id 1571898169 Administrator 1577159330 Administrator 47DE14E5-B096-470C-A95E-112FDE1D6C25 1571898186 Administrator 1577159330 Administrator 9560B6C4-A508-4E3F-BB87-56BBE784C0AB IBPS_PARTY_USER_GROUP【用户与组关系】 IBPS_PARTY_USER_GROUP 1471673651 Administrator 1577159330 Administrator 用户与组关系信息 25A2BC1B-0192-4EF6-AE2A-7B309A580E22 主键 ID_ 1471673715 Administrator 1577159330 Administrator 主键 varchar(64) 64 1 96E4E817-F667-4030-85FE-BA68B1A0A990 用户ID USER_ID_ 1471673715 Administrator 1577159330 Administrator 用户ID varchar(64) 64 79E7EBEB-EC6B-4D42-BF36-E6DD392B0B96 组ID GROUP_ID_ 1471673715 Administrator 1577159330 Administrator 组ID varchar(64) 64 48F0E0A9-4198-4F25-8E81-7A4C2202277E 创建时间 CREATE_TIME_ 1472868442 Administrator 1577159330 Administrator 创建时间 datetime 1 CA34350A-0FC1-489B-A97D-2E7780366D61 Key_1 Key_1 1471673715 Administrator 1577159330 Administrator 2B7CC0A1-77A1-4744-BD80-1E43C2097180 idx_u_g_g_id idx_u_g_g_id 1571898668 Administrator 1577159330 Administrator 1CF3F5B2-D43A-48A1-9953-4A3A94C7EB5F 1571898712 Administrator 1577159330 Administrator 47E49781-D1BE-4869-8688-C9D05081D242 IBPS_PARTY_GROUP【用户组】 IBPS_PARTY_GROUP 1469003919 Administrator 1577159330 Administrator 用户组 D29716ED-58B5-4451-847D-4E273BCB2534 主键 ID_ 1469003970 Administrator 1577159330 Administrator 主键 varchar(64) 64 1 F5BA10E8-10EB-45FE-AEE1-81F4064F174B 用户组名称 NAME_ 1469003970 Administrator 1577159330 Administrator 用户组名称 varchar(64) 64 1 8B92B3F0-D945-4AA5-BD43-4515661F2D20 用户组别名 GROUP_ALIAS_ 1469003970 Administrator 1577159330 Administrator 用户组别名 varchar(64) 64 1 4ADFB7B0-6191-4C8D-AD2A-F88C4EC7857D 用户组描述 GROUP_NOTE_ 1469003970 Administrator 1577159330 Administrator 用户组描述 varchar(4000) 4000 1F4D347C-E738-45A5-B94F-1568B4664B9E 租户ID TENANT_ID_ 1531099219 Administrator 1577159330 Administrator 租户ID varchar(64) 64 E903C3F0-7FF5-41DF-B521-D90792DC1D44 Key_1 Key_1 1469003970 Administrator 1577159330 Administrator CEC6A439-60BB-446F-9377-B4C80BD2D58C idx_g_g_a idx_g_g_a 1571897887 Administrator 1577159330 Administrator 950FA13E-63D4-4BD0-B36E-9CE40B8A74E3 1571897906 Administrator 1577159330 Administrator 40E66A4A-9637-4E78-8E2D-752D73A50F72 idx_g_t_id idx_g_t_id 1571897906 Administrator 1577159330 Administrator 133759C2-C362-4F9E-8CED-6C0959960CBE 1571897921 Administrator 1577159330 Administrator D0E3400D-158F-47DE-8559-11EF88ED529A IBPS_PARTY_USER_LIMIT【用户限制】 IBPS_PARTY_USER_LIMIT 1510111959 Administrator 1577159330 Administrator 用户限制：如锁定时长 280D87C9-D1C6-4C24-BC60-B22C8D8E8980 主键 ID_ 1510111963 Administrator 1577159330 Administrator 主键 varchar(64) 64 1 0BF16008-A572-4BCA-BB21-2B1F6CB64538 用户账号 ACCOUNT_ 1510111963 Administrator 1577159330 Administrator 用户账号 varchar(64) 64 1 D856FDA4-45EC-4B0A-A114-C470B083B94F 锁定模式 LOCK_MODE_ 1510112113 Administrator 1577159330 Administrator 锁定模式 varchar(64) 64 90B937B9-717D-466A-BDC3-F81CD8BD0FE5 锁定时间 LOCK_TIME_ 1510112113 Administrator 1577159330 Administrator 锁定时间 datetime 6E39B4FA-6025-48B9-8E6E-6225571D682A 解锁时间 UNLOCK_TIME_ 1510112113 Administrator 1577159330 Administrator 解锁时间 datetime 54B27042-9AC7-4664-B237-6272FDF4DE68 租户ID TENANT_ID_ 1531099502 Administrator 1577159330 Administrator 租户ID varchar(64) 64 6C6E2F8B-0FCB-45A3-96D0-3F5627A46485 Key_1 Key_1 1510111963 Administrator 1577159330 Administrator 0A3C9308-EF9E-4C38-B7C4-8B8135C1F716 idx_u_l_acc idx_u_l_acc 1571898722 Administrator 1577159330 Administrator 844F54F3-2434-461C-924F-8C89AECD0053 1571898799 Administrator 1577159330 Administrator 28BE0F09-B59B-4C48-8689-874BE3AC5DD2 idx_u_l_l_m idx_u_l_l_m 1571898722 Administrator 1577159330 Administrator 2DBE3D91-0E4B-485F-AC7F-8C12373D24FF 1571898805 Administrator 1577159330 Administrator 0FE26E66-F7B2-4790-AAC6-B86B60AC84FB idx_u_l_t_id idx_u_l_t_id 1571898722 Administrator 1577159330 Administrator 694193D1-B13A-463F-A414-F822CF1C2173 1571898811 Administrator 1577159330 Administrator B3A3F7CF-0F72-4D1A-B245-EE4B55602026 IBPS_PARTY_UNIQUE【用户唯一校验表】 IBPS_PARTY_UNIQUE 1468846452 Administrator 1591788784 Administrator 用户唯一校验表 5A552BF9-0EC3-47FF-AC91-09B856CF558D ID ID_ 1468846088 Administrator 1591788557 Administrator ID varchar(64) 64 1 F3AA2F15-7739-4621-9356-E1374D007A12 账号 ACCOUNT_ 1468846143 Administrator 1591788702 Administrator 账号 varchar(64) 64 1 E4CE112D-EAC0-487C-92A4-619DD658D875 邮箱 EMAIL_ 1468548824 Administrator 1591788757 Administrator 邮箱 varchar(64) 64 AEE6D774-7E9B-49B6-A7B4-84B97AAA2DFD 电话 MOBILE_ 1468549189 Administrator 1591788747 Administrator 电话 varchar(40) 40 89165826-F07B-4789-B4EF-3FC318700B89 微信账号 WC_ACCOUNT_ 1526467224 Administrator 1591788764 Administrator 微信账号 varchar(64) 64 0C298EC3-1604-4A66-8450-A9EC17B9F06B Key_1 Key_1 1472865780 Administrator 1591788557 Administrator E589D871-906F-49D3-A552-238048B2CB38 idx_unique_ac idx_unique_ac 1591788674 Administrator 1591788740 Administrator BAB79D79-DBEA-4150-AFC0-38E5012FA813 1591788696 Administrator 1591788702 Administrator 6645A643-068F-4039-A532-84C7C8ECE096 idx_unique_m idx_unique_m 1591788696 Administrator 1591788747 Administrator 173AAAE8-2D9E-4922-9660-C5080D07DCF8 1591788740 Administrator 1591788747 Administrator 2FDC7777-6CD1-40C5-A7C5-2120FD732964 idx_unique_em idx_unique_em 1591788696 Administrator 1591788757 Administrator 88E4596A-3855-4611-A2C4-EFCDF2CECA47 1591788748 Administrator 1591788757 Administrator 5C81EE2D-324B-47DC-B8A9-3EEF72B1B435 idx_unique_wac idx_unique_wac 1591788696 Administrator 1591788764 Administrator D5D93F69-BB32-4840-A9C5-A636A69D56C0 1591788758 Administrator 1591788764 Administrator 134AFF2F-8583-4107-82D8-6F29CF4E7EB4 BLOB BLOB 1385003019 win 1464592477 weixin blob C7A309A0-0D15-4027-A381-E784980EA72D PK Or FK PK 1384248302 lenovo 1591788674 Administrator varchar(64) 64 FA4A7A6A-3723-489B-9CD3-BDDDAD8FD9AB PK or FK（字符 64） pk_string 1374633124 lenovo 1591788674 Administrator varchar(64) 64 F8E28353-B909-4F70-B2B4-B3050B48CF63 业务主键（别名） biz_key 1369970573 Administrator 1591788674 Administrator varchar(64) 64 95AF8966-7FE1-4137-8714-EE185E411F46 内容 content 1369972565 Administrator 1591788674 Administrator varchar(1024) 1024 C36DC264-E453-4E49-8AD0-6000EF2048B2 内容（中） mediumContent 1369992723 Administrator 1468848363 weixin varchar(512) 512 8AF087EF-FEF2-42D8-9DAF-DE25A63D0195 内容（短） shortContent 1369992723 Administrator 1591788674 Administrator varchar(255) 255 FB87C816-3E18-405D-96F3-23FA03684180 内容（长） longContent 1369972527 Administrator 1526544146 hcy 在oracle中，varchar2最大长度为4000，此长度为了方便转换数据库。 varchar(4000) 4000 5EAE4F08-492E-4FDB-9A47-47EB099F9CFA 名称 name 1369971414 Administrator 1591788674 Administrator varchar(64) 64 5034B901-9B20-4C73-B906-6026655E7A91 名称（中） mediumName 1369971806 Administrator 1468846609 weixin varchar(40) 40 9CCA6DA7-F45B-4B35-AF2A-11FF2C492388 名称（短） shortName 1369989684 Administrator 1591788674 Administrator varchar(20) 20 60A9F4C8-2DB2-471A-8594-1D22BE1510C5 名称（长） fileName 1369971460 Administrator 1471504492 XUQ varchar(128) 128 78F4CE5D-83A4-4DDD-A15B-24C09EF06225 大文本 text 1369971839 Administrator 1539069481 Administrator longtext F2B18717-7055-41E8-989C-01CE2B1512DD 大文本（长） longtext 1369971938 Administrator 1496806850 XUQ longtext 1A01463E-3412-48F9-AF75-D595F197DD03 性别 GENDER 1370228245 Administrator 1464592477 weixin F=女性；M=男性 char(1) 1 6ED16A23-F6CF-48D5-A44F-6B947EE47258 整数 int 1369972099 Administrator 1538269497 Administrator int 25B85E76-7B6C-4FAD-9769-A3EDB71FF331 整数（短） shortNumber 1370161834 Administrator 1464592477 weixin smallint 4479D2E6-83D6-44BF-A93E-B918BE11851D 整数（长） long 1369992990 Administrator 1464597760 weixin bigint C4B28CEB-A548-4F95-8057-BD7C1EC404AC 时间 datetime 1369971539 Administrator 1591788674 Administrator datetime 575365EB-C47F-4B9B-B12D-F508DA126A1E 时间（短） date 1369971569 Administrator 1464592477 weixin date 67268C35-8B58-4F3E-8857-A7D95C8B4B95 是否 bool 1370228245 Administrator 1468846285 weixin 是 Y ；否 N char(1) 1 1 EC807CEC-D7E3-4518-AE82-3283CFDA6BA4 浮点（低精度） float 1369993105 Administrator 1464592477 weixin decimal(14,2) 14 2 1218FD6D-059B-43E4-B222-4D96A7A2B8A0 浮点（高进度）| 金额 money 1369972131 Administrator 1464592477 weixin decimal(20,4) 20 4 38D4A353-FF2B-4A95-BF3A-933AE96D4B0A 类型或状态（字符） typeOrStatus 1369996458 Administrator 1591788674 Administrator varchar(64) 64 61379F51-9F6D-4AE9-BFA8-93C314558CA1 PUBLIC PUBLIC 1464592449 weixin 1464592449 weixin 9EC4651A-EA68-4824-9392-EBB06A0F5942 MySQL 5.0 MYSQL50 1464597234 weixin 1467617409 sic file:///%_DBMS%/mysql50.xdb F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 1276524678