Openfire表结构,数据字典.xls

附录二 表结构 孙溦 第 1 页2020 1 19 表表 索索 引引 1 1 用户组数据表 ofGroup 2 2组属性名 值对应表 ofGroupProp 3 3用户 组关联表 ofGroupUser 4 4用户ID表 ofID 5 5离线消息存储表 ofOffline 6 6私人数据存储表 ofPrivate 7 7用户数据表 ofUser 8 8用户名 值对应表 ofUserProp 9 9好友名册表 ofRoster 1010好友名册条目组表 ofRosterGroups 1111用户私密表 ofPrivacyList 1212用户详细信息表 ofVCard 1313内含产品版本信息表 ofVersion 1414服务器属性表 ofProperty 1515扩展组件配置表 ofExtComponentConf 1616远程服务器配置表 ofRemoteServerConf 1717组聊天室数据表 ofMucRoom 1818聊天室房间属性名 值对应表 ofMucRoomProp 1919聊天室房间内用户联系表 ofMucAffiliation 2020聊天室房间成员信息表 ofMucMember 2121聊天室对话日志表 ofMucConversationLog 2222发布 订阅节点表 ofPubsubNode 2323节点 JID关联表 ofPubsubNodeJIDs 2424节点 名册组关联表 ofPubsubNodeGroups 2525节点关联表 ofPubsubAffiliation 附录二 表结构 孙溦 第 2 页2020 1 19 2626发布项目表 ofPubsubItem 2727节点订阅表 ofPubsubSubsciption 2828节点默认配置表 ofPubsubDefaultConf 2929离线信息存储 ofPresence 3030用户类型标识 ofUserFlag 3131记录安全事件 ofSecurityAditLog 3232群聊服务 ofMucService 3333群聊服务属性名 值对应表 ofMucServiceProp 3434SASL授权 ofSASLAuthorized 行行号号字字段段名名称称字字段段描描述述字字段段类类型型长长度度主主键键说说明明允允许许为为空空默默认认索索引引 用用户户组组数数据据表表 ofGroupofGroup 1 1groupNamegroupName组组名名varchar2varchar25050 NOTNOT NULLNULL 2 2descriptiondescription组组描描述述信信息息varchar2varchar2255255 组组属属性性名名 值值对对应应表表 ofGroupPropofGroupProp 1 1groupNamegroupName组组名名varchar2varchar25050 NOTNOT NULLNULL 2 2namename组组属属性性名名varchar2varchar2100100NOTNOT NULLNULL 3 3propValuepropValue组组属属性性值值varchar2varchar240004000 用用户户 组组关关联联表表 ofGroupUserofGroupUser 1 1groupNamegroupName组组名名varchar2varchar25050 NOTNOT NULLNULL 2 2usernameusername用用户户名名varchar2varchar2100100 NOTNOT NULLNULL 3 3administratoradministrator管管理理员员身身份份numbernumber booleanbooleanNOTNOT NULLNULL 用用户户IDID表表 ofIDofID 1 1idTypeidTypeIDID类类型型numbernumber 如如 组组 用用户户 名名单单册册NOTNOT NULLNULL 附录二 表结构 孙溦 第 3 页2020 1 19 2 2idid下下一一个个可可用用的的IDID块块numbernumber依依赖赖数数据据库库的的生生成成策策略略NOTNOT NULLNULL 离离线线消消息息存存储储表表 ofOfflineofOffline 1 1usernameusername用用户户名名varchar2varchar23232 NOTNOT NULLNULL 2 2messageIDmessageID消消息息IDIDnumbernumber NOTNOT NULLNULL 3 3creationDatecreationDate消消息息存存储储日日期期charchar1515NOTNOT NULLNULL 4 4messageSizemessageSize消消息息的的字字节节大大小小numbernumberNOTNOT NULLNULL 5 5stanzastanza消消息息体体longlongNOTNOT NULLNULL 私私人人数数据据存存储储表表 ofPrivateofPrivate 1 1usernameusername用用户户名名varchar2varchar26464 NOTNOT NULLNULL 2 2namename私私人人条条目目名名varchar2varchar2100100 NOTNOT NULLNULL 3 3namespacenamespace私私人人条条目目名名空空间间varchar2varchar2200200 NOTNOT NULLNULL 4 4privateDateprivateDate私私人人数数据据值值longlongNOTNOT NULLNULL 用用户户数数据据表表 ofUserofUser 1 1usernameusername用用户户名名varchar2varchar26464 NOTNOT NULLNULL 2 2plainPasswordplainPassword纯纯文文本本密密码码varchar2varchar23232 3 3encryptedPasswordencryptedPassword加加密密密密码码varchar2varchar2255255 4 4namename名名字字varchar2varchar2100100 5 5emailemail电电子子邮邮件件地地址址varchar2varchar2100100 6 6creationDatecreationDate创创建建日日期期charchar1515NOTNOT NULLNULL 7 7modificationDatemodificationDate最最后后修修改改日日期期charchar1515NOTNOT NULLNULL 用用户户名名 值值对对应应表表 ofUserPropofUserProp 1 1usernameusername用用户户名名varchar2varchar26464 NOTNOT NULLNULL 2 2namename用用户户属属性性名名varchar2varchar2100100 NOTNOT NULLNULL 附录二 表结构 孙溦 第 4 页2020 1 19 3 3propValuepropValue用用户户属属性性值值varchar2varchar210241024NOTNOT NULLNULL 好好友友名名册册表表 ofRosterofRoster 1 1rosterIDrosterID名名册册IDIDnumbernumber NOTNOT NULLNULL 2 2usernameusername用用户户名名varchar2varchar26464NOTNOT NULLNULL 3 3jidjid名名册册条条目目JIDJIDvarchar2varchar210241024NOTNOT NULLNULL 4 4subsub条条目目订订阅阅状状态态numbernumberNOTNOT NULLNULL 5 5askask条条目目申申请请状状态态numbernumberNOTNOT NULLNULL 6 6recvrecv申申请请被被接接受受的的标标记记numbernumberNOTNOT NULLNULL 7 7nicknick名名册册条条目目分分配配的的妮妮称称varchar2varchar2255255 好好友友名名册册条条目目组组表表 ofRosterGroupsofRosterGroups 1 1rosterIDrosterID名名册册IDIDnumbernumber NOTNOT NULLNULL 2 2rankrank条条目目位位置置numbernumber NOTNOT NULLNULL 3 3groupNamegroupName组组名名varchar2varchar2255255NOTNOT NULLNULL 用用户户私私密密表表 ofPrivacyListofPrivacyList 1 1usernameusername用用户户名名varchar2varchar26464 NOTNOT NULLNULL 2 2namename私私密密列列表表名名varchar2varchar2100100 NOTNOT NULLNULL 3 3isDefaultisDefault用用户户默默认认私私密密列列表表标标记记numbernumberNOTNOT NULLNULL 4 4listlist私私密密列列表表XMLXML表表示示longlongNOTNOT NULLNULL 用用户户详详细细信信息息表表 ofVCardofVCard 1 1usernameusername用用户户名名varchar2varchar26464 NOTNOT NULLNULL 2 2vcardvcard详详细细信信息息值值longlongNOTNOT NULLNULL 内内含含产产品品版版本本信信息息表表 ofVersionofVersion 附录二 表结构 孙溦 第 5 页2020 1 19 1 1namename跟跟踪踪到到版版本本信信息息的的条条目目名名varchar2varchar25050 NOTNOT NULLNULL 2 2versionversion版版本本号号numbernumberNOTNOT NULLNULL 服服务务器器属属性性表表 ofPropertyofProperty 1 1namename属属性性名名varchar2varchar2100100 NOTNOT NULLNULL 2 2propValuepropValue属属性性值值varchar2varchar240004000NOTNOT NULLNULL 扩扩展展组组件件配配置置表表 ofExtComponentConfofExtComponentConf 1 1subdomainsubdomain扩扩展展组组件件子子域域varchar2varchar2255255 NOTNOT NULLNULL 2 2secretsecret扩扩展展组组件件共共享享密密钥钥varchar2varchar2255255 3 3permissionpermission组组件件连连接接服服务务器器许许可可varchar2varchar21010NOTNOT NULLNULL 远远程程服服务务器器配配置置表表 ofRemoteServerConfofRemoteServerConf 1 1xmppDomainxmppDomain扩扩展展组组件件域域varchar2varchar2255255 NOTNOT NULLNULL 2 2remotePortremotePort远远程程服服务务器器端端口口numbernumber 3 3permissionpermission远远程程服服务务器器连连接接服服务务器器许许可可varchar2varchar21010NOTNOT NULLNULL 组组聊聊天天室室数数据据表表 ofMucRoomofMucRoom 1 1roomIDroomID聊聊天天室室IDIDnumbernumberNOTNOT NULLNULL 2 2creationDatecreationDate创创建建日日期期charchar1515NOTNOT NULLNULL 3 3modificationDatemodificationDate最最近近修修改改日日期期charchar1515NOTNOT NULLNULL 4 4namename作作公公共共IDID用用的的房房间间名名varchar2varchar25050 NOTNOT NULLNULL 5 5naturalNamenaturalName房房间间名名varchar2varchar2255255NOTNOT NULLNULL 6 6descriptiondescription房房间间描描述述varchar2varchar2255255 7 7lockedDatelockedDate锁锁定定日日期期charchar1515NOTNOT NULLNULL 8 8emptyDateemptyDate清清空空日日期期charchar1515 9 9canChangeSubjectcanChangeSubject房房间间主主题题可可编编辑辑标标记记numbernumberNOTNOT NULLNULL 附录二 表结构 孙溦 第 6 页2020 1 19 1010maxUsersmaxUsers用用户户个个数数最最大大值值numbernumberNOTNOT NULLNULL 1111publicRoompublicRoom房房间间公公共共属属性性标标记记numbernumber是是否否列列在在聊聊天天室室列列表表中中NOTNOT NULLNULL 1212moderatedmoderated房房间间适适合合度度标标记记numbernumberNOTNOT NULLNULL 1313membersOnlymembersOnly仅仅成成员员进进入入许许可可标标记记numbernumberNOTNOT NULLNULL 1414canlnvitecanlnvite邀邀请请加加入入许许可可标标记记numbernumberNOTNOT NULLNULL 1515roomPasswordroomPassword房房间间密密码码varchar2varchar25050 1616canDiscoverJIDcanDiscoverJID参参与与者者真真实实IDID显显示示标标记记numbernumberNOTNOT NULLNULL 1717logEnabledlogEnabled聊聊天天内内容容存存储储标标记记numbernumberNOTNOT NULLNULL 1818subjectsubject当当前前房房间间主主题题varchar2varchar2100100 1919rolesToBroadcastrolesToBroadcast可可以以广广播播的的角角色色numbernumberNOTNOT NULLNULL 2020useReservedNickuseReservedNick仅仅用用保保留留妮妮称称进进入入标标记记numbernumberNOTNOT NULLNULL 2121canChangeNickcanChangeNick妮妮称称可可修修改改标标记记numbernumberNOTNOT NULLNULL 2222canRegistercanRegister房房间间可可注注册册标标记记numbernumberNOTNOT NULLNULL 聊聊天天室室房房间间属属性性名名 值值对对应应表表 ofMucRoomPropofMucRoomProp 1 1roomIDroomID房房间间IDIDnumbernumber NOTNOT NULLNULL 2 2namename属属性性名名varchar2varchar2100100 NOTNOT NULLNULL 3 3propValuepropValue属属性性值值varchar2varchar240004000NOTNOT NULLNULL 聊聊天天室室房房间间内内用用户户联联系系表表 ofMucAffiliationofMucAffiliation 1 1roomIDroomID房房间间IDIDnumbernumber NOTNOT NULLNULL 2 2jidjid用用户户JIDJIDvarchar2varchar210241024 NOTNOT NULLNULL 3 3affiliationaffiliation联联系系等等级级numbernumberNOTNOT NULLNULL 聊聊天天室室房房间间成成员员信信息息表表 ofMucMember ofMucMember 1 1roomIDroomID房房间间IDIDnumbernumber NOTNOT NULLNULL 2 2jidjid用用户户IDIDvarchar2varchar210241024 NOTNOT NULLNULL 附录二 表结构 孙溦 第 7 页2020 1 19 3 3nicknamenickname妮妮称称varchar2varchar2255255 4 4firstNamefirstName名名varchar2varchar2100100 5 5lastNamelastName姓姓varchar2varchar2100100 6 6urlurl用用户户连连接接URLURL地地址址varchar2varchar2100100 7 7emailemail电电子子邮邮件件地地址址varchar2varchar2100100 8 8faqentryfaqentry帮帮助助条条目目varchar2varchar2100100 聊聊天天室室对对话话日日志志表表 ofMucConversationLog ofMucConversationLog 1 1roomIDroomID房房间间IDIDnumbernumberNOTNOT NULLNULL 2 2sendersender消消息息发发送送者者IDIDvarchar2varchar210241024NOTNOT NULLNULL 3 3nicknamenickname消消息息发发送送者者妮妮称称varchar2varchar2255255 4 4logTimelogTime消消息息发发送送时时间间charchar1515NOTNOT NULLNULL 5 5subjectsubject消消息息标标题题varchar2varchar2255255 6 6bodybody消消息息体体varchar2varchar240004000 发发布布 订订阅阅节节点点表表 ofPubsubNode ofPubsubNode 1 1serviceIDserviceID节节点点服服务务IDIDvarchar2varchar2100100 NOTNOT NULLNULL 2 2nodeIDnodeID节节点点IDIDvarchar2varchar2100100 NOTNOT NULLNULL 3 3leafleaf子子分分支支存存在在标标记记numbernumberNOTNOT NULLNULL 4 4creationDATEcreationDATE创创建建时时间间charchar1515NOTNOT NULLNULL 5 5modificationDatemodificationDate最最近近修修改改时时间间charchar1515NOTNOT NULLNULL 6 6parentparent父父节节点点IDIDvarchar2varchar2100100 7 7deliverPayliadsdeliverPayliads有有效效载载荷荷通通知知标标记记numbernumberNOTNOT NULLNULL 8 8maxPayloadSizemaxPayloadSize有有效效载载荷荷最最大大字字节节数数numbernumber 9 9persistitemspersistitems发发布布条条目目持持有有标标记记numbernumber 1010maxItemsmaxItems持持有有条条目目最最大大数数numbernumber 1111notifyConfigChangesnotifyConfigChanges节节点点配配置置改改变变通通知知标标记记numbernumberNOTNOT NULLNULL 附录二 表结构 孙溦 第 8 页2020 1 19 1212notifyDeletenotifyDelete节节点点删删除除通通知知标标记记numbernumberNOTNOT NULLNULL 1313notifyRetractnotifyRetract发发布布条条目目删删除除通通知知标标记记numbernumberNOTNOT NULLNULL 1414presenceBasedpresenceBased仅仅向向用用户户发发送送通通知知标标记记numbernumberNOTNOT NULLNULL 1515sendItemSubscribesendItemSubscribe向向新新订订户户发发送送最最近近发发布布条条目目标标记记numbernumberNOTNOT NULLNULL 1616publisherModelpublisherModel节节点点发发布布模模式式varchar2varchar21515NOTNOT NULLNULL 1717subscriptionEnabledsubscriptionEnabled订订阅阅允允许许标标记记numbernumberNOTNOT NULLNULL 1818configSubscriptionconfigSubscription新新订订阅阅必必须须配配置置为为活活跃跃标标记记numbernumberNOTNOT NULLNULL 1919accessModelaccessModel节节点点访访问问模模式式varchar2varchar21010NOTNOT NULLNULL 2020payloadTypepayloadType节节点点上上有有效效载载荷荷类类型型varchar2varchar2100100 2121bodyXSLTbodyXSLT有有效效载载荷荷信信息息转转为为消消息息体体的的XSLTXSLT地地址址varchar2varchar2100100 2222dataformXSLTdataformXSLT有有效效载载荷荷信信息息转转为为结结果果数数据据的的XSLTXSLT地地址址varchar2varchar2100100 2323creatorcreator创创建建节节点点的的实实体体IDIDvarchar2varchar210241024NOTNOT NULLNULL 2424descriptiondescription节节点点描描述述varchar2varchar2255255 2525languagelanguage节节点点默默认认语语言言varchar2varchar2255255 2626namename节节点点名名varchar2varchar25050 2727replyPolicyreplyPolicy反反馈馈条条目目策策略略varchar2varchar21515 2828associationPolicyassociationPolicy叶叶节节点点收收集集策策略略varchar2varchar21515 2929maxLeafNodesmaxLeafNodes最最大大子子叶叶节节点点数数numbernumber 节节点点 JID JID关关联联表表 ofPubsubNodeJIDs ofPubsubNodeJIDs 1 1serviceIDserviceID节节点点服服务务IDIDvarchar2varchar2100100 NOTNOT NULLNULL 2 2nodeIDnodeID节节点点IDIDvarchar2varchar2100100 NOTNOT NULLNULL 3 3jidjid实实体体JIDJIDvarchar2varchar210241024 NOTNOT NULLNULL 4 4associationTypeassociationType关关联联模模式式varchar2varchar22020NOTNOT NULLNULL 节节点点 名名册册组组关关联联表表 ofPubsubNodeGroups ofPubsubNodeGroups 1 1serviceIDserviceID节节点点服服务务IDIDvarchar2varchar2100100NOTNOT NULLNULL 附录二 表结构 孙溦 第 9 页2020 1 19 2 2nodeIDnodeID节节点点IDIDvarchar2varchar2100100NOTNOT NULLNULL 3 3rosterGrouprosterGroup节节点点所所属属的的名名册册组组varchar2varchar2100100允允许许订订阅阅 取取回回条条目目NOTNOT NULLNULL 节节点点关关联联表表 ofPubsubAffiliation ofPubsubAffiliation 1 1serviceIDserviceID节节点点服服务务IDIDvarchar2varchar2100100 NOTNOT NULLNULL 2 2nodeIDnodeID节节点点IDIDvarchar2varchar2100100 NOTNOT NULLNULL 3 3jidjid关关联联JIDJIDvarchar2varchar210241024 NOTNOT NULLNULL 4 4affiliationaffiliation关关联联类类型型varchar2varchar21010NOTNOT NULLNULL 发发布布项项目目表表 ofPubsubItem ofPubsubItem 1 1serviceIDserviceID节节点点服服务务IDIDvarchar2varchar2100100 NOTNOT NULLNULL 2 2nodeIDnodeID节节点点IDIDvarchar2varchar2100100 NOTNOT NULLNULL 3 3idid条条目目IDIDvarchar2varchar2100100 每每个个节节点点中中唯唯一一NOTNOT NULLNULL 4 4jidjid发发布布者者JIDJIDvarchar2varchar210241024NOTNOT NULLNULL 5 5creationDATEcreationDATE创创建建日日期期charchar1515NOTNOT NULLNULL 6 6payloadpayload发发布布条条目目中中有有效效载载荷荷的的XMLXML表表示示varchar2varchar240004000 节节点点订订阅阅表表 ofPubsubSubsciption ofPubsubSubsciption 1 1serviceIDserviceID节节点点服服务务IDIDvarchar2varchar2100100 NOTNOT NULLNULL 2 2nodeIDnodeID节节点点IDIDvarchar2varchar2100100 NOTNOT NULLNULL 3 3idid订订阅阅IDIDvarchar2varchar2100100 NOTNOT NULLNULL 4 4jidjid接接收收通通知知地地址址varchar2varchar210241024NOTNOT NULLNULL 5 5ownerowner订订阅阅者者的的关关联联JIDJIDvarchar2varchar210241024NOTNOT NULLNULL statestate订订阅阅的的状状态态varchar2varchar21515在在工工作作流流中中NOTNOT NULLNULL 6 6deliverdeliver通通知知允允许许标标记记numbernumberNOTNOT NULLNULL 7 7digestdigest请请求求通通知知摘摘要要标标记记numbernumberNOTNOT NULLNULL 8 8digest frequencydigest frequency通通知知摘摘要要最最小小间间隔隔毫毫秒秒数数numbernumberNOTNOT NULLNULL 附录二 表结构 孙溦 第 10 页2020 1 19 expireexpire订订阅阅空空闲闲时时间间charchar1515 includeBodyincludeBody同同时时请请求求消消息息体体标标记记numbernumberNOTNOT NULLNULL showValuesshowValues到到场场提提示示标标记记varchar2varchar23030NOTNOT NULLNULL subscriptionTypesubscriptionType订订阅阅目目标标类类型型varchar2varchar21010条条目目 节节点点 叶叶节节点点不不可可用用NOTNOT NULLNULL subscriptionDepthsubscriptionDepth接接收收通通知知的的深深度度numbernumber叶叶节节点点不不可可用用NOTNOT NULLNULL keywordkeyword事事件件匹匹配配关关键键字字varchar2varchar2200200 节节点点默默认认配配置置表表 ofPubsubDefaultConf ofPubsubDefaultConf 1 1serviceIDserviceID节节点点服服务务IDIDvarchar2varchar2100100 NOTNOT NULLNULL 2 2leafleaf节节点点类类型型numbernumber 叶叶节节点点 集集合合NOTNOT NULLNULL 3 3deliverPayloadsdeliverPayloads有有效效载载荷荷提提示示标标记记numbernumberNOTNOT NULLNULL 4 4maxPayloadSizemaxPayloadSize有有效效载载荷荷最最大大字字节节数数numbernumberNOTNOT NULLNULL 5 5persistItemspersistItems发发布布条条目目持持有有标标记记numbernumberNOTNOT NULLNULL 6 6maxItemsmaxItems持持有有最最大大条条目目数数numbernumberNOTNOT NULLNULL 7 7notifyConfigChangesnotifyConfigChanges节节点点配配置置变变更更提提示示标标记记numbernumberNOTNOT NULLNULL 8 8notifyDeletenotifyDelete删删除除节节点点提提示示标标记记numbernumberNOTNOT NULLNULL 9 9notifyRetractnotifyRetract删删除除条条目目提提示示标标记记numbernumberNOTNOT NULLNULL 1010presenceBasedpresenceBased仅仅通通知知用用户户标标记记numbernumberNOTNOT NULLNULL 1111sendItemSubscribesendItemSubscribe向向新新订订户户发发送送最最近近发发布布条条目目标标记记numbernumberNOTNOT NULLNULL 1212publisherModelpublisherModel节节点点发发布布模模式式varchar2varchar21515NOTNOT NULLNULL 1313subscriptionEnabledsubscriptionEnabled订订阅阅允允许许标标记记numbernumberNOTNOT NULLNULL 1414accessModelaccessModel节节点点访访问问模模式式varchar2varchar21010NOTNOT NULLNULL 1515languagelanguage节节点点默默认认语语言言varchar2varchar2255255 1616replyPolicyreplyPolicy反反馈馈条条目目策策略略varchar2varchar21515 1717associationPolicyassociationPolicy叶叶节节点点收收集集策策略略varchar2varchar21515NOTNOT NULLNULL 1818maxLeafNodesmaxLeafNodes最最大大子子叶叶节节点点数数numbernumberNOTNOT NULLNULL 附录二 表结构 孙溦 第 11 页2020 1 19 离离线线信信息息存存储储 ofPresenceofPresenc