📄 bbsxp2008 数据结构说明.htm
字号:
<td>0</td>
<td> </td>
</tr>
<tr>
<td>CommentFor</td>
<td>被评价的用户 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td>FK</td>
</tr>
<tr>
<td>CommentBy</td>
<td>发表评价的用户 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Comment</td>
<td>评论内容 </td>
<td>ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>IPAddress</td>
<td>IP地址 </td>
<td>Nvarchar(50)</td>
<td> </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="Roles"></a>表[Roles]</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>RoleID</td>
<td>角色ID</td>
<td>Int</td>
<td> </td>
<td>自动编号、PK</td>
</tr>
<tr>
<td>Name</td>
<td>角色名称 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Description</td>
<td>角色描述 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>RoleMaxFileSize</td>
<td>允许单个帖子附件的大小</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>RoleMaxPostAttachmentsSize</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="SiteSettings"></a>表[SiteSettings]</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>SiteSettingsXML</td>
<td>论坛信息 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>CreateUserAgreement</td>
<td>注册用户协议 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>GenericHeader</td>
<td>页面头信息 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>GenericTop</td>
<td>顶部广告代码 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>GenericBottom</td>
<td>底部版权信息 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>BestOnline</td>
<td>最高在线人数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>BestOnlineTime</td>
<td>最高在线发生时间 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>AdminNotes</td>
<td>管理员便笺 </td>
<td>ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>BBSxpVersion</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="Statistics"></a>表[Statistics]</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>DaysUsers</td>
<td>今日用户 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>DaysPosts</td>
<td>今日帖子 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>DaysTopics</td>
<td>今日主题 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalUsers</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>TotalTopics</td>
<td>总主题数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>NewestUserName</td>
<td>新注册用户 </td>
<td>Nvarchar(50)</td>
<td> </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="Subscriptions"></a>表[Subscriptions]</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>SubscriptionID</td>
<td> </td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>ThreadID</td>
<td>主题ID</td>
<td>Int</td>
<td>0</td>
<td>FK</td>
</tr>
<tr>
<td>UserName</td>
<td>订阅用户</td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Email</td>
<td>Email</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>SubscriptionDate</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="ThreadRating"></a>表[ThreadRating]</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>ThreadID</td>
<td>主题ID</td>
<td>Int</td>
<td>0</td>
<td>FK</td>
</tr>
<tr>
<td>UserName</td>
<td>用户 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Rating</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="Threads"></a>表[Threads]</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="120"><strong>字段名</strong></td>
<td width="242"><strong>字段中文说明</strong></td>
<td width="108"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>ThreadID</td>
<td width="217">主题ID</td>
<td>Int</td>
<td> </td>
<td>自动编号、PK</td>
</tr>
<tr>
<td>ForumID</td>
<td width="217">所属版块 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ThreadEmoticonID</td>
<td width="217">表情 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ThreadStyle</td>
<td width="217">主题样式 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Topic</td>
<td width="217">标题 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Category</td>
<td width="217">文章类别 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Description</td>
<td width="217">主题描述 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>PostAuthor</td>
<td width="217">用户名 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>LastName</td>
<td width="217">最后回复的用户 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>PostTime</td>
<td width="217">主题发表时间 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>LastTime</td>
<td width="217">最后回复时间 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>LastViewedDate</td>
<td width="217">最后查看日期 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>IsGood</td>
<td width="217">是否精华帖 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ThreadTop</td>
<td width="217">是否置顶帖 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>StickyDate</td>
<td width="217">公告/置顶过期时间 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>IsLocked</td>
<td width="217">是否锁帖 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>Visible</td>
<td width="217">是否可见<br>
0=未通过审核<br>
1=通过审核<br>
2=已删除</td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>HiddenCount</td>
<td width="217">未审核帖子数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>DeletedCount</td>
<td width="217">已删除帖子数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>IsVote</td>
<td width="217">是否投票主题 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalViews</td>
<td width="217">总浏览数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalReplies</td>
<td width="217">总回复数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>RatingSum</td>
<td width="217">投票总得分数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalRatings</td>
<td width="217">共几个用户投票 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ThreadStatus</td>
<td width="217">主题状态 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
</table>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -