60C74F8E-C582-45F8-ACB7-83B878C87E1B Physical Data _1 Physical Data _1 1650887183 Administrator 1650887219 Administrator [FolderOptions] [FolderOptions\Physical Objects] GenerationCheckModel=Yes GenerationPath= GenerationOptions= GenerationTasks= GenerationTargets= GenerationSelections= RevPkey=Yes RevFkey=Yes RevAkey=Yes RevCheck=Yes RevIndx=Yes RevOpts=Yes RevViewAsTabl=No RevViewOpts=Yes RevSystAsTabl=Yes RevTablPerm=No RevViewPerm=No RevProcPerm=No RevDbpkPerm=No RevSqncPerm=No RevAdtPerm=No RevUserPriv=No RevUserOpts=No RevGrpePriv=No RevRolePriv=No RevDtbsOpts=Yes RevDtbsPerm=No RevViewIndx=Yes RevJidxOpts=Yes RevStats=No RevTspcPerm=No RevCaseSensitive=No GenTrgrStdMsg=Yes GenTrgrMsgTab= GenTrgrMsgNo= GenTrgrMsgTxt= TrgrPreserve=No TrgrIns=Yes TrgrUpd=Yes TrgrDel=Yes TrgrC2Ins=Yes TrgrC2Upd=Yes TrgrC3=Yes TrgrC4=Yes TrgrC5=Yes TrgrC6=Yes TrgrC7=Yes TrgrC8=Yes TrgrC9=Yes TrgrC10=Yes TrgrC11=Yes TrgrC1=Yes TrgrC12Ins=Yes TrgrC12Upd=Yes TrgrC13=Yes UpdateTableStatistics=Yes UpdateColumnStatistics=Yes [FolderOptions\Physical Objects\Database Generation] GenScriptName=crebas GenScriptName0= GenScriptName1= GenScriptName2= GenScriptName3= GenScriptName4= GenScriptName5= GenScriptName6= GenScriptName7= GenScriptName8= GenScriptName9= GenPathName= GenSingleFile=Yes GenODBC=No GenCheckModel=Yes GenScriptPrev=Yes GenArchiveModel=No GenUseSync=No GenSyncChoice=0 GenSyncArch= GenSyncRmg=0 [FolderOptions\Physical Objects\Database Generation\Format] GenScriptTitle=Yes GenScriptNamLabl=No GenScriptQDtbs=Yes GenScriptQOwnr=Yes GenScriptCase=0 GenScriptEncoding=ANSI GenScriptNAcct=No IdentifierDelimiter=" [FolderOptions\Physical Objects\Database Generation\Database] Create=Yes Open=Yes Close=Yes Drop=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Database\Create] Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Tablespace] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Tablespace\Create] Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Storage] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\User] Create=Yes Grant=Yes Drop=Yes Comment=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\User\Create] Physical Options=No [FolderOptions\Physical Objects\Database Generation\Group] Create=Yes Drop=Yes Comment=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\Role] Create=Yes Drop=Yes Privilege=No [FolderOptions\Physical Objects\Database Generation\UserDefinedDataType] Create=Yes Comment=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\UserDefinedDataType\Create] Default value=Yes Check=Yes [FolderOptions\Physical Objects\Database Generation\AbstractDataType] Create=Yes Header=Yes Footer=Yes Drop=Yes Comment=Yes Install JAVA class=Yes Remove JAVA class=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Rule] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Default] Create=Yes Comment=Yes Drop=Yes [FolderOptions\Physical Objects\Database Generation\Sequence] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Table&&Column] [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create] Check=Yes Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Table\Create\Check] Constraint declaration=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Column] User datatype=Yes Default value=Yes Check=Yes Physical Options=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Column\Check] Constraint declaration=No [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key] [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Primary key\Create] Constraint declaration=No Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Key\Alternate key\Create] Constraint declaration=No Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Foreign key\Create] Constraint declaration=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Create] Constraint declaration=Yes Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Index\Filter] Primary key=Yes Foreign key=Yes Alternate key=Yes Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\Table&&Column\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [FolderOptions\Physical Objects\Database Generation\View] Create=Yes Drop=Yes Comment=Yes Permission=No [FolderOptions\Physical Objects\Database Generation\View\Create] Force Column list=No Physical Options=Yes Header=Yes Footer=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewColumn] Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Create] Physical Options=Yes [FolderOptions\Physical Objects\Database Generation\View\ViewIndex\Filter] Cluster=Yes Other=Yes [FolderOptions\Physical Objects\Database Generation\View\Trigger] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Database Generation\View\Trigger\Filter] For insert=Yes For update=Yes For delete=Yes For other=Yes [FolderOptions\Physical Objects\Database Generation\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\Database Generation\ExtendedObject <<Event>>] Create=Yes Drop=Yes Comment=Yes [FolderOptions\Physical Objects\Test Data] GenDataPathName= GenDataSinglefile=Yes GenDataScriptName=testdata GenDataScriptName0= GenDataScriptName1= GenDataScriptName2= GenDataScriptName3= GenDataScriptName4= GenDataScriptName5= GenDataScriptName6= GenDataScriptName7= GenDataScriptName8= GenDataScriptName9= GenDataOdbc=0 GenDataDelOld=No GenDataTitle=No GenDataDefNumRows=20 GenDataCommit=0 GenDataPacket=0 GenDataOwner=No GenDataProfNumb= GenDataProfChar= GenDataProfDate= GenDataCSVSeparator=, GenDataFileFormat=CSV GenDataUseWizard=No [FolderOptions\Pdm] IndxIQName=%COLUMN%_%INDEXTYPE% IndxPK=Yes IndxFK=Yes IndxAK=Yes IndxPKName=%TABLE%_PK IndxFKName=%REFR%_FK IndxAKName=%AKEY%_AK IndxPreserve=No IndxThreshold=0 IndxStats=No RefrPreserve=No JidxPreserve=No RbldMultiFact=Yes RbldMultiDim=Yes RbldMultiJidx=Yes CubePreserve=No TablStProcPreserve=No ProcDepPreserve=Yes TrgrDepPreserve=Yes CubeScriptPath= CubeScriptCase=0 CubeScriptEncoding=ANSI CubeScriptNacct=No CubeScriptHeader=No CubeScriptExt=csv CubeScriptExt0=txt CubeScriptExt1= CubeScriptExt2= CubeScriptSep=, CubeScriptDeli=" DfltDomnName=D_%.U:VALUE% DfltColnName=D_%.U:VALUE% DfltReuse=Yes DfltDrop=Yes [ModelOptions] [ModelOptions\Physical Objects] CaseSensitive=No DisplayName=Yes EnableTrans=No EnableRequirements=No DefaultDttp= IgnoreOwner=No RebuildTrigger=Yes RefrUnique=No RefrAutoMigrate=Yes RefrMigrateReuse=Yes RefrMigrateDomain=Yes RefrMigrateCheck=Yes RefrMigrateRule=Yes RefrMigrateExtd=No RefrMigrDefaultLink=No RefrDfltImpl=D RefrPrgtColn=No RefrMigrateToEnd=No RebuildTriggerDep=No ColnFKName=%.3:PARENT%_%COLUMN% ColnFKNameUse=No DomnCopyDttp=Yes DomnCopyChck=No DomnCopyRule=No DomnCopyMand=No DomnCopyExtd=No DomnCopyProf=No Notation=0 DomnDefaultMandatory=No ColnDefaultMandatory=No TablDefaultOwner= ViewDefaultOwner= TrgrDefaultOwnerTabl= TrgrDefaultOwnerView= IdxDefaultOwnerTabl= IdxDefaultOwnerView= JdxDefaultOwner= DBPackDefaultOwner= SeqDefaultOwner= ProcDefaultOwner= 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=30 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=128 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=128 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=128 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=128 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=128 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\CUBE] [ModelOptions\Physical Objects\ClssNamingOptions\CUBE\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\CUBE\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\Pdm] RRMapping=No [ModelOptions\Generate\Cdm] CheckModel=Yes SaveLinks=Yes NameToCode=No Notation=2 [ModelOptions\Generate\Oom] CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=Yes ClassPrefix= [ModelOptions\Generate\Xsm] CheckModel=Yes SaveLinks=Yes ORMapping=No NameToCode=No [ModelOptions\Generate\Ldm] CheckModel=Yes SaveLinks=Yes NameToCode=No [ModelOptions\Default Opts] [ModelOptions\Default Opts\TABL] PhysOpts= [ModelOptions\Default Opts\COLN] PhysOpts= [ModelOptions\Default Opts\INDX] PhysOpts= [ModelOptions\Default Opts\AKEY] PhysOpts= [ModelOptions\Default Opts\PKEY] PhysOpts= [ModelOptions\Default Opts\STOR] PhysOpts= [ModelOptions\Default Opts\TSPC] PhysOpts= [ModelOptions\Default Opts\SQNC] PhysOpts= [ModelOptions\Default Opts\DTBS] PhysOpts= [ModelOptions\Default Opts\USER] PhysOpts= [ModelOptions\Default Opts\JIDX] PhysOpts= CF808581-F1E0-455E-9A18-41836D65DDBB Sybase SQL Anywhere 11 SYASA11 1650887182 Administrator 1650887182 Administrator 9C2029CC-5AF2-4828-AA6C-11C184EF93D8 4BA9F647-DAB1-11D1-9944-006097355D9B 74F4A332-9F40-4B00-B91B-9219FA73AD73 PhysicalDiagram_1 PhysicalDiagram_1 1650887183 Administrator 1650887728 Administrator [DisplayPreferences] [DisplayPreferences\PDM] [DisplayPreferences\General] Adjust to text=Yes Snap Grid=No Constrain Labels=Yes Display Grid=No Show Page Delimiter=Yes Grid size=0 Graphic unit=2 Window color=255, 255, 255 Background image= Background mode=8 Watermark image= Watermark mode=8 Show watermark on screen=No Gradient mode=0 Gradient end color=255, 255, 255 Show Swimlane=No SwimlaneVert=Yes TreeVert=No CompDark=0 [DisplayPreferences\Object] Mode=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_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Object Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> ELnkShowStrn=Yes ELnkShowName=Yes ExtendedLink_SymbolLayout=<Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Source" >[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] </Form>[CRLF]</Form> FileObject.Stereotype=No FileObject.DisplayName=Yes FileObject.LocationOrName=No FileObject.IconPicture=No FileObject.IconMode=Yes FileObject_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Location" Attribute="LocationOrName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> PckgShowStrn=Yes Package.Comment=No Package.IconPicture=No Package_SymbolLayout= 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_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="Stereotype No\r\nDisplayName Yes\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nDomain No\r\nKeyIndicator No\r\nIndexIndicator No\r\nNullStatus No" Filters=""All Columns" PDMCOLNALL ""\r\n"PK Columns" PDMCOLNPK "PRIM \"TRUE\" TRUE"\r\n"Key Columns" PDMCOLNKEY "KEYS \"TRUE\" TRUE"" HasLimit="Yes" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Keys" Collection="Keys" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="Stereotype No\r\nDisplayName Yes\r\nIndicator No" HasLimit="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Triggers" Collection="Triggers" Columns="Stereotype No\r\nDisplayName Yes" HasLimit="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]</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_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardCollection Name="Columns" Collection="Columns" Columns="DisplayName No\r\nExpression No\r\nDataType No\r\nSymbolDataType No "Domain or Data type"\r\nIndexIndicator No" HasLimit="Yes" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Tables" Collection="TemporaryVTables" Columns="Name Yes" HasLimit="No" Caption="" Mandatory="No" />[CRLF] <StandardCollection Name="Indexes" Collection="Indexes" Columns="DisplayName Yes" HasLimit="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]</Form> Procedure.Stereotype=No Procedure.DisplayName=Yes Procedure.OwnerDisplayName=No Procedure.Comment=No Procedure.IconPicture=No Procedure_SymbolLayout=<Form>[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="Yes" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Owner and Name" Attribute="OwnerDisplayName" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <Separator Name="Separator" />[CRLF] <StandardAttribute Name="Comment" Attribute="Comment" Prefix="" Suffix="" Alignment="LEFT" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Icon" Attribute="IconPicture" Prefix="" Suffix="" Alignment="CNTR" Caption="" Mandatory="Yes" />[CRLF]</Form> Reference.Cardinality=No Reference.ImplementationType=No Reference.ChildRole=Yes Reference.Stereotype=Yes Reference.DisplayName=No Reference.ForeignKeyConstraintName=No Reference.JoinExpression=No Reference.Integrity=No Reference.ParentRole=Yes Reference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Cardinality" Attribute="Cardinality" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Implementation" Attribute="ImplementationType" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Cons&traint Name" Attribute="ForeignKeyConstraintName" Prefix="" Suffix="" Caption="Cons&traint Name" Mandatory="No" />[CRLF] <StandardAttribute Name="Join" Attribute="JoinExpression" Prefix="" Suffix="" Caption="Join" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] <StandardAttribute Name="Referential integrity" Attribute="Integrity" Prefix="" Suffix="" Caption="Referential integrity" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> ViewReference.ChildRole=Yes ViewReference.Stereotype=Yes ViewReference.DisplayName=No ViewReference.JoinExpression=No ViewReference.ParentRole=Yes ViewReference_SymbolLayout=<Form>[CRLF] <Form Name="Source" >[CRLF] <StandardAttribute Name="Child Role" Attribute="ChildRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF] <Form Name="Center" >[CRLF] <StandardAttribute Name="Stereotype" Attribute="Stereotype" Prefix="<<" Suffix=">>" Caption="" Mandatory="No" />[CRLF] <ExclusiveChoice Name="Exclusive Choice" Mandatory="No" Display="HorizontalRadios" >[CRLF] <StandardAttribute Name="Name" Attribute="DisplayName" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] <StandardAttribute Name="Join Expression" Attribute="JoinExpression" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </ExclusiveChoice>[CRLF] </Form>[CRLF] <Form Name="Destination" >[CRLF] <StandardAttribute Name="Parent Role" Attribute="ParentRole" Prefix="" Suffix="" Caption="" Mandatory="No" />[CRLF] </Form>[CRLF]</Form> [DisplayPreferences\Symbol] [DisplayPreferences\Symbol\FRMEOBJ] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=6000 Height=2000 Brush color=255 255 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=64 Brush gradient color=192 192 192 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 255 128 128 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FRMELNK] CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\FILO] OBJSTRNFont=新宋体,8,N OBJSTRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LCNMFont=新宋体,8,N LCNMFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PDMPCKG] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=3600 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 178 178 178 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\TABL] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 KeysFont=新宋体,8,N KeysFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 TriggersFont=新宋体,8,N TriggersFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=178 214 252 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VIEW] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 ColumnsFont=新宋体,8,N ColumnsFont color=0, 0, 0 TablePkColumnsFont=新宋体,8,U TablePkColumnsFont color=0, 0, 0 TableFkColumnsFont=新宋体,8,N TableFkColumnsFont color=0, 0, 0 TemporaryVTablesFont=新宋体,8,N TemporaryVTablesFont color=0, 0, 0 IndexesFont=新宋体,8,N IndexesFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4800 Height=4000 Brush color=208 208 255 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\PROC] STRNFont=新宋体,8,N STRNFont color=0, 0, 0 DISPNAMEFont=新宋体,8,N DISPNAMEFont color=0, 0, 0 OWNRDISPNAMEFont=新宋体,8,N OWNRDISPNAMEFont color=0, 0, 0 LABLFont=新宋体,8,N LABLFont color=0, 0, 0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Width=4000 Height=1000 Brush color=255 255 192 Fill Color=Yes Brush style=6 Brush bitmap mode=12 Brush gradient mode=65 Brush gradient color=255 255 255 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 108 0 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\REFR] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\VREF] SOURCEFont=新宋体,8,N SOURCEFont color=0, 0, 0 CENTERFont=新宋体,8,N CENTERFont color=0, 0, 0 DESTINATIONFont=新宋体,8,N DESTINATIONFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 128 128 192 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\USRDEPD] OBJXSTRFont=新宋体,8,N OBJXSTRFont color=0, 0, 0 Line style=1 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=2 0 128 128 255 Shadow color=192 192 192 Shadow=0 [DisplayPreferences\Symbol\Free Symbol] Free TextFont=新宋体,8,N Free TextFont color=0, 0, 0 Line style=0 AutoAdjustToText=Yes Keep aspect=No Keep center=No Keep size=No Brush color=255 255 255 Fill Color=Yes Brush style=1 Brush bitmap mode=12 Brush gradient mode=0 Brush gradient color=118 118 118 Brush background image= Custom shape= Custom text mode=0 Pen=1 0 0 0 255 Shadow color=192 192 192 Shadow=0 (8268, 11693) ((315,354), (433,354)) 1 15 1650887306 1650906328 ((-333943,50301), (-172753,-51317)) 4130 0 16711680 16744576 12632256 新宋体,8,N 1 {\rtf1\ansi\ansicpg936\deff0\nouicompat\deflang1033\deflangfe2052{\fonttbl{\f0\froman\fcharset134 \'ce\'a2\'c8\'ed\'d1\'c5\'ba\'da;}{\f1\fnil\fcharset0 Microsoft Sans Serif;}} {\*\generator Riched20 10.0.19041}\viewkind4\uc1 \pard\qc\f0\fs128\lang2052\'ca\'c2\'bc\'fe\'d6\'d0\'d0\'c4\f1\fs20\par } 1650887375 1650906328 ((-287820,52021), (-217688,71189)) 4130 0 0 7 0 12632256 新宋体,8,N 1 1650887722 1650906328 ((-111440,50623), (325286,-233657)) 4130 0 16711680 12615808 12632256 新宋体,8,N 1 1650887219 1650906328 ((-292392,14443), (-285819,14893)) ((-285819,14668),(-292392,14668)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-2608,4449), (1288,4899)) ((1288,4674),(-2608,4674)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-19896,3914), (-15070,4364)) ((-15070,4139),(-19896,4139)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-38024,4095), (-32358,4545)) ((-32358,4320),(-38024,4320)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-299449,-9876), (-298449,9401)) ((-298949,-9876),(-298949,9401)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-289937,-18256), (-281969,-17806)) ((-281969,-18031),(-289937,-18031)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-73736,-131623), (-66537,-131173)) ((-66537,-131398),(-73736,-131398)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((176837,-140118), (189405,-139668)) ((189405,-139893),(176837,-139893)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((177317,-168114), (190068,-167664)) ((190068,-167889),(177317,-167889)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((4956,-22395), (12023,-21945)) ((12023,-22365),(8353,-22365),(8353,-21975),(4956,-21975)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((4956,-42796), (13256,-36849)) ((13256,-36849),(13256,-42796),(4956,-42796)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-1736,-54322), (14144,-50963)) ((14144,-54322),(-1736,-54322),(-1736,-50963)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-3475,-58446), (-2475,-50963)) ((-2975,-58446),(-2975,-50963)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-21976,-22342), (-10596,-21892)) ((-21976,-22322),(-16422,-22322),(-16422,-21913),(-10596,-21913)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-22763,-47534), (-10596,-40144)) ((-22763,-40144),(-16816,-40144),(-16816,-47534),(-10596,-47534)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-21937,-59009), (-10596,-34922)) ((-21937,-59009),(-15950,-59009),(-15950,-34922),(-10596,-34922)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-53471,-52677), (-10596,-33339)) ((-53471,-52677),(-53471,-33339),(-10596,-33339)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-76189,-168605), (-68232,-168155)) ((-68232,-168380),(-76189,-168380)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((4956,-20890), (9836,-10475)) ((4956,-20890),(9836,-20890),(9836,-10475)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-25327,-134579), (-16320,-134129)) ((-16320,-134354),(-25327,-134354)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 1650887219 1650906328 ((-8789,-147840), (-7789,-140756)) ((-8289,-147840),(-8289,-140756)) 1 1 12615680 12632256 CENTER 0 新宋体,8,N SOURCE 0 新宋体,8,N DESTINATION 0 新宋体,8,N 事件模块 1650887219 1650906328 ((-266423,29273), (-229899,36265)) 4130 0 0 7 0 12632256 新宋体,64,N 1 事件分类信息表 1650887219 1650906328 ((-311103,19584), (-288828,25432)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 ((-97344,-102095), (6680,-186995)) 4130 0 16711680 8454016 12632256 新宋体,8,N 1 1650887219 1650906328 ((82748,40253), (187447,-27321)) 4130 0 16711680 8454143 12632256 新宋体,8,N 1650887219 1650906328 ((-100109,43464), (47971,-72805)) 4130 0 16711680 8421631 12632256 新宋体,8,N 1 1650887219 1650906328 ((87942,-102724), (220632,-224380)) 4130 0 16711680 4227327 12632256 新宋体,8,N 1 1650887219 1650906328 -1 ((-97951,-53783), (-76219,-20185)) 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 1650887219 1650906328 -1 ((-305489,-25324), (-289937,-9876)) 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 1650887219 1650906328 -1 ((-305626,9401), (-292392,19899)) 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 1650887219 1650906328 -1 ((-285819,9851), (-268723,20349)) 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 1650887219 1650906328 -1 ((-52030,-2039), (-38024,10935)) 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 1650887219 1650906328 -1 ((-32358,-4350), (-19896,12434)) 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 1650887219 1650906328 -1 ((-15070,-3050), (-2608,12398)) 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 1650887219 1650906328 -1 ((1288,-10475), (18384,19823)) 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 1650887219 1650906328 -1 ((-67303,-42348), (-54275,-18650)) 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 1650887219 1650906328 -1 ((-281969,-24477), (-266805,-11679)) 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 1650887219 1650906328 -1 ((-224329,-20918), (-209165,-12894)) 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 1650887219 1650906328 -1 ((-254274,-18423), (-237950,-12875)) 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 1650887219 1650906328 -1 ((-223669,9827), (-208505,18675)) 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 1650887219 1650906328 -1 ((-252738,12059), (-238732,16059)) 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 事件联动部门信息表 1650887219 1650906328 ((-288752,19883), (-264303,25731)) 4130 0 0 7 0 12632256 新宋体,26,N 1 节假日信息表 1650887219 1650906328 ((-257442,20478), (-232993,26326)) 4130 0 0 7 0 12632256 新宋体,26,N 1 事件信息表 1650887219 1650906328 ((-311665,-8962), (-287216,-3114)) 4130 0 0 7 0 12632256 新宋体,26,N 1 事件处置信息表 1650887219 1650906328 ((-287515,-9187), (-263066,-3339)) 4130 0 0 7 0 12632256 新宋体,26,N 1 事件绩效考核规则表 1650887219 1650906328 ((-258062,-9189), (-233613,-3341)) 4130 0 0 7 0 12632256 新宋体,26,N 1 事件绩效考核日志表 1650887219 1650906328 ((-227499,20917), (-203050,26765)) 4130 0 0 7 0 12632256 新宋体,26,N 1 事件日志信息表 1650887219 1650906328 ((-228274,-8942), (-203825,-3094)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((-10596,-50963), (4956,-15715)) 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 人房户模块 1650887219 1650906328 ((-50650,31562), (-14126,38554)) 4130 0 0 7 0 12632256 新宋体,64,N 1 小区信息表 1650887219 1650906328 ((-59759,19165), (-35310,25013)) 4130 0 0 7 0 12632256 新宋体,26,N 1 楼栋信息表 1650887219 1650906328 ((-38978,18530), (-14529,24378)) 4130 0 0 7 0 12632256 新宋体,26,N 1 单元信息表 1650887219 1650906328 ((-21464,18802), (2985,24650)) 4130 0 0 7 0 12632256 新宋体,26,N 1 楼层房间信息表 1650887219 1650906328 ((-1328,19000), (23121,24848)) 4130 0 0 7 0 12632256 新宋体,26,N 1 企业信息表 1650887219 1650906328 ((-101355,-17284), (-76906,-11436)) 4130 0 0 7 0 12632256 新宋体,26,N 1 社会组织信息表 1650887219 1650906328 ((-72950,-16921), (-48501,-11073)) 4130 0 0 7 0 12632256 新宋体,26,N 1 人口信息表 1650887219 1650906328 ((-15326,-15698), (9123,-9850)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((153226,2780), (166460,13278)) 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 1650887219 1650906328 -1 ((111162,3026), (124396,12700)) 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 1650887219 1650906328 -1 ((-88514,-136179), (-73736,-126505)) 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 1650887219 1650906328 -1 ((-66537,-136835), (-51759,-125307)) 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 1650887219 1650906328 -1 ((-39951,-143000), (-25327,-125708)) 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 1650887219 1650906328 -1 ((-91353,-173881), (-76189,-162557)) 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 1650887219 1650906328 -1 ((-68232,-175499), (-51908,-162671)) 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 1650887219 1650906328 -1 ((-35764,-181356), (-20986,-162608)) 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 网格任务模块 1650887219 1650906328 ((-64974,-113683), (-28450,-106691)) 4130 0 0 7 0 12632256 新宋体,64,N 1 任务核查信息表 1650887219 1650906328 ((-93176,-123453), (-68727,-117605)) 4130 0 0 7 0 12632256 新宋体,26,N 1 任务核查信息反馈表 1650887219 1650906328 ((-71072,-122850), (-46623,-117002)) 4130 0 0 7 0 12632256 新宋体,26,N 1 网格员巡查轨迹-人员信息表 1650887219 1650906328 ((-40869,-122312), (-21447,-116464)) 4130 0 0 7 0 12632256 新宋体,26,N 1 任务下派信息表 1650887219 1650906328 ((-95350,-158724), (-70901,-152876)) 4130 0 0 7 0 12632256 新宋体,26,N 1 任务下派完成情况表 1650887219 1650906328 ((-71555,-158603), (-47106,-152755)) 4130 0 0 7 0 12632256 新宋体,26,N 1 民情诉求信息表 1650887219 1650906328 ((-41755,-158302), (-17306,-152454)) 4130 0 0 7 0 12632256 新宋体,26,N 1 知识库系统 1650887219 1650906328 ((147762,15647), (172211,21495)) 4130 0 0 7 0 12632256 新宋体,26,N 1 备忘录 1650887219 1650906328 ((104813,15825), (129262,21673)) 4130 0 0 7 0 12632256 新宋体,26,N 1 日常办公及辅助模块 1650887219 1650906328 ((104193,26666), (169361,33658)) 4130 0 0 7 0 12632256 新宋体,64,N 1 1650887219 1650906328 -1 ((99180,-154887), (113186,-131409)) 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 1650887219 1650906328 -1 ((127141,-161974), (146169,-131110)) 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 1650887219 1650906328 -1 ((97362,-182575), (112140,-171253)) 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 1650887219 1650906328 -1 ((125406,-208009), (140184,-196687)) 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 1650887219 1650906328 -1 ((97453,-207553), (112231,-196231)) 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 1650887219 1650906328 -1 ((161285,-148634), (176837,-131092)) 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 1650887219 1650906328 -1 ((189405,-146605), (205343,-132287)) 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 1650887219 1650906328 -1 ((162153,-175837), (177317,-159643)) 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 1650887219 1650906328 -1 ((190068,-173387), (206392,-160795)) 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 党群服务模块 1650887219 1650906328 ((122639,-115932), (180595,-108940)) 4130 0 0 7 0 12632256 新宋体,64,N 1 党员信息表 1650887219 1650906328 ((94311,-126649), (118760,-120801)) 4130 0 0 7 0 12632256 新宋体,26,N 1 基层干部信息表 1650887219 1650906328 ((124335,-126860), (148784,-121012)) 4130 0 0 7 0 12632256 新宋体,26,N 1 党组织活动信息表 1650887219 1650906328 ((156278,-127042), (180727,-121194)) 4130 0 0 7 0 12632256 新宋体,26,N 1 活动评审信息表 1650887219 1650906328 ((184023,-127495), (208472,-121647)) 4130 0 0 7 0 12632256 新宋体,26,N 1 工作布置完成情况信息表 1650887219 1650906328 ((184386,-157486), (212723,-151638)) 4130 0 0 7 0 12632256 新宋体,26,N 1 工作布置信息表 1650887219 1650906328 ((156435,-157667), (180884,-151819)) 4130 0 0 7 0 12632256 新宋体,26,N 1 党建资讯 1650887219 1650906328 ((120408,-195309), (144857,-189461)) 4130 0 0 7 0 12632256 新宋体,26,N 1 党规党章信息表 1650887219 1650906328 ((93023,-169265), (117472,-163417)) 4130 0 0 7 0 12632256 新宋体,26,N 1 活动宣传信息表 1650887219 1650906328 ((93114,-195133), (117563,-189285)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((12023,-25642), (29891,-18444)) 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 人口-残联信息 1650887219 1650906328 ((8019,-16491), (32468,-10643)) 4130 0 0 7 0 12632256 新宋体,26,N 1 人口-军人信息 1650887219 1650906328 ((8994,-34716), (33443,-28868)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((13256,-39891), (28808,-34343)) 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 人口-新冠疫苗信息 1650887219 1650906328 ((8447,-47554), (32896,-41706)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((14144,-60568), (28922,-47594)) 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 人口-低保信息信息 1650887219 1650906328 ((-15629,-57781), (8820,-51933)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((-10519,-68944), (3488,-58446)) 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 1650887219 1650906328 -1 ((-37528,-26422), (-21976,-17574)) 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 人口-老龄人口信息表 1650887219 1650906328 ((-43249,-16897), (-18800,-11049)) 4130 0 0 7 0 12632256 新宋体,26,N 1 人口-计生特殊扶助信息表 1650887219 1650906328 ((-45387,-33793), (-15388,-27945)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((-38315,-47032), (-22763,-34058)) 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 人口-保险信息表 1650887219 1650906328 ((-46549,-53743), (-16550,-47895)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((-39034,-65496), (-21937,-52522)) 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 人口-流动人口信息 1650887219 1650906328 ((-68670,-53698), (-44221,-47850)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((-65288,-59051), (-50896,-52677)) 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 1650887219 1650906328 -1 ((162893,-216806), (177285,-192282)) 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 人才信息表 1650887219 1650906328 ((157716,-191467), (182165,-185619)) 4130 0 0 7 0 12632256 新宋体,26,N 1 党群通知公告表 1650887219 1650906328 ((186981,-191467), (211430,-185619)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((192487,-205004), (207651,-192030)) 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 1650887219 1650906328 -1 ((29921,-6622), (42767,-2623)) 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 人口与特殊人员属性关系映射表 1650887219 1650906328 ((22584,1679), (47033,7527)) 4130 0 0 7 0 12632256 新宋体,26,N 1 网格员巡查轨迹-巡查日期表 1650887219 1650906328 ((-18596,-121401), (5853,-115553)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((-16320,-140756), (-258,-125928)) 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 网格员巡查轨迹-巡查记录表 1650887219 1650906328 ((-20546,-147447), (3903,-141599)) 4130 0 0 7 0 12632256 新宋体,26,N 1 1650887219 1650906328 -1 ((-16554,-161684), (480,-147840)) 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 {\rtf1\ansi\ansicpg936\deff0\nouicompat\deflang1033\deflangfe2052{\fonttbl{\f0\froman\fcharset134 \'ce\'a2\'c8\'ed\'d1\'c5\'ba\'da;}{\f1\fnil\fcharset0 Microsoft Sans Serif;}} {\*\generator Riched20 10.0.19041}\viewkind4\uc1 \pard\qc\f0\fs128\lang2052\'ca\'fd\'be\'dd\'d6\'d0\'d0\'c4\f1\fs20\par } 1650887728 1650906328 ((76305,57569), (146437,76737)) 4130 0 0 7 0 12632256 新宋体,8,N 1 A8399A71-B93D-4C0E-AE83-4C98CBE9BEFA 企业信息表 zhsq_qiye 1650887219 Administrator 1650887219 Administrator 企业信息表 92F67E7D-C935-404B-BEC0-87F93A6C4FC1 企业信息主键 id 1650887219 Administrator 1652321752 Administrator 企业信息主键 varchar(32) 32 1 B810BBEE-FCC3-4702-9606-476E152ECBCC 企业名称 qy_name 1650887219 Administrator 1650887219 Administrator 企业名称 varchar(100) 100 108DD38E-44CD-46F7-ADC2-506F8839EA7A 统一社会信用代码 qy_code 1650887219 Administrator 1650887219 Administrator 统一社会信用代码 varchar(100) 100 99EFE3A5-9867-4722-B7BC-E3113F58A051 企业类别 qy_leibie 1650887219 Administrator 1650887219 Administrator 企业类别：数据字典企业、个体工商户、社会组织、宗教组织、文化机构、公共场所、餐饮服务单位、福利企业单位、公共卫生单位、教育机构 varchar(10) 10 768432B1-107D-403B-961E-1CF7FC4E03ED 地址 qy_address 1650887219 Administrator 1650887219 Administrator 地址 varchar(100) 100 7411C6AD-59D7-4D68-A253-3B5D77D50926 主要业务 qy_yewu 1650887219 Administrator 1650887219 Administrator 主要业务 varchar(1000) 1000 4AD5327B-5149-4A39-9145-16004922585D 法人姓名 qy_fr_name 1650887219 Administrator 1650887219 Administrator 法人姓名 varchar(100) 100 10862884-11EB-49D3-927E-CA34D74E1DAF 法人电话 qy_fr_tel 1650887219 Administrator 1650887219 Administrator 法人电话 varchar(100) 100 F6E96391-6D7C-41F2-8F44-DB600D981FA2 联系人姓名 qy_lxr_name 1650887219 Administrator 1650887219 Administrator 联系人姓名 varchar(100) 100 5279295A-00F4-4A82-B212-324F180CEE6A 联系人电话 qy_lxr_tel 1650887219 Administrator 1650887219 Administrator 联系人电话 varchar(100) 100 3FFA592A-8703-4ACC-8FCA-78DE16AD10B9 企业规模 qy_guimo 1650887219 Administrator 1650887219 Administrator 企业规模，数据字典大型中型小型微型 varchar(100) 100 EB915C90-2892-4607-A604-D549F11F30E5 企业面积 qy_mianji 1650887219 Administrator 1650887219 Administrator 企业面积 varchar(100) 100 2929C811-9A09-4C3D-92A5-44C0859E1134 建企时间 qy_shijian 1650887219 Administrator 1650887219 Administrator 建企时间 varchar(100) 100 8C0B2249-F5CA-4EAE-8D63-E5C84B96501A 职工人数 qy_renshu 1650887219 Administrator 1650887219 Administrator 职工人数 varchar(10) 10 816F6BAB-DB34-481A-A50E-150104DACF41 行业类别（大类） qy_type_one 1650887219 Administrator 1650887219 Administrator 行业类别（大类） varchar(100) 100 3B67F675-57D2-430B-9476-9C4496D9CF96 行业类别（中类） qy_type_two 1650887219 Administrator 1650887219 Administrator 行业类别（中类） varchar(100) 100 965D5737-6316-4224-9970-DF89E66DD0BE 登记注册类型 qy_type 1650887219 Administrator 1650887219 Administrator 登记注册类型,数据字典内资企业国有企业集体企业股份合作企业联营企业国有联营企业集体联营企业国有与集体联营企业其他联营企业有限责任公司国有独资企业其他有限责任公司股份有限公司私营企业私营独资企业私营合伙企业私营有限责任公司私营股份有限公司其他企业港、澳、台商投资企业合资经营企业（港或澳、台投资）合作经营企业（港或澳、台投资）港、澳、台商独资经营企业港、澳、台商投资股份有限公司其他港、澳、台商投资企业外商投资企业中外合资经营企业中外合作经营企业外资企业外商投资股份有限公司其他外商投资企业 varchar(10) 10 381F7B8F-9C24-42E3-A40C-8CF5DD760E06 年运行天数 qy_days 1650887219 Administrator 1650887219 Administrator 年运行天数 varchar(10) 10 63E18505-AED2-497E-8F18-D021DD09614B 近3年是否发生过环境突发事件 qy_tfsj 1650887219 Administrator 1650887219 Administrator 近3年是否发生过环境突发事件 varchar(100) 100 D49E4971-4488-4806-A908-50F4719C6C79 近1年是否收到生态环境部门的行政处罚 qy_xzcf 1650887219 Administrator 1650887219 Administrator 近1年是否收到生态环境部门的行政处罚 varchar(100) 100 03CFEC1D-43E2-4638-B4C5-A447B3BE1989 所在街道ID jd_id 1650887219 Administrator 1652321752 Administrator 所在街道ID varchar(32) 32 F765D6EB-6174-4F14-A91A-12F300F73238 所在街道名称 jd_name 1650887219 Administrator 1650887219 Administrator 所在街道名称 varchar(100) 100 88669F34-208F-4A77-865B-6C16963A6B25 所在社区ID sq_id 1650887219 Administrator 1652321752 Administrator 所在社区ID varchar(32) 32 63B5730B-7437-426F-94BE-75C63061826E 所在社区名称 sq_name 1650887219 Administrator 1650887219 Administrator 所在社区名称 varchar(100) 100 8BF5ECD7-44F4-452A-AE42-51617B55EB56 所在网格ID wg_id 1650887219 Administrator 1652321752 Administrator 所在网格ID varchar(32) 32 16666EF6-0E8C-4CB8-9FCA-412078029C5F 所在网格名称 wg_name 1650887219 Administrator 1650887219 Administrator 所在网格名称 varchar(100) 100 C8EED77B-1536-428E-A3FE-DFE2951F243F 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 3B9F5584-1ADB-4B7F-86CA-F49390357C27 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint DDDEB14F-528B-48A5-A733-64B737EB6A39 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 35985B40-1925-4ACA-A3F3-D729F7E7E6AC 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 376B4852-ECF5-40B7-AD42-1F0A18B2C87D 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 79948DD8-4583-44B0-803A-962FDC746DEE 所在小区ID xq_id 1650887219 Administrator 1652321752 Administrator 所在小区ID varchar(32) 32 3273D407-D060-4FBE-83D6-F497C38BAE77 所在小区名称 xq_name 1650887219 Administrator 1650887219 Administrator 所在小区名称 varchar(100) 100 55A8EE37-C183-4BB6-8343-59E848A2645C 所在楼栋ID ld_id 1650887219 Administrator 1652321752 Administrator 所在楼栋ID varchar(32) 32 4E9BC54A-3B7F-4E78-8CF9-8A638F25A8CC 所在楼栋名称 ld_name 1650887219 Administrator 1650887219 Administrator 所在楼栋名称 varchar(100) 100 D045A3F6-B0A8-404F-87A9-1FFC5585AD31 所在单元ID dy_id 1650887219 Administrator 1652321752 Administrator 所在单元ID varchar(32) 32 7958CDC6-A080-4924-BB6D-563A08F136E4 所在单元名称 dy_name 1650887219 Administrator 1650887219 Administrator 所在单元名称 varchar(100) 100 9DB433EB-95D7-466A-92D8-72CD9181C7AE 所在房间ID fj_id 1650887219 Administrator 1652321752 Administrator 所在房间ID varchar(32) 32 BE6E7C11-F88B-4BEE-9EB7-41F66AFC9B8F 所在房间名称 fj_name 1650887219 Administrator 1650887219 Administrator 所在房间名称 varchar(100) 100 B025DB57-1311-4199-884F-DBB0E09DFDDA Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 1C235D48-B14E-4564-8330-D9E527ECD3E3 事件信息表 zhsq_event 1650887219 Administrator 1651903138 Administrator 事件信息表 9106CA63-244A-4240-A65F-7209536104B9 事件主键ID event_id 1650887219 Administrator 1651903138 Administrator 事件主键ID bigint 1 D373D64D-E0C8-4112-B9F1-C2E7FDDC9FEB 事件分类主键ID event_type_id 1650887219 Administrator 1651903138 Administrator 事件分类主键ID bigint BB3F63E2-9DE2-4187-9FE3-CE01117FEBAC 事件标题 event_title 1650887219 Administrator 1651903138 Administrator 事件标题 varchar(100) 100 44099C78-48E3-4D5D-8849-6C96FD7C994F 事件内容 event_content 1650887219 Administrator 1651903138 Administrator 事件内容 varchar(1000) 1000 9D914FC3-C57D-4064-BE03-DFCAB6EE67B3 事件来源 event_laliyuan 1650887219 Administrator 1651903138 Administrator 事件来源 varchar(100) 100 9D6FB81D-341A-4C97-8E8D-C579D1464A23 事件照片 event_file 1650887219 Administrator 1651903138 Administrator 事件照片 longtext B56E36A2-CE0E-41EA-873E-5189E0026857 事件位置（GIS定位） event_position 1650887219 Administrator 1651903138 Administrator 事件位置（GIS定位） varchar(100) 100 E12EFC94-A4CA-4424-B93A-FF46A8BCF382 上报人ID event_sbr_id 1650887219 Administrator 1651903138 Administrator 上报人ID bigint D4E5A1EE-9F71-41F1-A7DF-A69B9A821BC4 上报人姓名 event_sbr_name 1650887219 Administrator 1651903138 Administrator 上报人姓名 varchar(100) 100 28A88329-D7E5-4891-AF32-CB6522F9BACE 上报时间 event_sbsj 1650887219 Administrator 1651903138 Administrator 上报时间 varchar(100) 100 B592D728-6C8A-4668-99FF-55602DE23C6D 事件状态 event_state 1650887219 Administrator 1651903138 Administrator 事件状态,数据字典： 1：新建 2：上报，待签收 3：拒签 4：街道指挥中心待分发 5：区级指挥中心待分发 6：签收超时 7：签收（未处置） 8：正在处置 9：重新处置（核查结果不满意） 10：处置完成（待核查） 11:核查完毕并归档（结果满意） varchar(5) 5 B915253B-49B0-4BDC-820D-F049A8A51EE9 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 6EE63B7E-84F4-425F-A7E0-84923AB8CF19 核查人ID event_hcr 1650887219 Administrator 1651903138 Administrator 核查人ID bigint 1B320A93-C6C6-4272-A5D5-EEF3F47EFBF1 核查意见 event_hcyj 1650887219 Administrator 1651903138 Administrator 核查意见 varchar(1000) 1000 F92D17E2-6BA9-4FE9-9A6D-BAA0A892F13B 核查时间 event_hcsj 1650887219 Administrator 1651903138 Administrator 核查时间 varchar(100) 100 F4C41AEA-35DB-40E0-9A5D-C961205E0F52 上报人所在部门ID event_sbr_dept_id 1650887219 Administrator 1651903138 Administrator 上报人ID bigint 2C996074-2EDD-47EC-AEEA-7D4F5DB470AF 上报人所在部门名称 event_sbr_dept_name 1650887219 Administrator 1651903138 Administrator 上报人姓名 varchar(100) 100 EFB09428-7A5E-4863-9E15-4B5F9C9A1403 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator E915ADDC-E9C7-4660-A34C-E5C6E13315A4 事件分类信息表 zhsq_event_type 1650887219 Administrator 1651476854 Administrator 事件分类信息表 61B61ACA-B216-47A8-ACDF-3F86013CB78D 事件分类主键ID event_type_id 1650887219 Administrator 1651476879 Administrator 事件类型一类主键ID bigint 1 61C05748-8F36-49AA-8842-1C35014DEFFB 事件分类名称 event_type_name 1650887219 Administrator 1651476879 Administrator 事件分类名称 varchar(100) 100 759A82AF-5745-4A56-8E99-E5587618B334 事件分类类型 event_type_type 1650887219 Administrator 1651476879 Administrator 事件分类类型：一类二类三类 int AA079DC1-2BB8-40D6-810E-F73DD52BBE0F 上级分类ID event_type_parent_id 1650887219 Administrator 1651476879 Administrator bigint F724974E-13B9-437D-98F0-F593555203EE 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int DE7E3B80-76F0-45A6-ADCC-F4155B4FC4CA 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint EBDFC7C3-8994-4892-BD57-F337CA522FA4 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 E1BF8C8A-295E-4B7D-969B-FACE0241E140 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 E6242BDC-32FF-4E0F-A957-EC552172D55F 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint EEE49C7F-F020-41E7-B50F-FDC32587EB38 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 55579D8D-931B-4356-ABB1-CA694FC23084 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 876FA2B7-4369-45B7-95FC-2255E9C25BB8 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator B25F6A19-1432-41A3-A1B5-B76D70FAEEE1 事件联动部门信息表 zhsq_sj_dept_mapping 1650887219 Administrator 1650887219 Administrator 事件联动部门信息表 4F5C3B68-F6AB-4C21-85EA-216832761EFA 事件与部门联动信息主键ID sj_dept_id 1650887219 Administrator 1650887219 Administrator 事件与部门联动信息主键ID bigint 1 7E6F28D3-740A-4BFC-8CB5-5BBD98F23272 事件类型ID sj_type_id 1650887219 Administrator 1650887219 Administrator 事件类型ID bigint F0154A06-2926-4D20-97E4-6B922725FDDE 关联部门ID dept_id 1650887219 Administrator 1650887219 Administrator 关联部门ID bigint 6F2EC1A1-5EDF-449B-BA51-E42102BA7905 关联部门名称 dept_name 1650887219 Administrator 1650887219 Administrator varchar(100) 100 14AAA677-FE85-4F73-9F60-8D73AFC43BE0 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int DF8482E8-91BF-402E-AA1D-9350F435F854 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 4E66AB76-6B8F-48F2-9204-472E6F8BC7CF 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 A7B602EC-10F8-4818-9E88-35E45FAB1E8C 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 1A07E53C-8FD7-4FB5-A345-30CEA52D5880 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 163AEF70-E113-42F4-ADE6-1BB13243E639 数据更新人ID update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 916F0FAC-7AB6-4BBE-A245-7DBC7CBA9EEA 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 FEC323D2-A5E7-452A-8ABC-22633BF0968E Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 0FEF06C4-610C-4E82-84C2-02C5F24D618B 小区信息表 zhsq_xiaoqu 1650887219 Administrator 1650887219 Administrator 小区信息表 C0A08D57-A8F5-4628-B481-81BBFEA32E1B 小区信息表主键ID id 1650887219 Administrator 1651892385 Administrator 小区信息表主键ID varchar(32) 32 1 4AC3B503-7F02-403D-95CE-57CA012C262A 小区名称 xq_name 1650887219 Administrator 1650887219 Administrator 小区名称 varchar(100) 100 FAA9ECD8-FFBC-4B03-9109-E877B0040C54 小区位置 xq_address 1650887219 Administrator 1650887219 Administrator 小区位置，可存储坐标 varchar(100) 100 5010A874-1699-4833-A3CA-6139707F3B53 小区所在街道ID jd_id 1650887219 Administrator 1652321224 Administrator 小区所在街道ID varchar(32) 32 FE62745F-2B14-47BA-8700-244D70FC771E 小区所在街道名称 jd_name 1650887219 Administrator 1650887219 Administrator 小区所在街道名称 varchar(100) 100 0F9786F9-3E39-4D51-A22F-16677A124E49 小区所在社区ID sq_id 1650887219 Administrator 1652321224 Administrator 小区所在社区ID varchar(32) 32 D5693DF9-E64E-4398-9E27-ABB5AEC94671 小区所在社区名称 sq_name 1650887219 Administrator 1650887219 Administrator 小区所在社区名称 varchar(100) 100 EECC0871-5033-42D6-B376-53EEC885CB48 小区所在网格ID wg_id 1650887219 Administrator 1652321224 Administrator 小区所在网格ID varchar(32) 32 0493123E-A0F4-449F-AE4D-B6756242F6E9 小区所在网格名称 wg_name 1650887219 Administrator 1650887219 Administrator 小区所在网格名称 varchar(100) 100 386809D0-10C2-480F-B403-F8226966F23D 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 7FBDF278-6E13-42B8-8D0A-C6018D13B31B 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 4375931D-6635-4D01-BC78-A197BD480037 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 19ED7349-0F1F-43B8-824B-4F06C6CFD524 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint D4D287EF-BF05-4B49-B6DA-6C18D64EFDF5 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 751C8B37-2DDD-4220-8B11-0F8E2A26503F Key_1 Key_1 1650887219 Administrator 1650887219 Administrator F2B15E88-0DAC-430E-92E8-F510D5B36E39 楼栋信息表 zhsq_loudong 1650887219 Administrator 1650904950 Administrator 楼栋信息表 F8FD133F-377A-4EEC-89A8-9C54D488BD1A 楼栋主键ID id 1650887219 Administrator 1651892396 Administrator 楼栋主键ID varchar(32) 32 1 57302756-C2D1-4767-95F9-C4E7A6D01F8B 楼栋名称 ld_name 1650887219 Administrator 1650887219 Administrator 楼栋名称 varchar(100) 100 D3D55268-78F7-42AF-9AFE-985F85471A24 小区主键ID xq_id 1650887219 Administrator 1651892410 Administrator 小区信息表主键ID varchar(32) 32 9CA0BF42-87B5-4C52-9EDE-E9A4193ACBD8 小区名称 xq_name 1650904799 Administrator 1650904836 Administrator varchar(100) 100 A58A0AA4-6B97-40C5-AB4A-4EE83092C893 楼栋位置 ld_address 1650887219 Administrator 1650887219 Administrator 楼栋位置,可存储坐标 varchar(100) 100 0F90F932-BB96-4AD5-BEB7-3AB045FB4E6E 所在街道ID jd_id 1650887219 Administrator 1652321240 Administrator 所在街道ID varchar(32) 32 4E745483-4EC5-43CF-A149-E1D3EAA3DD49 所在街道名称 jd_name 1650887219 Administrator 1650887219 Administrator 所在街道名称 varchar(100) 100 40C8760D-3E98-4440-9A05-90100DB7D765 所在社区ID sq_id 1650887219 Administrator 1652321240 Administrator 所在社区ID varchar(32) 32 C29FE5B9-E1CD-49AC-B8E6-E44EAFFC51C9 所在社区名称 sq_name 1650887219 Administrator 1650887219 Administrator 所在社区名称 varchar(100) 100 C7A375DE-1152-45A6-9DB3-DA3F3CE47BD1 所在网格ID wg_id 1650887219 Administrator 1652321240 Administrator 所在网格ID varchar(32) 32 8E6DEFAA-33F6-4920-8EF3-CC608927E210 所在网格名称 wg_name 1650887219 Administrator 1650887219 Administrator 所在网格名称 varchar(100) 100 DCE384A8-F75F-4FC0-9D1E-C15D4703DF0A 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 1213B837-39C6-402B-805C-CA03A9292008 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint D090550B-7B42-4062-9E7C-A56C407E45EC 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 8C01240C-7053-4BFB-A670-9D402DA95BBE 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint FA9CFA66-ED5F-4CB0-802C-EA6816EB9430 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 9566EE6F-93FE-444A-A4D9-B01867696AEC 建筑物ID building_id 1650887219 Administrator 1650887219 Administrator 地图建筑ID varchar(100) 100 5DD45331-2DF2-46AD-B963-447289A6634A 数据集名称 dataset_name 1650887219 Administrator 1650887219 Administrator 数据集名称 varchar(100) 100 CEB820BC-C693-40A7-94CF-2BC7C9EB8DA7 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator EEBCA08E-E288-433F-975C-0F5B3BA04CC9 单元信息表 zhsq_danyuan 1650887219 Administrator 1650904938 Administrator 单元信息表 1D25ADB0-82D9-406D-9557-9F99F6B4FEEB 单元主键ID id 1650887219 Administrator 1651892427 Administrator 单元主键ID varchar(32) 32 1 AEBEEE2A-5391-41A9-9C23-480A15F38095 单元名称 dy_name 1650887219 Administrator 1650887219 Administrator 单元名称 varchar(100) 100 7246D77E-2DD2-4697-AD85-2468E487667E 楼栋主键ID ld_id 1650887219 Administrator 1651892427 Administrator 楼栋主键ID varchar(32) 32 52420AF9-2CB7-4E3B-9329-944350399398 楼栋名称 ld_name 1650904861 Administrator 1650904891 Administrator varchar(100) 100 274A2BC8-3924-44E5-B886-43B1AD777249 小区主键ID xq_id 1650904891 Administrator 1652321267 Administrator varchar(32) 32 FA396E1D-214B-4C72-82C1-F5A5EF1A63E1 小区名称 xq_name 1650904891 Administrator 1650904929 Administrator varchar(100) 100 AE497ECE-9325-40F0-B73C-8C5F4B6387E6 所在街道ID jd_id 1650887219 Administrator 1652321267 Administrator 所在街道ID varchar(32) 32 22691C32-E097-43C9-B429-E0F8BF493CBC 所在街道名称 jd_name 1650887219 Administrator 1650887219 Administrator 所在街道名称 varchar(100) 100 62990AD8-202E-4ECB-93A8-32082C5128E0 所在社区ID sq_id 1650887219 Administrator 1652321267 Administrator 所在社区ID varchar(32) 32 D2E8C45D-1B28-45BF-91D1-AACB164787E2 所在社区名称 sq_name 1650887219 Administrator 1650887219 Administrator 所在社区名称 varchar(100) 100 E65D05D0-946C-4607-B680-6C5A055EC095 所在网格ID wg_id 1650887219 Administrator 1652321267 Administrator 所在网格ID varchar(32) 32 D9A736DF-CC78-45D4-A1AF-752BF72AA5B9 所在网格名称 wg_name 1650887219 Administrator 1650887219 Administrator 所在网格名称 varchar(100) 100 8FF92225-AFF9-4628-98BE-E29E16806B30 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int FB7E9003-B3DF-4FD1-B203-EB871DFB6517 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 054B6D66-3F42-400B-8668-EA4C8B982626 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 DC45BBB2-64A4-4921-AF30-3B212295BDD9 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint C3914AAC-FBD9-4573-8DE5-BCBFA042998F 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 05E7C3A1-51B3-4A8F-9305-1FC7B3C27A52 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator A2DA14D0-8D19-482F-A6FD-04A38C4F18B5 楼层房间信息表 zhsq_fangjian 1650887219 Administrator 1650905008 Administrator 楼层房间信息表 08D55E37-17D0-4205-9114-1B2D9CB35DEC 楼层房间主键ID id 1650887219 Administrator 1651892448 Administrator 楼层房间主键ID varchar(32) 32 1 6AE5D999-08F7-4859-B7B9-C4255ADA5859 房间名称 fj_name 1650887219 Administrator 1650887219 Administrator 房间名称 varchar(100) 100 0DABD8F3-99D8-4499-825B-9509E8E6A7A0 单元主键ID dy_id 1650887219 Administrator 1651892448 Administrator 单元主键ID varchar(32) 32 9923770D-49D0-4293-A1B0-4FD41C66EF9D 单元名称 dy_name 1650904967 Administrator 1650905008 Administrator varchar(100) 100 C6CA9396-0ED2-4695-B9FE-96FB7B018335 楼栋主键ID ld_id 1650904967 Administrator 1652321317 Administrator varchar(32) 32 0980090D-69EE-43F0-AD3D-88403AFDDF4D 楼栋名称 ld_name 1650904967 Administrator 1650905050 Administrator varchar(100) 100 D47C70EE-4163-4B37-80CA-BDE82CC695D4 小区主键ID xq_id 1650904967 Administrator 1652321317 Administrator varchar(32) 32 E9373353-F977-4ECF-9467-F27A455CACB6 小区名称 xq_name 1650904967 Administrator 1650905088 Administrator varchar(100) 100 C51653A9-A503-45CB-8980-2085C86E6230 所在楼层 fj_lc 1650887219 Administrator 1650887219 Administrator 所在楼层 varchar(5) 5 C8F769A5-02BA-45E3-BCC4-978E6B929288 所在街道ID jd_id 1650887219 Administrator 1652321317 Administrator 小区所在街道ID varchar(32) 32 96B97ECD-D039-40CA-B116-95F1FAAC8A53 所在街道名称 jd_name 1650887219 Administrator 1650887219 Administrator 小区所在街道名称 varchar(100) 100 C5177C28-C004-4DD8-A4F0-A18549191C3C 所在社区ID sq_id 1650887219 Administrator 1652321317 Administrator 小区所在社区ID varchar(32) 32 CAE73F93-F75B-4B8E-8114-2C78E30F9C3E 所在社区名称 sq_name 1650887219 Administrator 1650887219 Administrator 小区所在社区名称 varchar(100) 100 4C83F3C2-8DAE-41AA-8121-40E1B856021D 所在网格ID wg_id 1650887219 Administrator 1652321317 Administrator 小区所在网格ID varchar(32) 32 74B90463-6DC7-4D0C-917B-1E920B520D42 所在网格名称 wg_name 1650887219 Administrator 1650887219 Administrator 小区所在网格名称 varchar(100) 100 CCD8EADC-0958-4232-A83F-18BA18D73B63 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 7FBD3BD6-47DB-4564-976D-08D34891E860 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 1A000AB6-CD24-432B-B924-CEB05C132BE4 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 16A1AA9F-4E7A-4BF3-AE1E-2ED261E6C54A 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 33BB56FA-9BFB-4AE9-9C9B-AD7870637D7B 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 4C678844-0203-4B4B-BDE3-AF5F83AB2A0C 是否是平房 fj_sfpf 1650887219 Administrator 1650887219 Administrator 是否是平房, varchar(2) 2 29576C3C-C0AA-4F91-BA11-1E096619A9A3 是否有地下室 fj_sfydxs 1650887219 Administrator 1650887219 Administrator 是否有地下室 varchar(2) 2 4025804C-E78A-4777-98C9-2656EF2A8095 地下室是否住人 fj_sfzr 1650887219 Administrator 1650887219 Administrator 地下室是否住人 varchar(2) 2 BFBF2CC9-88E8-4CB2-BD1F-CBB848BF9FED 是否有危房 fj_sffw 1650887219 Administrator 1650887219 Administrator 是否有危房 varchar(2) 2 066B6B68-4F51-479F-BBF1-6353DBE4741C 管理方式 fj_glfs 1650887219 Administrator 1650887219 Administrator 管理方式，数据字典无/物业/社区代管/弃管 varchar(2) 2 0BF56607-A9EC-48D3-9831-B7AD366B37A8 管理委员会情况 fj_wyh 1650887219 Administrator 1650887219 Administrator 管理委员会情况，数据字典无/业委会/物管会 varchar(2) 2 8FF25000-76CA-4093-A72D-2A91CBB0B835 是否有违法建筑 fj_wfjz 1650887219 Administrator 1650887219 Administrator 是否有违法建筑 varchar(2) 2 0B4F969E-A06E-4717-B1E8-AA82CFD21326 是否养殖有宠物 fj_sfcw 1650887219 Administrator 1650887219 Administrator 是否养殖有宠物 varchar(2) 2 6FDF1ADD-EBF7-4421-BD94-DCFEFE6CDBAA 是否养殖鸽子或鸡等禽畜 fj_sfgz 1650887219 Administrator 1650887219 Administrator 是否养殖鸽子或鸡等禽畜 varchar(2) 2 AD0F5EA9-643B-4BFE-BF97-75F51A83FA3C 是否为门市房 fj_sfmsf 1650887219 Administrator 1650887219 Administrator 是否为门市房 varchar(2) 2 39106B84-47A9-4CA8-BA6C-852ACEAC6802 商户类型 fj_shlx 1650887219 Administrator 1650887219 Administrator 商户类型，数据字典 varchar(2) 2 D065C4DF-586D-4506-9D4A-1B348EBD8757 餐饮业是否有高空排烟设备 fj_sfgkpy 1650887219 Administrator 1650887219 Administrator 餐饮业是否有高空排烟设备 varchar(2) 2 7F89DD96-E5D6-4918-8BD6-4CE0FD79F927 餐饮业是否有油烟净化器 fj_sfjhq 1650887219 Administrator 1650887219 Administrator 餐饮业是否有油烟净化器 varchar(2) 2 8BC3611F-0C59-47B6-89B8-03BA5F9EF4C8 是否烧炉子（煤/木头） fj_sfslz 1650887219 Administrator 1650887219 Administrator 是否烧炉子（煤/木头） varchar(2) 2 5549BFA2-7CAD-4A95-8728-2EE9519EC28E 房间性质 rfh_fjxz 1650887219 Administrator 1652922808 Administrator 房间性质，数据字典 rfh_fjxz varchar(2) 2 CBE9F209-0206-45C2-86A3-1C4873814E39 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 1395FBF6-7946-4CCA-BA76-4C63722D84C5 社会组织信息表 zhsq_shzz 1650887219 Administrator 1652409279 Administrator 社会组织信息表 53668425-23B4-4CD9-ACBF-5C12AE69DD37 社会组织主键ID id 1650887219 Administrator 1652321688 Administrator varchar(32) 32 7DE0853F-8A36-4814-A799-95352113980E 社会组织名称 shzz_name 1650887219 Administrator 1650887219 Administrator varchar(100) 100 7911CFBF-9013-4A79-893C-739D263DFB90 统一信用社会代码 shzz_code 1650887219 Administrator 1650887219 Administrator varchar(100) 100 2E8F8DEE-4A91-48C8-B5CA-489366F2FDDE 专职人员数量 shzz_zzsl 1650887219 Administrator 1650887219 Administrator varchar(10) 10 9C1F2D8D-7C02-4B27-B67A-9CBCFEEEEF4D 兼职人员数量 shzz_jzsl 1650887219 Administrator 1650887219 Administrator varchar(10) 10 F9A50FF4-92B6-43B9-9298-CCE5B966124C 党员数量 shzz_dysl 1650887219 Administrator 1650887219 Administrator varchar(10) 10 D4A7CB57-1FA1-4428-9260-7E7138C97FC2 预备党员数量 shzz_ybdysl 1650887219 Administrator 1650887219 Administrator varchar(10) 10 52A7A470-761C-4388-9482-D1CCB94E269D 建立党组织时间 shzz_jldzzsj 1650887219 Administrator 1650887219 Administrator varchar(100) 100 23BF93D1-F423-499A-8928-05DAF372ACA8 地址 shzz_address 1650887219 Administrator 1650887219 Administrator varchar(100) 100 7102E381-3297-40EB-A61F-877F898BF3CC 联系电话 shzz_tel 1650887219 Administrator 1650887219 Administrator varchar(100) 100 81C5D88E-EF83-44CE-A5E6-C2E34D638B03 登记注册或备案机关 shzz_bajg 1650887219 Administrator 1650887219 Administrator varchar(100) 100 38060525-E705-4034-8AF1-D8A0FDA60E2B 业务主管部门 shzz_zgbm 1650887219 Administrator 1650887219 Administrator varchar(100) 100 3BD0C9F5-7C24-49F3-A2CB-45F7786C76E8 会员单位数量 shzz_hydw 1650887219 Administrator 1650887219 Administrator varchar(100) 100 E7C75622-A4B1-4422-8FF5-C3142948C613 会员数量 shzz_hysl 1650887219 Administrator 1650887219 Administrator varchar(100) 100 32187715-A7EC-4361-8E05-405719C49504 是否成立工会 shzz_sfclgh 1650887219 Administrator 1650887219 Administrator varchar(2) 2 2C2C193F-3A57-4BEC-B792-CD17CED184C4 是否建立团组织 shzz_sfjltzz 1650887219 Administrator 1650887219 Administrator varchar(2) 2 3A9679F5-2DBC-4EA0-A7B6-94A5A3CFA233 所在街道ID jd_id 1650887219 Administrator 1652321688 Administrator 所在街道ID varchar(32) 32 A718E262-1AD8-4CBB-97F8-F4762BF59CF1 所在街道名称 jd_name 1650887219 Administrator 1650887219 Administrator 所在街道名称 varchar(100) 100 AB72DB28-64ED-4C72-87FB-B6BE0C7A03EE 所在社区ID sq_id 1650887219 Administrator 1652321688 Administrator 所在社区ID varchar(32) 32 A4F79E25-0D1E-457E-97EF-8EFF943F5877 所在社区名称 sq_name 1650887219 Administrator 1650887219 Administrator 所在社区名称 varchar(100) 100 F4A59DCE-E955-4B63-8F65-54D30DBA439E 所在网格ID wg_id 1650887219 Administrator 1652321688 Administrator 所在网格ID varchar(32) 32 4349F075-8112-44FA-9B44-48065DFE33E5 所在网格名称 wg_name 1650887219 Administrator 1650887219 Administrator 所在网格名称 varchar(100) 100 4C9300D9-66C8-4AE9-B4F9-834246FA119B 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 8FA052E8-E18B-47EC-AC3C-FFC996BECA5C 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 8A38E64E-5A32-4AC6-AD3C-ADC287F68840 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 73F23295-C580-4A3C-92E7-0CFADC91DDE5 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 426DB5FF-66E9-4CFF-85D2-D480345F8AD7 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 0E99E65E-C5F4-4FA3-A433-BA1967932989 事件处置信息表 zhsq_sjcz 1650887219 Administrator 1650888404 Administrator 事件处置信息表 AC48C534-6BFC-41E5-A3A5-096D77D04B58 事件处置信息主键ID sjcz_id 1650887219 Administrator 1650887219 Administrator bigint 1 65FF78DC-6506-4188-B43B-16A258185E89 事件主键ID sj_id 1650887219 Administrator 1650887219 Administrator 事件主键ID bigint B326EEB5-FDD2-4F44-81D8-801CA19CC88C 处置部门ID sjcz_dept_id 1650887219 Administrator 1650887219 Administrator bigint B2EEAC85-AA31-4707-A52D-D1BC91E31E47 处置部门名称 sjcz_dept_name 1650887219 Administrator 1650887219 Administrator varchar(100) 100 BC75D622-C5FE-4A28-B928-BE05A2FA014C 处置人ID sjcz_user_id 1650887219 Administrator 1650887219 Administrator bigint 9207966F-FAB0-4349-BC87-A5AEC0BDDC40 处置人姓名 sjcz_user_name 1650887219 Administrator 1650887219 Administrator varchar(100) 100 A1FBE9F0-6C48-4E80-AF7C-2F26B526E32B 事件下发时间 sjcz_xfsj 1650887219 Administrator 1650887219 Administrator 事件下发时间 varchar(100) 100 2086CC22-F6F9-4A21-B75A-6F5621E808EB 预计签收时间 sjcz_yjqssj 1650888334 Administrator 1650888427 Administrator varchar(100) 100 9BAEB962-785E-4C76-A1D0-15D9507A4AF1 实际签收时间 sjcz_qssj 1650887219 Administrator 1650888427 Administrator varchar(100) 100 49AE3F5A-5FEB-47AF-971F-1C300327C6A6 预计完成时间 sjcz_yjwcsj 1650887219 Administrator 1650887219 Administrator 预计完成时间 varchar(100) 100 633AE068-CED6-4405-9709-6C461B6EC800 实际完成时间 sjcz_sjwcsj 1650887219 Administrator 1650887219 Administrator 实际完成时间 varchar(100) 100 8FDE6F87-290C-48C9-9188-098B68A68DCE 处理结果 sjcz_czjg 1650887219 Administrator 1650887219 Administrator varchar(1000) 1000 7ABD91AE-7BE6-46B4-B9AE-038B2E81D160 状态 sjcz_czzt 1650887219 Administrator 1650887219 Administrator 状态，数据字典：未签收拒签签收，未开始处置正在处置无法处置处置完成 varchar(2) 2 34A50A67-5A68-4991-9F60-D059177F2F2C Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 343047E9-3F11-436E-A5D5-6EAAB0828F2E 事件日志信息表 zhsq_event_log 1650887219 Administrator 1651902440 Administrator 事件日志信息表 48C5D7B9-23F9-4AE9-8B37-776389C5B745 事件日志信息主键ID eventlog_id 1650887219 Administrator 1651902479 Administrator 事件日志信息主键ID bigint 1 7AFE8126-2F66-4246-90B5-8FE73CE05DF4 事件ID event_id 1650887219 Administrator 1651902484 Administrator 事件ID bigint 15BF369B-F15A-4215-8430-75175F4AE139 时间 eventlog_time 1650887219 Administrator 1651902507 Administrator 时间 varchar(100) 100 6A707836-5DF0-47E1-81FD-80E3DEC64AB7 内容 eventlog_content 1650887219 Administrator 1651902507 Administrator 记录内容 varchar(1000) 1000 9F081CB1-F567-45A1-93AD-FA1186B7F013 记录人ID eventlog_user_id 1650887219 Administrator 1651902507 Administrator 记录人（部门）ID bigint 83367E45-DA04-497D-9B3C-24C9CAD87C26 记录人姓名 eventlog_user_name 1650887219 Administrator 1651902507 Administrator varchar(100) 100 7B984009-43B1-40A7-AAB7-36B325680343 部门ID eventlog_dept_id 1650887219 Administrator 1651902507 Administrator bigint F230948A-C013-48AE-9248-98543B880312 部门名称 eventlog_dept_name 1650887219 Administrator 1651902507 Administrator varchar(100) 100 CC62B6CC-07C3-4EE7-95CD-69FABE2E7C44 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator E8769B1B-77BA-4D79-B1BA-98C8C8721566 事件绩效考核规则表 zhsq_event_kaohe_rule 1650887219 Administrator 1651827454 Administrator 事件绩效考核规则表 D4750F07-EA83-417C-8791-480CF01F0B6D 事件考核规则信息主键ID rule_id 1650887219 Administrator 1650887219 Administrator bigint 1 B02EAB79-DE69-4353-9FF9-DFC87EC69FD2 规则名称 rule_name 1650887219 Administrator 1650887219 Administrator varchar(100) 100 0D25642A-0541-4C96-ABB5-9464D8ED2147 事件状态 rule_event_state 1650887219 Administrator 1651827361 Administrator varchar(3) 3 0AD90988-2ADA-4ED4-9ADF-6DC44A19C8E3 天数 rule_days 1650887219 Administrator 1650887219 Administrator varchar(100) 100 B78BBC8E-94A8-4607-97BE-7E591F442D89 分值 rule_score 1650887219 Administrator 1650887219 Administrator varchar(10) 10 F60FAA73-77D0-4E07-8BC9-72AD32AF3BF7 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 44ABA6A1-DEA3-4990-BE8F-F0D317CC6832 事件绩效考核日志表 zhsq_event_rule_log 1650887219 Administrator 1651902407 Administrator 事件绩效考核日志表 C2C4D424-CD31-426F-8AB5-08F9E6BE445C 绩效考核日志主键ID rulelog_id 1650887219 Administrator 1650887219 Administrator 绩效考核日志主键ID bigint 1 89126FDF-A045-47BE-A9A1-BDC7B940B924 事由 rulelog_content 1650887219 Administrator 1650887219 Administrator 分值变化事由 varchar(1000) 1000 031DDD0D-C70F-48AB-A2B9-6CAFE6A6A75F 时间 rulelog_time 1650887219 Administrator 1650887219 Administrator 记录产生时间 varchar(100) 100 05E80CA3-5201-45EA-B60D-5F5CD8BF3B32 分数 rulelog_score 1650887219 Administrator 1650887219 Administrator 分数 float(5,2) 5 2 D93D65E8-9BB9-4263-BFC8-39B01111DB1F 事件ID event_id 1650887219 Administrator 1651902429 Administrator 事件ID bigint 51C23FF0-A966-47FD-9D65-91FD620CD152 人员ID rulelog_user_id 1650887219 Administrator 1650887219 Administrator bigint 6F2AB587-06C1-4AFF-9946-CAF184291E90 人员名称 rulelog_user_name 1650887219 Administrator 1650887219 Administrator varchar(100) 100 DF5B6D7B-3D5F-47F6-A367-F3597496910B 部门ID rulelog_dept_id 1650887219 Administrator 1650887219 Administrator bigint 3F55E680-1DAF-402C-884B-374C779CB462 部门名称 rulelog_dept_name 1650887219 Administrator 1650887219 Administrator varchar(100) 100 1F929927-0E08-4691-8A1E-76F4EE2D77E4 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 1186CC14-075C-4EEF-B93D-5ED481AF9965 节假日信息表 zhsq_jiejiari 1650887219 Administrator 1650887219 Administrator 节假日信息表 53A1FD3C-20B3-482B-8DB3-3D32698A7C7E 节假日信息主键ID jjr_id 1650887219 Administrator 1650887219 Administrator 节假日信息主键ID bigint 1 ADB96B18-30BF-45F7-9E3B-43AF338F6725 日期 jjr_date 1650887219 Administrator 1650887219 Administrator 日期 varchar(100) 100 11F11229-8023-4818-A976-F94D953EC665 类型 jjr_type 1650887219 Administrator 1650887219 Administrator 类型：数据字典工作日休息日 varchar(2) 2 57341BD0-A4C9-4180-B809-C3A08D5CD660 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 80A5819E-C6A1-4CF5-84B5-C6832E880454 人口信息表 zhsq_person 1650887219 Administrator 1651892491 Administrator 人口信息表 BB9E375A-8E9D-4166-80A0-92508AA022AF 人口信息主键ID id 1650887219 Administrator 1651892472 Administrator 人口信息主键ID varchar(32) 32 1 FC0086B8-0E48-431E-985E-39CF97FD13AD 房间主键ID fj_id 1650887219 Administrator 1651892472 Administrator 楼层房间主键ID varchar(32) 32 E7477FB8-486C-4D58-8332-E8121E15DD79 房间名称 fj_name 1650905196 Administrator 1650905271 Administrator 房间名称 varchar(100) 100 1B3B669C-B845-43AD-9811-D52D4DB006AF 单元主键ID dy_id 1650905196 Administrator 1652321604 Administrator 单元主键ID varchar(32) 32 21BC11F7-D57F-4BBD-B83F-FAF971C5FEBC 单元名称 dy_name 1650905196 Administrator 1650905271 Administrator varchar(100) 100 D5A381EA-8C67-4425-802B-EA1EED8D70FD 楼栋主键ID ld_id 1650905196 Administrator 1652321604 Administrator varchar(32) 32 56E5AF53-179E-42C1-A36B-B3D86B5DF142 楼栋名称 ld_name 1650905196 Administrator 1650905271 Administrator varchar(100) 100 19F2A25F-46E3-4138-A278-D017A270D877 小区主键ID xq_id 1650905196 Administrator 1652321604 Administrator varchar(32) 32 3400B3AA-BB9D-4673-8566-058DBDC6F16D 小区名称 xq_name 1650905196 Administrator 1650905271 Administrator varchar(100) 100 85E43098-A54B-48B9-A2FF-B35A9D0955E5 所在楼层 fj_lc 1650905196 Administrator 1650905271 Administrator 所在楼层 varchar(5) 5 AD54B3C1-048D-4FCC-8FC3-A4C41872B111 所在街道ID jd_id 1650905196 Administrator 1652321604 Administrator 小区所在街道ID varchar(32) 32 360A9764-7916-4CD0-AB32-7FC6BE14DEC2 所在街道名称 jd_name 1650905196 Administrator 1650905271 Administrator 小区所在街道名称 varchar(100) 100 EA44B20F-F61E-433C-83BE-696F1F220C9D 所在社区ID sq_id 1650905196 Administrator 1652321604 Administrator 小区所在社区ID varchar(32) 32 09FB6461-E9C3-43CC-BE50-85555D49D5E6 所在社区名称 sq_name 1650905196 Administrator 1650905271 Administrator 小区所在社区名称 varchar(100) 100 8DE62945-D0E8-43F9-BD38-9237A4CF131F 所在网格ID wg_id 1650905196 Administrator 1652321604 Administrator 小区所在网格ID varchar(32) 32 90797AEA-1272-4A5D-9EEA-1A6FB01222BF 所在网格名称 wg_name 1650905196 Administrator 1650905271 Administrator 小区所在网格名称 varchar(100) 100 7E5F0CD2-EFB4-4480-92C5-55CB9CF1846C 人员姓名 per_name 1650887219 Administrator 1650887219 Administrator 人员姓名 varchar(100) 100 8C2A3D84-BD88-4A1A-A02C-7B249E7C897B 性别 per_sex 1650887219 Administrator 1650887219 Administrator 性别，数据字典 varchar(2) 2 13EFE663-0524-475E-98D3-0DE97BDB6E29 民族 per_nation 1650887219 Administrator 1650887219 Administrator 民族，数据字典 varchar(2) 2 9BFF7C00-545C-4DEA-B52E-D1E3FEB1B0E2 年龄 per_age 1650887219 Administrator 1650887219 Administrator 年龄 varchar(5) 5 20C772F5-3E56-44FF-8E08-C469C3624691 身份证号 per_idcard 1650887219 Administrator 1650887219 Administrator 身份证号 varchar(20) 20 C88A7D11-AC7B-4D1C-9762-8E545B451E02 联系方式 per_tel 1650887219 Administrator 1650887219 Administrator 联系方式 varchar(20) 20 07EA0AA7-E779-4DC9-AB04-D86B59F0221C 政治面貌 per_zzmm 1650887219 Administrator 1650887219 Administrator 政治面貌，数据字典 varchar(2) 2 80F505BA-0660-42F0-AB9F-9F19FE40718A 文化程度 per_degree 1650887219 Administrator 1650887219 Administrator 文化程度，数据字典 varchar(2) 2 28804B48-9540-4FE7-BBF4-81F38833B047 与房主关系 per_fzgx 1650887219 Administrator 1650887219 Administrator 与房主关系，数据字典 varchar(2) 2 0D1BB6A3-6B4F-46A8-ABE9-43276DD72932 是否空挂 per_sfkg 1650887219 Administrator 1650887219 Administrator 是否空挂，数据字典 varchar(2) 2 2E13CF4C-1C74-4E36-81B0-C34C96198272 与户主关系 per_hzgx 1650887219 Administrator 1650887219 Administrator 与户主关系，数据字典 varchar(2) 2 AB0208F1-067F-4B03-A9AB-9FCF11ADFAAC 户籍地址 per_hj 1650887219 Administrator 1650887219 Administrator 户籍地址 varchar(100) 100 7D51A769-677F-4A6A-A85F-9A4B11E047F8 工作单位 per_dw 1650887219 Administrator 1650887219 Administrator 工作单位 varchar(100) 100 0EA0594A-C558-444B-919F-1CBA14CA8733 是否一汽退休老干部 per_yqtx 1650887219 Administrator 1650887219 Administrator 是否一汽退休老干部，数据字典 varchar(2) 2 7D414F5B-EE4C-47AB-8A06-3F0958C0EDB5 宗教集会场所 per_zjcs 1650887219 Administrator 1650887219 Administrator varchar(100) 100 8FA40BEF-5E34-4148-9612-76BD88D97E61 是否为人大代表或委员 per_rddb 1650887219 Administrator 1650887219 Administrator 是否为人大代表或委员，数据字典 varchar(2) 2 71549E12-E577-40E6-BA64-0BDE2141151C 流动属性 per_ldsx 1650887219 Administrator 1650887219 Administrator 流动属性，数据字典常住人口流动人口户籍人口暂住人口 varchar(2) 2 03FB72F4-2D63-4012-8680-078230890C6C 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int E519467B-46F9-4CF0-BB29-E89F9552765C 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 32502544-3045-4C10-8AA8-B9E79FF66A8D 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 1C574D00-8702-4CA0-A08C-EE4B4B445AC6 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 58B5ECA3-38B6-4E8C-9F63-8AA7BFDCF0E7 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint D4A24EE9-BF3D-4AEA-AB00-B326E9BF1B4F 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 D7C96584-D609-4A84-8B3C-983EB661FFD2 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 CF9DBBE9-907B-4D10-B589-EEBA2C1AC0B4 数据删除审核状态 per_del_state 1650887219 Administrator 1650887219 Administrator 数据删除审核状态，数据字典 varchar(2) 2 B0F9526F-FB92-486C-8DDF-4E77DB8C2C1A Key_1 Key_1 1650887219 Administrator 1650887219 Administrator F608F2D8-8F27-4D25-9086-7CDDEAD32D39 知识库系统 zhsq_zhishiku 1650887219 Administrator 1650887219 Administrator 3EB1C376-09A4-4ACE-A47D-0F79A57729F8 知识库主键ID zsk_id 1650887219 Administrator 1650887219 Administrator 知识库主键ID bigint 1 49F894B4-3C9A-44BD-8F58-944741AD27E7 知识库类型 zsk_type 1650887219 Administrator 1650887219 Administrator 知识库类型 varchar(10) 10 9DA48C5A-7E6F-4FF9-B62E-5043DBB50FED 知识库栏目名称 zsk_title 1650887219 Administrator 1650887219 Administrator 知识库栏目名称 varchar(100) 100 27358320-5C19-48DC-8645-E1AE3212F08C 知识库内容 zsk_content 1650887219 Administrator 1650887219 Administrator 知识库内容 longtext 1D0C6A0C-AF50-476B-BC38-8830FF1EE861 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int B86DE2B4-86AE-446F-95E5-24DB39EEE3AE 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 5EF330D3-D4B5-497F-8A8C-9E4FD4D97A83 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 D00A997E-33B1-40EE-A3CA-290BA54981C3 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 06A4D702-EDF2-4F2F-B146-C3DDF905D200 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 75AF2DFF-9755-4A45-B181-78637DAB2005 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 38837A73-D159-4338-B770-2D9744D04244 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 31AE9AF9-A68E-41DE-A954-A67327495994 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator FDE3F58B-D013-465E-9F56-0FD6E2404D41 备忘录 zhsq_memorandum 1650887219 Administrator 1650887219 Administrator 备忘录 DDC94E4F-77BA-4EBE-9602-62E971C6F028 备忘录主键ID me_id 1650887219 Administrator 1650887219 Administrator 备忘录主键ID bigint 1 2795A09C-BEF7-4E91-B63B-8042B398993A 备忘录标题 me_title 1650887219 Administrator 1650887219 Administrator 备忘录标题 varchar(100) 100 10754D1E-008E-473A-8F2B-59B4D867A1C3 备忘录内容 me_content 1650887219 Administrator 1650887219 Administrator 备忘录内容 longtext 12723280-CC10-4672-9B8C-72BFA2890C82 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 4B8A46FD-E9D4-41A1-AEB5-F6F2A393B3EA 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 55C10AD4-A0C1-4505-BAB5-D1003B9135D9 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 3EA20C34-DFE3-4114-9461-23FA0DF2D79C 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 1D91E672-EAF7-43A5-9F59-04B14CCB9764 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 08FA396A-FA84-47E6-ABD5-99BD49458E3D 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 7B599D7B-F1BC-45D3-BBEB-CD9195E10B69 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 9402FD8F-1BF9-4D12-B522-93EADC4D6A3E Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 71A2C52A-9C35-448E-B6E3-C17ACE50D976 任务核查信息表 zhsq_rewuhecha 1650887219 Administrator 1650887219 Administrator 任务核查信息表 27C9094B-E1F7-4F5B-B899-F3635E193C1A 任务核查信息主键ID rwhc_id 1650887219 Administrator 1650887219 Administrator 任务核查信息主键ID bigint 1 E2CA6431-3382-4523-B930-EB1B8EB91588 任务名称 rwhc_title 1650887219 Administrator 1650887219 Administrator 任务名称 varchar(100) 100 7D390ABE-98A1-456A-9F44-33332B067AA2 任务内容 rwhc_content 1650887219 Administrator 1650887219 Administrator 任务内容 longtext 8277562C-9D45-4910-BD56-775B5614B61E 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 6AF9D449-8C31-45FD-B889-48B71757EA65 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 5649FA0B-4B3F-4795-A28C-668CCE8A62B5 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 F2679060-D737-48E5-976F-A31727C06861 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 F141B6BF-3C73-478E-A5CA-716EA5F4E882 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 09F285D3-9579-4A57-AFEA-F36FF909B8E8 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 860A8A51-3E30-4305-8E23-620ABC99F2A3 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 5C8EBB04-F5CF-4EB6-9898-89ACB80CEB69 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 8B3DC056-8475-413B-A81D-12C0F908CCA0 任务核查信息反馈表 zhsq_rwhc_fk 1650887219 Administrator 1650902710 Administrator 任务核查信息反馈表 B0339805-B810-4F7E-A4F2-D00BC68AE02B 核查反馈信息主键ID rwhcfk_id 1650887219 Administrator 1650887219 Administrator 核查反馈信息主键ID bigint 1 9ECDE801-0015-4D83-AF90-689A0EE084D9 任务核查信息主键ID rwhc_id 1650887219 Administrator 1650887219 Administrator 任务核查信息主键ID bigint 295016A6-118B-4E97-ABA6-F1360CBE4D53 接收部门ID dept_id 1650887219 Administrator 1650887219 Administrator 接收部门ID bigint 4894ADEF-A985-4C5B-9FC4-BFED0D5CAB00 接收部门名称 dept_name 1650902655 Administrator 1650902710 Administrator varchar(100) 100 12CBDD67-FE17-408C-975C-B5C8612C00F2 核查任务状态 rwhcfk_state 1650887219 Administrator 1650887219 Administrator 核查任务状态，数据字典：未完成完成 varchar(2) 2 2E1E2C0A-95A5-41F7-BC9B-F4B86136E0B8 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 45C3535C-B0A9-4C66-BFDD-6149F83FD8E7 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 85D779DE-EA8D-403E-A1FC-D33BF502CC8E 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 E33C1B9C-DAC7-480E-8204-C61895A0C037 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 35F3A931-E3CE-4ACB-8BE1-DBC56C6FEDBA 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint BC6C1B70-7384-4B04-80DE-F4CEE37BD1EA 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 068EABD3-8CD5-4683-9D75-109B0FFFF442 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 DBD53892-937B-404C-9145-8B5D706019F4 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator A307464D-216D-4E9C-BD09-EE902CC0A591 网格员巡查轨迹 zhsq_xcgj 1650887219 Administrator 1650887219 Administrator 网格员巡查轨迹 D4DB9554-6DE7-46AF-83E2-22E492C3C5A5 巡查主键ID gps_id 1650887219 Administrator 1650887219 Administrator 巡查主键ID bigint 1 DEBB143B-2593-43BD-8B10-19F480C68C02 时间 gps_time 1650887219 Administrator 1650887219 Administrator 时间 varchar(100) 100 6AA47C93-1FF6-4D08-B6FC-D4670657BC12 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int F8701953-E285-4ED5-A94D-635D54A68FCB 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 688BDE6F-6DAE-4D3B-BFDC-01FF482D8CFF 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 903E68AC-3B13-49F6-A4E3-A2FEB5553AE5 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 B3908B77-CD30-49B1-A587-0B43486546CC 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint C63AB7C1-C283-428A-ADDE-6656DB1D37B7 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 EFA3BEAC-623A-4EA4-84BC-2EABE15F6A6B 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 2D88BC69-9391-431B-8E63-CAC0B6828278 所在街道ID jd_id 1650887219 Administrator 1650887219 Administrator 所在街道ID bigint 40D6EDB3-90D9-4B78-AEC6-004F898EB7AC 所在街道名称 jd_name 1650887219 Administrator 1650887219 Administrator 所在街道名称 varchar(100) 100 0610DA1F-AC80-4681-93B6-243D0DECE633 所在社区ID sq_id 1650887219 Administrator 1650887219 Administrator 所在社区ID bigint 00E34F0E-720A-421E-A24A-C7BFCB4DE058 所在社区名称 sq_name 1650887219 Administrator 1650887219 Administrator 所在社区名称 varchar(100) 100 7D474F9F-8D55-4821-AC1C-5E9C71E66987 所在网格ID wg_id 1650887219 Administrator 1650887219 Administrator 所在网格ID bigint 7A86E447-EA66-4692-B0E5-BBBD79A4DD86 所在网格名称 wg_name 1650887219 Administrator 1650887219 Administrator 所在网格名称 varchar(100) 100 587A0F47-5DA6-4114-A142-04B51AF99B74 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 0308938C-860A-4FD2-A24E-C7ED32C3F486 任务下派信息表 zhsq_rwxp 1650887219 Administrator 1650887219 Administrator 任务下派信息表 D7DC1052-2355-4AB5-A6C9-0DAECF66C0E1 任务下派信息主键ID rwxp_id 1650887219 Administrator 1650887219 Administrator 任务下派信息主键ID varchar(100) 100 1 5D051BBF-23FD-4E6D-A656-6E21C6CCAA95 任务名称 rwxp_title 1650887219 Administrator 1650887219 Administrator 任务名称 varchar(100) 100 DFB2F8B4-FA0E-4613-99BA-51F33D69D008 任务内容 rwxp_content 1650887219 Administrator 1650887219 Administrator 任务内容 longtext 6A7F68C7-3863-49B4-9C5A-E2463FF87ADF 任务状态 rwxp_state 1650887219 Administrator 1650887219 Administrator 任务状态，数据字典新建下发 varchar(10) 10 5BEB7FC1-CA09-427C-B1F5-8BD25168E77B 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 24073F6E-AA81-48F1-8F57-2640FB5B8CA5 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 99DA5B2F-23FF-4D77-A48E-C56D77BEA495 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 BB37EC6E-15DC-4CA3-924B-BF8F4BC34DB7 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 2CF699F3-71B9-4D3F-AB09-090028A45B73 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint F0BD5162-2153-4838-BE92-847CC8F38B21 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 09E3ABD0-9278-4E83-926F-DB7ADB614B55 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 1DED53E9-E79C-4D3C-9666-FCA5A61D1FE8 通用附件 file_object 1650887219 Administrator 1650887219 Administrator 通用附件 varchar(2000) 2000 78D45AA1-D5EE-42C8-B228-415668EC88DD Key_1 Key_1 1650887219 Administrator 1650887219 Administrator A63F904A-12D1-4F42-A265-0703873181A1 任务下派完成情况表 zhsq_rwxp_wcqk 1650887219 Administrator 1650902600 Administrator 任务下派完成情况表 00F3A6E1-AD07-4D76-A4AF-E91ED8232287 任务下派完成信息主键ID rwxpwc_id 1650887219 Administrator 1650887219 Administrator 任务下派完成信息主键ID varchar(100) 100 1 19FB67A9-29A1-4EBB-948D-47817DDE671F 任务下派信息主键ID rwxp_id 1650887219 Administrator 1650887219 Administrator 任务下派信息主键ID varchar(100) 100 D1954F4A-3802-4550-ACA8-51BFD0F53CA9 任务下派部门ID dept_id 1650887219 Administrator 1650902600 Administrator 任务下派部门 bigint C84ACF94-B146-4648-A2C4-0CC61DC9748B 任务下派部门名称 dept_name 1650902547 Administrator 1650902600 Administrator varchar(100) 100 A26705F7-B8A0-4A5B-8219-87406BE7E345 任务状态 rwxpwc_state 1650887219 Administrator 1650887219 Administrator 任务状态：数据字典待签收已签收，未完成完成 varchar(2) 2 C6675CFD-33B3-4C3A-ABD9-A303370ECADA 完成时间 rwxpwc_time 1650887219 Administrator 1650887219 Administrator 完成时间 varchar(100) 100 216CEA0D-1A06-4005-BF1C-806546520C15 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 53D15E2F-E960-4355-BA31-2C05C9708450 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 6C4112F5-85C0-4FEA-BC19-BDFD116EEFBB 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 491D7358-9FC2-4EEF-B38A-048F1F360716 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 3C25FEB7-3FB4-4E80-8563-70535943687C 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 40273818-B7D1-470D-8392-82BBFA8E1630 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 318FAB2C-6B12-493A-B33E-233440E3E6BF 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 EB6DD4AF-1059-4C6B-AC44-8AC01DE2CBD6 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator B75E39CE-F5B5-46FC-A0C3-16F06FA08590 民情诉求信息表 zhsq_mqsq 1650887219 Administrator 1650887219 Administrator 民情诉求信息表 41206609-552D-48FF-A05E-84C2958787EA 民情诉求信息主键ID mqsq_id 1650887219 Administrator 1650887219 Administrator 民情诉求信息主键ID bigint 1 2387AADA-2605-4600-ACDA-9B17A95BBBD3 民情诉求标题 mqsq_title 1650887219 Administrator 1650887219 Administrator 民情诉求标题 varchar(100) 100 66CAE620-CB20-4C82-9802-18AC7E4370C8 民情诉求内容 mqsq_content 1650887219 Administrator 1650887219 Administrator 民情诉求内容 longtext 53E8CBD0-DB9B-407C-883E-7EFBF20C120D 诉求时间 mqsq_time 1650887219 Administrator 1650887219 Administrator 诉求时间 varchar(100) 100 7CB32A93-A55F-42DE-B101-DFFCB8E0AE72 处置人ID mqsq_czr_id 1650887219 Administrator 1650887219 Administrator 处置人ID varchar(100) 100 CF81BAF3-BE6D-4D56-80BD-399B93DAFB61 处置人姓名 mqsq_czr_name 1650887219 Administrator 1650887219 Administrator 处置人姓名 D5630836-BF3C-432F-B1C0-1E086D1AFCD0 处置时间 mqsq_czsj 1650887219 Administrator 1650887219 Administrator 处置时间 AFF9F697-1BDD-4911-9B3A-A7AFB6F35DCE 处置结果 mqsq_czjg 1650887219 Administrator 1650887219 Administrator 处置结果 35EC234F-4094-4429-9FB3-44B140B707E1 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 6E92118F-31B9-48AD-A555-CE583013F246 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 1FD9B314-2D7E-41B2-A56F-55ACC34BFE33 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 5239C2CE-DFB5-4CF8-A901-5194607D8680 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 5B9E5C03-350F-4A9D-8F0E-CF3F1961E105 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint F667B94A-3338-4BAD-97AF-18FF9BF598AB 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 7E95E1CA-FD67-421F-A8B6-4A8415498834 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 EEF2466B-E3F7-45EF-A62C-5A9AA9621310 所在街道ID jd_id 1650887219 Administrator 1650887219 Administrator 所在街道ID bigint BEDD2F13-9C1E-45B7-B269-342B6D49B6FC 所在街道名称 jd_name 1650887219 Administrator 1650887219 Administrator 所在街道名称 varchar(100) 100 F27A6B3E-84C7-4C5E-B9DB-4F418E3E8064 所在社区ID sq_id 1650887219 Administrator 1650887219 Administrator 所在社区ID bigint 9806B4BC-C554-4D69-A4A9-3F45AFC3D797 所在社区名称 sq_name 1650887219 Administrator 1650887219 Administrator 所在社区名称 varchar(100) 100 2D5180A5-6377-414D-822F-E9194B2A6B2C 所在网格ID wg_id 1650887219 Administrator 1650887219 Administrator 所在网格ID bigint 4977EB65-372B-4FB3-B73E-65E0E79A7822 所在网格名称 wg_name 1650887219 Administrator 1650887219 Administrator 所在网格名称 varchar(100) 100 B3A28775-10BF-49F5-BE99-51535A2FE621 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator ABAD2C8D-3108-44CC-B08B-E3FE1719215B 党员信息表 zhsqs_dangyuan 1650887219 Administrator 1650902919 Administrator 党员信息表 BCCA7ABA-9A53-4BD1-A95D-EB97323B91EF 党员信息主键id dy_id 1650887219 Administrator 1650887219 Administrator 党员信息主键id bigint 1 9B7CA0B8-300D-489D-B439-8ADC6AE24BB7 人员类型 dy_type 1650887219 Administrator 1650887219 Administrator 人员类型，数据字典：党员预备党员积极分子 varchar(2) 2 E3682D95-966F-4CEC-A3EF-95E06B5461AB 姓名 dy_name 1650887219 Administrator 1650887219 Administrator 姓名 varchar(100) 100 124E78C0-C87A-4E98-B960-05B708182F2E 性别 dy_sex 1650887219 Administrator 1650887219 Administrator 性别，数据字典男女 varchar(100) 100 090420F8-9755-4782-8DD9-AB437FEBC875 民族 dy_nation 1650887219 Administrator 1650887219 Administrator 民族，数据字典 varchar(2) 2 9F0F5252-3411-4248-BF3E-FE1820364197 出生日期 dy_birth 1650887219 Administrator 1650887219 Administrator 出生日期 varchar(100) 100 F0116859-4D06-48DF-AB43-C7B8A50BA9A5 学历 dy_degree 1650887219 Administrator 1650887219 Administrator 学历，数据字典 varchar(2) 2 31DB242E-2C42-4620-81B2-2F3CE3AD003E 所在党支部ID party_id 1650887219 Administrator 1650902919 Administrator 所在党支部 bigint 795B5144-316C-4650-9B79-956AB242A448 所在党支部名称 party_name 1650902863 Administrator 1650902919 Administrator varchar(100) 100 B8B5784C-6059-428E-B8C4-54F63AC148C8 加入党组织日期 dy_rdsj 1650887219 Administrator 1650887219 Administrator 加入党组织日期 varchar(100) 100 218C6FF4-EE79-4611-AB17-E1344C09B8BA 转为正式党员日期 dy_zzsj 1650887219 Administrator 1650887219 Administrator 转为正式党员日期 varchar(100) 100 C39325E2-A89F-4645-B39F-5117DC39CE1A 工作单位 dy_dw 1650887219 Administrator 1650887219 Administrator 工作单位 varchar(100) 100 65385024-EC34-48C7-A234-CB2926CF4CA3 手机号 dy_tel 1650887219 Administrator 1650887219 Administrator 手机号 varchar(100) 100 DFAD87E3-52E5-4E7F-BEC4-3DD648CCB2DF 家庭住址 dy_address 1650887219 Administrator 1650887219 Administrator 家庭住址 varchar(100) 100 E8F400DE-34C9-483F-9D43-0D690A898090 党籍状态 dy_dj 1650887219 Administrator 1650887219 Administrator 党籍状态 varchar(2) 2 ADBE56BA-AFC6-45F2-A45D-184E254CD4AC 是否失联党员 dy_sfsl 1650887219 Administrator 1650887219 Administrator 是否失联党员，数据字典是否 varchar(2) 2 35C6C0D1-AEEB-422F-A818-8F3BBFEC99DD 失联日期 dy_slrq 1650887219 Administrator 1650887219 Administrator 失联日期 varchar(100) 100 4AC0F793-6C84-471F-9146-04B97D41424B 是否流动党员 dy_sfld 1650887219 Administrator 1650887219 Administrator 是否流动党员，数据字典是否 varchar(2) 2 A092E8DB-D584-442A-BBA2-1E415C724DF6 外出流向 dy_lx 1650887219 Administrator 1650887219 Administrator 外出流向 varchar(100) 100 D412B111-6080-4981-9E5A-0F44665225B6 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 09F7DEE0-1A8B-48EA-9E4A-C5EE8D466022 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint CF372057-2B9B-4D96-A78E-7E566C951F40 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 44B1C143-0699-4AE6-8928-1A1A0F9EE219 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 F2C912E5-494D-4B89-9AFA-048D4F1761B0 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint F591D996-E666-442E-B9A9-BA317D3FC150 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 227FB84F-16E0-4A76-B2E8-98EB644E252F 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 6DB607B6-DBC3-4077-A9EB-06046884733D Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 5F11C2BD-4444-447E-9D30-E9CD6656BE11 基层干部信息表 zhsq_jcgb 1650887219 Administrator 1650903015 Administrator 基层干部信息表 0B3FA39E-2527-4A6D-B7E3-E4C93247615D 基层干部信息主键ID jcgb_id 1650887219 Administrator 1650887219 Administrator 基层干部信息主键ID bigint 1 21E40E9F-523D-4702-94DF-5D174E7B3E23 人员类型 jcgb_type 1650887219 Administrator 1650887219 Administrator 人员类型：数据字典：街道书记街道干部乡镇书记乡镇干部社区书记社区干部村书记村干部 varchar(2) 2 40902C02-D924-4AE8-8915-5A2A1669FB78 所在党支部ID party_id 1650887219 Administrator 1650903015 Administrator 所在党支部 bigint 42368A27-54CA-4B16-959E-C55708FEFE3F 所在党支部名称 party_name 1650902975 Administrator 1650903015 Administrator varchar(100) 100 4B3CE3D8-2818-453D-B692-04B62754B847 姓名 jcgb_name 1650887219 Administrator 1650887219 Administrator 姓名 char(100) 100 D39C6A64-6A06-4E77-9F4E-3BD0CC1B8AFE 性别 jcgb_sex 1650887219 Administrator 1650887219 Administrator 性别，数据字典男女 varchar(100) 100 1EDFA903-A36C-49D6-A896-B834374339EE 民族 jcgb_nation 1650887219 Administrator 1650887219 Administrator 民族，数据字典 varchar(100) 100 3ACC3D35-10D8-4BAB-B96F-066C5A1F2722 籍贯 jcgb_jg 1650887219 Administrator 1650887219 Administrator 籍贯 varchar(100) 100 C38D5176-5C70-458C-A5BE-868C774CCAEE 出生地 jcgb_csd 1650887219 Administrator 1650887219 Administrator 出生地 varchar(100) 100 76BF48EA-F343-435E-82EC-051A976BA351 出生日期 jcgb_birth 1650887219 Administrator 1650887219 Administrator 出生日期 varchar(100) 100 A33D0ED8-2B1E-4150-88F0-FE4B554E54EA 参加工作时间 jcgb_worktime 1650887219 Administrator 1650887219 Administrator 参加工作时间 varchar(100) 100 7136ED6B-604D-40BE-BC58-28DC0EDBEFF1 入党时间 jcgb_rdsj 1650887219 Administrator 1650887219 Administrator 入党时间 varchar(100) 100 564A9139-55C2-4037-80EF-CC38B5E7499E 技术职称 jcgb_jszc 1650887219 Administrator 1650887219 Administrator 技术职称 varchar(100) 100 7346ABFA-86F3-4DD8-BEE6-5FBD0C7486B1 全日制毕业院校 jcgb_rqz_yx 1650887219 Administrator 1650887219 Administrator 全日制毕业院校 varchar(100) 100 4A8D11B1-D85F-48AB-BEDC-8073B7966438 全日制专业 jcgb_rqz_zy 1650887219 Administrator 1650887219 Administrator 全日制专业 varchar(100) 100 E6E730E8-37B5-4E74-9DBF-368ECEF49792 全日制学历 jcgb_rqz_xl 1650887219 Administrator 1650887219 Administrator 全日制学历，数据字典 varchar(100) 100 C84EBCBE-F4FD-44DC-9BFE-DA5AEC54AE39 在职毕业院校 jcgb_zz_yx 1650887219 Administrator 1650887219 Administrator 在职毕业院校 varchar(100) 100 E82E3CE5-4968-4694-B6F2-BF249369E335 在职专业 jcgb_zz_zy 1650887219 Administrator 1650887219 Administrator 在职专业 varchar(100) 100 F0FF0357-BE8E-4460-8B93-807A87AEBEF0 在职学历 jcgb_zz_xl 1650887219 Administrator 1650887219 Administrator 在职学历，数据字典 varchar(100) 100 DBADB7C2-62A1-4A03-A6C0-5A27A6F952E4 现任职务 jcgb_zw 1650887219 Administrator 1650887219 Administrator 现任职务 varchar(100) 100 D7C58EAB-DAF8-41D3-8266-324871948B69 任现职务时间 jcgb_zwsj 1650887219 Administrator 1650887219 Administrator 任现职务时间 varchar(100) 100 8B4C3D06-F31D-4071-AE1F-10A4C4076DC1 现职级 jcgb_zj 1650887219 Administrator 1650887219 Administrator 现职级 varchar(100) 100 1299FBC0-DD8D-4306-8DBF-78A8F7B2F98D 任现职级时间 jcgb_zjsj 1650887219 Administrator 1650887219 Administrator 任现职级时间 varchar(100) 100 D10D3DB0-29D4-48C0-B0CE-5951C18663CD 政治面貌 jcgb_zzmm 1650887219 Administrator 1650887219 Administrator 政治面貌，数据字典 varchar(100) 100 07E2E2E4-5AA0-4212-AB1E-91FD3E69BFF9 受处分情况 jcgb_scf 1650887219 Administrator 1650887219 Administrator 受处分情况 varchar(1000) 1000 DFF6031A-9C10-4439-A6D4-2727F5E5B025 工作单位 jcgb_gzdw 1650887219 Administrator 1650887219 Administrator 工作单位 varchar(200) 200 4982B6BE-7F3D-48DD-AE4B-E07EE81CC716 是否单位省级“两代表一委员” jcgb_dbwy 1650887219 Administrator 1650887219 Administrator 是否单位省级“两代表一委员”，数据字典，是否 varchar(100) 100 20A13FAE-993D-47F4-87D0-4BC2E089D976 是否领办创办合作社 jcgb_hzs 1650887219 Administrator 1650887219 Administrator 是否领办创办合作社，数据字典是否 varchar(100) 100 6A2EF57A-A165-454F-9F16-12E1E6F28D9D 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 43C4A931-0825-4D15-A894-6DF5D1702B66 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 4C5E09BF-73D4-4448-82EA-344FFE0ED58E 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 1BE3035A-AE2F-4A1A-97CC-3FB7D0879E03 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 172AD4E8-2BF0-4A66-A2BA-A20A694E4598 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 44C032E0-EE8E-42AF-9CD6-94871478B83C 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 D1CC4C58-7B61-40DF-9329-A8FEB2E401E3 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 D6A09A30-CFF8-4B68-96FF-66097D115B90 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 84D4CE78-3C8F-4744-835A-5BA27889EF1B 党规党章信息表 zhsq_dgdz 1650887219 Administrator 1650903422 Administrator 党规党章信息表 74CAABBF-BE92-45A8-BEE9-A45C03A60676 党规党章信息主键ID dgdz_id 1650887219 Administrator 1650887219 Administrator 党规党章信息主键ID bigint 1 DA114ECE-4494-459E-BF1B-D3E4932CE124 标题 dgdz_title 1650887219 Administrator 1650887219 Administrator 标题 varchar(100) 100 0CDCEA24-F69B-4D81-9358-62ABF813E1FA 内容 dgdz_content 1650887219 Administrator 1650887219 Administrator 内容 longtext BCA64935-6B9D-4112-9B20-6C83F36F5BE4 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int A827C5FC-8344-4472-99D7-617759D0EA84 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 0A73303D-2C06-4A50-92FF-21384CBE7482 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 A7B1775F-4006-4E17-A0C4-EEBB4448712F 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 82A349DF-2726-4F0F-A869-63429A1DE8E2 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 5F209643-BBAB-4D70-95E0-4ECA696D760B 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 54A9CFAA-950C-4855-844C-2689FE148DF3 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 0D1E88DC-6F1E-4EA7-A8A4-2AC346CE14E8 所属党组织ID party_id 1650887219 Administrator 1650903422 Administrator 所属党组织ID bigint B5C4E61E-5F6C-47D3-B96F-DF90BADCF2B7 所属党组织名称 party_name 1650903381 Administrator 1650903422 Administrator varchar(100) 100 17D88F7B-8B7D-4761-B88A-1374BBF80850 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 288DA2E3-2993-4384-BF41-30B3884A6E07 党建资讯 zhsq_djzx 1650887219 Administrator 1650903513 Administrator 党建资讯 547D60FB-44AC-4B9B-8520-4D5A55298305 党建资讯信息主键ID djzx_id 1650887219 Administrator 1650887219 Administrator bigint 1 4EBC41C8-FD28-4642-B0E1-62BD27520C53 标题 djzx_title 1650887219 Administrator 1650887219 Administrator varchar(100) 100 0BB6272D-2D7D-4005-B20B-2DEB035041A8 内容 djzx_content 1650887219 Administrator 1650887219 Administrator longtext E73FA801-53FC-4950-90AA-E9F1A0A90956 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int A2BBE6BC-3E6D-4BF8-BC0F-844999AAAFE2 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 8F970754-682C-410B-A476-9257163AB9F8 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 A528566A-E4D7-4A22-8939-E1C968909400 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 F055EDB9-FE65-456C-A217-AECB62D2E55C 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 0730940E-817E-449B-99BB-31B68926E7B7 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 F617E7EA-09CB-4595-A5A2-040F2509BE4D 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 13BB5531-8328-4C09-BD48-0873357D4707 所属党组织ID party_id 1650887219 Administrator 1650903513 Administrator 所属党组织ID bigint B69C5FE3-6CB4-4963-8B84-31B83B6945D2 所属党组织名称 party_name 1650903476 Administrator 1650903513 Administrator varchar(100) 100 17AB3412-8CC4-47F8-BEBB-95126AF7492E Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 719B89CD-EFE7-486A-900B-7CFB87A4EA39 活动宣传信息表 zhsq_hdxc 1650887219 Administrator 1650903472 Administrator 活动宣传信息表 FE9CBEE1-56CD-47E3-AC58-E026F15F63FF 活动宣传信息主键ID hd_id 1650887219 Administrator 1650887219 Administrator 活动宣传信息主键ID bigint 1 1CA9040D-FD18-4709-B042-4F408651F13E 标题 hd_title 1650887219 Administrator 1650887219 Administrator 标题 varchar(100) 100 DBD7A175-04A1-43F6-8B6D-72E32503DF97 内容 hd_content 1650887219 Administrator 1650887219 Administrator 内容 longtext A13B5C21-C50E-42D4-ADAD-FD4EE65CA6ED 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int DCC9CC84-1909-4AB4-B066-AE2128110DDD 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 5EF3B879-78E5-4C68-A29F-8E13C24D6435 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 ACC50A4B-7747-4227-9611-2C3B891EA932 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 7ADA2B96-1D67-4F38-BF01-31F2D72EF245 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 8D582071-DF82-4A02-BF69-619C7A0E25E9 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 0B198F1E-33FD-4EA4-9B71-9B87F8C848B1 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 55E5D2C5-4831-4E6E-B61C-E9EBD28C1F46 所属党组织ID party_id 1650887219 Administrator 1650903472 Administrator 所属党组织ID bigint 47CB4007-8FC6-48C2-BD0E-4282FFA927F5 所属党组织名称 party_name 1650903439 Administrator 1650903472 Administrator varchar(100) 100 FFC65211-DF50-4A73-A5D2-1A5274A83F60 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator F3A2E670-42A8-4319-A226-3700809B14CA 党组织活动信息表 zhsq_dzzhd 1650887219 Administrator 1650903151 Administrator 党组织活动信息表 385E4338-49BF-4966-B401-549AD79607AC 党组织活动信息主键ID dzzhd_id 1650887219 Administrator 1650887219 Administrator 党组织活动信息主键ID bigint 1 3C0BC103-27DD-4E91-8B4E-61487BE0FDFD 活动类别 dzzhd_type 1650887219 Administrator 1650887219 Administrator 活动类别，数据字典，自定义 varchar(100) 100 A3AC2642-83B9-4B6B-BDCD-DBC22D4DFAC5 活动标题 dzzhd_title 1650887219 Administrator 1650887219 Administrator 活动标题 varchar(100) 100 211DFE22-47DE-463C-9988-81024AF7FFB8 活动开展日期 dzzhd_date 1650887219 Administrator 1650887219 Administrator 活动开展日期 varchar(100) 100 642962ED-FABD-4205-8196-1F4B95283446 活动地点 dzzhd_didian 1650887219 Administrator 1650887219 Administrator 活动地点 varchar(100) 100 5E644D40-64CD-468D-A46C-81D8EC0DB726 活动主要内容 dzzhd_content 1650887219 Administrator 1650887219 Administrator 活动主要内容 longtext F37F8F16-8019-43F3-8F5D-5E349192DC77 开展活动部门ID party_id 1650887219 Administrator 1650903106 Administrator 开展活动部门ID bigint E874B1E0-3CA9-4313-809A-D9AAB784E328 开展活动部门名称 party_name 1650903061 Administrator 1650903151 Administrator varchar(100) 100 A19A7EB4-2A38-4B5D-B61D-6119B07CA3A2 评审组织ID dzzhd_ps_party_id 1650887219 Administrator 1650903151 Administrator 评审组织ID bigint 603FCC86-DC3B-4ECB-AF7E-2B43F69B95AE 评审组织名称 dzzhd_ps_party_name 1650903106 Administrator 1650903151 Administrator varchar(100) 100 667127FA-425B-49E9-9BCF-5591669F7A64 活动状态 dzzhd_state 1650887219 Administrator 1650887219 Administrator 活动状态，数据字典：开展活动待评审评审结束 varchar(100) 100 5A9DE56A-4D16-4D62-B62A-9F7B006534B3 附件 dzzhd_file 1650887219 Administrator 1650887219 Administrator longtext A02AA45C-629C-4F60-B2C9-E70CC5074D6F 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 32A39CF3-2E53-4BA2-83F8-9FDEF2B078F1 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 12C2DE05-4F20-4454-A076-B9C44C846549 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 6F295EC9-4F3E-48D3-85E4-097F50F644DF 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 78DF7C14-DEBF-49EF-9C31-6CDDB8CC15FC 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 100DEEDC-B708-406B-8AF8-D893120FD723 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 5B30961C-7BAA-4435-8A37-8F310440C629 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 99981ED6-2869-4FD7-8C91-8D53E7E324DF Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 8C83654B-B5F6-4397-9D76-7F09495ED291 活动评审信息表 zhsq_hdps 1650887219 Administrator 1650903217 Administrator 活动评审信息表 6E442403-BA73-4F78-8BCB-6DBC957F653A 活动评审信息表主键ID hdps_id 1650887219 Administrator 1650887219 Administrator 活动评审信息表主键ID bigint 1 6158FE3F-63AB-4AAC-8D9C-DF43186B01BE 党组织活动信息主键ID dzzhd_id 1650887219 Administrator 1650887219 Administrator 党组织活动信息主键ID bigint 735843C0-D0A5-4520-A403-6913FB141098 评审组织ID hdps_party_id 1650887219 Administrator 1650903217 Administrator 评审组织ID bigint 116D59BF-0003-4A4E-84EB-B681F234F7CB 评审组织名称 hdps_party_name 1650903174 Administrator 1650903217 Administrator varchar(100) 100 75DBFABD-7608-431A-8AC8-82B997E3422D 评审纪要 hdps_jy 1650887219 Administrator 1650887219 Administrator 评审纪要 longtext 4B214BB8-5623-432F-9240-4FC5F503F453 评审意见 hdps_yj 1650887219 Administrator 1650887219 Administrator 评审意见 longtext 687DE06E-E7A4-4878-B6F3-2100624741F7 评审时间 hdps_sj 1650887219 Administrator 1650887219 Administrator 评审时间 varchar(100) 100 F264CA42-3166-4D3E-80AA-5E702E1E3C13 参与人 hdps_cyr 1650887219 Administrator 1650887219 Administrator 参与人 varchar(1000) 1000 ECEC8FCA-B7D8-4C41-BBAC-31CEA079BAB1 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 3AE96E46-82D8-4DEB-8211-8B0B5AF48BE6 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 6CD508EA-2AE8-48A1-9DEC-2FD3BE80D9EB 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 A3B60590-9331-4663-8410-A5A17BAD145D 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 32F9BD69-FD00-49E4-9E0A-64E8A4D6E851 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 2514F68D-BA31-4D41-A674-F2CD4255FFDC 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 7B7B4AA6-A77A-4440-95FD-C3897C639FB0 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 AC66A6CF-1426-4FF9-8585-440E863844C8 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator EC20C6E8-21AC-46B2-BB6C-BF8EACBDD347 工作布置信息表 zhsq_gzbz 1650887219 Administrator 1650903350 Administrator 工作布置信息表 7DF8C744-654C-405F-80A4-EED48F3BF407 工作布置信息主键ID gzbz_id 1650887219 Administrator 1650887219 Administrator 工作布置信息主键ID varchar(100) 100 1 998400B9-64E0-47DD-AD74-E3FD61D7A3ED 任务名称 gzbz_title 1650887219 Administrator 1650887219 Administrator 任务名称 varchar(100) 100 0664495D-6BBC-43A1-9915-CC0DFA2CBD8F 任务类别 gzbz_type 1650887219 Administrator 1650887219 Administrator 任务名称，数据字典 varchar(100) 100 1518869B-D34D-4082-AB60-918A8BAF49B3 任务内容 gzbz_content 1650887219 Administrator 1650887219 Administrator 任务内容 longtext 203EAB61-E836-4785-B61D-75FAF1CCF418 开始时间 gzbz_str_time 1650887219 Administrator 1650887219 Administrator 开始时间 varchar(100) 100 DA992B20-B492-453E-9E9C-8B2DC5F2B358 结束时间 gzbz_end_time 1650887219 Administrator 1650887219 Administrator 结束时间 varchar(100) 100 232D3A7A-EF7E-4933-8D17-75314FB2B778 附件 gzbz_file 1650887219 Administrator 1650887219 Administrator 附件 longtext 9BA330A4-A401-413F-B164-E8A770FC5AA6 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 047AA543-7479-4827-8120-85E4131B0D20 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 032E89AE-731D-4C00-A70A-B2B516E38412 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 EA6E047B-8544-45DF-AA71-0B2C8FE8B19C 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 39F99DBC-4B52-4279-95F0-2E132C752909 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 05F9D9F0-6380-4771-A62B-3E61B119CA33 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 3C537EA7-0158-4B40-88CA-CA5FC08198D8 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 69BDE32D-92AF-460C-98D5-37617869FA9A 工作布置部门ID gzbz_party_id 1650887219 Administrator 1650903350 Administrator 工作布置部门ID bigint 7FB52342-D510-45E0-9911-A66D81D41CD8 工作布置部门名称 gzbz_party_name 1650903302 Administrator 1650903370 Administrator varchar(100) 100 C5D5FB2A-0660-4F00-AF0D-E61E4D921249 工作状态 gzbz_state 1650887219 Administrator 1650887219 Administrator 工作状态新建已布置 int 750F6B8B-3E42-41BC-B2A1-5ED5591DC635 通用附件 file_object 1650887219 Administrator 1650887219 Administrator varchar(2000) 2000 20B6F08B-9894-4E45-A7F8-8BF1C2419EDE Key_1 Key_1 1650887219 Administrator 1650887219 Administrator A21E5844-C989-4B8B-B5AC-5913B2A323D3 工作布置完成情况信息表 zhsq_gzbz_wc 1650887219 Administrator 1650903277 Administrator 工作布置完成情况信息表 8BF937AA-60BD-4260-873D-AD7AD7A9FA80 工作布置完成信息主键ID wc_id 1650887219 Administrator 1650887219 Administrator 工作布置完成信息主键ID bigint 1 D167EF80-CCFA-47B0-A899-6A0DF28F3C62 工作布置信息主键ID gzbz_id 1650887219 Administrator 1650887219 Administrator 工作布置信息主键ID bigint 5A780764-4A69-45D2-AB06-31155E31C1FA 执行组织ID party_id 1650887219 Administrator 1650903277 Administrator 执行组织ID bigint 7A11236E-53DD-433E-A7DB-D2432479EDA8 执行组织名称 party_name 1650903234 Administrator 1650903277 Administrator varchar(100) 100 6C91DE0B-674F-4C9F-8B85-4D47E53E159B 任务完成状态 wc_state 1650887219 Administrator 1650887219 Administrator 任务完成状态，数据字典未完成已完成 varchar(100) 100 951572ED-0688-4DA7-BD09-147CEBF8C808 完成时间 wc_wcsj 1650887219 Administrator 1650887219 Administrator 完成时间 varchar(100) 100 2E62D0C7-44DC-4B06-8E35-A721AA3FC6F8 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int FE73857A-E7B5-4FF3-B5EF-7CEC6D0EA510 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 422022F0-9554-4B68-88F9-2A00CE9BDB15 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 AE0950B7-3817-41D8-BDC0-9F813A5FDFE0 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 849C2149-98F7-44EF-BFDB-84687F2C329B 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 4AE6417B-CEC2-433C-B915-E8AE4B1933C3 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 D8FFB0DF-57A7-4321-A03D-9718EAE2A99F 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 62C31D86-6C58-4475-A847-9D00E748BA50 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator BAB0D8A9-A0BD-4DB7-AFD9-C40528CDD003 人口残联信息 zhsq_per_canji 1650887219 Administrator 1650887219 Administrator 人口残联信息 6A41D8ED-E568-4F76-858A-F609F2EDD885 人口残联信息主键ID id 1650887219 Administrator 1652321556 Administrator 人口残联信息主键ID varchar(32) 32 1 25EC757D-2928-490D-A446-33E2A1E15E3A 人口信息主键ID per_id 1650887219 Administrator 1652321556 Administrator 人口信息主键ID varchar(32) 32 AE084287-61F9-4B79-916E-E4A3D39E3F84 残疾人证等级 canji_cjz 1650887219 Administrator 1650887219 Administrator 残疾人证等级 varchar(100) 100 70529CB5-4B6B-45E1-A1CC-A1AFCBC14A80 残疾种类 canji_type 1650887219 Administrator 1650887219 Administrator 残疾种类 varchar(100) 100 1F2FBADA-19D5-4815-B23B-F618231426AA 是否享受重度残疾人补贴情况 canji_bt 1650887219 Administrator 1650887219 Administrator 是否享受重度残疾人补贴情况，数据字典 varchar(2) 2 2528B338-86E0-4E7A-9A15-5403449252C7 是否居家关爱巡防对象 canji_sfxf 1650887219 Administrator 1650887219 Administrator 是否居家关爱巡防对象,数据字典 varchar(2) 2 CF0A739F-B9C3-4758-8C2B-DE8DBCCD688C 巡防频次 canji_xfpc 1650887219 Administrator 1650887219 Administrator 巡防频次 varchar(100) 100 A9E0FE03-CD33-468B-8545-9ADD3C41282E Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 6CE9E3B9-A3B6-4D7B-86BD-490FFAA37E0F 人口军人信息表 zhsq_per_junren 1650887219 Administrator 1650887219 Administrator 人口军人信息表 BC01D8A9-5B8F-4A52-AD4E-2D0B1EB132E1 人口军人信息表主键ID id 1650887219 Administrator 1652321575 Administrator 人口军人信息表主键ID varchar(32) 32 1 9C43554B-11D1-4834-BDD6-883C7D91EDA8 人口信息主键ID per_id 1650887219 Administrator 1652321575 Administrator 人口信息主键ID varchar(32) 32 D6E2098D-F27C-4EC2-B706-A02B8ED2BF4C 状态 junren_state 1650887219 Administrator 1650887219 Administrator 状态 varchar(2) 2 A22204E2-87F5-4D3E-AE6E-5BF23FDA256C 是否为优抚对象 junren_sfyf 1650887219 Administrator 1650887219 Administrator 是否为优抚对象 varchar(100) 100 F35F20D3-91B2-482A-909B-B8910389BC4F 优抚种类 junren_yfzl 1650887219 Administrator 1650887219 Administrator 优抚种类 varchar(100) 100 569EB118-4275-4BE8-BEA3-B480D211E1E9 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator CE761205-3005-42B1-97FA-A343DD2FB215 人口新冠疫苗接种情况表 zhsq_per_ncov 1650887219 Administrator 1650887219 Administrator 人口新冠疫苗接种情况表 F5D2E054-96FD-4BC4-8CF4-BB2E3FD00625 疫苗信息主键ID id 1650887219 Administrator 1652321619 Administrator 疫苗信息主键ID varchar(32) 32 1 14F0EB4D-19F3-4850-8A42-CE5B9B13D307 人口信息主键ID per_id 1650887219 Administrator 1652321619 Administrator 人口信息主键ID varchar(32) 32 8626519F-7B48-4FE9-B384-E21CB1DABA4B 是否接种第一针 ym_one_is 1650887219 Administrator 1650887219 Administrator 是否接种第一针,数据字典 varchar(2) 2 A46B9065-86DD-45B6-B719-4F78FF088957 第一针接种时间 ym_one_date 1650887219 Administrator 1650887219 Administrator 第一针接种时间 varchar(100) 100 751C5D44-EB82-4380-8CAC-36AB06C550BC 第一针疫苗种类 ym_one_type 1650887219 Administrator 1650887219 Administrator 第一针疫苗种类，数据字典 varchar(2) 2 1432DF85-D212-4EA0-AC52-654247744C68 第一针接种地点 ym_one_place 1650887219 Administrator 1650887219 Administrator 第一针接种地点 varchar(100) 100 2BA9FCCE-8D29-4BE6-8419-8CDCDCF54C52 是否接种第二针 ym_two_is 1650887219 Administrator 1650887219 Administrator 是否接种第二针 varchar(2) 2 DA339C33-53FA-4186-A29B-29CDD8392A67 第二针接种时间 ym_two_date 1650887219 Administrator 1650887219 Administrator 第二针接种时间 varchar(100) 100 FC7A0724-F43F-46BE-81D1-F976FBD26090 第二针接种疫苗种类 ym_two_type 1650887219 Administrator 1650887219 Administrator 第二针接种疫苗种类 varchar(2) 2 CD20EC0C-157F-4C5E-B02D-FE2733301A3F 第二针接种地点 ym_two_place 1650887219 Administrator 1650887219 Administrator 第二针接种地点 varchar(100) 100 B1D7242D-9D5C-4BE7-AA4A-F229D9A89C35 是否已接种第三针 ym_three_is 1650887219 Administrator 1650887219 Administrator 是否已接种第三针 varchar(2) 2 1CA4F46B-0C1A-41A4-94DF-3871925BA885 第三针接种时间 ym_three_date 1650887219 Administrator 1650887219 Administrator 第三针接种时间 varchar(100) 100 B8C096D1-1A3E-46BD-AA10-E244B823B6F1 第三针接种疫苗种类 ym_three_type 1650887219 Administrator 1650887219 Administrator 第三针接种疫苗种类 varchar(2) 2 691F31CB-1DD2-4CA5-8790-4F5645B83808 第三针接种地点 ym_three_place 1650887219 Administrator 1650887219 Administrator 第三针接种地点 varchar(100) 100 B0D5E88A-6FA8-42AC-9DC9-CEAE56579878 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator E95E3D14-1CD3-450B-8181-24E74BD672F7 人口-低保信息表 zhsq_per_dibao 1650887219 Administrator 1650887219 Administrator 人口-低保信息表 9CA1D748-2966-450D-970F-6F80789251C2 低保信息主键ID id 1650887219 Administrator 1652321829 Administrator 低保信息主键ID varchar(32) 32 1 677265EC-430B-4381-A863-4AAD36EEA4A0 人口信息主键ID per_id 1650887219 Administrator 1652321829 Administrator 人口信息主键ID varchar(32) 32 D676C933-FEE8-4059-A1AB-FAAAFCF1069C 是否重病 db_sfzb 1650887219 Administrator 1650887219 Administrator 是否重病,数据字典 varchar(2) 2 D47495C4-5108-4C54-ADCA-CDAFAC353E7C 是否重残 db_sfzc 1650887219 Administrator 1650887219 Administrator 是否重残，数据字典 varchar(2) 2 8817A882-791E-48FC-8D4A-D88DCC6CF21D 现住地 db_xzz 1650887219 Administrator 1650887219 Administrator 现住地 varchar(100) 100 A94EFE40-6937-4D3D-B873-BC57219B04DD 家庭情况 db_jt 1650887219 Administrator 1650887219 Administrator 家庭情况 varchar(100) 100 145AE191-32FA-401F-B57D-981279C9AB3F 是否集中供养 db_sfjzgy 1650887219 Administrator 1650887219 Administrator 是否集中供养，数据字典 varchar(2) 2 B6A2187A-7FE0-4983-AAF3-C2F10AB9CB71 是否分散供养 db_sffsgy 1650887219 Administrator 1650887219 Administrator 是否分散供养，数据字典 varchar(2) 2 14113C25-FE07-4AB5-A33A-0DC83AEA045B 监护人 db_jhr 1650887219 Administrator 1650887219 Administrator 监护人 varchar(100) 100 3D4770CF-A466-4AD0-97A6-847605525DB5 监护人现住址 db_jhrzz 1650887219 Administrator 1650887219 Administrator 监护人现住址 varchar(100) 100 962DA961-6942-43CA-B217-B9BF87FDEA57 监护人与本人关系 db_gx 1650887219 Administrator 1650887219 Administrator 监护人与本人关系，数据字典 varchar(2) 2 5C5DAC58-CBCC-4D49-9542-3DE6274F6514 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 009464AE-646A-4F5A-B8A8-A582906B20FF 老龄人口信息表 zhsq_per_llr 1650887219 Administrator 1650887219 Administrator 老龄人口信息表 AE5C0668-AAE1-491D-8D95-40B3D7225FD4 老龄信息主键ID id 1650887219 Administrator 1652321636 Administrator 老龄信息主键ID varchar(32) 32 1 0BE9FE70-1516-4B91-B182-E77B291B8769 人口信息主键ID per_id 1650887219 Administrator 1652321636 Administrator 人口信息主键ID varchar(32) 32 68245F77-D5BC-4FAA-8843-78875EB58871 是否享受政府购买服务 llr_zfgm 1650887219 Administrator 1650887219 Administrator 是否享受政府购买服务，数据字典 varchar(2) 2 FE2C8504-7BE3-443F-9FEB-4BB0EB899706 享受高龄津贴情况 llr_gljt 1650887219 Administrator 1650887219 Administrator 享受高龄津贴情况，数据字典无 200 400 600 varchar(2) 2 33F1081C-D292-4CAF-BC19-DBB469403655 是否空巢 llr_sfkc 1650887219 Administrator 1650887219 Administrator 是否空巢，数据字典 varchar(2) 2 60D2CF4A-D8A8-4328-B045-BF4A04317106 失能情况 llr_snqk 1650887219 Administrator 1650887219 Administrator 失能情况，数据字典 varchar(2) 2 02CE5E1F-D6F7-4648-B9A8-30FE2B4F2D78 是否居家巡防重点对象 llr_sfzdxf 1650887219 Administrator 1650887219 Administrator 是否居家巡防重点对象，数据字典 varchar(2) 2 E52AF5F3-E575-40EE-84A5-72353951FAB9 家庭情况 llr_jtqk 1650887219 Administrator 1650887219 Administrator 家庭情况 varchar(100) 100 D1284F12-9AE6-470D-927D-A82B0DB221F7 巡防频次 llr_xfpc 1650887219 Administrator 1650887219 Administrator 巡防频次 varchar(100) 100 06997A4D-59CC-41CD-A74E-151C6B0FEA27 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator AC950C2E-3B83-418F-A957-2E57FCB5EC3E 人口-计生特殊扶助信息表 zhsq_per_js 1650887219 Administrator 1650887219 Administrator 人口-计生特殊扶助信息表 08E83CC9-894B-47AD-9DD1-3C2551E5F966 计生信息主键ID id 1650887219 Administrator 1652321661 Administrator 计生信息主键ID varchar(32) 32 1 D8337E9B-AE65-4776-A5A5-EB01E8873667 人口信息主键ID per_id 1650887219 Administrator 1652321661 Administrator 人口信息主键ID varchar(32) 32 44DAFEDE-E57D-4511-9A81-5DF9BED26B10 初婚时间 js_chsj 1650887219 Administrator 1650887219 Administrator 初婚时间 varchar(100) 100 9D9BBEAE-FA2A-40D4-9764-82862DFA2529 再婚时间 js_zhsj 1650887219 Administrator 1650887219 Administrator 再婚时间 varchar(100) 100 87EC05A6-E010-4E9B-8DD6-05A26DAB6733 避孕措施 js_bycs 1650887219 Administrator 1650887219 Administrator 避孕措施 varchar(100) 100 16765743-0BA3-4E3B-9FCA-9FE274508D26 独生子女是否死亡 js_dsznsw 1650887219 Administrator 1650887219 Administrator 独生子女是否死亡,数据字典 varchar(2) 2 3411E57C-E1B3-4598-8C2F-2215F16F3A31 独生子女是否残疾 js_dszncj 1650887219 Administrator 1650887219 Administrator 独生子女是否残疾，数据字典 varchar(2) 2 A9F0BF6E-00C1-4C2C-A26C-16376301D67C 扶助账号 js_fzzh 1650887219 Administrator 1650887219 Administrator 扶助账号 varchar(100) 100 B672215F-7EB9-44DF-9E12-04A9492CFC61 是否困难家庭妇女儿童 js_sfkn 1650887219 Administrator 1650887219 Administrator 是否困难家庭妇女儿童，数据字典 varchar(2) 2 8CAE4347-0DDB-4D16-B8E9-003FF36D6145 是否孤儿 js_sfge 1650887219 Administrator 1650887219 Administrator 是否孤儿，数据字典 varchar(2) 2 BF1B00A6-0B92-4CB5-B4D7-C0966B02BA63 监护人 js_jhr 1650887219 Administrator 1650887219 Administrator 监护人 varchar(100) 100 162981C0-C3F3-4CB4-B211-975315695807 监护人与本人关系 js_gx 1650887219 Administrator 1650887219 Administrator 监护人与本人关系，数据字典 varchar(2) 2 D990637D-20B5-4B3A-A9F4-67AB14DA7923 是否事实无抚养儿童 js_sfsswfyet 1650887219 Administrator 1650887219 Administrator 是否事实无抚养儿童，数据字典 varchar(2) 2 81CB1BFD-0D02-4773-A2B4-BE3B0D05DBBC 家庭情况 js_jtqk 1650887219 Administrator 1650887219 Administrator 家庭情况 varchar(100) 100 827E625B-E14A-4AFF-A322-7BBA0602C9B1 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 98A335C5-4106-4CF2-89F0-BD8312146184 人口-保险信息表 zhsq_per_bx 1650887219 Administrator 1650887219 Administrator 人口-保险信息表 C0C6049D-1155-408F-B60C-D4B471067AD0 保险信息主键ID id 1650887219 Administrator 1652321777 Administrator 保险信息主键ID varchar(32) 32 1 0493397F-6B88-4587-B517-4BDB87AAACDB 人口信息主键ID per_id 1650887219 Administrator 1652321777 Administrator 人口信息主键ID varchar(32) 32 36D37507-77C1-49E4-844E-93923E505182 城职保是否参保 bx_czb_yanglao_sfcb 1650887219 Administrator 1650887219 Administrator 城职保是否参保，数据字典 varchar(2) 2 CC86DDB3-C9D2-4BBC-B3A7-6C8FE65E9905 城职保参保时间 bx_czb_yanglao_cbsj 1650887219 Administrator 1650887219 Administrator 城职保参保时间 varchar(100) 100 FE5C7099-7E3F-4205-80EF-5F496A20595E 城职保是否享待 bx_czb_yanglao_sfxd 1650887219 Administrator 1650887219 Administrator 城职保是否享待，数据字典 varchar(2) 2 0E4B1619-43D2-4394-8707-0439E71D7049 城居保是否参保 bx_cjb_yanglao_sfcb 1650887219 Administrator 1650887219 Administrator 城居保是否参保，数据字典 varchar(2) 2 7FE50E2F-6372-41E2-9067-ACE4CDDAC73F 城居保参保时间 bx_cjb_yanglaol_cbsj 1650887219 Administrator 1650887219 Administrator 城居保参保时间 varchar(100) 100 FECE08A6-4194-442F-970E-3538FC5F7F47 城居保是否享待 bx_cjb_yanglao_sfxd 1650887219 Administrator 1650887219 Administrator 城居保是否享待，数据字典 varchar(2) 2 42311015-FBF1-4CD2-9547-531458C4E188 城镇职工医疗保险是否参保 bx_czb_yiliao_sfcb 1650887219 Administrator 1650887219 Administrator 城镇职工医疗保险是否参保，数据字典 varchar(2) 2 D278BFE6-88C7-4A61-BA56-2A2CDC858DF8 城镇职工医疗保险参保时间 bx_czb_yiliao_cbsj 1650887219 Administrator 1650887219 Administrator 城镇职工医疗保险参保时间 varchar(100) 100 D4F403B6-E931-4153-99E7-8E9F256E6347 城镇职工医疗保险停保时间 bx_czb_yiliao_tbsj 1650887219 Administrator 1650887219 Administrator 城镇职工医疗保险停保时间 varchar(100) 100 61FCBC71-FB6F-49C5-83D8-546E4E491113 城镇居民医疗保险是否参保 bx_cjb_yiliao_sfcb 1650887219 Administrator 1650887219 Administrator 城镇居民医疗保险是否参保，数据字典 varchar(2) 2 11552B16-CD53-4501-88A8-751D0BB85AB9 城镇居民医疗保险参保时间 bx_cjb_yiliao_cbsj 1650887219 Administrator 1650887219 Administrator 城镇居民医疗保险参保时间 varchar(100) 100 E31DA28F-FC8B-4129-8500-92FCB2886061 城镇居民医疗保险停保时间 bx_cjb_yiliao_tbsj 1650887219 Administrator 1650887219 Administrator 城镇居民医疗保险停保时间 varchar(100) 100 B286333F-B4F1-4D6D-A454-0AE937AA45D8 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 369AE619-8642-45D8-9770-D932233AB7AF 人口-流动人口信息表 zhsq_per_liudong 1650887219 Administrator 1650887219 Administrator 人口-流动人口信息表 F1A057D4-E614-4C38-83F4-D4937793334B 流动人口信息主键 id 1650887219 Administrator 1652321842 Administrator 流动人口信息主键 varchar(32) 32 1 D0356A1A-DE5B-4289-AC2D-5539E92DB242 人口信息主键ID per_id 1650887219 Administrator 1652321842 Administrator 人口信息主键ID varchar(32) 32 3AD50AC0-ABD9-4E2D-A5D5-74490A95B21C 流入地址 liudong_liuru 1650887219 Administrator 1650887219 Administrator 流入地址 varchar(200) 200 8155FCBF-23E1-457D-A564-BD23D7D3433F 流出地址 liudong_liuchu 1650887219 Administrator 1650887219 Administrator 流出地址 varchar(200) 200 C59ABF9B-D6FA-468D-B0E1-754C082FC35E 流动类型 liudong_type 1650887219 Administrator 1650887219 Administrator 流动类型,数据字典流入流出 varchar(2) 2 F0D44E8D-1518-4A96-A6F0-01FB9154F96E 备注 liudong_remarks 1650887219 Administrator 1650887219 Administrator 备注 varchar(1000) 1000 F6E299F8-F8DE-455D-B688-57C70F841A46 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 94128032-F555-46FA-9ABB-4E619032EEFD 人才信息表 zhsq_talentinfo 1650887219 Administrator 1650887219 Administrator 人才信息表 8326F669-EF75-4A63-BF73-00A1AB81EB04 人才信息主键ID talent_id 1650887219 Administrator 1650887219 Administrator 人才信息主键ID bigint 1 60E236B0-722A-4ECF-9B95-0E3C053BC3F7 姓名 talent_name 1650887219 Administrator 1650887219 Administrator 姓名 varchar(100) 100 776056BA-7636-4D76-8C2E-DC34BB868B0D 性别 talent_sex 1650887219 Administrator 1650887219 Administrator 性别 varchar(2) 2 139D6E77-04BE-49B8-B5C1-D6AC6E6570C2 出生年月 talent_birth 1650887219 Administrator 1650887219 Administrator 出生年月 varchar(100) 100 7C9D0444-37DD-4668-A086-7BA0C8A040CD 民族 talent_nation 1650887219 Administrator 1650887219 Administrator 民族 varchar(2) 2 73546A1D-FC36-4294-9FD1-ECE110D2075C 籍贯 talent_jiguan 1650887219 Administrator 1650887219 Administrator 籍贯 varchar(100) 100 B6906B96-C4D8-460E-B669-0EDD1536F14A 政治面貌 talent_political 1650887219 Administrator 1650887219 Administrator 政治面貌 varchar(2) 2 748FAB72-8447-4A17-98C2-2E7498056E68 全日制毕业院校 talent_qrz_school 1650887219 Administrator 1650887219 Administrator 全日制毕业院校 varchar(100) 100 004C9A45-EC4D-4E61-9378-5A852E875913 全日制学历 talent_qrz_degree 1650887219 Administrator 1650887219 Administrator 全日制学历 varchar(2) 2 77A9BD35-AD5C-4924-A79F-6AE5A560B6D8 在职教育毕业院校 talent_zz_school 1650887219 Administrator 1650887219 Administrator 在职教育毕业院校 varchar(100) 100 6A4F4F18-0EA1-4734-AB8E-711DBB8030C9 在职教育学历 talent_zz_degree 1650887219 Administrator 1650887219 Administrator 在职教育学历 varchar(2) 2 83D3547C-5CCA-4EB9-875D-2B96132A40F5 工作单位及职务 talent_gzdw 1650887219 Administrator 1650887219 Administrator 工作单位及职务 varchar(200) 200 13F97565-110D-4ACC-B1AF-C9A83E76D85D 身份证号 talent_idcard 1650887219 Administrator 1650887219 Administrator 身份证号 varchar(20) 20 2779AE68-5314-4D42-835A-68EC583592F0 联系电话 talent_tel 1650887219 Administrator 1650887219 Administrator 联系电话 varchar(20) 20 CF7D335A-3EF3-41D4-B428-01AA08B86AD8 邮箱 talent_email 1650887219 Administrator 1650887219 Administrator 邮箱 varchar(100) 100 4D6D3904-65EB-4C6B-AFC7-4A1712704B8C 所属类别 talent_leibie 1650887219 Administrator 1650887219 Administrator 所属类别，数据字典：域内，域外 varchar(2) 2 5301D49F-8A96-4C5F-A743-16454A23C1C5 人才类型 talent_type 1650887219 Administrator 1650887219 Administrator 人才类型，数据字典高端智库人才高级专家人才党政人才企业经营人才专业技术人才高技能人才农村实用人才社会工作人才 varchar(2) 2 9EA4E1F0-E764-4E37-80D9-A4647DE72376 从业状况 talent_zk 1650887219 Administrator 1650887219 Administrator 从业状况 varchar(1000) 1000 0E74D370-A56F-49CD-A063-A3FF5E73D69F 从业领域 talent_ly 1650887219 Administrator 1650887219 Administrator 从业领域 varchar(1000) 1000 0E002EDD-00DB-49B5-AED9-B195C54E6E64 专业方向 talent_fx 1650887219 Administrator 1650887219 Administrator 专业方向 varchar(1000) 1000 C2434D92-92BF-481A-A70E-53EAF80BD412 获得荣誉情况 talent_ry 1650887219 Administrator 1650887219 Administrator 获得荣誉情况 varchar(1000) 1000 5CEA2E04-2CCE-449B-B4AE-05BA66D46B2C 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int CD15E29C-C3FD-460E-8883-268B6C4AE6AA 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint A0A6703D-CA35-48FC-8AFE-57140865262E 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 A74C168C-8915-48AF-8330-237D3D5C4E35 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 11D6ABD0-4367-4488-8391-64E89CBC3AA6 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 92CC863E-3158-4DD6-863A-7A8E1676CF0A 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 46851265-8C17-4ADD-9B2E-FF4D4E9E5857 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 12DCEC20-9D0E-4C90-9F57-7D0B3F049A38 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 306516AF-19F7-40B7-A2A7-F77E13FFB8FB 党群通知公告表 zhsq_dq_tzgg 1650887219 Administrator 1650887219 Administrator 党群通知公告表 A83013F1-D531-43C6-B773-19A957220864 党群通知公告主键ID dqtzgg_id 1650887219 Administrator 1650887219 Administrator 党群通知公告主键ID bigint 1 CAB97894-E1C7-45F3-8E92-69252870CBE7 标题 dqtzgg_title 1650887219 Administrator 1650887219 Administrator 标题 varchar(1000) 1000 0237AD28-63D2-4584-9981-869D6C0C8468 发布时间 dqtzgg_date 1650887219 Administrator 1650887219 Administrator 发布时间 varchar(100) 100 C45AAC4F-2570-473B-B061-9EE7C10D1574 类型 dqtzgg_type 1650887219 Administrator 1650887219 Administrator 类型,数据字典通知公告 varchar(2) 2 EA65D643-3A84-4FAF-A6CD-3F1CBF304A55 状态 dqtzgg_state 1650887219 Administrator 1650887219 Administrator 状态，数据字典新建发布 varchar(2) 2 D8C12501-C226-4D8B-B9B7-FB1736180114 内容 dqtzgg_content 1650887219 Administrator 1650887219 Administrator 内容 longtext 86290E94-A38E-4558-B5D5-762D1FC18288 通用附件 file_object 1650887219 Administrator 1650887219 Administrator 通用附件 varchar(2000) 2000 3CDBD2B1-80A0-44FC-A521-A7AC37692C1F 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int A7DD7414-C68F-4D97-BB19-731510815006 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 1BF943F4-E256-4801-8473-ADE377E17147 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 5176700B-D1E1-45C9-9C4C-6351EA2EB3DE 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 374695FE-0A1E-403B-98D6-60158FC05360 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 5AB30AE7-81C9-4568-8856-E79D8E940BF6 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 22C171DF-9E31-4EFB-BBC5-F11846D179E2 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator varchar(100) 100 986FDC20-4E6D-4EC0-939B-2AD41E703B6B Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 97F4F8EE-680C-4E0A-8522-489EB9614821 人口特殊属性关系映射表 zhsq_person_tsrq 1650887219 Administrator 1650887219 Administrator 人口特殊属性关系映射表 C59FA6B6-8103-4631-8679-4D972978DFE4 人员ID per_id 1650887219 Administrator 1652321328 Administrator varchar(32) 32 1 A74CCF47-8040-4C11-8AD0-4A1BFB8C9A8A 特殊人群字典ID tsrq_id 1650887219 Administrator 1650887219 Administrator bigint 1 89BCAF57-3F17-4C06-9452-7BEDB6165FBE Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 159A59A6-A6E8-41BB-837D-EBEB0B5C0914 网格员巡查轨迹日期表 zhsq_PatrolDate 1650887219 Administrator 1650887219 Administrator 网格员巡查轨迹日期表 FDEC82A6-4AC8-416C-8CB4-193BBAA7F0D4 巡查日期主键ID patroldate_id 1650887219 Administrator 1650887219 Administrator bigint 1 627B0E48-6E86-4A2D-B379-EC4FB707790C 巡查主键ID gps_id 1650887219 Administrator 1650887219 Administrator 巡查主键ID bigint 5B2D8942-89C5-4FD9-8B28-5CCB9AF49BEF 巡查日期 patroldate_date 1650887219 Administrator 1650887219 Administrator varchar(20) 20 4AD0A172-40D6-4683-8ABB-CF046CD80867 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 4F93A0C9-FEF9-4AEA-8009-86B61D12BBF3 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 010341F1-6745-4A1E-9C5F-56600DD48A3F 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 695F4CC5-18D0-4014-83F5-7DEE22DA4697 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 8407A12F-E279-454B-8F39-D2A8D593F73E 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 33E0F2A8-FC64-4562-832A-BC3D925AC35D 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 16D3C77D-4A0A-404D-A6D2-5AE67CA154C1 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 5E7D5A55-E3EC-422C-AF45-BB20F8C8E88A Key_1 Key_1 1650887219 Administrator 1650887219 Administrator F1490A4D-15DB-4765-A528-A18BFFC4C367 网格员巡查记录表 zhsq_patrolrecord 1650887219 Administrator 1650887219 Administrator 网格员巡查记录表 1D4FF9BE-4165-4CD0-AF74-E3CD59BCBE1C 巡查记录主键ID pd_id 1650887219 Administrator 1650887219 Administrator bigint 1 ED691D6B-F671-47D5-8236-99E121B1C968 巡查日期主键ID patroldate_id 1650887219 Administrator 1650887219 Administrator bigint 40C7DA4C-4EE0-4BE9-92C9-D7C499A9DDC4 巡查记录经度 pd_longitude 1650887219 Administrator 1650887219 Administrator varcahr(100) 100 972D24A1-D56B-42BD-BA70-F725B0C76CB4 巡查记录维度 pd_latitude 1650887219 Administrator 1650887219 Administrator varcahr(100) 100 6A0E9997-32C9-4BBB-9CB7-27E8C2D06E57 数据删除状态 del_flag 1650887219 Administrator 1650887219 Administrator 数据删除状态 0:有效 1：无效 int 304D48C7-C557-4152-B327-4505074A1B2F 数据创建人ID create_id 1650887219 Administrator 1650887219 Administrator 数据创建人ID bigint 206E3EFC-9A94-407A-BF43-802F25CE9A37 数据创建人姓名 create_user 1650887219 Administrator 1650887219 Administrator 数据创建人姓名 varchar(100) 100 63C1BE61-BB6A-4FBB-A4B0-805A89C698DC 数据创建时间 create_time 1650887219 Administrator 1650887219 Administrator 数据创建时间 varchar(100) 100 CC0806BF-74BF-4DA7-A097-CC75F40A4F6F 数据更新人 update_id 1650887219 Administrator 1650887219 Administrator 数据更新人 bigint 66E40A27-DE1F-4F8B-98EF-B00EB19DFB4C 数据更新时间 update_time 1650887219 Administrator 1650887219 Administrator 数据更新时间 varchar(100) 100 7E63CD11-2E6C-4999-B3E7-DFB0E2EA59F0 数据更新人姓名 update_user 1650887219 Administrator 1650887219 Administrator 数据更新人姓名 varchar(100) 100 BC5F3574-19D9-43E2-B35F-F49FDB882077 Key_1 Key_1 1650887219 Administrator 1650887219 Administrator 7054DE45-C681-448F-8D6E-CC8457A4CA2D Reference_1 Reference_1 1650887219 Administrator 1650887219 Administrator 0..* 1 1 2D92BD79-DBF6-4C83-A99E-AEDA6A0D5B23 1650887219 Administrator 1650887219 Administrator E5731296-123A-4BFD-B322-9C570F5E2B22 Reference_2 Reference_2 1650887219 Administrator 1650887219 Administrator 0..* 1 1 10697946-0E9A-4A7A-B1EE-81171CD525EB 1650887219 Administrator 1650887219 Administrator 84751B55-EE17-498B-941E-E36E4EB693E8 Reference_3 Reference_3 1650887219 Administrator 1650887219 Administrator 0..* 1 1 DC2FB486-1544-4432-A5B6-DA18B7E73CB3 1650887219 Administrator 1650887219 Administrator 702B9C98-88F5-4FAF-8DE6-84B55C7CFC4C Reference_4 Reference_4 1650887219 Administrator 1650887219 Administrator 0..* 1 1 40A501E9-A380-4D7E-A928-556ECFD8D250 1650887219 Administrator 1650887219 Administrator D386E26A-EC79-4498-97C4-967B3864277A Reference_5 Reference_5 1650887219 Administrator 1650887219 Administrator 0..* 1 1 9E9B0819-854C-4619-A76A-5E4F078EF276 1650887219 Administrator 1650887219 Administrator A0B47CC2-9115-4BE1-9033-B50DA91FF0FF Reference_6 Reference_6 1650887219 Administrator 1650887219 Administrator 0..* 1 1 4C48BAB8-2C07-4C79-BF36-7ACD21FC1121 1650887219 Administrator 1650887219 Administrator 628B7FC4-9E97-4747-B1A7-7FFB5C973ADA Reference_7 Reference_7 1650887219 Administrator 1650887219 Administrator 0..* 1 1 E74DB5A0-1421-431D-9CBC-80FA3264982B 1650887219 Administrator 1650887219 Administrator FBB21772-47D0-476B-87B8-9604C071465E Reference_9 Reference_9 1650887219 Administrator 1650887219 Administrator 0..* 1 1 6D586C29-2649-483B-91FF-948DA913D5EB 1650887219 Administrator 1650887219 Administrator F949853E-EA1A-4B01-B006-2BB6816CFA27 Reference_10 Reference_10 1650887219 Administrator 1650887219 Administrator 0..* 1 1 1DDB4575-D3F3-476E-BC7A-7283F8525FA3 1650887219 Administrator 1650887219 Administrator BCC64445-23DF-4F68-8960-3AC3D6E17591 Reference_11 Reference_11 1650887219 Administrator 1650887219 Administrator 0..* 1 1 D2F50B4F-37B8-4430-8E1F-9171408F255A 1650887219 Administrator 1650887219 Administrator 69191AC8-8334-44CB-ABFC-EC42F92CBD6A Reference_12 Reference_12 1650887219 Administrator 1650887219 Administrator 0..* 1 1 FD1D08B0-8806-4D27-83CE-BD6737283520 1650887219 Administrator 1650887219 Administrator 2AAC5D4E-EF21-4B8E-8D80-F5A3F99A2517 Reference_13 Reference_13 1650887219 Administrator 1650887219 Administrator 0..* 1 1 320BE83D-7FE2-40CE-BFC8-0CBEE4D3E706 1650887219 Administrator 1650887219 Administrator 0AA6475F-A63E-403C-B242-7BB0DCEF9284 Reference_14 Reference_14 1650887219 Administrator 1650887219 Administrator 0..* 1 1 A5B12F80-82BC-4FF7-B487-8372BD6882B6 1650887219 Administrator 1650887219 Administrator F08630D0-D690-47C2-9CE5-3863DC024C10 Reference_15 Reference_15 1650887219 Administrator 1650887219 Administrator 0..* 1 1 858F470F-13A5-471A-A27A-11CC7E772DDB 1650887219 Administrator 1650887219 Administrator 5E5774C1-0C2E-4059-A629-083DBDE2DA47 Reference_16 Reference_16 1650887219 Administrator 1650887219 Administrator 0..* 1 1 B95D2B85-3248-4D43-8C9C-944EE50B8A17 1650887219 Administrator 1650887219 Administrator 29FBFE0E-DA64-4E8F-BBB8-9DBABD484AEF Reference_17 Reference_17 1650887219 Administrator 1650887219 Administrator 0..* 1 1 260EA9BF-45F7-45FD-A584-F6DDA8F43CBA 1650887219 Administrator 1650887219 Administrator 81B7AC96-4B64-4EB1-950D-A6571269452D Reference_18 Reference_18 1650887219 Administrator 1650887219 Administrator 0..* 1 1 9D5E4543-4878-49ED-B4D1-E8573BF7C021 1650887219 Administrator 1650887219 Administrator CD0BA332-38A4-4322-9BCD-767F12B6CC40 Reference_19 Reference_19 1650887219 Administrator 1650887219 Administrator 0..* 1 1 2F139AF4-0CB0-46C9-99CD-6CE913CFBE6A 1650887219 Administrator 1650887219 Administrator 37D534DD-364D-4FEF-837B-51E970107024 Reference_20 Reference_20 1650887219 Administrator 1650887219 Administrator 0..* 1 1 00734640-B2ED-4ECE-BFD9-9AE1A42AAE0A 1650887219 Administrator 1650887219 Administrator C1C2559F-A00A-448B-9456-D2C85E866C4D Reference_21 Reference_21 1650887219 Administrator 1650887219 Administrator 0..* 1 1 2536D143-ED3F-476B-9D45-557FC0901CC5 1650887219 Administrator 1650887219 Administrator 6B68E596-A89B-437C-A16F-302579F59BC1 Reference_22 Reference_22 1650887219 Administrator 1650887219 Administrator 0..* 1 1 7F33D646-E3FB-4693-B80D-1DB9E3C2A1E8 1650887219 Administrator 1650887219 Administrator D90BB59C-D491-42BC-BFAE-CE200FE831FB PUBLIC PUBLIC 1650887182 Administrator 1650887182 Administrator 56918909-2275-469E-A01D-7D63802DA901 Sybase SQL Anywhere 11 SYASA11 1650887182 Administrator 1650887182 Administrator file:///%_DBMS%/syasa110.xdb 9C2029CC-5AF2-4828-AA6C-11C184EF93D8 4BA9F647-DAB1-11D1-9944-006097355D9B