1EFA7B8F-E5BE-422B-A0AE-B907AA87924F smartCommunity smartCommunity 1539048464 szc 1552542496 szc [FolderOptions] [FolderOptions\Physical Objects] GenerationCheckModel=Yes GenerationPath= GenerationOptions= GenerationTasks= GenerationTargets= GenerationSelections= RevPkey=Yes RevFkey=Yes RevAkey=Yes RevCheck=Yes RevIndx=Yes RevOpts=Yes RevViewAsTabl=No RevViewOpts=Yes RevSystAsTabl=Yes RevTablPerm=No RevViewPerm=No RevProcPerm=No RevDbpkPerm=No RevSqncPerm=No RevAdtPerm=No RevUserPriv=No RevUserOpts=No RevGrpePriv=No RevRolePriv=No RevDtbsOpts=Yes RevDtbsPerm=No RevViewIndx=Yes RevJidxOpts=Yes RevStats=No RevTspcPerm=No RevCaseSensitive=No GenTrgrStdMsg=Yes GenTrgrMsgTab= GenTrgrMsgNo= GenTrgrMsgTxt= TrgrPreserve=No TrgrIns=Yes TrgrUpd=Yes TrgrDel=Yes TrgrC2Ins=Yes TrgrC2Upd=Yes TrgrC3=Yes TrgrC4=Yes TrgrC5=Yes TrgrC6=Yes TrgrC7=Yes TrgrC8=Yes TrgrC9=Yes TrgrC10=Yes TrgrC11=Yes TrgrC1=Yes TrgrC12Ins=Yes TrgrC12Upd=Yes TrgrC13=Yes UpdateTableStatistics=Yes UpdateColumnStatistics=Yes [FolderOptions\Physical Objects\Database Generation] GenScriptName=smarCommunity.sql GenScriptName0= GenScriptName1= GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName=C:\Users\szc\Desktop\智慧社区\ GenSingleFile=Yes GenODBC=No GenCheckModel=Yes GenScriptPrev=Yes GenArchiveModel=No GenUseSync=No GenSyncChoice=0 GenSyncArch= GenSyncRmg=0 [FolderOptions\Physical Objects\Database Generation\Format] GenScriptTitle=Yes GenScriptNamLabl=No GenScriptQDtbs=No GenScriptQOwnr=Yes GenScriptCase=0 GenScriptEncoding=UTF8 GenScriptNAcct=No IdentifierDelimiter=" [FolderOptions\Physical Objects\Database Generation\Database] Create=Yes Open=Yes Close=Yes Drop=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Database\Create] Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Tablespace] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Tablespace\Create] Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Storage] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\User] Create=Yes Drop=Yes Comment=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\User\Create] Physical Options=No [FolderOptions\Physical Objects\Database Generation\Group] Create=Yes Drop=Yes Comment=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\Role] Create=Yes Drop=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\UserDefinedDataType] Create=Yes Comment=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\UserDefinedDataType\Create] Default value=Yes Check=Yes [FolderOptions\Physical Objects\Database Generation\AbstractDataType] Create=Yes Header=Yes Footer=Yes Drop=Yes Comment=Yes Install JAVA class=Yes Remove JAVA class=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Rule] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Default] Create=Yes Comment=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Sequence] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Table&&Column] [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create] Check=Yes Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create\Check] Constraint declaration=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Column] User datatype=No Default value=Yes Check=Yes Physical Options=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Column\Check] Constraint declaration=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key] [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key\Create] Constraint declaration=No Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key\Create] Constraint declaration=No Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key\Create] Constraint declaration=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Create] Constraint declaration=Yes Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Filter] Primary key=No Foreign key=No Alternate key=No Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [FolderOptions\Physical Objects\Database Generation\View] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\View\Create] Force Column list=No Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewColumn] Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Create] Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Filter] Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\View\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [FolderOptions\Physical Objects\Database Generation\DBMSTrigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Synonym] Create=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Synonym\Filter] Table=Yes View=Yes Proc=Yes Synonym=Yes Database Package=Yes Sequence=Yes [FolderOptions\Physical Objects\Database Generation\JoinIndex] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\JoinIndex\Create] Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Procedure] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Procedure\Create] Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\DatabasePackage] Create=Yes Drop=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\WebService] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Dimension] Create=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Synchronization] GenBackupTabl=1 GenKeepBackTabl=1 GenTmpTablDrop=No GenKeepTablOpts=No [FolderOptions\Physical Objects\Test Data] GenDataPathName= GenDataSinglefile=Yes GenDataScriptName=testdata GenDataScriptName0= GenDataScriptName1= GenDataScriptName2= GenDataScriptName3= GenDataScriptName4= GenDataScriptName5= GenDataScriptName6= GenDataScriptName7= GenDataScriptName8= GenDataScriptName9= GenDataOdbc=0 GenDataDelOld=No GenDataTitle=No GenDataDefNumRows=20 GenDataCommit=0 GenDataPacket=0 GenDataOwner=No GenDataProfNumb= GenDataProfChar= GenDataProfDate= GenDataCSVSeparator=, GenDataFileFormat=CSV GenDataUseWizard=No [FolderOptions\Pdm] IndxIQName=%COLUMN%_%INDEXTYPE% IndxPK=Yes IndxFK=Yes IndxAK=Yes IndxPKName=%TABLE%_PK IndxFKName=%REFR%_FK IndxAKName=%AKEY%_AK IndxPreserve=No IndxThreshold=0 IndxStats=No RefrPreserve=No JidxPreserve=No RbldMultiFact=Yes RbldMultiDim=Yes RbldMultiJidx=Yes CubePreserve=No TablStProcPreserve=No ProcDepPreserve=Yes TrgrDepPreserve=Yes CubeScriptPath= CubeScriptCase=0 CubeScriptEncoding=ANSI CubeScriptNacct=No CubeScriptHeader=No CubeScriptExt=csv CubeScriptExt0=txt CubeScriptExt1= CubeScriptExt2= CubeScriptSep=, CubeScriptDeli=" EstimationYears=0 DfltDomnName=D_%.U:VALUE% DfltColnName=D_%.U:VALUE% DfltReuse=Yes DfltDrop=Yes [FolderOptions\CheckModel] [FolderOptions\CheckModel\Package] [FolderOptions\CheckModel\Package\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\CheckPackageMissTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\DefaultCheckPackageMissTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\CircularReference] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\ConstraintName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\CnstMaxLen] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\CircularDependency] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Package\ShortcutUniqCode] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Table] [FolderOptions\CheckModel\Table\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\UniqIndex] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\MaxLen - NAME] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\EmptyColl - COLNCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\EmptyColl - INDXCOL] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\EmptyColl - KEYCOL] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\SerialColumnNumber] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\EmptyCollYesYes] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\TableIndexes] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\Mapping] CheckSeverity=No FixRequested=Yes CheckRequested=Yes [FolderOptions\CheckModel\Table\MappingSFMap] CheckSeverity=No FixRequested=Yes CheckRequested=Yes [FolderOptions\CheckModel\Table\EmptyColl - PERMCOL] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Table\CheckTablePartitionKey] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\CheckTableStartDate] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\CheckTableRefNoLifecycle] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\CheckTableSourceMapping] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\CheckTablePartialColumnMapping] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\CheckTableKeyColumnMapping] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\CheckTableNotOnLifecycleTablespace] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table\MYSQL50_Table_Table_storage_type] CheckSeverity=No FixRequested=Yes CheckRequested=Yes [FolderOptions\CheckModel\Table.Column] [FolderOptions\CheckModel\Table.Column\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\DomainDivergence] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\ColumnMandatory] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckNumParam] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckPrecSupLng] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckUndefDttp] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\FkeyDttpDivergence] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\FkeyCheckDivergence] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\ColnSqncNoKey] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\ColnSqncDttp] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\SerialColumnFK] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\ColumnCompExpr] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckColumnOneToOneMapping] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckColumnDataTypeMapping] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckColumnNoMapping] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\CheckDttpIncompatibleFormat] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\MYSQL50_Column_Auto_increment_key] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Column\MYSQL50_Column_Datatype_attributes] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index] [FolderOptions\CheckModel\Table.Index\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\EmptyColl - CIDXCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\UndefIndexType] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\IndexColumnCount] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\IQIndxHNGUniq] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\CheckIncludeColl - Tabl] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Index\MYSQL50_Index_Fulltext_indexes_validity] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key] [FolderOptions\CheckModel\Table.Key\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\EmptyColl - COLNCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\CheckIncludeColl - Tabl] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Key\MultiKeySqnc] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Trigger] [FolderOptions\CheckModel\Table.Trigger\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Trigger\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Trigger\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Trigger\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Trigger\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Trigger\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Trigger\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table.Trigger\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Join Index] [FolderOptions\CheckModel\Join Index\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Join Index\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Join Index\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Join Index\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Join Index\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Join Index\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Join Index\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View] [FolderOptions\CheckModel\View\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View\EmptyColl - PERMCOL] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\View.View Index] [FolderOptions\CheckModel\View.View Index\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\EmptyColl - CIDXCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\IndexColumnCount] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View.View Index\CheckIncludeColl - Tabl] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference] [FolderOptions\CheckModel\Reference\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\Reflexive] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\EmptyColl - RFJNCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\IncompleteJoin] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Reference\JoinOrder] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View Reference] [FolderOptions\CheckModel\View Reference\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View Reference\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View Reference\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View Reference\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View Reference\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View Reference\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View Reference\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\View Reference\EmptyColl - VRFJNCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain] [FolderOptions\CheckModel\Domain\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\CheckNumParam] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\CheckPrecSupLng] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\CheckUndefDttp] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Domain\CheckDttpIncompatibleFormat] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default] [FolderOptions\CheckModel\Default\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\DfltValeEmpty] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Default\DfltSameVale] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User] [FolderOptions\CheckModel\User\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\User\UniquePassword] CheckSeverity=No FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Group] [FolderOptions\CheckModel\Group\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\EmptyColl - USERCOL] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Group\UniquePassword] CheckSeverity=No FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Role] [FolderOptions\CheckModel\Role\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Role\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Role\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Role\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Role\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Role\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Role\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Role\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Role\EmptyColl - USERCOL] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure] [FolderOptions\CheckModel\Procedure\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\ProcBodyEmpty] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Procedure\EmptyColl - PERMCOL] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\DBMS Trigger] [FolderOptions\CheckModel\DBMS Trigger\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\DBMS Trigger\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\DBMS Trigger\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\DBMS Trigger\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\DBMS Trigger\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\DBMS Trigger\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\DBMS Trigger\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\DBMS Trigger\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\DBMS Trigger\DbmsTriggerEvent] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source] [FolderOptions\CheckModel\Data Source\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\EmptyColl - MODLSRC] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\DtscTargets] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Source\CheckDataSourceModels] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Horizontal Partitioning] [FolderOptions\CheckModel\Horizontal Partitioning\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Horizontal Partitioning\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Horizontal Partitioning\EmptyColl - PARTCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Horizontal Partitioning\TargetTables] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Vertical Partitioning] [FolderOptions\CheckModel\Vertical Partitioning\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Vertical Partitioning\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Vertical Partitioning\EmptyColl - PARTCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Vertical Partitioning\TargetTables] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table Collapsing] [FolderOptions\CheckModel\Table Collapsing\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table Collapsing\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table Collapsing\EmptyColl - TargetTable] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Table Collapsing\TargetTables] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact] [FolderOptions\CheckModel\Fact\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\EmptyColl - MEASCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\Mapping] CheckSeverity=No FixRequested=Yes CheckRequested=Yes [FolderOptions\CheckModel\Fact\MappingSFMap] CheckSeverity=No FixRequested=Yes CheckRequested=Yes [FolderOptions\CheckModel\Fact\EmptyColl - ALLOLINKCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact\CubeDupAssociation] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension] [FolderOptions\CheckModel\Dimension\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\EmptyColl - DATTRCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\EmptyColl - HIERCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\DimnDupHierarchy] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\DimnDefHierarchy] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension\Mapping] CheckSeverity=No FixRequested=Yes CheckRequested=Yes [FolderOptions\CheckModel\Dimension\MappingSFMap] CheckSeverity=No FixRequested=Yes CheckRequested=Yes [FolderOptions\CheckModel\Dimension\SerialColumnNumber] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Association] [FolderOptions\CheckModel\Association\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Association\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Association\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Association\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Association\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Association\EmptyColl - Hierarchy] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Attribute] [FolderOptions\CheckModel\Dimension.Attribute\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Attribute\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Attribute\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Attribute\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Attribute\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Attribute\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Attribute\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact.Measure] [FolderOptions\CheckModel\Fact.Measure\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact.Measure\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact.Measure\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact.Measure\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact.Measure\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact.Measure\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Fact.Measure\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Hierarchy] [FolderOptions\CheckModel\Dimension.Hierarchy\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Hierarchy\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Hierarchy\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Hierarchy\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Hierarchy\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Hierarchy\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Hierarchy\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Dimension.Hierarchy\EmptyColl - DATTRCOL] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym] [FolderOptions\CheckModel\Synonym\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\MaxLen - NAME] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Synonym\EmptyColl - BASEOBJ] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type] [FolderOptions\CheckModel\Abstract Data Type\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\AdtInstantiable] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type\AdtAbstractUsed] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure] [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\AdtProcUniqName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\UniqueDefinition] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Abstract Data Type.Abstract Data Type Procedure\ReturnDataType] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package] [FolderOptions\CheckModel\Database Package\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\MaxLen - NAME] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\EmptyColl - PROCOL] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package\EmptyColl - CURCOL] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Database Package\EmptyColl - VARCOL] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Database Package\EmptyColl - TYPCOL] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Database Package\EmptyColl - EXCCOL] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Database Package.Database Package Procedure] [FolderOptions\CheckModel\Database Package.Database Package Procedure\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Procedure\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Procedure\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Procedure\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Procedure\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Procedure\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Procedure\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Procedure\UniqueDefinition] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Procedure\EmptyColl - PARM] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Database Package.Database Package Procedure\ReturnDataType] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Sequence] [FolderOptions\CheckModel\Sequence\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Sequence\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Sequence\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Sequence\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Sequence\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Sequence\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Sequence\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Sequence\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor] [FolderOptions\CheckModel\Database Package.Database Package Cursor\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\UniqueDefinition] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\ReturnDataType] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Cursor\EmptyColl - PARM] CheckSeverity=Yes FixRequested=No CheckRequested=No [FolderOptions\CheckModel\Database Package.Database Package Variable] [FolderOptions\CheckModel\Database Package.Database Package Variable\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Variable\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Variable\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Variable\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Variable\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Variable\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Variable\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Variable\CheckUndefDttp] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Type] [FolderOptions\CheckModel\Database Package.Database Package Type\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Type\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Type\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Type\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Type\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Type\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Type\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Type\UniqueDefinition] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Exception] [FolderOptions\CheckModel\Database Package.Database Package Exception\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Exception\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Exception\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Exception\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Exception\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Exception\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database Package.Database Package Exception\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace] [FolderOptions\CheckModel\Tablespace\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Tablespace\IsObjectUsed] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage] [FolderOptions\CheckModel\Storage\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Storage\IsObjectUsed] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database] [FolderOptions\CheckModel\Database\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Database\IsObjectUsed] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service] [FolderOptions\CheckModel\Web Service\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service.Web Operation] [FolderOptions\CheckModel\Web Service.Web Operation\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service.Web Operation\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service.Web Operation\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service.Web Operation\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service.Web Operation\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service.Web Operation\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service.Web Operation\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Web Service.Web Operation\MaxLen - CODE] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle] [FolderOptions\CheckModel\Lifecycle\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\CheckLifecyclePhase] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\CheckLifecycleRetention] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle\CheckPartitionRange] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase] [FolderOptions\CheckModel\Lifecycle.Phase\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckPhaseTbspace] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckPhaseIQTbspace] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckPhaseDuplicateTbspace] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckPhaseTbspaceCurrency] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckPhaseRetention] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckPhaseIdlePeriod] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckPhaseDataSource] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Lifecycle.Phase\CheckPhaseExternalOnFirst] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Replication] [FolderOptions\CheckModel\Replication\PartialReplication] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Business Rule] [FolderOptions\CheckModel\Business Rule\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Business Rule\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Business Rule\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Business Rule\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Business Rule\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Business Rule\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Business Rule\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Business Rule\EmptyColl - OBJCOL] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Object] [FolderOptions\CheckModel\Extended Object\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Object\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Object\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Object\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Object\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Object\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Object\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Link] [FolderOptions\CheckModel\Extended Link\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Link\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Link\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Link\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Link\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Link\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Extended Link\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\File] [FolderOptions\CheckModel\File\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\File\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\File\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\File\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\File\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\File\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\File\CheckPathExists] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Format] [FolderOptions\CheckModel\Data Format\CheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Format\CheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Format\DefaultCheckUseOnlyTerms] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Format\DefaultCheckUseTermBySynonym] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Format\NotApprovedTerms] CheckSeverity=Yes FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Format\UniqueName] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Format\UniqueCode] CheckSeverity=No FixRequested=No CheckRequested=Yes [FolderOptions\CheckModel\Data Format\CheckDataFormatNullExpression] CheckSeverity=No FixRequested=No CheckRequested=Yes [ModelOptions] [ModelOptions\Physical Objects] CaseSensitive=No DisplayName=Yes EnableTrans=No UseTerm=No EnableRequirements=No EnableFullShortcut=Yes DefaultDttp= IgnoreOwner=No RebuildTrigger=Yes RefrUnique=No RefrAutoMigrate=Yes RefrMigrateReuse=Yes RefrMigrateDomain=Yes RefrMigrateCheck=Yes RefrMigrateRule=Yes RefrMigrateExtd=No RefrMigrDefaultLink=No RefrDfltImpl=D RefrPrgtColn=No RefrMigrateToEnd=No RebuildTriggerDep=No ColnFKName=%.3:PARENT%_%COLUMN% ColnFKNameUse=No DomnCopyDttp=Yes DomnCopyChck=No DomnCopyRule=No DomnCopyMand=No DomnCopyExtd=No DomnCopyProf=No Notation=0 DomnDefaultMandatory=No ColnDefaultMandatory=No TablDefaultOwner= ViewDefaultOwner= TrgrDefaultOwnerTabl= TrgrDefaultOwnerView= IdxDefaultOwnerTabl= IdxDefaultOwnerView= JdxDefaultOwner= DBPackDefaultOwner= SeqDefaultOwner= ProcDefaultOwner= DBMSTrgrDefaultOwner= Currency=USD RefrDeleteConstraint=1 RefrUpdateConstraint=1 RefrParentMandatory=No RefrParentChangeAllow=Yes RefrCheckOnCommit=No [ModelOptions\Physical Objects\NamingOptionsTemplates] [ModelOptions\Physical Objects\ClssNamingOptions] [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG] [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMPCKG\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN] [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\PDMDOMN\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\TABL] [ModelOptions\Physical Objects\ClssNamingOptions\TABL\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\TABL\Code] Template= MaxLen=64 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\COLN] [ModelOptions\Physical Objects\ClssNamingOptions\COLN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\COLN\Code] Template= MaxLen=64 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\INDX] [ModelOptions\Physical Objects\ClssNamingOptions\INDX\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\INDX\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\REFR] [ModelOptions\Physical Objects\ClssNamingOptions\REFR\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\REFR\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VREF] [ModelOptions\Physical Objects\ClssNamingOptions\VREF\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VREF\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEW] [ModelOptions\Physical Objects\ClssNamingOptions\VIEW\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEW\Code] Template= MaxLen=64 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC] [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\VIEWC\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV] [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBSERV\Code] Template= MaxLen=254 Case=M ValidChar='a'-'z','A'-'Z','0'-'9',"/-_.!~*'()" InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP] [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WEBOP\Code] Template= MaxLen=254 Case=M ValidChar='a'-'z','A'-'Z','0'-'9',"/-_.!~*'()" InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM] [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\WPARAM\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FACT] [ModelOptions\Physical Objects\ClssNamingOptions\FACT\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FACT\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DIMN] [ModelOptions\Physical Objects\ClssNamingOptions\DIMN\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DIMN\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\MEAS] [ModelOptions\Physical Objects\ClssNamingOptions\MEAS\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\MEAS\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DATTR] [ModelOptions\Physical Objects\ClssNamingOptions\DATTR\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DATTR\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FILO] [ModelOptions\Physical Objects\ClssNamingOptions\FILO\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FILO\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ] [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMEOBJ\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK] [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\FRMELNK\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass] [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass\Name] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Physical Objects\ClssNamingOptions\DefaultClass\Code] Template= MaxLen=254 Case=M ValidChar= InvldChar= AllValid=Yes NoAccent=No DefaultChar= Script= ConvTable= ConvTablePath=%_HOME%\Resource Files\Conversion Tables [ModelOptions\Connection] [ModelOptions\Pdm] [ModelOptions\Generate] [ModelOptions\Generate\Xsm] GenRootElement=Yes GenComplexType=No GenAttribute=Yes CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=No [ModelOptions\Generate\Pdm] RRMapping=No [ModelOptions\Generate\Cdm] CheckModel=Yes SaveLinks=Yes NameToCode=No Notation=2 [ModelOptions\Generate\Oom] CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=Yes ClassPrefix= [ModelOptions\Generate\Ldm] CheckModel=Yes SaveLinks=Yes NameToCode=No [ModelOptions\Default Opts] [ModelOptions\Default Opts\TABL] PhysOpts= [ModelOptions\Default Opts\COLN] PhysOpts= [ModelOptions\Default Opts\INDX] PhysOpts= [ModelOptions\Default Opts\AKEY] PhysOpts= [ModelOptions\Default Opts\PKEY] PhysOpts= [ModelOptions\Default Opts\STOR] PhysOpts= [ModelOptions\Default Opts\TSPC] PhysOpts= [ModelOptions\Default Opts\SQNC] PhysOpts= [ModelOptions\Default Opts\DTBS] PhysOpts= [ModelOptions\Default Opts\USER] PhysOpts= [ModelOptions\Default Opts\JIDX] PhysOpts= 940C582D-5AF9-49FA-9BE3-CEE4662F01D5 MySQL 5.0 MYSQL50 1539048464 szc 1539048464 szc F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 89224824-3A5D-4A36-8DB5-0E8FE3FE86C6 PhysicalDiagram_1 PhysicalDiagram_1 1539048464 szc 1552542496 szc [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Show Links intersections=Yes Activate automatic link routing=Yes Grid size=0 Graphic unit=2 Window color=255, 255, 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255, 255, 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Show Icon=No Mode=2 Trunc Length=40 Word Length=40 Word Text=!"#$%&')*+,-./:;=>?@\]^_`|}~ Shortcut IntIcon=Yes Shortcut IntLoct=Yes Shortcut IntFullPath=No Shortcut IntLastPackage=Yes Shortcut ExtIcon=Yes Shortcut ExtLoct=No Shortcut ExtFullPath=No Shortcut ExtLastPackage=Yes Shortcut ExtIncludeModl=Yes EObjShowStrn=Yes ExtendedObject.Comment=No ExtendedObject.IconPicture=No ExtendedObject.TextStyle=No ExtendedObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Object Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Source" >[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] </Form>[CRLF]</Form> FileObject.Stereotype=No FileObject.DisplayName=Yes FileObject.LocationOrName=No FileObject.IconPicture=No FileObject.TextStyle=No FileObject.IconMode=Yes FileObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Location" Attribute="LocationOrName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Package.Stereotype=Yes Package.Comment=No Package.IconPicture=No Package.TextStyle=No Package_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Display Model Version=Yes Table.Stereotype=Yes Table.DisplayName=Yes Table.OwnerDisplayName=No Table.Columns=Yes Table.Columns._Filter="All Columns" PDMCOLNALL Table.Columns._Columns=Stereotype DataType KeyIndicator Table.Columns._Limit=-5 Table.Keys=No Table.Keys._Columns=Stereotype Indicator Table.Indexes=No Table.Indexes._Columns=Stereotype Table.Triggers=No Table.Triggers._Columns=Stereotype Table.Comment=No Table.IconPicture=No Table.TextStyle=No Table_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="Stereotype No\r\nDisplayName Yes\r\nDataType No\r\nSymbolDataType No &quot;Domain or Data type&quot;\r\nDomain No\r\nKeyIndicator No\r\nIndexIndicator No\r\nNullStatus No" Filters="&quot;All Columns&quot; PDMCOLNALL &quot;&quot;\r\n&quot;PK Columns&quot; PDMCOLNPK &quot;\&quot;PRIM \&quot;TRUE\&quot; TRUE\&quot;&quot;\r\n&quot;Key Columns&quot; PDMCOLNKEY &quot;\&quot;KEYS \&quot;TRUE\&quot; TRUE\&quot;&quot;" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Keys" Collection="Keys" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Triggers" Collection="Triggers" Columns="Stereotype No\r\nDisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> View.Stereotype=Yes View.DisplayName=Yes View.OwnerDisplayName=No View.Columns=Yes View.Columns._Columns=DisplayName View.Columns._Limit=-5 View.TemporaryVTables=Yes View.Indexes=No View.Comment=No View.IconPicture=No View.TextStyle=No View_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="DisplayName No\r\nExpression No\r\nDataType No\r\nSymbolDataType No &quot;Domain or Data type&quot;\r\nIndexIndicator No" HasLimit="Yes" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Tables" Collection="TemporaryVTables" Columns="Name Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="DisplayName Yes" HasLimit="No" HideEmpty="No" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Procedure.Stereotype=No Procedure.DisplayName=Yes Procedure.OwnerDisplayName=No Procedure.Comment=No Procedure.IconPicture=No Procedure.TextStyle=No Procedure_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <StandardAttribute Name="Force top align" Attribute="TextStyle" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Reference.Cardinality=No Reference.ImplementationType=No Reference.ChildRole=Yes Reference.Stereotype=Yes Reference.DisplayName=No Reference.ForeignKeyConstraintName=No Reference.JoinExpression=No Reference.Integrity=No Reference.ParentRole=Yes Reference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Cardinality" Attribute="Cardinality" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Implementation" Attribute="ImplementationType" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Cons&amp;traint Name" Attribute="ForeignKeyConstraintName" Prefix="" Suffix="" Caption="Cons&amp;traint Name" Mandatory="No" />[CRLF] <StandardAttribute Name="Join" Attribute="JoinExpression" Prefix="" Suffix="" Caption="Join" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Referential integrity" Attribute="Integrity" Prefix="" Suffix="" Caption="Referential integrity" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> ViewReference.ChildRole=Yes ViewReference.Stereotype=Yes ViewReference.DisplayName=No ViewReference.JoinExpression=No ViewReference.ParentRole=Yes ViewReference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="&lt;&lt;" Suffix="&gt;&gt;" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Join Expression" Attribute="JoinExpression" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=6000 Height=2000 Brush color=255 255 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=64 Brush gradient color=192 192 192 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 255 128 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FRMELNK] CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FILO] OBJSTRNFont=新宋体,8,N OBJSTRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LCNMFont=新宋体,8,N LCNMFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PDMPCKG] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 KeysFont=新宋体,8,N KeysFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 TriggersFont=新宋体,8,N TriggersFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=178 214 252 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 TemporaryVTablesFont=新宋体,8,N TemporaryVTablesFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=208 208 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4000 Height=1000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 108 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=新宋体,8,N OBJXSTRFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0, 0, 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 (1890, 11693) ((315,354), (433,354)) 1 1 1539051658 1546565826 ((-60148,32175), (-47934,37407)) ((-59748,37007),(-59748,32875),(-48334,32875)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 3 1539051667 1546565826 ((-60148,29166), (-48451,32375)) ((-59748,29566),(-59748,31675),(-48851,31675)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 4 1539051707 1546565826 ((-53743,40116), (-45981,47254)) ((-53343,40516),(-53343,46554),(-46381,46554)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 3 1539065038 1546565826 ((-59805,47676), (-46351,51268)) ((-59405,50868),(-59405,48376),(-46751,48376)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539073099 1546565826 ((40419,51217), (56576,56907)) ((40819,51617),(55876,51617),(55876,56507)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539073104 1546565826 ((41767,32575), (58103,40776)) ((42167,32975),(57403,32975),(57403,40376)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539073108 1546565826 ((33962,58356), (50478,63207)) ((34362,62807),(34362,59056),(50078,59056)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539073112 1546565826 ((33834,42225), (52005,47778)) ((34234,47378),(34234,42925),(51605,42925)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539141182 1546565826 ((8657,-15890), (54808,-5451)) ((54408,-15490),(29008,-15490),(29008,-6151),(9057,-6151)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 3 1539141343 1546565826 ((-15551,-8618), (10229,506)) ((-15151,106),(-15151,-7918),(9829,-7918)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 2 1539143631 1546565826 ((22347,-39534), (36109,-5451)) ((35709,-39134),(28249,-39134),(28249,-6151),(22747,-6151)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 2 1539151702 1546565826 ((15387,-38782), (36109,-18092)) ((35709,-38382),(35709,-29261),(29008,-29261),(29008,-18792),(15787,-18792)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 3 1539151705 1546565826 ((-10004,-20243), (10109,3341)) ((-9604,2941),(1370,2941),(1370,-11411),(9409,-11411),(9409,-19843)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 3 1539155088 1546565826 ((-9404,12156), (4326,13556)) ((-9004,12856),(3926,12856)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539163549 1546565826 ((-22219,19874), (-20819,41739)) ((-21519,20274),(-21519,41339)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539163554 1546565826 ((-22219,59371), (27083,68465)) ((26683,68065),(-21519,68065),(-21519,59771)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539165080 1546565826 ((-15043,55284), (-10367,56684)) ((-14643,55984),(-10767,55984)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 3 1539165928 1546565826 ((1247,55547), (6910,56947)) ((1647,56247),(6510,56247)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 3 1539222729 1546565826 ((-29660,4629), (-23962,6029)) ((-24362,5329),(-29260,5329)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539222732 1546565826 ((-44949,2847), (-40456,4247)) ((-40856,3547),(-44549,3547)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539225316 1546565826 ((-13964,12710), (-1830,26521)) ((-2230,26121),(-2230,13410),(-13564,13410)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 2 1539247925 1546565826 ((-53967,-23650), (-33644,-22250)) ((-53567,-22950),(-34044,-22950)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539247933 1546565826 ((-17384,-16730), (-15984,506)) ((-16684,106),(-16684,-16330)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539247935 1546565826 ((-16252,-24850), (-630,26521)) ((-1030,26121),(-1030,-24150),(-15852,-24150)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539248647 1546565826 ((-54867,-40764), (-53467,-32018)) ((-54167,-32418),(-54167,-40364)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539248649 1546565826 ((-48757,-40764), (-33644,-23750)) ((-34044,-24150),(-48057,-24150),(-48057,-40364)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539248656 1546565826 ((-43829,-40764), (-23962,10590)) ((-24362,10190),(-43129,10190),(-43129,-40364)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539762995 1546565826 ((41641,49019), (79120,65503)) ((42041,65103),(78420,65103),(78420,49419)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539763022 1546565826 ((-33894,24926), (79120,45621)) ((-33494,25326),(78420,25326),(78420,45221)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1540878858 1546565826 ((-104323,2355), (-23962,12090)) ((-103923,2755),(-103923,11390),(-24362,11390)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1540880451 1546565826 ((-96180,-15264), (-17184,506)) ((-95780,-14864),(-17884,-14864),(-17884,106)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1540880736 1546565826 ((-96180,-22104), (-87650,-19955)) ((-95780,-20355),(-93980,-20355),(-93980,-21404),(-88050,-21404)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 3 1541398705 1546565826 ((-48149,-7350), (-40233,-5950)) ((-47749,-6650),(-40633,-6650)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1546566350 1552541977 ((22908,19881), (42192,21281)) ((23308,20581),(41792,20581)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1552289478 1552541981 ((22908,9103), (29163,10503)) ((23308,9803),(28763,9803)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1552542496 1552542496 ((22908,11658), (59680,16875)) ((23308,16475),(58980,16475),(58980,12058)) 1 8 16744576 12632256 OBJXSTR 0 新宋体,8,N 1539048863 1546565826 -1 ((-66333,37007), (-53163,45485)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539050106 1546565826 -1 ((-66265,20868), (-53803,29566)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539050408 1550193702 -1 ((-48851,31127), (-37255,36225)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539050486 1550193702 -1 ((-46751,45827), (-35155,50925)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539051910 1546565826 -1 ((1128,79025), (12724,85023)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539052628 1546565826 -1 ((-19601,77072), (-4545,87570)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539063934 1546565826 -1 ((-67084,50868), (-51726,61385)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539068867 1546565826 -1 ((-48552,14806), (-33494,30618)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539070929 1546565826 -1 ((-48633,51766), (-31053,67385)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539072138 1546565826 -1 ((28408,28176), (42167,37774)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539072143 1546565826 -1 ((27649,47378), (40819,55856)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539072161 1546565826 -1 ((51605,40376), (63201,45474)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539072390 1546565826 -1 ((50078,56507), (61674,61605)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539072398 1546565826 -1 ((26683,62807), (42041,73324)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539133824 1546565826 -1 ((-67339,68321), (-51889,77531)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539138638 1546565826 -1 ((49466,65703), (64916,74913)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539139207 1546565826 -1 ((35206,-27461), (54588,-10811)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539140281 1546565826 -1 ((71197,-18480), (90433,-10140)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539140734 1546565826 -1 ((8989,-10332), (22747,-2534)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539141219 1546565826 -1 ((-24362,106), (-9004,20274)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539143104 1546565826 -1 ((35709,-47459), (55091,-30809)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539143694 1546565826 -1 ((9289,-22362), (23047,-15464)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539154255 1546565826 -1 ((3926,4531), (23308,21181)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539158895 1546565826 -1 ((-28395,41339), (-14643,59771)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539163595 1546565826 -1 ((-10827,51047), (1647,59721)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539165130 1546565826 -1 ((6030,51108), (16706,59886)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539171783 1546565826 -1 ((-71425,-32418), (-53567,-16046)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539171786 1546565826 -1 ((-34044,-31970), (-15852,-16330)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539222635 1546565826 -1 ((-57719,-692), (-44549,7786)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539222681 1546565826 -1 ((-40856,1458), (-29260,6556)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539223552 1546565826 -1 ((-8830,26121), (5748,41909)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539237890 1546565826 -1 ((72533,-37827), (85859,-28229)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539243738 1546565826 -1 ((-78357,-930), (-63341,8112)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539247360 1546565826 -1 ((-55602,-51950), (-40512,-40364)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539322763 1546565826 -1 ((-26831,-57770), (-15751,-46801)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1539759734 1550193702 -1 ((-91560,43715), (-79532,50613)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539762745 1546565826 -1 ((72622,45221), (84218,49419)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1539764641 1550193702 -1 ((-8715,-53985), (4611,-47087)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1540189341 1550193702 -1 ((-79191,-46121), (-64999,-41023)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1540878443 1546565826 -1 ((-111847,-8779), (-95999,2755)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1540878979 1546565826 -1 ((-112018,-28381), (-95780,-12169)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1540880446 1546565826 -1 ((-89358,-28245), (-74780,-16345)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1541397368 1546565826 -1 ((-40633,-11901), (-26874,-1403)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1541398568 1546565826 -1 ((-61941,-9101), (-47749,-4903)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1542706044 1550193702 -1 ((-40714,-66611), (-23926,-59713)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1542952019 1550193702 -1 ((-62763,-81761), (-47707,-55063)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1546480499 1546565826 -1 ((-42722,81461), (-31558,85659)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1546498159 1546565826 -1 ((72468,-1983), (85584,13453)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1546565834 1552541977 -1 ((41792,18728), (57282,24726)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1548054314 1550193702 -1 ((-78562,-59174), (-63506,-54976)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 tp_bill_invoice 1551768453 1551768453 ((-3360,-1800), (3360,1800)) 4130 0 7 16777215 16777215 新宋体,8,N 1552288382 1552541981 -1 ((28763,3731), (46921,15875)) 0 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 1 1552542046 1552542492 -1 ((52100,4260), (65860,12058)) 12615680 16570034 12632256 STRN 0 新宋体,8,N DISPNAME 0 新宋体,8,N OWNRDISPNAME 0 新宋体,8,N Columns 0 新宋体,8,N TablePkColumns 0 新宋体,8,U TableFkColumns 0 新宋体,8,N Keys 0 新宋体,8,N Indexes 0 新宋体,8,N Triggers 0 新宋体,8,N LABL 0 新宋体,8,N 6 65 16777215 A6733759-FCBB-4000-A1DD-BD13E4C6C8BB to_sys_role to_sys_role 1539048863 szc 1547617997 szc 运营web端角色 647DEB29-C60F-43B8-9A10-194A77CA3A3D id id 1539049645 szc 1539049810 szc int(11) 11 1 1 C6BC7ABB-B702-4F45-9107-9E74C1778CF0 community_id community_id 1547617950 szc 1547617997 szc 小区id int(11) 11 4640D79D-305B-4020-8D9E-6BD1F306A413 role_name role_name 1539049666 szc 1539049819 szc 角色名称 varchar(50) 50 EB70D7E7-979D-4EDD-959E-449451A22C26 description description 1539049666 szc 1539049825 szc 描述 varchar(255) 255 1803607D-AA74-47D8-95EC-1FB9EFB78454 status status 1539584386 szc 1539584535 szc 逻辑删除状态 3051AEB4-28DD-4674-8EFB-290ABFF8E0E4 create_user create_user 1539049810 szc 1539049967 szc 创建人 int(11) 11 A88532A6-C6AB-4752-AC51-6BB0591A7FBB create_date create_date 1539049841 szc 1539049981 szc 创建时间 datetime 8FFF253F-DFEC-40AE-8CC9-F2525225C623 update_user update_user 1539049841 szc 1539049974 szc 更新人 int(11) 11 6F2A3962-1449-493B-883C-65AC232C6D67 update_date update_date 1539049841 szc 1539049986 szc 更新时间 datetime 42E230C2-7E5E-4D05-B8D8-A31487807EE1 Key_1 Key_1 1539049645 szc 1539049666 szc CBE1A5B1-900F-4646-9A84-07FA5DE81810 to_sys_menu to_sys_menu 1533715068 szc 1539050290 szc 运营web端菜单 ENGINE = InnoDB AUTO_INCREMENT = 565 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact AAF95580-51CC-4CFC-BB58-0F84C2DEECCC id id 1533715068 szc 1539050290 szc 菜单ID int(4) 4 1 1 85A2F5F5-83C8-4608-8EEE-8AB8F947EDD6 menu_name menu_name 1533715068 szc 1539050147 szc 菜单名称 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 83ED6EEB-412B-417A-9621-76D96998B524 menu_url menu_url 1533715068 szc 1539050160 szc 菜单链接 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 86AB02FC-754B-41F7-A01D-38B1DD6CECC3 menu_icon menu_icon 1533715068 szc 1539050169 szc 菜单图标 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 68300472-CEB0-430D-851C-341FB9428AFF parent_id parent_id 1533715068 szc 1539050290 szc 父级菜单ID NULL int(11) 11 73FB63DF-E30C-48BE-84A9-B2BD2A4A9BF1 sort sort 1533715068 szc 1539050290 szc 排序 NULL int(8) 8 49F8E5D2-8A4E-4137-B03A-17E50A855E17 menu_type menu_type 1533715068 szc 1539050242 szc 菜单类型 0 页面菜单 1功能菜单 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 AD24BEAC-CAD4-404A-9AB2-FDF3DF2908A2 status status 1533715068 szc 1539050369 szc 状态 0正常 9 删除 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 4B16D9F7-F05D-4B65-8271-D33E9D7438E3 Key_1 Key_1 1533715068 szc 1533715068 szc C27927B0-5980-44B1-8677-C33F1BF9BB2F to_sys_role_menu to_sys_role_menu 1533715068 szc 1547618107 szc 运营端角色可查看的菜单 ENGINE = InnoDB AUTO_INCREMENT = 168598 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact 8F22EC17-3CAB-4E4A-8ED5-823A8F73E3AA id id 1533715068 szc 1533715068 szc int(11) 11 1 1 76B686A5-F0A5-4F94-8CE5-14F5AC965599 community_id community_id 1547618074 szc 1547618107 szc 小区ID int(11) 11 EBF6E18C-E325-4502-995B-EC32549D1BC9 role_id role_id 1533715068 szc 1539050477 szc 角色ID NULL int(11) 11 FA191842-EA97-4CFE-A982-2BEA0B33897D menu_id menu_id 1533715068 szc 1539050477 szc 菜单ID NULL int(11) 11 1B61FA7E-5196-4698-8699-8463CFD3A2FD Key_1 Key_1 1533715068 szc 1533715068 szc 719CC9C2-DCAB-4E0F-A2B1-33FFDB8D01B9 to_sys_user_role to_sys_user_role 1533715068 szc 1547618168 szc 运营web端用户是那些角色 ENGINE = InnoDB AUTO_INCREMENT = 799 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact 3FCCFCDA-B11B-4773-AC7B-CE2899CE5B9B id id 1533715068 szc 1533715068 szc int(11) 11 1 1 8C0AE1D6-D2B9-4FCA-A83B-9068F6E26042 community_id community_id 1547618129 szc 1547618168 szc 小区id int(11) 11 C9426E51-F405-4AC9-B2DC-F804D5EA9CE1 user_id user_id 1533715068 szc 1539050703 szc 用户ID NULL int(11) 11 BF64AF97-A7F9-4690-BB38-574B2E01972E role_id role_id 1533715068 szc 1539050703 szc 角色ID NULL int(11) 11 1FBF5C9E-F200-4A97-9DE4-8DD9B83AD0FB Key_1 Key_1 1533715068 szc 1533715068 szc 94B4EEA0-1EDC-4C5F-A4E0-668DA062AB19 sys_dictionary sys_dictionary 1533715068 szc 1539052068 szc 数据字典表 ENGINE = InnoDB AUTO_INCREMENT = 949 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact E0E38B63-D5F3-49B5-954A-ED47F483291F id id 1533715068 szc 1533715068 szc int(11) 11 1 1 3F182217-BFDF-4254-AC8D-076ED7A47D2B code code 1533715068 szc 1539051938 szc 字典编码 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 58BF6EE1-D47F-4738-8756-98C6B5FEF438 name name 1533715068 szc 1539051944 szc 字典名称 varchar(50) 50 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 268DB596-AB53-43FD-A805-6197C12DF19C group_id group_id 1533715068 szc 1539052060 szc 分组id，就是父id varchar(32) 32 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 E8E2F380-5B27-45DC-A870-18553753C800 sort sort 1533715068 szc 1539052068 szc 排序 NULL int(2) 2 2DE12927-7FE1-42D3-9315-B1D6F21E9908 Key_1 Key_1 1533715068 szc 1533715068 szc 7CFBB49D-2BE6-4E54-AD9A-2A7B12C37093 sys_nation sys_nation 1539052628 szc 1539053554 szc 国家行政区划表 202E1151-4FA1-4641-917F-484E5ADAA8C4 id id 1539052631 szc 1539052736 szc int(11) 11 1 1 9B7F3B07-9A21-4220-93C6-FC69393A2F95 code code 1539052730 szc 1539052765 szc 地区代码 varchar(40) 40 0F59DAD9-4C6A-4AB1-8816-A9E0B6971B52 province province 1539052763 szc 1539053563 szc 省份 varchar(40) 40 B82E5B1D-E752-4727-8C25-AA016C2ECB75 city city 1539052763 szc 1539053571 szc 城市 varchar(40) 40 440642E0-59BD-43EF-BA56-F179267ADA8F parent_id parent_id 1539052763 szc 1539053579 szc 父级行政区划ID int(11) 11 EE7A41A8-48E3-46E7-9166-8F90E751525F create_time create_time 1539052763 szc 1539053585 szc 创建时间 datetime 9FA1CCAE-4683-4DE8-918E-C9E512B6C1A6 district district 1539052763 szc 1539053593 szc 县/区 varchar(40) 40 F069A204-CB78-4A28-B92A-83462B563361 last_update_time last_update_time 1539052763 szc 1539053600 szc 最后修改时间 datetime 1DDEDFFD-C080-4262-A9AF-882860E014D0 operator operator 1539052763 szc 1539053554 szc int 70674241-4BAA-48C8-AA7A-8D7676BD246C operator_ip operator_ip 1539052763 szc 1539053554 szc varchar(25) 25 4FC315F9-1038-48D8-86FD-735FC66C2FE8 Key_1 Key_1 1539052631 szc 1539052730 szc B841BA07-9D33-4343-935D-9406151B4CAD to_user to_user 1539063934 szc 1539759507 szc 运营web端用户表 FB201584-D67C-4290-96AA-B7026ACB5522 id id 1539063951 szc 1539064034 szc int(11) 11 1 1 E2EC1110-EA06-4B5E-9BBE-FFFF431C55BC user_name user_name 1539064032 szc 1539064732 szc 用户姓名 varchar(50) 50 C88C1409-BE5B-42F1-BE8F-65190775C052 login_name login_name 1539064723 szc 1539064795 szc 登录账号就是手机号确保唯一 varchar(50) 50 C6C5C4B3-5BAE-4E90-B947-D2ACC9DF8219 login_password login_password 1539759182 szc 1539759453 szc 登录密码 varchar(225) 225 76B679EF-B10E-46FA-B05C-C14D6398A530 email email 1539759445 szc 1539759482 szc 邮箱 varchar(225) 225 EA80A559-728C-4EC0-8E0A-49FD919B6A32 head_portrait head_portrait 1539759476 szc 1539759515 szc 头像 varchar(225) 225 6B8CA7D5-FF1A-4856-8C90-1279DA31E19B remark remark 1539064778 szc 1539064851 szc 备注 varchar(255) 255 7729EB83-D208-4709-B8A1-92F7ECBB37F9 status status 1539138429 szc 1539138512 szc 1 有效 0 无效(逻辑删除) char(1) 1 45B4C0B9-2956-4783-8639-F6D9A7469DFF create_user create_user 1539064844 szc 1539064979 szc 创建人 int(11) 11 2A393456-8A5B-4078-9950-D4BD9D10F8DE create_date create_date 1539064844 szc 1539064988 szc 创建时间 datetime 29A46521-9322-422E-A4D9-9CF080E46AD8 update_user update_user 1539064844 szc 1539064994 szc 更新人 int(11) 11 E53136A6-CB09-4CD2-8888-6BE4FAA70363 update_date update_date 1539064844 szc 1539065001 szc 更新时间 datetime 9DCA14ED-99AF-404D-A83D-2E59E687FFB3 Key_1 Key_1 1539063951 szc 1539064032 szc 96AB1371-547C-4F23-BF50-120F22327593 to_communities to_communities 1539068867 szc 1541145519 szc 所有小区表 8EC03F5D-55C6-48BD-9B9B-D237AD709687 id id 1539068897 szc 1539069014 szc int(11) 11 1 1 2FA7E643-651B-4EAA-B9D6-D1AA2CBDE737 community_name community_name 1539069011 szc 1539069170 szc 小区名称 varchar(225) 225 81D5F8A8-562E-4B12-A92F-719A51FC5B00 community_alias community_alias 1539069011 szc 1539069178 szc 小区别名 varchar(225) 225 1BF31C10-F020-4E0B-8D7F-8304A458AFC9 province_id province_id 1539069156 szc 1539069292 szc 省份id int(11) 11 7C4EAC68-7D29-4C7F-998B-AB3511B7043B city_id city_id 1539069222 szc 1539069292 szc int(11) 11 404C139F-26F9-4CB3-B5C0-A599C1199B79 district_id district_id 1539069222 szc 1539069307 szc 县/区id int(11) 11 5F90EC7A-3134-4ABC-94FB-445022C788C2 longitude longitude 1539069293 szc 1539069456 szc 经度 varchar(225) 225 B0B4A04A-6155-4FE3-9CA4-0330E065DE06 latitude latitude 1539069293 szc 1539069462 szc 纬度 varchar(225) 225 B52556FE-1F7B-4119-9A7D-35CAB3FD2E11 user_name user_name 1540964612 szc 1541147393 szc 用户名 varchar(225) 225 4AE52091-562F-4999-BEEE-4E53258C7C60 login_name login_name 1540964612 szc 1541147405 szc 登录账号 varchar(225) 225 1B65F0EA-8B5B-4912-9DC7-DB7C47B09D60 create_date create_date 1541145450 szc 1541145519 szc datetime EBDED0C9-0703-4627-86C0-767C1D63C524 create_user create_user 1541145450 szc 1541145519 szc int(0) 898F31F9-07FB-48D8-93C0-A2E72A094A75 update_date update_date 1541145450 szc 1541145519 szc datetime 568941DF-C612-4755-A7A7-5D450FE46AA3 update_user update_user 1541145450 szc 1541145519 szc int(0) AF2684CF-B020-4064-B07C-8CE4D6EA77E3 Key_1 Key_1 1539068897 szc 1539069011 szc 454BFBE5-66E4-4E55-A44C-364F8EB254CB to_banner to_banner 1539070929 szc 1540980036 szc 所有小区的广告位设置表 DB96EF09-DDEE-469E-BD91-1D67F6DCD2F2 id id 1539070941 szc 1539070994 szc int(11) 11 1 1 BCF8FFD9-9687-49B2-B8FB-0DA4D6F07D2D community_id community_id 1539760250 szc 1539760289 szc 小区id （保留字段） int(11) 11 7F01660E-C326-4795-919B-BA15FB7786A1 title title 1540975900 szc 1540975944 szc 标题 varchar(225) 225 D105DC6E-4D69-4702-84FD-DEFF7B3D3826 banner_description banner_description 1539070991 szc 1539071119 szc banner的跳转描述 varchar(225) 225 5027D299-C561-4872-986F-2064E84DA61F sort sort 1539070991 szc 1539071231 szc 排序 int(2) 2 628AE871-3BE4-4919-951B-914FA6CA09B3 banner_cover banner_cover 1539071106 szc 1539071225 szc banner图 varchar(225) 225 BA14E54A-22DF-4591-A931-F6E86C41747B banner_position banner_position 1539071212 szc 1539071359 szc banner位，取字典表banner int(11) 11 20784B73-FFC6-4DAC-B7D7-3F15EEADAF92 eff_time eff_time 1539071320 szc 1539071460 szc 生效时间 datetime 2719DBDD-5BAC-4B32-B915-6224D1AD7904 exp_time exp_time 1539071320 szc 1539071504 szc 失效时间 datetime D5211CB6-8667-4DD0-9A9F-BD0A0B2728C2 banner_type banner_type 1539071496 szc 1539071561 szc banner类型： 1 是 外部超链接 2 是 自写文章 char(1) 1 48314B8B-0C95-4F21-876E-C6BE1000318C external_link external_link 1539071496 szc 1544412382 szc 外部超链接 text DC8E884E-ED73-4DE1-956B-689C2FD16C2A banner_title banner_title 1539071534 szc 1539071853 szc banner标题 varchar(225) 225 220CAF5D-BA19-438D-A0E5-429E96D07F64 banner_content banner_content 1539071664 szc 1539583637 szc banner内容 text 02964603-9149-44DD-B3C8-210320E1001C create_user create_user 1540175034 szc 1540175173 szc 创建人 int(11) 11 C998D89F-0CC7-4605-9EC7-D19BAF34C30C create_date create_date 1540175034 szc 1540175179 szc 创建时间 datetime AF558D88-C219-4416-A745-824B6CE591F4 update_user update_user 1540979998 szc 1540980036 szc int(11) 11 7CDEDE74-58DD-4AFD-A4D4-98D164E77E78 update_date update_date 1540979998 szc 1540980036 szc datetime 02697470-EA29-43AF-898D-0B007AAFEF7A Key_1 Key_1 1539070941 szc 1539070991 szc 6F5078BE-627D-45A6-82C3-AEC69E1FD431 tp_sys_menu tp_sys_menu 1533715068 szc 1539072918 szc 物业web端菜单表 ENGINE = InnoDB AUTO_INCREMENT = 565 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact 40989890-F231-4F47-92DD-9DB6F13E4D95 id id 1533715068 szc 1539072138 szc 菜单ID int(4) 4 1 1 20DF4B7A-1807-4A4B-8EF8-7FBEC281F40C community_id community_id 1539072895 szc 1539072932 szc 小区id int(11) 11 CBB00052-48A9-4347-973B-D3ABE30C57DC menu_name menu_name 1533715068 szc 1539072138 szc 菜单名称 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 F680B9F1-9579-4AE8-B55A-63A42201217B menu_url menu_url 1533715068 szc 1539072138 szc 菜单链接 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 66D277CC-654D-4698-ADB6-858A9FAC3B1C menu_icon menu_icon 1533715068 szc 1539072138 szc 菜单图标 varchar(100) 100 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 8665F379-292A-4AF6-9192-5298478FBB82 parent_id parent_id 1533715068 szc 1539072138 szc 父级菜单ID NULL int(11) 11 542FD10C-7025-4EF0-A9DC-E548EE345BAD sort sort 1533715068 szc 1539072138 szc 排序 NULL int(8) 8 E1CCB82B-682D-45DF-B6E6-34C80AB0391E menu_type menu_type 1533715068 szc 1539072138 szc 菜单类型 0 页面菜单 1功能菜单 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 8E5E3D22-311C-41EC-8D86-E39D5F007B7A status status 1533715068 szc 1539072138 szc 状态 0正常 9 删除 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 FF4BA6C8-30FC-46D4-A9B3-468684206294 Key_1 Key_1 1533715068 szc 1533715068 szc A463F831-4A8F-461A-A0B2-5D9E7B81C6C5 tp_sys_role tp_sys_role 1539048863 szc 1539072872 szc 物业web端角色表 C5BCEB0C-9AE6-403E-96CE-8ACA3757FF2B id id 1539049645 szc 1539072143 szc int(11) 11 1 1 57C5EECB-8E20-4A46-8499-6C33CA58A905 community_id community_id 1539072831 szc 1539072879 szc 小区id int(11) 11 548DB666-A5BA-4657-B1FE-D41A4AB5DEE2 role_name role_name 1539049666 szc 1539072143 szc 角色名称 varchar(50) 50 F0A57E09-9C82-4417-96B3-9406FCE57AF2 description description 1539049666 szc 1539072143 szc 描述 varchar(255) 255 D12B5E31-140C-4EB3-BCFC-E37403C50B0F create_user create_user 1539049810 szc 1539072143 szc 创建人 int(11) 11 AD812748-6E70-416C-90BA-650468784980 create_date create_date 1539049841 szc 1539072143 szc 创建时间 datetime C8384C3F-9C8C-490B-BDFC-012172E8C773 update_user update_user 1539049841 szc 1539072143 szc 更新人 int(11) 11 E166953A-EBEA-4DE0-8BCF-AD00C70A527D update_date update_date 1539049841 szc 1539072143 szc 更新时间 datetime 1A5DFFBB-F4EB-489B-947C-43D26410D21B Key_1 Key_1 1539049645 szc 1539072143 szc 5E029CBB-B7FA-477B-8EF3-B202D44E7887 tp_sys_role_menu tp_sys_role_menu 1533715068 szc 1539073026 szc 物业端角色可查看的菜单 ENGINE = InnoDB AUTO_INCREMENT = 168598 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact CC0E3554-70AC-40FB-93C7-6711ADDFB43D id id 1533715068 szc 1533715068 szc int(11) 11 1 1 78C1D804-0446-412D-8363-02CB25249D79 community_id community_id 1539073008 szc 1539073026 szc int(11) 11 534801A2-9803-4146-9490-A2BEACCEAD95 role_id role_id 1533715068 szc 1539072161 szc 角色ID NULL int(11) 11 6C40A746-2F2A-4548-AC14-76E101D387F4 menu_id menu_id 1533715068 szc 1539072161 szc 菜单ID NULL int(11) 11 9B5930B8-4DD8-4398-9EF6-E37054E18818 Key_1 Key_1 1533715068 szc 1533715068 szc 200E4549-3192-477F-B306-8811F9B4EE29 tp_sys_user_role tp_sys_user_role 1533715068 szc 1539073044 szc 物业web端用户是那些角色 ENGINE = InnoDB AUTO_INCREMENT = 799 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact 354125D9-52C3-49EC-AC15-5288DEAC4264 id id 1533715068 szc 1533715068 szc int(11) 11 1 1 AE607F8C-D6B4-44D1-9A9D-E009CBA67DF7 community_id community_id 1539073028 szc 1539073044 szc int(11) 11 B3152597-4CC3-4F80-B2BE-30E10176A672 user_id user_id 1533715068 szc 1539072390 szc 用户ID NULL int(11) 11 CBCBBE61-BD4B-488B-BF70-111BDAF5DA36 role_id role_id 1533715068 szc 1539072390 szc 角色ID NULL int(11) 11 C6039D09-8028-44BB-A97B-CB6F616DC674 Key_1 Key_1 1533715068 szc 1533715068 szc 3F3F13BF-09F9-4651-91FD-96E1A505C1A6 tp_user tp_user 1539063934 szc 1539759341 szc 物业web端用户表 12A1D923-79BC-4984-8AF8-2172B1A547B0 id id 1539063951 szc 1539072398 szc int(11) 11 1 1 1B033B12-4D65-4963-A3E2-DC18DFE1E4CA community_id community_id 1539073050 szc 1539073077 szc 小区id int(11) 11 131B704F-AA99-4F45-AA4A-B9C508DC6444 user_name user_name 1539064032 szc 1539072398 szc 用户姓名 varchar(50) 50 B44FA871-7EF8-4026-87C6-11897CC6D8EE login_name login_name 1539064723 szc 1539072398 szc 登录账号就是手机号确保唯一 varchar(50) 50 3D72F6EA-A16D-499A-B425-E236529D9F71 login_password login_password 1539759230 szc 1539759311 szc 登录密码 varchar(225) 225 6808FAFE-F9EF-4CE4-B1DE-A55A0A6A5160 status status 1539138529 szc 1539138550 szc 1 有效 0 无效(逻辑删除) char(1) 1 B3EA2CF3-903C-4005-8448-CD92F94C9484 remark remark 1539064778 szc 1539759341 szc 备注 varchar(225) 225 761108B4-2254-4F72-9E78-0AEE61AF00DF email email 1539759295 szc 1539759348 szc 邮箱 varchar(225) 225 5FE0A9CB-5A47-431F-961C-A0472BB5C873 head_portrait head_portrait 1539759185 szc 1539759237 szc 头像 varchar(225) 225 12837721-2A7D-4975-A8F7-28A726C3FC0C create_user create_user 1539064844 szc 1539072398 szc 创建人 int(11) 11 EC3904C3-4DC1-49BE-AD07-461D868A34FB create_date create_date 1539064844 szc 1539072398 szc 创建时间 datetime E081DBC8-9513-4CE1-908D-F75F6B7E675E update_user update_user 1539064844 szc 1539072398 szc 更新人 int(11) 11 9A2FBAEA-C6C9-4077-9A39-7884BCF89D7E update_date update_date 1539064844 szc 1539072398 szc 更新时间 datetime 42FECBE4-1EB0-430C-B448-A0BEE166CD75 Key_1 Key_1 1539063951 szc 1539072398 szc 0417409C-9A13-41E3-A589-D54F6E977F76 to_sys_operate_log to_sys_operate_log 1539133824 szc 1539138329 szc 运营web端记录操作日志表 B08F9BA9-FD0E-427D-8FA3-7502BB71DE82 id id 1539133827 szc 1539133923 szc int(11) 11 1 1 DB378270-FA1C-40DF-BEFA-8DD58DCBBC52 module module 1539134099 szc 1539138159 szc 访问模块 varchar(225) 225 38E1F236-4C05-4079-8CB4-8EB0053FD163 operate_content operate_content 1539134099 szc 1539138169 szc 操作内容 varchar(225) 225 091A89F8-E57E-4C17-982F-D80FAE05A295 operate_time operate_time 1539138141 szc 1539138234 szc 操作时间 datetime 49A262FC-A3B7-4284-8367-A43CD615DB9B operator operator 1539138216 szc 1539138337 szc 操作人 int(11) 11 32F281D4-4064-4073-A811-634061FC27B3 operator_ip operator_ip 1539138216 szc 1539138346 szc 操作ip varchar(50) 50 E341C9AD-63EA-4E83-A021-1D64C832CF4F Key_1 Key_1 1539133827 szc 1539133921 szc CFCCD31F-81E3-4675-AAC6-4EAED698CD4F tp_sys_property_log tp_sys_property_log 1539133824 szc 1539138724 szc 物业web端记录操作日志表 0B9BCE82-CD86-40A1-8C18-00946828920E id id 1539133827 szc 1539138638 szc int(11) 11 1 1 D4974CD2-072A-48FD-B529-1FDFF5D26491 community_id community_id 1539138643 szc 1539138732 szc 小区id int(11) 11 1838E69C-F475-428D-93F6-F017A74DB4E6 module module 1539134099 szc 1539138638 szc 访问模块 varchar(225) 225 9AC12882-4D80-49D7-801E-B47835EAE035 operate_content operate_content 1539134099 szc 1539138638 szc 操作内容 varchar(225) 225 C020DDEF-FABE-4943-BDC1-06A267335239 operate_time operate_time 1539138141 szc 1539138638 szc 操作时间 datetime 2C07FC5F-7DAA-433C-BDB0-3CA8F6FB0832 operator operator 1539138216 szc 1539138638 szc 操作人 int(11) 11 EC805746-1CFE-4E1F-9A75-F523CD93DE6F operator_ip operator_ip 1539138216 szc 1539138638 szc 操作ip varchar(50) 50 F51D72EE-0F0B-4726-9725-1FD01303BEA5 Key_1 Key_1 1539133827 szc 1539138638 szc C5D1B517-E891-428E-9F92-1DE97D42B0A2 tp_announcement tp_announcement 1539139207 szc 1539760493 szc 物业web端公告表 6070ADA1-83FB-4B65-B276-02DD1A8BCF3E id id 1539139434 szc 1539139450 szc int(11) 11 1 1 86F87FE5-126E-4640-827F-CB4C70CA2184 community_id community_id 1539139506 szc 1539139555 szc 小区id int(11) 11 3E845CB9-7077-4747-849C-EF43FCEAC61C announcement_title announcement_title 1539139448 szc 1539139516 szc 公告标题 varchar(225) 225 7DB2A496-124C-46F8-AB02-A7F3E907658E announcement_carousel_img announcement_carousel_img 1539139545 szc 1539139699 szc 轮播图 varchar(225) 225 F69DAECB-5475-4C43-80DE-B94F96EC7E06 announcement_content announcement_content 1539139690 szc 1539139750 szc 公告内容 varchar(225) 225 E70CA777-EDDD-4FCC-898D-F57BD82223F6 sort sort 1539139809 szc 1539139945 szc 排序 int(8) 8 80F50C06-482D-4EFF-AAD2-417ECFBB9BD6 view_count view_count 1539143132 szc 1539143195 szc 查看人数 int(11) 11 E221C872-C306-49A9-8FDE-99AD9805DA1A set_up_carousel set_up_carousel 1539760296 szc 1539760509 szc 是否设置为轮播 保留字段 char(1) 1 EDF35598-33CA-4440-AC94-B3A32AB82A36 status status 1539139936 szc 1539154781 szc 0 是已作废 1 是已发布 2 是草稿 3 是已修改 char(1) 1 64DDDCB7-1B56-40DC-BC9F-FEE4AEF1E2F4 create_user create_user 1539140003 szc 1539140203 szc 创建人 int(11) 11 E7C3E342-0B70-4779-B687-AF6C4673FAA6 create_date create_date 1539140003 szc 1539140210 szc 创建时间 datetime 3491D0CB-D8CA-4F47-9A63-21863EE66713 update_user update_user 1539140003 szc 1539140216 szc 更新人 int(11) 11 9FF7C327-DD33-466E-9A76-83E2090043BE update_date update_date 1539140003 szc 1539140223 szc 更新时间 datetime CAA50EED-42CC-4C88-B80E-EB609CAFDF4F Key_1 Key_1 1539139434 szc 1539139448 szc E1A7CF79-7543-479E-B18A-516582F0951D tp_carousel_setting tp_carousel_setting 1539140281 szc 1540286027 szc 轮播数设置表 AA61008D-6BDC-4BA0-A058-09BF5C95074E id id 1539140288 szc 1539140372 szc int(11) 11 1 1 DF6B509D-AA76-45F1-9189-FBE33B63259B community_id community_id 1539140369 szc 1539140477 szc 小区id int(11) 11 6571CBA9-911D-4751-9D38-280D5CDC1641 carousel_type carousel_type 1539141779 szc 1540285970 szc 轮播类型： announcement 表示公告 activity 表示活动 banner表示运营banner varchar(80) 80 544FF1E7-5375-48D0-8983-DE444A69EBF3 carousel_num carousel_num 1539140369 szc 1539140508 szc 轮播数量 int(11) 11 9835507D-7967-4156-972A-C116E1689C75 Key_1 Key_1 1539140288 szc 1539140369 szc D4CFAFE0-1078-4E50-9686-20C53D073B10 tp_social_view tp_social_view 1539140734 szc 1539143041 szc 物业web端公告和活动查看数量记录表 BA57731C-EB9F-414B-9A0E-3E6270E6D6F8 id id 1539140736 szc 1539140876 szc int(11) 11 1 1 896A1281-623F-4924-8AAC-52331BC820F6 community_id community_id 1539140873 szc 1539140908 szc 小区id int(11) 11 4F025A5F-5FE3-4F66-95F8-B177D1B44A9F uuid uuid 1539140900 szc 1539154339 szc 公告id 或者是 活动id 或者是租赁id int(11) 11 4D5EFBE4-BC31-421E-95F8-0D20E311FD2A social_type social_type 1539142845 szc 1539154365 szc 社交类型： announcement 表示公告 activity 表示活动 lease 表示二手租赁 varchar(80) 80 38310D17-4F0F-48E4-B524-0121A76B985F ta_user_id ta_user_id 1539140943 szc 1539141145 szc 住户端app用户id int(11) 11 719A5D92-2DDB-4194-A417-6C5CB6822A42 remark remark 1539142926 szc 1539143047 szc 备注 varchar(225) 225 40780633-7ED1-4954-870D-522C3B5B5B50 create_date create_date 1539142926 szc 1539143054 szc 创建时间 datetime 17668B44-CB41-49AB-B7DF-5EC991CAB25E Key_1 Key_1 1539140736 szc 1539140873 szc 7AB6D124-29A9-41C0-B93F-0D532FBF1798 ta_user ta_user 1539063934 szc 1551768601 szc 住户app端用户表 9C424676-2CE3-4C42-A5FB-4FDDE79170D5 id id 1539063951 szc 1539141219 szc int(11) 11 1 1 6969D7D4-E32C-44D6-9984-549014B7FF51 community_id community_id 1539073050 szc 1539141219 szc 小区id int(11) 11 E8FDFA4B-B9F2-4D84-BABB-D5CE7D4D8493 building_owner_info_id building_owner_info_id 1539225099 szc 1539225143 szc 楼栋业主资料信息id int(11) 11 955118BF-E560-4692-B05E-7ECC033280CE head_portrait head_portrait 1539223062 szc 1539223285 szc 头像 varchar(225) 225 6CCF1684-CE42-45FC-8D9C-1962E88D9650 user_name user_name 1539064032 szc 1539141219 szc 用户姓名 varchar(50) 50 9723FE00-09D0-4293-9DD5-400CDDDF517A login_name login_name 1539064723 szc 1539141219 szc 登录账号就是手机号确保唯一 varchar(50) 50 142FEB84-2C6E-434C-8D9E-E88816B797FA login_password login_password 1539759175 szc 1539759386 szc 登录密码 varchar(225) 225 55FD73C6-EB86-49BC-8A90-B8DE3D888691 email email 1539759378 szc 1539759409 szc 邮箱 varchar(225) 225 E65E8B6D-9CE5-472E-9456-3E1DB2B3840A gender gender 1539223305 szc 1539223470 szc 性别 1：男 2：女 char(1) 1 BA39C6A0-2ADB-49B0-AD5F-44501C7C200F status status 1539138529 szc 1539141219 szc 1 有效 0 无效(逻辑删除) char(1) 1 E3F0BBCD-026A-4E17-974E-03BA25824D32 remark remark 1539064778 szc 1539142986 szc 备注 varchar(225) 225 78992FE4-88D9-4EAE-A912-F219C384813D parent_id parent_id 1539222825 szc 1539222931 szc 上级目录id存在，表示是这个id下的租客或家属 int(11) 11 172E2A84-82DB-4CEA-B213-70345682B74D accept_agreement_status accept_agreement_status 1539243561 szc 1539243698 szc 接受协议状态 0 是未接受 1是已接受 char(1) 1 911E38C6-F948-435F-BF2D-2F0D46D2FDBB verify_status verify_status 1540265528 szc 1540265676 szc 认证状态 0 是未认证 1是认证通过 2是已作废 char(1) 1 860A4F8C-E965-4D0C-A058-CFF09A4D1F62 face_status face_status 1540878861 szc 1540878924 szc 人脸状态 0 是未上传 1是已上传 char(1) 1 D30333D3-8855-43AA-85B5-57B23F83F5E7 id_card id_card 1551768566 szc 1551768601 szc 身份证 varchar(255) 255 C2BB6B7F-C890-460F-89AF-C550AAB91DC8 hk_person_no hk_person_no 1545882592 szc 1545882642 szc 海康人员编号 bigint(25) 25 9BFA099E-054C-4234-A519-E4746C68BFAE hk_user_id hk_user_id 1541662573 szc 1541662608 szc 海康用户id int(11) 11 E8794C97-30D7-4252-8BE1-113E58D8E67B hk_card_no hk_card_no 1541677817 szc 1541677855 szc 海康卡片号码 varchar(255) 255 E0758A89-1B65-4A9B-8328-59D28A7D0B11 create_user create_user 1539064844 szc 1539141219 szc 创建人 int(11) 11 179983FB-DF1A-405C-90D9-5C214C564544 create_date create_date 1539064844 szc 1539141219 szc 创建时间 datetime F1D27D73-550C-4755-AB66-6206B595F5F2 update_user update_user 1539064844 szc 1539141219 szc 更新人 int(11) 11 17F65D70-28FB-4460-8CA5-6079D72FE5FE update_date update_date 1539064844 szc 1539141219 szc 更新时间 datetime E6F3B9C9-5DA0-4F59-B9DD-6427012AB335 Key_1 Key_1 1539063951 szc 1539141219 szc 66225240-4A8D-412A-9072-231DAC2FEA9B tp_activity tp_activity 1539139207 szc 1539760751 szc 物业web端活动表 576869B3-CD4A-4005-85E9-B5C14F0F5AEC id id 1539139434 szc 1539143104 szc int(11) 11 1 1 A52E4AAF-0499-4037-9FA5-305CB2C8A457 community_id community_id 1539139506 szc 1539143104 szc 小区id int(11) 11 9E574108-660C-49E4-8877-D5FC28B9E2EE activity_title activity_title 1539139448 szc 1539143432 szc 活动标题 varchar(225) 225 D4EEFD2B-0792-4222-9097-D93B18F15273 activity_carousel_img activity_carousel_img 1539139545 szc 1539143449 szc 轮播图 varchar(225) 225 5DEC4446-2217-4CEB-A094-2A2753CC97E1 activity_content activity_content 1539139690 szc 1539143588 szc 活动内容 varchar(225) 225 9E267A34-0F4B-4B5D-AA44-73F493026E3D sort sort 1539139809 szc 1539143104 szc 排序 int(8) 8 A43554AE-028C-4F7A-B9BB-8099B015362D sign_up_count sign_up_count 1539143338 szc 1539143382 szc 报名人数统计 int(11) 11 74D9D7E7-D3E6-4435-8556-53DF5E844100 sign_up_max sign_up_max 1539143215 szc 1539143410 szc 报名人数上限（0 是无上限） 0 int(11) 11 BDCDBC2A-E972-4285-9287-6205366E46BF view_count view_count 1539143198 szc 1539143224 szc 查看人数 int(11) 11 ACA7EA49-99D7-44B5-A0E5-BC68D4178123 registration_start_time registration_start_time 1539760549 szc 1539760623 szc 报名开始时间 datetime 1BD09378-9767-42AE-9653-B5AA31C11822 registration_end_time2 registration_end_time2 1539760549 szc 1539760648 szc 报名结束时间 datetime FF63498C-8D5A-42DF-BB7E-EFC4090CFBC6 activity_start_time activity_start_time 1539760614 szc 1539760739 szc 活动开始时间 datetime FEC6E1D7-0333-4566-8476-01A3602D952D activity_end_time activity_end_time 1539760638 szc 1539760729 szc 活动结束时间 datetime 29504446-CE63-45AE-B566-D24523310215 status status 1539139936 szc 1539154792 szc 0 是已作废 1 是已发布 2 是草稿 3 是已修改 char(1) 1 08F7031E-E894-49EF-A317-432499405FFF create_user create_user 1539140003 szc 1539143104 szc 创建人 int(11) 11 52FEEB1C-F472-4271-B3BA-3441C06B900E create_date create_date 1539140003 szc 1539143104 szc 创建时间 datetime D4E23FB7-A146-4361-8715-9E70FEF24CBB update_user update_user 1539140003 szc 1539143104 szc 更新人 int(11) 11 ED4D67EC-CCCF-4538-9A93-5CB9881D6AEE update_date update_date 1539140003 szc 1539143104 szc 更新时间 datetime 2978F7A4-C43D-4B7F-BA41-9F8201D94E79 Key_1 Key_1 1539139434 szc 1539143104 szc 652DD1DA-D45D-4C45-9C63-4B111FA164C1 tp_activity_sign_up tp_activity_sign_up 1539143694 szc 1539151632 szc 物业web端活动报名表 615FD350-87EB-4A6F-8ADA-2F488FC75016 id id 1539151061 szc 1539151121 szc int(11) 11 1 1 F9203219-C77E-46F8-8591-69DC81C3E937 community_id community_id 1539151117 szc 1539151323 szc 小区id int(11) 11 CB8AF701-183A-4B5D-8136-77B2E5252724 activity_id activity_id 1539151117 szc 1539151332 szc 活动id int(11) 11 FD077D10-EE5C-4F4A-908C-8B8BFA6F7BE9 ta_user_id ta_user_id 1539151315 szc 1539151468 szc 住户用户id int(11) 11 8E7E6208-AD8A-4B52-8600-347FF8054287 sign_up_time sign_up_time 1539151455 szc 1539151535 szc 报名时间 datetime D69D540F-2F8F-4300-9C70-1A7FF043B144 remark remark 1539151525 szc 1539151639 szc 备注 varchar(225) 225 AD25B104-EA17-4B66-BF4A-68DEA2D4CA08 Key_1 Key_1 1539151061 szc 1539151117 szc C0451D10-5AD0-41B3-8731-2912EAC9CF51 tp_transaction tp_transaction 1539139207 szc 1546047146 szc 物业web端二手交易表 CDB0F184-832A-4151-AA3B-BBE11D8F08DC id id 1539139434 szc 1539154255 szc int(11) 11 1 1 4079A7B7-A3CA-49C1-AA1B-4D2719569E3C community_id community_id 1539139506 szc 1539154255 szc 小区id int(11) 11 0CD3E968-C089-4A40-9E5E-2BB110FC5872 ta_user_id ta_user_id 1539154400 szc 1539154677 szc 住户app的用户id int(11) 11 4BC9D9AF-6E4F-4DB1-B4B0-9AB4051B5C12 transaction_title transaction_title 1539139448 szc 1539155013 szc 交易标题 varchar(225) 225 CD6F0D37-1A16-424D-9FE8-B9D3395C9DD6 transaction_content transaction_content 1539139690 szc 1539155019 szc 交易内容 varchar(225) 225 CE985194-9367-4AC2-ACD8-DE9B077B3F07 view_count view_count 1539143198 szc 1539154255 szc 查看人数 int(11) 11 2EC31A6E-C5EE-4E16-8AB2-2A11F81B71EF status status 1539139936 szc 1539154768 szc 0 是已作废 1 是已发布 char(1) 1 6496A04E-0DF5-4249-BFC2-AABB076A2C94 type type 1539154821 szc 1539154913 szc 0 代表 二手（卖二手物品） 1 是代表 求购 （买二手物品） 2 是代表 租赁（租二手物品） char(1) 1 F2D87266-7A0C-4EB9-81D9-D32EC19D849C is_reported is_reported 1546047053 szc 1546047191 szc 是否被举报 1是被举报 0或null是没被举报 char(1) 1 A9E13DBC-0906-4154-B13C-AF73A9F6C549 create_user create_user 1539140003 szc 1539154255 szc 创建人 int(11) 11 1B2BD0F3-9A8A-46F9-B07A-0D15186714CD create_date create_date 1539140003 szc 1539154255 szc 创建时间 datetime 0343FCAE-4FD0-4674-B112-D9B768A526D2 update_user update_user 1539140003 szc 1539154255 szc 更新人 int(11) 11 F786F2D5-03C3-4D8E-A252-7EEF97C96193 update_date update_date 1539140003 szc 1539154255 szc 更新时间 datetime BD89E5FB-B0ED-4E9C-89BE-2AA7BB6D7826 Key_1 Key_1 1539139434 szc 1539154255 szc 48767716-372A-4C94-B4D5-A51E6E0EB475 tp_ticket tp_ticket 1539158895 szc 1540345303 szc 工单表 B42F9E0D-C204-4F30-B7F1-FED2CA49310F id id 1539162257 szc 1539162281 szc int(11) 11 1 1 922DA755-E8FB-44A8-A6A2-6DE0DF80E96B community_id community_id 1539162278 szc 1539162358 szc 小区id int(11) 11 1A34945C-11C4-402D-9CDD-001CE2DEDFFE ta_user_id ta_user_id 1539162278 szc 1539162381 szc 住户app的id int(11) 11 0C194286-C891-4746-A2A6-2726AE5CB1E7 ticket_title ticket_title 1539162350 szc 1539162489 szc 工单标题 varchar(225) 225 AFF419A8-91EE-4348-8FB5-892A5901C11D ticket_content ticket_content 1539162350 szc 1552291195 szc 工单内容 text B9353AE8-FC0A-4556-B45E-CB188CFF865C status status 1539162976 szc 1539163204 szc 流转状态 0:待分配 1:拒绝受理 2:待处理 3:正在处理 4:待评价 5:已评价 6:被终止 char(1) 1 34451E79-EAA6-4680-B58B-3AD3F40081F3 type type 1539162638 szc 1542791171 szc 类型 2 代表 报修 1 代表 投诉 3代表 联系单 字典 char(1) 1 BBF5D868-B241-4172-9A99-30B5E5122DDC repair_type repair_type 1539163065 szc 1540362377 szc 报修类型：0:公共区域 1: 房屋质量 2::户内设施 PS : 报修的情况下才有报修类型 char(1) 1 6850F821-33DB-4A2F-A455-061F30604C2B tp_user_id tp_user_id 1539163353 szc 1539591297 szc 受理人id 也就是物业的用户id 加 中间关系表 int(11) 11 1536DD37-FF15-4AD4-B2F8-4E1E8E0236FC score score 1539763258 szc 1539763387 szc 评分 varchar(50) 50 0221C641-47EA-4BDA-8AAB-86D2C9CA2069 comment comment 1539763379 szc 1539763427 szc 评语 varchar(225) 225 CFCAFBEC-6286-46C8-8045-7AFD3E2E94CC create_user create_user 1539163353 szc 1539163469 szc 创建人 int(11) 11 1C601F54-488C-459C-87EA-D0E3AD51BA0B create_date create_date 1539163353 szc 1539163475 szc 创建时间 datetime BE48E9AA-7A56-4481-805E-3890A7D49DAD update_user update_user 1539163353 szc 1539163487 szc 更新人 int(11) 11 94F2F857-523A-41CB-8F03-5E9869F0A5C3 update_date update_date 1539163353 szc 1539163493 szc 更新时间 datetime 9F1E9F1E-D7A5-4531-8CB9-60D0B9EC1EE4 Key_1 Key_1 1539162257 szc 1539162278 szc C9B7A154-5876-4DB3-B758-6602F99FA72C tp_ticket_record tp_ticket_record 1539163595 szc 1542608538 szc 工单处理表 68D8EEF2-48E6-4750-8F2A-245ECA9645DD id id 1539164727 szc 1539164815 szc int(11) 11 1 1 E64E53DF-595E-4B09-B7FE-B6EE4CD9346E community_id community_id 1539164751 szc 1539164787 szc 小区id int(11) 11 CDC30B4D-C920-4440-A992-EAC78675195C ticket_id ticket_id 1539164780 szc 1539164824 szc 工单id int(11) 11 826144B7-F96C-4E02-8EB4-9AEAFA923177 content content 1542592444 szc 1542608557 szc 自动生成的提示信息 varchar(255) 255 2B6B4E40-92F3-4F5E-86CB-04E7A2639467 status status 1539164815 szc 1539165037 szc 流转状态 0:待分配 1:拒绝受理 2:待处理 3:正在处理 4:待评价 5:已评价 6:被终止 char(1) 1 9F712013-A982-4293-8F7C-A2BF5E111C36 create_user create_user 1539164945 szc 1539165046 szc 创建人 int(11) 11 71D866F9-743E-4CE0-A03C-136012B53F69 create_date create_date 1539164945 szc 1539165053 szc 创建时间 datetime 13C20DAB-0CDC-4308-A3FF-CC5431BE89FD Key_1 Key_1 1539164780 szc 1539164815 szc A3A3BA0B-8385-4EE0-A06C-4A3CD17A470F tp_ticket_record_comment tp_ticket_record_comment 1539165130 szc 1539763236 szc 物业端工单追问表 C2AC49AE-158A-47CB-A912-383EA27D3F90 id id 1539165296 szc 1539165321 szc int(11) 11 1 1 D0A71A1D-08B5-47AE-A7B0-3DADD11F5251 community_id community_id 1539165318 szc 1539165346 szc 小区id int(11) 11 F95FD5BD-BCB6-4F49-B3F1-F3CC5E67B8D7 ticket_id ticket_id 1539763135 szc 1540345844 szc 工单id int(11) 11 2D2080AD-7F49-4C1B-9B0B-5F1E1FAB7D1A ticket_record_id ticket_record_id 1539165339 szc 1539165401 szc 工单记录id int(11) 11 AF5147B5-20FB-46F6-96EE-4EEC686723E1 uuid uuid 1539165378 szc 1539165541 szc 追问人id(tp_user_id也就是物业用户) 或者是 发起人id(ta_user_id也就是住户app的id) int(11) 11 B4DA8FF5-632F-41B1-AA0A-DAA7CCBF5D6F user_type user_type 1539165447 szc 1539165636 szc 用户类型： 0：追问人 1：发起人 char(1) 1 2F69F19D-16C7-4199-B2F9-53DA5359BD32 content content 1539165597 szc 1539165736 szc 追问内容或者回复内容 varchar(225) 225 91D461C1-09D0-4514-9D2F-C3D4CC0B3279 parent_id parent_id 1539165721 szc 1539165878 szc 回复的是哪条记录的id。 0表示当前状态下的第一条追问记录 int(11) 11 3B7E8F24-1728-498A-ABBF-3DDEAE375A1E user_name user_name 1539763203 szc 1539763246 szc 用户姓名 varchar(225) 225 887751A3-70C5-43A5-948E-441D759629F4 create_date create_date 1539165768 szc 1539165917 szc 创建时间 datetime BAD759C2-04AE-430E-8217-AF3EB37FCF0A Key_1 Key_1 1539165296 szc 1539165318 szc 5722CD12-6F13-4F10-9AB8-EE18E68E4BB3 tp_bill tp_bill 1539171783 szc 1539592819 szc 缴费项表 00D510E3-9D26-46BD-8098-8209BF6A7185 id id 1539245390 szc 1539245423 szc int(11) 11 1 1 0300F9EA-A730-4D0B-8959-9D477B29E891 community_id community_id 1539245419 szc 1539245772 szc 小区id int(11) 11 61F15739-6BF8-490A-B717-BDA49ED05961 bill_name bill_name 1539245419 szc 1539245584 szc 收费项名称 varchar(50) 50 2B7B7AD0-6540-4C34-B2EE-9F850D486E4C bill_explain bill_explain 1539245419 szc 1539245758 szc 缴费项说明 varchar(225) 225 7FCF17D9-49B9-488B-914A-0E4F744A4EE1 pay_price pay_price 1539592590 szc 1539592819 szc F8F49387-A379-43E1-9A17-051174E527DF pay_total_num pay_total_num 1539245574 szc 1539246022 szc 应缴户数 int(15) 15 055C608C-75DC-4573-9260-3A085D39EAB9 payed_num payed_num 1539245739 szc 1539246022 szc 已缴户数 int(15) 15 CEB30948-551B-441E-ADB7-A5156523FB67 unpayed_num unpayed_num 1539245739 szc 1539246022 szc 未缴户数 int(15) 15 5E403285-204E-4A36-BA71-431346A20CC2 bill_status bill_status 1539246022 szc 1540449341 szc 项目状态 0：正在收费 1：收费完成 2： 草稿 char(1) 1 71EF3BFB-F63C-4B5C-ACCC-4C88379A0BD6 end_date end_date 1539246308 szc 1539246431 szc 截止时间 datetime F275A7CC-9896-48B2-A254-9C348B371B8C create_user create_user 1539246424 szc 1539246525 szc 创建人 int(11) 11 652C8F69-F1E2-4657-84ED-D175029E2C26 create_date create_date 1539246424 szc 1539246538 szc 创建时间 datetime 649343A6-FAC7-4723-9E08-32A301D32C76 update_user update_user 1539246424 szc 1539246543 szc 更新人 int(11) 11 0DDE63E6-82C4-459B-98A2-F4982E570142 update_date update_date 1539246424 szc 1539246548 szc 更新时间 datetime 019602E0-EC9D-4E52-984C-A44F7017E7F8 Key_1 Key_1 1539245390 szc 1539245419 szc 8D2E67F5-3DE4-401D-ACB4-D1A0A548806E tp_bill_invoice tp_bill_invoice 1539171786 szc 1551768549 szc 缴费单 6FC63249-8186-4441-A54C-1C014C86CE76 id id 1539246719 szc 1539246734 szc int(11) 11 1 1 64777247-7632-44F4-ADA6-020AE07A71B1 community_id community_id 1539246732 szc 1539246758 szc 小区id int(11) 11 6E6EBAA3-02D1-461F-A617-F86CF22446FD bill_id bill_id 1539246751 szc 1539246787 szc 收费项id int(11) 11 A6F51382-E214-4962-95BB-A880D1C3D591 building_owner_info_id building_owner_info_id 1539246778 szc 1539246939 szc 楼栋业主资料信息id int(11) 11 73AFE2DD-565A-4B00-BA12-10B186B2388B ta_user_id ta_user_id 1539246778 szc 1539246984 szc app用户id int(11) 11 7094B961-1DD4-4C49-AB6C-1579F11EB8B2 bill_invoice_explain bill_invoice_explain 1539246930 szc 1539247178 szc 收费说明 varchar(225) 225 44134FEA-5E41-4E49-846E-DD8EB9289660 pay_price pay_price 1539246975 szc 1539247229 szc 收费金额 int(15) 15 87EF3439-EB26-40E9-96F5-CDC63DDA1F1C bill_statement_id bill_statement_id 1539247441 szc 1539247476 szc 账单流水id int(11) 11 E9C66B6E-DFF4-4867-A6A1-863CDA40C6E9 bill_status bill_status 1539247468 szc 1551768549 szc 缴费状态 0：未缴费 1: 已缴费 3: 正在支付中 char(1) 1 B7C2A30E-6D4A-43C8-87D9-CAE4C3EAAD86 pay_name pay_name 1539247526 szc 1539247742 szc 缴费人 varchar(50) 50 1A114EE4-5977-4CFC-A9CD-5227A9A7E5DC pay_date pay_date 1539247526 szc 1539247854 szc 缴费时间 datetime EC15C5B5-2CC8-4795-8A20-ED4DBD67682B status status 1550193639 szc 1550194873 szc 状态 0 是失效 1 是有效 char(1) 1 FC403B0B-1F27-4608-92F3-DEA86524B004 out_trade_no out_trade_no 1550631873 szc 1550631970 szc 微信支付的单号,唯一 varchar(32) 32 1 34BD995F-98FC-4F0A-BD7B-62F6C5499A88 pay_type pay_type 1551768469 szc 1551768549 szc 缴费方式 0：微信支付 1：线下缴费 char(1) 1 FCD5D37B-10E6-4FB8-A0B9-6019B746646D create_user create_user 1539247734 szc 1539247876 szc 创建人 int(11) 11 F5184E15-EB0F-46F8-982F-BF85A6788E45 create_date create_date 1539247734 szc 1539247869 szc 创建时间 datetime E34FCD0C-F16A-46E2-98D3-BC51F6855F2D update_user update_user 1539247734 szc 1539247906 szc 更新人 int(11) 11 4C3B1D9A-9C60-43CA-9D12-A01B3DEDCB84 update_date update_date 1539247734 szc 1539247902 szc 更新时间 datetime B694ACCF-3494-4724-A842-21DF6D0829A4 Key_1 Key_1 1539246719 szc 1539246732 szc 24003755-A085-4FDF-899F-2E9D7A515C13 ta_sys_role ta_sys_role 1539048863 szc 1539222670 szc app端角色 4451A0D9-2A71-4605-A381-8F028A8C5385 id id 1539049645 szc 1539222635 szc int(11) 11 1 1 14017C77-6BDF-4DF6-A3AF-9B85134F1FCB role_name role_name 1539049666 szc 1539222635 szc 角色名称 varchar(50) 50 A7C2427C-63E3-4AD1-BF41-ABF0C8D9C1CC description description 1539049666 szc 1539222635 szc 描述 varchar(255) 255 7D34A603-063E-446A-A891-AE72342ECB8D create_user create_user 1539049810 szc 1539222635 szc 创建人 int(11) 11 4B9630CE-926B-4C00-8B07-3C415F4B5264 create_date create_date 1539049841 szc 1539222635 szc 创建时间 datetime 4F837995-8D9E-4C3E-817F-49165AB564B1 update_user update_user 1539049841 szc 1539222635 szc 更新人 int(11) 11 0E354E8D-C5B8-432A-93A6-FC281C3BFDF9 update_date update_date 1539049841 szc 1539222635 szc 更新时间 datetime 4EA54A31-60BC-4718-8C0A-9819AA2D494A Key_1 Key_1 1539049645 szc 1539222635 szc 74C6325B-5C71-430C-B4B1-10285DD99059 ta_sys_user_role ta_sys_user_role 1533715068 szc 1539222800 szc app端用户是那些角色 ENGINE = InnoDB AUTO_INCREMENT = 799 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact D3653641-1986-407E-95BE-9E2D1E2BE4FA id id 1533715068 szc 1533715068 szc int(11) 11 1 1 B0775464-E5AC-47CE-9A05-A164607CAFDC community_id community_id 1539222771 szc 1539222807 szc 小区id int(11) 11 F74C4DC9-F9C8-47BE-A5D0-A0AAE03D6294 user_id user_id 1533715068 szc 1539222681 szc 用户ID NULL int(11) 11 54061991-5784-4235-991B-B5DBE4FB6658 role_id role_id 1533715068 szc 1539222681 szc 角色ID NULL int(11) 11 A4DA8184-3FFC-48E0-A7F3-96DC39AF2CC1 Key_1 Key_1 1533715068 szc 1533715068 szc 90A9E51C-B6D8-4C61-BF3D-22E6BA45264D tp_building_owner_info tp_building_owner_info 1539223552 szc 1546410633 szc 楼栋业主资料信息表 D7EBF176-CF9F-405A-8AF2-ACC9EE8E9087 id id 1539223614 szc 1539223630 szc int(11) 11 1 1 6F0484A3-2F06-45CC-8037-80D3C97623B1 community_id community_id 1539223627 szc 1539224400 szc 小区id int(11) 11 F7C772B7-0167-496F-BB5D-D550A81E6B52 id_card id_card 1539223944 szc 1539224079 szc 身份证号码 varchar(225) 225 0618ADB8-BBF6-4EDF-93DD-6D3E05245268 phase phase 1546410531 szc 1546410640 szc 期 varchar(225) 225 53A0A681-15F4-42BB-B194-DB770986B2EF building building 1539224063 szc 1539224105 szc 楼栋 varchar(225) 225 5B51D894-6FB3-49CF-9E1F-8234B373EA47 unit unit 1539224098 szc 1539224131 szc 单元 varchar(225) 225 5198C2CD-81FE-4F90-AAE7-B1CD23210421 level level 1539224123 szc 1539224156 szc 楼层 varchar(225) 225 466A6FF7-9B03-4D9A-B00A-03CD1D8982B1 room_no room_no 1539224147 szc 1539224179 szc 户号 varchar(225) 225 36C5F500-D6CC-4461-9710-9D28C40322A4 owner_name owner_name 1539224172 szc 1539224219 szc 业主姓名 varchar(225) 225 9B1A45FA-C980-45E2-A1C8-5A1A677148D9 owner_tel owner_tel 1539224172 szc 1539224230 szc 业主手机号 varchar(225) 225 AFE5B164-AC8E-42AF-9416-2DA3CA67B38F gender gender 1539224442 szc 1539224529 szc 性别 1：男 2：女 char(1) 1 9E49A1A5-8966-4975-B02C-615E064F59D1 pair_status pair_status 1539225350 szc 1539225556 szc 关联状态 0 未关联 1 是已关联 char(1) 1 54330B54-BA47-4A27-9BE1-57CAA3D8249C verify_status verify_status 1539225405 szc 1539225556 szc 认证状态 0 是未认证 1是认证通过 2是已作废 char(1) 1 F78D79FB-00CE-44F9-B49C-74D9F5229D12 create_user create_user 1539224234 szc 1539224342 szc 创建人 int(11) 11 8FB53E02-B948-454E-AFD3-E6E0443CCE93 create_date create_date 1539224234 szc 1539224358 szc 创建时间 datetime 491E4A34-83EA-4EE8-B008-57200698B33D update_user update_user 1539224234 szc 1539224379 szc 更新人 int(11) 11 F324D698-BC69-4B44-866F-90DD532B23CB update_date update_date 1539224234 szc 1539224388 szc 更新时间 datetime 9AEFD3FD-76CC-4383-96E5-9B36D19FA7C0 Key_1 Key_1 1539223614 szc 1539223627 szc CA027195-ADC1-46BF-B349-47F5541521DC tp_announcement_tel tp_announcement_tel 1539237890 szc 1539595985 szc 物业号码表 0F542B40-35B0-4F21-BED7-4633E1781982 id id 1539237892 szc 1539238029 szc int(11) 11 1 1 9C7AF8C3-F5A6-42ED-A709-B56395ABCE2B community_id community_id 1539238025 szc 1539238066 szc 小区id int(11) 11 CADEE3F0-8BA4-4F83-A7E6-1F748CB678BD name name 1539238060 szc 1539238148 szc 电话名称 varchar(50) 50 B61DF787-1BEF-484C-B968-571D2CA05F83 tel tel 1539238139 szc 1539238231 szc varchar(50) 50 6C2A212A-33D3-42C6-8C4E-384406E6032C remark remark 1539595952 szc 1539595985 szc 4619CF1D-B398-44CA-94CF-21C75A3DE15A create_user create_user 1539238139 szc 1539238238 szc 创建人 int(11) 11 D80EADDA-8AB9-44CA-AB8F-27B14A234493 create_date create_date 1539238139 szc 1539238246 szc 创建时间 datetime 9F4A99B0-03A3-4C40-B571-2F9498226686 update_user update_user 1539238139 szc 1539238251 szc 更新人 int(11) 11 BCACFCBD-2F9E-4323-A98E-C0CE0EAC6BB9 update_date update_date 1539238139 szc 1539238258 szc 更新时间 datetime 000A9404-77FE-4BBA-B7F7-75C17245ED88 Key_1 Key_1 1539237892 szc 1539238025 szc E40241FD-7065-45D3-A8BF-3B7A2B511B5D ta_agreement ta_agreement 1539243738 szc 1539243920 szc app协议表 14181365-652A-463E-AE30-3C92B7813123 id id 1539243805 szc 1539243827 szc int(11) 11 1 1 4066F364-5282-480F-BC1C-A35C98B9B4C0 user_agreement user_agreement 1539243825 szc 1539243876 szc 用户协议信息 text 9B575033-9DFD-4FF4-B6CF-23008AA53817 protection_statement protection_statement 1539243866 szc 1539243929 szc 保护声明 text CC97FE86-FB30-41BC-9D98-C56D9A3DE605 Key_1 Key_1 1539243805 szc 1539243825 szc CD97C8A8-D389-4B6F-BE2B-85800D37AA48 tp_bill_statement tp_bill_statement 1539247360 szc 1539593834 szc 账单流水表 C4DA4B1F-30E6-4A4B-8427-6AF3BC5FA1BA id id 1539247407 szc 1539247420 szc int(11) 11 1 1 771B3BC4-F682-4E41-A94F-2AB25118A748 community_id community_id 1539247419 szc 1539247978 szc 小区id int(11) 11 0F09D919-284C-4422-A9F8-2453B1E3E46C bill_invoice_id bill_invoice_id 1539247964 szc 1539248266 szc 缴费单id int(11) 11 B31E81EF-8DF1-4390-A240-12CB5C216B84 ta_user_id ta_user_id 1539248251 szc 1539248306 szc app 用户id int(11) 11 40739E9F-5006-4DBD-BB63-4BC7FCC97CF6 pay_price pay_price 1539248413 szc 1539248497 szc 收费金额 int(15) 15 B75275EF-C662-4808-8304-68A7B23ECF77 pay_name pay_name 1539248443 szc 1539248505 szc 缴费人 varchar(50) 50 8C945A51-70CD-4FF2-980C-F3E19F12D717 pay_remark pay_remark 1539248497 szc 1539248541 szc 缴费备注 varchar(225) 225 B9B550C4-0E63-4AD2-8B83-D731636083F5 pay_type pay_type 1539248534 szc 1540456024 szc 缴费方式 0：微信支付 char(1) 1 ED0CB245-1AD6-4E35-BD1E-6C3AADC5F97A create_time create_time 1539248561 szc 1539248637 szc 生成流水时间 datetime CEBA9D07-6C9D-4FFC-9240-D5E46E221B99 Key_1 Key_1 1539247407 szc 1539247419 szc B647C491-15B7-49A4-B800-48143CD906D9 tp_message tp_message 1539322763 szc 1552035003 szc 物业端消息表 BDCDF4A6-98B5-4CC0-8829-F6284766A14B id id 1539323722 szc 1539323837 szc int(11) 11 1 1 D03E0A5B-2851-4C0F-824E-FA5D7DAA85E8 ticket_id ticket_id 1542592363 szc 1542593157 szc 工单id 非工单不填 int(11) 11 FCA08EA8-A5F1-4F37-A695-BFA13B7B9678 community_id community_id 1539323834 szc 1539323980 szc 小区id int(11) 11 8B5D95EB-FA49-4053-8CA6-77C17AEB351D message_type message_type 1539323972 szc 1552034961 szc 消息类型 1：投诉 2：报修 3：联系物业 4： 访客 5:公告 6:系统通知 7:账单 8：活动 9:二手帖子 char(1) 1 2601130D-3290-4C78-854C-6DC1476BACB1 advice_type advice_type 1539324632 szc 1539335546 szc 通知方式 1 是app内通知 2是短信通知 3 是通知栏消息 4 是 web端消息 char(1) 1 DBD4644D-A8E2-4EC8-98F6-E7D60E78906F model_type model_type 1540192154 szc 1540192255 szc 模板类型 1 是消息模板 2是待办模板 char(1) 1 CF1215B1-0654-4789-B328-C9D793832047 uuid uuid 1539326362 szc 1540193111 szc 接收人id int(11) 11 B295677D-7272-4C81-B737-AC8DCC098315 uuid_type uuid_type 1540192986 szc 1540193138 szc 接收人id的类型 1是app用户 2是物业端用户 char(1) 1 7CABB4AE-D532-44C8-9ADD-CCBC30FB0F29 source source 1539335546 szc 1539335693 szc 来源 1 是app端 2是物业端 char(1) 1 D8D96343-2A56-44B9-B81D-52DDCB765639 message_content message_content 1539335673 szc 1539335742 szc 消息内容 varchar(225) 225 55A41567-09D9-411D-A5C1-C904F3EA19D9 status status 1539336169 szc 1540192823 szc 状态 1 是有效 0是无效 char(1) 1 984B2F10-304C-4ABC-B867-86509753D31F result result 1539596276 szc 1539764517 szc 推送结果 varchar(1) 1 A48FAAE1-05C8-4C5E-9D70-5708D7C23B10 meaasge_type_id meaasge_type_id 1539596276 szc 1540192214 szc 事件类型表的id 预留字段 varchar(1) 1 F5FF75F6-4EF1-4471-A4E6-00FE5E95D456 read_status read_status 1540192236 szc 1540192344 szc 阅读状态 0 是未读 1是已读 char(1) 1 AFF166EE-38D7-41B5-A42A-BA947B39E28A create_user create_user 1539335734 szc 1539335837 szc 创建人 int(11) 11 99A0E23D-1300-4D1A-9EEF-A90404954FF1 create_date create_date 1539335734 szc 1539335843 szc 创建时间 datetime 9675AFE0-2FB8-4712-8CC1-6504E2929182 update_user update_user 1539335734 szc 1539335849 szc 更新人 int(11) 11 DBD3CB9B-66E6-4A84-9866-A9AE9705E843 update_date update_date 1539335734 szc 1539335855 szc 更新时间 datetime 71F65324-7FAA-4294-86C4-E6361AFEF414 bill_id bill_id 1544435607 szc 1544435649 szc 缴费项目ID int(11) 11 E567C689-740A-4B5C-90BD-A4D78168D252 activity_id activity_id 1544435607 szc 1544435657 szc 活动ID int(11) 11 0AE8EF15-F2B1-40C4-AD9F-7BA680122B75 announcement_id announcement_id 1544435607 szc 1544435664 szc 公告ID int(11) 11 327B14D4-7337-4B00-AEFA-B71DD1C55E15 transaction_id transaction_id 1552034929 szc 1552035003 szc 二手租赁帖子ID int(11) 11 BA695BB4-ECCB-4DD3-83F3-7AFE92776BB4 Key_1 Key_1 1539323722 szc 1539323834 szc 4A482627-318E-47CF-A0ED-5A59F723F231 td_images td_images 1539759734 szc 1539760079 szc 图片表 02A61645-5027-4055-98D5-E4BD137D7806 id id 1539759737 szc 1539759811 szc int(11) 11 1 1 995FA719-50EE-463B-9489-1A8AF89671FD 图片路径 image_url 1539759808 szc 1539759901 szc 图片路径 varchar(225) 225 EC753ACC-4C6D-46CC-938F-EB92096F37D6 uuid uuid 1539759888 szc 1539759942 szc 图片关联的内容的id 根据类型来判断 int(11) 11 07A8FE0B-F95A-4748-A6DB-370A846F81F0 类型 type 1539759920 szc 1542770145 szc 类型 ： 服务：service, 公告：announcement , 活动：activity 租赁 ： transaction可添加 varchar(255) 255 7ACE3E66-DEB3-4564-BA4A-A442A5748D65 创建人 create_user 1539760014 szc 1539760088 szc 创建人 int(11) 11 C2200A93-10BA-4773-86DB-6385BB2D3A3F 创建时间 create_time 1539759964 szc 1539760079 szc 创建时间 datetime 0D467948-7C8F-4BDF-A9FD-5CA6DD570684 Key_1 Key_1 1539759737 szc 1539759808 szc 7D8BE1E9-C864-4C97-8720-C52072323209 tp_user_community tp_user_community 1539762745 szc 1539762973 szc 物业端用户和小区关联表 50F148B9-3880-4DC0-9B74-AB6CAF37AC17 id id 1539762829 szc 1539762907 szc int(11) 11 1 1 18F0E6F6-60B4-4048-AF49-169CF496F300 community_id community_id 1539762905 szc 1539762933 szc 小区id int(11) 11 17B30904-6546-439E-B269-4EEE2075451F tp_user_id tp_user_id 1539762926 szc 1539762982 szc 物业端用户id int(11) 11 5D5211E7-51B1-4B50-928C-12371122821B Key_1 Key_1 1539762829 szc 1539762905 szc 357A7E69-3652-41B5-A327-04CBDADA1820 tp_message_type tp_message_type 1539764641 szc 1539764766 szc 事件类型表 3CC3FC69-223C-41A7-8AF2-0444F4946A03 id id 1539764643 szc 1539764682 szc int(11) 11 1 1 6B99BA1E-B4F7-4F93-8A2B-B5C5A682C9C7 name name 1539764680 szc 1539764703 szc 事件名称 varchar(225) 225 BCD3ABCA-56E9-4BE8-994A-560E6208216C create_user create_user 1539764696 szc 1539764775 szc 创建人 int(11) 11 A20EC3C8-0346-4DF4-8BA0-1E0841E2CC7E create_date create_date 1539764696 szc 1539764784 szc 创建时间 datetime 79840112-EC18-4058-BAE4-BDE75257A6FA update_user update_user 1539764696 szc 1539764792 szc 更新人 int(11) 11 44EF3A31-2BBF-4ADA-A403-9843D767603C update_date update_date 1539764696 szc 1539764802 szc 更新时间 datetime B989961F-BE3A-468F-AD05-6516E546C12C Key_1 Key_1 1539764643 szc 1539764680 szc 9589EF6D-57F1-429C-A4D6-3FDA6EEFCAB8 td_model td_model 1540189341 szc 1540191968 szc 模板表 27F3D034-DFBA-4D02-BC88-814DE892B4E5 id id 1540189344 szc 1540189373 szc int(11) 11 1 1 51C66972-19CB-4479-B401-4B06BB72E069 advice_type advice_type 1540189370 szc 1540189542 szc 通知方式 1 是app内通知 2是短信通知 3 是通知栏消息 4 是 web端消息 char(1) 1 27D4FBCA-07D2-4AC2-A8DF-5B9EAC91396F model_type model_type 1540189532 szc 1540189934 szc 模板类型 1 是消息模板 2是待办模板 char(1) 1 A6B850B8-BC3E-4BD7-AC63-D3E3DB4A09C3 model_content model_content 1540189893 szc 1540191975 szc 模板内容 varchar(225) 225 52DE7143-02D7-476F-BE65-577CBE9998B0 Key_1 Key_1 1540189344 szc 1540189370 szc 7CD7E77D-B47E-4AFC-A463-1CBB465BDE24 ta_face ta_face 1540878443 szc 1540878816 szc 人脸检测图片 D5EBD47C-2C6C-4D56-9FE7-22F4A758066F id id 1540878446 szc 1540878524 szc int(11) 11 1 1 2FE425F0-3158-428E-B2FC-D633771E2674 community_id community_id 1540878521 szc 1540878696 szc 小区id int(11) 11 D7E63227-82C6-4CD8-8C18-FC3A18FDE237 ta_user_id ta_user_id 1540878521 szc 1540878707 szc 用户id int(11) 11 266429E0-0B45-49DA-A12B-E8FD02030904 face_img face_img 1540878521 szc 1540878726 szc 上传的图片 varchar(225) 225 FACD0182-56AF-489B-8788-573EBDD07FAD create_user create_user 1540878688 szc 1540878823 szc 创建人 int(11) 11 1095CBA6-2FCF-4B6A-9799-9D76F008013A create_date create_date 1540878688 szc 1540878832 szc 创建时间 datetime D5DF5EF0-ABD2-4ECB-A30A-6C743DE9DA37 update_user update_user 1540878688 szc 1540878840 szc 更新人 int(11) 11 645E14FA-7851-42F2-A2A0-21668C93DFA9 update_date update_date 1540878688 szc 1540878851 szc 更新时间 datetime A2FF19DF-C1D8-4600-BFE7-93E1F9FAA2E2 Key_1 Key_1 1540878446 szc 1540878521 szc E885747A-7925-4592-9B47-C2CCF9E0D015 ta_visitor ta_visitor 1540878979 szc 1540881674 szc 访客邀请表 E20BDFE1-0C5B-4562-BE5C-521046549490 id id 1540878983 szc 1540879016 szc int(11) 11 1 1 AAC05619-CB5B-434B-A3C5-8CAC49E83F7A community_id community_id 1540879014 szc 1540879069 szc 小区id int(11) 11 AC4034B5-9350-4AE2-94E1-3FA27FB6B20C visitor_name visitor_name 1540879014 szc 1540879082 szc 访客姓名 varchar(225) 225 44451565-B6B9-4512-B144-9472B85FD5A6 visitor_tel visitor_tel 1540879062 szc 1540879117 szc 访客电话 varchar(17) 17 2E1774B2-9817-4FDE-B58E-145F7D21EFDD visitor_num visitor_num 1540879111 szc 1540879141 szc 访客人数 varchar(17) 17 E633F959-2F29-46E9-8FCA-2BD9D282DE06 visitor_start_time visitor_start_time 1540879133 szc 1543392472 szc 来访时间 datetime 1D2BD0E0-2785-4936-9823-8F89B1C6C8C5 visitor_end_time visitor_end_time 1540879214 szc 1542090776 szc 来访结束时间 datetime 6BE9F0B8-5B0A-4C12-B04D-5FBABAE38477 driving_status driving_status 1540879214 szc 1540879947 szc 开车状态 0 是不开车 1是 开车 char(1) 1 0EE30237-EE8A-4923-A5BA-4D9837C17E56 pay_entity pay_entity 1540879920 szc 1540880354 szc 支付方式 owmer 是由我承担 visitor是 访客承担 varchar(25) 25 2A72C9EB-5167-4EC7-9D87-C009FFC0BA28 visitor_code visitor_code 1540881641 szc 1540881694 szc 访客码 varchar(50) 50 1A7082FD-6372-450D-A8D1-3FC40E93CE6B ta_user_id ta_user_id 1540880092 szc 1540880363 szc 住户id int(11) 11 F6E2E4F8-4A68-4457-8735-B9F7E5A9DD50 create_user create_user 1540880092 szc 1540880378 szc 创建人 int(11) 11 5CCD4747-0120-4B5D-8B16-8ADD8340EB01 create_date create_date 1540880354 szc 1540880423 szc 创建时间 datetime 795F89A8-0BD5-4B79-99EC-552CD6B610ED update_user update_user 1540880354 szc 1540880431 szc 更新人 int(11) 11 0022955C-089F-42F9-BF59-EB7CFB1D0E55 update_darte update_darte 1540880354 szc 1540880439 szc 更新时间 datetime 4CB0C771-9BA3-4B56-93A4-B917A1296EA6 Key_1 Key_1 1540878983 szc 1540879014 szc 169E71D8-F06B-47B9-93FC-EDEEDDDC0FE6 ta_visitor_license ta_visitor_license 1540880446 szc 1540880691 szc 访客牌照 22601EDB-16A3-4744-98A8-E4FAC2DB87F6 id id 1540880455 szc 1540880554 szc int(11) 11 1 1 7AB861AE-CCD0-4AC1-B29C-F9F46CB935BE community_id community_id 1540880553 szc 1540880578 szc 小区id int(11) 11 50D4CF21-2EBF-46F1-BC86-58AE4D106056 visitor_id visitor_id 1540880567 szc 1540880614 szc 访客id int(11) 11 68831EE6-7B81-4B94-86FA-9965B14F3789 license license 1540880603 szc 1540880646 szc 牌照 varchar(225) 225 F0F35858-4E64-4BEB-A169-72568A2848D4 create_user create_user 1540880638 szc 1540880697 szc 创建人 int(11) 11 7F06B3BD-0D0D-4B95-B79D-15C3E304F606 create_date create_date 1540880638 szc 1540880706 szc 创建时间 datetime 3F4485FA-FB98-41F1-99DA-34AC74C53E99 update_user update_user 1540880638 szc 1540880715 szc 更新人 int(11) 11 02E8112B-8E2F-4FFD-A759-C5AF2AFA267C update_date update_date 1540880638 szc 1540880723 szc 更新时间 datetime 449D1BB8-B153-4C0D-8B48-0DC1A3D4BD45 Key_1 Key_1 1540880455 szc 1540880553 szc CE591991-DAB1-4DDF-A520-10C64F6D55B9 ta_sys_menu ta_sys_menu 1533715068 szc 1551839729 szc APP端菜单页面 ENGINE = InnoDB AUTO_INCREMENT = 565 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Compact 6D51758A-FFD8-4DA2-B441-2C0F689CC11B id id 1533715068 szc 1541397458 szc 菜单ID int(11) 11 1 1 E609D716-3D27-4327-99B6-68BF5167A6AF community_id community_id 1541397374 szc 1541397465 szc 小区id int(11) 11 702E06F0-36C1-4BC4-AAFA-F6EBBFB1F6EE menu_name menu_name 1533715068 szc 1541397368 szc 菜单名称 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 20A88B4C-BEE8-41A9-A2A7-725AAF7134BB menu_url menu_url 1533715068 szc 1541397368 szc 菜单链接 varchar(200) 200 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 E3E5D883-C125-4FA4-A0A1-976A356DD3C8 parent_id parent_id 1533715068 szc 1541397368 szc 父级菜单ID NULL int(11) 11 3D4D485A-4492-4FF3-80F4-549675561EB8 sort sort 1533715068 szc 1541397368 szc 排序 NULL int(8) 8 00E62ED4-F9FE-4978-B14E-1ABBD798C902 menu_type menu_type 1533715068 szc 1541397763 szc 菜单类型 0 H5 1是 原生开发 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 6007E120-5D67-4740-888D-958845CF27C2 status status 1533715068 szc 1551854093 szc 状态 0正常 1.停用 9 删除 char(2) 2 {F4F16ECD-F2F1-4006-AF6F-638D5C65F35E},MYSQL50,55={9480E6AA-83DD-4AA7-9C91-E48F709C29D9},CharSet,4=utf8 AF391D2C-4D1D-4592-8F2F-29F98363BE60 remark remark 1542074031 szc 1542074231 szc 备注 face 代表人脸录入 monitor 代表是 公区监控 varchar(255) 255 D1FAE6FA-E08F-4587-A290-EB7A661A1DE1 explain explain 1551839687 szc 1551839729 szc 说明 varchar(255) 255 F1DC6704-B7A5-4FBF-9D69-829E807E40AB Key_1 Key_1 1533715068 szc 1533715068 szc 3B2ADC35-820A-4CD3-8FD2-8149D9C7A486 ta_sys_menu_img ta_sys_menu_img 1541398568 szc 1541398672 szc app端手机菜单图片表 一对多 97B9CBE3-AB28-41A0-88C8-BB1E75EBFFE2 id id 1541398571 szc 1541398626 szc int(11) 11 1 1 6FCB5733-B058-4D7A-8DF1-5173C376D30B ta_menu_id ta_menu_id 1541398624 szc 1541398690 szc 菜单id int(11) 11 8F484F00-FF54-4924-AB12-89C761CC7689 menu_icon_img menu_icon_img 1541398624 szc 1541398756 szc 菜单图片 varchar(225) 225 3B9C4822-136A-442B-B7F9-61E079261903 Key_1 Key_1 1541398571 szc 1541398624 szc 2020445A-9536-4528-9B58-79BF0F1BC3A8 tp_message_icon tp_message_icon 1542706044 szc 1543480192 szc 消息图标表 29A0FE03-A56F-4BCD-93CA-EB80927934B1 id id 1542706047 szc 1542706105 szc int(11) 11 1 1 A6AD1828-8034-4ABE-B557-26EB155D3766 message_type message_type 1542706103 szc 1544435690 szc 消息类型 1：投诉 2：报修 3：联系物业 4： 访客 5:公告 6:系统通知 7:账单8：活动 char(1) 1 4C7EA4E2-3B31-4C3E-B1ED-42452C64059D read_message_icon read_message_icon 1542706281 szc 1542706521 szc 已读图标url varchar(255) 255 D3774323-8294-4A48-8191-A1089354F624 unread_message_icon unread_message_icon 1542706438 szc 1542706516 szc 未读图标url varchar(255) 255 C445B8E4-084E-4063-AB92-2E31B6C816BE message_detail_url message_detail_url 1542768554 szc 1542768618 szc 消息详情url varchar(255) 255 F8DE996A-E9C4-44EA-8206-53522A2FCF05 message_icon_title message_icon_title 1543480070 szc 1543480192 szc varchar(255) 255 26A69CCB-020F-4EF0-9143-8764DED242E3 Key_1 Key_1 1542706047 szc 1542706103 szc DA8BCB49-B53D-4292-8F74-53A643DB2C6C mq_message mq_message 1542952019 szc 1542957441 szc 消息订阅消息表 4DD5CBA6-770E-473F-8934-5EDD96D121F6 id id 1542952320 szc 1542952420 szc int(11) 11 1 1 F0349ADD-66D0-430E-9B11-967D6DF4BC81 event_state event_state 1542952415 szc 1542952565 szc int(1) 1 CBD7DBE3-3C04-499A-94AB-1C22E7AF0412 event_level event_level 1542952415 szc 1542952565 szc int(1) 1 BAA092FC-2CAA-4436-A1A3-A8893186518D unit_idx unit_idx 1542952415 szc 1542953140 szc varchar(255) 255 742654AC-6855-4891-87C7-4F7335D8BA0C event_type event_type 1542952568 szc 1542953140 szc int(25) 25 11434250-0829-481C-ADDB-8789D8B5C945 event_type_name event_type_name 1542952568 szc 1542953140 szc varchar(255) 255 915EB2CD-278E-4ACA-A7B7-32B7D61E580A sub_sys_type sub_sys_type 1542952568 szc 1542953140 szc int(50) 50 524D78DB-D5B6-4E21-9A78-65FC94CA9B71 event_name event_name 1542952568 szc 1542953140 szc varchar(255) 255 F9586B5B-ACA5-4E20-B579-B82194825179 start_time start_time 1542952568 szc 1542953140 szc datetime BE71711E-DB09-4B43-B3FA-73BB502535F0 stop_time stop_time 1542952568 szc 1542953140 szc datetime 9729C389-4C89-4E46-8E41-4EA84669E2B2 source_idx source_idx 1542952568 szc 1542960175 szc varchar(255) 255 5DA158D3-6F7D-4D03-8D78-C3D556CB6AC5 source_type source_type 1542952568 szc 1542959578 szc int(90) 90 3D617607-AAB2-4D24-8C28-578B3FBC4917 source_name source_name 1542952568 szc 1542953140 szc varchar(255) 255 2FB9D075-CCF8-4343-A18C-D1B6D0B8BB01 region_idx region_idx 1542952568 szc 1542953140 szc varchar(255) 255 4E2A38B4-023B-4E01-BA6A-4B84AF01B9FE event_code event_code 1542952568 szc 1542953140 szc int(90) 90 A7312C07-60F4-4674-83F6-090D266440BA device_id device_id 1542952568 szc 1542953140 szc int(90) 90 F5E5F8C9-7034-420B-8B3E-1A301730D33C device_type device_type 1542952568 szc 1542953140 szc int(90) 90 062C16C4-1155-4D16-913D-66F096B57D1A device_name device_name 1542952568 szc 1542953140 szc varchar(255) 255 BBD618AF-FDB0-417A-A778-3A0B8997050E event_card event_card 1542952568 szc 1542953140 szc varchar(255) 255 34808DF1-4711-4258-81A4-B6DB181DD52D person_id person_id 1542952568 szc 1542953140 szc int(90) 90 32CEE916-F12F-45AF-BC83-1D42B8B8BD20 person_name person_name 1542952568 szc 1542953140 szc varchar(255) 255 27739F03-7477-4759-A70A-E1BF5D1ACF77 dept_id dept_id 1542952568 szc 1542953140 szc int(90) 90 5F000DC1-611B-492E-B9D8-589F39BFA951 dept_name dept_name 1542952568 szc 1542953140 szc varchar(255) 255 D7E8BB80-0895-4A12-9F55-7E9FE12C83D2 dept_code dept_code 1542952568 szc 1542953140 szc varchar(255) 255 02FC83B5-57D3-40CF-A434-0B2B6A66EE2F in_out in_out 1542952568 szc 1542953140 szc int(10) 10 EDF7E2FE-E5B8-4EB2-8622-37D735B11AC3 ext_txt ext_txt 1542952568 szc 1542953140 szc text 2D0F6C5E-E444-4A9D-A180-9E6849EAA091 card_status card_status 1542952568 szc 1542953140 szc int(10) 10 85DCD41F-8F80-4AFB-9629-3A14080EFB37 pic_url pic_url 1542952568 szc 1542953140 szc varchar(255) 255 471D6AE4-41F1-4EBB-B439-16ED2470870B Key_1 Key_1 1542952320 szc 1542952415 szc EBDD1C7D-21CB-48F1-9837-B0A2AC2BEEC0 sys_report_reason sys_report_reason 1546480499 szc 1546480671 szc 举报原因表 7813F887-78FB-4151-8EDD-0AFC743E7414 id id 1546480504 szc 1546480540 szc int(11) 11 1 1 634EA064-F97B-47C3-A9DA-048727A275B7 reason reason 1546480537 szc 1546480671 szc varchar(225) 225 8264C37A-8C8C-4B3E-9BC0-960D2288C35B sort sort 1546480537 szc 1546480671 szc int(8) 8 CC6C6617-F2A1-4FB6-A1CC-E66E9D806459 Key_1 Key_1 1546480504 szc 1546480537 szc 4F6FA829-66E8-4196-91D8-3DB7F1655F10 tp_persion tp_persion 1546498159 szc 1546498192 szc 物业端人员表 881928C6-A526-4033-B81C-2AD0FB368F33 tp_transaction_report tp_transaction_report 1546565834 szc 1546566290 szc 二手交易举报表 A2FB2CD6-1E12-401A-8045-8B200E349EC9 id id 1546565836 szc 1546565995 szc int(11) 11 1 1 C7F7361F-1844-4A44-9F7D-956D874CE40C community_id community_id 1546565993 szc 1546566132 szc 小区id int(11) 11 375D2CE3-A21E-42DE-932E-174D57349EB7 transaction_id transaction_id 1546566038 szc 1546566176 szc 二手交易id int(11) 11 174AB9D8-4541-45F2-9819-147A84F787A9 report_reason_id report_reason_id 1546566158 szc 1546566963 szc 举报原因id varchar(225) 225 DE05B6C9-59EA-4355-B645-8D8C2C4D8A9E reporter_id reporter_id 1546566158 szc 1546566302 szc app用户端的举报者 int(11) 11 48A43472-90A4-4855-BBA0-6D9D80D45C46 Key_1 Key_1 1546565836 szc 1546565993 szc 333A8C7B-B946-494C-8533-50DF64405BEB long_connection_status long_connection_status 1548054314 szc 1548054656 szc 长连接的状态表 2BF9E4DE-D7A3-464D-AC17-C251B72F6279 id id 1548054318 szc 1548054497 szc int(11) 11 1 1 59A22160-4D28-4B6A-B149-A87B6473AA3F connection_name connection_name 1548054495 szc 1548054656 szc 长连接的类型名称 varchar(225) 225 43649F1B-8B6C-48CC-AB82-6C6A01170806 status status 1548054495 szc 1548054656 szc 状态(0 不返回数据，1 返回数据) char(1) 1 CCDE8FE4-0C4B-4181-8CAD-AE2B78828BE7 Key_1 Key_1 1548054318 szc 1548054495 szc 00F9A727-7DE7-4F7A-A9D6-5ED2B31AF0F5 tp_transaction_reply tp_transaction_reply 1552288382 szc 1552289425 szc 物业web端二手交易评论表 5D7B4170-1A35-4CDE-BE13-5E5B8655EA49 id id 1552288396 szc 1552288515 szc int(11) 11 1 1 9819B04E-D705-450A-B55F-3FEF37448CD4 community_id community_id 1552288481 szc 1552289425 szc 小区id int(11) 11 777E2C82-0380-4016-80C0-A84B1A30A4FA transaction_id transaction_id 1552288481 szc 1552289465 szc 交易帖子ID int(11) 11 EC713D13-9A3F-483D-A847-6E40E2D65E83 ta_user_id ta_user_id 1552288481 szc 1552289465 szc 回复帖子的住户APP端的用户ID int(11) 11 2AACFE09-0EF0-456C-A348-33F901E2EE52 ta_user_name ta_user_name 1552288481 szc 1552289465 szc 回复帖子的住户APP端的用户姓名 varchar(255) 255 3ABB53CF-6742-4BB4-A33B-8D207C34AB5D reply_content reply_content 1552288481 szc 1552289465 szc 回复内容 varchar(255) 255 84467DDB-CC8F-4EDB-8E26-AF972B017EB6 reply_ta_user_id reply_ta_user_id 1552288481 szc 1552289465 szc 被回复的评论内容的住户App端用户ID int(11) 11 1E085FF7-970D-40D2-9908-1DB7705E6BF2 reply_ta_user_name reply_ta_user_name 1552288481 szc 1552289465 szc 被回复的评论内容的住户App端用户姓名 varchar(255) 255 0DDA9878-6685-40D4-B7FE-89862E68CD66 create_date create_date 1552288481 szc 1552289465 szc 创建时间 datetime 424847FB-64A2-413B-8205-4DBFCD92C966 Key_1 Key_1 1552288481 szc 1552288515 szc EEE27036-3948-4114-9BF7-F83B6D51412B tp_transaction_like tp_transaction_like 1552542046 szc 1552542473 szc 二手租赁喜好表 D9D18879-0AC3-4F81-BBAA-828F21E065B5 id id 1552542049 szc 1552542138 szc int(11) 11 1 1 3646CE25-7F39-4A8E-9CF2-D0A6C94B1E37 community_id community_id 1552542049 szc 1552542234 szc 小区ID int(11) 11 27A60EF0-9116-4514-A1DB-9898D4A31ECF ta_user_id ta_user_id 1552542135 szc 1552542234 szc 住户端App用户ID int(11) 11 98160D61-BECD-4C0B-8779-23B5E96D6128 transaction_id transaction_id 1552542135 szc 1552542473 szc 交易帖子ID int(11) 11 F52062DB-EC84-4A6D-9811-0E690A62F652 like_status like_status 1552542234 szc 1552542473 szc 1是喜欢 2是不喜欢 varchar(2) 2 94AC4086-281D-4B4B-9C03-61083B2B5DEF create_date create_date 1552542234 szc 1552542473 szc 创建时间 datetime C0365061-D96F-4182-8620-47B39A9B98AF Column_7 update_date 1552542234 szc 1552542473 szc 更新时间 datetime 6BE5DBA8-4AB3-4958-80DD-B7760DB2ECB5 Key_1 Key_1 1552542049 szc 1552542135 szc 9FAF56B5-A351-488F-9A3B-D4A944CD4081 PUBLIC PUBLIC 1539048464 szc 1539048464 szc 4E11BE8F-F439-472A-B60F-FF5658DC0291 1539051658 szc 1539051658 szc ED78D9EA-BE53-406D-854D-ABAE0E3B0732 1539051667 szc 1539051667 szc E8B0A073-625B-43A3-9DEF-1E89EA6BB1BC 1539051707 szc 1539051707 szc AFA093A5-E93D-458E-974B-4C2EC18784DE 1539065038 szc 1539065038 szc E81C9279-78CF-492F-A326-4329800E8399 1539073099 szc 1539073099 szc 449DC67A-80F3-4599-8EE5-420B1EDA16E7 1539073104 szc 1539073104 szc ADC2B5E0-82BD-4286-8887-DABEFD1423B5 1539073108 szc 1539073108 szc 531818E5-E4FE-487A-AE8F-98D5B0C7F846 1539073112 szc 1539073112 szc 9E96EDCD-0391-436E-BEBC-FF281D4BC9F7 1539141182 szc 1539141182 szc A9ED97FE-687D-4796-8689-C5A928DFCAE3 1539141343 szc 1539141343 szc C77525EF-C4C8-45CB-866E-50419171C1C9 1539143631 szc 1539143631 szc 38E7B161-65A1-403A-961B-DEF8DD9AC238 1539151702 szc 1539151702 szc 94417CEE-DDC1-480F-971F-D07E5EB0C89D 1539151705 szc 1539151705 szc 793AA33C-1A31-4954-92DF-61382C7E6085 1539155088 szc 1539155088 szc 676789CA-95BC-4DA9-934B-A1BCFD4151C6 1539163549 szc 1539163549 szc CC4ED887-5BD9-403A-A2F2-224677BCBE04 1539163554 szc 1539163554 szc CD88558F-3853-48D6-941F-119DFB4C89A2 1539165080 szc 1539165080 szc 5B1C7D2E-7939-45E2-B3D0-82DF8C562CB4 1539165928 szc 1539165928 szc 1024A73D-E56E-438E-9528-C44D7EFC0E4F 1539222729 szc 1539222729 szc 4FB77D04-D8A7-4BE5-8A9A-64F9586169E6 1539222732 szc 1539222732 szc E50461F4-4E44-44B6-96AB-F83A47FCA038 1539225316 szc 1539225316 szc 96AC279A-6D2A-4F08-8F86-09024388639E 1539247925 szc 1539247925 szc 6A89E18E-F131-45B3-B8D9-378696BAB88F 1539247933 szc 1539247933 szc 3C9325BC-CFDD-41CD-8AE7-757D119E68C6 1539247935 szc 1539247935 szc 5253905C-FB8A-4C8B-B88F-ABDEB1BA5011 1539248647 szc 1539248647 szc FDA29219-205D-4E7D-AA04-3AF597010BAC 1539248649 szc 1539248649 szc C25F9E1D-799A-40D8-80DB-05A2927B1CEF 1539248656 szc 1539248656 szc 8DC2DF1C-6655-4633-9560-19A95760BA90 1539762995 szc 1539762995 szc 576D7750-D1E0-4DAA-867F-AB572BEF4998 1539763022 szc 1539763022 szc D033E91C-8691-4CFE-9C1D-2D38C1E34CD9 1540878858 szc 1540878858 szc 576B3B59-044C-4E53-9BD0-3487CBBAECAE 1540880451 szc 1540880451 szc CAE33A30-8C04-40F4-8E14-CC91213F21F8 1540880736 szc 1540880736 szc 52E38B46-DD21-438B-A86B-6D9A3286728B 1541398705 szc 1541398705 szc 63110909-5966-450C-8EB8-8072E8D7E4DF 1546566350 szc 1546566350 szc 96E7D423-8D9C-4E3B-8DF4-9711A70BED1C 1552289478 szc 1552289478 szc FD935883-26F6-4A89-84C6-9EE237EE4E9E 1552542496 szc 1552542496 szc B86EB932-C352-4174-86E4-2D2B1DDE4A45 MySQL 5.0 MYSQL50 1539048464 szc 1539048464 szc file:///%_DBMS%/mysql50.xdb F4F16ECD-F2F1-4006-AF6F-638D5C65F35E 4BA9F647-DAB1-11D1-9944-006097355D9B 1276524678