00000000-0000-0000-0000-000000000000 6826959D-4043-4DEF-A539-29F0F677EBA1 j-wms-center j-wms-center 1599729022 anyx 1599805186 anyx [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 DeploymentMode=REP [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=Yes 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=Yes 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=Yes Foreign key=Yes Alternate key=Yes 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 SynchroCode=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\AREA] [ModelOptions\Physical Objects\ClssNamingOptions\AREA\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\AREA\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= D:\PhysicalDataModel_1.pdm E64ED89A-DC73-4A52-B29D-A10121F4E535 MySQL 5.0 MYSQL50 1599729020 anyx 1599729020 anyx F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B DC056F6C-BC72-4AB8-BB9F-F2264D858112 91系统权限 91系统权限 1599729022 anyx 1599805105 anyx [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=800 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 Area.IconPicture=Yes Area.Stereotype=Yes Area.Comment=No Area.TextStyle=No Area.SubSymbols=Yes Area_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Area 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="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> 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> ExtDpdShowStrn=Yes ExtendedDependency_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" 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\AREA] 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=9600 Height=8000 Brush color=253 249 234 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=16 Brush gradient color=245 230 173 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 121 98 6 Shadow color=192 192 192 Shadow=0 [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 Source Arrow=24 Center Arrow=24 Target Arrow=7 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\USRDEPD] CENTERFont=新宋体,8,N CENTERFont color=0 0 0 Line style=1 Source Arrow=24 Center Arrow=24 Target Arrow=7 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\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 Source Arrow=24 Center Arrow=24 Target Arrow=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 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 Source Arrow=24 Center Arrow=24 Target Arrow=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 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0 0 0 Line style=0 Source Arrow=24 Center Arrow=24 Target Arrow=24 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 -1 ((-54535,21945), (-38985,53887)) 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 ((-36372,-33391), (-20822,-21245)) 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 ((39372,2675), (54535,18945)) 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 ((-17822,-32566), (-2272,-21245)) 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 ((728,-31742), (16278,-21245)) 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 ((1115,1848), (16278,18943)) 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 ((1115,34316), (16665,53885)) 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 ((19665,35140), (35215,53885)) 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 ((36282,-14946), (51445,-1975)) 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 ((-39460,-46063), (-24297,-37216)) 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 ((-54533,-18245), (-39370,-1975)) 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 ((-40619,-53887), (-31635,-49888)) 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 ((-54535,1025), (-38985,18945)) 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 ((26241,-41215), (37929,-37216)) 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 ((38215,35140), (53765,53885)) 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 ((727,-15771), (14732,-1975)) 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 ((-28635,-53887), (-19651,-49888)) 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 ((19278,-31742), (34441,-21245)) 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 ((-2363,-43588), (7780,-37216)) 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 ((-35985,1848), (-20435,18943)) 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 ((40929,-41215), (52617,-37216)) 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 ((-17434,-15771), (-2271,-1975)) 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 ((-21299,-45238), (-5363,-37216)) 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 ((-35985,27718), (-20435,53885)) 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 ((37441,-30917), (50674,-21245)) 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 ((19278,2675), (36372,18945)) 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 ((-16651,-53887), (-7667,-49888)) 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 ((-17435,32666), (-1885,53885)) 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 ((-36372,-15771), (-20436,-1975)) 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 ((-54533,-46888), (-42460,-37216)) 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 ((-54533,-34216), (-39370,-21245)) 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 ((-17435,1848), (-1885,18943)) 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 ((17732,-14946), (33282,-1975)) 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 ((-54535,-53887), (-43619,-49888)) 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 ((10780,-41215), (23241,-37216)) 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 ((-4667,-53887), (4317,-49888)) 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 768B03B9-1FAC-4F53-A224-C987AB9CC9E2 70货主模型 70货主模型 1599805173 anyx 1599805186 anyx [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=800 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 Area.IconPicture=Yes Area.Stereotype=Yes Area.Comment=No Area.TextStyle=No Area.SubSymbols=Yes Area_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Area 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="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> 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> ExtDpdShowStrn=Yes ExtendedDependency_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" 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\AREA] 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=9600 Height=8000 Brush color=253 249 234 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=16 Brush gradient color=245 230 173 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 121 98 6 Shadow color=192 192 192 Shadow=0 [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 Source Arrow=24 Center Arrow=24 Target Arrow=7 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\USRDEPD] CENTERFont=新宋体,8,N CENTERFont color=0 0 0 Line style=1 Source Arrow=24 Center Arrow=24 Target Arrow=7 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\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 Source Arrow=24 Center Arrow=24 Target Arrow=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 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 Source Arrow=24 Center Arrow=24 Target Arrow=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 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0 0 0 Line style=0 Source Arrow=24 Center Arrow=24 Target Arrow=24 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 385421FB-A6FF-410C-90CD-4323890645C1 j-wms-center j-wms-center 1599804378 anyx 1599804378 anyx 90908B03-46A0-4782-BB23-A0F0D88F91A6 b_config_sender b_config_sender 1599804378 anyx 1599804378 anyx 1244E5EA-21DD-4856-B53F-327E6E149121 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D92BF107-20CF-4B09-ABD7-E735D1398E01 code code 1599804378 anyx 1599804378 anyx varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EB65A784-F559-4566-94A4-1223C9936760 warehouse_id warehouse_id 1599804378 anyx 1599804378 anyx 仓库 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 464D0B65-22FD-4592-B421-47C4DFB4FA71 warehouse_code warehouse_code 1599804378 anyx 1599804378 anyx 仓库代码 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F185B3A4-367B-4159-AD0D-F798B936C7E7 warehouse_name warehouse_name 1599804378 anyx 1599804378 anyx varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7E954E87-2193-4080-BDA5-229B5C3767AB shipway_code shipway_code 1599804378 anyx 1599804378 anyx varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 620709CD-574A-464E-8ADB-6B2CFB9FB216 shipway_name shipway_name 1599804378 anyx 1599804378 anyx varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true DB7999F2-B6AA-4444-B7BE-EFC2EFA2BF67 customer_id customer_id 1599804378 anyx 1599804378 anyx varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 346D1C8F-38D5-4ABA-B469-C20966DAE79F customer_code customer_code 1599804378 anyx 1599804378 anyx varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 40AA2B7B-6807-4F8C-9E8F-A43540AD843A company company 1599804378 anyx 1599804378 anyx 寄件公司名 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3FD7AB93-6BBF-47D7-B39D-F336B008E657 name name 1599804378 anyx 1599804378 anyx 联系人名 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D043ECDD-D8CD-49B8-A1FB-FEDCBE6E7909 address_line1 address_line1 1599804378 anyx 1599804378 anyx 街道地址1 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F9800D35-4154-41A8-AC1E-09613FBD82C5 address_line2 address_line2 1599804378 anyx 1599804378 anyx 街道地址2 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 805ED247-0982-4A91-AD16-03BCA5B62491 province province 1599804378 anyx 1599804378 anyx 省份 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5C188273-AE5D-4139-8B71-655C3DA8DB47 city city 1599804378 anyx 1599804378 anyx 城市 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9814E5D4-3B1E-4970-857C-85CC1499E2DF county county 1599804378 anyx 1599804378 anyx 县城 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2EDC7C53-8AAD-4080-8F2D-8E26D5E3DB8D postal_code postal_code 1599804378 anyx 1599804378 anyx 邮编 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 26E036CA-34E2-4796-8465-AA73FB06BC66 country_code country_code 1599804378 anyx 1599804378 anyx 国家代码 varchar(10) 10 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6FD67859-4F66-4631-81F7-FB0F13DED7EE country_name country_name 1599804378 anyx 1599804378 anyx 国家名称 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 82BFBFDA-78E4-4ED5-AD8B-30CE5D1FE37E email email 1599804378 anyx 1599804378 anyx 邮箱 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 011AEBB5-0B78-4001-B69F-64993B286076 mobile_number mobile_number 1599804378 anyx 1599804378 anyx 手机号码 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 136EAF9D-757D-46DC-B5E8-B66E204CD90C phone_number phone_number 1599804378 anyx 1599804378 anyx 电话号码 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 15EF1FC4-A965-4328-944F-8F89D40B6C54 identity_number identity_number 1599804378 anyx 1599804378 anyx 身份证号码 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C6A601F4-E215-4609-A7CF-DCF2752B38EA extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F42C63DE-F4B5-4626-9C47-C88D8ACDE356 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 419CC855-9C87-4CBD-82F5-877930F17372 extend3 extend3 1599804378 anyx 1599804378 anyx 预留字段3 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EC855F4C-5F94-48F0-989B-BF7454C5B299 extend4 extend4 1599804378 anyx 1599804378 anyx 预留字段4 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6C2313A9-B82A-487C-A818-230E5E0F2421 extend5 extend5 1599804378 anyx 1599804378 anyx 预留字段5 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8E27486E-D2EF-446C-95F5-F7FDA11C8211 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 00B148B5-C189-4BDE-AB9E-D59F51521D70 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B034D35D-65A6-45F1-8916-4168160DF684 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 489F0C29-D605-4FD9-A344-972CC3016E80 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 8B7CB3DA-9113-4ABF-AE7E-BA05A4BCD9F0 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B332AE02-46E3-44C1-BA90-46FA3825004D update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2E921F7A-B085-45E8-84E0-AEBCF6348A7A is_default is_default 1599804378 anyx 1599804378 anyx ~N~ varchar(1) 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 16D4EC2B-325D-41E9-8238-F07F068AEE48 instance_code instance_code 1599804378 anyx 1599804378 anyx WMS实例代码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6E1C54F6-BDE7-40CB-B0B1-D445B7C25B9B instance_name instance_name 1599804378 anyx 1599804378 anyx WMS实例名称 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true DC024D7A-72AA-401A-8C6A-9850A20582EB PK_b_config_sender PK_b_config_sender 1599804378 anyx 1599804378 anyx PK_b_config_sender B728D256-D7AA-4631-81AB-E28B81D8D2DB b_country b_country 1599804378 anyx 1599804378 anyx D70B991E-D9E1-4981-A658-209BB829D64F id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3205AD37-2F54-4740-B2B1-73DD30B99AA3 code code 1599804378 anyx 1599804378 anyx 2位英文代码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 03460094-6A99-486B-8F4C-DEF81E02D656 code_l3 code_l3 1599804378 anyx 1599804378 anyx 3位英文代码 varchar(22) 22 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7AAAE7A0-9AFE-4426-9BCB-EF93088A4DC3 name_cn name_cn 1599804378 anyx 1599804378 anyx 中文名 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 16D049C1-421E-4458-A287-B7A8D95E77B4 name_en name_en 1599804378 anyx 1599804378 anyx 英文名 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 448A701B-9798-4D92-8CE5-63DFE23DE9C4 phone_area_code phone_area_code 1599804378 anyx 1599804378 anyx 电话区号 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E9C3C320-EF98-4092-9C69-771BC0E4EC30 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime DC26A458-01EE-4CCF-8C77-00557CAD6D62 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E3E1390D-1E9F-4DD2-B091-C8E6F0DD2378 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8F5159ED-F103-451A-BE77-E7B7F3842F76 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 62CC008F-F1E3-403E-BB38-0E51CD368137 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CAC9AB21-A561-4A72-BC08-35CED1B791CF update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3B4AE752-44A0-448B-BDB8-FC8570043D76 sort sort 1599804378 anyx 1599804378 anyx 序号 0 int(11) 11 1 4750F5B9-2AF2-4938-8884-075CD66C8246 PK_b_country PK_b_country 1599804378 anyx 1599804378 anyx PK_b_country 63A19AFA-16F3-484F-8120-A2AB01D09A2B b_country_region b_country_region 1599804378 anyx 1599804378 anyx 881F4E59-3D3C-4870-A439-7EA8D9FE9B51 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9AB6E408-ADBE-4396-AD3E-A8BFD3A3AEC7 parent_id parent_id 1599804378 anyx 1599804378 anyx 父级别id varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 54C01FCA-BF37-432A-9DD8-2897B5979A07 country_code country_code 1599804378 anyx 1599804378 anyx 国家代码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true DA2AA980-0806-4C18-A2EE-8B6D5D144E43 name_en name_en 1599804378 anyx 1599804378 anyx 地区名称英文 varchar(80) 80 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true BE35DD8B-12CD-438F-9E58-7C035EC90601 name_cn name_cn 1599804378 anyx 1599804378 anyx 地区名称中文 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CEEFCCC9-AF52-4A4A-B49E-7C75BE09F5EC level level 1599804378 anyx 1599804378 anyx 级别 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A70B55EB-9D06-4E79-9AB0-BDF60338E36A level_name level_name 1599804378 anyx 1599804378 anyx 级别名 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0B990191-64D5-4FC4-9D1C-434C1FE39291 zip_code zip_code 1599804378 anyx 1599804378 anyx 邮编 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8901931B-8B33-431F-844D-89C7D6CB9403 sort_no sort_no 1599804378 anyx 1599804378 anyx int(11) 11 1087D7A6-A494-45EB-968E-E48CFC6D388D remark remark 1599804378 anyx 1599804378 anyx 备注 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 100A2F72-71F0-483F-AB57-00234D3AE2C3 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6E4BCA47-E4EE-4D2B-9057-75407DCCAE68 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 46987C29-1631-4A95-884A-0F82275348B1 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 56FE17A7-A8B0-4CB2-BAB3-692C5905157B created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A27AFB9E-888A-4AE8-A320-A66D1549E528 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 03D75A97-CF88-4B7F-8227-AC5160B5770C update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 67EFA9B9-9AFD-4301-9CFA-3113E66E32EE update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D69E77B4-6127-47AA-BE03-59CB1551897B update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5577E57F-C058-4402-8354-400719038E1E PK_b_country_region PK_b_country_region 1599804378 anyx 1599804378 anyx PK_b_country_region DC773E28-5765-477A-B730-2EB3F1F000DF index_level index_level 1599804378 anyx 1599804378 anyx 0CC5D818-FE54-4EFC-AF62-25B37DCCDFE1 1599804378 anyx 1599804378 anyx 20F18A4C-B442-4220-9C9E-99BB99838CB9 index_parent_id index_parent_id 1599804378 anyx 1599804378 anyx F79A9C59-67ED-4E2A-899A-D702E3CA903C 1599804378 anyx 1599804378 anyx 73763411-9B62-4884-8554-98BC4CB16BF8 b_dict_item b_dict_item 1599804378 anyx 1599804378 anyx 225530DB-338E-43EF-B0FE-32C55059BE96 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 99630224-EE5F-484E-BB3E-A94D4BA5A3AA type_code type_code 1599804378 anyx 1599804378 anyx 字典类型码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9D9FC9E5-14E6-4F2F-A366-48DCE497DA30 code code 1599804378 anyx 1599804378 anyx 字典条目代码 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4C94239A-0B10-4478-BC2F-C5F7ECDF5B14 value value 1599804378 anyx 1599804378 anyx 字典名/值 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B8C23DB8-0C49-4A56-9800-6DD7EBC98839 sort sort 1599804378 anyx 1599804378 anyx 序号 0 int(11) 11 1 CA606E9A-13B1-4072-A40D-B1968BB85710 remark remark 1599804378 anyx 1599804378 anyx 备注 varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 50B64BBC-1703-4525-B134-F7211AE60189 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 633D48FE-D76A-4CC8-B602-0A79F4302133 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E9E58966-212C-4181-B3E3-0A4E993C284F created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 916D2432-B044-4AF7-97C2-B8ED704EA54D update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime F874AABD-866A-43B5-A223-933BDFBDD7B9 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 491D41FE-F493-417E-8340-756D9CAB6801 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 850D42DA-341F-4F18-9EFD-2794B5916797 code code 1599804378 anyx 1599804378 anyx code 688E2923-08AD-4B55-9114-4393EE2E5567 PK_b_dict_item PK_b_dict_item 1599804378 anyx 1599804378 anyx PK_b_dict_item B7E2C8C5-A15E-4B35-B478-96465CFBC60F b_dict_type b_dict_type 1599804378 anyx 1599804378 anyx F1BBA2A6-526C-4687-94E4-ED3D45330A22 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D578F58D-C76E-42F3-B7F6-090E16F6BD7A code code 1599804378 anyx 1599804378 anyx 字典类型码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CFBA015A-A5AC-4F0E-A02E-233749E24AF5 name name 1599804378 anyx 1599804378 anyx 字典类型名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3D262234-4DD4-422A-BBD7-E1136837B8F9 status status 1599804378 anyx 1599804378 anyx 状态 0:未启用, 1:已启用 1 int(11) 11 1 2AB97612-8C52-4AB5-9EA2-3C1EF4AFC607 remark remark 1599804378 anyx 1599804378 anyx 备注 varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1926956D-754A-4C77-9788-43C17D6317CE created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 D714D6B2-7113-46DB-9AF9-48A5ECF583BB created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7BD83FFE-F3D8-4347-BCEE-FAF67790E63C created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5E5C31A8-9CBA-4B78-90BF-23DD066C4118 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 09212A5F-4773-4803-8E39-AFDA4F2077F5 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1F19B1D7-6880-4913-A1B6-CD32940889AD update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AA11B13F-4E63-42A6-9F04-C8235696D8E1 code code 1599804378 anyx 1599804378 anyx code 4B907ABB-DC2D-46BC-BC87-6E9D92B223EF PK_b_dict_type PK_b_dict_type 1599804378 anyx 1599804378 anyx PK_b_dict_type 30406B51-F489-4DB7-9666-C71F36FDE267 b_shop b_shop 1599804378 anyx 1599804378 anyx 9CCC20DD-437B-4472-8767-9D93ECA04C7D id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0BE30E0C-1468-4A0F-AD89-2EC7C8CC514C instance_code instance_code 1599804378 anyx 1599804378 anyx 实例代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6F19F9C0-A5EC-4330-90CF-110031D43EC5 instance_name instance_name 1599804378 anyx 1599804378 anyx 实例名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0A5CD88A-46C7-4C65-9291-B80B2BA574DF code code 1599804378 anyx 1599804378 anyx 门店代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3DA1F799-D34B-49B6-B970-C9FB2DB96E0D name name 1599804378 anyx 1599804378 anyx 门店名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4ADF0C2C-82A3-4690-9E78-035310464E18 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 A21CCE72-5E99-407B-9AB4-CCB2D3CEFD4F created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 35D5C23A-A0F1-42D6-A7AB-28602B7E5399 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 26C0F44B-7C36-4A8E-A8EC-629FE0C50119 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 3CE670D1-ABE8-4EE2-BB3D-7FEEED7EDE77 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D10E894A-3431-49C6-8E2F-64F3370144E7 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C8032EBE-9CE0-4744-A691-8ACD0A173DB3 admin_code admin_code 1599804378 anyx 1599804378 anyx (管理员)用户代码-用于登录 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 23163BCA-CEAF-4D45-A2C7-109B1D8C313A admin_name admin_name 1599804378 anyx 1599804378 anyx 管理员用户名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1C972938-D41A-4142-94A0-9E1D83BA7D7D admin_password admin_password 1599804378 anyx 1599804378 anyx 登录密码- md5值 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 58421E70-2ADA-4E3C-8780-DFB79E57DA40 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 579E9339-621C-409A-A794-7E0E99D9842D extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2C333B34-463C-49E9-82E5-925D5378EA9C extend3 extend3 1599804378 anyx 1599804378 anyx 预留字段3 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 149A307E-98EF-4BC6-A740-81FAA36775D0 extend4 extend4 1599804378 anyx 1599804378 anyx 预留字段4 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EC2393BF-0904-4547-B609-BD898B940DA5 extend5 extend5 1599804378 anyx 1599804378 anyx 预留字段5 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 608EBEB6-2C9C-4D43-A8C0-04E0DCCC2D44 index_code index_code 1599804378 anyx 1599804378 anyx index_code 1C905FF6-9006-43DF-88CA-B8B8E9DE1D11 PK_b_shop PK_b_shop 1599804378 anyx 1599804378 anyx PK_b_shop C275F1D1-E42B-4B5E-999F-12846B6E2D71 b_warehouse b_warehouse 1599804378 anyx 1599804378 anyx 54D164BE-E1D5-4AA9-96ED-F8212EDFCB2E id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E819B47B-26F0-46AC-879A-C5519CDB10B7 instance_code instance_code 1599804378 anyx 1599804378 anyx 实例代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6D50DAAE-2B36-4295-860C-9685B2937909 instance_name instance_name 1599804378 anyx 1599804378 anyx 实例名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EFCC1250-B491-4542-B5A1-C4880AE87B0C code code 1599804378 anyx 1599804378 anyx 仓库代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 662FF584-E402-4C14-BB03-305A05BC524C name name 1599804378 anyx 1599804378 anyx 仓库名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9E159672-ABBC-4BDF-8D6F-729458475720 type_code type_code 1599804378 anyx 1599804378 anyx 类型代码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 35B2BA40-1654-4870-A733-92D7CB64C684 type_name type_name 1599804378 anyx 1599804378 anyx 类型名称 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9C83B8A9-7D25-47DA-9CBF-3A2B984C3AF1 length length 1599804378 anyx 1599804378 anyx 长度,米 0.000 double(11,3) 11 3 1 AC98FAE3-A327-478E-8BBC-04FAB38D2703 width width 1599804378 anyx 1599804378 anyx 宽度,米 0.000 double(11,3) 11 3 1 DA4769A2-9FA8-4062-A228-A67CC944F002 height height 1599804378 anyx 1599804378 anyx 高度,米 0.000 double(11,3) 11 3 1 D741B24B-2524-4368-9A24-4B1DBA8F73F6 square_meter square_meter 1599804378 anyx 1599804378 anyx 平方米;非计算,由用户自己输入 0.000 double(11,3) 11 3 E82D8F72-70EC-41CF-957A-5878282FB6A9 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 C22B62A9-9D8B-4D34-BA3C-607F2F887E1D created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3B13911D-743C-4283-97FF-151F72F8E3E2 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6D55B1D2-5C1B-4E7A-9F9D-5263E82B0044 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 97F19E0A-8A4F-4F9D-AD1F-1F8D86B7A628 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0DDDCF8D-62CC-4721-9385-B36CF3CBE59A update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 342AC78B-9B42-4392-8054-BC422ACF56C0 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F43B7D19-79D1-493C-A405-6865AFE9A5A4 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true DBF6D0F8-CB57-42D5-8C46-64BCC2627B06 extend3 extend3 1599804378 anyx 1599804378 anyx 预留字段3 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C8BB9D38-402B-447F-A987-5BC25300AED0 extend4 extend4 1599804378 anyx 1599804378 anyx 预留字段4 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4A2603E1-626D-4186-AEA8-EF19DEE3F54F extend5 extend5 1599804378 anyx 1599804378 anyx 预留字段5 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 23ED1D92-95CE-48DA-8CEE-84189817B7DF index_code index_code 1599804378 anyx 1599804378 anyx index_code 57EFD590-0C10-41F1-AADD-9F6B08AC82A0 PK_b_warehouse PK_b_warehouse 1599804378 anyx 1599804378 anyx PK_b_warehouse E59112AB-B99D-41BD-B051-89AB84A2B1CC b_warehouse_address b_warehouse_address 1599804378 anyx 1599804378 anyx CAEB81F8-125C-495C-B529-2935AC26BCAF id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B957F086-5FF3-4ABF-B819-4A67223CFAA0 warehouse_id warehouse_id 1599804378 anyx 1599804378 anyx 仓库id varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9C38A1A8-5C14-4A4C-8CC3-E0585EBD612B warehouse_code warehouse_code 1599804378 anyx 1599804378 anyx 仓库代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F6904C9E-5D0C-4714-941A-A08BFF02A1D1 country_code country_code 1599804378 anyx 1599804378 anyx 国家代码 varchar(10) 10 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C4B718B0-7552-473A-AC44-DC3F98817B67 country_name country_name 1599804378 anyx 1599804378 anyx 国家名称 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D334F635-E82E-4896-8E4A-0A074B10D874 province province 1599804378 anyx 1599804378 anyx 省份/州 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AC0DC2F1-48BA-4255-B4B9-C170DA497AAD city city 1599804378 anyx 1599804378 anyx 城市 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7AB9D639-4D97-4564-A232-14B496BD372C county county 1599804378 anyx 1599804378 anyx 县城/区 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B46B4FCE-97DC-4B4C-AC1B-E47C89F4F342 address address 1599804378 anyx 1599804378 anyx 仓库地址详情 varchar(500) 500 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E187720B-9A99-44DC-8EF4-6312A0BB4A25 postal_code postal_code 1599804378 anyx 1599804378 anyx 邮编 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7E92F996-4A91-4D42-B54E-132491789001 contact_name contact_name 1599804378 anyx 1599804378 anyx 联系人名 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 45EC0AE1-C92F-4CD2-8355-7320F77EF45F phone_number phone_number 1599804378 anyx 1599804378 anyx 联系人电话号码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 37C09451-293B-4444-B7DE-9C0FA8E1ED53 mobile_number mobile_number 1599804378 anyx 1599804378 anyx 联系人手机号码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C26A7864-6E4C-4A75-92F7-839348AB7518 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 4F338402-6D47-4205-BECB-FDFBBAEB16A5 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E6D2DE0E-42EA-454F-8DA6-7B58171D7634 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B8CAD956-2640-4C80-8D77-502D9A7CEF09 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 2D309325-9437-4625-AA9B-1D28E6783F7B update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2D052167-7D41-4E1A-8027-723E27F06E73 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C417C2CF-86F3-4098-AE00-3115DA117440 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 187A7AF2-28D8-42EB-A83B-F6CAEA797FBD extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EBED8978-97AE-4469-93D6-C889CB205880 PK_b_warehouse_address PK_b_warehouse_address 1599804378 anyx 1599804378 anyx PK_b_warehouse_address EFF9146E-D03F-4B57-ABA1-B59D4DCD1370 b_warehouse_type b_warehouse_type 1599804378 anyx 1599804378 anyx C5A2E428-1812-4992-BA00-B7BFAAF880FC id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EA660FF7-F32A-4183-A313-6B4432D087BF code code 1599804378 anyx 1599804378 anyx 类型代码;物料仓,恒温仓,虚拟仓,奢侈品仓等. 由客户自定义 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 96E45B38-4890-4931-BD89-BE01F1E0BB7C name name 1599804378 anyx 1599804378 anyx 类型名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3BDCAEED-7A7D-496C-9986-F2431E169C54 sort sort 1599804378 anyx 1599804378 anyx 排序号 0 int(11) 11 A4C087F0-46AE-4A5B-8CF6-1A2382A34D9B is_enable is_enable 1599804378 anyx 1599804378 anyx 是否启用(Y/N) varchar(2) 2 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 55928285-BFFB-4020-96C2-578BFDBBA448 is_enable_name is_enable_name 1599804378 anyx 1599804378 anyx 是否启用名字 varchar(2) 2 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4F3CEC76-A3A3-4D5A-8F59-6433A440B8AE extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3C6E3221-52A7-459A-AE2C-CB1E369E707A extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B11F8DDB-C996-47D2-9081-2C1E5F4BD142 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 697E63B0-5703-4C4F-989A-557756BEE980 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 082E631A-D8B1-4CB7-93EC-958CFD6C9500 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B168030E-80E7-453F-8978-B1BD2586848E update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime D8E0E98A-BFD9-4321-B370-F08463C4B4E8 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D7D2D405-06B2-49B9-90FF-D377390EFDAA update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true FE6E8460-BC31-48DC-A7E7-C3C36D815146 PK_b_warehouse_type PK_b_warehouse_type 1599804378 anyx 1599804378 anyx PK_b_warehouse_type 5BBC3E08-3A34-40C1-BDE3-3F9ABDD35641 b_website_config b_website_config 1599804378 anyx 1599804378 anyx ED120F63-9528-4A86-A846-5EEC31CB19F3 id id 1599804378 anyx 1599804378 anyx varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 61F3E22A-362F-47E4-92DA-9705FD9A6BDC login_title login_title 1599804378 anyx 1599804378 anyx 登录页的标题 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D81901C8-BD34-4A61-9725-8814CF3DAF53 browser_title browser_title 1599804378 anyx 1599804378 anyx 网页浏览器顶部的标题 varchar(500) 500 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true BAF849E6-AECB-4CB7-B322-3C1247B17D4B logo_img_url logo_img_url 1599804378 anyx 1599804378 anyx 首页左侧logo varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A35E6935-D1B7-4AD8-9728-6010017883CE bottom_text bottom_text 1599804378 anyx 1599804378 anyx 首页底部版权声明 varchar(500) 500 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CE67D724-1DC1-4CF5-8898-C840808B7964 remark remark 1599804378 anyx 1599804378 anyx varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C06D6158-ADD4-4219-911D-A5A8746F066F update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 1C8DCF20-4220-4B87-8104-871C91D24477 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B2A1A027-8650-4877-899F-58F60D103929 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0AB0BBB1-4F59-42E4-A4E6-E9FCA5019851 PK_b_website_config PK_b_website_config 1599804378 anyx 1599804378 anyx PK_b_website_config 9E2AAC1B-7177-442E-980B-BC686FFC4E65 s_cluster s_cluster 1599804378 anyx 1599804378 anyx 32AF7EAF-9416-4042-BCDB-E024DAE24D72 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 97EA0EA3-7144-47E1-939F-C98DC5A11068 instance_code instance_code 1599804378 anyx 1599804378 anyx WMS实例代码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3A04D707-93F9-47D2-B19D-595A509B1C9A instance_name instance_name 1599804378 anyx 1599804378 anyx WMS实例名称 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true BB17F613-AC17-42B2-BE51-4479AFDA42E5 project_type_code project_type_code 1599804378 anyx 1599804378 anyx 工程类型代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1DFD9418-E7D9-418C-98C6-809A26762505 project_type_name project_type_name 1599804378 anyx 1599804378 anyx 工程类型名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 04B3D0FC-337A-4DB4-A2AA-5CD2D1083E11 ip ip 1599804378 anyx 1599804378 anyx 负载均衡ip地址 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A422057C-1B41-4451-BD5B-0460F5E27F4E port port 1599804378 anyx 1599804378 anyx 端口 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8E4141EE-40E5-4593-A733-7455118588BD path path 1599804378 anyx 1599804378 anyx 项目名/等于工程的path; ip+port+path 等于完整的http路径 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true FB3EBC3A-810C-4A50-A093-37209D8D70B3 status status 1599804378 anyx 1599804378 anyx 状态:健康,警告,宕机 int(11) 11 1 58F6C1AF-29D6-4459-82D6-D9680F9288E6 status_name status_name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8E4E2CAB-FFCB-4959-8B7A-C920F80E15DE created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 4DB20DC7-2E94-41D2-8EA3-FFD996546FB9 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D629EF8C-999B-4B55-B392-DBB66DE7B3BE created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EC8710BF-0476-462A-B4F9-0C38439BEA9F update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 86E2ABC4-D92B-41E8-9F82-EB8438D90FED update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 67FFA31F-324B-4430-BFE2-84FF5B3EF578 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 07F30ACD-35DD-4D10-87F1-461CDC6AC452 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7D1C44F4-974C-495C-ABB2-75637372D574 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 18C50444-8928-4F85-AFF0-FEF558CB2107 PK_s_cluster PK_s_cluster 1599804378 anyx 1599804378 anyx PK_s_cluster 64B8109E-A454-403B-913F-6F3DD83DCC1E s_cluster_status s_cluster_status 1599804378 anyx 1599804378 anyx CCC9939B-3F05-445F-BFBA-02319D06E7A0 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EF24C1E5-07FA-4669-82B6-593053684E2C code code 1599804378 anyx 1599804378 anyx 状态代码 int(11) 11 1 7AFC9854-0F2E-4848-A1B2-DA6C35C9A327 name name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1A6EE685-C0C5-47B7-912E-FDBC55F6B339 PK_s_cluster_status PK_s_cluster_status 1599804378 anyx 1599804378 anyx PK_s_cluster_status 25598937-9067-4BAA-9B76-E076BE815785 s_database s_database 1599804378 anyx 1599804378 anyx 6BF308E3-09C0-4260-8C69-06C386158319 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A22FB50D-6E5B-45DE-98E0-464A9C8455ED code code 1599804378 anyx 1599804378 anyx 数据库代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E1BE876A-2495-41E4-BA69-680C2CE4E76D ip ip 1599804378 anyx 1599804378 anyx ip地址 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true ABF3BE05-EEA5-4EE2-8745-5DF89119557B intranet_ip intranet_ip 1599804378 anyx 1599804378 anyx 内网ip地址 varchar(30) 30 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6D198902-FCFB-4EC2-B631-A58AAB13C844 port port 1599804378 anyx 1599804378 anyx 端口 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6D77C1B4-A6A5-4787-BEF0-F4D1E4659884 db_name db_name 1599804378 anyx 1599804378 anyx 数据库名 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C4511973-A188-424A-9748-61BD70184744 user_name user_name 1599804378 anyx 1599804378 anyx 数据库用户名 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F6FC960E-F693-4908-BE4F-ADFF29116D7E user_pwd user_pwd 1599804378 anyx 1599804378 anyx 数据库登录密码 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0DA60CE8-68B1-444D-9F3B-0885A4E9B174 status status 1599804378 anyx 1599804378 anyx 状态:预留字段 int(11) 11 1 903413CD-A1D6-4AA8-9FDF-193F780A1A64 status_name status_name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E6F48998-3030-4162-9BDD-5FD163342853 expire_date expire_date 1599804378 anyx 1599804378 anyx 到期时间 datetime 1 717D022F-4DFB-44DC-AED4-AC0993960D38 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 17967861-4470-428D-80D3-62D839563FC4 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0884543A-0FCD-4F67-8E4F-6AFDF4E61B06 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 83A1488C-20FF-4A66-BCB7-F2E51B6F0601 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 8854CE69-F125-4525-A916-AAFA3B5F453D update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 34627B77-8A13-47B5-A723-3ECC05FF90D6 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 27811D6A-E3E1-4A41-AF76-B751BC07D632 remark remark 1599804378 anyx 1599804378 anyx 备注字段;如备注阿里云登录账号密码,腾讯云账号密码; varchar(150) 150 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 61288EB5-3C27-4D82-BEFD-010035454D0E extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 496B84F6-846F-4F50-91E3-4DD50E390C22 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true DC66A76A-BE5A-4EF1-B9E4-9C817793944E PK_s_database PK_s_database 1599804378 anyx 1599804378 anyx PK_s_database 10235F52-5415-45F9-B80A-5E62DACDC206 s_database_status s_database_status 1599804378 anyx 1599804378 anyx 456C8D02-BDAF-4CEF-ACB9-01213C594885 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E31AC16A-B6E9-4DDD-AFC9-FF8A2752ED04 status_code status_code 1599804378 anyx 1599804378 anyx 状态代码 int(11) 11 1 63EAC938-22AE-4299-AE92-BC77C9724D53 status_name status_name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4DE6FC0E-26FC-496E-9E67-00BBE8C0AB88 PK_s_database_status PK_s_database_status 1599804378 anyx 1599804378 anyx PK_s_database_status ECCF76D8-2A58-42D3-B3D0-1A39660A475F s_deploy s_deploy 1599804378 anyx 1599804378 anyx CEB06281-9A19-4D49-A18B-4505E03D73B5 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9135D8A9-F737-4C91-A46B-6AACBD31ED52 cluster_code cluster_code 1599804378 anyx 1599804378 anyx WMS负载均衡入口代码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E64F808B-85A2-439C-9B99-0AF111AE4082 cluster_name cluster_name 1599804378 anyx 1599804378 anyx WMS负载均衡入口名称 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9A3D1127-54DE-429E-8146-9956E97E7DFB project_type_code project_type_code 1599804378 anyx 1599804378 anyx 工程类型代码:这是冗余字段 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 84601A56-1BAD-4494-AD6A-2B2FA829A663 project_type_name project_type_name 1599804378 anyx 1599804378 anyx 工程类型名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5B3BE3FD-B606-45CD-9421-5DE678BA7309 server_code server_code 1599804378 anyx 1599804378 anyx 物理服务器代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true DAA4F133-0175-40F4-B56D-364E7BAC5C71 database_code database_code 1599804378 anyx 1599804378 anyx 物理数据库代码:有多套数据源的只记录主库 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5AC10B62-83EE-42E4-A2D0-88842C0BE453 ip ip 1599804378 anyx 1599804378 anyx ip地址 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F0CE5FE1-F80E-452D-8CBE-7241A5AC7A0B port port 1599804378 anyx 1599804378 anyx 端口 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true ED8376CC-B2B6-4A6D-9A9F-D46407A6B27A path path 1599804378 anyx 1599804378 anyx 访问路径,等同于项目名 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0F28820A-8EFD-4D5E-9F5B-57DE37D2691D file_dir file_dir 1599804378 anyx 1599804378 anyx 发布到服务器上的目录地址 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 411DB1FD-3E3A-4F8E-BC04-39F40DC58348 status status 1599804378 anyx 1599804378 anyx 状态 int(11) 11 1 C94217F2-3BCB-4E61-927F-987AA6ADAC69 status_name status_name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5E36353A-AE18-4F03-9B81-2BCA76A70AFE created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 4BE84D10-8851-46CB-929E-1C8D786A56E1 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EF85163A-386D-424B-984E-3B1AF40AA78B created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true BB8B1689-E1F2-40F2-9875-E33714090862 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime F3A1EBFE-384E-4EEC-91E8-0F21571AC1FE update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6BFB909E-9A17-4F00-BF01-0E24617E5524 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9E3E3456-3397-49D9-B511-7CF61FE754E2 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 34770210-3666-4D44-ADE3-8F5A02704F37 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5E4B72EB-522D-4C31-885A-23FAFA5086B0 PK_s_deploy PK_s_deploy 1599804378 anyx 1599804378 anyx PK_s_deploy 7DB9EB0C-1B91-457C-AD5B-CE2D482545DE s_deploy_monitor s_deploy_monitor 1599804378 anyx 1599804378 anyx 72DB7289-F041-47C6-907D-FF8C1A531381 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 708F5B33-DBBF-470D-A829-B093F5313EB5 deploy_id deploy_id 1599804378 anyx 1599804378 anyx 部署主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A9D00883-D608-4933-B731-9A7946E675E2 cluster_code cluster_code 1599804378 anyx 1599804378 anyx WMS负载均衡入口代码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 242EE32B-A328-4E15-AB63-DD1C2BB68701 cluster_name cluster_name 1599804378 anyx 1599804378 anyx WMS负载均衡入口名称 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AA389C0D-6EE5-4248-AB10-547A1EC4925D project_type_code project_type_code 1599804378 anyx 1599804378 anyx 工程类型代码:这是冗余字段 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true FD30F5F0-D085-4F34-9B8D-D5C8A4F70774 project_type_name project_type_name 1599804378 anyx 1599804378 anyx 工程类型名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 182645B5-9E58-489B-9B43-F9C61A7570DF ip ip 1599804378 anyx 1599804378 anyx ip地址 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2784AE47-A06D-4445-9DE5-C78526185570 port port 1599804378 anyx 1599804378 anyx 端口 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1396079E-6908-4804-A744-206FC4469297 monitor_time monitor_time 1599804378 anyx 1599804378 anyx 监控时间 datetime 1 26A57D43-DA09-4EE3-AEFE-DC089334063B http_status http_status 1599804378 anyx 1599804378 anyx 返回http状态码 0 int(11) 11 E65CE84C-9EF8-48E8-A811-7A0F9FC490E7 message message 1599804378 anyx 1599804378 anyx 返回信息 0 int(11) 11 51ED1665-611D-4B31-BA2F-88D20639D4C7 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4B2097B4-ACDE-47D0-9381-25DD4C3B3098 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6FE7059B-49DA-4ACE-98D5-A8C3F998F07C extend3 extend3 1599804378 anyx 1599804378 anyx 预留字段3 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E845C066-9786-4588-B204-231279B9D39C extend4 extend4 1599804378 anyx 1599804378 anyx 预留字段4 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 50D488A0-F083-4ABA-A694-BC3D858048D9 PK_s_deploy_monitor PK_s_deploy_monitor 1599804378 anyx 1599804378 anyx PK_s_deploy_monitor D562CF36-A86A-406C-B775-719DD1996EB1 s_deploy_status s_deploy_status 1599804378 anyx 1599804378 anyx 99AECCAF-BDC7-43AB-97D4-AABDA85593EA id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C3DB6DA5-3CB0-4359-8275-565D74BEB882 code code 1599804378 anyx 1599804378 anyx 状态代码 int(11) 11 1 4AAFC898-258A-4CB9-A6E9-8CEFE60C2A06 name name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 084659E9-7435-4D8B-BC81-5C8C549E6465 PK_s_deploy_status PK_s_deploy_status 1599804378 anyx 1599804378 anyx PK_s_deploy_status 9F5417DA-018C-4D2A-8555-ED89DCFBA321 s_instance s_instance 1599804378 anyx 1599804378 anyx 3476259E-D6EA-4FF4-B6A0-63207F02EB48 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B410B898-F889-43A4-A5B8-CB214C1AA77D code code 1599804378 anyx 1599804378 anyx 代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 754EB8C2-DF90-4E24-8079-7B59D01BCCF4 name name 1599804378 anyx 1599804378 anyx 名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 75BEB05D-0135-4825-A3A4-E6BC80DF0298 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 F85589DD-409C-417A-8853-3DDEAD93972D created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4E78E853-4E92-4C70-9980-C733350C80EC created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 13EBC395-B06E-47CC-A618-A70E585DB127 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 7FDB2B3E-82FB-40A9-900C-57123A89A0EA update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F66346C2-11D0-446A-BA2C-08C83B7271B4 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6DB6BB11-2AC3-4313-B87B-91646F3706EC extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3855DA64-51C4-467E-BCE0-932D7D565B15 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C1014D83-2650-4642-AC44-DBF728BF3F3A PK_s_instance PK_s_instance 1599804378 anyx 1599804378 anyx PK_s_instance FE594A52-9BF1-4787-877F-CAE46C6B3D61 s_project_type s_project_type 1599804378 anyx 1599804378 anyx C5B04807-3F3D-4072-B327-6553DCE277B2 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AF9DB93B-B32E-4534-AE5F-D88D91F67401 code code 1599804378 anyx 1599804378 anyx 工程代码;api,client,operate,send,task varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CB946D70-48C8-4787-82E9-40D955A1E169 name name 1599804378 anyx 1599804378 anyx 工程名字:接口系统,货主系统,作业系统,推送系统,任务系统 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true FFAF3153-19B5-4387-AEAB-940489633AD4 sort sort 1599804378 anyx 1599804378 anyx 排序号 0 int(11) 11 9CD57015-98D0-4DF6-A245-10839CE47DF0 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D934C061-6871-435A-A716-F6B4CB485864 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6E27FA4B-8A01-427F-9534-9E96F507EEF0 PK_s_project_type PK_s_project_type 1599804378 anyx 1599804378 anyx PK_s_project_type 04CF1DB4-4BD4-4B8C-934C-1ADB5F958C84 s_server s_server 1599804378 anyx 1599804378 anyx 0650A18A-D416-4E91-A37C-257415A83BA5 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B2873DBF-A21E-4E79-A716-54B831AF9FFC code code 1599804378 anyx 1599804378 anyx 服务器代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 35A14777-1F7A-4A42-A6B0-7F274A0E4D23 ip ip 1599804378 anyx 1599804378 anyx 公网ip地址 varchar(30) 30 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4ED18811-9284-43C9-8A1F-2C971C1F1C8E intranet_ip intranet_ip 1599804378 anyx 1599804378 anyx 内网ip地址 varchar(30) 30 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B726B372-AA22-4E15-80AA-94F1CBCBEA66 port port 1599804378 anyx 1599804378 anyx 登录端口 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D7F03ADC-66F6-4254-93A6-DAFE45555DC9 user_name user_name 1599804378 anyx 1599804378 anyx 服务器登录用户名 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8896F2A2-772D-491F-A254-5BC217D66B4E user_pwd user_pwd 1599804378 anyx 1599804378 anyx 服务器登录密码 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 93D6363D-FE46-4D20-B114-C95F97B883C0 status status 1599804378 anyx 1599804378 anyx 服务器状态 int(11) 11 1 D05E1E40-1DB1-498F-AEB4-41AB32AA6C48 status_name status_name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5BFA24BA-3DF4-4B3F-8846-157FC9E05D82 expire_date expire_date 1599804378 anyx 1599804378 anyx 到期时间 datetime 1 08FADBDB-9B98-4E24-B824-D108198648DD created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 3A7EF509-E1B7-4995-BB8A-EF73114059AC created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C280967C-619F-4BE7-9EE1-7C837DEBE61A created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AE5B0831-9181-42ED-B188-864BFB9F5F0E update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 7CB80B28-B60A-4521-9234-5FC5F001D9BA update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6550B4C7-1379-4FE7-8625-AC4F098EAF90 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F1680BC0-7072-41D9-832C-6EE057207BE7 remark remark 1599804378 anyx 1599804378 anyx 备注字段;如备注阿里云登录账号密码,腾讯云账号密码; varchar(150) 150 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AE204301-55E6-4A40-B7C5-41104F51B0C0 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A58869E9-CC3B-4E39-8DAB-C6D5D726271D extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8015B239-8F7D-4AA5-A6A8-744CF2973939 PK_s_server PK_s_server 1599804378 anyx 1599804378 anyx PK_s_server A7701A91-D2AD-46F2-80D9-E2A5310FAD1C s_server_status s_server_status 1599804378 anyx 1599804378 anyx CEC3CB66-633A-4F5A-9CEF-80AB7D2B2BE3 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5E54BC9D-BA47-423E-A1F6-641C75DA4FF0 status_code status_code 1599804378 anyx 1599804378 anyx 状态代码 int(11) 11 1 9D29E972-C098-4791-9AAD-474F54B93751 status_name status_name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4E8E88C1-FB02-4A64-93B3-91E75FCD73D4 PK_s_server_status PK_s_server_status 1599804378 anyx 1599804378 anyx PK_s_server_status A07F3580-C10C-4A5C-B6F2-E287C7717A54 u_customer u_customer 1599804378 anyx 1599804378 anyx DA2017FA-7A3E-4EF2-91D7-3512B7369882 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D13D8EDD-7CAE-429C-8DF6-6791682B2EDC code code 1599804378 anyx 1599804378 anyx 用户登录名/没有密码,密码在平台管理 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 19091B7F-5594-4A4E-AFD9-9FD6FF926ECC password password 1599804378 anyx 1599804378 anyx 登录密码md5 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E3CD5DD7-E958-4520-A3A6-3C5BECD63446 name name 1599804378 anyx 1599804378 anyx 客户名字:可以是人名,公司名 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0696CC88-F790-4CA1-AF51-1EE5401CED10 name_en name_en 1599804378 anyx 1599804378 anyx 客户英文名字:可以是人名,公司名 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 41D2A98B-8706-4E4D-9900-D2EAAD0EC83F status status 1599804378 anyx 1599804378 anyx 账号状态:0:已删除,1正常,2:冻结只有1可以登录 int(11) 11 1 BAD7C8F5-858C-40A2-9468-A21620AF9236 status_name status_name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9A90133F-9385-40D6-9CB3-859207B4E756 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 3020CF76-9DAB-4A2A-9FF4-2E8A634B13FE created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2FDEB8E1-9388-4552-9B44-34DEEC752B30 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B0A779D2-4EB3-4447-BEE5-4476D2C4682B update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 7DA88094-5396-47DC-BF26-AF3F3B5D10B5 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 429A59EA-1823-42E6-A857-274F0DBC5991 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9DB1802A-8F8D-432B-A5F5-539A17D06C4F extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3A08CC8D-BA5E-41B7-8081-6FD4DA14EE9D extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 89BD4670-CA12-4C92-BD95-ED96A455A658 PK_u_customer PK_u_customer 1599804378 anyx 1599804378 anyx PK_u_customer 84CE81F3-5A3E-4C14-B8B1-E3778A2FDA6C u_customer_attach_file u_customer_attach_file 1599804378 anyx 1599804378 anyx 47A7BAB7-0715-4E83-AE75-44A986C7ADE7 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true FB372383-453B-49BB-B296-E5807699C8D3 customer_id customer_id 1599804378 anyx 1599804378 anyx 货主ID varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5F6588F7-872A-49E3-B6C9-A64B44C2A045 customer_code customer_code 1599804378 anyx 1599804378 anyx 货主代码 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true ABC975B8-2345-40D0-96AD-EDDCB438B93C name name 1599804378 anyx 1599804378 anyx 附件名称 varchar(30) 30 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0BD3F9C4-02BC-4917-A569-7550EEBCDE39 url url 1599804378 anyx 1599804378 anyx 附件文件URL varchar(1000) 1000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 934A805B-E9B2-4495-A1BA-BA7B45F9F735 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C30C64C5-57AD-439E-970F-91CD9530E2F0 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2B4B2EAB-7089-4DB3-A1AB-E47B8C4DEF7E created_time created_time 1599804378 anyx 1599804378 anyx datetime 1 01962460-FD1D-43BE-BEC5-1EA701468136 PK_u_customer_attach_file PK_u_customer_attach_file 1599804378 anyx 1599804378 anyx PK_u_customer_attach_file 4425EC8A-9B54-4191-8A0B-C652E5CB8F6A customer_id customer_id 1599804378 anyx 1599804378 anyx 95F51CD0-C088-458E-96FB-1DD30AE86DAD 1599804378 anyx 1599804378 anyx 1B0CC01A-E090-47AC-B876-3EEDAC1D3320 u_customer_contact u_customer_contact 1599804378 anyx 1599804378 anyx 122B9A3F-F945-4EF5-8500-2E989536E0E9 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 14FB96DC-6CC7-49FB-8EBC-B9465F4E76C3 customer_id customer_id 1599804378 anyx 1599804378 anyx 货主id varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 549C7C7C-60D9-4FCA-A566-6C6C4A612CCB customer_code customer_code 1599804378 anyx 1599804378 anyx 货主代码 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2ECA09A4-DAA7-4A00-9815-85B39BFAA0CD name name 1599804378 anyx 1599804378 anyx 联系人名 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E9171347-7CD1-468B-9508-115C853696A1 address_line1 address_line1 1599804378 anyx 1599804378 anyx 街道地址1 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4E27A5D5-2BB6-4038-9D09-232D5BE05A6C address_line2 address_line2 1599804378 anyx 1599804378 anyx 街道地址2 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6560B7CE-9C2B-4BC4-8A88-5FD42D90A990 province province 1599804378 anyx 1599804378 anyx 省份 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5EA2B17D-9E1C-411D-8B47-216A555996F8 city city 1599804378 anyx 1599804378 anyx 城市 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5D3A3901-15F6-47C1-88E2-74C5AA7C0BC8 county county 1599804378 anyx 1599804378 anyx 县城 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 57E84635-39EA-48D7-B427-A6731BCD0FEA postal_code postal_code 1599804378 anyx 1599804378 anyx 邮编 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 897536D0-43CD-4C12-9A86-172578B72BF2 country_code country_code 1599804378 anyx 1599804378 anyx 国家代码 varchar(10) 10 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6D2DD956-4098-4E34-9E9A-9AF812C78582 country_name country_name 1599804378 anyx 1599804378 anyx 国家名称 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0A1534C3-9BD4-48D5-B7C5-7E0F242CC723 email email 1599804378 anyx 1599804378 anyx 邮箱 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 444D0E16-6CBE-4D66-B474-9BF95328DEAD mobile_number mobile_number 1599804378 anyx 1599804378 anyx 手机号码 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F43536A8-D916-4C55-9288-99A5DD88B6AC phone_number phone_number 1599804378 anyx 1599804378 anyx 电话号码 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D7EC2457-6066-47BE-AE4C-35D6759FAE0A identity_number identity_number 1599804378 anyx 1599804378 anyx 身份证号码 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1121E36F-9658-4601-B85F-79618EEB9AB5 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 052245DB-5497-42BA-A510-6686816EA3C3 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 由货主的员工创建;首个货主员工账号在创建货主时系统自动创建 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A89AF48A-BC40-470F-AE1A-C46E0FE964EE created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8A8412FB-3436-47C6-A469-75EEE53DEABA update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 8DFF4BD2-25D3-4C31-9D63-4A3475D2C857 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C012D56A-7AB8-428C-B807-030B89B6178A update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4829D38B-8E12-44F2-8FC4-17F4B9568056 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 453EF5EB-B17A-4B10-B77E-92042636895A extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D4F521C0-F9A7-4A6F-B2A8-82160EEF12AF attachment1_address attachment1_address 1599804378 anyx 1599804378 anyx 附件1存放地址 varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5ADCB3CD-E67A-4516-9CE4-8262CC397E33 attachment1_remark attachment1_remark 1599804378 anyx 1599804378 anyx 附件1备注 varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 57730ED5-01B3-4EDA-8940-64AF082D9804 attachment2_address attachment2_address 1599804378 anyx 1599804378 anyx 附件2存在地址 varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C485DEF8-5285-46DE-9C99-54B85A1A07EF attachment2_remark attachment2_remark 1599804378 anyx 1599804378 anyx 附件2备注 varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0037F34D-29A4-4E22-89D4-AF53A1139377 attachment3_address attachment3_address 1599804378 anyx 1599804378 anyx 附件3存放地址 varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AA36894D-0C85-4951-8D67-536DF97E89C5 attachment3_remark attachment3_remark 1599804378 anyx 1599804378 anyx 附件3备注 varchar(255) 255 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AEE4C93B-82F1-47BA-95B9-9F329A57BD61 PK_u_customer_contact PK_u_customer_contact 1599804378 anyx 1599804378 anyx PK_u_customer_contact 75327F23-1B25-4C4D-B23C-51BB287C3997 u_customer_credentials u_customer_credentials 1599804378 anyx 1599804378 anyx 4D72F292-4ADB-49A9-980F-C880CB916926 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 59FB2A72-E21E-4BEA-AD67-A58AD534320F customer_id customer_id 1599804378 anyx 1599804378 anyx 客户ID varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 162436C5-ADED-406D-B5A5-46C5DE35F323 customer_code customer_code 1599804378 anyx 1599804378 anyx 客户代码 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F596E7C1-AD14-4368-9330-A80829884ABB id_number id_number 1599804378 anyx 1599804378 anyx 证件号码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 87D4F60C-0FB4-4BE1-9725-BA7DDBCB161C name name 1599804378 anyx 1599804378 anyx 人名/公司名 varchar(30) 30 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8F5430AA-DBBF-4FD2-A020-B9C0F80CFAC7 front_img front_img 1599804378 anyx 1599804378 anyx 正面照片 mediumtext {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true BDE38DD5-32D7-4934-A452-F6F9FB62842C back_img back_img 1599804378 anyx 1599804378 anyx 背面照片 mediumtext {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4E3D300D-799C-48A1-9E33-7781052D1BC5 front_img_url front_img_url 1599804378 anyx 1599804378 anyx 身份证正面照片URL varchar(1000) 1000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7B1BE5F0-10E4-463B-B184-66638A34E952 back_img_url back_img_url 1599804378 anyx 1599804378 anyx 身份证背面照片URL varchar(1000) 1000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CDE8BCFE-2FCC-4526-8CBC-6211FE033777 created_time created_time 1599804378 anyx 1599804378 anyx datetime 1 6AFA1B4F-A29A-40ED-8017-CA7FD5951F84 PK_u_customer_credentials PK_u_customer_credentials 1599804378 anyx 1599804378 anyx PK_u_customer_credentials CC2BBBDE-DB37-4843-ADEC-E10E5F79526D customer_id customer_id 1599804378 anyx 1599804378 anyx CFCD8490-1738-46F7-80F9-97A047EB8C62 1599804378 anyx 1599804378 anyx B7CE7401-CB99-46C7-84D2-F9524AA1E645 index_id_number index_id_number 1599804378 anyx 1599804378 anyx C0308D2F-797A-498C-BC09-5052B5640557 1599804378 anyx 1599804378 anyx 2CF023AC-58DA-44FC-8113-A76CF49EFE75 u_customer_pf_info u_customer_pf_info 1599804378 anyx 1599804378 anyx 5E52365D-17F3-4C63-8043-AD8FBCD102D0 id id 1599804378 anyx 1599804378 anyx varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C55F90F5-CED6-4FDC-9366-6183C05E0051 customer_id customer_id 1599804378 anyx 1599804378 anyx 客户id varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 851D7C6A-D088-4F7F-91F7-A388B9AA795D customer_code customer_code 1599804378 anyx 1599804378 anyx 客户代码 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8781DDAC-463B-4568-9452-D9D06C614A6D platform_code platform_code 1599804378 anyx 1599804378 anyx 电商平台代码 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 030D9E42-A0F7-4DA6-8EF2-899B7668D509 platform_name platform_name 1599804378 anyx 1599804378 anyx 电商平台名称 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A555CC39-D888-4595-8BBA-289557921510 enterprise_code enterprise_code 1599804378 anyx 1599804378 anyx 电商企业代码 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B5A8C522-2A6A-4EBB-AC30-2EA351244241 enterprise_name enterprise_name 1599804378 anyx 1599804378 anyx 电商企业名称(海关备案) varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 47EA8761-0F6A-47F9-BEEF-F1E4EAEEBE49 enterprise_register_code enterprise_register_code 1599804378 anyx 1599804378 anyx 电商企业注册编码 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 39A43B7D-377E-4F80-8833-5A9C35E4DECD enterprise_name2 enterprise_name2 1599804378 anyx 1599804378 anyx 电商企业名称(单一窗口) varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4D950FC6-EB65-4205-AFA0-BEF5B9DE4CAA domain_name domain_name 1599804378 anyx 1599804378 anyx 电商域名 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CB0C6340-7462-4BF4-ABB3-0452083E2E4B created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 0D1424E1-2CE3-4D5B-A26D-E2223F16BF0D created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 由客户的员工创建 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9685F3E0-1D81-400A-BB65-F7647A7330F5 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4405E7BB-DB7B-4102-AFA6-4A4DFBC58046 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 5097B89E-28B4-4319-855D-91C8CC04F6B1 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4CEA4727-9EFB-413F-A22B-1A1586382601 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D31D209C-3591-4754-94C1-2A218BE8F28F extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 78075FA0-15C5-4754-B48D-84988626941A extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4F8D26D0-7E01-4987-AF3B-465F67EFBC5F PK_u_customer_pf_info PK_u_customer_pf_info 1599804378 anyx 1599804378 anyx PK_u_customer_pf_info 1BED75F4-643E-47C1-92B3-93FFB850B728 u_customer_status u_customer_status 1599804378 anyx 1599804378 anyx 089CCD07-7B69-4176-9902-653558476CD6 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D1BE6AA3-4256-4BBE-98DE-A8241064BD48 code code 1599804378 anyx 1599804378 anyx 状态代码 int(11) 11 1 1BD5753C-F97E-4B59-807F-B3E2865D6B64 name name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A322F74F-864C-4D9F-A4F9-B6F76C90188F PK_u_customer_status PK_u_customer_status 1599804378 anyx 1599804378 anyx PK_u_customer_status 6095C78D-120F-4FFC-AD6F-96211776116E u_user u_user 1599804378 anyx 1599804378 anyx A3796922-6478-4A0E-921F-279274A6BBDA id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9AA7D3C7-D85E-44CA-A44A-32FAEB494377 code code 1599804378 anyx 1599804378 anyx 用户代码-用于登录 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 560FA606-FD62-46C5-A77E-CD3566AF4847 name name 1599804378 anyx 1599804378 anyx 用户名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8F27FBEA-24EB-45CB-925D-D7C06BE809E4 password password 1599804378 anyx 1599804378 anyx 登录密码- md5值 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 91C7325F-989A-4DC8-86DD-3410308CDA14 org_id org_id 1599804378 anyx 1599804378 anyx 机构id varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 72ABF3F2-03F6-431D-B8DE-BC3FB220A003 org_code org_code 1599804378 anyx 1599804378 anyx 机构代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 10CD248A-79D3-49B5-B6D5-2FFFA5C30242 org_name org_name 1599804378 anyx 1599804378 anyx 机构名 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5838326A-F5B7-48F1-94DD-950AAA71ADDD status status 1599804378 anyx 1599804378 anyx 账号状态:0正常,1:冻结只有0可以登录 int(11) 11 1 37B9DB02-3146-4559-886C-59316A5097C7 status_name status_name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9F0C5B58-CAE3-47BA-935D-AB03BFD270CE phone_number phone_number 1599804378 anyx 1599804378 anyx 电话号码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true BE1D426B-8D18-4995-81DD-11988808A5A4 mobile_number mobile_number 1599804378 anyx 1599804378 anyx 手机号码 varchar(20) 20 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 857B7809-0765-405F-90D7-6088033EDA36 address address 1599804378 anyx 1599804378 anyx 联系地址 varchar(500) 500 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E50BC9BC-590C-4FAC-86C5-BA64896EE53B last_login_time last_login_time 1599804378 anyx 1599804378 anyx 上次登录时间 datetime 84A47BCF-0929-4920-8D0F-19845C11D6AB count_login count_login 1599804378 anyx 1599804378 anyx 登录次数 0 int(11) 11 BDF9E1F5-DAAB-4B95-AB1D-DCAEE6EAB946 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 9D4EC9FF-3BE8-4DA8-83EE-3EA81F204239 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C0F86D1B-DD61-4512-9F50-CB71F8E4BF35 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F77E11A8-1DDE-43A7-87D1-A8474AC0DB78 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime F4715561-6D54-4195-90F8-93CB4A7FA46A update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true ADF0EC77-64B5-48E0-A33C-F6617DD00E16 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true BD581308-4625-47A8-BC2B-68A6242CAAE4 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 28DBDD06-8004-4036-A4FE-21B69768BA63 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1FC9C83C-59A7-41F0-945F-4A1216F0BA01 extend3 extend3 1599804378 anyx 1599804378 anyx 预留字段3 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6DA2EAEB-6216-427D-A9DD-56307B880F5B extend4 extend4 1599804378 anyx 1599804378 anyx 预留字段4 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 558DD47B-805D-4244-8A2F-774F283A1333 index_code index_code 1599804378 anyx 1599804378 anyx index_code 8E6334EC-6585-4A21-8B5A-B0589AE38307 PK_u_user PK_u_user 1599804378 anyx 1599804378 anyx PK_u_user 44523B3C-7684-4CDB-8989-893D254159DE u_user_data_access u_user_data_access 1599804378 anyx 1599804378 anyx 79C535DA-5698-4A77-8435-8EC09A417FA1 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4E0DD509-27EF-4229-8720-A43B2EC29DE8 user_code user_code 1599804378 anyx 1599804378 anyx 用户登录名/没有密码,密码在平台管理 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 50F7CB80-5165-47F1-BDDC-CE0336F1C6D6 user_id user_id 1599804378 anyx 1599804378 anyx 登录密码md5 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 6E5591F4-3EF5-4597-972D-4E2D54C8B4A2 warehouse_ids warehouse_ids 1599804378 anyx 1599804378 anyx 用逗号分隔,如果是[ALL]表示全部 varchar(500) 500 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C7671420-78AF-44FC-985F-5293361B022B warehouse_codes warehouse_codes 1599804378 anyx 1599804378 anyx 用逗号分隔,如果是[ALL]表示全部 varchar(500) 500 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EAF223D4-EED9-4847-934E-865C36935BC3 customer_ids customer_ids 1599804378 anyx 1599804378 anyx 用逗号分隔,如果是[ALL]表示全部 varchar(1000) 1000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 388BC27E-7702-476C-9971-92E03A2319DF customer_codes customer_codes 1599804378 anyx 1599804378 anyx 用逗号分隔,如果是[ALL]表示全部 varchar(1000) 1000 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 27B7D5AF-B28D-4388-A734-C1F3D0C13DBC created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 54C2E120-0BF7-4B8B-9A07-EACD250B12E4 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A7A49194-1146-473E-BCCF-3F819B6DAE75 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7FDCAA7C-15D6-42F5-97B7-33B0F9D6C911 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime A8E13DFC-913F-4A90-B75C-EB6289198ACA update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F415BE47-C0BA-4AE4-9C8B-19D29B590480 update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2EF2DC46-DF43-4D99-9D0B-91E7AFC84B70 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 948EA31A-E3A9-488B-A8FD-F27178543894 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B8516C8E-91EA-4559-8739-77AC3A492680 PK_u_user_data_access PK_u_user_data_access 1599804378 anyx 1599804378 anyx PK_u_user_data_access BAF29BC2-1DA2-4BA1-88F5-EC3AFF616CBD u_user_login_log u_user_login_log 1599804378 anyx 1599804378 anyx 6C4C47A3-CCD8-40E7-A51B-FA84E593F3D5 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 203DF665-FF87-4953-A68E-A5958D0BF3F1 user_code user_code 1599804378 anyx 1599804378 anyx 用户代码 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 209E775D-1ED7-4695-9FDF-AD16FA9D55FD password password 1599804378 anyx 1599804378 anyx 登录时输入的密码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 8B0E991A-B606-4106-8719-B8F6F93116BF login_time login_time 1599804378 anyx 1599804378 anyx 登录时间 datetime 1 1FF8EBDD-3D39-40A5-A0CC-F2DD98616336 ip_address ip_address 1599804378 anyx 1599804378 anyx ip地址 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C2E99A44-01A7-49B9-8CE9-01910DC998D3 is_success is_success 1599804378 anyx 1599804378 anyx 代码:登录是否成功 0:否,1:是 0 tinyint(1) 1 189E6D08-EFA0-40AF-B492-DE6962D50798 after_time after_time 1599804378 anyx 1599804378 anyx 耗时 0 bigint(20) 20 1 0B6D1950-09C4-4EE0-86F0-87D2269B49A1 login_result login_result 1599804378 anyx 1599804378 anyx 登录结果消息 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F48A32E9-6689-42D5-97F5-0A00E5CEB74F extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4BB98EEB-3E22-463F-9402-A2FECC6ADCFB extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 287761E4-36FD-4E69-A873-AA5294216101 PK_u_user_login_log PK_u_user_login_log 1599804378 anyx 1599804378 anyx PK_u_user_login_log 2C6F4219-92F1-422D-885F-B54FB6447A2E u_user_org u_user_org 1599804378 anyx 1599804378 anyx BF5A9CDC-87A5-4354-A3B5-FB532C79ED5D id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0375F01E-A3A6-4A7B-8517-FD576039360F code code 1599804378 anyx 1599804378 anyx 组织代码 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D5A722E8-9503-4FFD-93C2-A894D2552BE0 name name 1599804378 anyx 1599804378 anyx 组织名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A19AEA92-A33D-41BF-AC5F-296F7BF5BB23 parent_id parent_id 1599804378 anyx 1599804378 anyx 上级组织机构id - 上级机构拥有下级机构的数据权限 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 9AED3844-7C13-49B7-9138-57D5CF2835A0 leader leader 1599804378 anyx 1599804378 anyx 负责人 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 7333E2F4-F161-4007-96CD-B4FFC4135040 sort sort 1599804378 anyx 1599804378 anyx 排序号 0 int(11) 11 1 F1F5B2D4-7D8C-40CE-A9A5-DBB1DD5A4E24 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 4E5D3954-DF29-466E-9D92-55B3AA2627FD created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 44A7EEA3-0654-4006-8A2C-96973B19271F created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 38FE2504-0239-4286-AFF2-D6005CC74890 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime A3E63067-9BA8-4358-A696-2A841D055C9A update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true A11F1BA5-E455-4459-8BA1-4AE02DD2DBFB update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true E9BDEA10-CDFA-4E33-9ADF-F26D4BA017A0 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5794EA0D-AB79-4AD2-8041-18AC164852FD extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0364CAD1-9B44-476F-A639-ADDD32838480 index_code index_code 1599804378 anyx 1599804378 anyx index_code FEDB8BC3-ACA1-4896-BAA0-70F91D3FC70E PK_u_user_org PK_u_user_org 1599804378 anyx 1599804378 anyx PK_u_user_org C5639F95-58E6-4001-9420-AD2B74F4E97F index_parent_id index_parent_id 1599804378 anyx 1599804378 anyx DCE61E78-A872-4D3C-8771-5C9827910760 1599804378 anyx 1599804378 anyx 1AE477F4-A21A-4859-9734-48DEB4426F21 u_user_resource u_user_resource 1599804378 anyx 1599804378 anyx D72B61CC-A77E-4599-A366-D39D03530BD9 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true FFDDA3F1-9B82-4023-92FB-E7DC916C7BE4 parent_id parent_id 1599804378 anyx 1599804378 anyx 父ID varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4B4AA620-2EF7-42A7-9FCE-84E12011E6A8 code code 1599804378 anyx 1599804378 anyx 资源代码 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 41FF7938-C9D0-4EB6-AFBB-6FBA341300E2 name name 1599804378 anyx 1599804378 anyx 资源名称 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 55C80FE7-A11F-423F-AB12-58E8367B04F3 url url 1599804378 anyx 1599804378 anyx 菜单的URL varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AF359FC2-DBD7-4011-8B47-EAFD16DF99AA event event 1599804378 anyx 1599804378 anyx 按钮的事件 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CFDBB33F-C02B-4019-82E2-0F62D56B3D08 type type 1599804378 anyx 1599804378 anyx 类型:1是菜单,2是按钮 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D3F14BBC-6839-464C-9362-544B2DCBE9E8 icon_cls icon_cls 1599804378 anyx 1599804378 anyx 菜单,按钮图标css varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true AB520C71-88EA-44BB-B73E-2A454FE6719C state state 1599804378 anyx 1599804378 anyx 在系统菜单中默认打开:open还是关闭:closed varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B032B858-1165-486B-A7FE-E43F907324DD sort_no sort_no 1599804378 anyx 1599804378 anyx 排序号 0 int(8) 8 896B4130-8271-4538-8730-160F51DDD141 created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 C81FA333-F82F-45C5-82F9-B2FFFBA44B28 created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 创建人id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true C7827E0F-40E9-468C-AD32-50B3A13DD790 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 95FB7764-2A2F-429B-9410-B9EC18893A28 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime D5370886-6E6B-4BB4-ABE8-72231D750FCB update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 4995E731-6BC4-4D78-9BCF-97DAA2BA0C8B update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3E52E868-D491-485B-BD80-AE974EE7647C is_hidden is_hidden 1599804378 anyx 1599804378 anyx 是否隐藏 ~N~ char(1) 1 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 3720818D-7E16-4EE8-A0CE-06C7ACD23F21 extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 58FD9724-D589-4732-9181-6231B0EDA6F4 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 981B39AD-A719-4E01-A9F5-F7867F05B71C code code 1599804378 anyx 1599804378 anyx code CE82567A-33E7-4DEB-846C-034CF067C2CE PK_u_user_resource PK_u_user_resource 1599804378 anyx 1599804378 anyx PK_u_user_resource 12DA0367-198D-4FAB-8B5F-215FEE2F529C u_user_role u_user_role 1599804378 anyx 1599804378 anyx 7DEAEC19-39AC-43FD-964F-571598C31837 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true DAA5DF0A-C699-4D0D-AE4F-2C4306AF5347 code code 1599804378 anyx 1599804378 anyx 角色码 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 583D51EE-7885-4659-90C1-60896FB636AE name name 1599804378 anyx 1599804378 anyx 角色名 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5CDA0108-5D63-4F18-BE60-E6D16E62CD81 level level 1599804378 anyx 1599804378 anyx 级别 1 int(11) 11 1 6A503DBB-A07B-452A-B818-BB19A411BB29 sort sort 1599804378 anyx 1599804378 anyx 排序号 0 int(11) 11 1 E794A0FC-33C6-4D67-9C35-B840426E7C54 description description 1599804378 anyx 1599804378 anyx 角色描述 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 77FEC0BD-C275-46D8-9718-047D69D5FF4C created_time created_time 1599804378 anyx 1599804378 anyx 创建时间 datetime 1 5D1AC1D4-242E-4186-9991-3723E7A3B6EE created_by_user_id created_by_user_id 1599804378 anyx 1599804378 anyx 是谁创建的 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 2567252E-775D-4F40-88A8-FC1C5ED0D3B2 created_by_user_code created_by_user_code 1599804378 anyx 1599804378 anyx 创建人账号 varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 1854FD44-18B3-46F1-ABAE-7DB80FE5BC10 update_time update_time 1599804378 anyx 1599804378 anyx 更新时间 datetime 5AB4E010-6AC8-465F-B612-F10D7199F097 update_by_user_id update_by_user_id 1599804378 anyx 1599804378 anyx 是谁更新的 varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true CF0CC434-CD1A-429B-9574-218CD392F52E update_by_user_code update_by_user_code 1599804378 anyx 1599804378 anyx 更新人账号 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D9024557-1950-4168-91A7-A632BF345ACB extend1 extend1 1599804378 anyx 1599804378 anyx 预留字段1 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B53EEBA0-4BB8-4DCB-9356-2F47068282E8 extend2 extend2 1599804378 anyx 1599804378 anyx 预留字段2 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 42568110-3F5D-4C42-AB5C-18B11229045A code code 1599804378 anyx 1599804378 anyx code 4607494B-8FC4-48BE-81B2-68E6C8E03D39 PK_u_user_role PK_u_user_role 1599804378 anyx 1599804378 anyx PK_u_user_role B9756E9E-1F00-49A8-B757-9CC52302ADA3 u_user_role_relation u_user_role_relation 1599804378 anyx 1599804378 anyx 66C828E2-4F5D-41B1-8568-1D27606948D3 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true B7C18FBE-18BB-4840-A583-D5E7378FFD48 user_code user_code 1599804378 anyx 1599804378 anyx 用户code varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 0E12B186-BC1E-4061-B7E8-5A59680C5617 role_code role_code 1599804378 anyx 1599804378 anyx 角色code varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true EF0F0B55-2330-46FF-8E11-DA6CCB1CD2F0 PK_u_user_role_relation PK_u_user_role_relation 1599804378 anyx 1599804378 anyx PK_u_user_role_relation 54D93A98-DACE-4639-80B8-DEA17FEBEE92 u_user_role_resource_relation u_user_role_resource_relation 1599804378 anyx 1599804378 anyx 0102D68E-1ADE-407B-A80A-B3E94838B706 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true D1CF4888-B84B-48B4-85A3-F8BA3A9CC489 resource_code resource_code 1599804378 anyx 1599804378 anyx 权限code varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 55363363-07CE-4032-BD43-B1A4B126C193 role_code role_code 1599804378 anyx 1599804378 anyx 角色code varchar(50) 50 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 5D9905BE-D396-44B8-862C-E7620810F503 PK_u_user_role_resource_relation PK_u_user_role_resource_relation 1599804378 anyx 1599804378 anyx PK_u_user_role_resource_relation 3A7F061D-3DC9-436A-9FCE-C9D67D71F204 u_user_status u_user_status 1599804378 anyx 1599804378 anyx B432116D-54B1-4A67-AE15-7EB401E51B42 id id 1599804378 anyx 1599804378 anyx 主键 varchar(32) 32 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true 81A03254-1B22-4E21-A520-1951412DE7BE code code 1599804378 anyx 1599804378 anyx 状态代码 int(11) 11 1 264BC828-6D4C-405C-A6C4-9C02A7BB3880 name name 1599804378 anyx 1599804378 anyx 状态名字 varchar(20) 20 1 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,56={9C949EAB-FF87-446D-938C-8F03A4ABDC8E},National,4=true F3D1BF43-993D-4072-8C5C-1941E6B4238C PK_u_user_status PK_u_user_status 1599804378 anyx 1599804378 anyx PK_u_user_status D78A37A6-5E9E-44B7-AB0F-64E1965E7C1F PUBLIC PUBLIC 1599729019 anyx 1599729019 anyx 855A4663-C7E8-4252-9CAD-9251873DE871 MySQL 5.0 MYSQL50 1599729020 anyx 1242731549 anyx file:///%[XDB]%/mysql50.xdb F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 1242731549