06BB2740-A389-4BA7-9D45-8E9E79000E93 商业仪表盘 PhysicalDataModel_1 1433304340 Administrator 1671433724 yskj01 [FolderOptions] [FolderOptions\Physical Objects] GenerationCheckModel=Yes GenerationPath= GenerationOptions= GenerationTasks= GenerationTargets= GenerationSelections= RevPkey=Yes RevFkey=Yes RevAkey=Yes RevCheck=Yes RevIndx=Yes RevOpts=Yes RevViewAsTabl=No RevViewOpts=Yes RevSystAsTabl=Yes RevTablPerm=No RevViewPerm=No RevProcPerm=No RevDbpkPerm=No RevSqncPerm=No RevAdtPerm=No RevUserPriv=No RevUserOpts=No RevGrpePriv=No RevRolePriv=No RevDtbsOpts=Yes RevDtbsPerm=No RevViewIndx=Yes RevJidxOpts=Yes RevStats=No RevTspcPerm=No RevCaseSensitive=No GenTrgrStdMsg=Yes GenTrgrMsgTab= GenTrgrMsgNo= GenTrgrMsgTxt= TrgrPreserve=No TrgrIns=Yes TrgrUpd=Yes TrgrDel=Yes TrgrC2Ins=Yes TrgrC2Upd=Yes TrgrC3=Yes TrgrC4=Yes TrgrC5=Yes TrgrC6=Yes TrgrC7=Yes TrgrC8=Yes TrgrC9=Yes TrgrC10=Yes TrgrC11=Yes TrgrC1=Yes TrgrC12Ins=Yes TrgrC12Upd=Yes TrgrC13=Yes UpdateTableStatistics=Yes UpdateColumnStatistics=Yes [FolderOptions\Physical Objects\Database Generation] GenScriptName=crebas GenScriptName0= GenScriptName1= GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName= 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 Grant=Yes [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=Yes 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\Database Generation\View <<MaterializedView>>] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\View <<MaterializedView>>\ViewColumn] Comment=Yes [FolderOptions\Physical Objects\Database Generation\View <<MaterializedView>>\ViewIndex] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View <<MaterializedView>>\ViewIndex\Filter] Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\View <<MaterializedView>>\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View <<MaterializedView>>\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [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=No 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=30 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=30 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=30 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\Physical Objects\ClssNamingOptions\CUBE] [ModelOptions\Physical Objects\ClssNamingOptions\CUBE\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [ModelOptions\Physical Objects\ClssNamingOptions\CUBE\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= {92EAD7D1-CC48-4A70-BCD1-8AB4B082FD0A},ORACLE10g,147={6B42D21D-1B09-4011-9A58-AD06794DFCE8},AutoFixMaterializedViewDone,4=true {1EE52FE6-7E9F-4F28-98C8-1AF75F186F54},AutoFixTempAttributeDone,4=true 5F55F687-E9ED-4598-8F0A-8D60C871B419 ORACLE Version 10g ORACLE10g 1433304340 Administrator 1433304340 Administrator 92EAD7D1-CC48-4A70-BCD1-8AB4B082FD0A 4BA9F647-DAB1-11D1-9944-006097355D9B 41658ECF-763C-4DD5-ADEC-50535861CBD6 管理平台 PhysicalDiagram_1 1433304340 Administrator 1671433724 yskj01 [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=No Activate automatic link routing=No 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=""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> File Location=No PckgShowStrn=Yes ColnMode=0 ColnMax=5 TablOwnr=No ColnDttp=Yes ColnDomn=No ColnShowDomn=No ColnKey=Yes ColnIndx=No ColnMand=No ColnStrn=Yes ViewOwnr=No VColName=Yes VColExpr=No VColDttp=No VColIndx=No VColCMod=0 VColCMax=5 ProcOwnr=No KeyStrn=Yes IndxStrn=Yes TrgrStrn=Yes [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=Yes Keep center=Yes Keep size=No Width=2400 Height=2400 Brush color=255 255 255 Fill Color=No 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=3600 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 1671418419 1671418419 ((13894,14152), (20194,14602)) ((20194,14377),(13894,14377)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1671433424 1671433424 ((-22822,-20602), (-18122,-20152)) ((-18122,-20377),(-22822,-20377)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1671433699 1671433699 ((-29153,-3649), (-6439,4866)) ((-29153,4866),(-29153,-3349),(-6439,-3349)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 4 1671433706 1671433706 ((-14513,-1753), (-6474,4550)) ((-14513,4550),(-14513,-1453),(-6474,-1453)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 4 1671433710 1671433710 ((2373,-2455), (7218,4189)) ((7218,4189),(7218,-2155),(2373,-2155)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 4 1671433713 1671433713 ((2935,-3930), (24772,9290)) ((24772,9290),(24772,-3630),(2935,-3630)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 4 1671433718 1671433718 ((-29012,-9212), (-8194,-5436)) ((-29012,-9212),(-29012,-5736),(-8194,-5736)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 4 1671433721 1671433721 ((-12301,-13530), (-7773,-7683)) ((-12301,-13530),(-12301,-7983),(-7773,-7983)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 4 1671433724 1671433724 ((3111,-15355), (8622,-7472)) ((8622,-15355),(8622,-7772),(3111,-7772)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 4 1671100072 1671100072 -1 ((-35993,3084), (-22809,25282)) 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 1671100073 1671413536 -1 ((-19492,3118), (-6310,25316)) 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 1671100075 1671433691 -1 ((-8896,-9114), (4286,-416)) 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 1671100077 1671417578 -1 ((120,2667), (14950,25765)) 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 1671100078 1671418419 -1 ((18901,7834), (31259,20132)) 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 1671100079 1671433411 -1 ((-35726,-31347), (-22544,-7349)) 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 1671100080 1671433424 -1 ((-19005,-25782), (-4999,-12584)) 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 1671100081 1671433686 -1 ((2586,-25065), (14944,-14567)) 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 D7094FA4-324D-422D-BD07-5A69262A98B9 商业仪表盘 PlatForm_Dashboard 1656663860 yskj01 1671446337 yskj01 商业仪表盘 C48ED161-7108-4D69-A619-9EC019243EBE 服务区营收日度报表 T_RevenueDaily 1671100072 yskj01 1671418393 yskj01 服务区营收日度报表 AA358FA0-2DAA-42A4-B4D9-F354DAA4B96F 表内码 RevenueDaily_ID 1671100124 yskj01 1671443841 yskj01 表内码 NUMBER(9) 9 1 FF4A53CB-5E59-43C1-A26B-7EECDA45B1C6 统计日期 Statistics_Date 1671100124 yskj01 1671443841 yskj01 统计日期 NUMBER(8) 8 EA3A0113-C5D2-4288-9178-3001B7AD2FF9 省份内码 Province_ID 1671100124 yskj01 1671443841 yskj01 省份内码 NUMBER(9) 9 EC475525-5F95-4D96-BC92-5F5726CBB4D8 服务区内码 Serverpart_ID 1671100124 yskj01 1671443841 yskj01 服务区内码 NUMBER(9) 9 D23A74F7-8CC8-4D59-819F-A105F8B7F937 经营模式 Business_Type 1671100124 yskj01 1671443841 yskj01 经营模式 NUMBER(8) 8 3E95430B-0047-4CC9-89E3-C66F7EB616E2 经营业态 Business_Trade 1671100124 yskj01 1671443841 yskj01 经营业态 VARCHAR2(50) 50 BF1DA747-12AF-475C-AF18-A3659A474E0A 经营品牌 Business_Brand 1671100124 yskj01 1671443841 yskj01 经营品牌 VARCHAR2(50) 50 B3210736-F5F6-4CA9-87A4-B962B91F6CD5 商品业态 ShopTrade 1671100124 yskj01 1671443841 yskj01 商品业态 NUMBER(8) 8 252F1EEB-C1D1-4410-9A81-074D0875CDC5 销售数量 Total_Count 1671100124 yskj01 1671443841 yskj01 销售数量 NUMBER(16,2) 16 2 50914554-E12D-4696-9CC3-71BC686B65EA 客单数量 Ticket_Count 1671100124 yskj01 1671443841 yskj01 客单数量 NUMBER(9) 9 F2E21F90-BC29-4AC6-88F1-0784D6A06C05 优惠金额 TotalOff_Amount 1671100124 yskj01 1671443841 yskj01 优惠金额 NUMBER(16,2) 16 2 5F447248-A4F5-478B-AD20-307C02943159 营收金额 Revenue_Amount 1671100124 yskj01 1671443841 yskj01 营收金额 NUMBER(16,2) 16 2 D2FA6BE7-BB3C-4422-AD7D-2F8A9B6BEAAD 移动支付 MobilePay_Amount 1671100124 yskj01 1671443841 yskj01 移动支付 NUMBER(16,2) 16 2 C3446462-397C-425E-A32F-8F2CEB2167A5 现金支付 CashPay_Amount 1671100124 yskj01 1671443841 yskj01 现金支付 NUMBER(16,2) 16 2 8DCC436D-392C-48B2-A02B-AA1ABF45C905 其他支付 OtherPay_Amount 1671100124 yskj01 1671443841 yskj01 其他支付 NUMBER(16,2) 16 2 D24023DB-AC7D-423C-BCDA-E16559B9B74B 长短款 Different_Amount 1671100124 yskj01 1671443841 yskj01 长短款 NUMBER(16,2) 16 2 4C5AFFA4-F9C6-4F38-A6C0-22021618A06E 稽核次数 Audit_Count 1671100124 yskj01 1671443841 yskj01 稽核次数 NUMBER(9) 9 CF2FC070-C976-42B8-B37D-4A24C29E9FCC 门店数量 Shop_Count 1671100124 yskj01 1671443841 yskj01 门店数量 NUMBER(9) 9 31FF4CF6-9C1D-4C44-9C43-8D65503BCCA4 日结账单数量 Endaccount_Count 1671100124 yskj01 1671443841 yskj01 日结账单数量 NUMBER(9) 9 E2C815E7-CB5C-4D77-B077-21042B28CD74 自然日营收 RevenueDaily_Amount 1671100124 yskj01 1671443841 yskj01 自然日营收 NUMBER(16,2) 16 2 85BE4412-88A3-428C-A851-A37BFBA325A9 自然日客单 TicketDaily_Count 1671100124 yskj01 1671443841 yskj01 自然日客单 NUMBER(9) 9 0DD35CFC-0D9A-4B1D-87D0-8B8C7E892ADC 数据状态 RevenueDaily_State 1671100124 yskj01 1671443841 yskj01 数据状态 1 NUMBER(1) 1 E34A9A0C-70B6-48B3-94E1-F8D3CA7EAFFC 更新时间 Record_Date 1671100124 yskj01 1671443841 yskj01 更新时间 SYSDATE DATE 1B1CC722-6F64-4F72-B9F0-451F3D811FE9 Key_1 Key_1 1671100124 yskj01 1671100503 yskj01 5EF08EE7-90A0-49D3-A688-3B07D3EC1D18 服务区营收月度报表 T_RevenueMonthly 1671100073 yskj01 1671418387 yskj01 服务区营收月度报表 748E15C1-7F7C-4116-B687-2826D33AE2DD 表内码 RevenueMonthly_ID 1671100124 yskj01 1671443841 yskj01 表内码 NUMBER(9) 9 1 C75AEC08-0DD2-4C5C-978D-591FCCA6E8A6 统计日期 Statistics_Month 1671100124 yskj01 1671443841 yskj01 统计日期 NUMBER(6) 6 14AC550F-1276-4289-810D-ED6EAE00662B 省份内码 Province_ID 1671100124 yskj01 1671443841 yskj01 省份内码 NUMBER(9) 9 E6B50917-E85A-442F-89FE-C7C39837C727 服务区内码 Serverpart_ID 1671100124 yskj01 1671443841 yskj01 服务区内码 NUMBER(9) 9 5750390B-7BB2-42DD-996E-F510D357853C 经营模式 Business_Type 1671100124 yskj01 1671443841 yskj01 经营模式 NUMBER(8) 8 EB284FC1-8688-4A4F-8806-0F5BAC426295 经营业态 Business_Trade 1671100124 yskj01 1671443841 yskj01 经营业态 VARCHAR2(50) 50 93DC16E6-83B2-46D6-B127-2D707D92F9D3 经营品牌 Business_Brand 1671100124 yskj01 1671443841 yskj01 经营品牌 VARCHAR2(50) 50 A3429A9D-1D8B-4986-8D3B-A9F6BEC55870 商品业态 ShopTrade 1671100124 yskj01 1671443841 yskj01 商品业态 NUMBER(8) 8 B8AE0ECF-F17D-484C-930A-7EDC39C2D774 销售数量 Total_Count 1671100124 yskj01 1671443841 yskj01 销售数量 NUMBER(16,2) 16 2 EE886817-4EDD-4252-AD42-F5FEE0F12111 客单数量 Ticket_Count 1671100124 yskj01 1671443841 yskj01 客单数量 NUMBER(9) 9 CDD6FB31-1C13-4B04-9059-E6BD68076B5E 优惠金额 TotalOff_Amount 1671100124 yskj01 1671443841 yskj01 优惠金额 NUMBER(16,2) 16 2 B1C7C1E8-E162-486F-BBCA-A1FD5355F399 营收金额 Revenue_Amount 1671100124 yskj01 1671443841 yskj01 营收金额 NUMBER(16,2) 16 2 C312979C-0E91-433F-BEE1-073CFF3597C0 移动支付 MobilePay_Amount 1671100124 yskj01 1671443841 yskj01 移动支付 NUMBER(16,2) 16 2 F736358E-052E-44A6-954C-DF0B2D4BB765 现金支付 CashPay_Amount 1671100124 yskj01 1671443841 yskj01 现金支付 NUMBER(16,2) 16 2 0B094E72-7B37-471F-B4F2-49B780B68363 其他支付 OtherPay_Amount 1671100124 yskj01 1671443841 yskj01 其他支付 NUMBER(16,2) 16 2 27A85638-5FDC-4360-9B6C-B197E13AFDA8 长短款 Different_Amount 1671100124 yskj01 1671443841 yskj01 长短款 NUMBER(16,2) 16 2 C385FB7C-CE25-40AF-A834-554D7E48366B 稽核次数 Audit_Count 1671100124 yskj01 1671443841 yskj01 稽核次数 NUMBER(9) 9 26A3D149-26F8-4935-8BAA-39EE41CDBF89 门店数量 Shop_Count 1671100124 yskj01 1671443841 yskj01 门店数量 NUMBER(9) 9 7D564FE7-2F14-4FFF-AF9B-19B56FE75C7C 日结账单数量 Endaccount_Count 1671100124 yskj01 1671443841 yskj01 日结账单数量 NUMBER(9) 9 53A08592-FFA0-4794-88FF-FE2B7BFD594F 自然日营收 RevenueDaily_Amount 1671100124 yskj01 1671443841 yskj01 自然日营收 NUMBER(16,2) 16 2 EA75CA29-DCE6-4630-9FA5-A3F91741CCF2 自然日客单 TicketDaily_Count 1671100124 yskj01 1671443841 yskj01 自然日客单 NUMBER(9) 9 ABB1089C-C5BC-4EEA-B671-DBE8CB75F9BD 数据状态 RevenueMonthly_State 1671100124 yskj01 1671443841 yskj01 数据状态 1 NUMBER(1) 1 E084B11E-195B-4AED-9103-39518912FC4A 更新时间 Record_Date 1671100124 yskj01 1671443841 yskj01 更新时间 SYSDATE DATE 9A7ECDA1-2010-4A7E-BE8B-AB9E4FA8193B Key_1 Key_1 1671414885 yskj01 1671414930 yskj01 9FE8F494-9514-4638-8464-6D7E9F3EDA25 自动更新说明表 T_ModifyLog 1671100075 yskj01 1671416080 yskj01 自动更新说明表 9D3EA5F7-AF60-42F1-999D-55BE189A75FA Related Columns Related Columns 1671416083 yskj01 1671416083 yskj01 6E380ACF-0AB1-4025-8DAF-9929AF0FA681 表内码 ModifyLog_ID 1671415777 yskj01 1671443841 yskj01 表内码 NUMBER(9) 9 1 4CCF6988-5529-4E0F-A725-7A6474BCA629 统计表内码 Dashboard_ID 1671415777 yskj01 1671443841 yskj01 统计表内码 NUMBER(9) 9 D91D9320-D323-4797-9B82-B804F2760F4D 统计表名称 Dashboard_TableName 1671415777 yskj01 1671443841 yskj01 统计表名称 VARCHAR2(50) 50 0B5B045D-58BB-4BCC-83DF-32CCA6289C09 字段名称 Field_Name 1671415777 yskj01 1671443841 yskj01 字段名称 VARCHAR2(100) 100 E528F7C7-472B-4365-AF33-4F50E796E6E1 字段原值 Field_OriValue 1671415777 yskj01 1671443841 yskj01 字段原值 VARCHAR2(1000) 1000 944A4E83-B637-4C47-AD83-CA16D5246F3A 字段新值 Field_NewValue 1671415777 yskj01 1671443841 yskj01 字段新值 VARCHAR2(1000) 1000 E0C4C0DA-2C45-4DED-89C5-C98C8A54075C 更新说明 ModifyLog_Intro 1671415777 yskj01 1671443841 yskj01 更新说明 VARCHAR(3000) 3000 4D2B89E1-BDDA-4608-988E-AD0AAC596AF3 记录时间 Record_Date 1671415777 yskj01 1671443841 yskj01 记录时间 SYSDATE DATE 995B6FC4-6B6A-49B3-BF23-D450228299F6 Key_1 Key_1 1671415777 yskj01 1671416007 yskj01 38AA87D6-98B0-4E04-B1AC-C7CA4AF84DDF 服务区稽核月度统计表 T_AuditMonthly 1671100077 yskj01 1671444832 yskj01 服务区稽核月度统计表 6307D2B2-2CAB-4F43-8669-915825CA7453 Related Columns Related Columns 1671446342 yskj01 1671446342 yskj01 E2B2659A-AD03-44CE-9DA7-5FA41BAD9A85 月度表内码 AuditMonthly_ID 1671416145 yskj01 1671443841 yskj01 月度表内码 NUMBER(9) 9 1 6C2D84F9-ADAF-4C7C-AAE2-7F1E52EF9A38 统计月份 Statistics_Month 1671416145 yskj01 1671443841 yskj01 统计月份 NUMBER(6) 6 7A46D0D6-0B82-4F31-A921-6403D0E89639 省份内码 Province_ID 1671416145 yskj01 1671443841 yskj01 省份内码 NUMBER(9) 9 FF79560A-0973-486B-9566-D8E98E1A40D1 服务区内码 Serverpart_ID 1671416145 yskj01 1671443841 yskj01 服务区内码 NUMBER(9) 9 AE22BD53-0765-46C1-9D38-2E3FFA75FB4F 经营模式 Business_Type 1671416145 yskj01 1671443841 yskj01 经营模式 NUMBER(8) 8 85BC67EE-58AC-43AF-85FA-0C4773F2996A 经营业态 Business_Trade 1671416145 yskj01 1671443841 yskj01 经营业态 VARCHAR2(50) 50 7F5C3DAD-A3C3-4954-BE09-767133A17619 本月天数 Statistics_Days 1671416145 yskj01 1671443841 yskj01 本月天数 NUMBER(4) 4 7D0C275A-5035-4668-AE42-825A9A263A7B 稽核天数 Audit_Days 1671416145 yskj01 1671443841 yskj01 稽核天数 NUMBER(8) 8 997AD977-32D1-45E3-957A-2CCE0CB7D9FF 稽核次数 Audit_Count 1671416145 yskj01 1671443841 yskj01 稽核次数 NUMBER(8) 8 7E86516A-4671-42E3-8587-645FCBD07938 异常稽核次数 AbnormalAudit_Count 1671416145 yskj01 1671443841 yskj01 异常稽核次数 NUMBER(8) 8 E269E522-648F-462A-A045-480B5AC4DF9C 异常处理次数 AbnormalAudit_DealCount 1671416145 yskj01 1671443841 yskj01 异常处理次数 NUMBER(8) 8 63945D21-11F0-4D28-B444-CE1104F51812 视频查看次数 Audit_CheckCount 1671444056 yskj01 1671444832 yskj01 现场稽核查看次数 NUMBER(8) 8 D928AF17-47A8-49A6-B3AA-2075A0D43819 指令稽核次数 CommandAudit_Count 1671416145 yskj01 1671443841 yskj01 指令稽核次数 NUMBER(8) 8 857D8875-CE90-4AAC-8EDF-D5A76E7A39E1 指令稽核异常次数 CommandAudit_DealCount 1671416145 yskj01 1671443841 yskj01 指令稽核异常次数 NUMBER(8) 8 23BAB2B0-EE71-4B86-A450-492B7D5D3253 现金支付 CashPay_Amount 1671416145 yskj01 1671443841 yskj01 现金支付 NUMBER(9,2) 9 2 12EA0EF4-A8DE-45A2-BF49-05F7504151CB 稽查现金 AuditCash_Amount 1671416145 yskj01 1671443841 yskj01 稽查现金 NUMBER(9,2) 9 2 C7C732CA-B621-4D29-B013-6D24FBE80757 长短款 Different_Amount 1671416145 yskj01 1671443841 yskj01 长短款 NUMBER(9,2) 9 2 83807D42-83CD-4D1D-981F-A650E64B48DA 异常行为数量 Aberration_Count 1671416145 yskj01 1671443841 yskj01 异常行为数量 NUMBER(8) 8 6C7CF1C4-1563-4DC4-B490-0AB674C7640F 异常行为金额 Aberration_Amount 1671416145 yskj01 1671443841 yskj01 异常行为金额 NUMBER(9,2) 9 2 A2F6A831-735A-42AE-9B77-EDFB57778242 异常查看次数 Aberration_CheckCount 1671444056 yskj01 1671444832 yskj01 异常行为视频查看次数 NUMBER(8) 8 9A3A3657-34F0-4AF8-B154-052611D03B59 必查项数量 MustCheck_Count 1671416145 yskj01 1671443841 yskj01 必查项数量 NUMBER(8) 8 B8F24019-AE00-4A29-9CEA-1CDBC39C3099 抽查项数量 SpotCheck_Count 1671416145 yskj01 1671443841 yskj01 抽查项数量 NUMBER(8) 8 E955F52C-D69F-435A-AEC2-DA377A3E683F 数据状态 AuditMonthly_State 1671416145 yskj01 1671443841 yskj01 数据状态 1 NUMBER(1) 1 19CCD94A-FF4B-42F9-9EAF-623AC58EC699 更新时间 Record_Date 1671416145 yskj01 1671443841 yskj01 更新时间 SYSDATE DATE BB961A9E-E4FE-431A-B821-90B19063BA8A Key_1 Key_1 1671416287 yskj01 1671417562 yskj01 3BFCECF4-A32D-474A-BD45-F07BAF2B70B8 服务区异常行为月度明细表 T_AuditMonthlyDetail 1671100078 yskj01 1671418419 yskj01 服务区异常行为月度明细表 5DA0C0AF-94A4-4C9A-87C4-89D28EA54823 Related Columns Related Columns 1671446338 yskj01 1671446338 yskj01 495282D8-6FD3-4E1D-9AF1-00556F08D979 表内码 AuditMonthlyDetail_ID 1671417652 yskj01 1671443841 yskj01 表内码 NUMBER(9) 9 1 7DF3C388-5609-40F9-BCF1-1AA29852652A 月度表内码 AuditMonthly_ID 1671418419 yskj01 1671443841 yskj01 月度表内码 NUMBER(9) 9 DF539C9B-9C2A-4E18-BD04-CDCF199C18BC 统计月份 Statistics_Month 1671416145 yskj01 1671443841 yskj01 统计月份 NUMBER(6) 6 82036F9D-CA49-4BA8-B73D-1A95090C5FE4 省份内码 Province_ID 1671416145 yskj01 1671443841 yskj01 省份内码 NUMBER(9) 9 00F278BC-7160-48D4-A786-729A33C50868 服务区内码 Serverpart_ID 1671416145 yskj01 1671443841 yskj01 服务区内码 NUMBER(9) 9 9C681A1F-F5D5-42A1-B1C9-E0BCE47739F8 经营模式 Business_Type 1671416145 yskj01 1671443841 yskj01 经营模式 NUMBER(8) 8 F26C0B75-5C18-4425-B417-462F9E32D3E5 经营业态 Business_Trade 1671416145 yskj01 1671443841 yskj01 经营业态 VARCHAR2(50) 50 5A60D6B6-9F70-47D0-B06D-9C0394701173 异常类型 Aberration_Type 1671417652 yskj01 1671443841 yskj01 异常类型 NUMBER(8) 8 526BEEC7-0F62-483B-88EC-F2CBA68DE303 异常数量 Aberration_Count 1671417652 yskj01 1671443841 yskj01 异常数量 NUMBER(9) 9 DFAE0185-3145-402F-92F8-C2A6E88C6007 异常金额 Aberration_Amount 1671417652 yskj01 1671443841 yskj01 异常金额 NUMBER(9,2) 9 2 140A312E-210D-4E3C-879F-4D57A2F3CDD5 数据状态 AuditMonthlyDetail_State 1671417652 yskj01 1671443841 yskj01 数据状态 1 NUMBER(1) 1 8C196DAA-DA27-4118-908F-5EBD7CCB22A8 更新时间 Record_Date 1671417652 yskj01 1671443841 yskj01 更新时间 SYSDATE DATE 2F7BDD0D-1EC4-4CDF-A630-5FF38073BE35 Key_1 Key_1 1671417652 yskj01 1671418326 yskj01 5573C2CA-C364-4469-AC86-D40F91B42AD9 餐饮毛利率统计表 T_CateringGrossMargin 1671100079 yskj01 1671446331 yskj01 餐饮毛利率统计表 F15FF233-199B-4FF6-8B23-BB8BD9A5175B Related Columns Related Columns 1671446344 yskj01 1671446344 yskj01 00BB3C5A-AF28-4C20-BA35-28DD4B4C6CDC 毛利率表内码 CateringGrossMargin_ID 1671420152 yskj01 1671443841 yskj01 毛利率表内码 NUMBER(9) 9 1 B4F2AC06-E69C-4945-91A9-DD6F5CBD7070 统计月份 Statistics_Month 1671416145 yskj01 1671443841 yskj01 统计月份 NUMBER(6) 6 74591A41-DD48-4259-BC3E-E1D0EBAD43AB 省份内码 Province_ID 1671416145 yskj01 1671443841 yskj01 省份内码 NUMBER(9) 9 C3672FF5-5D50-4FAC-A3E0-9C09E532C1BF 服务区内码 Serverpart_ID 1671416145 yskj01 1671443841 yskj01 服务区内码 NUMBER(9) 9 9423B81A-F13A-4FDB-B9FD-6F9020E05119 对客营收 Revenue_TaxAmount 1671420152 yskj01 1671443841 yskj01 对客营收 NUMBER(16,2) 16 2 62CC59C8-5A95-45C8-87ED-24DCDCF79786 除税营收 Revenue_Amount 1671420152 yskj01 1671443841 yskj01 除税营收 NUMBER(16,2) 16 2 5764150F-EB85-4965-8619-7A1656AC84D0 营收税额 Revenue_Tax 1671420152 yskj01 1671443841 yskj01 营收税额 NUMBER(16,2) 16 2 9A5952EB-CD5B-4563-AFEE-A3B49238E976 除税毛利金额 GrossProfit_TaxAmount 1671420152 yskj01 1671443841 yskj01 除税毛利金额 NUMBER(16,2) 16 2 1AA22EDC-8DC6-4301-ACBF-2B241A80B2F2 除税毛利率 GrossProfit_Amount 1671420152 yskj01 1671443841 yskj01 除税毛利率 NUMBER(16,2) 16 2 023636DC-2030-46D6-847F-FBF788B9ADDA 含税成本采购 Purchase_TaxCost 1671420152 yskj01 1671443841 yskj01 含税成本采购 NUMBER(16,2) 16 2 19B87D6E-C33B-4240-8863-873FD2EF872A 除税成本采购 Purchase_Cost 1671420152 yskj01 1671443841 yskj01 除税成本采购 NUMBER(16,2) 16 2 82965777-AFD1-4F61-8E2F-64AE65B3022F 上期结存 LastOverplus_Amount 1671420613 yskj01 1671443841 yskj01 上期结存 NUMBER(16,2) 16 2 65975FA5-7A39-42F0-948C-0951E4A2688F 本期入库 Purchase_Amount 1671420613 yskj01 1671443841 yskj01 本期入库 NUMBER(16,2) 16 2 D5154CFB-B0BF-4107-9D10-E32A605CC2BD 本期结存 Overplus_Amount 1671420613 yskj01 1671443841 yskj01 本期结存 NUMBER(16,2) 16 2 B45C6C8F-59E3-4206-9923-D2F34D4BBD7D 本期退货 Back_Amount 1671420613 yskj01 1671443841 yskj01 本期退货 NUMBER(16,2) 16 2 0F21D387-84F2-41C7-A581-199B873BC271 抵扣税金 Tax_Deduction 1671420613 yskj01 1671443841 yskj01 抵扣税金 NUMBER(16,2) 16 2 4A974295-DEAE-4E19-B780-A05B4E4EC382 员工用餐人数 StaffMeal_Count 1671420613 yskj01 1671443841 yskj01 员工用餐人数 NUMBER(9) 9 1576005E-8B93-47F5-BD96-05A784AFBD6D 员工标准餐费 StaffMeal_Amount 1671420613 yskj01 1671443841 yskj01 员工标准餐费 NUMBER(16,2) 16 2 7BDCBD1B-5C2F-4FC1-9B5E-E84AD6E30729 内部接待人数 ReceptionInside_Count 1671420613 yskj01 1671443841 yskj01 内部接待人数 NUMBER(9) 9 0A7B3FDB-F1C8-4324-86DB-A27C5B7B3A1E 内部接待餐费 ReceptionInside_Amount 1671420613 yskj01 1671443841 yskj01 内部接待餐费 NUMBER(16,2) 16 2 6A69B74E-25AF-4271-BE03-FBDFB6B79C98 外部接待人数 ReceptionOutside_Count 1671420613 yskj01 1671443841 yskj01 外部接待人数 NUMBER(9) 9 5569A9A5-7E3C-4CFF-9678-6DFF9CAF5915 外部接待餐费 ReceptionOutside_Amount 1671420613 yskj01 1671443841 yskj01 外部接待餐费 NUMBER(16,2) 16 2 33341AD2-8F73-4AD2-8114-DEC53D495B71 数据类型 CateringGrossMargin_Type 1671420613 yskj01 1671443873 yskj01 数据类型(1:餐饮门店;2:员工餐) NUMBER(1) 1 C87D77E5-A708-4610-92D7-4E1149DFBC64 数据状态 CateringGrossMargin_State 1671420613 yskj01 1671443841 yskj01 数据状态 1 NUMBER(1) 1 B481AE03-BC91-4004-8611-24ED48AF06E0 更新时间 Record_Date 1671420613 yskj01 1671443841 yskj01 更新时间 SYSDATE DATE 2F146474-ACA5-4E9C-B590-1A094E8910E4 Key_1 Key_1 1671420152 yskj01 1671420613 yskj01 DE6DDEBF-A026-43D9-8F4E-60CFF8180F08 原材料消耗排名 T_RawMaterialRank 1671100080 yskj01 1671446334 yskj01 原材料消耗排名 2724DCA6-C09D-4C6F-B5AE-27686A242B69 表内码 RawMaterialRank_ID 1671431420 yskj01 1671443841 yskj01 表内码 NUMBER(9) 9 1 7F706F71-9615-4BB9-A70E-2F3418BA4AF7 毛利率表内码 CateringGrossMargin_ID 1671433424 yskj01 1671443841 yskj01 毛利率表内码 NUMBER(9) 9 828856B3-0938-4041-AEA5-285F3E6C2831 统计月份 Statistics_Month 1671416145 yskj01 1671443841 yskj01 统计月份 NUMBER(6) 6 EBDA41DE-76A4-4948-928D-C314AB5AA246 省份内码 Province_ID 1671416145 yskj01 1671443841 yskj01 省份内码 NUMBER(9) 9 AA3AE59F-A4FE-4E04-B94A-08751B71C02B 服务区内码 Serverpart_ID 1671416145 yskj01 1671443841 yskj01 服务区内码 NUMBER(9) 9 C7E71356-D494-4D64-BF68-B8AC3F7900F1 供应商内码 Supplier_ID 1671431420 yskj01 1671443841 yskj01 供应商内码 NUMBER(9) 9 EA7F59C4-FC74-4897-8612-CBD6D80CF1A4 原材料类型内码 RawMaterialType_ID 1671431420 yskj01 1671443841 yskj01 原材料类型内码 NUMBER(9) 9 D5D46B8E-297B-468A-8341-D414CB40D5BD 采购数量 Purchase_Count 1671431420 yskj01 1671443841 yskj01 采购数量 NUMBER(16,2) 16 2 769DEBE8-A916-4FA8-843C-F105DEF2AD34 采购金额 Purchase_Amount 1671431420 yskj01 1671443841 yskj01 采购金额 NUMBER(16,2) 16 2 79E3B245-79F5-4CC9-951F-2D636C0EB919 采购均价 Purchase_AvgPrice 1671431420 yskj01 1671443841 yskj01 采购均价 NUMBER(16,6) 16 6 5DDA01AA-36BC-4200-8F5B-9B9342446B92 数据类型 RawMaterialRank_Type 1671431420 yskj01 1671443880 yskj01 数据类型(1:餐饮门店;2:员工餐) NUMBER(1) 1 7D914455-E802-4002-92A0-A1B3F16CBF8A 数据状态 RawMaterialRank_State 1671431420 yskj01 1671443841 yskj01 数据状态 1 NUMBER(1) 1 070FFC50-F49B-4FEE-8D5F-3DD92C1EABAC 更新时间 Record_Date 1671431420 yskj01 1671443841 yskj01 更新时间 SYSDATE DATE 6B7238C4-960E-4FC8-9F00-7FF7B1C5E479 Key_1 Key_1 1671432372 yskj01 1671433398 yskj01 84DF914F-A358-46B2-84E0-B3B94106E6FA 财务费用统计表 T_FinancialExpense 1671100081 yskj01 1671446337 yskj01 财务费用统计表 F6E546A2-83F1-4DF2-A156-F9BD8853B42B 表内码 FinancialExpense_ID 1671433428 yskj01 1671443841 yskj01 表内码 NUMBER(9) 9 1 800DDC98-2874-4232-9B8D-011D97C6335F 统计月份 Statistics_Month 1671416145 yskj01 1671443841 yskj01 统计月份 NUMBER(6) 6 D9EED06C-390B-44A1-AAB0-8B2228AD513F 省份内码 Province_ID 1671416145 yskj01 1671443841 yskj01 省份内码 NUMBER(9) 9 9ABD17A7-4ED7-4837-AD20-F6019BEC5B8B 服务区内码 Serverpart_ID 1671416145 yskj01 1671443841 yskj01 服务区内码 NUMBER(9) 9 87C371D2-4A1E-45B6-A6B6-FB613ACA222A 科目大类 Subject_HostCode 1671433428 yskj01 1671443841 yskj01 科目大类 VARCHAR2(20) 20 E9FFDBFD-F4BC-40B4-9A71-082F330CBE63 科目代码 Subject_Code 1671433428 yskj01 1671443841 yskj01 科目代码 VARCHAR2(20) 20 45DD1680-4F57-4EC3-93F6-942A46E1E6B6 费用支出 Expense_Amount 1671433428 yskj01 1671443841 yskj01 费用支出 NUMBER(16,2) 16 2 477EE2FE-187C-435F-9716-ACA514F5EBF2 费用标准 Expense_Standard 1671433428 yskj01 1671443841 yskj01 费用标准 NUMBER(16,2) 16 2 20637833-CD4E-499F-899D-4B6722F39BE0 数据状态 FinancialExpense_State 1671433428 yskj01 1671443841 yskj01 数据状态 1 NUMBER(1) 1 1BD02179-B167-4A15-9AAF-9DB540985A20 更新时间 Record_Date 1671433428 yskj01 1671443841 yskj01 更新时间 SYSDATE DATE C58D83F8-2F5D-4398-AF86-34B5C383A019 Key_1 Key_1 1671433428 yskj01 1671433666 yskj01 A1BBD142-6945-48C0-B764-276272CB554F Reference_1 Reference_1 1671418419 yskj01 1671418419 yskj01 0..* 1 1 C8FACBB5-4EF6-4D79-BCF2-CD240175049B 1671418419 yskj01 1671418419 yskj01 FE470762-2FB9-4C15-B8ED-910A83ED72D2 Reference_2 Reference_2 1671433424 yskj01 1671433424 yskj01 0..* 1 1 305A9FD1-5168-4208-A1ED-D3EB02FDFE46 1671433424 yskj01 1671433424 yskj01 3BD06DC2-D401-46D4-8834-6C2AC31B1558 PUBLIC PUBLIC 1433304340 Administrator 1656663860 yskj01 91D92225-5588-4E96-B76E-FF9D3D257E08 1671433699 yskj01 1671433699 yskj01 DC7E7739-8E6A-4ACE-97F9-920C1C0F44DD 1671433706 yskj01 1671433706 yskj01 6476D865-3DC8-4B27-852F-3E856ED25763 1671433710 yskj01 1671433710 yskj01 5042C7B1-61B1-4046-8900-86C97B8FB272 1671433713 yskj01 1671433713 yskj01 3B54D10E-CDFC-4A97-939B-A36B37D218A6 1671433718 yskj01 1671433718 yskj01 9FDD899E-79F1-480A-86AB-E3427CD57793 1671433721 yskj01 1671433721 yskj01 AFB489F3-9022-48BE-AAA5-CFEDE56E93A6 1671433724 yskj01 1671433724 yskj01 7876A8D4-819F-4EE8-9E40-747EDDC60D1C ORACLE Version 10g ORACLE10g 1433304340 Administrator 1656658721 yskj01 file:///%_DBMS%/oracl10g.xdb 92EAD7D1-CC48-4A70-BCD1-8AB4B082FD0A 4BA9F647-DAB1-11D1-9944-006097355D9B 1647573768