495266E2-4A0A-428D-A231-8241A0B7D15E saas saas 1575252712 ChenJianDong 1595813256 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=crebas GenScriptName1= GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName=D:\项目文件\中治建筑Saas\数据库设计\ 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=254 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=64 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=64 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=64 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=254 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=254 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= 5A1C2B30-FEF1-4AAC-A940-95E5F1983951 MySQL 5.0 MYSQL50 1575252711 ChenJianDong 1575252711 ChenJianDong F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 1EA311F2-710F-4FAD-85F0-1F43E4C9B6D4 saas saas 1575252712 ChenJianDong 1595813256 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=0 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 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 {\rtf1\ansi\ansicpg936\deff0\nouicompat\deflang1033\deflangfe2052{\fonttbl{\f0\froman\fcharset134 \'ce\'a2\'c8\'ed\'d1\'c5\'ba\'da;}{\f1\fnil\fcharset0 Microsoft Sans Serif;}} {\*\generator Riched20 10.0.18362}\viewkind4\uc1 \pard\f0\fs20\lang2052\'b9\'a6\'c4\'dc\'cc\'d7\'b2\'cd\'c4\'a3\'bf\'e9\f1\par } 1589449281 1589457220 ((26321,32618), (75461,37992)) 4130 0 16711680 16777215 12632256 新宋体,8,N 1 1575295313 1591861430 ((-2313,23254), (8448,24504)) ((8048,23879),(-1913,23879)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1575295766 1589457202 ((56964,23831), (60836,25081)) ((57364,24456),(60436,24456)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1575295768 1589457202 ((42460,10807), (51886,19535)) ((51486,19135),(51486,11432),(42860,11432)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1575295825 1589457202 ((41615,-7427), (47817,-6177)) ((47417,-6802),(42015,-6802)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1575295830 1589457202 ((42460,290), (55440,10857)) ((55040,690),(55040,10232),(42860,10232)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1575295842 1589457202 ((62263,-5229), (67864,19840)) ((62663,-4829),(67239,-4829),(67239,19440)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 2 1575253913 1589457202 -1 ((60436,18993), (74268,29919)) 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 1575274241 1589457202 -1 ((28467,-14031), (42015,427)) 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 1575291693 1589457202 -1 ((28986,5217), (42860,15247)) 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 1575291996 1589457202 -1 ((45608,19135), (57364,29997)) 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 1575293206 1589457202 -1 ((47417,-10348), (62663,690)) 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 1575294030 1591861430 -1 ((-15877,16350), (-1913,31408)) 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 1575294448 1589457243 -1 ((8048,20049), (21818,30117)) 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 {\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fcharset0 Microsoft Sans Serif;}{\f1\froman\fcharset134 \'ce\'a2\'c8\'ed\'d1\'c5\'ba\'da;}} {\*\generator Msftedit 5.41.21.2510;}\viewkind4\uc1\pard\f0\fs20 IBPS\lang2052\f1 _\lang1033\f0 AUTH\lang2052\f1 _\lang1033\f0 RES\lang2052\f1\'b1\'ed\'d0\'c2\'d4\'f6\lang1033\f0 tenant\lang2052\f1 _\lang1033\f0 type\lang2052\f1 _\'d7\'d6\'b6\'ce\{\lang1033\f0 init:\lang2052\f1\'b3\'f5\'ca\'bc\'bb\'af\'d7\'ca\'d4\'b4,\lang1033\f0 normal:\lang2052\f1\'bf\'c9\'b9\'ba\'c2\'f2\'d7\'ca\'d4\'b4,\lang1033\f0 forbidden\lang2052\f1 :\'b2\'bb\'d4\'ca\'d0\'ed\'ca\'b9\'d3\'c3\'b5\'c4\'d7\'ca\'d4\'b4\}\par \'d3\'c3\'d3\'da\'b6\'a8\'d2\'e5\'c4\'c4\'d0\'a9\'b2\'cb\'b5\'a5\'d7\'ca\'d4\'b4\'ca\'c7\'c9\'fa\'b3\'c9\'d7\'e2\'bb\'a7\'bf\'d5\'bc\'e4\'ba\'f3\'d0\'e8\'d2\'aa\'b3\'f5\'ca\'bc\'bb\'af\'b5\'c4\'a3\'ac\'b1\'c8\'c8\'e7 \'d3\'c3\'bb\'a7\'b9\'dc\'c0\'ed\'a1\'a2\'cf\'b5\'cd\'b3\'b9\'dc\'c0\'ed \'b5\'c8\'b5\'c8\lang1033\f0\par } 1589449308 1590569304 ((-22658,1390), (3113,15776)) 4130 0 16711680 16777215 12632256 新宋体,8,N 1 1589450078 1589457211 -1 ((78910,18202), (95724,29534)) 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 {\rtf1\ansi\ansicpg936\deff0\nouicompat\deflang1033\deflangfe2052{\fonttbl{\f0\froman\fcharset134 \'ce\'a2\'c8\'ed\'d1\'c5\'ba\'da;}{\f1\fnil\fcharset0 Microsoft Sans Serif;}} {\*\generator Riched20 10.0.18362}\viewkind4\uc1 \pard\f0\fs20\lang2052\'d4\'da\'cf\'df\'d6\'a7\'b8\'b6\'c4\'a3\'bf\'e9\f1\par } 1589450098 1589457225 ((77659,32536), (125853,37910)) 4130 0 16711680 16777215 12632256 新宋体,8,N 1 1589451055 1590570076 -1 ((7838,4614), (21918,16988)) 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 1589451608 1590569306 -1 ((-22398,-11469), (-8150,-1515)) 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 {\rtf1\ansi\ansicpg936\deff0\nouicompat\deflang1033\deflangfe2052{\fonttbl{\f0\froman\fcharset134 \'ce\'a2\'c8\'ed\'d1\'c5\'ba\'da;}{\f1\fnil\fcharset0 Microsoft Sans Serif;}} {\*\generator Riched20 10.0.18362}\viewkind4\uc1 \pard\f0\fs20\lang2052\'bb\'e1\'d3\'d0\'d2\'bb\'b8\'f6\'bc\'c6\'bb\'ae\'c8\'ce\'ce\'f1\'c0\'b4\'c5\'dc\'d5\'e2\'d5\'c5\'b1\'ed\'c5\'d0\'b6\'cf\'d7\'e2\'bb\'a7\'d7\'ca\'d4\'b4\'ca\'c7\'b7\'f1\'b5\'bd\'c6\'da\'a3\'ac\'ca\'c7\'b7\'f1\'d0\'e8\'d2\'aa\'cd\'a8\'d6\'aa\'d0\'f8\'b7\'d1\f1\par } 1589452008 1590569309 ((-5349,-10239), (6495,-1403)) 4130 0 16711680 16777215 12632256 新宋体,8,N 1 {\rtf1\ansi\ansicpg936\deff0\nouicompat\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fcharset0 Microsoft Sans Serif;}{\f1\froman\fcharset134 \'ce\'a2\'c8\'ed\'d1\'c5\'ba\'da;}} {\*\generator Riched20 10.0.18362}\viewkind4\uc1 \pard\f0\fs20 SaaS\f1\lang2052\'ba\'cb\'d0\'c4\'c4\'a3\'bf\'e9\f0\par } 1589452091 1589457229 ((-25015,32446), (23773,37820)) 4130 0 16711680 16777215 12632256 新宋体,8,N 1 1595813255 1595813265 -1 ((-39907,15323), (-25943,30381)) 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 08EF7277-3899-4339-BA2B-19512100EA4E BLOB BLOB 1385003019 win 1589456669 Administrator blob 9C32DC14-7363-41DD-A230-99067CB2665D PK Or FK PK 1384248302 lenovo 1589456669 Administrator varchar(64) 64 1936B6F4-D9E0-48B0-907D-F7F006780165 PK or FK（字符 64） pk_string 1374633124 lenovo 1595813454 Administrator varchar(64) 64 86ABB455-6C26-425A-80AA-35ED1D342960 业务主键（别名） biz_key 1369970573 Administrator 1595813539 Administrator varchar(64) 64 7BABB662-536B-4DF8-B601-8AE6FD747CAA 内容 content 1369972565 Administrator 1591268471 Administrator varchar(1024) 1024 9635A772-A6C3-4DF3-B817-8C77C92C13DD 内容（中） mediumContent 1369992723 Administrator 1591268603 Administrator varchar(512) 512 DFC62F98-8737-4DFC-9F75-8B36D853EBDC 内容（短） shortContent 1369992723 Administrator 1595813445 Administrator varchar(255) 255 F0268CE8-0341-4D1E-8CD0-E2E2590F4736 内容（长） longContent 1369972527 Administrator 1589459872 Administrator 在oracle中，varchar2最大长度为4000，此长度为了方便转换数据库。 varchar(4000) 4000 081C1541-B0A2-42BF-A1B8-EED6944F9CE5 名称 name 1369971414 Administrator 1595813445 Administrator varchar(64) 64 BE14CD63-4572-4C5E-8AB6-789852F71785 名称（中） mediumName 1369971806 Administrator 1589460076 Administrator varchar(40) 40 CE1CAAF1-C4C6-4167-8CD8-4DD3792A2E6F 名称（短） shortName 1369989684 Administrator 1589460076 Administrator varchar(20) 20 39BE5488-6731-48B6-AD37-77632C064DBE 名称（长） fileName 1369971460 Administrator 1589459430 Administrator varchar(128) 128 BB8AD20F-6502-4DB2-8E21-B166B78751D5 大文本 text 1369971839 Administrator 1591861470 Administrator longtext 70DBAADE-E6E7-418A-9674-35636B6F2A15 大文本（长） longtext 1369971938 Administrator 1591861470 Administrator longtext FAC03A5E-AE35-4B1B-A166-A1C23C57DAE1 性别 GENDER 1370228245 Administrator 1589457890 Administrator F=女性；M=男性 char(1) 1 06466292-3D6B-4060-94FC-054F04FB71F7 整数 int 1369972099 Administrator 1589460076 Administrator int 18FAA9E2-508D-4213-8925-0FCAE3C11886 整数（短） shortNumber 1370161834 Administrator 1589456669 Administrator smallint D9619E53-1603-4430-B2CA-05114C877194 整数（长） long 1369992990 Administrator 1589458929 Administrator bigint FDEA638B-D928-4838-BD23-56464301BA7B 时间 datetime 1369971539 Administrator 1595813630 Administrator datetime 29D593C6-8FEE-43FA-9FFA-1E73B7307444 时间（短） date 1369971569 Administrator 1589456669 Administrator date FA897BA9-D87F-430F-B8E8-B5835A400410 是否 bool 1370228245 Administrator 1589459041 Administrator 是 Y ；否 N char(1) 1 1 F7029126-3E41-4180-AF7C-EC4666D0CAA9 浮点（低精度） float 1369993105 Administrator 1589456669 Administrator decimal(14,2) 14 2 0544C81F-29C5-4E10-9895-6BB3EA80912E 浮点（高进度）| 金额 money 1369972131 Administrator 1589460076 Administrator decimal(20,4) 20 4 F9AF3C94-C696-4632-B44A-C075706805B0 类型或状态（字符） typeOrStatus 1369996458 Administrator 1595813445 Administrator varchar(20) 20 806660B6-EB9A-4639-AC16-796F2405609E 套餐模块-套餐表 IBPS_SAAS_SETMEAL 1575253913 ChenJianDong 1590457471 Administrator 套餐模块-套餐表 48AE4FBD-E1FE-4C26-8E5C-20516A029F5C 主键 ID_ 1575253995 ChenJianDong 1590457471 Administrator 主键 varchar(64) 64 1 62619C4D-6787-4533-8001-31BE34A89736 套餐名称 NAME_ 1575254057 ChenJianDong 1590457471 Administrator 套餐名称 varchar(255) 255 0C914972-0228-4E51-A210-643C83415E4A 套餐资费 PRICE_ 1575254213 ChenJianDong 1590457471 Administrator 套餐资费 decimal(20,4) 20 4 5C9BDD9C-46AB-467B-9D49-F87C5B645139 套餐创建人ID CREATE_BY_ 1575254259 ChenJianDong 1590457471 Administrator 套餐创建人ID varchar(64) 64 D59E4E3C-02D4-4ED2-AEB4-4AC07BCED989 套餐创建时间 CREATE_TIME_ 1575254296 ChenJianDong 1590457471 Administrator 套餐创建时间 datetime BC03AAF4-8AD0-4DAC-94CD-0886619A6F57 套餐备注 NOTE_ 1589452104 ChenJianDongLc 1590457471 Administrator 套餐备注 varchar(255) 255 0CD3FC0C-0007-4BDE-BF69-767F19C7A50B Key_1 Key_1 1575253995 ChenJianDong 1575254018 ChenJianDong 6D98AD2A-437F-494A-907A-1E7FBC99F305 套餐模块-订单表 IBPS_SAAS_ORDER 1575253913 ChenJianDong 1590457471 Administrator 套餐模块-订单表 1AA9FFEB-C53E-4DE5-B307-F2E61100F560 订单主键 ID_ 1575253995 ChenJianDong 1590457471 Administrator 订单主键 varchar(64) 64 1 F081123C-E6A3-4964-8E98-2A8728AEC0C2 订单流水号 CODE_ 1589452314 ChenJianDongLc 1590457471 Administrator 订单流水号 varchar(64) 64 FB7201D2-D3B9-4F93-8B4E-8C9F59823C9E 订单标题 TITLE_ 1575274261 ChenJianDong 1590457471 Administrator 订单标题 varchar(255) 255 02A07BFC-237C-44B6-9501-2562BAEA81AF 订单单价 PRICE_ 1575274446 ChenJianDong 1590457471 Administrator 订单单价 decimal(20,4) 20 4 7B1839C9-2093-4C28-9C9C-D3FF6DC4BC4C 订单数量 NUM_ 1575274413 ChenJianDong 1590457471 Administrator 订单数量 int E6C91502-255A-4EB5-80E6-1156C3320735 订单金额 AMOUNT_ 1575274312 ChenJianDong 1590457471 Administrator 订单金额 decimal(20,4) 20 4 94062CDF-80C9-4353-A38B-147B9C830A7A 订单开始时间 START_TIME_ 1575274633 ChenJianDong 1590457471 Administrator 订单开始时间 datetime 5D8691CE-AD6D-4037-91D6-D48F3D1E611F 订单结束时间 FINISH_TIME_ 1575274633 ChenJianDong 1590457471 Administrator 订单结束时间 datetime 531B3848-E8C5-4F5E-876C-AEEB4B5B529E 订单支付状态 PAY_STATUS_ 1575274494 ChenJianDong 1590457471 Administrator 订单支付状态 varchar(20) 20 E0A9F482-16E6-4CF8-AB1B-8D1D7DC530E9 订单使用状态 USE_STATUS_ 1575274701 ChenJianDong 1590457471 Administrator 订单使用状态 varchar(20) 20 75FD6921-C74E-40B8-9798-4F23CEC40695 订单创建时间 CREATE_TIME_ 1575293496 ChenJianDongLc 1590457471 Administrator 订单创建时间 datetime F3323BF1-61C8-4267-9F67-FFA0257B1C7A 购买时限 DURATION_ 1589452314 ChenJianDongLc 1590457471 Administrator 购买时限 varchar(40) 40 6E2AC796-2ED4-4719-8CB8-2F1D8C01E8A6 支付者ID BUY_ID_ 1589452314 ChenJianDongLc 1590457471 Administrator 支付者ID varchar(64) 64 53E0FC51-364B-4EA0-B9AF-510457C6677C 租户ID TENANT_ID_ 1589452314 ChenJianDongLc 1590457471 Administrator 租户ID varchar(64) 64 CDFA6720-51B4-475C-B4CF-928F86841975 Key_1 Key_1 1575253995 ChenJianDong 1575274241 ChenJianDong CA566FC7-EC33-41CF-AAF5-44076FDCC3FC 套餐模块-套餐功能子表 IBPS_SAAS_MODEL 1575253913 ChenJianDongLc 1590457471 Administrator 套餐模块-套餐功能子表 19E590FA-CEE0-4B15-8436-479BD4E13BC1 主键 ID_ 1575253995 ChenJianDongLc 1590457471 Administrator 主键 varchar(64) 64 1 17D8D237-161A-4CC9-8A3F-CB37AAB97F5E 功能名称 NAME_ 1575291695 ChenJianDongLc 1590457471 Administrator 功能名称 varchar(64) 64 56255CAF-934E-4B90-A397-2E4FB82C0261 功能资费 PRICE_ 1575291763 ChenJianDongLc 1590457471 Administrator 功能资费 decimal(20,4) 20 4 D6092611-706C-457B-8C99-766C31531247 功能权限ID AUTH_ID_ 1575291850 ChenJianDongLc 1590457471 Administrator 功能权限ID varchar(64) 64 0B1068C4-3000-401A-9C9B-0765A0185020 功能创建人 CREATE_BY_ 1589452149 ChenJianDongLc 1590457471 Administrator 功能创建人 varchar(64) 64 00967865-4E10-4DBE-9432-56CF197C544E 功能创建时间 CREATE_TIME_ 1575293551 ChenJianDongLc 1590457471 Administrator 功能创建时间 datetime A80641A5-0756-41F8-ACC4-5A3A8AFC8986 更新人 UPDATE_BY_ 1589452149 ChenJianDongLc 1590457471 Administrator 更新人 varchar(64) 64 44F65DFA-DFCC-449E-A8C2-0DE710BD454E 更新时间 UPDATE_TIME_ 1589452149 ChenJianDongLc 1590457471 Administrator 更新时间 datetime 186B9E7A-12B3-4D5C-976D-2E17F75FF8B2 Key_1 Key_1 1575253995 ChenJianDongLc 1575291693 ChenJianDongLc D7C7C26C-A478-47F2-A1BC-786B1ECBD68B 套餐模块-功能与套餐关联表 IBPS_SAAS_SETMEAL_REL 1575253913 ChenJianDongLc 1590457471 Administrator 套餐模块-功能与套餐关联表 E8FF1F0F-E3F0-471C-B588-EA69D344ED8E 主键 ID_ 1575253995 ChenJianDongLc 1590457471 Administrator 主键 varchar(64) 64 1 3D8DA7B2-72EA-4C00-99E2-6B4358DC0DC2 套餐ID PACKAGE_ID_ 1575292007 ChenJianDongLc 1590457471 Administrator 套餐ID varchar(64) 64 7A1B1E15-A5B9-498C-9778-A3C62E57AD10 功能ID MODEL_ID_ 1575292007 ChenJianDongLc 1590457471 Administrator 功能ID varchar(64) 64 9E33315F-589A-4FB9-976D-F689C95C1350 Key_1 Key_1 1575253995 ChenJianDongLc 1575291996 ChenJianDongLc 758B7505-A73F-4BC3-9BF2-680552CDB60C 套餐模块-订单明细表 IBPS_SAAS_ORDER_DETAIL 1575253913 ChenJianDongLc 1590457471 Administrator 套餐模块-订单明细表 10836D5D-DB3A-4E16-922E-854C9CC6E29A 明细主键 ID_ 1575253995 ChenJianDongLc 1590457471 Administrator 明细主键 varchar(64) 64 1 4DF791B3-0BC1-49B1-B7DE-4B3D2B2F1F9F 明细类型 DETAIL_TYPE_ 1575293219 ChenJianDongLc 1590457471 Administrator 明细类型 varchar(20) 20 5563C940-A21B-450A-88A5-5DAA1CCA6DAF 明细金额 DETAIL_AMOUNT_ 1575293268 ChenJianDongLc 1590457471 Administrator 明细金额 decimal(20,4) 20 4 3559C1C7-B022-4DC1-803F-83252861002D 明细表关联ID DETAIL_REL_ID_ 1575293390 ChenJianDongLc 1590457471 Administrator 明细表关联ID varchar(64) 64 F58F0EA7-8051-4822-861A-5A0325EFAF8C 明细所属订单ID ORDER_ID_ 1575293470 ChenJianDongLc 1590457471 Administrator 明细所属订单ID varchar(64) 64 5C410A3B-129B-445B-A382-3CEA03FF8094 明细名字 DETAIL_NAME_ 1589452239 ChenJianDongLc 1590457471 Administrator 明细名字 varchar(64) 64 B20E20AD-0BD3-4BEA-95B4-82463BC7D47D 明细父ID PARENT_ID_ 1589452239 ChenJianDongLc 1590457471 Administrator 明细父ID varchar(64) 64 19C3FBAE-BB35-4B6F-A663-A7CB58996F01 明细备注 DETAIL_NOTE_ 1589452239 ChenJianDongLc 1590457471 Administrator 明细备注 varchar(255) 255 D32B4293-670E-4344-AFF3-6F635D3379EA Key_1 Key_1 1575253995 ChenJianDongLc 1575293206 ChenJianDongLc 90A86724-BA05-4E6B-B775-6FF5A5661853 SaaS核心-租户(企业)信息表 IBPS_SAAS_TENANT 1575253913 ChenJianDongLc 1597116589 Eddy SaaS核心-租户(企业)信息表 2DC4110A-1DA8-4952-A2AB-F37B6F36544A 主键 ID_ 1575253995 ChenJianDongLc 1590457471 Administrator 主键 varchar(64) 64 1 D913B020-F220-4754-8CCE-1FF04A9C5279 父ID PARENT_ID_ 1590568487 Administrator 1597116584 Eddy 父ID varchar(64) 64 69E73073-33E4-4E8C-B5EB-5093989F5978 公司编码 CODE_ 1591231868 Administrator 1597116617 Eddy 公司编码 varchar(64) 64 1 F4FD12CF-43E4-48FA-B45A-5264F22C8F85 公司名称 NAME_ 1575294055 ChenJianDongLc 1590457471 Administrator 公司名称 varchar(64) 64 1 86DDE9EC-5398-44AE-A906-84DA5F1C5E72 公司规模 SCALE_ 1575294363 ChenJianDongLc 1590457471 Administrator 公司规模 varchar(64) 64 1 35967C71-1C56-4221-A692-9F488DE50D62 地理区域 AREA_ 1591612508 Administrator 1591612549 Administrator 地理区域 varchar(255) 255 46084189-5298-4D69-B0E7-E35E2615929E 详细地址 STREET_ 1591612508 Administrator 1591612549 Administrator 详细地址 varchar(255) 255 3BDEB85D-9621-4046-B27B-E8667634340D 所属空间 SCHEMA_ 1576163387 ChenJianDongLc 1590576508 Administrator 所属空间 varchar(255) 255 EFDFD4EA-AA44-495D-B149-42988E578D51 空间状态 SCHEMA_STATUS_ 1576163428 ChenJianDongLc 1591177076 Administrator 空间状态{WAIT:待创建,CREATING:创建中,CREATED:已创建,FAILED:创建失败,ERROR:删除失败} varchar(20) 20 1 4D59E1D7-F093-4160-ACB9-ECB717EDF47B 租户状态 STATUS_ 1576163312 ChenJianDongLc 1590569242 Administrator 租户状态{ENABLED:启用,DISABLED:禁用} varchar(20) 20 1 7833D978-327C-4D23-AD43-D5064553E209 审批状态 APPROVE_STATUS_ 1589451911 ChenJianDongLc 1590569390 Administrator 审批状态{WAIT:待审批,PASSED:通过,REFUSED:拒绝} varchar(20) 20 1 78778D99-3A05-4A42-939B-3261F04C6554 业务同步状态 BUSINESS_STATUS_ 1591842978 Administrator 1591843033 Administrator 业务同步状态{WAIT:待同步,SYNCING:同步中,SYNC:已同步,FAILED:同步失败} varchar(20) 20 8797519B-483C-4A66-BAFC-AB91DCA6C1BF 注册时间 CREATE_TIME_ 1575293602 ChenJianDongLc 1590457471 Administrator 注册时间 datetime 1 32EC7848-33E8-4562-86E2-B827A6ACB971 更新时间 UPDATE_TIME_ 1580811660 Administrator 1590568852 Administrator 更新时间 datetime 68FF9506-5D80-411F-B941-E6169C111177 失败原因 CAUSE_ 1591861431 Administrator 1591861470 Administrator 失败原因 longtext 34196DEF-B476-4816-B978-EF04FD42B523 Key_1 Key_1 1575253995 ChenJianDongLc 1575294030 ChenJianDongLc 2376A5A3-C066-45E9-A63E-6F146808ED4A idx_t_pid idx_t_pid 1597116544 Eddy 1597116584 Eddy 92F57DFE-E2D3-4093-BFC5-80330C85548A 1597116564 Eddy 1597116584 Eddy 27184841-834C-4796-9998-63C92F41CAB1 idx_t_c idx_t_c 1597116564 Eddy 1597116617 Eddy 2BFA877F-4D5C-46F1-A0F9-EEDE1A3DA120 1597116589 Eddy 1597116617 Eddy 9BEDDED7-49DC-4301-BCB2-F50F76C2A33E SaaS核心-租户与用户关联表 IBPS_SAAS_TENANT_USER_REL 1575253913 ChenJianDongLc 1597116338 Eddy SaaS核心-租户与用户关联表 C6D94325-FA0C-42A5-89B4-D405404876BF 主键 ID_ 1575253995 ChenJianDongLc 1590457471 Administrator 主键 varchar(64) 64 1 B48CE19F-972F-4FB5-B335-388D6BA79006 用户账号 ACCOUNT_ 1589457027 Administrator 1597116334 Eddy 用户账号 varchar(64) 64 1 D3C9DF26-319F-49AC-BA40-FBF2729FB255 租户ID TENANT_ID_ 1575294486 ChenJianDongLc 1597116356 Eddy 租户ID varchar(64) 64 1 CB4D586D-14E1-47CE-9184-11B25A8D6E39 关联类型 REL_TYPE_ 1590570406 Administrator 1591174131 Administrator 关联类型{MASTER:主租户,GUEST:从租户} varchar(20) 20 1 92128980-0E42-4145-BC44-F8B1C3ECE88A 用户类型 TYPE_ 1580292826 ChenJianDongLc 1591174131 Administrator 关联类型{USER:普通用户,MANAGER:管理员,SUPER_MANAGER:超级管理员} varchar(20) 20 1 51E7B5AC-E073-48B4-BB09-FC586F1A24EC 创建时间 CREATE_TIME_ 1575293602 ChenJianDongLc 1590457471 Administrator 创建时间 datetime 9C9AA91F-AAFC-4A89-B4B1-49226978EBC7 Key_1 Key_1 1575253995 ChenJianDongLc 1575294448 ChenJianDongLc F391707D-3C3E-4C81-95D3-FAFC823389F8 idx_tur_acc idx_tur_acc 1597116295 Eddy 1597116334 Eddy 79AA6218-B9A4-4E0C-91E1-963B9AD1E3D5 1597116310 Eddy 1597116334 Eddy 3FF4FFE5-7573-4E4F-AAE2-CDA817905A6A idx_tur_tid idx_tur_tid 1597116310 Eddy 1597116356 Eddy CD9CF5F4-262B-4434-B553-646275545DED 1597116338 Eddy 1597116356 Eddy 92A4ABA9-9D13-4811-8160-8E1488467FAB 支付模块-支付信息表 IBPS_SAAS_PAYMENT 1575253913 ChenJianDongLc 1590457471 Administrator 支付模块-支付信息表 47CEC457-EAF1-4A26-813C-9A9FC2262D2D 主键 ID_ 1575253995 ChenJianDongLc 1590457471 Administrator 主键 varchar(64) 64 1 3641393B-346A-4E15-A4D3-27DB41F6BCEA 创建人名字 CREATE_NAME_ 1589450259 ChenJianDongLc 1590457471 Administrator 创建人名字 varchar(64) 64 B1DE6B32-0115-4BB0-9DB1-D936CC2BF358 对接类型 APP_TYPE_ 1589450259 ChenJianDongLc 1590457471 Administrator 对接类型 varchar(20) 20 B9A0A0E4-816B-45A9-8508-4E19D3AC84AB 系统单号 ORDER_CODE_ 1589450259 ChenJianDongLc 1590457471 Administrator 系统单号 varchar(64) 64 817C0020-A70E-485D-9945-114E5FD46B15 对接应用单号 APP_ORDER_CODE_ 1589450259 ChenJianDongLc 1590457471 Administrator 对接应用单号 varchar(64) 64 830AD376-0EB6-4FD6-8F18-28758065E189 支付金额 PAY_AMT_ 1589450259 ChenJianDongLc 1590457471 Administrator 支付金额 decimal(20,4) 20 4 CE0724FB-FAAA-4FA2-803A-C97666F3FF72 支付状态 PAY_STATUS_ 1589450259 ChenJianDongLc 1590457471 Administrator 支付状态 varchar(20) 20 A41CA16D-E0A8-4C7E-8265-93E56B01F191 支付方ID BUYER_ID_ 1589450259 ChenJianDongLc 1590457471 Administrator 支付方ID varchar(64) 64 7FB7B7E4-E542-4028-9948-5D6170CAC995 创建人 CREATE_BY_ 1589450259 ChenJianDongLc 1590457471 Administrator 创建人 varchar(64) 64 8C959858-B6A1-435B-825E-BAF20B72C021 创建时间 CREATE_TIME_ 1575293602 ChenJianDongLc 1590457471 Administrator 创建时间 datetime D22C0B68-C7F4-4F90-8B0A-02BEF9DEDBA4 备注 NOTE_ 1589450259 ChenJianDongLc 1590457471 Administrator 备注 varchar(255) 255 52F9A40B-10D5-430A-AC23-8D3FAAE5BBFC Key_1 Key_1 1575253995 ChenJianDongLc 1589450078 ChenJianDongLc 17EB2729-72F6-4D5B-91E0-6C235C5EBD0E SaaS核心-租户用户申请表 IBPS_SAAS_TENANT_USER 1575253913 ChenJianDongLc 1597116877 Eddy SaaS核心-租户用户申请表 1A6BE47D-984A-4087-985B-CE9BBAD995EB 主键 ID_ 1575253995 ChenJianDongLc 1590457471 Administrator 主键 varchar(64) 64 1 FB327882-6CBC-4192-8139-6172197D36F3 租户ID TENANT_ID_ 1589451149 ChenJianDongLc 1597116813 Eddy 租户ID varchar(64) 64 1 40119A0F-13A6-4AF3-89DE-2930CBB4A945 姓名 NAME_ 1590570260 Administrator 1590570324 Administrator 姓名 varchar(64) 64 1 503346D9-3466-4EA8-8057-76DB299EBD79 性别 GENDER_ 1589451275 ChenJianDongLc 1590457471 Administrator 性别 varchar(20) 20 26BF19D2-15FE-43BE-A6FC-828751EDC64B 账号 ACCOUNT_ 1589451275 ChenJianDongLc 1597116849 Eddy 管理员账号 varchar(64) 64 1 555B02C6-1CA5-447B-8B75-5EE28896E3C1 密码 PASSWORD_ 1589451275 ChenJianDongLc 1590570318 Administrator 管理员密码 varchar(512) 512 1 8334C0FD-15A4-454C-A27B-866313994DB3 是否超管 IS_SUPER_ 1589451275 ChenJianDongLc 1590569460 Administrator 是否超管 varchar(20) 20 1EA75DDB-32B2-48B6-B2B8-079E5C2D9547 电子邮箱 EMAIL_ 1589451275 ChenJianDongLc 1597116875 Eddy 电子邮箱 varchar(128) 128 1 58FED629-71EA-4F4E-8732-7882B4FC9B27 电话 PHONE_ 1589451275 ChenJianDongLc 1597116894 Eddy 管理员电话 varchar(20) 20 1 D2716FC5-34E9-4465-AE49-250580F67087 数据校验 DATA_CHECK_ 1591268439 Administrator 1591268603 Administrator 数据校验 varchar(512) 512 1 6C0882F3-DE22-40A1-974C-EEB4CDBD2B51 审批状态 STATUS_ 1589451275 ChenJianDongLc 1590569415 Administrator 审批状态{WAIT:待审批,PASSED:通过,REFUSED:拒绝} varchar(20) 20 49DCE21F-1409-43B0-868C-96E4AD872CD8 创建时间 CREATE_TIME_ 1575293602 ChenJianDongLc 1590457471 Administrator 创建时间 datetime 41390319-836F-43C2-9E7A-CA2532876703 Key_1 Key_1 1575253995 ChenJianDongLc 1589451055 ChenJianDongLc 10C82D85-1F5F-4FDF-BED7-32972208F75B idx_stu_tid idx_stu_tid 1597116788 Eddy 1597116813 Eddy DE9061DC-1B69-4165-845A-22B36DDEECA9 1597116795 Eddy 1597116813 Eddy 02A51512-F6CE-463C-81DF-8ACE91F0400B idx_stu_acc idx_stu_acc 1597116795 Eddy 1597116849 Eddy 83D2D50B-EEFE-4DD0-8B4B-5A74B275AC6C 1597116834 Eddy 1597116849 Eddy 6E945F29-BB9A-494F-BD15-CC2EE92B44E7 idx_stu_em idx_stu_em 1597116834 Eddy 1597116875 Eddy 6C41BA41-6E25-4A66-9A33-C995BEC23D0B 1597116854 Eddy 1597116875 Eddy 6E323925-DB1B-420D-BAAF-DE0ED7114AA9 idx_stu_ph idx_stu_ph 1597116854 Eddy 1597116894 Eddy E344F4B6-1931-4950-B886-595B4825A2E3 1597116877 Eddy 1597116894 Eddy 0939F28D-0878-4113-9AD8-3862968DD9DB SaaS核心-租户可用资源表 IBPS_SAAS_TENANT_RES 1575253913 ChenJianDongLc 1590548475 Administrator SaaS核心-租户可用资源表 8E0C7A1B-4ABC-4A4A-9FC3-757AB0AFD3F6 主键 ID_ 1575253995 ChenJianDongLc 1590457471 Administrator 主键 varchar(64) 64 1 F6B49709-F0B1-4E0C-AD4D-D698A6B5874B 租户ID TENANT_ID_ 1589451644 ChenJianDongLc 1590457471 Administrator 租户ID varchar(64) 64 A746DDD8-A485-4311-B862-155695D12B77 租户名称 TENANT_NAME_ 1589451644 ChenJianDongLc 1590457471 Administrator 租户名称 varchar(128) 128 61DA2FF0-8BD6-4484-B758-AF5920D546B2 授权资源ID RES_ID_ 1589451644 ChenJianDongLc 1590457471 Administrator 授权资源ID varchar(64) 64 FCEA34CC-C7A3-4FEC-BCCF-4762B54E6CFA 生效起始时间 BEGIN_DATE_ 1589451644 ChenJianDongLc 1590457471 Administrator 生效起始时间 datetime 8303CC69-FA95-441C-8E70-668E210F33C6 生效结束时间 END_DATE_ 1589451644 ChenJianDongLc 1590457471 Administrator 生效结束时间 datetime 81222948-3885-45E9-89E2-0152C53D945D 状态 STATUS_ 1589451644 ChenJianDongLc 1590457471 Administrator 状态 varchar(20) 20 894BBB82-3B6E-484A-BF89-AEF9457CB047 审批状态 APPROVE_STATUS_ 1589451911 Administrator 1590548475 Administrator 审批状态 varchar(20) 20 1 0CC273DA-1FB5-41A1-BD8A-4B29CDACBB45 是否预警通知 IS_NOTIFY_ 1589451644 ChenJianDongLc 1590457471 Administrator 是否预警通知 varchar(20) 20 C30B5706-CABB-4E82-B07A-5FCA03A3D768 Key_1 Key_1 1575253995 ChenJianDongLc 1589451608 ChenJianDongLc 3C543C4E-17FD-4F75-BFC0-23E3C24628FB SaaS核心-租户(企业)数据库信息表 IBPS_SAAS_TENANT_SCHEMA 1575253913 Administrator 1597116735 Eddy SaaS核心-租户(企业)数据库信息表 C351DC78-225B-4B60-9814-0F92739760D2 主键 ID_ 1575253995 Administrator 1595813256 Administrator 主键 varchar(64) 64 1 4A6BE3DA-9097-4D2F-82F2-4D305AE0EDF9 租户ID TENANT_ID_ 1591231868 Administrator 1597116732 Eddy 租户ID varchar(64) 64 1 6C04A509-67C7-4431-95A5-B56A6ABDF02D 服务ID PROVIDER_ID_ 1595813505 Administrator 1597116732 Eddy 服务ID varchar(64) 64 30D181F3-4639-4A26-A229-5FCA58CB9A4D 数据源别名 DS_ALIAS_ 1595813454 Administrator 1597116753 Eddy 数据源别名 varchar(64) 64 B549C6A7-544D-439A-B359-31EC38A0240B 所属空间 SCHEMA_ 1576163387 Administrator 1595813256 Administrator 所属空间 varchar(255) 255 212BF87E-E356-4270-A448-6ACBD607ECF9 空间状态 SCHEMA_STATUS_ 1576163428 Administrator 1595813256 Administrator 空间状态{WAIT:待创建,CREATING:创建中,CREATED:已创建,FAILED:创建失败,ERROR:删除失败} varchar(20) 20 1 4FB90552-D04F-4461-A5FA-0C9BB4FA7A1C 业务同步状态 BUSINESS_STATUS_ 1591842978 Administrator 1595813701 Administrator 业务同步状态{WAIT:待同步,SYNCING:同步中,SYNC:已同步,FAILED:同步失败} varchar(20) 20 1 B20E4F63-107B-4513-B53D-FE4387B5C2DE 创建时间 CREATE_TIME_ 1575293602 Administrator 1595813701 Administrator 创建时间 datetime B7A71EB2-9985-404C-91BC-F840F70A576D 更新时间 UPDATE_TIME_ 1595813539 Administrator 1595813630 Administrator 更新时间 datetime DE79BDAB-CE3A-4CB2-9BF8-22380AF6A29A 失败原因 CAUSE_ 1591861431 Administrator 1595813256 Administrator 失败原因 longtext D00C1BA3-DA3D-4748-B125-403FCC6C8895 Key_1 Key_1 1575253995 Administrator 1595813256 Administrator B54FCE41-2EBE-4ECB-A229-1F2EB78D28F2 idx_sts_proid idx_sts_proid 1597116650 Eddy 1597116732 Eddy 1848EE48-AA68-4196-9F67-8C98398F509D 1597116672 Eddy 1597116732 Eddy 6FB91362-07E7-4D47-83AF-9E4E1F637120 idx_sts_tid idx_sts_tid 1595813701 Administrator 1595813811 Administrator B90E353F-D9FB-48ED-BE68-F425087F29C2 1595813773 Administrator 1595813811 Administrator 1768E89A-7B2D-45B8-BDFD-176F748EF32F idx_sts_ds_a idx_sts_ds_a 1597116672 Eddy 1597116753 Eddy 478E4607-4DF1-4156-B268-E3DB3745637C 1597116735 Eddy 1597116753 Eddy 22A6A78A-479D-415C-9EA2-841ED6245AAF 租户与关联表关联 FK_SAAS_TENANT_USER_REL_TENANT_ID_SAAS_TENANT_ID_ 1575295313 ChenJianDongLc 1589448983 ChenJianDongLc 1..* 1 1 7F0AE763-D9E3-4D43-8C9F-6A4FF26CF7A4 1575295313 ChenJianDongLc 1575295313 ChenJianDongLc 0506F94B-C5EB-4C40-A39B-BEB22604A282 关联表与套餐表关联 FK_SAAS_PACKAGE_REL_PACKAGE_ID_SAAS_SETMEAL_ID_ 1575295766 ChenJianDongLc 1589449732 ChenJianDongLc 0..* 1 1 2655D226-36A8-4C4F-84B4-4DA7D5DA84B0 1575295766 ChenJianDongLc 1575295766 ChenJianDongLc 002C6BCD-4DB3-440C-8F65-284E7D07735F 关联表与套餐功能关联 FK_SAAS_PACKAGE_REL_MODEL_ID_SAAS_MODEL_ID_ 1575295768 ChenJianDongLc 1589449692 ChenJianDongLc 0..* 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,58={208169ED-E14F-4B04-93BD-2FE48112A769},ReferenceMatch,0= B64B0B58-D9CD-4DAB-94C0-EF5849F5C6E1 1575295768 ChenJianDongLc 1575295775 ChenJianDongLc 07550A09-2A1E-4D02-8AB8-5852BB609B78 订单明细与订单表关联 FK_SAAS_ORDER_DETAIL_ORDER_DETAIL_REL_ID_SAAS_ORDER_ID_ 1575295825 ChenJianDongLc 1589450023 ChenJianDongLc 0..* 1 1 962BF5E1-99CE-48E3-87EB-6EC28D155195 1575295825 ChenJianDongLc 1575295825 ChenJianDongLc FF8A9596-BC93-488C-BD2F-D1DF8B0743F0 订单明细与套餐功能关联 FK_SAAS_ORDER_DETAIL_ORDER_DETAIL_REL_ID_SAAS_MODEL_ID_ 1575295830 ChenJianDongLc 1589449979 ChenJianDongLc 0..* 1 1 278C8E48-48D0-43AC-9CBF-9E432C90609F 1575295830 ChenJianDongLc 1575295837 ChenJianDongLc B00D4617-08C7-40DE-8D50-B83851345B11 套餐明细与套餐关联 FK_SAAS_ORDER_DETAIL_ORDER_DETAIL_REL_ID_SAAS_SETMEAL_ID_ 1575295842 ChenJianDongLc 1589449844 ChenJianDongLc 0..* 1 1 FD51F2B8-F98A-4390-ABE9-AE9E00F2757B 1575295842 ChenJianDongLc 1575295852 ChenJianDongLc CD108170-2955-4677-9BA1-6B8250099EB9 PUBLIC PUBLIC 1575252711 ChenJianDong 1575252711 ChenJianDong 708A80FC-B6BA-441E-A5AF-40500AF3A9F5 MySQL 5.0 MYSQL50 1575252711 ChenJianDong 1575252711 ChenJianDong file:///%_DBMS%/mysql50.xdb F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 1276524678