📄 bbsxp2008 数据结构说明.htm
字号:
<html>
<head>
<title>BBSXP2008(8.0.5) 数据结构说明</title>
</head>
<style type="text/css">
body {font-size:10pt; padding 0 auto;line-height:1.5}
td {font-size:10pt;}
.TableNav{color:#00F}
</style>
<body>
<div style="text-align:center; font-weight:bold; font-size:13pt; color:#F00">BBSXP2008 数据结构</div>
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td style="line-height:1.5">
<a href="#Advertisements">表[Advertisements]</a> <a href="#EventLog">表[EventLog]</a>
<a href="#FavoriteForums">表[FavoriteForums]</a> <a href="#FavoritePosts">表[FavoritePosts]</a>
<a href="#FavoriteUsers">表[FavoriteUsers]</a> <a href="#ForumPermissions">表[ForumPermissions]</a><br>
<a href="#Forums">表[Forums]</a> <a href="#Groups">表[Groups]</a>
<a href="#Links">表[Links]</a> <a href="#PostAttachments">表[PostAttachments]</a>
<a href="#PostEditNotes">表[PostEditNotes]</a> <a href="#PostInTags">表[PostInTags]</a>
<a href="#Posts">表[Posts]</a> <a href="#PostTags">表[PostTags]</a><br>
<a href="#PrivateMessages">表[PrivateMessages]</a> <a href="#Ranks">表[Ranks]</a>
<a href="#Reputation">表[Reputation]</a> <a href="#Roles">表[Roles]</a>
<a href="#SiteSettings">表[SiteSettings]</a> <a href="#Statistics">表[Statistics]</a>
<a href="#Subscriptions">表[Subscriptions]</a><br><a href="#ThreadRating">表[ThreadRating]</a>
<a href="#Threads">表[Threads]</a> <a href="#UserActivation">表[UserActivation]</a>
<a href="#UserOnline">表[UserOnline]</a> <a href="#Users">表[Users]</a>
<a href="#Votes">表[Votes]</a>
</td>
</tr>
<tr>
<td>
<div>说明：</div>
<div style="padding-left:40px;">1、PK表示主键 2、FK表示外键</div>
</td>
</tr>
</table>
<br />
<br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="Advertisements"></a>表[Advertisements]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="132"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>AdvertisementID</td>
<td>广告ID</td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>Body</td>
<td>广告内容 </td>
<td>ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ExpireDate</td>
<td>广告过期时间 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="EventLog"></a>表[EventLog]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="242"><strong>字段名</strong></td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="132"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>UserName</td>
<td>名字 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ErrNumber</td>
<td>错误代码 </td>
<td>Int</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>EventDate</td>
<td>操作时间 </td>
<td>DateTime(8)</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>MessageXML</td>
<td>操作记录 </td>
<td>ntext</td>
<td> </td>
<td>XML格式 </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="FavoriteForums"></a>表[FavoriteForums]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="132"><strong>数据类型</strong><strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong><strong></td>
</tr>
<tr>
<td>FavoriteID</td>
<td>收藏ID</td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>OwnerUserName</td>
<td>所有者 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td>FK</td>
</tr>
<tr>
<td>ForumID </td>
<td>论坛ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="FavoritePosts"></a>表[FavoritePosts]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong> </td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="132"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>FavoriteID</td>
<td>收藏ID</td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>OwnerUserName</td>
<td>所有者 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td>FK</td>
</tr>
<tr>
<td>PostID </td>
<td>帖子ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
</table>
<br /><br /><span class="TableNav">
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="FavoriteUsers"></a>表[FavoriteUsers]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong> </td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="132"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>FavoriteID</td>
<td>收藏ID</td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>OwnerUserName</td>
<td>所有者 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td>FK</td>
</tr>
<tr>
<td>FriendUserName </td>
<td>好友名 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="ForumPermissions"></a>表[ForumPermissions]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="132"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>ForumID</td>
<td>论坛ID</td>
<td>Int</td>
<td> </td>
<td>FK</td>
</tr>
<tr>
<td>RoleID</td>
<td>角色ID</td>
<td>Int</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>PermissionView</td>
<td>是否允许浏览主题列表</td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PermissionRead</td>
<td>是否允许阅读帖子</td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PermissionPost</td>
<td>是否允许发帖 </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PermissionReply</td>
<td>是否允许回复帖子 </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PermissionEdit</td>
<td>是否允许编辑帖子 </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PermissionDelete</td>
<td>是否允许删除帖子 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>PermissionCreatePoll</td>
<td>是否允许发起投票 </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PermissionVote</td>
<td>是否允许参与投票 </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PermissionAttachment</td>
<td>是否允许上传附件 </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PermissionManage</td>
<td>是否允许管理论坛 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="Forums"></a>表[Forums]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="132"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>ForumID</td>
<td>论坛ID</td>
<td>Int</td>
<td> </td>
<td>自动编号、PK</td>
</tr>
<tr>
<td>GroupID</td>
<td>论坛组ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ParentID</td>
<td>父论坛ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>SortOrder</td>
<td>排序（0为隐藏） </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>ForumName</td>
<td>论坛名称 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Moderated</td>
<td>论坛版主 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>TotalCategorys</td>
<td>主题类别 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ForumDescription</td>
<td>论坛描述 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>TodayPosts</td>
<td>今日帖数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalThreads</td>
<td>总主题数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalPosts</td>
<td>总帖子数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ForumUrl</td>
<td>论坛转向URL</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>IsActive</td>
<td>是否激活 </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>MostRecentThreadID</td>
<td>最后主题帖ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>MostRecentPostSubject</td>
<td>最后发表主题 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>MostRecentPostAuthor</td>
<td>最后发帖人的名称 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>MostRecentPostDate</td>
<td>最后发帖人的时间 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>ForumRules</td>
<td>版规和导读 </td>
<td>ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ModerateNewThread</td>
<td>新主题是否需要审核 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ModerateNewPost</td>
<td>新帖子是否需要审核 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>DateCreated</td>
<td>创建时间 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
</table>
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="Groups"></a>表[Groups]</span></td>
<td align="right"><a href="#top">返回TOP</a></td>
</tr>
</table>
<table width="780" border="1" align="center" cellpadding="3" cellspacing="0">
<tr align="center">
<td width="142"><strong>字段名</strong></td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="132"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>GroupID</td>
<td>论坛组ID</td>
<td>Int</td>
<td> </td>
<td>自动编号、PK</td>
</tr>
<tr>
<td>GroupName</td>
<td>论坛组名称 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>SortOrder</td>
<td>排序（0为隐藏） </td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -