DF4B5ED2-C3CE-42C3-9DCE-6550B13A827B emato_pt Physical Data _1 1561947604 Administrator 1563261824 Administrator [FolderOptions] [FolderOptions\Physical Objects] GenerationCheckModel=Yes GenerationPath= GenerationOptions= GenerationTasks= GenerationTargets= GenerationSelections= RevPkey=Yes RevFkey=Yes RevAkey=Yes RevCheck=Yes RevIndx=Yes RevOpts=Yes RevViewAsTabl=No RevViewOpts=Yes RevSystAsTabl=Yes RevTablPerm=No RevViewPerm=No RevProcPerm=No RevDbpkPerm=No RevSqncPerm=No RevAdtPerm=No RevUserPriv=No RevUserOpts=No RevGrpePriv=No RevRolePriv=No RevDtbsOpts=Yes RevDtbsPerm=No RevViewIndx=Yes RevJidxOpts=Yes RevStats=No RevTspcPerm=No RevCaseSensitive=No GenTrgrStdMsg=Yes GenTrgrMsgTab= GenTrgrMsgNo= GenTrgrMsgTxt= TrgrPreserve=No TrgrIns=Yes TrgrUpd=Yes TrgrDel=Yes TrgrC2Ins=Yes TrgrC2Upd=Yes TrgrC3=Yes TrgrC4=Yes TrgrC5=Yes TrgrC6=Yes TrgrC7=Yes TrgrC8=Yes TrgrC9=Yes TrgrC10=Yes TrgrC11=Yes TrgrC1=Yes TrgrC12Ins=Yes TrgrC12Upd=Yes TrgrC13=Yes UpdateTableStatistics=Yes UpdateColumnStatistics=Yes [FolderOptions\Physical Objects\Database Generation] GenScriptName=crebas GenScriptName0= GenScriptName1= GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName= 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= F86AE337-82CE-49C5-8997-D2914408AA50 MySQL 5.0 MYSQL50 1561947603 Administrator 1561947603 Administrator F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B C968E6D1-D04D-4F9A-8491-13DB9103CE5F 官网模型 PhysicalDiagram_1 1561947604 Administrator 1563261824 Administrator [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Show Links intersections=Yes Activate automatic link routing=Yes Grid size=0 Graphic unit=2 Window color=255, 255, 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255, 255, 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Show Icon=No Mode=2 Trunc Length=40 Word Length=40 Word Text=!"#$%&')*+,-./:;=>?@\]^_`|}~ Shortcut IntIcon=Yes Shortcut IntLoct=Yes Shortcut IntFullPath=No Shortcut IntLastPackage=Yes Shortcut ExtIcon=Yes Shortcut ExtLoct=No Shortcut ExtFullPath=No Shortcut ExtLastPackage=Yes Shortcut ExtIncludeModl=Yes EObjShowStrn=Yes ExtendedObject.Comment=No ExtendedObject.IconPicture=No ExtendedObject.TextStyle=No ExtendedObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Object Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Source" >[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] </Form>[CRLF]</Form> FileObject.Stereotype=No FileObject.DisplayName=Yes FileObject.LocationOrName=No FileObject.IconPicture=No FileObject.TextStyle=No FileObject.IconMode=Yes FileObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Location" Attribute="LocationOrName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Package.Stereotype=Yes Package.Comment=No Package.IconPicture=No Package.TextStyle=No Package_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Display Model Version=Yes Table.Stereotype=Yes Table.DisplayName=Yes Table.OwnerDisplayName=No Table.Columns=Yes Table.Columns._Filter="All Columns" PDMCOLNALL Table.Columns._Columns=Stereotype DataType KeyIndicator Table.Columns._Limit=-5 Table.Keys=No Table.Keys._Columns=Stereotype Indicator Table.Indexes=No Table.Indexes._Columns=Stereotype Table.Triggers=No Table.Triggers._Columns=Stereotype Table.Comment=No Table.IconPicture=No Table.TextStyle=No Table_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="Stereotype No\r\nDisplayName Yes\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nDomain No\r\nKeyIndicator No\r\nIndexIndicator No\r\nNullStatus No" Filters=""All Columns" PDMCOLNALL ""\r\n"PK Columns" PDMCOLNPK "\"PRIM \"TRUE\" TRUE\""\r\n"Key Columns" PDMCOLNKEY "\"KEYS \"TRUE\" TRUE\""" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Keys" Collection="Keys" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Triggers" Collection="Triggers" Columns="Stereotype No\r\nDisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> View.Stereotype=Yes View.DisplayName=Yes View.OwnerDisplayName=No View.Columns=Yes View.Columns._Columns=DisplayName View.Columns._Limit=-5 View.TemporaryVTables=Yes View.Indexes=No View.Comment=No View.IconPicture=No View.TextStyle=No View_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="DisplayName No\r\nExpression No\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nIndexIndicator No" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Tables" Collection="TemporaryVTables" Columns="Name Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="DisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Procedure.Stereotype=No Procedure.DisplayName=Yes Procedure.OwnerDisplayName=No Procedure.Comment=No Procedure.IconPicture=No Procedure.TextStyle=No Procedure_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Reference.Cardinality=No Reference.ImplementationType=No Reference.ChildRole=Yes Reference.Stereotype=Yes Reference.DisplayName=No Reference.ForeignKeyConstraintName=No Reference.JoinExpression=No Reference.Integrity=No Reference.ParentRole=Yes Reference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Cardinality" Attribute="Cardinality" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Implementation" Attribute="ImplementationType" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Cons&traint Name" Attribute="ForeignKeyConstraintName" Prefix="" Suffix="" Caption="Cons&traint Name" Mandatory="No" />[CRLF] <StandardAttribute Name="Join" Attribute="JoinExpression" Prefix="" Suffix="" Caption="Join" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Referential integrity" Attribute="Integrity" Prefix="" Suffix="" Caption="Referential integrity" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> ViewReference.ChildRole=Yes ViewReference.Stereotype=Yes ViewReference.DisplayName=No ViewReference.JoinExpression=No ViewReference.ParentRole=Yes ViewReference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Join Expression" Attribute="JoinExpression" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=6000 Height=2000 Brush color=255 255 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=64 Brush gradient color=192 192 192 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 255 128 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FRMELNK] CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FILO] OBJSTRNFont=新宋体,8,N OBJSTRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LCNMFont=新宋体,8,N LCNMFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PDMPCKG] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 KeysFont=新宋体,8,N KeysFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 TriggersFont=新宋体,8,N TriggersFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=178 214 252 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 TemporaryVTablesFont=新宋体,8,N TemporaryVTablesFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=208 208 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4000 Height=1000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 108 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=新宋体,8,N OBJXSTRFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0, 0, 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 (8268, 11693) ((315,354), (433,354)) 1 7 1561959861 1563262410 -1 ((-3945,8362), (7745,21186)) 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 1561960169 1563257294 -1 ((-31312,8286), (-19876,21184)) 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 1561968509 1563262359 -1 ((-3895,-4613), (7795,7611)) 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 1561970358 1563262233 -1 ((-3819,-19613), (7871,-5861)) 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 1561970678 1563262423 -1 ((-17969,8436), (-5337,21186)) 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 1561971339 1563261771 -1 ((-17420,-19163), (-5212,-5951)) 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 1562228210 1563262363 -1 ((9705,-4613), (21395,7535)) 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 1562729945 1563262416 -1 ((9556,8587), (21246,21161)) 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 1562827603 1563262356 -1 ((-17796,-4613), (-5436,7537)) 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 1562827793 1563261751 -1 ((-31270,-4584), (-19580,7438)) 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 1562829729 1563262398 -1 ((9956,-19088), (21646,-5936)) 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 1563261067 1563262390 -1 ((-31420,-19238), (-18937,-5962)) 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 42F12A6F-98DF-400F-9ACB-FE2C89C85B8F 系统模型 sys 1562228305 Administrator 1562830386 Administrator 系统模型 [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Show Links intersections=Yes Activate automatic link routing=Yes Grid size=0 Graphic unit=2 Window color=255, 255, 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255, 255, 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Show Icon=No Mode=2 Trunc Length=40 Word Length=40 Word Text=!"#$%&')*+,-./:;=>?@\]^_`|}~ Shortcut IntIcon=Yes Shortcut IntLoct=Yes Shortcut IntFullPath=No Shortcut IntLastPackage=Yes Shortcut ExtIcon=Yes Shortcut ExtLoct=No Shortcut ExtFullPath=No Shortcut ExtLastPackage=Yes Shortcut ExtIncludeModl=Yes EObjShowStrn=Yes ExtendedObject.Comment=No ExtendedObject.IconPicture=No ExtendedObject.TextStyle=No ExtendedObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Object Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Source" >[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] </Form>[CRLF]</Form> FileObject.Stereotype=No FileObject.DisplayName=Yes FileObject.LocationOrName=No FileObject.IconPicture=No FileObject.TextStyle=No FileObject.IconMode=Yes FileObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Location" Attribute="LocationOrName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Package.Stereotype=Yes Package.Comment=No Package.IconPicture=No Package.TextStyle=No Package_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Display Model Version=Yes Table.Stereotype=Yes Table.DisplayName=Yes Table.OwnerDisplayName=No Table.Columns=Yes Table.Columns._Filter="All Columns" PDMCOLNALL Table.Columns._Columns=Stereotype DataType KeyIndicator Table.Columns._Limit=-5 Table.Keys=No Table.Keys._Columns=Stereotype Indicator Table.Indexes=No Table.Indexes._Columns=Stereotype Table.Triggers=No Table.Triggers._Columns=Stereotype Table.Comment=No Table.IconPicture=No Table.TextStyle=No Table_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="Stereotype No\r\nDisplayName Yes\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nDomain No\r\nKeyIndicator No\r\nIndexIndicator No\r\nNullStatus No" Filters=""All Columns" PDMCOLNALL ""\r\n"PK Columns" PDMCOLNPK "\"PRIM \"TRUE\" TRUE\""\r\n"Key Columns" PDMCOLNKEY "\"KEYS \"TRUE\" TRUE\""" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Keys" Collection="Keys" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Triggers" Collection="Triggers" Columns="Stereotype No\r\nDisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> View.Stereotype=Yes View.DisplayName=Yes View.OwnerDisplayName=No View.Columns=Yes View.Columns._Columns=DisplayName View.Columns._Limit=-5 View.TemporaryVTables=Yes View.Indexes=No View.Comment=No View.IconPicture=No View.TextStyle=No View_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="DisplayName No\r\nExpression No\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nIndexIndicator No" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Tables" Collection="TemporaryVTables" Columns="Name Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="DisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Procedure.Stereotype=No Procedure.DisplayName=Yes Procedure.OwnerDisplayName=No Procedure.Comment=No Procedure.IconPicture=No Procedure.TextStyle=No Procedure_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Reference.Cardinality=No Reference.ImplementationType=No Reference.ChildRole=Yes Reference.Stereotype=Yes Reference.DisplayName=No Reference.ForeignKeyConstraintName=No Reference.JoinExpression=No Reference.Integrity=No Reference.ParentRole=Yes Reference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Cardinality" Attribute="Cardinality" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Implementation" Attribute="ImplementationType" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Cons&traint Name" Attribute="ForeignKeyConstraintName" Prefix="" Suffix="" Caption="Cons&traint Name" Mandatory="No" />[CRLF] <StandardAttribute Name="Join" Attribute="JoinExpression" Prefix="" Suffix="" Caption="Join" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Referential integrity" Attribute="Integrity" Prefix="" Suffix="" Caption="Referential integrity" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> ViewReference.ChildRole=Yes ViewReference.Stereotype=Yes ViewReference.DisplayName=No ViewReference.JoinExpression=No ViewReference.ParentRole=Yes ViewReference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Join Expression" Attribute="JoinExpression" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=6000 Height=2000 Brush color=255 255 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=64 Brush gradient color=192 192 192 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 255 128 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FRMELNK] CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FILO] OBJSTRNFont=新宋体,8,N OBJSTRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LCNMFont=新宋体,8,N LCNMFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PDMPCKG] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 KeysFont=新宋体,8,N KeysFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 TriggersFont=新宋体,8,N TriggersFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=178 214 252 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 TemporaryVTablesFont=新宋体,8,N TemporaryVTablesFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=208 208 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4000 Height=1000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 108 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=新宋体,8,N OBJXSTRFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0, 0, 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 (8268, 11693) ((315,354), (433,354)) 1 7 1562228534 1562228936 -1 ((-21419,4461), (-9731,16161)) 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 1562228544 1562229041 -1 ((-6369,3264), (5319,16236)) 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 1562228554 1562229044 -1 ((7205,7326), (18894,16174)) 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 1562228575 1562830394 -1 ((35598,7990), (46901,16012)) 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 1562228654 1562229046 -1 ((21624,8039), (32927,16061)) 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 1562228666 1562229148 -1 ((-21487,-10274), (-9413,1874)) 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 1562228678 1562830398 -1 ((-6237,-8699), (5837,1799)) 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 DF3B2940-8D25-49FC-932B-9A3AB2844AAF 官网首页滚动图表 emt_home_scroll_img 1546842924 Administrator 1563262188 Administrator 官网首页滚动图表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact 9D569417-82A3-4A4A-8D28-072018698B10 编号 home_scroll_img_id 1546842924 Administrator 1563262058 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 53AB7B8E-3ECA-4C0C-BF06-42943A096AC4 广告类型 home_scroll_img_type 1538029095 Administrator 1563262058 Administrator 0 轮播展示 1 小图展示 0 char(2) 2 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 615277C5-365E-466F-9442-60DCC97F1D23 广告url home_scroll_img_url 1546842924 Administrator 1563262058 Administrator 广告url varchar(225) 225 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 7E40AF75-450A-491A-90D0-56E1F7D36453 广告名称 home_scroll_img_name 1546842924 Administrator 1563262058 Administrator 广告名称 varchar(64) 64 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 67542D2F-57E0-4F67-9DFB-186950BB9977 排序 sort_order 1546941249 Administrator 1561966810 Administrator 排序 int(11) 11 E5625997-97A4-45ED-9A26-5BACE76722DC 广告内容 home_ad_content 1546842924 Administrator 1562228100 Administrator 广告内容 varchar(10000) 10000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 305A01A9-F638-4F7F-81B2-1D6ADF4C39BB 是否有效 is_valid 1546842924 Administrator 1561971640 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 55239A93-3F69-4E68-B3F1-2AB9DDB5CD5F 创建人编号 creater_sn 1503543793 Administrator 1561960156 Administrator 创建人编号 varchar(22) 22 FC07B21E-3E1B-443E-951E-1E7FA5C57CEC 创建时间 create_time 1480919323 Administrator 1561960156 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime A68DBD4D-A955-4BF5-8867-A5AFC672298E 修改人编号 moder_sn 1487662489 Administrator 1561960156 Administrator 修改人编号 varchar(22) 22 2019A2E2-3EB3-4C78-AFDE-B36760B0A82E 修改时间 mod_time 1480919323 Administrator 1561960156 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime F4BF7092-DE4E-4709-AB1E-363EEC9B99C5 时间戳 tstm 1503405883 Administrator 1561960156 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 0F57679C-72D9-42F7-A1E6-2FF0949D2AC9 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator 120FEFBC-6FC0-44BC-8AB7-0E5333F1D2C9 官网导航栏菜单表 emt_navi_menu 1546842924 Administrator 1562230092 Administrator 官网导航栏菜单表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact DC3A1417-77EC-4F1B-8E33-03A0F10497DC 编号 navi_menu_id 1546842924 Administrator 1561968452 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true DFB7DE2A-CBEE-4D39-905A-1FE22C8329E9 父级菜单id parent_navi_menu_id 1562229979 Administrator 1562230101 Administrator 父级菜单id int(11) 11 C4DC0A66-3391-41E2-A44B-3E05DD0A8C23 菜单url navi_menu_url 1546842924 Administrator 1561963470 Administrator 菜单url varchar(225) 225 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 64F52046-B129-45F4-B510-8EA7863907AE 菜单名称 navi_menu_name 1546842924 Administrator 1561963470 Administrator 菜单名称 varchar(64) 64 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 32AB4A1F-C573-4916-A315-5C0AAC0ADF11 菜单等级 child_menu_level 1561963485 Administrator 1561971126 Administrator 子菜单等级 int(11) 11 8292192E-7B8F-43CC-BB00-99844359D524 排序 sort_order 1546941249 Administrator 1561968499 Administrator 排序 int(11) 11 C417A593-2DC5-4C70-AC55-EE325A70675F 是否有效 is_valid 1546842924 Administrator 1561971629 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 B08AA73D-881C-4F15-B988-6306F9F0E87D 创建人编号 creater_sn 1503543793 Administrator 1561960169 Administrator 创建人编号 varchar(22) 22 37F17FC0-E0C7-4FFD-B650-2E4A01D23CE8 创建时间 create_time 1480919323 Administrator 1561960169 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 570BA49E-B71D-432A-90E7-DF92DF13B98C 修改人编号 moder_sn 1487662489 Administrator 1561960169 Administrator 修改人编号 varchar(22) 22 FE204AA5-3308-43C8-9B87-614AC8A7C1BF 修改时间 mod_time 1480919323 Administrator 1561960169 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 023D1CCD-3BB7-4743-B7E7-59F96FF0B57C 时间戳 tstm 1503405883 Administrator 1561960169 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 46A12287-0463-46C5-BE53-3081BFA1AA81 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator C3E32D05-4F1F-4614-BB68-A7151D79F8F1 新闻表 emt_new 1546842924 Administrator 1561968707 Administrator 新闻表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact E9932F3D-CEC3-4C4B-9DB0-33214263C2FE 编号 new_id 1546842924 Administrator 1561968707 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 46CB79AC-1B3C-4957-AA94-9808E3FC6136 新闻类型id new_type_id 1538029095 Administrator 1562229896 Administrator 新闻类型id 0 int(11) 11 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true F2165748-E951-4284-9704-DF110BBB2BCA 新闻标题 new_title 1538029095 Administrator 1561971711 Administrator 新闻标题 0 varchar(64) 64 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true C0270D70-4955-4057-BA15-7B415FB3B877 新闻内容描述 new_content 1546842924 Administrator 1562228152 Administrator 新闻内容描述 varchar(10000) 10000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 12D1B76D-D1C8-48E2-9E2F-EE7961D3AC52 排序 sort_order 1546941249 Administrator 1561968509 Administrator 排序 int(11) 11 BAE383A8-8B51-4535-B8B0-2A5F34BA2A59 是否有效 is_valid 1546842924 Administrator 1561971711 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 E9274583-E590-47BD-B221-3F210C84CD21 创建人编号 creater_sn 1503543793 Administrator 1561968509 Administrator 创建人编号 varchar(22) 22 E5729EDE-D2C6-495A-B8DA-70C16148A555 创建时间 create_time 1480919323 Administrator 1561968509 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 482DED4D-96FB-45E9-ACB6-DFE8329FBD20 修改人编号 moder_sn 1487662489 Administrator 1561968509 Administrator 修改人编号 varchar(22) 22 C458C523-EEDF-44FC-AB7A-27016DD6E9C9 修改时间 mod_time 1480919323 Administrator 1561968509 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 54AA5F62-16E7-4A4C-83AB-095F660A69BA 时间戳 tstm 1503405883 Administrator 1561968509 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime B643B1B3-0F09-4CEB-ABF4-1C801E63EF06 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator D463269C-BECA-4A73-AD64-5C22BB5D70BD 招聘表 emt_recruitment 1546842924 Administrator 1562829688 Administrator 招聘表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact 79FCE122-CB21-4437-A051-47707DFA6777 编号 recruitment_id 1546842924 Administrator 1561970578 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 28CECACA-7168-46F9-AB51-E8A8A9CC1C10 岗位名称 recruitment_name 1538029095 Administrator 1562829688 Administrator 岗位名称 0 varchar(256) 256 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 219CE917-11A6-4F35-BADD-802D5B1A4D94 工作地点 job_address 1562829302 Administrator 1562829688 Administrator 工作地点 varchar(64) 64 468FE31B-EE96-4FDB-A449-EC9C837E0FD4 经验要求 experience_year 1562829302 Administrator 1562829688 Administrator 经验要求 varchar(64) 64 40458D8C-193A-40DE-A012-73B7ED2BEBB9 学历要求 education_cotent 1562829302 Administrator 1562829688 Administrator 学历要求 varchar(64) 64 7BF04D44-AB15-4E58-B091-36318FE0FDF4 招聘人数 recruitment_num 1562829302 Administrator 1562829688 Administrator 招聘人数 int(11) 11 F87DEC70-1679-44A5-B1AC-77BE0E5C4AAB 招聘内容 position_state 1538029095 Administrator 1562829688 Administrator 岗位职责 0 varchar(10000) 10000 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true E4D6C73D-2D6F-4A0A-9F2D-CB0779BC3228 入职要求 entry_require 1562829302 Administrator 1562829688 Administrator 入职要求 varchar(10000) 10000 3AD7CB67-78D0-47F1-803C-0F6CB96CA949 排序 sort_order 1546941249 Administrator 1561970358 Administrator 排序 int(11) 11 7ED7F161-68BA-4D0B-BD21-250776A7B2DB 是否有效 is_valid 1546842924 Administrator 1561971745 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 0A99218D-20BC-48EC-9C40-D1D7D793D664 创建人编号 creater_sn 1503543793 Administrator 1561970358 Administrator 创建人编号 varchar(22) 22 BEEEF5AF-CEBD-4D76-9199-2BAB69BBF86D 创建时间 create_time 1480919323 Administrator 1561970358 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime F174A382-254F-4420-ADFB-28BBFB6B46B5 修改人编号 moder_sn 1487662489 Administrator 1561970358 Administrator 修改人编号 varchar(22) 22 CC9CEA19-351A-49F5-BADC-48E9BCA3A460 修改时间 mod_time 1480919323 Administrator 1561970358 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime FF52A6C1-21D7-4D68-85D7-8A6B8D312FC7 时间戳 tstm 1503405883 Administrator 1561970358 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 764E5C6E-0B76-4169-B612-DC7882B9AF53 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator 4A2F45D0-838B-4BE9-9531-119E6574E1AC 官网菜单滚动图表 emt_navi_menu_pic 1546842924 Administrator 1562831033 Administrator 官网菜单滚动图表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact 03B641F5-3BFB-4175-88E7-626B8703F04B 编号 navi_menu_pic_id 1546842924 Administrator 1562229542 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 18F3218C-6084-4681-B0AB-15AFAAA74FB6 导航栏菜单id navi_menu_id 1538029095 Administrator 1562229408 Administrator 导航栏菜单id 0 int(11) 11 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true E0AE1710-BA6F-4BBA-8780-FF006E7BBF30 菜单展示图片url navi_menu_pic_url 1546842924 Administrator 1562229408 Administrator 菜单展示图片url varchar(64) 64 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 5787AC5F-72BA-4608-A464-8BF42DDA1BFD 是否有效 is_valid 1546842924 Administrator 1561971649 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 A37B760A-CB26-4B93-9256-2766803B31CA 创建人编号 creater_sn 1503543793 Administrator 1561970678 Administrator 创建人编号 varchar(22) 22 4230BE30-FA5B-4801-939C-95CA5CABF33E 创建时间 create_time 1480919323 Administrator 1561970678 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 8D28A919-05D6-43D7-BF1A-04D15869CBB2 修改人编号 moder_sn 1487662489 Administrator 1561970678 Administrator 修改人编号 varchar(22) 22 07383456-8120-4EE1-9FE2-3666EE71CF7D 修改时间 mod_time 1480919323 Administrator 1561970678 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 004E895F-93FA-4034-BE75-BBA1AD000938 时间戳 tstm 1503405883 Administrator 1561970678 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 41E144E6-527E-4A23-8224-996C384A0E5C Key_1 Key_1 1546842924 Administrator 1546842924 Administrator D345CE32-0838-450E-8457-145E54CDCC55 公司通讯录表 emt_bus_address_book 1546842924 Administrator 1562829272 Administrator 公司通讯录表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact E11EB183-BC16-4E8D-BCC5-B3B9587CA61B 编号 bus_address_book_id 1546842924 Administrator 1562829272 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true C95F0D44-C708-49DE-B06D-5CFA95B6BEBF 公司名称 bus_name 1546842924 Administrator 1562829272 Administrator 公司名称 varchar(64) 64 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 399159C5-FEFE-43D2-BD5C-24CF44C52F64 公司地址 bus_address 1546842924 Administrator 1562829272 Administrator 公司地址 varchar(10000) 10000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 6A6DEEAE-4A07-455F-ADA5-0B4C76488CC9 公司联系电话 bus_tel 1562829016 Administrator 1563261057 Administrator 公司联系电话 varchar(22) 22 8C0CB0D7-FC0F-45D8-9504-B1DA1332810D 公司电子邮箱 bus_email 1562829016 Administrator 1563261057 Administrator 公司电子邮箱 varchar(64) 64 24181B4A-FC4B-41D4-98C8-42A287D7FFC8 公司地址经度 bus_longitude 1562829016 Administrator 1563261057 Administrator 公司地址经度 varchar(64) 64 55841EF3-E672-4D06-B433-BB583EF07E9A 公司地址纬度 bus_latitude 1562829016 Administrator 1563261057 Administrator 公司地址纬度 varchar(64) 64 7E6310B5-BF49-4E6F-BE0E-9489D666F93F 排序 sort_order 1546941249 Administrator 1561971461 Administrator 排序 int(11) 11 81FA17C2-9846-44DD-A3D7-CA3AA5C7013C 是否有效 is_valid 1546842924 Administrator 1561971339 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 F7819A94-ADE7-45E9-8285-BB98D173A627 创建人编号 creater_sn 1503543793 Administrator 1561971339 Administrator 创建人编号 varchar(22) 22 684977C9-0E5C-45C5-9F09-2F5104F8087C 创建时间 create_time 1480919323 Administrator 1561971339 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 38257A5C-9438-4D7C-A707-20E2D89262B2 修改人编号 moder_sn 1487662489 Administrator 1561971339 Administrator 修改人编号 varchar(22) 22 1BCAC472-2661-44F6-B3D6-4B4A4539F077 修改时间 mod_time 1480919323 Administrator 1561971339 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 5CACC53C-05F7-4BB9-910F-A579FE49316F 时间戳 tstm 1503405883 Administrator 1561971339 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 395012FE-EEC7-4969-B423-F3F1A4F3AD40 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator F990A40E-5762-4651-B1C8-D14CA1730013 新闻类型表 emt_new_type 1546842924 Administrator 1562228259 Administrator 新闻类型表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact A5CCFBDE-F56E-4C36-B4A2-70F94137415C 编号 new_type_id 1546842924 Administrator 1562228259 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 9E84DD34-3761-4B5B-8AA0-A64046447B8B 新闻类型名称 new_type_name 1538029095 Administrator 1562228259 Administrator 新闻类型名称 0 varchar(22) 22 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 7A431430-DF27-4D54-B571-EF59ACD41944 排序 sort_order 1546941249 Administrator 1562228210 Administrator 排序 int(11) 11 4D11B8B8-F6BC-496E-B730-12877403BEF8 是否有效 is_valid 1546842924 Administrator 1562228210 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 E01533DA-B777-4ED0-9DBD-B81001EF13A2 创建人编号 creater_sn 1503543793 Administrator 1562228210 Administrator 创建人编号 varchar(22) 22 E2450A4E-8A63-4DBD-BE66-C7D3EB3E81E9 创建时间 create_time 1480919323 Administrator 1562228210 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 67F3DD4D-6C88-4E7C-9AB7-4BC75FA29EDF 修改人编号 moder_sn 1487662489 Administrator 1562228210 Administrator 修改人编号 varchar(22) 22 86C8122F-FDC8-4692-8E6C-D0C3E7E8CA7F 修改时间 mod_time 1480919323 Administrator 1562228210 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 12E9625A-383D-4D24-B308-15F01B6FAA08 时间戳 tstm 1503405883 Administrator 1562228210 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 4AD8BC70-AA46-4E14-B42F-123ECAEDD5F1 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator 3542C736-4062-4F33-85E5-4186DBF0809F 系统用户表 sys_user 1538029095 Administrator 1562228930 Administrator auto_increment = 2 8CBCF104-C91A-4553-B608-A79E2AFD34AD 编号 user_id 1538029095 Administrator 1562229934 Administrator 编号 int(11) 11 1 1 54B85D09-727F-4351-8956-8A8AE99D16BD 用户名 username 1538029095 Administrator 1562228534 Administrator 用户名 varchar(50) 50 1 99C10FFF-65A9-4952-A7B9-86A5D641BC6E 密码 password 1538029095 Administrator 1562228534 Administrator 密码 NULL varchar(100) 100 41DA2801-72A6-4999-A200-D4A76F75984E 邮箱 email 1538029095 Administrator 1562228534 Administrator 邮箱 NULL varchar(100) 100 FD755FAC-7600-452F-B7D6-FEC746EB3075 手机号 mobile 1538029095 Administrator 1562228534 Administrator 手机号 NULL varchar(100) 100 865EF2F6-FF7A-4FF0-9041-1B9B679B7B8D 角色类型 role_type 1547000739 Administrator 1562228534 Administrator 角色类型 1：操作员；2：店员；3：商户管理员 int(11) 11 13097395-99A7-4472-AA40-DCDAC2169FAE 是否有效 is_valid 1546842924 Administrator 1562228930 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 1D22BC73-1F61-4BD3-AC7F-CF2BCEC8FCA6 创建人编号 creater_sn 1503543793 Administrator 1562228930 Administrator 创建人编号 varchar(22) 22 CE48ED2C-C7CA-40AD-BD68-2F70E6C45AD3 创建时间 create_time 1480919323 Administrator 1562228945 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 237A7E1F-96A9-47B5-8E09-CA4E86A39A3C 修改人编号 moder_sn 1487662489 Administrator 1562228930 Administrator 修改人编号 varchar(22) 22 24A8C7F1-2E21-4F0B-B2B8-203D7AE14E94 修改时间 mod_time 1480919323 Administrator 1562228930 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime C4851C9A-50AE-498D-A530-0A8230452208 时间戳 tstm 1503405883 Administrator 1562228930 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime C5145C51-4850-4406-80B1-B7B558931DB0 Key_1 Key_1 1538029095 Administrator 1538029095 Administrator D29055BA-1590-464E-9861-EA04D76449AF username username 1538029095 Administrator 1538029095 Administrator username {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,57={D1C795B8-8F7B-4AA7-A240-85C5B737C543},ExtUnique,4=true F2D29453-8483-4E1C-A9F3-0966E8C1E4EE 系统菜单表 sys_menu 1538029095 Administrator 1562548656 Administrator auto_increment = 11008 8F369E00-1ED8-43D7-BC8E-865A1068FC15 编号 menu_id 1538029095 Administrator 1562229941 Administrator 编号 int(11) 11 1 1 7CD6C905-FF45-4286-B028-427840071758 父菜单ID parent_id 1538029095 Administrator 1562229941 Administrator 父菜单ID，一级菜单为0 NULL int(11) 11 96FBAF2B-FD04-4E3A-850E-008B2B8CCDE9 菜单名称 name 1538029095 Administrator 1562228544 Administrator 菜单名称 NULL varchar(50) 50 DE3F2631-4C6B-48EE-B8AF-85991AA46D81 菜单URL url 1538029095 Administrator 1562228544 Administrator 菜单URL NULL varchar(200) 200 42D27DDC-0E37-436C-84D6-BA22A4FCFD5D 授权 perms 1538029095 Administrator 1562228544 Administrator 授权(多个用逗号分隔，如：user:list,user:create) NULL varchar(500) 500 04B7A856-5543-4D5C-ADBD-CE2DD29DEA89 类型 type 1538029095 Administrator 1562228544 Administrator 类型 0：目录 1：菜单 2：按钮 NULL int(11) 11 9255DF68-E370-4BB7-9AB5-B6C332CF2C3C 菜单图标 icon 1538029095 Administrator 1562228544 Administrator 菜单图标 NULL varchar(50) 50 17E68F2B-1D90-4746-816A-925288D3DCDC 排序 order_num 1538029095 Administrator 1562228544 Administrator 排序 NULL int(11) 11 D28C89A9-4236-4025-852E-F83D434B5374 状态 status 1538029095 Administrator 1562228544 Administrator 状态 NULL int(1) 1 E58FF604-20C7-4B38-9006-77047751FCA5 创建人编号 creater_sn 1503543793 Administrator 1562228966 Administrator 创建人编号 varchar(22) 22 6F5784E7-81D4-4B0C-9A20-E24DF08741E2 创建时间 create_time 1480919323 Administrator 1562228966 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime F35C1557-20C0-44B1-9BEF-6DDE6CE5214F 修改人编号 moder_sn 1487662489 Administrator 1562228966 Administrator 修改人编号 varchar(22) 22 9FCBB563-4FB4-4D9A-A0C0-8D32B4E4CC1C 修改时间 mod_time 1480919323 Administrator 1562228966 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime F193306E-A45C-4790-8769-64DD56F1D3C9 时间戳 tstm 1503405883 Administrator 1562228966 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime C94A5840-7A84-4760-B93F-DB4EA9F8F63F Key_1 Key_1 1538029095 Administrator 1538029095 Administrator 0CF783F3-14BC-465D-96A2-0A6B06781801 角色表 sys_role 1538029095 Administrator 1562228978 Administrator auto_increment = 2 1D88A29B-800E-4FEA-948C-578A869BA8DB 编号 role_id 1538029095 Administrator 1562229947 Administrator 编号 int(11) 11 1 1 DB168C6E-1D3F-43CF-8168-8AE58DBCE919 角色名称 role_name 1538029095 Administrator 1562228554 Administrator 角色名称 NULL varchar(100) 100 BA03C31C-4FF7-4223-A6FD-B6BCF8C8230B 备注 remark 1538029095 Administrator 1562228554 Administrator 备注 NULL varchar(100) 100 40BE8643-1DEE-4E64-8702-5AAC62067971 是否有效 is_valid 1546842924 Administrator 1562228978 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 0000111A-2312-4A45-88BE-F1A1745A7CF7 创建人编号 creater_sn 1503543793 Administrator 1562228978 Administrator 创建人编号 varchar(22) 22 64536EC5-5FC3-4C3B-AD11-23E126959D57 创建时间 create_time 1480919323 Administrator 1562228978 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime C488E87C-8F50-4DD3-AD2F-6B83964F74CB 修改人编号 moder_sn 1487662489 Administrator 1562228978 Administrator 修改人编号 varchar(22) 22 D6B427C9-13D6-4709-8EA8-2CB119AEFD61 修改时间 mod_time 1480919323 Administrator 1562228978 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 97A2D27F-BD1F-466E-B1AD-646A73C98251 时间戳 tstm 1503405883 Administrator 1562228978 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 0A55F9ED-6C37-492E-A4F9-78E9AD817D46 Key_1 Key_1 1538029095 Administrator 1538029095 Administrator 5DF8ECB0-E400-4130-9DC1-399D6DC9B924 角色与菜单对应关系 sys_role_menu 1538029095 Administrator 1562229010 Administrator auto_increment = 1 88A1DFE3-308B-42AB-A219-0790FC918383 编号 id 1538029095 Administrator 1562229965 Administrator 编号 int(11) 11 1 1 9F9D3388-151F-4F72-B348-C5030E84C442 角色ID role_id 1538029095 Administrator 1562229965 Administrator 角色ID NULL int(11) 11 13F3D3A7-F1D6-4B7B-8E82-9DF85711E05A 菜单ID menu_id 1538029095 Administrator 1562229965 Administrator 菜单ID NULL int(11) 11 C5097006-7193-44F0-B634-8481FDC05398 创建人编号 creater_sn 1503543793 Administrator 1562229010 Administrator 创建人编号 varchar(22) 22 20509100-1C09-48C1-8B3C-7D5DBA982156 创建时间 create_time 1480919323 Administrator 1562229010 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 946647E7-F513-4F0C-A129-B00C69EBAF23 修改人编号 moder_sn 1487662489 Administrator 1562229010 Administrator 修改人编号 varchar(22) 22 C212B9D1-2CA5-4B1D-9502-8C185696A585 修改时间 mod_time 1480919323 Administrator 1562229010 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 37DD674F-340D-4046-9AC0-F1E0620661C1 时间戳 tstm 1503405883 Administrator 1562229010 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 4FB94AB4-AB79-4E4E-8338-C83CF3E4F7B7 Key_1 Key_1 1538029095 Administrator 1538029095 Administrator FC9D03BA-6E33-44AD-8A12-D4EDC64DD294 用户与角色对应关系 sys_user_role 1538029095 Administrator 1562228989 Administrator auto_increment = 1 8291C4DE-CE2C-4DDD-8588-EBFB3F02BD4C 编号 id 1538029095 Administrator 1562229953 Administrator 编号 int(11) 11 1 1 30516DCC-5A1C-41D7-A3A4-337141CE1100 用户ID user_id 1538029095 Administrator 1562229953 Administrator 用户ID NULL int(11) 11 ED1727C5-9BD8-4F1C-B2DD-BD3B530553B3 角色ID role_id 1538029095 Administrator 1562229953 Administrator 角色ID NULL int(11) 11 5E94411D-2780-4961-8DC6-3EE6CD37595D 创建人编号 creater_sn 1503543793 Administrator 1562228989 Administrator 创建人编号 varchar(22) 22 7377D3BD-4093-4D52-933C-A8C90845EB6B 创建时间 create_time 1480919323 Administrator 1562228989 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime D3E1A053-4242-46E8-B4C1-A1414D390FA1 修改人编号 moder_sn 1487662489 Administrator 1562228989 Administrator 修改人编号 varchar(22) 22 9981B22A-1A12-4C62-9C4B-F4A24306D9A7 修改时间 mod_time 1480919323 Administrator 1562228989 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 4D14EFFD-421F-4EB1-AC9D-57001BCF8DE4 时间戳 tstm 1503405883 Administrator 1562228989 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 4102F888-6321-4437-B7A7-DA6EAC21191A Key_1 Key_1 1538029095 Administrator 1538029095 Administrator 17E2A9B1-CA55-460C-8BF0-4A50A1C5F251 通用字典表 sys_macro 1538029095 Administrator 1562229023 Administrator auto_increment = 8 3B0E02BD-4AB6-49B5-9480-9DFFE5E6EF60 编号 id 1538029095 Administrator 1562229972 Administrator 编号 int(11) 11 1 1 95D3116E-1F7A-4A69-9513-E2088D71415D 父级id parent_id 1538029095 Administrator 1562229972 Administrator 父级id NULL int(11) 11 4A620BE8-9013-432A-B816-EB55B261E7A5 名称 name 1538029095 Administrator 1562228666 Administrator 名称 NULL varchar(50) 50 C4770826-B170-423D-9DBE-FC648282686E 值 value 1538029095 Administrator 1562228666 Administrator 值 NULL varchar(2000) 2000 F86B765D-1C99-49E5-9519-AECB1E1D2ED3 状态 status 1538029095 Administrator 1562228666 Administrator 状态，0：隐藏 1：显示 1 tinyint(4) 4 719DCD6B-F718-4E93-8AB0-4B8F54A5580E 类型 type 1538029095 Administrator 1562228666 Administrator 类型,0:目录，1:参数配置 NULL tinyint(20) 20 6758BAE4-8EBE-44A0-A5F1-97DFECEF67DA 排序 order_num 1538029095 Administrator 1562228666 Administrator 排序 NULL int(11) 11 355D9211-629F-4A0A-923E-9581A34B0B51 备注 remark 1538029095 Administrator 1562228666 Administrator 备注 NULL varchar(500) 500 92526CC2-266B-4EC6-A2AB-4CDAB82BCBA1 创建人编号 creater_sn 1503543793 Administrator 1562229023 Administrator 创建人编号 varchar(22) 22 D180CCCB-A0C6-4F0F-8488-A26745EA2A06 创建时间 create_time 1480919323 Administrator 1562229023 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime BD699926-6719-4870-A07B-3D01EE2CF6D5 修改人编号 moder_sn 1487662489 Administrator 1562229023 Administrator 修改人编号 varchar(22) 22 B72E2577-3498-498F-B899-8D3C01AEE4F1 修改时间 mod_time 1480919323 Administrator 1562229023 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 4F7EA8BB-1069-44F4-87FF-352738D4613A 时间戳 tstm 1503405883 Administrator 1562229023 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 3501B9CC-BF61-4A8A-BCE4-9D628BBF6651 Key_1 Key_1 1538029095 Administrator 1538029095 Administrator 2292AFC0-6E64-4CE6-AFFC-17E2AA94331D 系统配置信息表 sys_config 1538029095 Administrator 1562229000 Administrator auto_increment = 5 8CF5B6E8-544F-4394-BA92-F9788C821362 编号 id 1538029095 Administrator 1562229958 Administrator 编号 int(11) 11 1 1 722A3C6B-297B-453D-B86C-8CB505FA53FA key key 1538029095 Administrator 1538029095 Administrator key NULL varchar(50) 50 BCDCD75F-F7A3-45F3-A356-376478506346 value value 1538029095 Administrator 1538029095 Administrator value NULL varchar(2000) 2000 03B1960D-F935-4B21-AB95-4950EBB03F08 状态 status 1538029095 Administrator 1562228678 Administrator 状态 0：隐藏 1：显示 1 tinyint(4) 4 7A71E50D-A611-4089-877E-EA6CA0800E4C 备注 remark 1538029095 Administrator 1562228678 Administrator 备注 NULL varchar(500) 500 5605717D-1F6F-427D-8897-44983321A544 是否有效 is_valid 1546842924 Administrator 1562229000 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 91003D52-CFFD-4D5E-A4AC-70AA3BB52ECC 创建人编号 creater_sn 1503543793 Administrator 1562229000 Administrator 创建人编号 varchar(22) 22 FE2D5AEF-406C-4E7F-B300-504F8FCBFFCB 创建时间 create_time 1480919323 Administrator 1562229000 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 563BE2FD-8D87-413F-A779-F664C582393B 修改人编号 moder_sn 1487662489 Administrator 1562229000 Administrator 修改人编号 varchar(22) 22 FE03DC92-1B67-48FB-BD9F-F0EDF83A990D 修改时间 mod_time 1480919323 Administrator 1562229000 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 2257FC55-A260-4B1F-B540-A6AAA96560D0 时间戳 tstm 1503405883 Administrator 1562229000 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 9E98F3FB-6F42-40B7-A964-B470B60783D9 Key_1 Key_1 1538029095 Administrator 1538029095 Administrator FC2BBE1C-E84E-4D83-A160-A487C8BA60F3 key key 1538029095 Administrator 1538029095 Administrator key {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,57={D1C795B8-8F7B-4AA7-A240-85C5B737C543},ExtUnique,4=true A1F37D6C-673B-453F-994F-44B1D6C38DB6 官网首页背景图内容表 emt_home_background 1546842924 Administrator 1563261989 Administrator 官网首页背景图内容表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact 60715989-7149-443B-9BF2-3F082A2510E9 编号 home_backg_id 1546842924 Administrator 1562730176 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 8CA731A7-E164-428A-9B69-30AB4EE6A0F5 背景图片url home_backg_url 1546842924 Administrator 1562730176 Administrator 背景图片url varchar(225) 225 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 A39C0D52-5A36-45C3-86D6-12D7C186609C 背景图片名称 home_backg_name 1546842924 Administrator 1562730176 Administrator 背景图片名称 varchar(64) 64 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 3A40FA85-EBB2-4721-A176-F1052662ACBA 背景图片内容 home_backg_content 1546842924 Administrator 1562730176 Administrator 背景图片内容 varchar(10000) 10000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 47983EAD-7A4F-4022-8BC6-D07299340EB3 排序 sort_order 1546941249 Administrator 1562729945 Administrator 排序 int(11) 11 C7F8D20E-07EE-41C6-B92B-27C1ABC6C184 是否有效 is_valid 1546842924 Administrator 1562729945 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 966AD4D7-48BC-4502-BE4D-D06CBDAF2CA0 创建人编号 creater_sn 1503543793 Administrator 1562729945 Administrator 创建人编号 varchar(22) 22 9A3EB0E0-C27E-494D-B036-BDD320ECAF44 创建时间 create_time 1480919323 Administrator 1562729945 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime C3479D72-EAC9-40DF-9C8A-BD986C42C827 修改人编号 moder_sn 1487662489 Administrator 1562729945 Administrator 修改人编号 varchar(22) 22 EC04CE91-4E46-4553-809D-97689CEF7211 修改时间 mod_time 1480919323 Administrator 1562729945 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime E2C7BFC5-91B1-470B-A6F0-DA1E003F8242 时间戳 tstm 1503405883 Administrator 1562729945 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 03B62EEB-F52E-4E6F-A3D8-2C882FC167F3 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator A05D77C7-7E59-4F12-91C5-C4D4E5BC4BA2 发展历程表 emt_deve_course 1546842924 Administrator 1562827745 Administrator 发展历程表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact F666750B-2A54-40EE-BEBA-7D201E7B9BDA 编号 deve_course_id 1546842924 Administrator 1562827745 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 51A39F4A-C995-4B66-B264-1AC9F7C43EF9 历程年份 deve_course_year 1538029095 Administrator 1562827745 Administrator 历程年份 0 varchar(22) 22 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 842E5563-CA7A-402D-AC74-2D26C5413452 发展历程内容描述 deve_course_content 1546842924 Administrator 1562827745 Administrator 发展历程内容描述 varchar(10000) 10000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 2DDD5744-C509-4F68-B00E-F9BBB78C8132 排序 sort_order 1546941249 Administrator 1562827603 Administrator 排序 int(11) 11 105692F8-B615-4E79-A60D-CB328E5FACAF 是否有效 is_valid 1546842924 Administrator 1562827603 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 E3D578CB-5BB1-4DCA-833B-A1D8D072307D 创建人编号 creater_sn 1503543793 Administrator 1562827603 Administrator 创建人编号 varchar(22) 22 86D07D7E-5AB3-40C3-B354-43B0D423BE9E 创建时间 create_time 1480919323 Administrator 1562827603 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 58C62897-87FC-4FB4-905D-686BDED632EB 修改人编号 moder_sn 1487662489 Administrator 1562827603 Administrator 修改人编号 varchar(22) 22 ADE95E3F-07AA-4364-9B1F-F500489360B8 修改时间 mod_time 1480919323 Administrator 1562827603 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime CDAED9D5-1DCD-4804-8FEC-6B5170F9DCEE 时间戳 tstm 1503405883 Administrator 1562827603 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 84102214-0BEE-47A0-B1D2-108AC78079BD Key_1 Key_1 1546842924 Administrator 1546842924 Administrator 7C2CD6D0-056A-456F-9E60-4473AF21C3D5 荣誉资质表 emt_honor_cert 1546842924 Administrator 1562828467 Administrator 荣誉资质表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact F3D9E58A-B799-4668-AEEA-E4080E9CB779 编号 honor_cert_id 1546842924 Administrator 1562828467 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 09CB0BE2-C597-486B-9656-71FD9AC18E0D 资质年份 honor_cert_year 1538029095 Administrator 1562828467 Administrator 资质年份 0 varchar(22) 22 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true D3DE49DB-EF04-4815-BECC-A2EB3B83AD1A 荣誉资质图片 honor_cert_url 1546842924 Administrator 1562828467 Administrator 荣誉资质图片 varchar(256) 256 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 F45E8C0A-3E5C-47FE-9ED0-AD3E3C75A9BA 排序 sort_order 1546941249 Administrator 1562827794 Administrator 排序 int(11) 11 4ED23F89-F2D3-488B-993B-FF1CFB3E6C6A 是否有效 is_valid 1546842924 Administrator 1562827794 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 9A2565AB-AEE4-4459-B2E1-33160D90A94B 创建人编号 creater_sn 1503543793 Administrator 1562827794 Administrator 创建人编号 varchar(22) 22 28BD8622-608A-471E-AB72-555D24BC256A 创建时间 create_time 1480919323 Administrator 1562827794 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 5ACF6271-98B0-4AA1-BE6B-16E701502127 修改人编号 moder_sn 1487662489 Administrator 1562827794 Administrator 修改人编号 varchar(22) 22 641725C6-8767-4915-A83D-92DC331F4727 修改时间 mod_time 1480919323 Administrator 1562827794 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime C7008CD8-DB0D-445F-94FC-0BF6CF267CFE 时间戳 tstm 1503405883 Administrator 1562827794 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime 0F34B611-049E-485D-849A-1CE9E229B101 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator CF7242C3-A084-4DE4-82AD-7A8AB3C1D7CA 应聘表 emt_apply 1546842924 Administrator 1562829948 Administrator 应聘表 ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact AD073D93-5FBB-45C0-B1B3-C6E756C0D45B 编号 apply_id 1546842924 Administrator 1562829948 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true CA07BA34-BAA5-4D77-8E43-BFC5FF325392 招聘id recruitment_id 1538029095 Administrator 1562829948 Administrator 招聘id 0 int(11) 11 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 2F86BB87-D30C-43A4-BDA0-E51938D5304C 应聘人姓名 apply_cus_name 1562829302 Administrator 1562829948 Administrator 应聘人姓名 varchar(64) 64 519C4449-F075-4038-B40A-9CB3F0FC7597 应聘人邮箱 apply_cus_email 1562829302 Administrator 1562829948 Administrator 应聘人邮箱 varchar(64) 64 26B8CCCA-A8BB-40BC-8FBA-14BD548509FF 应聘人电话 apply_cus_phone 1562829302 Administrator 1562829948 Administrator 应聘人电话 varchar(64) 64 AFD059F3-4C70-4118-8563-3BEFE98B2AD8 应聘人简历文件下载地址 apply_cus_resume 1562829302 Administrator 1562830007 Administrator 应聘人简历文件下载地址 varchar(256) 256 0C2E5158-B448-4838-B479-E11C49B49FFB 排序 sort_order 1546941249 Administrator 1562829729 Administrator 排序 int(11) 11 53DDC9C2-572E-4773-8B84-7B72B180B833 是否有效 is_valid 1546842924 Administrator 1562829729 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 33D8DB9E-76F2-45A7-8FE7-F260836F6881 创建人编号 creater_sn 1503543793 Administrator 1562829729 Administrator 创建人编号 varchar(22) 22 9635AEC8-DB31-45EC-A3B2-7149F3A2ED72 创建时间 create_time 1480919323 Administrator 1562829729 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime E1CD0909-3D61-4955-B88E-39160934BD43 修改人编号 moder_sn 1487662489 Administrator 1562829729 Administrator 修改人编号 varchar(22) 22 79A4B6D2-62EC-46DF-892E-8C12278D494F 修改时间 mod_time 1480919323 Administrator 1562829729 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 292E38C6-F368-4655-A1BC-E763B675152E 时间戳 tstm 1503405883 Administrator 1562829729 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime BEFF686B-362B-4FCC-A554-A19FFCB6E0AE Key_1 Key_1 1546842924 Administrator 1546842924 Administrator 19E89851-1B98-431F-834D-305FD235862D 官网二级导航栏内容展示表 emt_child_navi_content 1546842924 Administrator 1563261693 Administrator 官网二级导航栏内容展示表（包括菜单e码头、业务中心、支持与服务） ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '平安支付回执信息' ROW_FORMAT = Compact 4AC31F6D-EAF6-4881-8790-0ECB2E0BCDE3 编号 child_navi_content_id 1546842924 Administrator 1563261693 Administrator 编号 int(11) 11 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true 43B9F955-1B6F-43C4-AC2E-AF3D3EEBCFC0 首页导航栏菜单id navi_menu_id 1538029095 Administrator 1563261721 Administrator 首页导航栏菜单id（只包括e码头、业务中心、支持与服务的子菜单） 0 int(11) 11 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={4A2BD2F3-4A8A-4421-8A48-A8029BDA28E8},Unsigned,4=true A5945638-C602-4B22-8C34-6E09BDD8DA64 展示内容 child_navi_content 1546842924 Administrator 1563261693 Administrator 展示内容 varchar(10000) 10000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 E346559B-B4E0-4637-AB7A-8C20EB380394 排序 sort_order 1546941249 Administrator 1563261067 Administrator 排序 int(11) 11 10FE12C6-81BD-485C-9FE4-4377F2383EBC 是否有效 is_valid 1546842924 Administrator 1563261067 Administrator 是否有效 1：是，0：否 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 4200C7CB-4E09-4522-890E-1118AD79C2E5 创建人编号 creater_sn 1503543793 Administrator 1563261067 Administrator 创建人编号 varchar(22) 22 EED57AF0-E52F-4AED-AFF5-6464C90767D9 创建时间 create_time 1480919323 Administrator 1563261067 Administrator 创建时间,yyyy-MM-dd HH:mm:ss datetime 630701DD-9B8D-4E7D-AE0E-1312A0F158FD 修改人编号 moder_sn 1487662489 Administrator 1563261067 Administrator 修改人编号 varchar(22) 22 85D8D953-D73C-49EE-8765-717C5AFA681F 修改时间 mod_time 1480919323 Administrator 1563261067 Administrator 修改时间,yyyy-MM-dd HH:mm:ss datetime 361AFC65-6D96-4F1E-94EC-57981D924B71 时间戳 tstm 1503405883 Administrator 1563261067 Administrator 时间戳 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP datetime EFF17BCA-DF60-432F-9907-2854FA6AFD15 Key_1 Key_1 1546842924 Administrator 1546842924 Administrator C969ADD6-F5AF-48E8-983B-C47E4009F8D1 PUBLIC PUBLIC 1561947603 Administrator 1561947603 Administrator 426EBF0C-05BC-47EA-8AD0-66FAEA9826F8 MySQL 5.0 MYSQL50 1561947603 Administrator 1561947603 Administrator file:///%_DBMS%/mysql50.xdb F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 1276524678