087D54E7-73E3-4C43-BA08-9A03EA8B3E08 一体化平台综合调度一体化平台综合调度 1604541490 Administrator 1606355717 zZ [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.sql GenScriptName0=crebas.sql GenScriptName1= GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName=C:\Users\Administrator.SKY-20171018EJQ\Desktop\ GenSingleFile=Yes GenODBC=No GenCheckModel=No 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= 58034CD1-DE7D-41DD-8FE4-9D7114352B6E MySQL 5.0 MYSQL50 1604541490 Administrator 1604541490 Administrator F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 039C25AF-07A8-4D7B-9995-10F552501194 数据库模型 PhysicalDiagram_1 1604541490 Administrator 1606354993 zZ [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 (4098, 6000) ((315,354), (433,354)) 1 1 1604548143 1604548227 ((-844201,889289), (-837357,890539)) ((-837757,889914),(-843801,889914)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604548258 1604644927 ((-844201,880982), (-816977,882232)) ((-817377,881607),(-843801,881607)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604548258 1604549085 ((-874231,881030), (-851496,882280)) ((-873831,881655),(-851896,881655)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604622351 1604624337 ((-865853,846743), (-859160,847993)) ((-859560,847368),(-865453,847368)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604622351 1604624349 ((-843770,843093), (-837219,844343)) ((-837619,843718),(-843370,843718)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604622675 1604644927 ((-873948,861039), (-808657,868091)) ((-873548,861439),(-873548,865736),(-809282,865736),(-809282,867691)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604644957 1604645025 ((-809907,864820), (-784612,882654)) ((-785012,882254),(-785012,865220),(-809282,865220),(-809282,881762)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604645025 1604645160 ((-852090,861794), (-783412,868583)) ((-783812,868183),(-783812,864020),(-851465,864020),(-851465,862194)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604645349 1604645428 ((-784287,847804), (-782249,882804)) ((-782649,848204),(-782649,865229),(-783662,865229),(-783662,882404)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604645428 1604645690 ((-809907,848278), (-807658,882162)) ((-808058,848678),(-808058,865220),(-809282,865220),(-809282,881762)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604646119 1604646176 ((-852090,832652), (-807658,835007)) ((-808058,834607),(-808058,833452),(-851465,833452),(-851465,834052)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1604542031 1604549085 -1 ((-881926,867633), (-865736,895775)) 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 1604543577 1604549085 -1 ((-859991,867536), (-843801,895678)) 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 1604546871 1604548227 -1 ((-837757,884149), (-821567,895679)) 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 1604547674 1604645690 -1 ((-817377,867691), (-801187,895833)) 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 1604554112 1604624320 -1 ((-880322,799521), (-864132,827663)) 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 1604555820 1604624324 -1 ((-858700,799724), (-842510,827866)) 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 1604561446 1604624334 -1 ((-881643,833297), (-865453,861439)) 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 1604567835 1604646176 -1 ((-859560,834052), (-843370,862194)) 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 1604622016 1604624349 -1 ((-837619,834411), (-821429,862553)) 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 1604624428 1604646176 -1 ((-816153,834607), (-799963,862749)) 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 1604634683 1604645428 -1 ((-791907,868183), (-775717,896325)) 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 1604643467 1604645428 -1 ((-790744,834133), (-774554,862275)) 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 1606354992 1606354992 -1 ((-833174,815402), (-828375,819401)) 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 1606354993 1606355002 -1 ((-837749,804657), (-822226,826077)) 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 4DE21270-4B7F-4EC5-B496-9046EEB317F3 场景类型 SMS_SCENE_TYPE 1603012269 Administrator 1604549085 Administrator 3CB2E33A-C8D5-4622-8B5C-54EED496B585 主键 ID 1603013963 Administrator 1604549085 Administrator int 1 17E7938D-3DBC-4DC5-A5EA-6CDE6EDC6A37 租户标识 TENANT_ID 1603013963 Administrator 1604543438 Administrator varchar(100) 100 219FE748-CF72-4E86-BAAA-5EBEFB293267 上级场景类型 PARENT_SCENETYPE_ID 1603013963 Administrator 1604543725 Administrator int 74548BAB-ADA5-431F-82F7-A25FED73A3CF 场景类型名称 SCENE_TYPE_NAME 1603013963 Administrator 1604543725 Administrator varchar(20) 20 D0AAA6B1-3A2A-46E3-BF09-7A06F63830EA 备注 REMARK 1603013963 Administrator 1604542031 Administrator varchar(255) 255 FED0D511-D605-4587-A1DE-CC06CB8B29D6 数据删除标记 STATUS 1603013963 Administrator 1604542031 Administrator smallint 4C0A4CA3-9865-4987-AB89-93978F1710CC 创建时间 DATE_CREATE 1603013963 Administrator 1604542031 Administrator timestamp A4000831-2038-47B6-BD91-174D55BABBD0 创建人 CREATE_BY 1603013963 Administrator 1604543438 Administrator varchar(100) 100 99A4E1C4-78D4-4538-B4F5-F0A20FB3896A 更新时间 DATE_UPDATE 1603013963 Administrator 1604542031 Administrator timestamp 0E7F4EC6-B069-46CA-924D-45FD8789E5B4 更新人 UPDATE_BY 1603013963 Administrator 1604543228 Administrator varchar(100) 100 F2A38CC1-1FAA-40B2-BB33-26CEA85EBCFF Key_1 Key_1 1603014309 Administrator 1604542031 Administrator 768BF329-AF3F-4D78-BC8D-9DCDC1917EBF 场景信息 SMS_SCENE 1603012269 Administrator 1604549928 Administrator 55C4CA92-9DD6-44BE-B1E2-653708982794 主键 ID 1603013963 Administrator 1604549085 Administrator int 1 51155D2A-D333-464B-B33A-3B54A89E13F9 租户标识 TENANT_ID 1603013963 Administrator 1604543577 Administrator varchar(100) 100 A286370B-9E73-4CC4-ACCF-3F65E20DA27B 上级场景 PARENT_SCENE_ID 1603013963 Administrator 1604544224 Administrator int 4F25907E-4CBE-4C0C-9C58-B62936A5FEEC 场景名称 SCENE_NAME 1603013963 Administrator 1604544224 Administrator varchar(20) 20 9E086933-37D0-4E21-8F85-E1413D1E6BCF 所属公司 COMPANY_ORG_ID 1604543726 Administrator 1604544693 Administrator int 02DA2A87-2459-4455-A476-CECD3B415E8B 所属部门 DEPT_ORG_ID 1604544249 Administrator 1604544693 Administrator int E1056ADF-DBA8-4984-B017-D94A08CC4ABE 场景类型 SCENE_TYPE_ID 1604544249 Administrator 1604544693 Administrator int 3AB6D4F0-530F-488E-949F-4FDCC2D803C2 状态 ENABLE_STATE 1604544249 Administrator 1604544693 Administrator int 5E8A8E2F-719D-4C6B-A6E4-965F94039F79 投运时间 RUN_TIME 1604547235 Administrator 1604547389 Administrator timestamp BC3E66E5-87C2-415C-8CE7-7E048DC13BA6 地址 ADDRESS 1604544882 Administrator 1604546862 Administrator varchar(255) 255 E20FC599-51C3-4ED3-9AA1-B557E424CF18 经度 POINT_X 1604549452 Administrator 1604549928 Administrator decimal(16,10) 16 10 AEC26042-8C12-4BC4-B374-3B95912B3A88 纬度 POINT_Y 1604549452 Administrator 1604549928 Administrator decima(16,10) 16 10 1EB58B31-F2B4-4C2B-9C78-BBC259A6CD0B 介绍 REMARK 1603013963 Administrator 1604546862 Administrator varchar(255) 255 9F9FFE57-8D42-4972-B7DC-B266A3599F6F 数据删除标记 STATUS 1603013963 Administrator 1604543577 Administrator smallint D0409204-E710-4018-8A25-C81932833B97 创建时间 DATE_CREATE 1603013963 Administrator 1604543577 Administrator timestamp 3B7B114F-D41C-42E2-8F04-33ADF316F6A9 创建人 CREATE_BY 1603013963 Administrator 1604543577 Administrator varchar(100) 100 E7BBAD79-58FC-418B-8D3F-A8645570B322 更新时间 DATE_UPDATE 1603013963 Administrator 1604543577 Administrator timestamp 515E9339-46D7-4195-B418-3645B3FA7F42 更新人 UPDATE_BY 1603013963 Administrator 1604543577 Administrator varchar(100) 100 63F644AF-3A02-49E3-928A-A5F9CB49ADED Key_1 Key_1 1603014309 Administrator 1604549085 Administrator CBE56AB0-E13C-4359-AF54-6B139E064077 场景图片信息 SMS_SCENE_IMAGE 1603012269 Administrator 1604548227 Administrator BDE3F868-BFE9-47CE-8F9A-B4A03F10A2DD 主键 ID 1603013963 Administrator 1604548227 Administrator int 1 8D9C0D4D-CC1A-46D7-8496-B4BC0F230483 图片类型 IMAGE_TYPE 1603013963 Administrator 1604547163 Administrator int 26E7553C-633D-4C6C-883A-A909BBC85FA5 图片路径 IMAGE_PATH 1604543726 Administrator 1604547163 Administrator varchar(255) 255 7B47ABBA-5C11-401F-805E-CFD2AB3C30F9 所属场景 SCENE_ID 1604544249 Administrator 1604547163 Administrator int 8A5211D8-EF37-4682-A452-1A8B765C17AD 数据删除标记 STATUS 1603013963 Administrator 1604546871 Administrator smallint 7E1271C7-EBFB-4C8D-A7E3-D60F4CEFE12C 创建时间 DATE_CREATE 1603013963 Administrator 1604546871 Administrator timestamp A64BF588-B9FF-4970-8017-166ADDDC1E74 创建人 CREATE_BY 1603013963 Administrator 1604546871 Administrator varchar(100) 100 441ECAF0-BA84-418C-88E6-008FA7D07E4A 更新时间 DATE_UPDATE 1603013963 Administrator 1604546871 Administrator timestamp 6AB922AC-6233-4B07-9A16-3DF3E41C031E 更新人 UPDATE_BY 1603013963 Administrator 1604546871 Administrator varchar(100) 100 983101D9-D9F3-4987-A07C-48105C47398F Key_1 Key_1 1603014309 Administrator 1604546871 Administrator ED09362A-9D40-46BF-86C5-E39D6FD4D31B 设备信息 SMS_DEVICE 1603012269 Administrator 1605162782 user 2943ECE9-1A58-4835-96D6-D4D3F332BD27 主键 ID 1603013963 Administrator 1604645690 admin int 1 8780B656-7058-4527-AE60-1ECBE190820D 租户标识 TENANT_ID 1603013963 Administrator 1604547674 Administrator varchar(100) 100 A733D03F-A220-4B20-8E0A-189099EA8D00 设备编号 DEVICE_CODE 1603013963 Administrator 1604547996 Administrator int 552AF928-A0DF-47D3-BA64-FD95A0EA66E8 设备名称 DEVICE_NAME 1603013963 Administrator 1604547996 Administrator varchar(20) 20 9292A902-370C-4DBA-A05C-D0F405931800 设备型号 DEVICE_TYPE_ID 1604547693 Administrator 1604624624 Administrator int 6642E605-92A4-4A3E-8721-267394E7165B 所属公司 COMPANY_ORG_ID 1604543726 Administrator 1604547996 Administrator int 05F1E952-F0AA-4662-B3B7-DDDAA899B7FC 所属部门 DEPT_ORG_ID 1604544249 Administrator 1604547674 Administrator int A440FD21-0FB8-4235-9DB3-9CFB25DDAE86 所属场景 SCENE_ID 1604544249 Administrator 1604547996 Administrator int 37794080-161F-4DDB-A850-E9A4FEE497F4 经度 POINT_X 1604549452 Administrator 1604549954 Administrator decimal(16,10) 16 10 FBEABD3A-6C69-44BA-8B6A-27F5D85AC503 纬度 POINT_Y 1604549452 Administrator 1604549954 Administrator decima(16,10) 16 10 F22A946E-DACE-45E8-AA1D-4CED3D60F4A2 设备状态 ENABLE_STATE 1604544249 Administrator 1604547996 Administrator int 7E1AC782-AAF4-472D-9D58-D1DA3A07CA22 最后上报时间 LAST_UPDATE_TIME 1605162710 user 1605162782 user timestamp DF41497E-7270-42B5-9E5B-EA831BF16BCC 地址 ADDRESS 1604544882 Administrator 1604547674 Administrator varchar(255) 255 F9B56719-5195-4F60-83A9-0BF8F19D37D3 备注 REMARK 1603013963 Administrator 1604547996 Administrator varchar(255) 255 00CACAC9-E5E7-4C23-8A26-8745B531B3DB 数据删除标记 STATUS 1603013963 Administrator 1604547674 Administrator smallint 7C9D96AE-D701-427C-85B3-BAFF5B2F3B08 创建时间 DATE_CREATE 1603013963 Administrator 1604547674 Administrator timestamp 2F6EF384-89D6-4158-B6BE-AC3DDAE849ED 创建人 CREATE_BY 1603013963 Administrator 1604547674 Administrator varchar(100) 100 EC035946-BFEF-49BF-9AF2-29C7469D7F93 更新时间 DATE_UPDATE 1603013963 Administrator 1604547674 Administrator timestamp 8CA33360-AC6E-4DB5-A61B-079B8C7540ED 更新人 UPDATE_BY 1603013963 Administrator 1604547674 Administrator varchar(100) 100 4F49C33F-5AEC-4D2B-91D6-742B81D0B256 Key_1 Key_1 1603014309 Administrator 1604645690 admin 1CAF93C8-CA20-439E-BB99-9881EF0AE85A 系统设置 SMS_SYSTEM_SETTING 1603012269 Administrator 1605163009 user BB388E6F-A6DB-4548-927E-A2C6FCC6034E 主键 ID 1603013963 Administrator 1604554112 Administrator int 1 F2022A4B-EC42-4643-85B3-B7C3A294AA73 租户标识 TENANT_ID 1603013963 Administrator 1604554112 Administrator varchar(100) 100 00D080C3-CFE0-4ABF-BBBA-FB04236DD8E0 所属公司 COMPANY_ORG_ID 1604543726 user 1605163009 user int CFBC71AF-B026-46CB-A7A7-BF9BC1CE9D5F 所属部门 DEPT_ORG_ID 1603013963 Administrator 1605163009 user int F3F82992-E369-4543-B7E6-13A2046C7241 地图数据刷新频率 MAP_DATA_REFRESH 1603013963 Administrator 1604555796 Administrator int D631CE99-6F8E-4992-BF5B-B122636C73B7 概览页数据刷新频率 FIRST_PAGE_REFRESH 1604554142 Administrator 1604555796 Administrator int DFA7BCDF-FA5B-41B8-9B2A-3FEEED905BDB 工艺图数据刷新频率 PROCESS_DRAWING_REFRESH 1603013963 Administrator 1604555796 Administrator int A0BC57FB-9936-4589-85B7-0986254291AC 地图悬浮参数是否显示 MAP_SUSPENSION_DISPLAY 1604554142 Administrator 1604555796 Administrator smallint EFBF812A-1F40-4E0B-957C-B172CB01AF86 数据删除标记 STATUS 1603013963 Administrator 1604554112 Administrator smallint 9A02AF91-EB3C-409D-80FA-C46A597E85E0 创建时间 DATE_CREATE 1603013963 Administrator 1604554112 Administrator timestamp 396B6ABE-6E35-43D6-AB40-22B28A8529B9 创建人 CREATE_BY 1603013963 Administrator 1604554112 Administrator varchar(100) 100 48DEABAB-E6A7-4A8F-B532-ECAC864B4A7F 更新时间 DATE_UPDATE 1603013963 Administrator 1604554112 Administrator timestamp 27DB33F1-8F53-4DB0-87B5-0E622DCDA221 更新人 UPDATE_BY 1603013963 Administrator 1604554112 Administrator varchar(100) 100 83FA3BA6-D2E7-4C1A-A830-4D7C1AD4373E Key_1 Key_1 1603014309 Administrator 1604554112 Administrator 17104597-7EAA-4A95-A3C7-D013C6B3ED78 GIS设置 SMS_GIS_SETTING 1603012269 Administrator 1606355718 zZ 875AE639-D8A4-4B9B-AC38-B1C8F329B6D4 主键 ID 1603013963 Administrator 1604555820 Administrator int 1 59CD0DEE-4120-4672-ACD7-B7D81D24FCF9 租户标识 TENANT_ID 1603013963 Administrator 1604555820 Administrator varchar(100) 100 98C45CB6-C280-465F-A91B-06032307DAA3 所属公司 COMPANY_ORG_ID 1604543726 user 1605162990 user int 3CFCBA2E-70A3-4976-99BE-7BFEAF2CD710 所属部门 DEPT_ORG_ID 1603013963 Administrator 1605162990 user int A75A5EEB-16F6-4A41-8609-A1D54D4FC57C 内网设置 EXTRANET_SETTING 1603013963 Administrator 1604556254 Administrator varchar(255) 255 D4154D5F-84D9-49E9-BEA3-C1C55891BC00 外网设置 INTRANET_SETTING 1604554142 Administrator 1604556254 Administrator varchar255) 55 28CA7C1C-8D4B-47E6-BF3B-981305972D13 服务类型 SERVICE_TYPE 1603013963 Administrator 1604556254 Administrator int E3637665-62B9-4CA9-8379-AFE9234C57E0 数据删除标记 STATUS 1603013963 Administrator 1604555820 Administrator smallint A928779C-122C-4999-AF87-148335CFE85D 创建人 CREATE_BY 1603013963 Administrator 1604555820 Administrator varchar(100) 100 AC8A9014-328C-4EEC-91F1-D8F15D4F4335 更新时间 DATE_UPDATE 1603013963 Administrator 1604555820 Administrator timestamp D9E8E41E-70C7-46C8-920C-6CF4B593A5FA 创建时间 DATE_CREATE 1603013963 Administrator 1604555820 Administrator timestamp 7D1ABEE5-1B00-4E0A-8FC6-56BAD6ECCD3E 更新人 UPDATE_BY 1603013963 Administrator 1604555820 Administrator varchar(100) 100 F140C8A8-38B6-4183-AB08-62AA5C036DB1 Key_1 Key_1 1603014309 Administrator 1604555820 Administrator B9923B46-40EE-4E66-9A8F-F40ED2E3C03D 设备型号 SMS_DEVICE_TYPE 1603012269 Administrator 1604622687 Administrator 2F665572-2E9A-4C5B-8FCD-4DC6EAB517D1 主键 ID 1603013963 Administrator 1604622687 Administrator int 1 3AA682E3-E1A5-4CD1-A36E-7600C323F1AF 厂商名称 MANUFACTURER_NAME 1603013963 Administrator 1604567806 Administrator varchar(50) 50 8ED5A895-2F08-4226-90F7-FF397C691375 厂商ID MANUFACTURER_ID 1604561456 Administrator 1604567806 Administrator varchar(50) 50 AA9C0449-805C-4C70-8FCC-B687624FABBE 设备类型 DEVICE_TYPE 1603013963 Administrator 1604567806 Administrator varchar(50) 50 4A306C83-9E55-4676-89AE-ACE8AB911D56 设备型号 DEVICE_MODE 1604554142 Administrator 1604567806 Administrator varchar(50) 50 6676D965-51CA-466F-A75D-2117DE3081CD 数据删除标记 STATUS 1603013963 Administrator 1604561446 Administrator smallint 3C344FC8-FD55-4340-BBFB-5C3C141BF1AD 创建时间 DATE_CREATE 1603013963 Administrator 1604561446 Administrator timestamp FA6110D0-A140-4232-A01F-33113A31E4B2 创建人 CREATE_BY 1603013963 Administrator 1604561446 Administrator varchar(100) 100 D90E9597-AD6B-4F66-BA96-23DDE08D3E3C 更新时间 DATE_UPDATE 1603013963 Administrator 1604561446 Administrator timestamp A5E91329-A970-41DB-92F3-2C320C00C92E 更新人 UPDATE_BY 1603013963 Administrator 1604561446 Administrator varchar(100) 100 FDC93BB5-2764-4163-ABD1-40BF44E356A0 Key_1 Key_1 1603014309 Administrator 1604622424 Administrator 2CF26986-B15B-497E-8CB3-25EAAD9BEA2E 设备属性 SMS_DEVICE_ATTRIBUTE 1603012269 Administrator 1604647736 admin C32B6452-FE0B-4AD1-9DF7-DE234AC9B941 主键 ID 1603013963 Administrator 1604646176 admin int 1 BC9AF585-861C-4AC0-90E7-04D17D1C42ED 属性名称 NAME 1603013963 Administrator 1604621948 Administrator varchar(50) 50 D4CDBC90-2B76-4983-A91F-FFA35AF2CD1F 属性标识符 IDENTIFIER 1604561456 Administrator 1604621948 Administrator varchar(50) 50 F26E889F-05A5-4BDA-A0B4-106F60D6CC46 属性类型 DATA_TYPE 1603013963 Administrator 1604621948 Administrator varchar(50) 50 1E865403-9632-4576-86AD-FEB1E63D5F4D 属性描述 DESCRIPTION 1604621662 Administrator 1604621948 Administrator varchar(100) 100 D2C280D7-763B-40E1-895A-2F3BDA35384C 属性单位 UNIT 1604621662 Administrator 1604621948 Administrator varchar(20) 20 65E36F0D-B21A-47FC-A7F9-E1DAC8AEC730 设备型号 DEVICE_MODE_ID 1604554142 Administrator 1604621948 Administrator int 8FD7C245-4E34-4D1E-9A5B-F6ECB184A076 数据删除标记 STATUS 1603013963 Administrator 1604567835 Administrator smallint 99443443-E1C8-41B0-A09A-1E2023A48A11 创建时间 DATE_CREATE 1603013963 Administrator 1604567835 Administrator timestamp DD688C1E-8851-4A92-B898-943E160F06C0 创建人 CREATE_BY 1603013963 Administrator 1604567835 Administrator varchar(100) 100 0184B516-73D9-4DAF-A1ED-A1E57DA59344 更新时间 DATE_UPDATE 1603013963 Administrator 1604567835 Administrator timestamp 2EE94A8E-C3BD-4660-9A38-9DBB06CD901E 更新人 UPDATE_BY 1603013963 Administrator 1604567835 Administrator varchar(100) 100 C2EC299B-241D-4898-AD90-8CD7910F9A14 Key_1 Key_1 1603014309 Administrator 1604646176 admin 7E5DF2F0-DD0B-463C-A033-EA129880321C 设备属性规则 SMS_DEVICE_ATTRIBUTE_SPECS 1603012269 Administrator 1604622424 Administrator F8588819-D576-4ED9-9B0A-165FD220E133 主键 ID 1603013963 Administrator 1604622424 Administrator int 1 7FBEAF43-93D2-405D-B7AE-033C8F02D25C 规格名称 SPECS_NAME 1604561456 Administrator 1604622258 Administrator varchar(50) 50 D4FACB5F-235C-425C-95FA-64E857719C0A 规格值 SPECS_VALUE 1603013963 Administrator 1604622258 Administrator varchar(50) 50 6F1A5E7A-CE21-44EF-A009-71B0863AF1A5 设备属性 ATTRIBUTE_ID 1604622073 Administrator 1604622258 Administrator int 60CBA208-A36F-4EB3-A6BF-84433DA185FA 数据删除标记 STATUS 1603013963 Administrator 1604622016 Administrator smallint 1C92BC89-9FE8-4980-85A0-B11EF7C25F6F 创建时间 DATE_CREATE 1603013963 Administrator 1604622016 Administrator timestamp 70B8F808-93F2-4E0E-BCBB-8DC93075195D 创建人 CREATE_BY 1603013963 Administrator 1604622016 Administrator varchar(100) 100 2AE2279F-3FCB-4D2D-9D1A-B3FF3AD855F1 更新时间 DATE_UPDATE 1603013963 Administrator 1604622016 Administrator timestamp 2A417EEF-34CA-4BAB-833E-B7F92ECEA4E0 更新人 UPDATE_BY 1603013963 Administrator 1604622016 Administrator varchar(100) 100 B82D0128-106C-4D7F-9319-FB21C8FDE5A1 Key_1 Key_1 1603014309 Administrator 1604622016 Administrator EFDF2E9E-6267-4E5D-ACFE-8FA692E150CC 设备参数设置 SMS_DEVICE_PARM 1603012269 Administrator 1604999989 user 6A745F68-137D-4E75-B81F-01253348D359 主键 ID 1603013963 Administrator 1604647869 admin int 1 7FCC0E4F-6573-4FEB-BF81-6C7D00D50061 租户标识 TENANT_ID 1603013963 Administrator 1604624428 Administrator varchar(100) 100 716B2C89-DC60-43A8-9F74-CBF91C2FFC24 设备信息 DEVICE_ID 1603013963 Administrator 1604648518 Administrator int 092DD138-2E45-455B-9906-0773C701D2D6 设备属性 ATTRIBUTE_ID 1603013963 Administrator 1604647596 admin int 566D66C0-286D-438E-828D-BC77B0E71ED3 是否地图悬浮显示 IS_SUSPENSION 1604547693 Administrator 1604647962 admin smallint 1A48BF89-1856-4F6E-B107-154D4B4B04DE 是否统计报表参数 IS_REPORT 1604544249 admin 1604647962 admin smallint 01A23F51-5D91-4A3A-AAD8-4074B0893844 是否统计图表参数 IS_CHART 1604544249 Administrator 1604647962 admin smallint ECA8F179-C6C5-41D2-BDAC-FEAA542E5565 是否地图参数 IS_MAP 1604544249 Administrator 1604647962 admin smallint DF251DD5-8E56-47EF-91F8-8A2A58118C61 是否报警参数 IS_ALARM 1604549452 Administrator 1604647962 admin smallint 0751785D-6319-4DBB-A9B8-214002EE3A0C 是否工艺图参数 IS_ARTWORK 1604549452 Administrator 1604647962 admin smallint 3259CEB4-44C3-4351-AF59-54D8CCD56C58 备注 REMARK 1603013963 Administrator 1604624428 Administrator varchar(255) 255 BFA400E2-DDD1-4202-ACB8-61307243B563 数据删除标记 STATUS 1603013963 Administrator 1604624428 Administrator smallint 4817F674-3BE2-4A12-AAE8-517D62B4996C 创建时间 DATE_CREATE 1603013963 Administrator 1604624428 Administrator timestamp 87388C3C-2264-44C1-B674-EE99905986A3 创建人 CREATE_BY 1603013963 Administrator 1604624428 Administrator varchar(100) 100 AA5A488B-76D4-4127-A352-2CC014BFE1C3 更新时间 DATE_UPDATE 1603013963 Administrator 1604624428 Administrator timestamp B5AFB3CD-B94D-4444-8ADA-45FA323AD3EC 更新人 UPDATE_BY 1603013963 Administrator 1604624428 Administrator varchar(100) 100 E3D50B2B-1A5A-4928-8FFE-4B5DE5BA720E Key_1 Key_1 1603014309 Administrator 1604624428 Administrator BBA24694-005D-4F31-B48F-5D476A1D1D54 报警参数设置 SMS_ALARM_SETTING 1603012269 admin 1604999969 user 42C53C5B-D7E6-4316-9381-1F90E5D9EBA6 主键 ID 1603013963 admin 1604645428 admin int 1 139598C9-581C-4711-97AD-0262971BD743 租户标识 TENANT_ID 1603013963 admin 1604634683 admin varchar(100) 100 2901293E-09C0-449E-98E8-D644D499DFD4 设备信息 DEVICE_ID 1603013963 admin 1604648623 Administrator int 80926AE1-C725-4EE8-8049-6E1DE27801FD 设备属性 ATTRIBUTE_ID 1603013963 admin 1604647736 admin int D9E40555-A941-46E7-B492-0EB8EDAA85DD 报警类型 ALARM_TYPE 1604547693 admin 1604643262 admin varchar(255) 255 692E701E-1027-45BB-8693-382E106A37D1 报警条件 ALARM_CONDITION 1604544249 admin 1604643262 admin varchar(10) 10 BFCBB878-E8E4-482C-AE54-E9B959FD7D59 报警值 ALARM_VALUE 1604544249 admin 1604643262 admin decimal(16,3) 16 3 2BB8EFD5-C89F-4F9D-808E-67C9A23CA94B 备注 REMARK 1603013963 admin 1604634683 admin varchar(255) 255 C31ACB0B-28D5-4C1D-A471-DCA16A5F8FC1 数据删除标记 STATUS 1603013963 admin 1604634683 admin smallint 87291171-BDE4-4CB7-9CD6-1C9CE04FAC9F 创建时间 DATE_CREATE 1603013963 admin 1604634683 admin timestamp AFAA04C1-157D-47D7-8BE4-6A58C068A3CF 创建人 CREATE_BY 1603013963 admin 1604634683 admin varchar(100) 100 DAE95DF2-CE7F-4A05-90C5-4B2293DCD1B9 更新时间 DATE_UPDATE 1603013963 admin 1604634683 admin timestamp DEF15E7E-3819-4111-9D85-49825D4D6A81 更新人 UPDATE_BY 1603013963 admin 1604634683 admin varchar(100) 100 FD2713F8-D58A-4B7A-AACB-49B9C64F5B39 Key_1 Key_1 1603014309 admin 1604645428 admin 95F4BD92-CC81-4405-96B4-02AA99080A72 报警详情信息 SMS_ALARM_DETAILS 1603012269 admin 1605162117 user B675CE27-DFFB-4A91-ADF3-52CFEFF186FD 主键 ID 1603013963 admin 1604647663 admin int 1 731E5AEB-E803-4AA0-92DB-60A0A163C571 租户标识 TENANT_ID 1603013963 admin 1604643467 admin varchar(100) 100 9C775299-DFF5-49DD-AEFE-D8F9517429E3 设备信息 DEVICE_ID 1604648745 Administrator 1604649073 Administrator int 6E7EF12B-E5C1-4567-BC29-1BD08D473949 所属公司 COMPANY_ORG_ID 1604543726 user 1605162117 user int 936C44E8-F7D0-4E65-8607-476909BD3AED 所属部门 DEPT_ORG_ID 1604544249 user 1605162117 user int 5C2A7F3C-168E-4EFC-8F49-1121C513CDD9 报警类型 ALARM_TYPE 1604649166 Administrator 1604649444 Administrator int 84892027-EA26-4F61-A308-2D4F450CA145 报警参数ID ATTRIBUTE_ID 1604648745 Administrator 1605162228 user int B171C0EA-739F-4298-B3F1-8447F177C047 当前数值 ALARM_VALUE 1604544249 admin 1604649073 Administrator decimal(16,3) 16 3 DE8E1ECF-D62F-4D24-84C6-9652C99B8711 报警详情 ALARM_CONTENT 1604544249 admin 1604649073 Administrator varchar(255) 255 7B259888-A3B9-472C-B8B0-65BD52BC0BCB 报警开始时间 ALARM_START_TIME 1604544249 admin 1604649073 Administrator timestamp D3742B0A-A46B-494E-BD8B-0FD8C68609DB 报警结束时间 ALARM_END_TIME2 1604544249 admin 1604649073 Administrator timestamp 5680D84C-9F2D-4E0E-A64B-C3545EAD22E2 报警状态 STATE 1604648745 Administrator 1604649073 Administrator int BF44AECF-14CB-43C7-8C00-E1FF3B0FCAC0 处理状态 OP_STATE 1604649166 Administrator 1604649444 Administrator int 979161F3-3562-481D-99BF-DDAA0170E230 备注 REMARK 1603013963 admin 1604643467 admin varchar(255) 255 AAA3BDD0-6E37-4B44-BA7C-02D9EB0E3701 数据删除标记 STATUS 1603013963 admin 1604643467 admin smallint 24632DBB-9F26-4D55-9110-078E1435178A 创建时间 DATE_CREATE 1603013963 admin 1604643467 admin timestamp 8A53BA2E-D668-45CD-9129-1209987D610D 创建人 CREATE_BY 1603013963 admin 1604643467 admin varchar(100) 100 F86E1A06-4DED-4587-89D2-A7CF0F202F03 更新时间 DATE_UPDATE 1603013963 admin 1604643467 admin timestamp 68EDA5B0-966C-4892-8AAE-F8809FD220BB 更新人 UPDATE_BY 1603013963 admin 1604643467 admin varchar(100) 100 88B57B3C-D078-4D91-B863-477238DB39C4 Key_1 Key_1 1603014309 admin 1604643467 admin 65E51B00-4B05-41BD-9DC3-5EFC1CBCA7CE Table_13 Table_13 1606354992 zZ 1606354992 zZ 3E467357-F317-4B44-BD5D-BAB331FD3CAB 摄像头管理 SMS_CAMERA_MANAGE 1606354993 zZ 1606355717 zZ A96D9791-10A3-4481-B85D-EFA4A56C438C ID ID 1606355003 zZ 1606355598 zZ INT 72170458-8FA2-4FF6-81DC-13486940807B 租户标识 TENANT_ID 1606355003 zZ 1606355598 zZ varchar(100) 100 0713FFA5-8678-463E-99CD-5B744F470013 所属公司 COMPANY_ORG_ID 1606355003 zZ 1606355598 zZ INT 4EFD0184-DEA5-400A-A55F-E2E36AB5132D 所属部门 DEPT_ORG_ID 1606355003 zZ 1606355598 zZ INT AD91AFFA-ABFE-4A18-9827-3D5069E7FDB4 所属场景 SCENE_ID 1606355003 zZ 1606355598 zZ INT 824C8407-CF26-420C-A4F3-0D5D4AABF911 地址名 address 1606355003 zZ 1606355598 zZ varchar(100) 100 00E77A5D-2F54-4177-911C-36661C0D1928 经纬度 geo 1606355003 zZ 1606355598 zZ varchar(100) 100 11CB7E52-6ADB-4BDA-A604-8F37950FF8D9 预览地址 PALY_URL 1606355003 zZ 1606355598 zZ varchar(100) 100 2B24FF21-98FC-4B87-8C80-AECA39C8AB5C 回放地址 REPLAY_URL 1606355003 zZ 1606355598 zZ varchar(100) 100 C44AF355-CA32-4EA6-8259-DCF44021FE05 APPKEY APPKEY 1606355003 zZ 1606355598 zZ varchar(100) 100 BC2CB15E-D167-42F0-B76D-26E139C0E555 创建人 CREATE_BY 1603013963 zZ 1606355717 zZ varchar(100) 100 AEE85014-167C-45A4-9826-E91EBCB59E67 更新时间 DATE_UPDATE 1603013963 zZ 1606355717 zZ timestamp E15E854A-A1DD-4B82-AB8B-B7FD9F36F01D 创建时间 DATE_CREATE 1603013963 zZ 1606355717 zZ timestamp F377EDD3-5789-46E4-AF95-382EEC420C89 更新人 UPDATE_BY 1603013963 zZ 1606355717 zZ varchar(100) 100 2CC4EBFB-818F-4F55-9A59-F23DA76B5B49 SCRERT SCRERT 1606355003 zZ 1606355598 zZ varchar(100) 100 0C9C022A-0802-4439-9940-6CA73038D4D7 Reference_1 Reference_1 1604548143 Administrator 1604548227 Administrator 1..* 1 1 217DD79D-98CA-48E7-ACFA-AB90E13E7DB6 1604548143 Administrator 1604548227 Administrator 00FD434B-C870-4AF8-86DC-293D4DE86BF7 Reference_2 Reference_2 1604548258 Administrator 1604549085 Administrator 1..* 1 1 428C3123-B32C-472E-94C2-EBFC075962EC 1604548258 Administrator 1604549085 Administrator 8B63BB98-5266-43FF-AB0C-CADFFBF6123A Reference_3 Reference_3 1604548258 Administrator 1604549085 Administrator 1..1 1 1 53ABAB19-26F4-494D-A781-CE3C001A850E 1604548258 Administrator 1604549085 Administrator 533971A7-58DD-4218-9106-7385494DC155 Reference_4 Reference_4 1604622351 Administrator 1604622424 Administrator 1..* 1 1 902FDF07-B095-431A-A0C2-D05F3DE5C8C3 1604622351 Administrator 1604622424 Administrator 9929BDCA-FD50-4E3E-A38E-6D01659AEBEA Reference_5 Reference_5 1604622351 Administrator 1604622424 Administrator 1..* 1 1 4DFE2272-5EE6-4FBF-95DA-1A543C35CA97 1604622351 Administrator 1604622424 Administrator 9D438983-7FB3-47E4-85E6-F892191C2164 Reference_6 Reference_6 1604622675 Administrator 1604622687 Administrator 1..1 1 1 438A66B9-EA55-4F40-AF26-B9096EAE7596 1604622675 Administrator 1604622687 Administrator F17F7340-86B3-4A1A-96BD-CE25FFFD533A Reference_7 Reference_7 1604644957 admin 1604647778 admin 1..* 1 1 3B1BB605-E0F9-45AA-B389-1DF72605667E 1604644957 admin 1604647778 admin 4118B982-67B4-400B-B6DB-6EB411912D2C Reference_8 Reference_8 1604645025 admin 1604647736 admin 1..* 1 1 89F783A5-C9E7-4122-984A-03DC5377E1AF 1604645025 admin 1604647736 admin ABC226B2-7A85-4947-9CF3-574AD5029F4F Reference_9 Reference_9 1604645349 admin 1604647663 admin 1..* 1 1 3E8CEB33-0E1E-4D7C-B51A-EE055B7E77F9 1604645349 admin 1604649444 Administrator FE9EC8C3-3AC7-4672-A273-7FA5C3E5FA86 Reference_10 Reference_10 1604645428 admin 1604647869 admin 1..* 1 1 B84D7FDF-9C09-4E44-9400-A7676039A4E0 1604645428 admin 1604647869 admin 423325CC-4EB5-4562-A87F-6481AD75223A Reference_11 Reference_11 1604646119 admin 1604647596 admin 1..1 1 1 636DE083-C842-44FF-9E66-DBAC89BC46B9 1604646119 admin 1604647596 admin 592750E1-7563-4828-B936-FCEB7C28B756 PUBLIC PUBLIC 1604541490 Administrator 1604541490 Administrator 2B40AF8F-37D4-4877-B75A-2F813FF27280 MySQL 5.0 MYSQL50 1604541490 Administrator 1606354555 zZ file:///%_DBMS%/mysql50.xdb F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 1603175699