1EDA071E-F3C8-4E2A-9591-AF4C52E3AE96 DB_Model DB_Model 1452166299 sirous 1452216373 sirous [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 RevCaseSensitive=No GenTrgrStdMsg=Yes GenTrgrMsgTab= GenTrgrMsgNo= GenTrgrMsgTxt= TrgrPreserve=No TrgrIns=Yes TrgrUpd=Yes TrgrDel=Yes TrgrC2Ins=Yes TrgrC2Upd=Yes TrgrC3=Yes TrgrC4=Yes TrgrC5=Yes TrgrC6=Yes TrgrC7=Yes TrgrC8=Yes TrgrC9=Yes TrgrC10=Yes TrgrC11=Yes TrgrC1=Yes TrgrC12Ins=Yes TrgrC12Upd=Yes TrgrC13=Yes UpdateTableStatistics=Yes UpdateColumnStatistics=Yes [FolderOptions\Physical Objects\Database Generation] GenScriptName=crebas GenScriptName0= GenScriptName1= GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName= GenSingleFile=Yes GenODBC=No GenCheckModel=Yes GenScriptPrev=Yes GenArchiveModel=No GenUseSync=No GenSyncChoice=0 GenSyncArch= GenSyncRmg=0 [FolderOptions\Physical Objects\Database Generation\Format] GenScriptTitle=Yes GenScriptNamLabl=No GenScriptQDtbs=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 [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 Grant=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\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=" DfltDomnName=D_%.U:VALUE% DfltColnName=D_%.U:VALUE% DfltReuse=Yes DfltDrop=Yes [ModelOptions] [ModelOptions\Physical Objects] CaseSensitive=No DisplayName=Yes EnableTrans=No EnableRequirements=No DefaultDttp= IgnoreOwner=No RebuildTrigger=Yes RefrUnique=No RefrAutoMigrate=Yes RefrMigrateReuse=Yes RefrMigrateDomain=Yes RefrMigrateCheck=Yes RefrMigrateRule=Yes RefrMigrateExtd=No RefrMigrDefaultLink=No RefrDfltImpl=D RefrPrgtColn=No RefrMigrateToEnd=No RebuildTriggerDep=No ColnFKName=%.3:PARENT%_%COLUMN% ColnFKNameUse=No DomnCopyDttp=Yes DomnCopyChck=No DomnCopyRule=No DomnCopyMand=No DomnCopyExtd=No DomnCopyProf=No Notation=0 DomnDefaultMandatory=No ColnDefaultMandatory=No TablDefaultOwner= ViewDefaultOwner= TrgrDefaultOwnerTabl= TrgrDefaultOwnerView= IdxDefaultOwnerTabl= IdxDefaultOwnerView= JdxDefaultOwner= DBPackDefaultOwner= SeqDefaultOwner= ProcDefaultOwner= 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= [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN\Code] Template= MaxLen=30 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\TABL\Code] Template= MaxLen=31 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\COLN\Code] Template= MaxLen=31 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\INDX\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\REFR\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\VREF\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\VIEW\Code] Template= MaxLen=31 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [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= [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= [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= [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= [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\FACT\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\DIMN\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [ModelOptions\Physical Objects\ClssNamingOptions\CUBE] [ModelOptions\Physical Objects\ClssNamingOptions\CUBE\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [ModelOptions\Physical Objects\ClssNamingOptions\CUBE\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [ModelOptions\Physical Objects\ClssNamingOptions\MEAS] [ModelOptions\Physical Objects\ClssNamingOptions\MEAS\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [ModelOptions\Physical Objects\ClssNamingOptions\MEAS\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\DATTR\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\FILO\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [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= [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= [ModelOptions\Connection] [ModelOptions\Pdm] [ModelOptions\Generate] [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\Xsm] CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=No [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= 9679706D-CE6D-4FE5-B0B7-DC02C460E033 PostgreSQL 8 PGSQL80 1452166299 sirous 1452166299 sirous 8AF15AEA-CCBC-4EDC-B468-7DB8DB5300B2 4BA9F647-DAB1-11D1-9944-006097355D9B D298CB91-8E27-4585-A02B-4F454C698A34 PhysicalDiagram_1 PhysicalDiagram_1 1452166261 sirous 1452216062 sirous [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Grid size=0 Graphic unit=2 Window color=255, 255, 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255, 255, 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Mode=0 Trunc Length=80 Word Length=80 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=No EObjShowStrn=Yes ExtendedObject.Comment=No ExtendedObject.IconPicture=No ExtendedObject_SymbolLayout= ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout= File Location=No PckgShowStrn=Yes Package.Comment=No Package.IconPicture=No Package_SymbolLayout= Display Model Version=Yes Table.IconPicture=No Table_SymbolLayout= View.IconPicture=No View_SymbolLayout= Procedure.IconPicture=No Procedure_SymbolLayout= FileObject.IconPicture=No FileObject_SymbolLayout= TablColn=Yes ColnMode=0 ColnMax=5 TablIndx=No TablKey=No TablTrgr=No TablOwnr=No ColnDttp=Yes ColnDomn=No ColnShowDomn=No ColnKey=Yes ColnIndx=No ColnMand=No ColnStrn=Yes ViewTabl=Yes ViewIndx=No ViewColn=Yes ViewOwnr=No VColName=Yes VColExpr=No VColDttp=No VColIndx=No VColCMod=0 VColCMax=5 RefrName=No RefrJoin=No RefrCnam=Yes RefrIntg=No RefrImpl=No RefrCard=No RefrStrn=Yes RefrRole=Yes VRefName=No VRefJoin=No VRefStrn=Yes VRefRole=Yes ProcOwnr=No KeyStrn=Yes IndxStrn=Yes TrgrStrn=Yes TablStrn=Yes TablCmmt=No ViewStrn=Yes ViewCmmt=No ProcStrn=No Procedure.Comment=No [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=Arial,8,N STRNFont color=0, 0, 0 DISPNAMEFont=Arial,8,N DISPNAMEFont color=0, 0, 0 LABLFont=Arial,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=Arial,8,N CENTERFont color=0, 0, 0 Line style=2 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\PDMPCKG] STRNFont=Arial,8,N STRNFont color=0, 0, 0 DISPNAMEFont=Arial,8,N DISPNAMEFont color=0, 0, 0 LABLFont=Arial,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=Arial,8,N STRNFont color=0 0 0 DISPNAMEFont=Arial,8,N DISPNAMEFont color=0 0 0 ColumnsFont=宋体,8,N ColumnsFont color=0 0 0 TablePkColumnsFont=Arial,8,U TablePkColumnsFont color=0 0 0 TableFkColumnsFont=Arial,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=Arial,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=210 137 2 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 64 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] DISPNAMEFont=Arial,8,N DISPNAMEFont color=0 0 0 CARDFont=Arial,8,N CARDFont color=0 0 0 Line style=2 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 0 64 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] DISPNAMEFont=Arial,8,N DISPNAMEFont color=0 0 0 Line style=2 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 0 64 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=Arial,8,N STRNFont color=0 0 0 DISPNAMEFont=Arial,8,N DISPNAMEFont color=0 0 0 ColumnsFont=宋体,8,N ColumnsFont color=0 0 0 IndexesFont=Arial,8,N IndexesFont color=0 0 0 TemporaryVTablesFont=宋体,8,N TemporaryVTablesFont color=0 0 0 LABLFont=Arial,8,N LABLFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=233 202 131 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 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=Arial,8,N STRNFont color=0 0 0 DISPNAMEFont=Arial,8,N DISPNAMEFont color=0 0 0 LABLFont=Arial,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\FILO] NAMEFont=Arial,8,N NAMEFont color=0 0 0 AutoAdjustToText=Yes Keep aspect=Yes Keep center=Yes Keep size=No Width=2400 Height=2400 Brush color=255 255 255 Fill Color=No Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=-1 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=Arial,8,N OBJXSTRFont color=0 0 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 0 64 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=Arial,8,N Free TextFont color=0 0 0 Line style=2 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 64 0 Shadow color=192 192 192 Shadow=0 (8268, 11693) ((315,354), (433,354)) 1 15 1452166340 1452166352 ((-10584,21556), (5146,8910)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-1301,-70646), (11727,-76692)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-84914,-50076), (-69570,-57772)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((56438,-11386), (71395,-21557)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-45326,-79693), (-36548,-84090)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((64708,-25381), (79666,-33903)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((7004,-38554), (16941,-47075)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-67344,3436), (-52772,-8385)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((46363,-25381), (61707,-33903)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-57879,-79693), (-48327,-84090)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((40024,-60773), (49576,-67645)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((37708,-50076), (53824,-56948)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((6422,-60773), (20222,-67645)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-15397,-11386), (-439,-21557)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((2561,-11386), (17519,-21557)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((20520,-11386), (35478,-21557)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((70730,-70646), (79508,-75868)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((26491,21556), (41063,8910)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-74295,-79693), (-60881,-84090)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-11151,-60773), (3421,-67645)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((44064,21556), (58636,8910)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-48226,-50076), (-33654,-57772)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-67344,-70646), (-53158,-76692)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-37487,21556), (-23301,7262)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((20133,-25382), (30843,-34728)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-13080,-50076), (1106,-57772)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-33742,-11386), (-18398,-21557)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((19942,-38554), (29879,-47075)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-50158,-70646), (-36744,-76692)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-49386,-38554), (-34814,-47075)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-67730,-11386), (-53544,-22381)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-84916,-38554), (-69958,-47075)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-84916,21556), (-69958,6436)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((41764,-70646), (50156,-76692)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((56825,-50076), (72941,-56948)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-21498,43801), (-6540,27031)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-28722,-60773), (-14150,-67645)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((68027,43801), (83757,28681)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((76523,-60773), (84915,-67645)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-84916,-70646), (-70344,-76692)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((4106,-50076), (18292,-57772)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((57980,3436), (73324,-7560)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-30653,43801), (-24497,26733)) 8421504 8637161 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TemporaryVTables 0 宋体,8,N Indexes 0 Arial,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-20299,21556), (-13585,8612)) 8421504 8637161 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TemporaryVTables 0 宋体,8,N Indexes 0 Arial,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((61637,21556), (70149,9436)) 8421504 8637161 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TemporaryVTables 0 宋体,8,N Indexes 0 Arial,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((-3539,43801), (4973,27557)) 8421504 8637161 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TemporaryVTables 0 宋体,8,N Indexes 0 Arial,8,N LABL 0 Arial,8,N 6 65 16777215 1452166340 1452166352 ((3332,-25382), (17132,-34728)) 16512 166354 12632256 STRN 0 Arial,8,N DISPNAME 0 Arial,8,N Columns 0 宋体,8,N TablePkColumns 0 Arial,8,U TableFkColumns 0 Arial,8,N Keys 0 宋体,8,N Indexes 0 宋体,8,N Triggers 0 宋体,8,N LABL 0 Arial,8,N 6 65 16777215 D082E1B1-3F2B-46C9-A85D-21C9799E0C49 Report 1 Report 1 1452216373 sirous 1452216373 sirous sirous %DATE% LightBlue_Theme.css Header_LightBlue.html Footer_LightBlue.html 54 18 4 Home_LightBlue.html Light Blue Professional 1 6F31FE45-AFE6-4D4D-906B-E76E47525A69 1452216373 sirous 1452216373 sirous 新宋体 10 1 4 423 106 15 0 B127C9D0-96EC-4F64-ADED-D91F9C4AE3FC 1452216373 sirous 1452216373 sirous NSimSun 10 4 0 A9D7788A-5FEF-4CC7-8F0D-D854BCAD4F95 Section_1 1452216373 sirous 1452216373 sirous 1EDA071E-F3C8-4E2A-9591-AF4C52E3AE96 1 TEMPLATE PDM %MODULE% %MODELNAME% %APPNAME% %DATE% Page %PAGE% ((800,900), (1100,900)) ((0,1), (0,0)) (21000, 29700) 26646D90-4998-4435-B4BF-271901965663 1452216373 sirous 1452216373 sirous 1 TBLCTS PDM C4E25C75-ABDB-4FEF-B977-7363828BC181 1452216373 sirous 1452216373 sirous 新宋体 10 5 353 106 0 EC9D4347-CE9D-4E27-BE97-DC7BEA587541 1452216373 sirous 1452216373 sirous NSimSun 10 1 0 81306631-DBB9-43F2-90CD-7FF5950010CA 1452216373 sirous 1452216373 sirous 19100 3 0F3B02A6-7894-4BA5-A0E1-2C08C46749CD 1452216373 sirous 1452216373 sirous NSimSun 10 350 1 0 CD9A8B7A-7935-4312-AC35-5888C2183FA5 1452216373 sirous 1452216373 sirous 19100 3 22A600CF-E8F5-4D62-A906-E4F42CED1AE6 1452216373 sirous 1452216373 sirous NSimSun 10 700 1 0 6E33D57E-9E30-4C67-AC06-51C88F17704E 1452216373 sirous 1452216373 sirous 19100 3 E6687936-5BB3-4810-A455-08F832AB937A 1452216373 sirous 1452216373 sirous NSimSun 10 1050 1 0 CD7D5927-EC5D-4195-9593-1D34EA0CF300 1452216373 sirous 1452216373 sirous 19100 3 8E2DAE76-FCDD-4C53-B607-CFA7C3019D8B 1452216373 sirous 1452216373 sirous NSimSun 10 1400 1 0 DB382890-8E5C-423C-BDAE-A2F5A44343E4 1452216373 sirous 1452216373 sirous 19100 3 85C73996-D602-4FFC-BD78-93CAA18D52A7 1452216373 sirous 1452216373 sirous NSimSun 10 1750 1 0 B57DBF87-62BA-4037-AEC2-C8C4785F2797 1452216373 sirous 1452216373 sirous 19100 3 886FA581-565A-4D58-8FB0-6364262E50FE 1452216373 sirous 1452216373 sirous NSimSun 10 2100 1 0 EACDBC32-87F9-42F3-A349-6D23748F05A8 1452216373 sirous 1452216373 sirous 19100 3 124179EB-2074-4957-AC59-9F53203F988F 1452216373 sirous 1452216373 sirous NSimSun 10 2450 1 0 CAF94DBC-009C-4E2F-89CD-DFCDA77C4411 1452216373 sirous 1452216373 sirous 19100 3 43B8DEE0-F9A4-434E-A9B4-669BBBAC2C7F 1452216373 sirous 1452216373 sirous NSimSun 10 2800 1 0 2D115ABA-28DA-40B4-AB64-4CC13AFA9F0D 1452216373 sirous 1452216373 sirous 19100 3 6F3B49BD-73A1-4373-A2FE-E2388E62180B 1452216373 sirous 1452216373 sirous 1 1 TITLE PDM 简介 81228ACE-E0CC-42B8-A8BC-BE76A2A0A919 1452216373 sirous 1452216373 sirous 1 1 TITLE PDM 描述 0 B95BCB1E-D989-4230-A4F5-9BD077E9E2AE 1452216373 sirous 1452216373 sirous 1 TEXT PDM 24E2AA1F-BE52-4F29-B678-8216AB38CE84 1452216373 sirous 1452216373 sirous NSimSun 10 0 5886BE4A-DDC9-42D5-AF49-721101D33C6B 1452216373 sirous 1452216373 sirous 新宋体 10 5 423 106 0 261A90C4-8CFF-460C-9B80-28B2A57AF3B2 1452216373 sirous 1452216373 sirous 1 1 PDM_MODEL_CARD PDM Card of model %ITEM% Card of model %ITEM% Card of model %ITEM% Name Code DBMS Comment Database BE440AF3-3E72-4D95-8D04-2A106F85BBA3 1452216373 sirous 1452216373 sirous 新宋体 10 5 353 106 2 0 DA5B344C-FAE3-4C41-864F-2D289F3D95BC 1452216373 sirous 1452216373 sirous NSimSun 10 2 1 2 1 6A44E79E-0DFA-48B5-A3B3-CC8925444B3C 1452216373 sirous 1452216373 sirous NSimSun 10 1 2 1 C778A8FB-B975-4A9E-AD25-90570AC9BB40 1452216373 sirous 1452216373 sirous 新宋体 10 5 423 106 0 24313354-5ED2-413D-8555-96262532D960 1452217161 sirous 1452217161 sirous 1 PAGEBREAK PDM 92F68EC3-87BA-4DB1-ACA7-408A14268CB5 1452217161 sirous 1452217161 sirous 1 1 TITLE PDM 简单模型描述 4ADDBC21-49D6-4704-9249-2E18AEE96908 1452217161 sirous 1452217161 sirous 1 1 PDM_MODEL_DIAG_LIST PDM List of diagrams List of diagrams List of diagrams 1 -50 Name -50 Code CECCE99D-5083-465D-AE5F-0A82AB815890 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 43846451-7E90-46E4-BCEE-519AFD7BA186 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 E74CE4E8-899D-4C12-AEFF-C3F1DBFC2024 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 C4432648-E6FB-4ACC-B46A-BB32452651F7 1452217161 sirous 1452217161 sirous FA9DBA38-F819-4A73-9A6B-C8B78F8800DF 1452217161 sirous 1452217161 sirous 1 1 PDM_DIAG_TITLE PDM Diagram %ITEM% Diagram %ITEM% Diagram %ITEM% AllDiagrams A491F3F7-6FE3-4ECD-ADEB-73FF3052E781 1452217161 sirous 1452217161 sirous 1 PDM_GRAPHIC PDM 1 1 84 4A7F9767-3F58-4ABE-97E9-3DE6F7EC8C4F 1452217161 sirous 1452217161 sirous NSimSun 10 4 0 44760E9D-04C9-44F8-BC7B-298E26BFFDBA 1452217161 sirous 1452217161 sirous 1 1 PDM_DIAG_DESC PDM Description of diagram %ITEM% Description of diagram %ITEM% Description of diagram %ITEM% 0248E881-FBB0-4535-AE55-ACDFBA261B25 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 9032D1C9-7966-48A5-9733-C6E8CECF9000 1452217161 sirous 1452217161 sirous NSimSun 10 0 70FD0759-C778-441B-8121-E09BEBCCE42F 1452217161 sirous 1452217161 sirous 1 1 PDM_DIAG_NOTE PDM Annotation of diagram %ITEM% Annotation of diagram %ITEM% Annotation of diagram %ITEM% 666F8134-AB28-478C-9797-46C01A4146C4 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 0B8F56D1-3F7D-4045-A6D8-CB980D77D325 1452217161 sirous 1452217161 sirous NSimSun 10 0 5797C093-F501-4989-BF9D-46426895A653 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 5045DAD9-FA56-4F7D-9CDE-F6AC8F163A69 1452217161 sirous 1452217161 sirous 1 1 PDM_MODEL_TABL_LIST PDM List of tables List of tables List of tables Tables 1 50 Comment 50 Code 22D2D855-F35B-41F4-9B0D-B90E09257E7B 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 91DA3615-5D45-499F-8806-134D9AA31C40 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 380E1547-A01C-452E-BDD1-2C1F69943FF0 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 B4D6EB8B-1532-4287-85D6-79D1268645F4 1452217161 sirous 1452217161 sirous 243C9345-A67B-4A7A-8943-54CBA930482A 1452217161 sirous 1452217161 sirous 1 1 PDM_MODEL_VIEW_LIST PDM List of views List of views List of views Views 1 -50 Name -50 Code 160BDB35-79CC-4852-9600-E9B4E48262DB 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 78BD1C1B-F16B-40AD-B9A1-ABE036A64503 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 72092FA2-1A42-42F7-89F3-0581C07DD8EC 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 7D5864A6-57D3-4271-BE40-AE28397694D3 1452217161 sirous 1452217161 sirous 23F3DC14-593E-460A-9DD0-44DCC8D7CB68 1452217161 sirous 1452217161 sirous 新宋体 10 5 423 106 0 4B679A2D-0A17-461F-B3D0-A25D07D9712F 1452217161 sirous 1452217161 sirous 1 PAGEBREAK PDM ECC973B0-2741-477A-BEC1-4D6FBF04B82F 1452217161 sirous 1452217161 sirous 1 1 TITLE PDM 完全模型描述 05D5CFD3-C1D8-4432-926C-5BF6EB9A314C 1452217161 sirous 1452217161 sirous 1 1 PDM_MODEL_DIAG_LIST PDM List of diagrams List of diagrams List of diagrams 1 -50 Name -50 Code 2667492E-E3CE-482F-9A81-693740624131 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 A883AB57-DE99-42A7-9894-72B8FBA727B6 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 89181DC7-A39D-4325-A751-B98AE17F4EA6 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 0633F67E-0CBE-4D93-8AC4-61CE15E6AF79 1452217161 sirous 1452217161 sirous 0D0FB3E5-C2C9-471D-9F7F-8D1DBC01B337 1452217161 sirous 1452217161 sirous 1 1 PDM_DIAG_TITLE PDM Diagram %ITEM% Diagram %ITEM% Diagram %ITEM% AllDiagrams 6D4F6FAA-E7B0-4D2E-B1E2-EDD687D3841F 1452217161 sirous 1452217161 sirous 1 PDM_GRAPHIC PDM 1 1 84 29C46060-880F-41FD-A48F-9E6DC6B9D76E 1452217161 sirous 1452217161 sirous NSimSun 10 4 0 A8CCC67D-4FDA-45FD-B6CC-BB48B6E3EAA6 1452217161 sirous 1452217161 sirous 1 1 PDM_DIAG_DESC PDM Description of diagram %ITEM% Description of diagram %ITEM% Description of diagram %ITEM% FC716709-D759-42FD-91AA-56CE7259C201 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 8ACCD3BA-1D91-49CD-9F27-5A8A476AA4FE 1452217161 sirous 1452217161 sirous NSimSun 10 0 3832D737-D290-4FF0-8147-9EB2C6F88B7D 1452217161 sirous 1452217161 sirous 1 1 PDM_DIAG_NOTE PDM Annotation of diagram %ITEM% Annotation of diagram %ITEM% Annotation of diagram %ITEM% C5637471-D899-4B93-9B62-C02E4FD98DA0 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 C03EE649-5A78-4F30-B051-1942C05C66F8 1452217161 sirous 1452217161 sirous NSimSun 10 0 FD7B2073-D7B6-430E-BE2F-B42C27D28061 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 D0853939-B0F6-4134-BCA3-D8BE3B6A9AEF 1452217161 sirous 1452217161 sirous 1 1 TITLE PDM 表格清单 BFD68516-8B2A-4B39-B521-095A59D0874A 1452217161 sirous 1452217161 sirous 1 1 PDM_MODEL_TABL_LIST PDM List of tables List of tables List of tables 0 Tables 1 50 Comment 50 Code 9961B844-B60B-45C4-9195-FAA45E14F129 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 ABD40D7D-8D0B-413B-8B86-C50CCF1ADFC2 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 DD75EC49-7717-4C1D-AF3B-92420BDDC1D2 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 432D7D5B-0FCC-4260-9526-112E27605C47 1452217161 sirous 1452217161 sirous D32F47B5-2D99-47D1-9EAC-14C88E0BE44D 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_TITLE PDM Table %ITEM% Table %ITEM% Table %ITEM% Tables 0 643F8459-64A4-4ADE-99CC-43B13BB806F0 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_CARD PDM Card of table %ITEM% Card of table %ITEM% Card of table %ITEM% Name Code 8BA5F27D-EFBE-4386-8F6D-E65E1BC84B68 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 2 0 E98928D1-DA0B-4AA6-9237-CB4532ED9161 1452217161 sirous 1452217161 sirous NSimSun 10 2 1 2 1 F6EA09FB-E5B1-41A4-9EED-604E31F44963 1452217161 sirous 1452217161 sirous NSimSun 10 1 2 1 C03ABAE7-424F-4B9A-BE5E-F1E6EDD9AF59 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_DESC PDM Description of table %ITEM% Description of table %ITEM% Description of table %ITEM% D540F9E0-0978-42A2-9CF7-A6234BE23A69 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 887BAD96-2684-41B9-9712-1A5B2C5BB49A 1452217161 sirous 1452217161 sirous NSimSun 10 0 CF81BD4F-7D25-4049-B519-E59A040C2873 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_NOTE PDM Annotation of table %ITEM% Annotation of table %ITEM% Annotation of table %ITEM% B0932887-93E8-448A-8B42-A6F68955DD7A 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 A4E6423D-F7BA-41DE-A9FB-EE5A673D799B 1452217161 sirous 1452217161 sirous NSimSun 10 0 11CAD96E-8B0D-4C83-A0EF-FAAEC02B8F7D 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_HEAD PDM Begin script of table %ITEM% Begin script of table %ITEM% Begin script of table %ITEM% A0E86035-59BB-4464-AEE0-B16201EB925C 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 214BA38B-F452-4636-891D-834880EA7DD0 1452217161 sirous 1452217161 sirous NSimSun 10 0 A79BB8CF-136A-4FDA-A86C-06A35DB333A2 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_FOOT PDM End script of table %ITEM% End script of table %ITEM% End script of table %ITEM% BA18593C-0E10-4347-A7FB-C16775963A38 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 B86FECC3-886B-43A4-96F2-AC7AFE2B773C 1452217161 sirous 1452217161 sirous NSimSun 10 0 7F1E6DAC-CF83-436C-9879-5975660B6752 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_CRUL PDM Client validation rule of table %ITEM% Client validation rule of table %ITEM% Client validation rule of table %ITEM% 77FDAF05-CB4E-40A5-B8BA-2E2A24B32DF7 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 22F66D04-61EB-4871-98CE-E061853F46C8 1452217161 sirous 1452217161 sirous NSimSun 10 0 8A775583-34D6-4431-B0F3-A96D9F9E0DD9 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_SRUL PDM Server validation rule of table %ITEM% Server validation rule of table %ITEM% Server validation rule of table %ITEM% 9849852F-59B8-46B3-A4D2-F53166C43EF1 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 4E0CFF60-A93D-495D-A3BB-D3F0F4751645 1452217161 sirous 1452217161 sirous NSimSun 10 0 043A20AE-FC59-4A93-9775-019321911A8C 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_OPTS PDM Options of table %ITEM% Options of table %ITEM% Options of table %ITEM% 0AF8F99E-D17F-415B-9136-6260185DD10B 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 064856B6-A8D9-4983-9931-1C08798C6681 1452217161 sirous 1452217161 sirous NSimSun 10 0 0C4DA3A5-4F1F-484C-AB0C-8311989112D3 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_CKCN PDM Check constraint name of table %ITEM% Check constraint name of table %ITEM% Check constraint name of table %ITEM% 6F0F265E-F911-4DD0-9E7E-7B4B3511BE34 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 097F67C6-553E-46F3-A476-AC429BDFBA76 1452217161 sirous 1452217161 sirous NSimSun 10 0 0AE68DC3-1AAB-432B-BE5B-89EA0BE8DB0E 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_RELDIAG_LIST PDM List of related diagrams of the table %PARENT% List of related diagrams of the table %PARENT% List of related diagrams of the table %PARENT% 1 -50 Name -50 Code 614744C9-6A17-4359-BDA6-D62EAF712AD1 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 3C822360-1FB5-40C4-A4A0-B6428DE42A59 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 9E2BED22-1C4E-4779-8891-A79C9A4BFBDF 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 0384B192-7726-4043-BE08-EDC1F833D828 1452217161 sirous 1452217161 sirous 8623F9E7-D3BE-4F43-AD8E-741543BAC341 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_VIEW_LIST PDM List of views of the table %PARENT% List of views of the table %PARENT% List of views of the table %PARENT% 1 -50 Name -50 Code 9890315A-8E48-4E9F-887B-3E5A12C7F3C7 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 C257D2AA-E7A0-4005-8BCD-C65B23A89502 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 C2D63DF6-2A29-40EF-8375-2CBAEB581914 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 465917D6-54CF-451F-B7B8-96FE2735A62F 1452217161 sirous 1452217161 sirous 1435993A-D8D5-44A2-B8BF-AF08A085F5D6 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_ARTC_LIST PDM List of remote articles of the table %PARENT% List of remote articles of the table %PARENT% List of remote articles of the table %PARENT% 1 -100 ShortDescription 2BADD0FB-9564-41FC-8241-A1D53D4421AF 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 8C1C263C-5289-4303-B450-7BD37617F04F 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 DEE956B6-EFAF-4AD2-8862-A88246BEE50B 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 55556B6E-96AC-4008-900D-580CC083BFAB 1452217161 sirous 1452217161 sirous 416C9D40-6457-4BBF-BE9F-29A08F515674 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_SRCARTC_LIST PDM List of source articles of the table %PARENT% List of source articles of the table %PARENT% List of source articles of the table %PARENT% 1 -100 ShortDescription A179535D-AD56-4FD4-9F7F-A53D932F78E4 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 420322C4-9CC9-4D25-9D39-E77E0B9AD9EF 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 319D71EE-97BB-4F6F-A3FD-F056A22D1E14 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 F804F69D-8BD9-415D-A039-C0938A43A2D3 1452217161 sirous 1452217161 sirous 637AB087-4F41-44F7-AA25-C99BCDFCDED2 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_SRCSTEP_LIST PDM List of source step of the table %PARENT% List of source step of the table %PARENT% List of source step of the table %PARENT% 1 -100 ShortDescription 1315633F-EBC2-4BAF-B2C3-CD796365835D 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 2B77B25B-6256-40AA-97E5-C9BBB67D5F86 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 4492380D-BC65-4E13-8A31-3A2FA017AB24 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 FFCD657E-7FCC-40A4-9E56-C45960BC62F6 1452217161 sirous 1452217161 sirous F6849B64-8EB8-4B4B-AFC8-501F8818B76D 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_DSTSTEP_LIST PDM List of target step of the table %PARENT% List of target step of the table %PARENT% List of target step of the table %PARENT% 1 -100 ShortDescription F324CA98-07AA-403E-BC77-A87EA6EF849D 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 F9D3461F-A45C-46CF-8460-4A568B8A7920 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 C7DE5FD5-455B-4029-9DD2-41FBE9EBEA98 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 5F00B3F9-B029-4B90-8002-0B6BE20C0168 1452217161 sirous 1452217161 sirous 8A42EC32-F06E-4A27-9B79-A1AA1F67F7C4 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_COLN_LIST PDM List of columns of the table %PARENT% List of columns of the table %PARENT% List of columns of the table %PARENT% Columns 1 70 Comment 40 Code 50 DataType 15 Length 9CBA293C-E7FE-4170-BDA9-F8E5146E74DA 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 01ED3C51-2519-488C-A15E-EC0C222B911B 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 839C6BC3-CBB4-43F4-8EC2-B5EE980B87A0 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 D05D30F9-CC89-4B04-A7EF-CF6D9C0956B4 1452217161 sirous 1452217161 sirous C3D1A7BD-D085-42F4-8039-3E6C06E771F2 1452217161 sirous 1452217161 sirous 1 1 PDM_TABL_INDX_LIST PDM List of indexes of the table %PARENT% List of indexes of the table %PARENT% List of indexes of the table %PARENT% Indexes 1 -33 Name -33 Code 20 Unique 20 Clustered 20 Primary 20 ForeignKey 20 AlternateKey -33 Table 7BA89039-90D6-4F36-8BE4-E061F97FC59E 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 B4CEAE64-8BFA-4AC9-BB20-29A692580672 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 527E8C08-ED55-4F22-B8DD-3143A8B2CF65 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 80E59413-A5C8-416D-9886-A27CC51AB8AF 1452217161 sirous 1452217161 sirous 2CC2591A-E83B-4BDB-B9F5-8D78603088A5 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 AA2ED459-19F8-4CAB-9079-B746E8759770 1452217161 sirous 1452217161 sirous 新宋体 10 5 423 106 0 266FB3AA-F5B8-4BC0-9C1E-64A449732A2A 1452217161 sirous 1452217161 sirous 1 1 TITLE PDM 视图清单 6731568A-E21B-4BF3-803A-6D899B94491C 1452217161 sirous 1452217161 sirous 1 1 PDM_MODEL_VIEW_LIST PDM List of views List of views List of views 0 Views 1 -50 Name -50 Code 147AFB6D-364B-4CA2-B45C-90C9F61F1A4D 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 9EC7D17B-E61F-4349-B8D0-D39FC7F93E0F 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 4ACC8FDA-6DA0-472D-8D1B-0F1A50B161AB 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 A0F4FB6B-C13E-4F33-BE59-094A1829806D 1452217161 sirous 1452217161 sirous 0094D986-4478-4759-9961-89F17CD9880D 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_TITLE PDM View %ITEM% View %ITEM% View %ITEM% Views 0 1B28358F-381C-4490-BCE7-A6CB575A7410 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_CARD PDM Card of view %ITEM% Card of view %ITEM% Card of view %ITEM% Name Code 58500E1A-2889-4504-B5E6-931BD84FF8E9 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 2 0 6A5A556F-034D-4A9D-8B6B-761ACE212672 1452217161 sirous 1452217161 sirous NSimSun 10 2 1 2 1 DBEA53E3-D414-4FC5-BF2B-A9ED47B8E4C6 1452217161 sirous 1452217161 sirous NSimSun 10 1 2 1 BC920C3B-9974-4A7F-9F50-5AE89301EC47 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_DESC PDM Description of view %ITEM% Description of view %ITEM% Description of view %ITEM% A4CE5BAB-1BFE-4DE7-ACC1-E1B2135490C6 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 4953F1AF-2476-450C-8716-49FF359A643D 1452217161 sirous 1452217161 sirous NSimSun 10 0 17EA2D4E-04ED-4BCD-BA6F-2B0535784EC0 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_NOTE PDM Annotation of view %ITEM% Annotation of view %ITEM% Annotation of view %ITEM% DC374D92-2826-45CF-B58C-13E1036C2796 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 6C9A605F-CC51-44FA-814E-91FD68C0943A 1452217161 sirous 1452217161 sirous NSimSun 10 0 0FD1B079-8F63-48EB-863E-D6D247BF3A42 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_OPTS PDM Options of view %ITEM% Options of view %ITEM% Options of view %ITEM% 2A5D30A7-398F-4C0B-85C2-67DB389D2FC1 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 57358071-AA61-4915-9F5E-2636D1164152 1452217161 sirous 1452217161 sirous NSimSun 10 0 635C5E0F-F8D6-409C-ADFE-A871B642FB9C 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_SQL PDM SQL query of view %ITEM% SQL query of view %ITEM% SQL query of view %ITEM% AAF27D8B-C701-4519-90E8-041552468DAA 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 B80C7142-733F-4EC6-848A-4D1043F936FD 1452217161 sirous 1452217161 sirous NSimSun 10 0 19AE2CF3-A7E4-46C7-9631-318A9919C74E 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_RELDIAG_LIST PDM List of related diagrams of the view %PARENT% List of related diagrams of the view %PARENT% List of related diagrams of the view %PARENT% 1 -50 Name -50 Code EA1AC6A8-F571-4B5C-9016-ECFE57BB5F06 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 8237E911-05BA-4A72-982A-7A1BF9B69D8B 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 C1695F37-CA89-4DDD-9D88-6AA14A55C24A 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 6D552303-C6DE-4AE7-93A8-ACA3881D2075 1452217161 sirous 1452217161 sirous B03CD9DB-7798-476E-83C5-ADAEA9C0BFC4 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_Tables_LIST PDM List of tables of the view %PARENT% List of tables of the view %PARENT% List of tables of the view %PARENT% 1 -50 Name -50 Code 4234B789-B7AA-4ED0-9067-3A849AE46484 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 F5349E22-824A-4A48-8B8D-C48562160E94 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 6076DD79-0BC0-4106-A9AA-84107C9BF41D 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 3826450E-08C0-476C-81E1-BBBA803AE7FE 1452217161 sirous 1452217161 sirous 1A16C66B-932B-4EF7-974A-88558637BACF 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_VIEW_LIST PDM List of views of the view %PARENT% List of views of the view %PARENT% List of views of the view %PARENT% 1 -50 Name -50 Code 12966617-5781-45DD-BFB0-6B661E063CC4 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 C11610F2-843D-4482-9E0F-04778BF3FC95 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 52F67E3E-C6EF-4721-9F8D-56010FACA0BB 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 5E3B7DD8-3161-487D-8CE2-4E19B4D96CEF 1452217161 sirous 1452217161 sirous 6C1A5CA8-A0D3-4A95-BA34-F83C9D5FC6B6 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_ARTC_LIST PDM List of remote articles of the view %PARENT% List of remote articles of the view %PARENT% List of remote articles of the view %PARENT% 1 -100 ShortDescription 838FD0E6-296E-4C08-9EB9-647C97907317 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 3BD1D640-6075-4627-881A-738F4A79ABCB 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 E8A85FCD-1CFA-44FE-8AED-85F510085A79 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 BE8A092D-DED2-4B81-AE92-A7BD30EB3FDF 1452217161 sirous 1452217161 sirous F536D0EC-A258-4C33-9C33-545878A1E6E5 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_SRCARTC_LIST PDM List of source articles of the view %PARENT% List of source articles of the view %PARENT% List of source articles of the view %PARENT% 1 -100 ShortDescription 211F824D-6CC4-42CE-84F9-C21087D34AF4 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 AC15B523-CBBA-44B2-9FDF-1DD9535A48B8 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 A337D910-4144-4501-BF3B-6792C66B698D 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 2F6B6536-8440-4809-A263-A8741155E330 1452217161 sirous 1452217161 sirous 2EDBB16F-3979-4D62-9B7B-9A3784C393E4 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_SRCSTEP_LIST PDM List of source step of the view %PARENT% List of source step of the view %PARENT% List of source step of the view %PARENT% 1 -100 ShortDescription 43942833-373A-4482-BFF9-0388E7554747 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 AE93043B-BA0E-4646-8812-BC39B7BA40B1 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 1DCBC8B4-DC58-4F96-BCE6-594E425F193F 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 18D7DECA-0032-417E-9AE1-2DDEC7EE7C51 1452217161 sirous 1452217161 sirous 9A890A9E-FCF1-4846-B6B5-4DCDE67ADE43 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_DSTSTEP_LIST PDM List of target step of the view %PARENT% List of target step of the view %PARENT% List of target step of the view %PARENT% 1 -100 ShortDescription 80DFCD3C-BB02-4298-82EB-45891008AFD0 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 FDC302CB-78EC-4BAE-B728-8FC091865060 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 0459A316-31C3-4935-94E9-9860FE9A66AC 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 0670A126-D6EF-4B3E-82F4-FCC650BDC524 1452217161 sirous 1452217161 sirous F34A5049-4E62-45BF-8DBB-39B6D867F1EF 1452217161 sirous 1452217161 sirous 1 1 PDM_VIEW_VIEWC_LIST PDM List of view columns of the view %PARENT% List of view columns of the view %PARENT% List of view columns of the view %PARENT% Columns 1 -50 Name -50 Code 2CF34A92-C4DA-4B1E-BECD-C0C5AD4FDEA7 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 069C1993-0FBC-4972-A2F4-CE7F90160F48 1452217161 sirous 1452217161 sirous NSimSun 10 2 4 1 1 E59D19B4-A556-4ED9-AA2C-4A85DBDBDEF0 1452217161 sirous 1452217161 sirous NSimSun 10 1 1 DED302ED-68E0-4774-9405-9EA2E849D967 1452217161 sirous 1452217161 sirous 280A9785-872C-4CA3-826F-FFF288C7E71D 1452217161 sirous 1452217161 sirous 新宋体 10 5 353 106 0 7B17453F-0AA3-49CC-A730-34FE3FBEAE3E 1452217161 sirous 1452217161 sirous 新宋体 10 5 423 106 0 D8DA9420-FE52-4625-9C83-F88542D020B3 1452217161 sirous 1452217161 sirous 新宋体 10 5 423 106 0 A0A5AA73-5AA0-44D6-A8E8-E2D6902CF946 1452216373 sirous 1452216373 sirous NSimSun 10 8 0 1765397B-4994-4E5F-A0BD-7AABC28931C4 1452216373 sirous 1452216373 sirous 19100 3 1729BCCD-9299-4E32-88D6-4C4A1F11429A 1452216373 sirous 1452216373 sirous NSimSun 10 2 0 83A5B7DF-2C77-4246-9D13-61849085394C 1452216373 sirous 1452216373 sirous 9550 2 6AE9D53C-96A2-4CD0-96C8-CF230DF4C32A 1452216373 sirous 1452216373 sirous 19100 3 E5895B2A-FFCB-4308-9D57-10AA771A54A9 Simplified Chinese ZH-CN 1452216373 sirous 1452216373 sirous F3A0BF0F-7536-11D5-A4D6-0008C79B4501 585CBB37-C940-11D1-BD0D-00A02478ECC9 BF2EBEC1-E8C0-4A6D-B0C1-2314100F2B2B DB_Model DB_Model 1452216373 sirous 1452216373 sirous file:///. 1EDA071E-F3C8-4E2A-9591-AF4C52E3AE96 CDE44E21-9669-11D1-9914-006097355D9B C7065BDB-F904-44A6-8265-05D94B385C06 Domain_1 Domain_1 1452166340 sirous 1452166352 sirous BCE25183-208F-436C-8E92-59EC5E87C623 Domain_2 Domain_2 1452166340 sirous 1452166352 sirous 4389B3A9-91B3-4B3C-BAD7-2ADAAD26CFDD Domain_3 Domain_3 1452166340 sirous 1452166352 sirous A828C5FC-712B-4F16-A47D-AE2B781A7FCF Domain_4 Domain_4 1452166340 sirous 1452166352 sirous E187E6C2-1119-4444-949A-0DB232C3F4C6 Domain_5 Domain_5 1452166340 sirous 1452166352 sirous 426B773D-B18E-4573-810E-819CDAB2BDA6 Domain_6 Domain_6 1452166340 sirous 1452166352 sirous 657E1186-DD27-42B6-97B4-1CD861592D56 Domain_7 Domain_7 1452166340 sirous 1452166352 sirous 1341F1FB-1112-4C8C-A088-3EF990A7DD01 Domain_8 Domain_8 1452166340 sirous 1452166352 sirous A036EAEA-61D6-4312-87E5-B299861C7723 Domain_9 Domain_9 1452166340 sirous 1452166352 sirous 8A87CD38-AF26-4A53-92A0-10E64C2545B6 Domain_10 Domain_10 1452166340 sirous 1452166352 sirous 4B8B2B61-2A3C-46AA-9C55-2D35689B1D45 Domain_11 Domain_11 1452166340 sirous 1452166352 sirous BB8D5D20-EABF-4B56-B9BA-0AB1CD94AF67 Domain_12 Domain_12 1452166340 sirous 1452166352 sirous 82B30621-6B0E-43CB-8707-59634AADCA7C Domain_13 Domain_13 1452166340 sirous 1452166352 sirous ECF4CAC1-03F4-45DE-8CFE-CCE2DE468EB9 Domain_14 Domain_14 1452166340 sirous 1452166352 sirous 1186A4AF-1D14-4CC3-97E5-FE3704075685 Domain_15 Domain_15 1452166340 sirous 1452166352 sirous A76B4385-DF9B-4D7B-94C5-3002D4522882 Domain_16 Domain_16 1452166340 sirous 1452166352 sirous B83A06DF-597C-4181-9242-C909A3D0D110 Domain_17 Domain_17 1452166340 sirous 1452166352 sirous 86CFAC14-5E1E-4EE2-876C-D34377E70CCD Domain_18 Domain_18 1452166340 sirous 1452166352 sirous 53116B67-FBBE-4A16-92C5-F279CC5CC767 Domain_19 Domain_19 1452166340 sirous 1452166352 sirous 3DBD0934-68CC-4D16-A5F4-E4453C0DCEF4 Domain_20 Domain_20 1452166340 sirous 1452166352 sirous 07BDCBC4-AEA4-4F11-90CA-6CCBC4382C6D Domain_21 Domain_21 1452166340 sirous 1452166352 sirous 9F51A724-3DD8-4C8B-B219-0C75224550DE Domain_22 Domain_22 1452166340 sirous 1452166352 sirous B51A791B-64A6-4274-A54E-8C979E7DAAD3 Domain_23 Domain_23 1452166340 sirous 1452166352 sirous B8B3DE5F-8E0A-4ADF-9D54-E3C19EE1D6AC Domain_24 Domain_24 1452166340 sirous 1452166352 sirous 47270AAD-04ED-4AEB-BCF3-8C383F134FD0 Domain_25 Domain_25 1452166340 sirous 1452166352 sirous E3DC0F6E-EE25-4136-B838-1892F6D5F7DA Domain_26 Domain_26 1452166340 sirous 1452166352 sirous C4A5EE78-72F1-43A1-A788-D15151DD0A6A Domain_27 Domain_27 1452166340 sirous 1452166352 sirous 64D62C2B-E823-41DC-975E-6788BF93AEBA Domain_28 Domain_28 1452166340 sirous 1452166352 sirous 8D5E5FBD-D010-447A-8D63-FBB308968CEA Domain_29 Domain_29 1452166340 sirous 1452166352 sirous 5567EB7F-2B5A-4809-A9DD-DE0014A4D4AB Domain_30 Domain_30 1452166340 sirous 1452166352 sirous 8212AEDA-6645-451F-89A5-A9515DDA1CC7 Domain_31 Domain_31 1452166340 sirous 1452166352 sirous 729B360D-F239-40ED-A25F-76BE578EA50E Domain_32 Domain_32 1452166340 sirous 1452166352 sirous B71D7CEB-9B0E-43CE-8340-083EEFF13A63 Domain_33 Domain_33 1452166340 sirous 1452166352 sirous F8FEA8A8-09EB-40AC-BDCB-1ADB53F6C610 Domain_34 Domain_34 1452166340 sirous 1452166352 sirous 22C5E6C5-825A-4C14-957E-CC80730D1B7F Domain_35 Domain_35 1452166340 sirous 1452166352 sirous EDD673F7-BDF4-407E-8878-E1B08525024A Domain_36 Domain_36 1452166340 sirous 1452166352 sirous 043A85F0-BBDE-4676-928E-C6DF86598C01 Domain_37 Domain_37 1452166340 sirous 1452166352 sirous 90C7555A-DE93-431A-B356-B553A8B95790 Domain_38 Domain_38 1452166340 sirous 1452166352 sirous A9CC825A-9C4B-442F-B079-B425B058EBEB Domain_39 Domain_39 1452166340 sirous 1452166352 sirous 5ADC66A1-1163-4956-A226-04EFB75D6A58 Domain_40 Domain_40 1452166340 sirous 1452166352 sirous B4CA2F8D-94DB-4E1E-9D24-CFC87225983E Domain_41 Domain_41 1452166340 sirous 1452166352 sirous 475DC278-56D7-47C5-88A0-33D4CFC1E320 Domain_42 Domain_42 1452166340 sirous 1452166352 sirous 3404ACF3-B234-47C3-B585-A3E678212755 Domain_43 Domain_43 1452166340 sirous 1452166352 sirous D21C92FD-8AD0-4310-BB51-7FCD624BD2FE Domain_44 Domain_44 1452166340 sirous 1452166352 sirous C9383989-3F02-4D62-8C18-66836E828272 Domain_45 Domain_45 1452166340 sirous 1452166352 sirous 2584E1CF-339E-4C3E-A1B4-8763EC75CD8C Domain_46 Domain_46 1452166340 sirous 1452166352 sirous 945989F3-B191-4858-A642-7EEF4D25575B Domain_47 Domain_47 1452166340 sirous 1452166352 sirous 6422DF49-0288-46F4-AE09-DDFE33CDCF01 Domain_48 Domain_48 1452166340 sirous 1452166352 sirous 1C347CCC-359B-440B-B9D3-0BAF2B443041 Domain_49 Domain_49 1452166340 sirous 1452166352 sirous 57AA37AA-13E0-4BA1-9645-195C8F041973 Domain_50 Domain_50 1452166340 sirous 1452166352 sirous C56228FF-D307-4973-930E-79626C5A1D91 Domain_51 Domain_51 1452166340 sirous 1452166352 sirous 0F6FE12F-997B-4B49-90F9-F8BFC3E8A982 Domain_52 Domain_52 1452166340 sirous 1452166352 sirous 4088AFE7-2553-4501-8984-361E6DE8D099 Domain_53 Domain_53 1452166340 sirous 1452166352 sirous 573D5425-7AF6-458B-BE8A-2F4B9EF4A7A0 Domain_54 Domain_54 1452166340 sirous 1452166352 sirous AC354DCC-4BCF-403B-B25D-9258F2F03C97 Domain_55 Domain_55 1452166340 sirous 1452166352 sirous 21C2D53F-4051-444C-B4ED-2F14823EFEAE Domain_56 Domain_56 1452166340 sirous 1452166352 sirous 048594E8-29B3-40C1-9638-95762A6A85DB Domain_57 Domain_57 1452166340 sirous 1452166352 sirous A7C5B8F4-D752-4DA3-81A3-E219BCEA6B8A Domain_58 Domain_58 1452166340 sirous 1452166352 sirous E6D9D223-D7B7-4197-B3BF-7196CAEE2D00 Domain_59 Domain_59 1452166340 sirous 1452166352 sirous 61F227F2-4B7B-4C90-9589-8BE5A21DB993 Domain_60 Domain_60 1452166340 sirous 1452166352 sirous EB7F64E2-B183-48CF-A231-8CC44B0D3FC2 Domain_61 Domain_61 1452166340 sirous 1452166352 sirous 8185BB5E-9628-466C-9ADE-9B0C59D81E5A Domain_62 Domain_62 1452166340 sirous 1452166352 sirous 380AF33D-DE4D-46E4-98C3-1E0C0944C856 achivement achivement 1452166340 sirous 1452166352 sirous 作业成绩 24547524-6480-4C23-A01A-748CC77DA8EA achivementid achivementid 1452166340 sirous 1452166352 sirous id integer 1 39370F87-1098-4BE7-8E59-2DD2F1D33D83 uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 8D422DB6-CE2A-4C9E-9352-0313AA77AC8A achivetype achivetype 1452166340 sirous 1452166352 sirous 资料类型 L课程lesson，具体的课程部分；S教师自传资料self L character varying(50) 50 CAC60346-54E1-4573-A6AB-555BCA1011B3 pointcasetype pointcasetype 1452166340 sirous 1452166352 sirous 积分项类别 1 单词（每个） 2 单句（每个） 3 单词学习（整篇） 4 单句练习（整篇） 5 短文朗读（整篇） 6 强化记忆（整篇） 7 短文复诵（整篇） 8 角色扮演（整篇） 9 模拟测试（整篇） integer 80462390-5006-4A53-A195-0729479F67CF objectid objectid 1452166340 sirous 1452166352 sirous 学习对象ID 通常是lessonPartId,指针对于是课程；是教师自传资料的话，就是自传资料ID；如果是单句练习时，就是sentenceId integer F883F037-B914-40C9-9C85-5B3440B075C8 score score 1452166340 sirous 1452166352 sirous 得分 integer 4B7292B5-0B19-43A2-8012-5677E77DEE1C accuracy accuracy 1452166340 sirous 1452166352 sirous 准确度 integer C1B6032B-3044-464B-A13B-E563A6B470EC fluent fluent 1452166340 sirous 1452166352 sirous 流利度 integer C82EE53C-8003-442B-A7AF-35C3505061B0 integrity integrity 1452166340 sirous 1452166352 sirous 完整度 integer 56FE0F04-2C83-4DA9-A044-1E3EF1A65DDF content content 1452166340 sirous 1452166352 sirous 内容 character varying(45000) 45000 FA38104E-BADC-43A1-BBC7-82BEA609710A created created 1452166340 sirous 1452166352 sirous 完成时间 timestamp 1C217360-D660-4474-9703-B6045EAE2735 uuid uuid 1452166340 sirous 1452166352 sirous 好声音随机号 给要上传的好声音给出一个随机号。 character varying(1000) 1000 8A9418AC-22C1-454B-8399-CAA23E3119AF areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 39451A71-960F-46A2-8A2F-0D763D47C5B6 area area 1452166340 sirous 1452166352 sirous 地域 9B5842E5-22E9-4F01-8B22-7F967FB53DF4 areaid areaid 1452166340 sirous 1452166352 sirous 地域id integer 1 CEFFFC5F-32B8-4285-8472-6EE43A09FBF2 areaname areaname 1452166340 sirous 1452166352 sirous 地域名称 character varying(100) 100 7E681041-66E5-4081-BBF6-FA6BAC5790B8 parentid parentid 1452166340 sirous 1452166352 sirous 父地域 integer 5FCDA997-6510-4B2B-8D2F-B1D7BB447A60 server server 1452166340 sirous 1452166352 sirous 服务器 character varying(100) 100 707CB049-2063-4211-9509-B70B69AC45CB port port 1452166340 sirous 1452166352 sirous 端口 integer 5127C103-05FF-4B04-B819-A72947537C00 assigndetail assigndetail 1452166340 sirous 1452166352 sirous 作业细目 2109DCB5-9C17-4CCF-9B0F-2425E3CA8B40 assigndetailid assigndetailid 1452166340 sirous 1452166352 sirous 作业细目id integer 1 86875FC6-3AFD-4428-8F52-7928FF0497EC assignmentid assignmentid 1452166340 sirous 1452166352 sirous 作业id integer F404C708-FFB8-4B19-B3AA-B6E2B575F35F assigntype assigntype 1452166340 sirous 1452166352 sirous 类型 U单元unit，该单元下所有课程；L课程lesson，具体的课程；S教师自传资料self L character varying(50) 50 FD55B9FB-6210-45A1-8562-F9EE90918646 unitid unitid 1452166340 sirous 1452166352 sirous 单元id 如果作业细目类型为3，这里就是0 integer 03C65B04-BEE1-4B3F-98D4-A569B5E121A2 lessonid lessonid 1452166340 sirous 1452166352 sirous 课程id 如果作业细目类型为3，这里就是自传资料的id integer 8DE505D4-B690-47D2-B6AC-818D8CA1F2C0 title title 1452166340 sirous 1452166352 sirous 标题 character varying(200) 200 32F82B26-5672-4354-8C67-BD5115BCF79E areaid areaid 1452166340 sirous 1452166352 sirous 0 integer DD1FC973-DFB1-48FD-B344-3D97119EF087 assignment assignment 1452166340 sirous 1452166352 sirous 作业 60382838-64FD-4053-8CF0-14792355DB19 assignmentid assignmentid 1452166340 sirous 1452166352 sirous 作业id 如果是对全班指定，就是0 integer 1 1D576A2C-C6D2-4FBC-88DC-57182F099B72 teacherid teacherid 1452166340 sirous 1452166352 sirous 教师id bigint DBD30AB1-460A-44AE-80C9-4D4B46DAC198 content content 1452166340 sirous 1452166352 sirous 内容 character varying(300) 300 AD14FCCE-2C46-43A0-9F9A-4300530848AD description description 1452166340 sirous 1452166352 sirous 描述 character varying(5000) 5000 7612FCD5-913C-411E-91D9-E8CBE025E5A8 created created 1452166340 sirous 1452166352 sirous 布置时间 timestamp 05B02930-F347-4521-B25C-147167DCF2D0 starttime starttime 1452166340 sirous 1452166352 sirous 开始时间 timestamp 53FF98C3-B754-463E-B011-EE2A6D210366 endtime endtime 1452166340 sirous 1452166352 sirous 结束时间 timestamp 709B4599-18EC-429C-A7C2-20A5E439D698 status status 1452166340 sirous 1452166352 sirous 状态 1 smallint 28D642A6-B750-48CD-B81B-C7C6964D13B4 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer C3369EB5-1875-4B0E-BC5D-BC5A08CF4799 packagename packagename 1452166340 sirous 1452166352 sirous 资源包名 '' character varying(50) 50 467EED6E-FDB5-4FFB-B465-150EDCA5235A assigntoclass assigntoclass 1452166340 sirous 1452166352 sirous 作业针对班级 EEADC2D2-0AEE-4E6F-BC60-386E45FC82FF classesid classesid 1452166340 sirous 1452166352 sirous 班级id bigint 1 45DE91E4-1F56-4E43-AEA7-FD96A28B902C assignmentid assignmentid 1452166340 sirous 1452166352 sirous 作业id integer 1 E753A620-8F63-4245-87C4-47231D2EFB94 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer A16F469D-41B2-441D-82F0-E6C3BB6EB8EE badgecase badgecase 1452166340 sirous 1452166352 sirous 奖牌奖杯规则 8F260FCC-06A5-4237-A6FB-464CB74CE57E badgecaseid badgecaseid 1452166340 sirous 1452166352 sirous id integer 1 41C9E167-D500-4E1B-8F6F-5F6655EDFFC7 badgecasetype badgecasetype 1452166340 sirous 1452166352 sirous 奖牌类型 1奖牌2奖杯 integer CE5DB1C9-FC51-43F9-B838-433E4219C485 badgecasename badgecasename 1452166340 sirous 1452166352 sirous 奖牌名称 character varying(50) 50 268CBD90-5080-4E88-8EAA-4548AE8E0F6D descrition descrition 1452166340 sirous 1452166352 sirous 奖牌描述 character varying(500) 500 FC1E6B6F-F157-46C0-BEB5-A659E3DDEE98 min min 1452166340 sirous 1452166352 sirous 最低值 integer 9CD56AFA-E3F8-471C-9DBC-0BD21B8E2BAD max max 1452166340 sirous 1452166352 sirous 最高值 integer A2690CF1-43FF-4A3F-89E7-429DDD763E57 created created 1452166340 sirous 1452166352 sirous 创建时间 timestamp B9B7FDAF-DB59-4125-BB8B-14C21414F3CF status status 1452166340 sirous 1452166352 sirous 状态 smallint A0A99D58-F810-4F17-B732-A492E2F5E7D1 badgelog badgelog 1452166340 sirous 1452166352 sirous 奖牌奖杯日志 964A7CDD-F3C0-4BC4-8CA7-6C46EDE6B405 badgelogid badgelogid 1452166340 sirous 1452166352 sirous id integer 1 42453313-51D8-438D-B16D-0882327662B3 userid userid 1452166340 sirous 1452166352 sirous 用户id bigint 948B5516-29CB-4196-97EA-BB5027D77852 badgetype badgetype 1452166340 sirous 1452166352 sirous 奖牌类型 integer 56ECA954-2748-4758-8F55-2B96C770F12B objectid objectid 1452166340 sirous 1452166352 sirous 对象id integer B85712CD-7D83-4EB3-894E-1B117B9C93DD badgecaseid badgecaseid 1452166340 sirous 1452166352 sirous 奖牌项id integer 6673AA9F-81D2-4005-8852-1EB0E4643F4B created created 1452166340 sirous 1452166352 sirous 创建日期 timestamp 557F5339-2867-4CDC-A537-A6CFB06C8F5A areaid areaid 1452166340 sirous 1452166352 sirous 0 integer FF605A9F-6528-4708-B385-008970721F76 pointcasetype pointcasetype 1452166340 sirous 1452166352 sirous 积分项类型，考试、比赛传0 0 integer 22B89489-936E-4150-A19A-A12411B5B6E6 classes classes 1452166340 sirous 1452166352 sirous 班级（小组） FD2B28FA-B39B-4346-8BD6-2873A12ED1DF classesid classesid 1452166340 sirous 1452166352 sirous 班级id bigint 1 5558F4AA-F221-4386-94B1-E7DC78DC4900 classlevel classlevel 1452166340 sirous 1452166352 sirous 班级小初高 学习级别，1幼儿园，2小学，3初中，4高中，5大学 integer 8AC25494-E9AE-4E0D-AAC9-24F1E1A10D97 classname classname 1452166340 sirous 1452166352 sirous 班级名称 character varying(50) 50 50DFFFA9-6B58-4588-9743-9FEBA72B4E09 description description 1452166340 sirous 1452166352 sirous 班级简介 character varying(1000) 1000 210792B9-CBE3-454F-ADF6-B699807E838A schoolyear schoolyear 1452166340 sirous 1452166352 sirous 入学年份 integer FDDD7C69-59D6-4467-A363-7552A99FA939 classorder classorder 1452166340 sirous 1452166352 sirous 班号 integer 393A5D49-98E5-44EB-B37E-C3BD3388146D schoolid schoolid 1452166340 sirous 1452166352 sirous 所属学校 0 bigint ACCCF931-2A75-46A0-8799-CE6A65DD6E76 areaid areaid 1452166340 sirous 1452166352 sirous 所在地域编号 integer F9B575F1-8148-4FD4-96EF-388F5AED077F teacherid teacherid 1452166340 sirous 1452166352 sirous 任课教师 bigint A00CDE8A-8E56-4DD4-97FB-6BBEF174FA6F classtype classtype 1452166340 sirous 1452166352 sirous 班级类别 1是正常的班级，2是教师创建的小组 1 smallint 76D4F9CA-F102-4D43-BDC4-1E137EC5B1C8 status status 1452166340 sirous 1452166352 sirous 状态 1 smallint D5F21D6D-153F-450E-BDDD-084364F7C909 source source 1452166340 sirous 1452166352 sirous 来源 1 smallint F2856CB1-59B7-4ED8-96EB-5E2D268DE163 classmessage classmessage 1452166340 sirous 1452166352 sirous 班级消息 9D4270BD-0661-411C-B981-A909F06477E7 classmessageid classmessageid 1452166340 sirous 1452166352 sirous id integer 1 8FBD8509-50D6-42E3-B6BC-6FA6B5D71A7E content content 1452166340 sirous 1452166352 sirous 内容 character varying(300) 300 EA3E4372-E737-4F96-A0A9-75A67AA2C891 teacherid teacherid 1452166340 sirous 1452166352 sirous 创建老师 bigint 62ED5F5B-021A-4E76-BB10-82FF2C20CE97 created created 1452166340 sirous 1452166352 sirous 创建时间 timestamp 8DA9AC24-EDC7-4703-A9D3-DF67FF49FD85 starttime starttime 1452166340 sirous 1452166352 sirous 开始时间 timestamp FA57538A-1A0F-43C0-B33E-276DA322D991 endtime endtime 1452166340 sirous 1452166352 sirous 结束时间 timestamp 53DD521E-5322-464D-86CA-836BE053F0BF status status 1452166340 sirous 1452166352 sirous 是否有效 1 smallint 62598B52-EC3E-4D11-8485-E9082A469B01 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 3B2E3634-BC01-4E12-82F7-F8D99F28900D classownmessage classownmessage 1452166340 sirous 1452166352 sirous 班级拥有消息 3E893773-79CD-421E-B12E-B4D1EB9BB7AF classesid classesid 1452166340 sirous 1452166352 sirous 班级id bigint 1 51AB3FCD-BCE5-43EC-80D4-2FA4B3957977 classmessageid classmessageid 1452166340 sirous 1452166352 sirous 班级消息id integer 1 E3F7E986-33F0-4126-8918-170AD9CE54C5 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 26C6808F-070D-4914-B9B8-F26FCE3EA971 connectlog connectlog 1452166340 sirous 1452166352 sirous 连接日志 2F14E4DB-269B-4CCC-BBC2-3F78E89CFF76 connectlogid connectlogid 1452166340 sirous 1452166352 sirous 连接日志id integer 1 9625A976-F57B-48E7-8A9C-5E64F7E9376D uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 8B2B3419-68CB-4BFB-8FF7-B5282F368C05 starttime starttime 1452166340 sirous 1452166352 sirous 开始时间 timestamp 761C3DD6-9719-4CCD-AC30-CEC8D5E4CAEB endtime endtime 1452166340 sirous 1452166352 sirous 结束时间 timestamp F5C7612F-FA33-45DC-85BA-75BF2806C560 timelength timelength 1452166340 sirous 1452166352 sirous 时间长度 以秒为单位 0 integer 07F26524-28B4-4E61-A181-4B3A193AB502 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 9D5F77BD-292D-400C-957C-38B10B50B8CF deviceuselog deviceuselog 1452166340 sirous 1452166352 sirous 设备使用日志 0CF4FADE-76BB-4C82-843E-6702CE7B5B00 deviceuselogid deviceuselogid 1452166340 sirous 1452166352 sirous 设备使用日志id integer 1 2DD339D2-B9F3-4CAB-A8DE-F0BB9FD25377 uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 7BC6E56F-4093-4769-904A-3875423A0B0A devicecode devicecode 1452166340 sirous 1452166352 sirous 设备号 character varying(200) 200 B94352EE-A044-4798-839F-CA12C74B141D devicecodechivox devicecodechivox 1452166340 sirous 1452166352 sirous 驰声设备号 驰声SDK提供的设备号 character varying(200) 200 EFD230E5-0336-4465-AC8E-F73261874E47 created created 1452166340 sirous 1452166352 sirous 时间 timestamp C7244E44-1FEF-4E40-BDA3-64CADCEF0E23 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 063F1D13-8A0E-4315-8D37-F291C115F9D4 emoneylog emoneylog 1452166340 sirous 1452166352 sirous 3E币日志 CA5BD7C7-D198-418D-9089-9780AD82D896 emoneylogid emoneylogid 1452166340 sirous 1452166352 sirous 流水号 integer 1 A55B7B0E-464B-4719-BFA3-7EA78DD1640E uid uid 1452166340 sirous 1452166352 sirous 用户id bigint BEC3A869-2DB7-4E0F-B8E6-4B499A8B31D6 howmuch howmuch 1452166340 sirous 1452166352 sirous 使用数目 integer 7423F072-A3F4-4A7D-B3BA-9150FDA73CCA description description 1452166340 sirous 1452166352 sirous 描述 character varying(50) 50 063D65B1-6CEC-4875-8C6B-A274FC8F98E5 created created 1452166340 sirous 1452166352 sirous 创建时间 timestamp DE19A455-E5E8-4458-B9A1-3F40993DFB4D areaid areaid 1452166340 sirous 1452166352 sirous 0 integer E523C426-8784-4830-8DA2-3E0DE0DC4E9B finishassignstat finishassignstat 1452166340 sirous 1452166352 sirous 用户完成作业统计 B688DC6B-07C7-4FE6-A237-0288E1F8B95A uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 1 136A9467-50B8-41CA-9A9B-E9527577DCB7 assignmentid assignmentid 1452166340 sirous 1452166352 sirous 作业id integer 1 FAC7F349-354F-4A43-9527-94111AD244CE content content 1452166340 sirous 1452166352 sirous 内容 character varying(200) 200 FB107010-1B5E-4D37-B0D0-82BDF413CCEC lessoncount lessoncount 1452166340 sirous 1452166352 sirous 作业包括的课程数 integer 6D5F3EC8-3609-40CD-80EF-E5E9C1823521 completecount completecount 1452166340 sirous 1452166352 sirous 已经完成的课程数 integer 4A3BBA1A-09EB-4714-8018-125F3242CC99 created created 1452166340 sirous 1452166352 sirous 创建时间 timestamp 2838C9BB-2395-46F4-A48F-BDC40A5533A5 howmuch howmuch 1452166340 sirous 1452166352 sirous 完成次数 integer 9A6F696A-17DA-4DA7-BBEF-D36C7A3989EA maxscore maxscore 1452166340 sirous 1452166352 sirous 最高成绩 integer 1295366A-485F-42AB-AD56-94DCE0DDE478 avgscore avgscore 1452166340 sirous 1452166352 sirous 平均成绩 integer 522BD910-F3CB-45D6-9A8D-E737CF010015 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 4126A773-82D9-4889-B2E9-8CA84C7CC8FF finishlessonstat finishlessonstat 1452166340 sirous 1452166352 sirous 用户完成课程统计 CEB317D0-D5D0-4962-9B27-5C894B22BADA uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 1 0944FACB-8DBC-43D8-B533-D9B4F9D1DB46 unitid unitid 1452166340 sirous 1452166352 sirous 单元id integer 1 1EB24925-B5C7-429F-AF77-1F47294F7B93 content content 1452166340 sirous 1452166352 sirous 内容 character varying(200) 200 CBBBCFEA-11E5-4594-B5A6-5841A5E825C4 lessoncount lessoncount 1452166340 sirous 1452166352 sirous 单元包括的课程数 integer 7E87FABA-6C2C-48AC-BC91-26710C160386 completecount completecount 1452166340 sirous 1452166352 sirous 已经完成的课程数 integer 269F03EA-EAD2-471B-A6F0-68A5370D6F71 created created 1452166340 sirous 1452166352 sirous 创建时间 timestamp C88D6209-6132-4C9A-92C2-2AEF7F1FF974 howmuch howmuch 1452166340 sirous 1452166352 sirous 完成次数 integer D760C824-EE11-4E26-9D2C-B280DD07377C maxscore maxscore 1452166340 sirous 1452166352 sirous 最高成绩 integer A0A546FF-7869-46C4-B512-89BD30E6CA93 avgscore avgscore 1452166340 sirous 1452166352 sirous 平均成绩 integer CF591677-F0DE-4886-A7D2-F623F77A5EE6 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer E7A485FF-BE95-4169-A34D-681EB6AD6B76 finishwordsstat finishwordsstat 1452166340 sirous 1452166352 sirous 用户完成单词统计 F4FE3E2F-291E-46E2-AFE8-DCD0B33825C6 uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 1 E03B341B-0846-4576-8863-795102CACB09 unitid unitid 1452166340 sirous 1452166352 sirous 单元id integer 1 121F2426-83D8-4800-8B82-6503C5593BAA content content 1452166340 sirous 1452166352 sirous 内容 character varying(200) 200 3FF8A17F-CF36-4658-93A9-7AF12AF53B1C wordscount wordscount 1452166340 sirous 1452166352 sirous 单元包括的单词数 integer 89148DFA-5CE0-484C-BFCE-3D5272303C1F completecount completecount 1452166340 sirous 1452166352 sirous 已经完成的单词数 integer 0A562703-AAB7-43F2-8487-E6289662E308 created created 1452166340 sirous 1452166352 sirous 创建时间 timestamp 8ED5A61C-AD30-4B1A-8056-1B2F67D0CF2C howmuch howmuch 1452166340 sirous 1452166352 sirous 完成次数 integer 41CE8893-44FB-4E17-963F-544410E1D5A8 maxscore maxscore 1452166340 sirous 1452166352 sirous 最高成绩 integer 69523BEB-5C71-4D76-8316-5AE34BFF4318 avgscore avgscore 1452166340 sirous 1452166352 sirous 平均成绩 integer 113DF5D6-526E-42F1-97A6-6904BD4F4709 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 1B65F475-8C12-47F6-9B53-5E07E1675DC3 followship followship 1452166340 sirous 1452166352 sirous 关注 88768B66-DE41-4ABC-9B19-50A9DE06F306 befollower befollower 1452166340 sirous 1452166352 sirous 被关注者 bigint 1 8A124D8E-27E8-41AC-BBBD-8DDAFD6A8167 follower follower 1452166340 sirous 1452166352 sirous 关注者 bigint 1 C909A8D4-564C-4933-9784-8BC01E893068 isclassmate isclassmate 1452166340 sirous 1452166352 sirous 是否同班同学 0 smallint 4FC864E9-1BFF-4C24-8456-16E3F727A1B0 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer F366BD99-D070-4714-83AA-5B0E9C3532D4 goods goods 1452166340 sirous 1452166352 sirous 商品 4F8D8C6C-DA90-4A06-A2C4-0FE052B1CACE goodsid goodsid 1452166340 sirous 1452166352 sirous 商品id integer 1 0786082D-DE4A-4E73-A510-97E2BD96FEE3 goodsname goodsname 1452166340 sirous 1452166352 sirous 商品名 character varying(200) 200 19E176A0-3A6D-45D4-89E8-E26CF4EC4FE3 lessonid lessonid 1452166340 sirous 1452166352 sirous 课程大类 这里是与课程体系的第一级相关联。 integer 2B402D5C-C8AF-4EA8-87C2-F73C123C40B4 goodslevel goodslevel 1452166340 sirous 1452166352 sirous 学年性质 学习级别，1幼儿园，2小学，3初中，4高中，5大学 3 integer 88F9E35F-B586-47B9-9F48-D285BEB365FE wordcount wordcount 1452166340 sirous 1452166352 sirous 单词量 integer 236E4110-BFF9-476B-8FB7-F9C6C0354018 price price 1452166340 sirous 1452166352 sirous 金额（年） integer 5E5A5788-0AB8-4ACA-B621-4B4B673CDF6C description description 1452166340 sirous 1452166352 sirous 说明描述 character varying(1000) 1000 243FD402-AE8C-4259-A405-5322D4C80431 isrecomm isrecomm 1452166340 sirous 1452166352 sirous 是否推荐 0 smallint 3DDE3867-6628-4917-A03C-CA75B55898D4 goodspic goodspic 1452166340 sirous 1452166352 sirous 商品图 character varying(300) 300 0B4A177D-B3D6-4C7C-9178-2C46E232A047 memo memo 1452166340 sirous 1452166352 sirous 备注 character varying(1000) 1000 63B1AADE-8D18-4DDB-902E-E623A6CADE36 rebate rebate 1452166340 sirous 1452166352 sirous 代理商折扣 折扣必须是0-100之间 50 integer FB2E1B18-598D-4589-9CA2-D0CDDAA09F0C tradeprice tradeprice 1452166340 sirous 1452166352 sirous 出货价格 0 integer 426334CC-7E0E-4C4D-9376-039A3C553954 trymonths trymonths 1452166340 sirous 1452166352 sirous 试用月数 1 integer 05059474-CDC0-4B8B-86AC-9992623BAE3F goodsownpackage goodsownpackage 1452166340 sirous 1452166352 sirous 商品包括的资源包 7C635CA2-77F5-40FB-BFD9-EE8E34ED1200 goodsid goodsid 1452166340 sirous 1452166352 sirous 商品id integer 1 C583F2EC-BC0A-4E99-BBCB-7F24F735B29F lessonid lessonid 1452166340 sirous 1452166352 sirous 书的id integer 1 132378DE-B466-4803-9487-3C918F59CB87 coursetype coursetype 1452166340 sirous 1452166352 sirous 类型 L课程 W单词 character varying(50) 50 1 0DEB577B-3D6C-441A-8ED2-B6AD3A8CEF18 goodspricedefi goodspricedefi 1452166340 sirous 1452166352 sirous 商品价格定义 7F1116C9-DDEE-40B0-8E56-BFD56C9A7542 schoolid schoolid 1452166340 sirous 1452166352 sirous 学校ID 0表示所有的学校 bigint 1 7360C3F4-463C-4CA8-8C1C-7A68C1F69C8F goodsid goodsid 1452166340 sirous 1452166352 sirous 商品id 0是基础服务费，设置这个方便扩展 integer 1 79945FBC-579A-47C9-A428-C7796B926D5F years years 1452166340 sirous 1452166352 sirous 年数 integer 1 FF84F3FF-5E47-47CB-9F24-F8B27A903045 price price 1452166340 sirous 1452166352 sirous 单价 integer 43387105-D091-4397-9CED-02085611610E amount amount 1452166340 sirous 1452166352 sirous 总价 integer FB0ACE6B-2424-43E0-A513-CD9A10501D72 description description 1452166340 sirous 1452166352 sirous 说明 character varying(3000) 3000 3CC9FDF6-36DF-4A46-9637-F29A2C357A98 lesson lesson 1452166340 sirous 1452166352 sirous 课程 D7F1BB3C-B14A-4BA7-9E98-3D7A10B3061B lessonid lessonid 1452166340 sirous 1452166352 sirous 课程id integer 1 9BB614CC-4714-4D7F-B64F-65760EDCE518 lessontype lessontype 1452166340 sirous 1452166352 sirous 类别 C课程类别category（指大类）；B课本book ；U单元unit；L课程lesson character varying(50) 50 6372EBB1-8E6F-4C48-BB40-6BDB11B323AC lessonname lessonname 1452166340 sirous 1452166352 sirous 课程名称 character varying(200) 200 82D57A54-5EF5-4334-9F17-D387FF9F076B parentid parentid 1452166340 sirous 1452166352 sirous 父ID integer 4F605742-0BBB-4EEB-91BB-4F994371F098 coursecode coursecode 1452166340 sirous 1452166352 sirous 内部编号 character varying(50) 50 3CCCC26B-CA95-4833-9BBC-01F9722A5B35 description description 1452166340 sirous 1452166352 sirous 描述 character varying(1000) 1000 5B073F0A-5DFB-4B9E-97FF-D758E20B3EB5 orderid orderid 1452166340 sirous 1452166352 sirous 顺序号 integer 437DEF1B-50EF-4F7A-ABF6-C3DB20F912D3 status status 1452166340 sirous 1452166352 sirous 状态 0 失效； 1 有效 1 smallint AC057CB6-EE42-45A2-9D60-52A624D11DD2 bigicon bigicon 1452166340 sirous 1452166352 sirous 图标 character varying(500) 500 3092A3EE-6668-4C98-9632-D92ADCCEE614 version version 1452166340 sirous 1452166352 sirous 版本号 character varying(50) 50 854D5483-C798-4E3E-B571-8DF269D26177 versionno versionno 1452166340 sirous 1452166352 sirous 版本值 初始值为1，以后更新版本加1 1 integer B4869C91-8D8E-44D3-A96A-1F8B161BF294 url url 1452166340 sirous 1452166352 sirous 上传下载地址 character varying(300) 300 9215DDFB-C144-4EEF-856E-307DA193CC22 isrecommend isrecommend 1452166340 sirous 1452166352 sirous 是否推荐 0 smallint 70D31987-27FD-4776-86EB-A8213C642D1E ix_lesson_coursecode ix_lesson_coursecode 1452166340 sirous 1452166352 sirous 1 btree 85F6FDE3-ADB7-4C45-AA26-C9BD5B79CE0F 1452166340 sirous 1452166352 sirous 79FF721D-8253-4D43-994A-E728369E3B96 lessonpart lessonpart 1452166340 sirous 1452166352 sirous 课程部分 83546278-D7B6-4F8A-9DA8-6DC5AF5A7FDE lessonpartid lessonpartid 1452166340 sirous 1452166352 sirous 课程部分ID integer 1 80F5C401-1CEE-465E-84AA-C9B11112FDBF lessonid lessonid 1452166340 sirous 1452166352 sirous 课程ID integer D6968EF2-8EB3-4BDA-B2FE-57F387607C62 title title 1452166340 sirous 1452166352 sirous 标题 character varying(100) 100 B77AD3C9-59F3-4F22-A144-D0E8DBC03191 description description 1452166340 sirous 1452166352 sirous 说明 character varying(500) 500 61D79F4D-4D93-45ED-ACA9-4A8E9763B511 background background 1452166340 sirous 1452166352 sirous 背景图 character varying(200) 200 3F7FFCDC-EF66-44A2-A0AA-8D7C901BB532 orderid orderid 1452166340 sirous 1452166352 sirous 顺序号 smallint D63F4DD5-3380-4ACE-8765-283FA3D8EEE6 status status 1452166340 sirous 1452166352 sirous 状态 0 失效； 1 有效 1 smallint DCB73A0F-71F3-4A10-9859-7D1A7FEBC0D7 lessonrole lessonrole 1452166340 sirous 1452166352 sirous 课程角色 FB4B970E-3738-42DE-A135-B19CB064B33A lessonroleid lessonroleid 1452166340 sirous 1452166352 sirous 课程角色Id integer 1 744D84E2-3AA4-472C-8B95-B7BB8F2FD0E2 lessonid lessonid 1452166340 sirous 1452166352 sirous 课程id integer D39AF4E0-CB95-478A-99B2-3C4253E414B0 name name 1452166340 sirous 1452166352 sirous 名字 名字必须唯一 character varying(50) 50 2BF059C3-6D33-428A-8699-B5CB6F2E71A5 usedgif usedgif 1452166340 sirous 1452166352 sirous 使用图片 character varying(50) 50 3DA85341-8E94-411D-8E3F-1CEAC059FA62 status status 1452166340 sirous 1452166352 sirous 状态 0 失效； 1 有效 1 smallint F4560DEF-9305-49DE-9C2B-1C0A53F7A284 orderinfo orderinfo 1452166340 sirous 1452166352 sirous 订单信息 0465BE7A-7466-453B-816A-BB70731ABDC7 orderinfoid orderinfoid 1452166340 sirous 1452166352 sirous id integer 1 2975D043-346C-4160-9E66-E58EB7F01B27 uid uid 1452166340 sirous 1452166352 sirous 用户ID bigint 1 0D0E3D2A-6CEA-45EF-9FA7-F5501372696A ispayed ispayed 1452166340 sirous 1452166352 sirous 是否支付 0未支付，1已支付 0 smallint BACAAFDE-5198-447B-AF99-EBD4C4264ADC isdeleted isdeleted 1452166340 sirous 1452166352 sirous 是否删除 0未删除，1已删除 0 smallint 17CB69EC-35EC-41A1-B2D0-A0FC642AB3CA payway payway 1452166340 sirous 1452166352 sirous 支付方式 0赠送，1支付宝， 2银联,3微信 smallint 1A6A539E-FB7E-44E5-BA03-CF04C4DA7733 description description 1452166340 sirous 1452166352 sirous 其它说明 character varying(500) 500 2EB0B720-6706-4696-AA36-84B4D0FCCD3E amount amount 1452166340 sirous 1452166352 sirous integer AD87C50B-0752-4537-9C29-6554B030479D gains gains 1452166340 sirous 1452166352 sirous double precision 0BECDDBC-A746-404E-B6CA-EC6C2F92929F fees fees 1452166340 sirous 1452166352 sirous double precision 4A4D757B-DF30-439B-9A2F-A8ABBC0F9EBE created created 1452166340 sirous 1452166352 sirous timestamp AD8B9C27-E3F5-451A-AE14-DB510C177F1E paytime paytime 1452166340 sirous 1452166352 sirous timestamp 0B6064E5-4FFE-46CC-AE7E-7C3250849AC0 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer C3BDE8C2-1175-4503-9771-95FC4880D81D paynumber paynumber 1452166340 sirous 1452166352 sirous 支付号 '' character varying(500) 500 21583A0C-9AB4-43D8-A874-C614D339F18D channel channel 1452166340 sirous 1452166352 sirous 订单渠道 1 PC端;2 微信端 1 integer 62396E38-0362-47FB-8620-85C77EE3DCFE orderno orderno 1452166340 sirous 1452166352 sirous 订单号 订单号= 3E+YYYYMMDDhhmmss+五位随机数 '' character varying(50) 50 806A23CC-15C7-410A-86C2-5DDC381079E5 orderowngoods orderowngoods 1452166340 sirous 1452166352 sirous 订单包括的商品 842E08E2-F841-41A5-BBC8-EBFF6F219C8E orderowngoodsid orderowngoodsid 1452166340 sirous 1452166352 sirous 流水id integer 1 CFE7C6CE-0D8C-469F-8250-15D2FEC89F85 orderinfoid orderinfoid 1452166340 sirous 1452166352 sirous 订单id integer 84E39DC0-D18D-4BF1-A427-F3781171B070 goodsid goodsid 1452166340 sirous 1452166352 sirous 商品id integer 7E2549C8-31BE-4480-A6A9-9F416D1DA390 years years 1452166340 sirous 1452166352 sirous 购买年数 integer 6DF0F66E-96DB-4124-A8AA-05123060AFE3 starttime starttime 1452166340 sirous 1452166352 sirous 开始时间 timestamp B51CA5C7-D21F-426A-9173-FD3A443864AD endtime endtime 1452166340 sirous 1452166352 sirous 结束时间 timestamp 1C87AEC4-E2F8-4008-96E1-F522FAA44B1A price price 1452166340 sirous 1452166352 sirous 单价 用户购买的年数 * 商品金额，是赠送的话为0 integer 1505DE64-045F-48DA-883A-FB68AE8C67C2 amount amount 1452166340 sirous 1452166352 sirous 总价 integer 281EC69E-AA93-4262-B9F9-7EB592D7AE59 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer F28163C9-5A14-4AC9-B25F-025133784088 phonetic phonetic 1452166340 sirous 1452166352 sirous 音标 701DFDD5-F7CE-46F5-8469-A7FA6B3D799E aispeech aispeech 1452166340 sirous 1452166352 sirous API标示 character varying(50) 50 1 D4AF0DFD-B231-4D87-9ED3-8EF0041CD918 content content 1452166340 sirous 1452166352 sirous 内容 character varying(50) 50 E63BA653-6C0F-4797-854C-C1EDB752ED27 origivoice origivoice 1452166340 sirous 1452166352 sirous 原音 character varying(50) 50 BBE70DBB-FA05-4AB5-A665-D2153A5615FA description description 1452166340 sirous 1452166352 sirous 描述 character varying(300) 300 AD1F2603-6A76-4673-9396-A1B3229C4D98 status status 1452166340 sirous 1452166352 sirous 状态 1 smallint FBEE23CC-421A-4FC8-9F5F-E53183E7A304 phonetype phonetype 1452166340 sirous 1452166352 sirous 音标类型 1 integer D5CDC96D-C1C9-470C-B5BE-406E528D5DF9 orderid orderid 1452166340 sirous 1452166352 sirous 顺序 0 integer D60F7732-8A2D-4A89-84E4-BC53272E9770 pointcase pointcase 1452166340 sirous 1452166352 sirous 积分规则 27789F11-F9EB-4CC8-BB83-A25EABEEE3C6 pointcaseid pointcaseid 1452166340 sirous 1452166352 sirous 积分项id integer 1 8700180A-644A-4B6E-A348-AB913807E12E pointcasetype pointcasetype 1452166340 sirous 1452166352 sirous 积分项类别 1 单词（每个） 2 单句（每个） 3 单词学习（整篇） 4 单句练习（整篇） 5 短文朗读（整篇） 6 强化记忆（整篇） 7 短文复诵（整篇） 8 角色扮演（整篇） 9 模拟测试（整篇） integer FDECDCDF-8B03-413A-BE49-31DD20ACEA6E pointcasename pointcasename 1452166340 sirous 1452166352 sirous 积分项名称 character varying(50) 50 B6030C22-F33D-48F0-8ECD-1A8FADB6D3D7 description description 1452166340 sirous 1452166352 sirous 描述 character varying(1000) 1000 8CC0ECDF-08B5-42BB-868B-04B6422EB72A min min 1452166340 sirous 1452166352 sirous 最低值 integer A593F639-5736-48AC-AA48-D06E27465803 max max 1452166340 sirous 1452166352 sirous 最高值 integer D03C8928-E3FC-4641-8B81-38463869D6BC point point 1452166340 sirous 1452166352 sirous 分值 integer 7BA9D015-422A-41C9-90AD-0F3577F32966 emoney emoney 1452166340 sirous 1452166352 sirous 3E币 integer A5109C40-6333-4A35-99DC-DFFB57E91FE1 created created 1452166340 sirous 1452166352 sirous 创建日期 timestamp 4A84DC9B-F426-4C9D-A69E-B1D3A8265E75 status status 1452166340 sirous 1452166352 sirous 状态 1 smallint 2D95A79C-2AE1-4CD8-A4D3-CA1C9F071D99 pointlog pointlog 1452166340 sirous 1452166352 sirous 积分日志 2063DEBE-AC49-4091-9B31-8630EF876BD4 pointlogid pointlogid 1452166340 sirous 1452166352 sirous 流水号 integer 1 37D6B9DB-8BE7-400D-B842-A3CC992CCBC5 uid uid 1452166340 sirous 1452166352 sirous 用户id bigint E76A07E9-CF74-4FF1-9104-87D57F26580A pointcasetype pointcasetype 1452166340 sirous 1452166352 sirous 积分项类别 1 单词（每个） 2 单句（每个） 3 单词学习（整篇） 4 单句练习（整篇） 5 短文朗读（整篇） 6 强化记忆（整篇） 7 短文复诵（整篇） 8 角色扮演（整篇） 9 模拟测试（整篇） integer BA9EF0AB-8E55-4F17-962C-7D08DBA588F1 objectid objectid 1452166340 sirous 1452166352 sirous 对象id integer 08325C83-EA3C-4DF1-8DCD-E053D1819CDC pointcaseid pointcaseid 1452166340 sirous 1452166352 sirous 积分项id integer 61BFB600-D75A-4C2F-9EE8-A4CCF0536FA1 point point 1452166340 sirous 1452166352 sirous 积分 integer A8C30A7E-1E23-422F-98B8-6FCBD835C35B created created 1452166340 sirous 1452166352 sirous 创建日期 timestamp 896573C7-CDF8-48B6-B862-EC6AC5D4A443 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 296BE1F7-6BB3-44D9-A9A2-B9CF31111E7D pronostat pronostat 1452166340 sirous 1452166352 sirous 发音统计 C73B1A58-EA82-4564-B7A0-F9562B556FD2 uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 1 B03A8CA6-72ED-46D2-854E-A2D20F09DCC2 aispeech aispeech 1452166340 sirous 1452166352 sirous API标示 character varying(50) 50 1 B581303A-F5CB-4AF4-AFAC-4E84BD2E99AF totalscore totalscore 1452166340 sirous 1452166352 sirous 总分 0 integer D6955F8A-314E-4BDF-8F4C-543770658C96 totalnum totalnum 1452166340 sirous 1452166352 sirous 总次数 0 integer 6319B1CE-DCA7-4EF8-866E-8992A20F8E27 areaid areaid 1452166340 sirous 1452166352 sirous 地域编号 0 integer 42D32153-E2F5-4BF9-8AE6-E26E933E64DA respackage respackage 1452166340 sirous 1452166352 sirous 课程单词资源包 EE539908-CB45-4B14-AB7E-687F5EB0E74F lessonid lessonid 1452166340 sirous 1452166352 sirous 书的id integer 1 632C294A-BE84-4270-A176-C30B9D2B9C2C coursetype coursetype 1452166340 sirous 1452166352 sirous 类型 L课程 W单词 character varying(50) 50 1 861D2289-6FAE-4E8B-80D6-2042BF5E802F coursecode coursecode 1452166340 sirous 1452166352 sirous 内部编号 character varying(50) 50 ADD0C34D-8847-4B86-B9A6-5D31266B9773 version version 1452166340 sirous 1452166352 sirous 版本号 character varying(50) 50 7B44EFEB-F786-4E54-BEC0-1293E9FE82A9 versionno versionno 1452166340 sirous 1452166352 sirous 版本值 integer 6A415A83-31EB-4F83-8241-392FE5F5A60C packagepic packagepic 1452166340 sirous 1452166352 sirous 包图片 character varying(300) 300 B084D732-C476-4682-9EF2-EFB04A8BD7C8 packagename packagename 1452166340 sirous 1452166352 sirous 资源包名 character varying(50) 50 6E38A0D1-F102-4583-AB6B-05CF41DE62C8 packagetitle packagetitle 1452166340 sirous 1452166352 sirous 包体标题 课程包直接用课程书名，单词包用课程书名+_单词 character varying(200) 200 53D3B739-5DC9-4C5B-A09D-9A44E807C10A school school 1452166340 sirous 1452166352 sirous 学校 ADE864C3-98B7-424B-BD03-F3D7AEFD793F schoolid schoolid 1452166340 sirous 1452166352 sirous 学校Id bigint 1 141B241E-15BB-4331-81BA-46CAF761CF9B schoolname schoolname 1452166340 sirous 1452166352 sirous 学校名称 character varying(50) 50 62667EE6-C8A4-464A-AA20-82410E22A8FE address address 1452166340 sirous 1452166352 sirous 学校地址 character varying(50) 50 44FE2D1C-3CE7-428B-A1C4-484887DA2C99 areaid areaid 1452166340 sirous 1452166352 sirous 所在地域编号 integer 3C04DBF6-BFFD-4BD6-B69A-8C703EA3CE9D telephone telephone 1452166340 sirous 1452166352 sirous 电话 character varying(50) 50 53E2DC05-3474-446A-8DAA-70CF04C8C6CE url url 1452166340 sirous 1452166352 sirous 网址 character varying(50) 50 845109FB-B6AF-434C-BC84-0A8A8ABAE32C contactor contactor 1452166340 sirous 1452166352 sirous 联系人 character varying(50) 50 55D432A7-E1E1-491E-B312-CF506F8A54FA cellphone cellphone 1452166340 sirous 1452166352 sirous 联系人电话 character varying(50) 50 D04DD979-122E-41E1-A0FF-4BD1B65C20ED description description 1452166340 sirous 1452166352 sirous 学校简介 character varying(500) 500 78AA33B7-D599-422F-A33E-6082D95E1701 status status 1452166340 sirous 1452166352 sirous 状态 1 smallint A84A39CC-60AF-4616-9C3B-E8383518B68D servicefee servicefee 1452166340 sirous 1452166352 sirous 基础服务费 基础服务费，主要为了学校打折的问题，有改动时要即时修改。 360 integer 9563EACB-3CCC-4EB7-A4A9-317C1FB4100D sentence sentence 1452166340 sirous 1452166352 sirous 句子 26952BD9-66F6-4FC3-86B2-1DDB3D96ED8F sentenceid sentenceid 1452166340 sirous 1452166352 sirous 句子id integer 1 BA1DC4DA-4494-4986-9A12-BF6F5F9CC5A4 lessonpartid lessonpartid 1452166340 sirous 1452166352 sirous 所属课程部分 所属课程是课程的最低一级 integer FD6D287E-BA9A-41D0-8D6A-A62FF7761251 lessonroleid lessonroleid 1452166340 sirous 1452166352 sirous 课程角色Id integer 4F2F0BD3-FD00-4671-A527-508CD7A54EFF content content 1452166340 sirous 1452166352 sirous 内容 character varying(3000) 3000 2AD52176-EFAB-43F6-B904-997AE113082F translate translate 1452166340 sirous 1452166352 sirous 译文 character varying(1000) 1000 673ED158-5CDA-43C3-846A-A793C6C6E700 origivoice origivoice 1452166340 sirous 1452166352 sirous 原音 character varying(300) 300 2D515058-A0B0-45B3-BCE3-562469BC3B64 orderid orderid 1452166340 sirous 1452166352 sirous 顺序号 smallint F7140174-43DA-44B5-815E-0A458CADA60E status status 1452166340 sirous 1452166352 sirous 状态 0 失效； 1 有效 1 smallint CA45F801-0E53-4B9B-9DBA-3A12189C0DFE student student 1452166340 sirous 1452166352 sirous 学生 20650515-B3EE-40CA-B467-F823FC2BD9FB studentid studentid 1452166340 sirous 1452166352 sirous 学生id bigint 1 900F99E7-29EB-43B4-ACD1-75745A63683B password password 1452166340 sirous 1452166352 sirous 密码 character varying(50) 50 F9D4192E-1159-44BC-863C-8FFA84B121D2 truename truename 1452166340 sirous 1452166352 sirous 真实姓名 character varying(50) 50 947E82ED-B4D4-4BB4-8752-5DBC43784D6F nickname nickname 1452166340 sirous 1452166352 sirous 昵称 character varying(50) 50 3D448038-AFAE-4863-859A-543F925E775F gender gender 1452166340 sirous 1452166352 sirous 性别 1男生，2女生 1 smallint 7C026977-311A-4CCC-B586-81CE965B2236 address address 1452166340 sirous 1452166352 sirous 家庭住址 character varying(50) 50 A20734A0-D7CF-4563-B5D2-79AB3836A68A areaid areaid 1452166340 sirous 1452166352 sirous 所在地域编号 integer 6F8CFE4F-C13A-4C95-9268-C13DD20D9C3F recognizecode recognizecode 1452166340 sirous 1452166352 sirous 学籍号 character varying(50) 50 BF2F857E-AFC5-4738-BB71-3ECB40140547 cellphone cellphone 1452166340 sirous 1452166352 sirous 手机 character varying(50) 50 5A553739-D345-46D8-B5D9-833A24E7A9A1 telephone telephone 1452166340 sirous 1452166352 sirous 电话 character varying(50) 50 3C7E7025-FA39-4AD7-85A8-CB3D4BE63DE4 email email 1452166340 sirous 1452166352 sirous 邮箱 character varying(50) 50 7D61E052-7D5F-4E31-BC84-36DB6AAD9E7F avatar avatar 1452166340 sirous 1452166352 sirous 头像 character varying(500) 500 0FD86F03-AEEA-41F4-B2AA-B922C027AB42 status status 1452166340 sirous 1452166352 sirous 状态 0 未缴费；1 已缴费 1 smallint 11E5B482-B79F-473C-AA50-F87BA5AFEE2A source source 1452166340 sirous 1452166352 sirous 来源 0 互联网； 1 商务谈判的。 1 smallint 9E254CFE-A6D2-488C-B984-04E492592CB1 lastsignin lastsignin 1452166340 sirous 1452166352 sirous 最近登录时间 timestamp 3B4F912E-D68E-40FE-8C67-185E30FACEAE jdtoken jdtoken 1452166340 sirous 1452166352 sirous 京东TOKEN 保存京东的TOKEN，避免下次再输入 '' character varying(300) 300 C7F0026F-E901-4F4F-9254-4A0723E97583 ix_student_recognizecode ix_student_recognizecode 1452166340 sirous 1452166352 sirous 1 btree 6AB248BB-BB7B-42F3-B5A4-07D5A7920481 1452166340 sirous 1452166352 sirous 50049B58-356F-47AC-A71E-2214746369F8 studentownclass studentownclass 1452166340 sirous 1452166352 sirous 学生所属班级 E744BB41-7B25-418A-8F4D-6B43AAD5F5FA studentid studentid 1452166340 sirous 1452166352 sirous 学生 bigint 1 DF0D2B5A-267C-4C80-87CB-33352B01CA1F classesid classesid 1452166340 sirous 1452166352 sirous 班级 bigint 1 999CBC04-8573-47AE-99AA-B5861725A587 isdelegate isdelegate 1452166340 sirous 1452166352 sirous 是否是课代表 0 smallint A7B01C45-7A5D-4CB5-AF32-A202B9C07258 status status 1452166340 sirous 1452166352 sirous 状态 0申请中，1正式的。 1 smallint D9F0CEB7-FCB6-45CA-AF41-DB98DDFCBEFB areaid areaid 1452166340 sirous 1452166352 sirous 0 integer ED6545DB-FADB-4C47-9741-5B4E290B73D0 systemmessage systemmessage 1452166340 sirous 1452166352 sirous 系统消息 B8BA560E-D716-4F17-90C8-4FF554733AA4 systemmessageid systemmessageid 1452166340 sirous 1452166352 sirous id integer 1 115B42CB-08B7-4B10-8805-EB0E7A68B1E1 title title 1452166340 sirous 1452166352 sirous 标题 character varying(100) 100 B53A5E00-C87C-46B6-8771-90AAD6EA0E1B content content 1452166340 sirous 1452166352 sirous 内容 character varying(5000) 5000 7195C02F-D2BC-46BC-B9E0-079701754590 sysmesspic sysmesspic 1452166340 sirous 1452166352 sirous 图片 character varying(500) 500 6C456F36-B933-4B2C-9850-9664005F5F8F created created 1452166340 sirous 1452166352 sirous 创建时间 timestamp 23195256-825F-4B48-AF85-1BA054A90025 status status 1452166340 sirous 1452166352 sirous 是否有效 1 smallint CFD08DC2-7B0E-4ABA-B42A-F23D4516D330 teacher teacher 1452166340 sirous 1452166352 sirous 教师 4C728C6F-C163-4EEE-8447-079A24E0D5A6 teacherid teacherid 1452166340 sirous 1452166352 sirous 教师id bigint 1 48A64EB5-D043-4FD9-9F2F-F63A74B6A0DB schoolid schoolid 1452166340 sirous 1452166352 sirous 学校id 0 bigint 4F4EF6F9-908E-4FB3-9C22-9CB0FE0B7452 loginno loginno 1452166340 sirous 1452166352 sirous 教师登录号 因为有的教师没有教师资格证号，所以生成一个登录号供他们登录用 character varying(50) 50 51B1BDB5-74A9-49A6-8AA2-B29FC3E4280C password password 1452166340 sirous 1452166352 sirous 密码 character varying(50) 50 59416E7A-7D8E-4341-B538-86F0A0B73EDD truename truename 1452166340 sirous 1452166352 sirous 真实姓名 character varying(50) 50 6855B294-A29C-4611-B808-F540FB101DFB nickname nickname 1452166340 sirous 1452166352 sirous 昵称 character varying(50) 50 2C511E07-C856-4752-A7AB-98D612378EFD gender gender 1452166340 sirous 1452166352 sirous 性别 1 smallint DF59AA7F-C46E-4AB9-BC7D-8A9E99B3CD86 address address 1452166340 sirous 1452166352 sirous 家庭住址 character varying(50) 50 67FF3A92-7698-4579-AC7A-0C96B85C7765 areaid areaid 1452166340 sirous 1452166352 sirous 所在地域编号 是指执教学校的地域 integer C3158038-A941-4AA3-AD36-376738A02FDA recognizecode recognizecode 1452166340 sirous 1452166352 sirous 教师资格证 character varying(50) 50 5E0E1ABE-1058-4E8F-BFC5-C370F4590C6D cellphone cellphone 1452166340 sirous 1452166352 sirous 手机 character varying(50) 50 8C9163C1-4757-48E6-920C-C62D321FDB05 telephone telephone 1452166340 sirous 1452166352 sirous 电话 character varying(50) 50 2914E8B1-BC9C-4032-9665-2FA995895AB5 avatar avatar 1452166340 sirous 1452166352 sirous 头像 character varying(100) 100 DD75FEF3-C32A-4122-9D38-D21E0912A097 email email 1452166340 sirous 1452166352 sirous 邮箱 character varying(50) 50 1364480F-CD6F-4DAC-9733-F167C2F2781B status status 1452166340 sirous 1452166352 sirous 状态 1 smallint 9C93F44D-F4CB-41C3-9A84-DD893FA61F7F source source 1452166340 sirous 1452166352 sirous 来源 0 互联网； 1 商务谈判的 1 smallint 1D16AC55-1561-4FCA-8C56-EE9CD92B90AD lastsignin lastsignin 1452166340 sirous 1452166352 sirous 最近登录时间 timestamp 046E1F17-3805-4D48-9182-4B80888D9756 jdtoken jdtoken 1452166340 sirous 1452166352 sirous 京东TOKEN 保存京东的TOKEN，避免下次再输入 '' character varying(300) 300 07DB0B0A-9739-4731-B863-B275C5514038 ix_teachert_loginno ix_teachert_loginno 1452166340 sirous 1452166352 sirous 1 btree 55EF01CB-78C0-40FA-B118-DD7DE64E8BBA 1452166340 sirous 1452166352 sirous 3AFA5BFE-C1E9-4972-A988-F1ED092E8EFA usehelp usehelp 1452166340 sirous 1452166352 sirous 使用帮助 F67FB0E9-07C3-42E0-8EAD-3177F7A313F9 usehelpid usehelpid 1452166340 sirous 1452166352 sirous 使用帮助id integer 1 61A2D2DD-E53B-4E8A-ADC1-44008722C485 title title 1452166340 sirous 1452166352 sirous 标题 character varying(100) 100 04E0F043-C1C0-48E0-899F-9E1508AD5428 description description 1452166340 sirous 1452166352 sirous 描述 character varying(1000) 1000 570B92DF-F722-48DA-84A6-ADB8C61E3FFA importance importance 1452166340 sirous 1452166352 sirous 重要度 10 integer EF9B89D7-94AC-4BCE-8D96-89BA2D027B19 usehelppic usehelppic 1452166340 sirous 1452166352 sirous 使用帮助图片 character varying(300) 300 F2A028F8-9AA8-4CDA-A437-90388E423CBD status status 1452166340 sirous 1452166352 sirous 是否有效 1 smallint 39657E93-F52B-45CB-9E33-5E9AF4B3D553 userhonor userhonor 1452166340 sirous 1452166352 sirous 用户荣誉 A47BEB0B-78B0-4B9E-A6D6-0942E25789DF uid uid 1452166340 sirous 1452166352 sirous 用户ID bigint 1 C14F6786-84EA-4986-B177-DB97D9F93BEC totalpoint totalpoint 1452166340 sirous 1452166352 sirous 用户积分 integer BB480852-5645-4989-9A45-67ADBD414E78 userlevel userlevel 1452166340 sirous 1452166352 sirous 用户级别 character varying(50) 50 D7E15DA6-561C-429B-BD3B-0247490EF594 levelname levelname 1452166340 sirous 1452166352 sirous 荣誉称号 冗余为取数据方便 character varying(50) 50 678BC56A-64EE-4860-9125-229174E754CE totalmoney totalmoney 1452166340 sirous 1452166352 sirous 3E币总数 integer 2A2520F3-460A-4FB3-AFB6-4C696B7379AB goldmedalcount goldmedalcount 1452166340 sirous 1452166352 sirous 金牌数 integer B547274A-C1C1-4BD6-835D-4D37D8974517 silvermedalcount silvermedalcount 1452166340 sirous 1452166352 sirous 银牌数 integer 868EAB2A-16FD-450A-B2F4-C51A0794FFD9 bronzemedalcount bronzemedalcount 1452166340 sirous 1452166352 sirous 铜牌数 integer 945CA460-8F38-4580-9820-727E5FF303E8 cupcount cupcount 1452166340 sirous 1452166352 sirous 奖杯数 integer C3694083-EDC4-4729-A0E6-94020A0B7495 flowercount flowercount 1452166340 sirous 1452166352 sirous 鲜花数 integer 0557AD4C-D8C7-4B59-95E8-0B7F669D11DE totalscore totalscore 1452166340 sirous 1452166352 sirous 总成绩分数 integer 54A263D1-24B7-4475-A878-72BF6D26C79D howmuch howmuch 1452166340 sirous 1452166352 sirous 总次数 integer 2116E8DC-EB41-48D4-AF33-ED0CFB17B264 studyduration studyduration 1452166340 sirous 1452166352 sirous 学习时间 integer A75529EF-D749-4415-B07D-027923A1642D studynum studynum 1452166340 sirous 1452166352 sirous 学习次数 integer AFF7EB99-549D-424A-A38F-186853D2EF8E befollowcount befollowcount 1452166340 sirous 1452166352 sirous 人气 0 integer 4B43E772-4A00-41DC-ADC4-491A36F61928 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 9E38E292-07CC-4980-8A93-B0260C3F432D userownlesson userownlesson 1452166340 sirous 1452166352 sirous 用户拥有课程 906FB419-EF5F-462A-A91F-D005E54B8D6E uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 1 B3E692F4-996C-4240-8010-B6B20D9E78D9 goodsid goodsid 1452166340 sirous 1452166352 sirous 商品ID 商品就是课程 integer 1 2FEBE88C-5917-4B68-A995-E7A4291312C5 starttime starttime 1452166340 sirous 1452166352 sirous 开始时间 timestamp 5D550F1E-AE2E-4219-B7B7-E9A93E2942CE endtime endtime 1452166340 sirous 1452166352 sirous 结束时间 timestamp 02E33003-E0B1-464E-815D-7FE4936A4A7F status status 1452166340 sirous 1452166352 sirous 状态 smallint 0E49E9CC-A2B4-4D00-80C3-73B6DA397472 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer B0C9BBBE-46EC-4654-867F-F79ACCEF3F03 version version 1452166340 sirous 1452166352 sirous 客户端版本 3ABD3C13-C7C5-497E-A2A9-8571AB71615E versionid versionid 1452166340 sirous 1452166352 sirous 版本id integer 1 E286F21D-08EA-4D09-B151-D1A4A61E37C1 versiontype versiontype 1452166340 sirous 1452166352 sirous 版本类型 主要是留作扩展用，1 PC端 1 smallint 0E034A5E-687E-45D2-B70C-AB24C30A7DD2 version version 1452166340 sirous 1452166352 sirous 版本 character varying(50) 50 FD802D2F-5BEB-43D9-B023-B2E72925445A description description 1452166340 sirous 1452166352 sirous 说明 character varying(3000) 3000 7C05616A-7FB7-4E6C-95C5-1231555FEB44 created created 1452166340 sirous 1452166352 sirous 创建日期 timestamp 6EE7571E-E562-421F-AE45-EC5D384A8FAA versiondetail versiondetail 1452166340 sirous 1452166352 sirous 版本内容细目 F6E46867-A887-45AE-9714-CDC8B1BC0F69 pathfile pathfile 1452166340 sirous 1452166352 sirous 完整文件名 包括路径的完整文件名 character varying(300) 300 1 88687843-64C1-48E5-BA7E-37F9158C2323 fileversion fileversion 1452166340 sirous 1452166352 sirous 本文件版本号 具体某个文件的版本号， character varying(50) 50 8502D2E2-6020-4DE2-86FA-36D2AB0F5B62 operatype operatype 1452166340 sirous 1452166352 sirous 操作方式 1,版本号 2,MD5 3,直接覆盖 integer 33FEC280-5FCB-472C-ACB0-D9B083714364 comparetype comparetype 1452166340 sirous 1452166352 sirous 比对类型 1,程序文件 2,系统文件 integer FF7CA984-4E5D-4626-9925-AF32C31EBD65 versionid versionid 1452166340 sirous 1452166352 sirous 对应版本id 对应的版本号 integer DDD334E9-5227-450F-8478-4BFE5AADBBAF versiontype versiontype 1452166340 sirous 1452166352 sirous 版本类型 主要是留作扩展用，1 PC端 1 smallint B879321A-959B-40CD-8269-F8C4CD68249E md5code md5code 1452166340 sirous 1452166352 sirous '' character varying(500) 500 672FD5D4-127B-4E71-AD64-6134C137E2D1 wordachive wordachive 1452166340 sirous 1452166352 sirous 单词成绩 076C3083-5D36-40A8-8BE5-5E13D0087FD1 wordachiveid wordachiveid 1452166340 sirous 1452166352 sirous 单词成绩id integer 1 E85AE34F-150B-4C67-909D-334DCC3B3746 uid uid 1452166340 sirous 1452166352 sirous 用户id bigint 53144F8B-38CB-4095-BCFD-F8D21A4AD5B8 pointcasetype pointcasetype 1452166340 sirous 1452166352 sirous 积分项类别 1 单词（每个） 2 单句（每个） 3 单词学习（整篇） 4 单句练习（整篇） 5 短文朗读（整篇） 6 强化记忆（整篇） 7 短文复诵（整篇） 8 角色扮演（整篇） 9 模拟测试（整篇） integer 8074F464-F4AD-4CB4-B9EB-3CC196893484 wordsid wordsid 1452166340 sirous 1452166352 sirous 单词id integer 00200F47-D941-4F5E-97AA-189E345825A1 score score 1452166340 sirous 1452166352 sirous 得分 integer EFB10280-079C-416F-B764-DF5BF7FD34FD accuracy accuracy 1452166340 sirous 1452166352 sirous 准确度 integer 90ACE4B9-D4CA-41E6-A12E-8B6364AC192E fluent fluent 1452166340 sirous 1452166352 sirous 流利度 integer E51030AF-1451-4380-910E-75A695930761 integrity integrity 1452166340 sirous 1452166352 sirous 完整度 integer B1A23F25-6DF3-485B-8B35-361346CE8EC4 content content 1452166340 sirous 1452166352 sirous 内容 character varying(5000) 5000 3224DD5E-787F-44D4-98CA-00C81BEA9B1A created created 1452166340 sirous 1452166352 sirous 创建时间 timestamp CBECA958-C8C3-4F14-9E0B-2194EC755255 areaid areaid 1452166340 sirous 1452166352 sirous 0 integer 0E270301-3BDC-46B4-AF69-95E3CA016324 words words 1452166340 sirous 1452166352 sirous 生词 E48C8A04-8514-411F-AF7D-FA97BF84C0B3 wordsid wordsid 1452166340 sirous 1452166352 sirous 生词id integer 1 495E6A0C-DDEC-4F50-8F04-3CE809C9CD5D lessonid lessonid 1452166340 sirous 1452166352 sirous 单元id 以前用的是课程ID，现在用的是单元ID. integer FC9C35D2-0EDC-43B2-8810-AC3007FE9E9C content content 1452166340 sirous 1452166352 sirous 单词 character varying(50) 50 462DA173-DB3B-433B-B56C-E5A8482B1821 phonetic phonetic 1452166340 sirous 1452166352 sirous 音标 character varying(50) 50 81CFEF48-6C84-4864-9A90-64CFFA0CC252 picture picture 1452166340 sirous 1452166352 sirous 图片 character varying(200) 200 2255014B-D225-4375-84F9-4B76A25EF73E translate translate 1452166340 sirous 1452166352 sirous 译文 character varying(1000) 1000 B8936EA8-4A51-443F-8A09-6D818C6BE702 example1 example1 1452166340 sirous 1452166352 sirous 例句一 character varying(200) 200 33AB0E3F-B5E0-4BC3-BE32-26825A791B92 example2 example2 1452166340 sirous 1452166352 sirous 例句二 character varying(200) 200 DF30D66E-638F-4D31-BB1F-B418F0C87981 example3 example3 1452166340 sirous 1452166352 sirous 例句三 character varying(200) 200 B37B5348-76DF-4DFD-864A-8BE6FF2EF367 ix_words_lessonidcontent ix_words_lessonidcontent 1452166340 sirous 1452166352 sirous 1 btree B07FC4B4-FCC1-4042-8B85-A1BE9DC89AD4 1452166340 sirous 1452166352 sirous E12BD97F-E872-42D7-80D9-235D86FC86D6 1452166340 sirous 1452166352 sirous 5D2D244D-01BC-4744-97F3-614D01BB4C17 v_baseuser v_baseuser 1452166340 sirous 1452166352 sirous SELECT student.studentid, student.password, student.truename, student.nickname, student.gender, student.address, student.areaid, student.recognizecode, student.cellphone, student.telephone, student.email, student.avatar, student.status, student.source, student.jdtoken, student.lastsignin FROM student UNION SELECT teacher.teacherid AS studentid, teacher.password, teacher.truename, teacher.nickname, teacher.gender, teacher.address, teacher.areaid, teacher.loginno AS recognizecode, teacher.cellphone, teacher.telephone, teacher.avatar AS email, teacher.email AS avatar, teacher.status, teacher.source, teacher.jdtoken, teacher.lastsignin FROM teacher select [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{20650515-B3EE-40CA-B467-F823FC2BD9FB}=studentid], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{900F99E7-29EB-43B4-ACD1-75745A63683B}=password], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{F9D4192E-1159-44BC-863C-8FFA84B121D2}=truename], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{947E82ED-B4D4-4BB4-8752-5DBC43784D6F}=nickname], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{3D448038-AFAE-4863-859A-543F925E775F}=gender], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{7C026977-311A-4CCC-B586-81CE965B2236}=address], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{A20734A0-D7CF-4563-B5D2-79AB3836A68A}=areaid], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{6F8CFE4F-C13A-4C95-9268-C13DD20D9C3F}=recognizecode], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{BF2F857E-AFC5-4738-BB71-3ECB40140547}=cellphone], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{5A553739-D345-46D8-B5D9-833A24E7A9A1}=telephone], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{3C7E7025-FA39-4AD7-85A8-CB3D4BE63DE4}=email], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{7D61E052-7D5F-4E31-BC84-36DB6AAD9E7F}=avatar], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{0FD86F03-AEEA-41F4-B2AA-B922C027AB42}=status], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{11E5B482-B79F-473C-AA50-F87BA5AFEE2A}=source], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{3B4F912E-D68E-40FE-8C67-185E30FACEAE}=jdtoken], [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student].[{9E254CFE-A6D2-488C-B984-04E492592CB1}=lastsignin] from [{CA45F801-0E53-4B9B-9DBA-3A12189C0DFE}=student] UNION select [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{4C728C6F-C163-4EEE-8447-079A24E0D5A6}=teacherid] as studentid, [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{51B1BDB5-74A9-49A6-8AA2-B29FC3E4280C}=password], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{59416E7A-7D8E-4341-B538-86F0A0B73EDD}=truename], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{6855B294-A29C-4611-B808-F540FB101DFB}=nickname], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{2C511E07-C856-4752-A7AB-98D612378EFD}=gender], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{DF59AA7F-C46E-4AB9-BC7D-8A9E99B3CD86}=address], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{67FF3A92-7698-4579-AC7A-0C96B85C7765}=areaid], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{4F4EF6F9-908E-4FB3-9C22-9CB0FE0B7452}=loginno] as recognizecode, [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{5E0E1ABE-1058-4E8F-BFC5-C370F4590C6D}=cellphone], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{8C9163C1-4757-48E6-920C-C62D321FDB05}=telephone], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{2914E8B1-BC9C-4032-9665-2FA995895AB5}=avatar] as email, [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{DD75FEF3-C32A-4122-9D38-D21E0912A097}=email] as avatar, [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{1364480F-CD6F-4DAC-9733-F167C2F2781B}=status], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{9C93F44D-F4CB-41C3-9A84-DD893FA61F7F}=source], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{046E1F17-3805-4D48-9182-4B80888D9756}=jdtoken], [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher].[{1D16AC55-1561-4FCA-8C56-EE9CD92B90AD}=lastsignin] from [{CFD08DC2-7B0E-4ABA-B42A-F23D4516D330}=teacher] 11B837C7-9168-44E7-9D41-FE26162E2A8F studentid studentid 1452166340 sirous 1452166352 sirous 学生id bigint 115685F3-6A2A-4869-AEC2-239C32C56246 password password 1452166340 sirous 1452166352 sirous 密码 character varying(50) 50 A81903A8-1BFB-40E8-9071-A50986EC23EB truename truename 1452166340 sirous 1452166352 sirous 真实姓名 character varying(50) 50 8384FA04-4CC4-4A4A-BF9E-3D6304A01E26 nickname nickname 1452166340 sirous 1452166352 sirous 昵称 character varying(50) 50 B87A4DD8-2347-4CE7-B3B1-56FA65ECFF08 gender gender 1452166340 sirous 1452166352 sirous 性别 1男生，2女生 smallint 67BF0493-5D91-437C-961B-573363DC1D46 address address 1452166340 sirous 1452166352 sirous 家庭住址 character varying(50) 50 4A3AB860-F702-4047-B053-62FCBC8EB9AA areaid areaid 1452166340 sirous 1452166352 sirous 所在地域编号 integer B1E34C38-7FF6-46D2-B934-74D334CF811E recognizecode recognizecode 1452166340 sirous 1452166352 sirous 学籍号 character varying(50) 50 742B9EC6-569A-4124-8AD5-5AC85DF898F6 cellphone cellphone 1452166340 sirous 1452166352 sirous 手机 character varying(50) 50 37FAFB70-7C77-454E-89B7-290C51DE2FC4 telephone telephone 1452166340 sirous 1452166352 sirous 电话 character varying(50) 50 9E0798B3-F1B5-4D24-BD31-B895957C6245 email email 1452166340 sirous 1452166352 sirous 邮箱 character varying(50) 50 5002267E-F25C-462D-816B-2603A64DC213 avatar avatar 1452166340 sirous 1452166352 sirous 头像 character varying(500) 500 3C7FB1EB-F7E0-4565-BF2D-AC2F1D126C9F status status 1452166340 sirous 1452166352 sirous 状态 0 未缴费；1 已缴费 smallint 4C16E668-F74B-4AFF-9F31-7833BE0BCFEE source source 1452166340 sirous 1452166352 sirous 来源 0 互联网； 1 商务谈判的。 smallint AA073AC1-32E0-4292-999F-7ACB6231DB97 jdtoken jdtoken 1452166340 sirous 1452166352 sirous 京东TOKEN 保存京东的TOKEN，避免下次再输入 character varying(300) 300 01268E81-DD22-4A0B-BF71-E3FDD12B624A lastsignin lastsignin 1452166340 sirous 1452166352 sirous 最近登录时间 timestamp EA8145FD-CA8C-4A4D-9D49-D87D624B9574 v_recommbook v_recommbook 1452166340 sirous 1452166352 sirous SELECT 0 AS uid, b.lessonid, c.packagetitle AS lessonname, c.coursetype, c.coursecode, b.orderid, c.packagepic, c.version, c.versionno, c.packagename AS url, b.isrecommend FROM (lesson b JOIN respackage c ON ((((b.lessonid = c.lessonid) AND (b.status = 1)) AND ((c.coursetype)::text = 'L'::text)))) WHERE (b.isrecommend = 1) ORDER BY b.lessonid SELECT 0 AS uid, b.lessonid, c.packagetitle AS lessonname, c.coursetype, c.coursecode, b.orderid, c.packagepic, c.version, c.versionno, c.packagename AS url, b.isrecommend FROM (lesson b JOIN respackage c ON ((((b.lessonid = c.lessonid) AND (b.status = 1)) AND ((c.coursetype)::text = 'L'::text)))) WHERE (b.isrecommend = 1) ORDER BY b.lessonid 1 2585368A-CE79-4801-8066-E1025AD490BF uid uid 1452166340 sirous 1452166352 sirous E039E5D1-7B27-491D-8FDE-283CB983F563 lessonid lessonid 1452166340 sirous 1452166352 sirous 17497DBA-300B-4169-BD67-B3B84F828632 lessonname lessonname 1452166340 sirous 1452166352 sirous 8025197C-21CB-41C8-AC65-990AA62AF817 coursetype coursetype 1452166340 sirous 1452166352 sirous 35091B88-D1F7-48A8-97BE-2B92CB2202BF coursecode coursecode 1452166340 sirous 1452166352 sirous 2C355BB1-B1F8-44E9-8FEB-5ED215A70827 orderid orderid 1452166340 sirous 1452166352 sirous 553FA716-CDA1-493A-880B-30C2C126E808 packagepic packagepic 1452166340 sirous 1452166352 sirous AC862963-722B-45BA-9AAD-540AC8CA00A5 version version 1452166340 sirous 1452166352 sirous FC0B10E2-7FA3-4250-93FC-A2A3C40088F9 versionno versionno 1452166340 sirous 1452166352 sirous CF532039-ADCD-4269-8FBD-3F60BFB974E3 url url 1452166340 sirous 1452166352 sirous AD75E9C6-C4EC-4DC7-87F5-4369AEA46A16 isrecommend isrecommend 1452166340 sirous 1452166352 sirous D467A526-E59F-4522-A39F-C23E6233551B v_studentclass v_studentclass 1452166340 sirous 1452166352 sirous SELECT a.studentid, a.recognizecode, c.classesid, c.classname, c.teacherid, b.isdelegate, a.truename, b.status, a.avatar FROM ((student a JOIN studentownclass b ON ((((a.studentid = b.studentid) AND (a.status = 1)) AND (b.status = 1)))) JOIN classes c ON (((b.classesid = c.classesid) AND (c.status = 1)))) SELECT a.studentid, a.recognizecode, c.classesid, c.classname, c.teacherid, b.isdelegate, a.truename, b.status, a.avatar FROM ((student a JOIN studentownclass b ON ((((a.studentid = b.studentid) AND (a.status = 1)) AND (b.status = 1)))) JOIN classes c ON (((b.classesid = c.classesid) AND (c.status = 1)))) 1 559D6354-AA87-4EEA-8297-57347E9D99E8 studentid studentid 1452166340 sirous 1452166352 sirous 1C4E1D38-62A0-4C3C-8854-42C433775F04 recognizecode recognizecode 1452166340 sirous 1452166352 sirous 44C887D6-4067-46DD-A7B6-D44D1001C941 classesid classesid 1452166340 sirous 1452166352 sirous 8DE4C387-B107-4928-9D33-15DE25239D0B classname classname 1452166340 sirous 1452166352 sirous 40EBD522-E807-4312-BB46-3F9BE0D52459 teacherid teacherid 1452166340 sirous 1452166352 sirous 29FB0CA9-905E-4E2A-A382-835AE4EBB42D isdelegate isdelegate 1452166340 sirous 1452166352 sirous 68853937-6E59-45A4-BA24-F6B09D814B28 truename truename 1452166340 sirous 1452166352 sirous BCC9F290-99F7-46F7-A3EF-56482268BE7B status status 1452166340 sirous 1452166352 sirous 3117C509-A835-4C1B-9B8C-06E1D6DAA291 avatar avatar 1452166340 sirous 1452166352 sirous 4166ACD1-153E-4889-823E-A7D9D6942222 v_userownbook v_userownbook 1452166340 sirous 1452166352 sirous SELECT a.uid, b.lessonid, c.packagetitle AS lessonname, c.coursetype, c.coursecode, b.orderid, c.packagepic, c.version, c.versionno, c.packagename AS url, b.isrecommend, b.lessonname AS bookname FROM ((((userownlesson a JOIN goods m ON ((a.goodsid = m.goodsid))) JOIN goodsownpackage n ON ((a.goodsid = n.goodsid))) JOIN respackage c ON (((n.lessonid = c.lessonid) AND ((n.coursetype)::text = (c.coursetype)::text)))) JOIN lesson b ON (((c.lessonid = b.lessonid) AND (b.status = 1)))) WHERE ((a.starttime <= now()) AND (a.endtime > now())) SELECT a.uid, b.lessonid, c.packagetitle AS lessonname, c.coursetype, c.coursecode, b.orderid, c.packagepic, c.version, c.versionno, c.packagename AS url, b.isrecommend, b.lessonname AS bookname FROM ((((userownlesson a JOIN goods m ON ((a.goodsid = m.goodsid))) JOIN goodsownpackage n ON ((a.goodsid = n.goodsid))) JOIN respackage c ON (((n.lessonid = c.lessonid) AND ((n.coursetype)::text = (c.coursetype)::text)))) JOIN lesson b ON (((c.lessonid = b.lessonid) AND (b.status = 1)))) WHERE ((a.starttime <= now()) AND (a.endtime > now())) 1 0A38DC29-90DA-46EB-8E48-8D1343758483 uid uid 1452166340 sirous 1452166352 sirous 8C59D330-59D7-4235-87A9-73F53AC192A0 lessonid lessonid 1452166340 sirous 1452166352 sirous 28EA9CB0-E07E-47A8-A12F-66B17D7A75B1 lessonname lessonname 1452166340 sirous 1452166352 sirous 0BAA6AC2-8083-4F48-87CE-AF9C21467438 coursetype coursetype 1452166340 sirous 1452166352 sirous E3F8A1B1-610B-4931-A709-B294ACE534F5 coursecode coursecode 1452166340 sirous 1452166352 sirous 3953B884-8DD5-4FC4-8967-708BE4035059 orderid orderid 1452166340 sirous 1452166352 sirous 5AE2F256-4009-45E0-A296-2D9AC4DD7C3A packagepic packagepic 1452166340 sirous 1452166352 sirous 150A7380-3BD7-4631-8E83-4D9DA1162E5D version version 1452166340 sirous 1452166352 sirous 578776B2-DFDF-4065-8AA9-650C2677C150 versionno versionno 1452166340 sirous 1452166352 sirous 87749F33-AA6E-467F-9F52-6C868B8CD3A1 url url 1452166340 sirous 1452166352 sirous 9BFAB9DF-BD97-4E68-8364-CA804DAEFF58 isrecommend isrecommend 1452166340 sirous 1452166352 sirous 2F764FC7-8F7C-4961-9E69-560779585071 bookname bookname 1452166340 sirous 1452166352 sirous 7EA94CFC-0860-43AB-A444-412A8234BED6 PUBLIC PUBLIC 1452166261 sirous 1452166261 sirous 05311207-BA1C-4B06-81DC-85CEC7F6AC64 PostgreSQL 8 PGSQL80 1452166299 sirous 1452166299 sirous file:///%_DBMS%/pgsql8.xdb 8AF15AEA-CCBC-4EDC-B468-7DB8DB5300B2 4BA9F647-DAB1-11D1-9944-006097355D9B 7E3C113E-E391-4FDC-A708-6FA80F9FB133 Simplified Chinese ZH-CN 1452216373 sirous 1452216373 sirous file:///%_RTPLANG%/Chinese.xrl F3A0BF0F-7536-11D5-A4D6-0008C79B4501 585CBB37-C940-11D1-BD0D-00A02478ECC9