722DF388-149B-40E4-8A9D-6686BA37613D ddpf_alpha_7-1-1 ddpf_alpha_7-1-1 1467375726 ph2 1467548488 ph2 [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 [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= {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,62={6EBD0427-31BE-44D4-BA6D-77622CBC4F1E},DatabaseType,6=InnoDB 411D6D4D-46D4-41CD-B302-00D41C79C94A MySQL 5.0 MYSQL50 1467375726 ph2 1467375726 ph2 F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B DF72E2BF-CFC2-4A9D-B322-0C0D25FA25FA PhysicalDiagram_1 PhysicalDiagram_1 1467375718 ph2 1467548488 ph2 [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Show Links intersections=Yes Activate automatic link routing=Yes Grid size=0 Graphic unit=2 Window color=255, 255, 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255, 255, 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Show Icon=No Mode=2 Trunc Length=40 Word Length=40 Word Text=!"#$%&')*+,-./:;=>?@\]^_`|}~ Shortcut IntIcon=Yes Shortcut IntLoct=Yes Shortcut IntFullPath=No Shortcut IntLastPackage=Yes Shortcut ExtIcon=Yes Shortcut ExtLoct=No Shortcut ExtFullPath=No Shortcut ExtLastPackage=Yes Shortcut ExtIncludeModl=Yes EObjShowStrn=Yes ExtendedObject.Comment=No ExtendedObject.IconPicture=No ExtendedObject.TextStyle=No ExtendedObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Object Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Source" >[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] </Form>[CRLF]</Form> FileObject.Stereotype=No FileObject.DisplayName=Yes FileObject.LocationOrName=No FileObject.IconPicture=No FileObject.TextStyle=No FileObject.IconMode=Yes FileObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Location" Attribute="LocationOrName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Package.Stereotype=Yes Package.Comment=No Package.IconPicture=No Package.TextStyle=No Package_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Display Model Version=Yes Table.Stereotype=Yes Table.DisplayName=Yes Table.OwnerDisplayName=No Table.Columns=Yes Table.Columns._Filter="All Columns" PDMCOLNALL Table.Columns._Columns=Stereotype DataType KeyIndicator Table.Columns._Limit=-5 Table.Keys=No Table.Keys._Columns=Stereotype Indicator Table.Indexes=No Table.Indexes._Columns=Stereotype Table.Triggers=No Table.Triggers._Columns=Stereotype Table.Comment=No Table.IconPicture=No Table.TextStyle=No Table_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="Stereotype No\r\nDisplayName Yes\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nDomain No\r\nKeyIndicator No\r\nIndexIndicator No\r\nNullStatus No" Filters=""All Columns" PDMCOLNALL ""\r\n"PK Columns" PDMCOLNPK "\"PRIM \"TRUE\" TRUE\""\r\n"Key Columns" PDMCOLNKEY "\"KEYS \"TRUE\" TRUE\""" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Keys" Collection="Keys" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Triggers" Collection="Triggers" Columns="Stereotype No\r\nDisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> View.Stereotype=Yes View.DisplayName=Yes View.OwnerDisplayName=No View.Columns=Yes View.Columns._Columns=DisplayName View.Columns._Limit=-5 View.TemporaryVTables=Yes View.Indexes=No View.Comment=No View.IconPicture=No View.TextStyle=No View_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="DisplayName No\r\nExpression No\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nIndexIndicator No" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Tables" Collection="TemporaryVTables" Columns="Name Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="DisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Procedure.Stereotype=No Procedure.DisplayName=Yes Procedure.OwnerDisplayName=No Procedure.Comment=No Procedure.IconPicture=No Procedure.TextStyle=No Procedure_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Reference.Cardinality=No Reference.ImplementationType=No Reference.ChildRole=Yes Reference.Stereotype=Yes Reference.DisplayName=No Reference.ForeignKeyConstraintName=No Reference.JoinExpression=No Reference.Integrity=No Reference.ParentRole=Yes Reference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Cardinality" Attribute="Cardinality" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Implementation" Attribute="ImplementationType" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Cons&traint Name" Attribute="ForeignKeyConstraintName" Prefix="" Suffix="" Caption="Cons&traint Name" Mandatory="No" />[CRLF] <StandardAttribute Name="Join" Attribute="JoinExpression" Prefix="" Suffix="" Caption="Join" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Referential integrity" Attribute="Integrity" Prefix="" Suffix="" Caption="Referential integrity" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> ViewReference.ChildRole=Yes ViewReference.Stereotype=Yes ViewReference.DisplayName=No ViewReference.JoinExpression=No ViewReference.ParentRole=Yes ViewReference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Join Expression" Attribute="JoinExpression" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=6000 Height=2000 Brush color=255 255 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=64 Brush gradient color=192 192 192 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 255 128 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FRMELNK] CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FILO] OBJSTRNFont=新宋体,8,N OBJSTRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LCNMFont=新宋体,8,N LCNMFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PDMPCKG] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 KeysFont=新宋体,8,N KeysFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 TriggersFont=新宋体,8,N TriggersFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=178 214 252 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 TemporaryVTablesFont=新宋体,8,N TemporaryVTablesFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=208 208 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4000 Height=1000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 108 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=新宋体,8,N OBJXSTRFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0, 0, 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 (8268, 11693) ((315,354), (433,354)) 1 15 1467442352 1467544697 ((6349,30279), (40085,33045)) ((6749,32645),(20995,32645),(20995,30904),(39685,30904)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 3 1467442669 1467544697 ((6400,32824), (39768,34074)) ((6800,33449),(39368,33449)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467443188 1467544697 ((6400,28461), (39768,29711)) ((6800,29086),(39368,29086)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467443198 1467544697 ((2811,26061), (39768,28140)) ((3211,27740),(3211,26686),(39368,26686)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467446227 1467544613 ((-150897,-26922), (-115573,-23562)) ((-150497,-26522),(-150497,-24187),(-115973,-24187)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467447271 1467544613 ((-101595,-29031), (-73955,-22362)) ((-74355,-28631),(-74355,-22987),(-101195,-22987)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467448692 1467544613 ((-144516,-46147), (-136095,-44897)) ((-136495,-45522),(-144116,-45522)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467448699 1467544613 ((-85806,-46300), (-81538,-43567)) ((-85406,-45900),(-83382,-45900),(-83382,-44192),(-81938,-44192)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467450178 1467544613 ((-152322,-72594), (-128710,-45428)) ((-129110,-72194),(-151697,-72194),(-151697,-45828)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1 1467450187 1467544613 ((-89300,-70335), (-73730,-44505)) ((-88900,-69935),(-74355,-69935),(-74355,-44905)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467450689 1467544613 ((-148000,-76613), (-128822,-75363)) ((-129222,-75988),(-147600,-75988)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467450690 1467544613 ((-89300,-76630), (-71856,-75380)) ((-88900,-76005),(-72256,-76005)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467451302 1467546333 ((1822,64692), (7433,80508)) ((7033,80108),(2447,80108),(2447,65092)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467451314 1467544697 ((526,38166), (1776,57470)) ((1151,57070),(1151,38566)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467451433 1467546336 ((-2964,64692), (-1714,76494)) ((-2339,76094),(-2339,65092)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467451516 1467546164 ((-34131,37328), (-6498,58988)) ((-33731,58588),(-33731,37953),(-6898,37953)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467451820 1467466153 ((48151,4805), (49401,25010)) ((48776,5205),(48776,24610)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467463839 1467466153 ((-5901,-34432), (46415,25160)) ((-5501,-34032),(45790,-34032),(45790,24760)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467463842 1467466153 ((-5901,-30630), (44015,25010)) ((-5501,-30230),(43390,-30230),(43390,24610)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467463844 1467466153 ((-5901,-29430), (39768,28511)) ((-5501,-29030),(25409,-29030),(25409,27886),(39368,27886)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467463846 1467466153 ((-14642,-24036), (47905,25010)) ((-14242,-23636),(-14242,5531),(47280,5531),(47280,24610)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467544753 1467544774 ((-48022,-31454), (-6498,28978)) ((-47622,-31054),(-47622,28353),(-6898,28353)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467544885 1467544885 ((-6726,-24036), (-5476,28140)) ((-6101,-23636),(-6101,27740)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467544971 1467544971 ((-60352,9551), (-6498,30178)) ((-59952,9951),(-59952,29553),(-6898,29553)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467545185 1467545185 ((-73555,-29031), (-6498,31378)) ((-73155,-28631),(-73155,30753),(-6898,30753)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467545188 1467545188 ((-153297,-26922), (-6498,37378)) ((-152897,-26522),(-152897,36753),(-6898,36753)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467545480 1467545480 ((-89300,-72735), (576,28140)) ((-88900,-72335),(-49,-72335),(-49,27740)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467545499 1467545499 ((-89300,-71535), (-624,28140)) ((-88900,-71135),(-1249,-71135),(-1249,27740)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467545673 1467545673 ((-121653,-65298), (-6498,33778)) ((-121253,-64898),(-121253,33153),(-6898,33153)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467545693 1467545697 ((-122658,-65298), (-6348,35128)) ((-122258,-64898),(-122258,34503),(-6748,34503)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 3 1467545851 1467545851 ((-91160,-44985), (-6498,32578)) ((-90760,-44585),(-90760,31953),(-6898,31953)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467545902 1467545902 ((-132057,-44876), (-6498,36178)) ((-131657,-44476),(-131657,35553),(-6898,35553)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467546004 1467546133 ((6400,35224), (20195,57393)) ((19795,56993),(19795,35849),(6800,35849)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467546054 1467546163 ((-9217,38166), (-4185,61741)) ((-8817,61341),(-4810,61341),(-4810,38566)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467546112 1467546140 ((6400,34024), (35032,59580)) ((34632,59180),(34632,34649),(6800,34649)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467546324 1467546336 ((-34356,64560), (-14187,80918)) ((-14587,80518),(-33731,80518),(-33731,64960)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1467546140 -1 ((28595,59180), (40669,65552)) 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 1467544538 -1 ((-4210,57070), (7479,65092)) 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 1467544833 -1 ((-55825,-39078), (-41819,-31054)) 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 1467544971 -1 ((-67342,-3023), (-52562,9951)) 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 1467466153 -1 ((39368,24610), (49512,33562)) 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 1467466153 -1 ((-22983,-39224), (-5501,-23636)) 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 1467466153 -1 ((46487,-1167), (56632,5205)) 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 1467544613 -1 ((-115973,-27352), (-101195,-18622)) 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 1467546164 -1 ((-41121,58588), (-26341,64960)) 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 1467546336 -1 ((-14587,76094), (-1739,84942)) 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 1467546333 -1 ((7033,76509), (17951,83707)) 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 1467546163 -1 ((-22824,58567), (-8817,64115)) 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 1467544613 -1 ((-72256,-78781), (-59022,-73233)) 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 1467544613 -1 ((-160834,-78764), (-147600,-73216)) 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 1467544613 -1 ((-104838,-79562), (-88900,-65108)) 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 1467544613 -1 ((-129222,-79490), (-113284,-64898)) 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 1467545851 -1 ((-97482,-53433), (-85406,-44585)) 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 1467545902 -1 ((-136495,-53324), (-124419,-44476)) 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 1467546133 -1 ((12797,56993), (27191,67491)) 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 1467545185 -1 ((-81938,-44905), (-66772,-28631)) 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 1467544613 -1 ((-159278,-45828), (-144116,-26522)) 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 1467544697 -1 ((-6898,27740), (6800,38566)) 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 1467549075 -1 ((-76085,73462), (-65375,79010)) 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 1467452907 1467466153 -1 ((60323,-4552), (68385,2946)) 12615808 16765136 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 TemporaryVTables 0 新宋体,8,N Indexes 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1467460872 1467466153 -1 ((60373,-14872), (68435,-7374)) 12615808 16765136 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 TemporaryVTables 0 新宋体,8,N Indexes 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1467461678 1467466153 -1 ((60373,-39730), (68435,-32232)) 12615808 16765136 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 TemporaryVTables 0 新宋体,8,N Indexes 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1467461791 1467466153 -1 ((60373,-50775), (68435,-43277)) 12615808 16765136 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 TemporaryVTables 0 新宋体,8,N Indexes 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1467461863 1467466153 -1 ((60373,-61129), (68435,-53631)) 12615808 16765136 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 TemporaryVTables 0 新宋体,8,N Indexes 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1467462209 1467466153 -1 ((60373,-27174), (68435,-19676)) 12615808 16765136 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 TemporaryVTables 0 新宋体,8,N Indexes 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 32536D48-8FF5-4BB7-8AD5-9C8CAFB1A34B dd_user dd_user 1467375730 ph2 1467545705 ph2 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表' 1FA9E942-2198-4912-B868-3A5BD6FEBC6F userId userId 1467375730 ph2 1467540190 ph2 用户id int(20) 20 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,159={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,5=false {9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,0= {B314652C-DD43-4F81-8524-6F97A1BAACBA},Collate,0= 78925871-A0FE-49D9-A485-AA50E68EFF5F userAccount userAccount 1467375730 ph2 1467523700 ph2 账号 char(20) 20 1 66C0FF30-3869-4046-8229-DED2A944F612 userPassword userPassword 1467375730 ph2 1467528259 ph2 用户密码 char(40) 40 1 E5A02DDD-9306-49FA-8541-9E7CBE601892 userName userName 1467375730 ph2 1467528264 ph2 用户姓名 varchar(64) 64 1 D8F1E2DE-EF64-40C4-9FC9-EA4E57479D27 departmentId departmentId 1467375730 ph2 1467528268 ph2 用户所属部门id int(20) 20 D8930BB3-AB0F-4418-A0F0-55056189F1B0 establishmentId establishmentId 1467375730 ph2 1467528274 ph2 用户编制id int(20) 20 E1761306-7F54-4064-95D7-5A4BF48C35E7 dutiesId dutiesId 1467375730 ph2 1467528278 ph2 用户行政职务id int(20) 20 3CC6384C-8A79-47F4-BE03-0145FF92F53B jobTitleId jobTitleId 1467375730 ph2 1467528282 ph2 用户行政职称id int(20) 20 41728FE4-0C84-435D-9C6C-0A5EFDC8DE40 ctime ctime 1467464972 ph2 1467464987 ph2 datetime 4987AB8D-7AA7-4C6D-878E-96177CC5A953 mtime mtime 1467464972 ph2 1467464987 ph2 datetime 6CA12DAD-5682-4E02-BC1A-09703E3023E6 deleted deleted 1467464972 ph2 1467524284 ph2 0 tinyint 27003C44-2477-4D8F-9F90-3AB81845E7C0 Key_1 Key_1 1467442265 ph2 1467442275 ph2 E64D3726-DF4B-423E-97EB-6ADCBE4EA859 理论课课表 dd_course_theory 1467375730 ph2 1467545147 ph2 课表(理论课) 在导入课表时，要更新部门表中没有的课程所属部门 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课表(理论课)//在导入课表时，要更新部门表中没有的课程所属部门' 0E2B036F-D94B-42E1-AA6E-71E8E777730A courseId courseId 1467375730 ph2 1467540190 ph2 课程id int(20) 20 1 1 62966507-6765-4ABA-84C8-B671F76AD2A5 courseYear courseYear 1467375730 ph2 1467525766 ph2 学年 smallint 1 1E5B691D-750F-42B7-8D6C-6D0C3444CEFB courseTerm courseTerm 1467375730 ph2 1467525777 ph2 学期 tinyint 1 F513F5DB-921D-4808-BF66-6EC7C30EBA60 courseName courseName 1467375730 ph2 1467525785 ph2 课程名称 varchar(255) 255 1 E2E14F79-01E2-4B89-90B3-F64B86B52812 userId userId 1467545117 ph2 1467545147 ph2 int(20) 20 1 794B6793-3403-41CD-84F4-55D6A8F4D7A1 courseJoined courseJoined 1467375730 ph2 1467525806 ph2 上课人数 int 35B2256A-DFA0-424B-B062-58182CB0EF8C courseClass courseClass 1467375730 ph2 1467526211 ph2 上课班级 '' varchar(40) 40 40D5952E-C406-4762-BEE8-1D8C9E8460D4 courseSite courseSite 1467375730 ph2 1467526215 ph2 上课地点 '' varchar(40) 40 AEF5876D-87C2-4665-9D10-1910B1482BCB courseSession courseSession 1467375730 ph2 1467526221 ph2 上课时间周二第1，2节 '' varchar(40) 40 53C033E8-8BAE-4BF2-B3D1-F1A0D58B56C3 courseType courseType 1467375730 ph2 1467526225 ph2 课程类型 '' varchar(40) 40 3C885B0A-C4D9-412C-B069-B9E49D91E041 courseDepartmentId courseDepartmentId 1467375730 ph2 1467525852 ph2 开课学院 int(20) 20 CD8A651D-58AB-4CEC-BF6A-F76FBA10D30B coursePeriod coursePeriod 1467375730 ph2 1467525856 ph2 课程学时 smallint 9A521C6E-0603-47FD-8FAA-A2FE8DD8CC27 courseStartWeek courseStartWeek 1467375730 ph2 1467525864 ph2 开始周 tinyint 285133F1-EEA7-4705-B7B6-3A1A95CBD096 courseEndWeek courseEndWeek 1467375730 ph2 1467525874 ph2 结束周 tinyint F2A4478D-6E51-4AFD-9187-B1554ED6C5B3 courseCampus courseCampus 1467375730 ph2 1467525989 ph2 校区名 '' varchar(40) 40 9040BA87-EE7D-4938-892F-83128B08A50B ctime ctime 1467465242 ph2 1467465266 ph2 datetime 4AF3516D-4304-4B54-867F-1E9B132E26FB mtime mtime 1467465242 ph2 1467465266 ph2 datetime 7FD5A07E-1571-47F2-AC51-A3CDD9DA2017 deleted deleted 1467465242 ph2 1467526007 ph2 0 tinyint E46E6547-99BE-44B7-85AF-E4EC1BAC220A Key_1 Key_1 1467444208 ph2 1467444232 ph2 44A0B08B-DC80-4033-94B6-AEF7B9C8156A 实验课课表 dd_course_experiment 1467375730 ph2 1467545075 ph2 在导入课表时，要更新<记录在>部门表中没有的课程的开课实验室所属部门(开课实验室不做筛选，不更新) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课表(实验课)//在导入课表时，要更新<记录在>部门表中没有的课程的开课实验室所属部门(开课实验室不做筛选，不更新)' 792E3B44-0A9F-453A-B96D-9C3538CF7276 courseId courseId 1467375730 ph2 1467540190 ph2 课程id int(20) 20 1 1 F577A325-7A3C-4223-A7CA-FC6E3A07505E courseYear courseYear 1467375730 ph2 1467526097 ph2 学年 smallint 1 32D3A0FF-EEB5-45DF-9D27-E5AC507273A1 courseTerm courseTerm 1467375730 ph2 1467526101 ph2 学期 tinyint 1 7A3843C0-A542-4ABC-88C8-696D217C2E63 courseName courseName 1467375730 ph2 1467526105 ph2 课程名称 varchar(255) 255 1 51A85731-50DB-41E0-95BE-14786D8CC78F userId userId 1467545052 ph2 1467545068 ph2 int(20) 20 1 A5F51B53-C7D2-45B7-826A-0CA016B165E9 courseJoined courseJoined 1467375730 ph2 1467526120 ph2 上课人数 int AA889897-8A60-436C-AE09-8BEC84EFFB4E courseClass courseClass 1467375730 ph2 1467526126 ph2 上课班级 '' varchar(40) 40 D2E3D4F6-2B01-447A-94D4-B947D2463D06 courseSite courseSite 1467375730 ph2 1467526131 ph2 上课地点 '' varchar(40) 40 2EE7EB58-FCFF-4A6C-A6B9-F6371899404B courseSession courseSession 1467375730 ph2 1467526135 ph2 上课时间周二第1，2节 '' varchar(40) 40 78FE4D29-2BB1-432E-80A3-A9A700DEDBB0 courseType courseType 1467375730 ph2 1467526140 ph2 课程类型 '' varchar(40) 40 C0247555-6264-4D89-A649-CF030EADB3EE courseDepartmentId courseDepartmentId 1467375730 ph2 1467526155 ph2 开课实验室所属部门 int(20) 20 6107D569-826D-4760-9681-2E12BB3E5FE2 experimentName experimentName 1467375730 ph2 1467526162 ph2 实验项目名称 '' varchar(255) 255 0A8CA378-66C3-4DE6-B76F-E2FAD3A4A689 experimentPeriod experimentPeriod 1467375730 ph2 1467526172 ph2 实验项目学时 smallint F60F6929-F655-4AA0-8E08-3724AB1AC440 experimentType experimentType 1467375730 ph2 1467526186 ph2 实验项目类型 '' varchar(40) 40 12AA44BF-4413-4407-97CF-8F166FCD0F26 experimentLab experimentLab 1467375730 ph2 1467526195 ph2 开课实验室 '' varchar(40) 40 85A04427-A374-4593-884E-ED6E30A4E208 ctime ctime 1467465283 ph2 1467465297 ph2 datetime 069E125A-73A6-4FD4-821B-0F2184B5B2F3 mtime mtime 1467465283 ph2 1467465297 ph2 datetime F9554306-C07A-4677-A6D7-E628CFC96FEB deleted deleted 1467465283 ph2 1467526205 ph2 0 tinyint F57835DB-4069-49D4-AB39-E6FA6065DE9C Key_1 Key_1 1467448338 ph2 1467448343 ph2 3AEC1A74-9849-41A1-8E41-F248575E8078 教师听课次数表 dd_user_listened 1467375730 ph2 1467546019 ph2 教师的最大听课次数被更改过记录在这里；若没有，使用当年学期的默认配置<配置表> ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='教师听课次数表//教师的最大听课次数被更改过记录在这里若没有，使用当年学期的默认配置<配置表>' CC1935B0-D51D-402A-8148-2AA1B3033CAA listenedId listenedId 1467375730 ph2 1467540190 ph2 id int(20) 20 1 1 85D50E70-07B3-4237-9AC9-A0A170D9F527 listenedYear listenedYear 1467375730 ph2 1467524556 ph2 学年 smallint 1 25C7A9CD-05B4-45E3-A549-CD69BB5A59C3 listenedTerm listenedTerm 1467375730 ph2 1467524560 ph2 学期 tinyint 1 63B60916-0EE6-49D3-B7CB-9985F249485B userId userId 1467545970 ph2 1467545989 ph2 int(20) 20 1 2F4588BA-A5E8-4FD3-B49C-81318318DB61 theoryListened theoryListened 1467375730 ph2 1467524597 ph2 理论课已听次数 0 int BB72D501-4BBB-4AE2-AFA7-F3063A3B8F8D theoryMaxListened theoryMaxListened 1467375730 ph2 1467524605 ph2 理论课最大听课次数 0 int A665AC19-C66E-47EA-8C61-A0B07118702F experimentListened experimentListened 1467375730 ph2 1467524614 ph2 实验课已听次数 0 int 481C3AC3-BD75-4CB8-9D23-8BB0EF5A441F experimentMaxListened experimentMaxListened 1467375730 ph2 1467524618 ph2 实验课最大听课次数 0 int ED8097B7-8AC6-4B23-B8B1-3DD0B8F5504E ctime ctime 1467464801 ph2 1467464857 ph2 datetime CE0D6A35-802E-42DF-AFE8-50DC9FA4DC3F mtime mtime 1467464801 ph2 1467464857 ph2 datetime CE8DF37A-6994-4057-BE82-E15064B16D51 deleted deleted 1467464801 ph2 1467524633 ph2 0 tinyint C8965E51-7D09-4CD6-8753-C98130F03A5F Key_1 Key_1 1467447401 ph2 1467447643 ph2 8E4FF809-BE09-4E37-8CD2-EA5002F734BD 听课安排表-理论课 dd_schedule_theory 1467375730 ph2 1467545885 ph2 听课安排表(理论课) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='听课安排表(理论课)' E70245B3-69C2-4844-96CC-BF215B9FB2D0 scheduleId scheduleId 1467375730 ph2 1467540190 ph2 安排id int(20) 20 1 1 5A29CE4C-ABA6-47DD-8617-1C7A8A77788D scheduleYear scheduleYear 1467375730 ph2 1467526311 ph2 学年 smallint 1 2696455C-EABB-476E-9A2B-6D6C307885A7 scheduleTerm scheduleTerm 1467375730 ph2 1467526316 ph2 学期 tinyint 1 1104E497-32A5-4F75-A9C6-E75D7A998B3C userId userId 1467545868 ph2 1467545885 ph2 int(20) 20 1 9046C15D-C9A4-41B0-A575-E413FBC69CCC courseId courseId 1467375730 ph2 1467526337 ph2 所听课程id int(20) 20 1 B71549EA-1794-4D22-A869-5C0876AEFB56 scheduleStatus scheduleStatus 1467375730 ph2 1467526341 ph2 分配状态 tinyint 1 986CE431-D45B-48CF-9AC0-27267F06F328 ctime ctime 1467465268 ph2 1467465281 ph2 datetime F704219C-B68D-490D-A137-CDF5D042ABE2 mtime mtime 1467465268 ph2 1467465281 ph2 datetime 98C81002-2918-4B56-ADB7-2515B0BEFC16 deleted deleted 1467465268 ph2 1467526347 ph2 0 tinyint 59D97655-9AA9-4181-AA9A-A8FE92C95E5A Key_1 Key_1 1467448452 ph2 1467448548 ph2 14842FA6-F5B8-4508-8D78-7450D82FCE8E 听课安排表-实验课 dd_schedule_experiment 1467375730 ph2 1467545816 ph2 听课安排表(实验课) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='听课安排表(实验课)' 196ECC93-F777-4055-8ADB-5E53F5AA56A3 scheduleId scheduleId 1467375730 ph2 1467540190 ph2 安排id int(20) 20 1 1 36E02449-9A35-43D9-9DEB-E9A46DB9CCD6 scheduleYear scheduleYear 1467375730 ph2 1467526434 ph2 学年 smallint 1 2AFE77C6-C7C2-44F5-9574-339C56B5A020 scheduleTerm scheduleTerm 1467375730 ph2 1467526437 ph2 学期 tinyint 1 4DD9FE49-4C85-446D-82E8-424B03269A5B userId userId 1467545749 ph2 1467545816 ph2 int(20) 20 1 B64E592F-7142-41E9-A729-878AE589DD80 courseId courseId 1467375730 ph2 1467526456 ph2 所听课程id int(20) 20 1 151DFEF9-CC3C-4B4F-9674-FBE633DF7ACB scheduleStatus scheduleStatus 1467375730 ph2 1467526461 ph2 分配状态 0 tinyint 1 E4B313AE-18CA-4937-896F-90E750FD6071 ctime ctime 1467465345 ph2 1467465360 ph2 datetime 05043804-4900-43D1-9274-BA347DF5DDDD mtime mtime 1467465345 ph2 1467465360 ph2 datetime B4E2C3AA-8472-4DD3-9D8C-BF3AE891EC06 deleted deleted 1467465345 ph2 1467526465 ph2 0 tinyint C855C65F-3649-4C9B-9B73-624326763913 Key_1 Key_1 1467448560 ph2 1467448646 ph2 B0D47677-FEDB-4F65-A5D5-52F18253AEF0 督导评分表-理论课 dd_evaluate_theory 1467375730 ph2 1467545718 ph2 督导评分表(理论课) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='督导评分表(理论课)' 8E9011FD-3378-45DB-8B10-19B6D8A68A1B evalId evalId 1467375730 ph2 1467540190 ph2 评分id int(20) 20 1 1 32C0EBDC-B293-4BB5-A81E-71DF8F0FD761 evalYear evalYear 1467375730 ph2 1467527296 ph2 学年 smallint 1 8A80830E-19D9-4C40-AE6C-D946CE431A9E evalTerm evalTerm 1467375730 ph2 1467527301 ph2 学期 tinyint 1 EF5F039F-B284-41F7-B9A7-B8318C9DA5F4 courseId courseId 1467375730 ph2 1467527304 ph2 课程id int(20) 20 1 F2ED9B17-E0E0-46DB-BB73-015103ACAA14 teacherId teacherId 1467545601 ph2 1467545688 ph2 int(20) 20 1 792062AE-0DE6-435B-8F1E-C4738F3158B6 evalStatus evalStatus 1467375730 ph2 1467527319 ph2 状态 0 tinyint 1 5FD57647-42B4-4A1B-8B9C-52ED3406B75C appraiserId appraiserId 1467545601 ph2 1467545705 ph2 int(20) 20 1 E8595C43-14E4-4044-968B-9A3F03D01CAB evaluationId evaluationId 1467375730 ph2 1467527337 ph2 教学质量评价表id int(20) 20 1 8D8E9E69-51E3-47BE-BA20-D2F660978870 ctime ctime 1467465366 ph2 1467526500 ph2 datetime 1 0C4902E7-D011-4028-8FA6-06F5C34E43AC mtime mtime 1467465366 ph2 1467465379 ph2 datetime ADBC9A3F-2C14-4969-8466-EB39C6A2BA9D deleted deleted 1467465366 ph2 1467526515 ph2 0 tinyint B955CC79-1BED-48A1-AA99-9E2DE631F1F7 Key_1 Key_1 1467449211 ph2 1467449405 ph2 CEC5DF79-C0BE-414F-AD0F-C2AE137F66F2 督导评分表-实验课 dd_evaluate_experiment 1467375730 ph2 1467545510 ph2 督导评分表-实验课 dd_evaluate_experiment ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='督导评分表(实验课)' 62FD30C3-08EA-45FD-8D0D-8D3D7D7EEE9D evalId evalId 1467375730 ph2 1467540190 ph2 评分id int(20) 20 1 1 72F6D172-02F8-47EF-B21A-FE8174075A6C evalYear evalYear 1467375730 ph2 1467527388 ph2 学年 smallint 1 55098406-73CA-4E1D-8E00-2A3EAB3F7E12 evalTerm evalTerm 1467375730 ph2 1467527391 ph2 学期 tinyint 1 A880DE4F-B135-4190-A17C-B5BA4691B2A9 courseId courseId 1467375730 ph2 1467527395 ph2 课程id int(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,102={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,0= {B314652C-DD43-4F81-8524-6F97A1BAACBA},Collate,0= 2894F364-681E-4489-89EA-0BB6B0528CA7 teacherId teacherId 1467545375 ph2 1467545491 ph2 int(20) 20 1 D7BC2BCF-DC2B-4AB1-B4E9-70BD6B5740E4 evalStatus evalStatus 1467375730 ph2 1467527436 ph2 状态 0 tinyint 1 F63B71C8-70D1-480C-A6A4-51DEA2F88CC2 appraiserId appraiserId 1467545375 ph2 1467545510 ph2 int(20) 20 1 C7097967-38E6-44A3-8550-CD193D3D5BC6 evaluationId evaluationId 1467375730 ph2 1467527428 ph2 教学质量评价表id int(20) 20 1AD80E7E-8B14-41FB-AF49-619CC1151515 ctime ctime 1467465380 ph2 1467527376 ph2 datetime 1 93C2DC3A-503C-4F36-8DCE-0E5CBB068D0C mtime mtime 1467465380 ph2 1467465395 ph2 datetime C5807FAC-6212-454B-BFD5-5914AB20A2B0 deleted deleted 1467465380 ph2 1467527442 ph2 0 tinyint E64979B1-1269-43DD-92EB-A186CE0F8B36 Key_1 Key_1 1467449621 ph2 1467449624 ph2 C77CB005-CE92-4EDB-927C-339A81D54CCC 教学质量评价表-理论课 dd_evaluation_theory 1467375730 ph2 1467527536 ph2 教学质量评价表(理论课) 具体要保存什么字段自行添加 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='教学质量评价表(理论课)' 3B5013C0-60D5-4B6A-BCB4-97A7D898FD3E evaluationId evaluationId 1467375730 ph2 1467540190 ph2 评价表id int(20) 20 1 1 C81EECB4-3B29-46FF-AF64-88B261F51987 evaluationData evaluationData 1467375730 ph2 1467527478 ph2 各种数据 varchar(255) 255 E631EAEE-3079-49A9-8B32-8DDC878EFBC2 ctime ctime 1467527503 ph2 1467528153 ph2 datetime 35A733F8-D5D6-47DD-B0E5-48BBE754622E mtime mtime 1467527503 ph2 1467527536 ph2 datetime 5FEF939F-88AF-4ECB-A0BA-5F9C30AB9AE1 deleted deleted 1467527503 ph2 1467527554 ph2 0 tinyint ACFF414A-FC92-4BFB-9C7D-A4B545F693C7 Key_1 Key_1 1467450476 ph2 1467450481 ph2 CF0C0D13-A567-4034-B2E0-EF1BA8B7987C 教学质量评价表-实验课 dd_evaluation_experiment 1467375730 ph2 1467527807 ph2 教学质量评价表(实验课) 具体要保存什么字段自行添加 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='教学质量评价表(实验课)' F218DD46-136B-4BC6-9664-4AD7E6095E39 evaluationId evaluationId 1467375730 ph2 1467540190 ph2 评价表id int(20) 20 1 1 1046E7FE-3A40-4A2A-BC69-3A791E2F8DA4 evaluationData evaluationData 1467375730 ph2 1467527823 ph2 各种数据 varchar(255) 255 B778B649-3CEA-4DA6-843D-6B9DFAD5985D ctime ctime 1467527784 ph2 1467528161 ph2 datetime D899BBF8-E8EF-47D7-8E03-775D66DB33DE mtime mtime 1467527784 ph2 1467527807 ph2 datetime 74E46637-27AD-4F18-9359-0C07C3A426C2 deleted deleted 1467527784 ph2 1467527829 ph2 0 tinyint 28903CD7-861A-434C-B6F4-D9381111B9EF Key_1 Key_1 1467450584 ph2 1467450628 ph2 852F54F6-D0DD-479A-B638-DEF7299D216D 督导简报权限表 dd_briefing_competence 1467375730 ph2 1467464794 ph2 督导简报权限表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='督导简报权限表' 4A41445F-9077-4FB3-BC78-1002CD693A21 briefingCompetenceId briefingCompetenceId 1467375730 ph2 1467540190 ph2 权限id int(20) 20 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,159={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,5=false {9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,0= {B314652C-DD43-4F81-8524-6F97A1BAACBA},Collate,0= F1790B0E-20C7-47BC-BBA5-1ECD234BEE8A userId userId 1467375730 ph2 1467524390 ph2 教师id int(20) 20 1 9A93D2C9-0326-4C7B-85BF-2B4529B13F88 ctime ctime 1467464718 ph2 1467464794 ph2 datetime 013EF627-0D1F-468A-938C-811BBFC455FC mtime mtime 1467464718 ph2 1467464794 ph2 datetime 65F265E2-2499-4357-9EFC-9038751035C9 deleted deleted 1467464718 ph2 1467524375 ph2 0 tinyint C33E69AD-4455-48C7-8CAF-B9219271E556 Key_1 Key_1 1467450799 ph2 1467450829 ph2 4E9AA243-EF8A-4F98-BB92-73401C26EC61 简报表 dd_briefing 1467375730 ph2 1467464940 ph2 简报表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='简报表' 83D35B58-AE8C-4F83-AD06-4286F60ED46C briefingId briefingId 1467375730 ph2 1467540190 ph2 简报id int(20) 20 1 1 863B7548-AAE3-4069-A21C-992DC42EE981 briefingYear briefingYear 1467375730 ph2 1467524693 ph2 学年 smallint 1 A27BD699-F130-4C03-BFD7-CE4A1ECF322F briefingTerm briefingTerm 1467375730 ph2 1467524699 ph2 期数 tinyint 1 F6110F0E-12B6-4B78-9633-CF3BCB9B7C5F uploadId uploadId 1467375730 ph2 1467524704 ph2 上传id int(20) 20 1 D5708BCB-4B10-4898-B742-AC875A75E1D2 ctime ctime 1467464923 ph2 1467464940 ph2 datetime 12896846-5B5A-469C-9F1B-2104AB3EBD53 mtime mtime 1467464923 ph2 1467464940 ph2 datetime 7CED325A-7EB8-4922-B5AD-94B27425C15F deleted deleted 1467464923 ph2 1467524717 ph2 tinyint EEA4DB44-C6F0-458D-B5A6-A6537B521941 Key_1 Key_1 1467451242 ph2 1467451277 ph2 24AE74F0-E185-4EF5-9FD6-0B6D6E4AE42E 总结表 dd_summary 1467375730 ph2 1467464971 ph2 总结表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='总结表' 0B9C98C9-ACE2-4583-ADB7-13BB3BF019E2 summaryId summaryId 1467375730 ph2 1467540190 ph2 总结id int(20) 20 1 1 33EBC21E-4A47-40AC-ADB4-E1C77F88765D summaryYear summaryYear 1467375730 ph2 1467524763 ph2 学年 smallint 1 6F6F073F-E49E-4FA4-BDDB-57BCAA92FB58 summaryNO summaryNO 1467375730 ph2 1467524767 ph2 期数 tinyint 1 C7D2E08F-FDD2-4643-ADC8-E957BAE10FD0 appraiserGroupId appraiserGroupId 1467375730 ph2 1467524782 ph2 总结所属督导组id int(20) 20 B0B98B55-8C48-4AAC-A25F-B5701EE1E53B summaryStatus summaryStatus 1467375730 ph2 1467524795 ph2 总结状态 0 tinyint C53F44CB-4A63-436E-AE90-4464AD42A1EC uploadId uploadId 1467375730 ph2 1467524801 ph2 上传id int(20) 20 466BD3C2-5F09-4714-8D7C-AEB87BAB5434 ctime ctime 1467464941 ph2 1467464971 ph2 datetime DD499933-B68F-4323-8EA8-E420B2427FF8 mtime mtime 1467464941 ph2 1467464971 ph2 datetime A47AE2B3-6159-4D68-AF38-67790DE6DF4A deleted deleted 1467464941 ph2 1467524808 ph2 0 tinyint 6413C3CF-4488-43F3-BE0D-A1FD7FDF8F57 Key_1 Key_1 1467451353 ph2 1467451415 ph2 FE4B1EA9-21AA-4FD1-B508-8FEB11D2A652 督导组分组表 dd_appraiser_group 1467375730 ph2 1467465002 ph2 督导组分组表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='督导组分组表' A3851915-60B2-4682-8A4C-B10B0C101384 appraiserGroupId appraiserGroupId 1467375730 ph2 1467540190 ph2 督导组id int(20) 20 1 1 7662A007-1B39-4EF3-8638-8583FAC10DB2 appraiserGroupName appraiserGroupName 1467375730 ph2 1467524861 ph2 督导组名称 varchar(255) 255 1 0A9E932F-62E5-4848-9FE8-A16C0EF8E8FC leaderId leaderId 1467375730 ph2 1467524875 ph2 督导组组长id int(20) 20 40B8DFC3-B437-42D0-8442-8DD7D60D9374 ctime ctime 1467464989 ph2 1467465002 ph2 datetime 8F457AE5-A23D-4135-B521-853CE11B6265 mtime mtime 1467464989 ph2 1467465002 ph2 datetime 217904DD-9A5B-49A4-A5C1-3A6B83329CAE deleted deleted 1467464989 ph2 1467524842 ph2 tinyint 917665AC-77B2-4505-96F3-A9D3DD814BC1 Key_1 Key_1 1467451456 ph2 1467451496 ph2 E1EE9707-0B8B-44E1-9983-679F0251A777 部门表 dd_department 1467375730 ph2 1467466879 ph2 记录部门（导入课表时要更新没有的部门）学院人数管理 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门表//记录部门（导入课表时要更新没有的部门）学院人数管理' {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,58={31D066BE-2F61-4B4D-B7B4-230D38F22B99},Temporary,5=false 52644602-813E-46C9-8126-13498F3991BD departmentId departmentId 1467375730 ph2 1467540190 ph2 部门id int(20) 20 1 1 2DAC9ABB-2911-4004-A784-4376804C94E1 departmentName departmentName 1467375730 ph2 1467525563 ph2 部门名称 varchar(60) 60 1 CAF2FC55-F801-43FC-BD79-D950FBB700C2 departmentPeopleNum departmentPeopleNum 1467375730 ph2 1467444294 ph2 部门人数 0 int 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,102={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,0= {B314652C-DD43-4F81-8524-6F97A1BAACBA},Collate,0= 3E74D119-7F63-4F75-A547-E05C657E31DB departmentGroupId departmentGroupId 1467375730 ph2 1467525578 ph2 部门所属督导组 int(20) 20 8058DD01-3D8A-4D71-84B3-4E9EB3FF0408 departmentStatus departmentStatus 1467375730 ph2 1467525583 ph2 部门状态 0 tinyint 1 536CBFEA-31DB-49B6-8163-2285BC6F132E ctime ctime 1467465176 ph2 1467465190 ph2 datetime F67AC9C4-5B74-4A0E-9304-2A18D8DF301F mtime mtime 1467465176 ph2 1467465190 ph2 datetime 2A5C86BA-1263-4624-84B0-88411FEE0403 deleted deleted 1467465176 ph2 1467525603 ph2 0 tinyint DFA0E2D4-7A20-4AE5-B8F3-5F057E68986A Key_1 Key_1 1467443828 ph2 1467443914 ph2 A1526453-6187-4872-A51C-DB1608DDA100 用户角色表 dd_role 1467375730 ph2 1467465104 ph2 用户角色关系表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色关系表//系统用户拥有并且显示的角色（用户跟角色类型多对多）' 319F3640-3B3E-49A9-9711-4D0F57B62BBA roleId roleId 1467375730 ph2 1467540190 ph2 int(20) 20 1 1 0729A5A9-B0B9-4150-AAAE-0D8538828447 userId userId 1467375730 ph2 1467524937 ph2 用户id int(20) 20 1 C133D710-D081-4DF2-96C3-49CA22D6C9BE roleTypeId roleTypeId 1467375730 ph2 1467524967 ph2 用户角色类型id int(20) 20 1 CCE4CD01-3B9C-4A13-9B39-9542CCCE1FAD ctime ctime 1467465085 ph2 1467465104 ph2 datetime A43FF3E4-905D-4362-A5CB-7EAF7CA48BBD mtime mtime 1467465085 ph2 1467465104 ph2 datetime F6248BA9-CCC9-416F-906D-1F050E55F071 deleted deleted 1467465085 ph2 1467524978 ph2 0 tinyint 04ACA40B-1EE7-461E-B239-9026CBDD3005 Key_1 Key_1 1467451588 ph2 1467451653 ph2 BCFEFB53-C30F-4ACB-91AF-1CBA092DBE7A 听课申请表 dd_apply_listened 1467375730 ph2 1467544898 ph2 听课申请表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='听课申请表' E8B140F0-527A-4551-9CA7-11F9A776AEDF applyId applyId 1467375730 ph2 1467540190 ph2 听课申请id int(20) 20 1 1 8D2054B0-8C77-4588-BDA7-FEB775E7981A applyYear applyYear 1467375730 ph2 1467525319 ph2 学年 smallint 1 8726366D-594A-4CFE-8C86-8C44F8ECE7EE userId userId 1467544852 ph2 1467544871 ph2 int(20) 20 1 57A815C0-CB4F-485D-9C0B-91C82619AA8D courseTerm courseTerm 1467375730 ph2 1467525362 ph2 是否开课开学的学期 char(20) 20 1 39EA494F-09C4-4A27-965A-1E90852D8CEE applyType applyType 1467375730 ph2 1467525375 ph2 申请课程类型//theory; experiment; theory,experiment; tinyint 1 FD34A204-F944-4421-A492-CD7C0AC48403 applyTheoryTypeId applyTheoryTypeId 1467375730 ph2 1467525380 ph2 理论课听课类型id int(20) 20 D2050606-876E-4039-8496-60A0952D826E applyExperimentTypeId applyExperimentTypeId 1467375730 ph2 1467525384 ph2 实验课听课类型id int(20) 20 E14D5326-4441-4FF0-9829-D317EA9D5D24 applyTheoryJobTitleId applyTheoryJobTitleId 1467375730 ph2 1467525391 ph2 理论课申报职称id int(20) 20 04F3C4D7-9DC6-4B25-9BBF-FCE97223C36E applyExperimentJobTitleId applyExperimentJobTitleId 1467375730 ph2 1467525397 ph2 实验课申报职称id int(20) 20 918E2E75-FC2D-4086-BCBF-19D13EA2D2B4 applyStatus applyStatus 1467375730 ph2 1467525410 ph2 申请状态 0 tinyint 1 0C04CA62-32A2-41E7-8924-24F6638293DE ctime ctime 1467465144 ph2 1467465159 ph2 datetime 908F0E09-8B64-44B0-90D6-A8729582BF1D mtime mtime 1467465144 ph2 1467465159 ph2 datetime 938F5B15-23C3-4DE3-93F1-C7DBEC85869A deleted deleted 1467465144 ph2 1467525417 ph2 0 tinyint 5384200B-C10C-4255-85C7-3DBCC4B6B50D Key_1 Key_1 1467452002 ph2 1467452009 ph2 B22262F1-B52C-4BDD-A50F-DCEF6C94F71E dd_system_conf dd_system_conf 1467375730 ph2 1467465023 ph2 系统配置表，用于存放一些配置信息 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统配置表' 9FBEC4BB-7C6C-4DC3-8F24-63F473749A41 confId confId 1467375730 ph2 1467540190 ph2 int(20) 20 1 1 68F41D88-DA29-491B-8A6F-87A30B28FE1F pid pid 1467375730 ph2 1467523984 ph2 int(20) 20 1 E22AB0F6-079B-4E19-96C3-BD7D5743B58E k k 1467375730 ph2 1467523997 ph2 '' varchar(255) 255 1 84E36EBC-B2F0-4832-8CC8-13B90FDAC8F2 value value 1467375730 ph2 1467524105 ph2 '' varchar(255) 255 1 312773FF-1160-46C7-8508-896AFFABA3CA extra extra 1467375730 ph2 1467524116 ph2 额外，自行解析 '' varchar(255) 255 22D6E51F-7D73-44D7-9E64-3E916AD8FC93 status status 1467375730 ph2 1467524231 ph2 状态 0 tinyint A53560A4-0EBD-4AC5-957D-1EAA97B490C1 ctime ctime 1467465007 ph2 1467465023 ph2 datetime 47F32060-16F0-4B6D-8127-DCCCCCA826CB mtime mtime 1467465007 ph2 1467465023 ph2 datetime D3CB0AB5-419C-4FA6-B1B1-C0B14B427EAD deleted deleted 1467465007 ph2 1467524302 ph2 0 tinyint 15EC3FC6-1B09-4176-8AB2-1EE31B02154C Key_1 Key_1 1467442001 ph2 1467442607 ph2 5DA66837-6C4C-4B91-BCB3-05BE5C93F3FD 推优审核表 dd_audit_superiority 1467375730 ph2 1467544962 ph2 推优审核表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='推优审核表//符合推优条件的人员名单这个表在开启推优后，系统自动检索符合条件的人员生成评分如果在推优期间，数据发生变动，请关闭推优重新开启推优使得系统刷新数据' 980D8BB3-0A08-4365-9432-5FC8F710BD41 auditId auditId 1467375730 ph2 1467540190 ph2 审核id int(20) 20 1 1 15DEA73B-5CF1-4954-84F9-9D1AB2947D9E auditYear auditYear 1467375730 ph2 1467525163 ph2 学年 smallint 1 3AED5CFF-B9CE-408A-91B7-3E267AD3FA9F userId userId 1467544939 ph2 1467544953 ph2 int(20) 20 1 C13A59DA-52BE-468A-8D8A-BE498B8BF1C8 applyGrade applyGrade 1467375730 ph2 1467547133 ph2 申报等级 '' char(20) 20 1 7BD87C91-16FD-4FB0-A639-8C1D28475931 appraiserEvalScore appraiserEvalScore 1467375730 ph2 1467525221 ph2 督导评分 0 int 1 FB6908EE-F49E-4598-A874-FCD0C2BDE9E0 stuEvalScore stuEvalScore 1467375730 ph2 1467525227 ph2 学生评分 0 int 1 CE178616-572B-4A13-AAFE-1AE571D9EE52 courseCountOwn courseCountOwn 1467375730 ph2 1467525234 ph2 独立承担课程门次 0 smallint 1 FFF7AB89-E580-4B58-BD05-79CF24E22163 planPeriod planPeriod 1467375730 ph2 1467525239 ph2 累计计划学时 0 smallint 1 DAF2A316-D372-41FA-B170-16B31DB11100 undergraduateWorkload undergraduateWorkload 1467375730 ph2 1467525245 ph2 本科基本教学工作量 0 smallint 1 9DB6238B-F0F9-4484-A85A-358B2EB8C553 PostgraduateWorkload PostgraduateWorkload 1467375730 ph2 1467525250 ph2 研究生基本教学工作量 0 smallint 1 DD1F90A1-8689-4F0A-BFA8-CD2A22375905 auditStatus auditStatus 1467375730 ph2 1467525258 ph2 审核状态 0 tinyint 1 3ADCF16C-6AF0-475C-86AA-91B5D80F231D ctime ctime 1467465115 ph2 1467465140 ph2 datetime 4341F717-0D76-418F-AB62-4F6CE4075AE6 mtime mtime 1467465115 ph2 1467465140 ph2 datetime E5DB98A1-07B8-440A-A5E0-A920EE30EDF9 deleted deleted 1467465115 ph2 1467525146 ph2 tinyint FD298D03-7B5B-4A6D-80DD-2EA4E55F0A9C Key_1 Key_1 1467452202 ph2 1467452297 ph2 BA0E443E-6286-4BD1-8054-D7E18637657A 事故表 dd_accident 1467375730 ph2 1467544833 ph2 事故表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='事故表' 26FA0008-BF04-49B7-86A6-9D1224B771A4 accidentID accidentID 1467375730 ph2 1467540190 ph2 事故id int(20) 20 1 1 1767946F-836A-4E94-AFE8-29C1CC297803 accidentYear accidentYear 1467375730 ph2 1467526038 ph2 学年 smallint 1 630409DB-3A97-4D32-815F-D92878B5DCF9 accidentTerm accidentTerm 1467375730 ph2 1467526042 ph2 学期 tinyint 1 F669748D-8A8D-4225-956A-C0D865669FCF userId userId 1467541248 ph2 1467541298 ph2 int(20) 20 1 6DCA3F28-2BAF-490B-8D8A-971E551509B4 accidentContent accidentContent 1467375730 ph2 1467526063 ph2 事故内容 varchar(127) 127 1 49C96009-4CA3-4211-A574-5F013AE1E06F ctime ctime 1467465299 ph2 1467465322 ph2 datetime A46E0CD3-FA21-4EA4-901E-21A790693149 mtime mtime 1467465299 ph2 1467465322 ph2 datetime ABB3699E-BB82-4307-BE67-611175977627 deleted deleted 1467465299 ph2 1467526069 ph2 0 tinyint AB637CB6-02CA-4D3C-AA27-2D05AB0563BB Key_1 Key_1 1467452545 ph2 1467452556 ph2 95984A21-51CC-4BB7-A652-897DAA7E7D95 上传文件表 dd_upload 1467375730 ph2 1467464921 ph2 上传文件表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='上传文件表' 62F86F1D-F31F-4B16-9786-CEBFCF021CAC uploadId uploadId 1467375730 ph2 1467540190 ph2 上传id int(20) 20 1 1 AD132EE3-7F4D-419C-BE6C-324F41951CA8 uploadName uploadName 1467375730 ph2 1467524456 ph2 文件名 varchar(255) 255 1 188342BB-82DA-4F11-948F-B5813BDD91DB uploadTime uploadTime 1467375730 ph2 1467524468 ph2 上传时间 datetime 1 AD4838A4-CD28-4FCD-AEDE-458D9D2EF2A3 uploadPath uploadPath 1467375730 ph2 1467524478 ph2 文件路径 varchar(511) 511 1 A92CA76E-29BA-450B-BF63-0A7776D8A33F userId userId 1467375730 ph2 1467524484 ph2 上传者id int(20) 20 DDBE59CE-B0EF-4395-93F7-21C791B528B3 ctime ctime 1467464896 ph2 1467464921 ph2 datetime 90B48A95-A153-49DF-9907-51ECD89E7ED6 mtime mtime 1467464896 ph2 1467464921 ph2 datetime 8C29C614-C3A7-42E4-AA7F-E6F19C4B9067 deleted deleted 1467464896 ph2 1467524497 ph2 0 tinyint 25863F90-E38D-4848-8605-4BBC5B1917BE Key_1 Key_1 1467451068 ph2 1467451113 ph2 8F392D2A-4F56-4436-8869-2C3BE3CE7A28 学生网评表 dd_student_evaluation 1467375730 ph2 1467546094 ph2 学生网评表具体数据自行添加 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学生网评表' C69FCA47-51A1-40F9-8E43-C35EC9A901FF stuEvalId stuEvalId 1467375730 ph2 1467540190 ph2 网评id int(20) 20 1 1 9457D372-5550-4DD5-9570-B2B5BC709899 userId userId 1467546075 ph2 1467546094 ph2 int(20) 20 1 96897D9C-74DF-4E8D-B2B0-E29C26D55E87 stuEvalData stuEvalData 1467375730 ph2 1467525019 ph2 各种数据 varchar(255) 255 0E213AF9-7005-426C-8A2C-F239CF9C7E9F ctime ctime 1467464858 ph2 1467464876 ph2 datetime C5717230-DD53-4376-BEE0-29CC94C97C0F mtime mtime 1467464858 ph2 1467464876 ph2 datetime 6390B02B-D2C8-4C87-AD06-D45D4EBF473F deleted deleted 1467464858 ph2 1467525029 ph2 0 tinyint 1B425FCF-7DF7-4B75-8563-6C113A237873 Key_1 Key_1 1467452654 ph2 1467452688 ph2 1E8F04B8-82DA-4AF3-A7BD-D5D40744FD98 督导数据库信息表 dd_database 1467375730 ph2 1467464894 ph2 督导数据库信息表 ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='督导数据库信息' D23AEF3A-429C-4756-8AB8-324FFD6BA1DB databaseNum databaseNum 1467375730 ph2 1467528328 ph2 0.0.1 varchar(255) 255 0DE064A9-5A59-45A0-ADC4-98899734D96E databaseInfo databaseInfo 1467375730 ph2 1467528333 ph2 varchar(255) 255 0A045C6D-BF4F-4F37-A9E2-9051DB4DCCEF ctime ctime 1467464878 ph2 1467464894 ph2 datetime F3B65E18-FC44-4779-8AE1-4FD339F0DA87 mtime mtime 1467464878 ph2 1467464894 ph2 datetime 33C9B70A-A9CD-465D-BE66-339936A3B9F5 deleted deleted 1467464878 ph2 1467525052 ph2 0 tinyint 11CC56F4-A894-4F13-95E0-269460D5F5D9 编制类型表 dd_view_establishmentId 1467452907 ph2 1467467542 ph2 编制类型表 select confId as establishmentId, value as establishmentName, pid, k, extra, status from dd_system_conf where pid in (select confId from dd_system_conf where k = 'root' and value = 'view_establishment') ; select [{9FBEC4BB-7C6C-4DC3-8F24-63F473749A41}=confId] as establishmentId, [{84E36EBC-B2F0-4832-8CC8-13B90FDAC8F2}=value] as establishmentName, [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid], [{E22AB0F6-079B-4E19-96C3-BD7D5743B58E}=k], [{312773FF-1160-46C7-8508-896AFFABA3CA}=extra], [{22D6E51F-7D73-44D7-9E64-3E916AD8FC93}=status] from [{B22262F1-B52C-4BDD-A50F-DCEF6C94F71E}=dd_system_conf] where [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid] in (select confId from dd_system_conf where k = 'root' and value = 'view_establishment') ; C9FE25A7-C4BC-4033-B1D3-ABF8F4A08B7E establishmentId establishmentId 1467453138 ph2 1467462312 ph2 int(20) 20 establishmentId establishmentId 47C14D63-E4E9-4180-9C4F-2CADDE805CC6 establishmentName establishmentName 1467453138 ph2 1467462312 ph2 varchar(255) 255 establishmentName establishmentName 736A4FA3-C10A-4778-B28D-B4D4F2CC96F4 pid pid 1467460759 ph2 1467460804 ph2 int(20) 20 BC27024E-CA48-49F5-85D9-B12957DB1BD9 k k 1467453138 ph2 1467460827 ph2 varchar(255) 255 08188186-D997-4480-B352-617A5A4BE82C extra extra 1467464361 ph2 1467464411 ph2 额外，自行解析 varchar(255) 255 700C61F6-1FB7-46F4-AE4E-C37751988572 status status 1467460513 ph2 1467460527 ph2 状态 tinyint 5975C4C4-30FD-4A29-A0C0-176736C1E027 行政职务表 dd_view_duties 1467460872 ph2 1467467553 ph2 行政职务表 select confId as dutiesId, value as dutiesName, pid, k, extra, status from dd_system_conf where pid in (select confId from dd_system_conf where k = 'root' and value = 'view_duties') ; select [{9FBEC4BB-7C6C-4DC3-8F24-63F473749A41}=confId] as dutiesId, [{84E36EBC-B2F0-4832-8CC8-13B90FDAC8F2}=value] as dutiesName, [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid], [{E22AB0F6-079B-4E19-96C3-BD7D5743B58E}=k], [{312773FF-1160-46C7-8508-896AFFABA3CA}=extra], [{22D6E51F-7D73-44D7-9E64-3E916AD8FC93}=status] from [{B22262F1-B52C-4BDD-A50F-DCEF6C94F71E}=dd_system_conf] where [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid] in (select confId from dd_system_conf where k = 'root' and value = 'view_duties') ; 0E7148C7-FBE1-41CB-849E-B4B0B93AD4AB dutiesId dutiesId 1467460879 ph2 1467462196 ph2 int(20) 20 dutiesId dutiesId 307626CC-3C22-47E7-BBAF-BAE3A55CCBCC dutiesName dutiesName 1467460879 ph2 1467462196 ph2 varchar(255) 255 dutiesName dutiesName 894B6092-5BF2-45E4-B183-DFB475BC9CCA pid pid 1467460879 ph2 1467460899 ph2 int(20) 20 C0155334-E5FD-49F5-9FAF-6A16069B8321 k k 1467460879 ph2 1467460899 ph2 varchar(255) 255 B4ADB8C7-6962-4984-B334-D83DFA8C7718 extra extra 1467460879 ph2 1467460899 ph2 额外，自行解析 varchar(255) 255 67A60EFD-DDA8-4B26-AA81-A68962FDE700 status status 1467460879 ph2 1467460899 ph2 状态 tinyint 6F883459-767A-4E3F-A96B-217B2D3FDB7A 申报职称类型表 dd_view_apply_job_title 1467460872 ph2 1467467567 ph2 申报职称类型表 select confId as applyJobTitleId, value as applyJobTitleName, pid, k, extra, status from dd_system_conf where pid in (select confId from dd_system_conf where k = 'root' and value = 'view_apply_job_title') ; select [{9FBEC4BB-7C6C-4DC3-8F24-63F473749A41}=confId] as applyJobTitleId, [{84E36EBC-B2F0-4832-8CC8-13B90FDAC8F2}=value] as applyJobTitleName, [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid], [{E22AB0F6-079B-4E19-96C3-BD7D5743B58E}=k], [{312773FF-1160-46C7-8508-896AFFABA3CA}=extra], [{22D6E51F-7D73-44D7-9E64-3E916AD8FC93}=status] from [{B22262F1-B52C-4BDD-A50F-DCEF6C94F71E}=dd_system_conf] where [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid] in (select confId from dd_system_conf where k = 'root' and value = 'view_apply_job_title') ; DBD74A44-43EB-49CA-BE5F-9598D662B712 applyJobTitleId applyJobTitleId 1467460879 ph2 1467462064 ph2 int(20) 20 applyJobTitleId applyJobTitleId 490DB5DD-23F2-4F4E-AB23-791949C3F0A1 applyJobTitleName applyJobTitleName 1467460879 ph2 1467462077 ph2 varchar(255) 255 applyJobTitleName applyJobTitleName BC6985DD-2EEF-4005-BB66-57C7EACEDF09 pid pid 1467460879 ph2 1467461678 ph2 int(20) 20 8B4D9AD7-C046-418D-A13C-C901683FCED2 k k 1467460879 ph2 1467461678 ph2 varchar(255) 255 604B97BA-A444-44FD-8DD8-E6C221F87079 extra extra 1467460879 ph2 1467461678 ph2 额外，自行解析 varchar(255) 255 2F8C3019-873D-4902-9ADB-B136AC4446D3 status status 1467460879 ph2 1467461678 ph2 状态 tinyint 48AB47D7-1034-4C0B-9E9A-3CDBBB8B2AAE 听课类型表 dd_view_listened_type 1467460872 ph2 1467467573 ph2 听课类型表 select confId as listenedId, value as listenedName, pid, k, extra, status from dd_system_conf where pid in (select confId from dd_system_conf where k = 'root' and value = 'view_listened_type') ; select [{9FBEC4BB-7C6C-4DC3-8F24-63F473749A41}=confId] as listenedId, [{84E36EBC-B2F0-4832-8CC8-13B90FDAC8F2}=value] as listenedName, [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid], [{E22AB0F6-079B-4E19-96C3-BD7D5743B58E}=k], [{312773FF-1160-46C7-8508-896AFFABA3CA}=extra], [{22D6E51F-7D73-44D7-9E64-3E916AD8FC93}=status] from [{B22262F1-B52C-4BDD-A50F-DCEF6C94F71E}=dd_system_conf] where [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid] in (select confId from dd_system_conf where k = 'root' and value = 'view_listened_type') ; 0699B0BA-862B-4860-8EF9-3701A3B5CEA1 listenedId listenedId 1467460879 ph2 1467462025 ph2 int(20) 20 listenedId listenedId FA0D2FCD-FC5E-4599-8D90-C31B0212C7EB listenedName listenedName 1467460879 ph2 1467464544 ph2 varchar(255) 255 listenedName 79F303DD-853D-48B6-BE1A-4DF3077618F5 pid pid 1467460879 ph2 1467461791 ph2 int(20) 20 21F32B72-FE14-4FC5-9394-90905800371B k k 1467460879 ph2 1467461791 ph2 varchar(255) 255 EDC9005E-797D-4544-BAFB-0267520C79A6 extra extra 1467460879 ph2 1467461791 ph2 额外，自行解析 varchar(255) 255 0024BA62-9C1E-47C9-A6A0-70056CD17527 status status 1467460879 ph2 1467461791 ph2 状态 tinyint 37C7D9EB-01F4-45D6-8C68-11BBAF4FB8A9 用户角色类型表 dd_view_roleType 1467460872 ph2 1467467581 ph2 用户角色类型表 select confId as roleId, value as roleName, pid, k, extra, status from dd_system_conf where pid in (select confId from dd_system_conf where k = 'root' and value = 'view_roleType') ; select [{9FBEC4BB-7C6C-4DC3-8F24-63F473749A41}=confId] as roleId, [{84E36EBC-B2F0-4832-8CC8-13B90FDAC8F2}=value] as roleName, [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid], [{E22AB0F6-079B-4E19-96C3-BD7D5743B58E}=k], [{312773FF-1160-46C7-8508-896AFFABA3CA}=extra], [{22D6E51F-7D73-44D7-9E64-3E916AD8FC93}=status] from [{B22262F1-B52C-4BDD-A50F-DCEF6C94F71E}=dd_system_conf] where [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid] in (select confId from dd_system_conf where k = 'root' and value = 'view_roleType') ; CF7FE029-2352-4699-A0D6-24B47573AA02 roleId roleId 1467460879 ph2 1467461969 ph2 int(20) 20 roleId roleId 93B2793F-9AD4-4B73-B320-222F797A3C7B roleName roleName 1467460879 ph2 1467464583 ph2 varchar(255) 255 roleName 2D307658-7A8E-4496-9A27-DF4B22A38E5C pid pid 1467460879 ph2 1467461863 ph2 int(20) 20 5AAC1E69-C8BB-4264-8562-1F53D209AA38 k k 1467460879 ph2 1467461863 ph2 varchar(255) 255 672DBE92-67B4-4B8B-9120-D74E6B439A53 extra extra 1467460879 ph2 1467461863 ph2 额外，自行解析 varchar(255) 255 8C3DF895-C73B-492B-8D22-245CECEB2ABB status status 1467460879 ph2 1467461863 ph2 状态 tinyint D2741B3A-442B-4379-B658-6574A1D1B281 行政职称表 dd_view_job_title 1467460872 ph2 1467467560 ph2 行政职称表 select confId as jobTitleId, value as jobTitleName, pid, k, extra, status from dd_system_conf where pid in (select confId from dd_system_conf where k = 'root' and value = 'view_job_title') ; select [{9FBEC4BB-7C6C-4DC3-8F24-63F473749A41}=confId] as jobTitleId, [{84E36EBC-B2F0-4832-8CC8-13B90FDAC8F2}=value] as jobTitleName, [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid], [{E22AB0F6-079B-4E19-96C3-BD7D5743B58E}=k], [{312773FF-1160-46C7-8508-896AFFABA3CA}=extra], [{22D6E51F-7D73-44D7-9E64-3E916AD8FC93}=status] from [{B22262F1-B52C-4BDD-A50F-DCEF6C94F71E}=dd_system_conf] where [{68F41D88-DA29-491B-8A6F-87A30B28FE1F}=pid] in (select confId from dd_system_conf where k = 'root' and value = 'view_job_title') ; 4C76CFE7-07F0-482F-A064-49551DEFCA2A jobTitleId jobTitleId 1467460879 ph2 1467463399 ph2 int(20) 20 jobTitleId jobTitleId 95FB78B2-046D-4C6E-B6EB-2AF86E475F6F jobTitleName jobTitleName 1467460879 ph2 1467462273 ph2 varchar(255) 255 jobTitleName jobTitleName 57E75B5D-C7D7-47C1-903A-55FDCD738746 pid pid 1467460879 ph2 1467462209 ph2 int(20) 20 111EE213-D5F9-496E-9116-CFFC5BD815E9 k k 1467460879 ph2 1467462209 ph2 varchar(255) 255 D88DCE79-CA27-43AD-AC55-96A81C6C0FB4 extra extra 1467460879 ph2 1467462209 ph2 额外，自行解析 varchar(255) 255 4F156263-701E-4DBF-A00C-BAB88D34C0EE status status 1467460879 ph2 1467462209 ph2 状态 tinyint 918C4697-02BE-47DD-8150-74B6638BF16A Reference_1 Reference_1 1467442352 ph2 1467442607 ph2 0..* 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,58={208169ED-E14F-4B04-93BD-2FE48112A769},ReferenceMatch,0= C9DA2793-C148-4178-9EA8-3E836C80437A 1467442352 ph2 1467442570 ph2 66DDC37B-B59A-4057-BB21-081C1FD3AACA Reference_2 Reference_2 1467442669 ph2 1467443146 ph2 0..* 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,58={208169ED-E14F-4B04-93BD-2FE48112A769},ReferenceMatch,0= CCA25C68-C9A4-4385-A60B-78E701E70FFA 1467442669 ph2 1467442709 ph2 B16C696D-D4F5-4BF3-ABB7-B804F474B0A8 Reference_3 Reference_3 1467443188 ph2 1467443219 ph2 0..* 1 1 FEA620AC-7050-4897-873E-DC4CAD03EEBF 1467443188 ph2 1467443219 ph2 F326A05F-A3B3-4E9E-BE64-3FA19CC305FF Reference_4 Reference_4 1467443198 ph2 1467443231 ph2 0..* 1 1 C2551CF4-B5F9-444D-8C89-E43D910B7F50 1467443198 ph2 1467443231 ph2 5C1A497F-8579-4DD8-89D7-CB7C9F36BEE7 Reference_6 Reference_6 1467446227 ph2 1467446244 ph2 0..* 1 1 10934457-793D-4F5C-8066-DCD3FC337214 1467446227 ph2 1467446244 ph2 51499610-97C5-4165-A6C4-2E1EC8FC1052 Reference_8 Reference_8 1467447271 ph2 1467447305 ph2 0..* 1 1 21BE6602-A584-4CC6-A12D-C4D4DA03199A 1467447271 ph2 1467447305 ph2 CB0DEE6D-AE25-43CF-86D1-7E11BBFC7207 Reference_9 Reference_9 1467448692 ph2 1467448692 ph2 0..* 1 1 B8380F44-1BAE-40A3-BAD1-C953602F54B9 1467448692 ph2 1467448692 ph2 6265B831-887D-4E1E-8E16-5521C2A6920E Reference_10 Reference_10 1467448699 ph2 1467448699 ph2 0..* 1 1 5FCE43EA-A89A-425A-B450-A744D2CFEB10 1467448699 ph2 1467448699 ph2 F127409B-A863-4C59-AC73-821A28162CC5 Reference_15 Reference_15 1467450178 ph2 1467450178 ph2 0..* 1 1 11CF8459-3125-4BB7-8BB2-EB39FC5A5B46 1467450178 ph2 1467450178 ph2 3D5A5D5A-5679-43D6-A8D0-2D29B16D2BAC Reference_16 Reference_16 1467450187 ph2 1467450187 ph2 0..* 1 1 4E7A2AB0-2931-4AB2-A015-6A5E1F318833 1467450187 ph2 1467450187 ph2 6DBCD3B1-0428-422B-9769-73E37839E458 Reference_19 Reference_19 1467450689 ph2 1467450689 ph2 0..* 1 1 CCDCFDBD-A867-4CAD-9481-225F39F2E7A4 1467450689 ph2 1467450689 ph2 54508563-1F6C-476A-90C2-1BD1D808E610 Reference_20 Reference_20 1467450690 ph2 1467450690 ph2 0..* 1 1 20E19AF7-C0C5-46EE-BC52-388C57DDB714 1467450690 ph2 1467450690 ph2 5A2ABC8D-4AF4-4857-8BBF-37139EAC603E Reference_21 Reference_21 1467451302 ph2 1467451302 ph2 0..* 1 1 6608929B-DE77-4013-943F-D2221202E0A6 1467451302 ph2 1467451302 ph2 DFF6EF9E-305D-4B03-B953-B5DE797D8F07 Reference_22 Reference_22 1467451314 ph2 1467451314 ph2 0..* 1 1 AEF1F076-B134-4C8A-AD96-53E2965585AB 1467451314 ph2 1467451314 ph2 C9A537A8-0C72-4F64-8CBF-286935B47AF3 Reference_23 Reference_23 1467451433 ph2 1467451433 ph2 0..* 1 1 5DADBFE5-77FF-4150-A240-B5AD9B07459A 1467451433 ph2 1467451433 ph2 0C5F8F2B-7F51-4B0C-AD2A-81951750EF5E Reference_24 Reference_24 1467451516 ph2 1467451555 ph2 0..* 1 1 01CFE337-8482-4635-BD96-B4C48DC22B6A 1467451516 ph2 1467451555 ph2 CC65D022-8B25-4AFB-B339-053B73897918 Reference_25 Reference_25 1467451820 ph2 1467451835 ph2 0..* 1 1 51F8A902-B007-4221-8042-BAC3375D52EB 1467451820 ph2 1467451835 ph2 0C53F73C-732C-40C2-9E5D-134C2776F805 Reference_33 Reference_33 1467463839 ph2 1467464018 ph2 0..* 1 1 746B75D0-B84C-4F9E-9996-8532151A26C0 1467463839 ph2 1467464018 ph2 4E135600-CCF3-4A96-B5D8-0518749CBDE9 Reference_34 Reference_34 1467463842 ph2 1467463922 ph2 0..* 1 1 2912FE2B-EA76-48D8-AFC2-480908831162 1467463842 ph2 1467463922 ph2 1FBF0B17-64E8-4AB5-94ED-5C929C24A5EF Reference_35 Reference_35 1467463844 ph2 1467463950 ph2 0..* 1 1 2A2EA818-12C8-4B8D-A97F-F1EC9E2B427F 1467463844 ph2 1467463950 ph2 2486E977-143E-4B7E-B903-C8DB7D54856E Reference_36 Reference_36 1467463846 ph2 1467463967 ph2 0..* 1 1 79571B62-39FD-4E3E-A95F-71CE4E7DEAE3 1467463846 ph2 1467463967 ph2 306BD4EE-ADC0-4C12-B05D-40C709FFF8EC Reference_37 Reference_37 1467544753 ph2 1467544753 ph2 0..* 1 1 BAECBE2A-3758-445C-A53C-9FE22B675B2F 1467544753 ph2 1467544753 ph2 3DFE688D-5808-48A5-ABF1-AA5F23795EAB Reference_38 Reference_38 1467544885 ph2 1467544885 ph2 0..* 1 1 56EFD348-F136-4128-8B49-A4E57D95568B 1467544885 ph2 1467544885 ph2 3215E024-3AB1-4DC7-8C45-B2ABBDF85061 Reference_39 Reference_39 1467544971 ph2 1467544971 ph2 0..* 1 1 EBA43BBA-92D6-4355-97A2-29FABFCF2FEA 1467544971 ph2 1467544971 ph2 61CF7400-182B-441A-90D5-F4C0B47B1501 Reference_40 Reference_40 1467545185 ph2 1467545185 ph2 0..* 1 1 20831F7A-DB6D-4F70-B7F7-9C25D3A2DFE8 1467545185 ph2 1467545185 ph2 592127CA-7204-4E4A-9CCD-65D2BCC6C745 Reference_41 Reference_41 1467545188 ph2 1467545188 ph2 0..* 1 1 922E8FF9-A35F-4220-B528-6C53E79B146B 1467545188 ph2 1467545188 ph2 B9632A72-187A-45BD-972B-5C4B62EB9EDE Reference_42 Reference_42 1467545480 ph2 1467545491 ph2 0..* 1 1 64B39209-3C15-4F74-B8F6-1482AAD3DCC1 1467545480 ph2 1467545491 ph2 F81BF629-7CFB-4E82-B226-A70DDBF5CE13 Reference_43 Reference_43 1467545499 ph2 1467545510 ph2 0..* 1 1 A784BB4F-832C-4478-AFAA-7F0860A6759B 1467545499 ph2 1467545510 ph2 70AC0B90-AC33-4E78-9471-BFD4555FE181 Reference_44 Reference_44 1467545673 ph2 1467545688 ph2 0..* 1 1 3704C788-A4F8-4C5B-8C12-87566A74A049 1467545673 ph2 1467545688 ph2 202DBA06-9C3B-45CE-AB13-EF486A941DFD Reference_45 Reference_45 1467545693 ph2 1467545705 ph2 0..* 1 1 1190E664-0AC3-4216-A4DA-402B8909683A 1467545693 ph2 1467545705 ph2 4D48018D-5FA5-4EBE-AE05-4CBE04CCD4FA Reference_46 Reference_46 1467545851 ph2 1467545851 ph2 0..* 1 1 771D34BA-0F1D-4E76-96E4-21DD9857A78E 1467545851 ph2 1467545851 ph2 8859A31E-53AC-4DE2-B401-42459E999701 Reference_47 Reference_47 1467545902 ph2 1467545902 ph2 0..* 1 1 EAFCB99B-8654-4FC1-A33F-4D6323DEAC7B 1467545902 ph2 1467545902 ph2 6F38AB89-786D-4514-887D-3F5C2E6D21F6 Reference_48 Reference_48 1467546004 ph2 1467546004 ph2 0..* 1 1 CE55DEBB-225B-47A4-8E60-222C8099FB1F 1467546004 ph2 1467546004 ph2 B48477C1-21C2-48C4-84E4-F7155178C1A2 Reference_49 Reference_49 1467546054 ph2 1467546054 ph2 0..* 1 1 253794C5-9682-40BB-A012-ECB36F1A9F92 1467546054 ph2 1467546054 ph2 811FBB9B-58EA-4618-A640-D0B6F4F046B3 Reference_50 Reference_50 1467546112 ph2 1467546112 ph2 0..* 1 1 EB27062A-49AF-405D-A97B-A223620B375D 1467546112 ph2 1467546112 ph2 77EC4688-2073-47A1-838C-380499D2E484 Reference_51 Reference_51 1467546324 ph2 1467546324 ph2 0..* 1 1 EB076FA3-73C1-4886-B7B7-060011EDFA57 1467546324 ph2 1467546324 ph2 9AD8770B-049C-4482-91DC-23C706D3FEA8 PUBLIC PUBLIC 1467375718 ph2 1467375718 ph2 72014D4A-D80D-4F56-AFC9-B63917CBFE6F MySQL 5.0 MYSQL50 1467375726 ph2 1467523556 ph2 file:///%_DBMS%/mysql50.xdb F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 1467469734