📄 bbsxp2008 数据结构说明.htm
字号:
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>GroupDescription</td>
<td>论坛组描述 </td>
<td>ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ForumColumns</td>
<td>论坛横排</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<td>Moderated</td>
<td>论坛组版主</td>
<td>Nvarchar(255)</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="Links"></a>表[Links]</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>LinkID</td>
<td> </td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>Name</td>
<td>网站名字 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>URL</td>
<td>网址 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Logo</td>
<td>网站LOGO</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Intro</td>
<td>网站描述 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>SortOrder</td>
<td>排序（0为隐藏） </td>
<td>Int</td>
<td>1</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="PostAttachments"></a>表[PostAttachments]</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>UpFileID</td>
<td> </td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>UserName</td>
<td>用户名 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>FileName</td>
<td>文件名 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>FileDate</td>
<td>附件数据</td>
<td>Image</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ContentType</td>
<td>文件类型 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>FilePath</td>
<td>服务器路径 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ContentSize</td>
<td>文件大小 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>PostID</td>
<td>帖子ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>Description</td>
<td>描述 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Created</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="PostEditNotes"></a>表[PostEditNotes]</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><p align="center"><strong>字段中文说明</strong></td>
<td><p align="center"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td><p align="center"><strong>备注</strong></td>
</tr>
<tr>
<td>EditNoteID</td>
<td> </td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>PostID</td>
<td>帖子ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>EditNotes</td>
<td>帖子编辑记录 </td>
<td>Nvarchar(255)</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="PostInTags"></a>表[PostInTags]</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>TagID</td>
<td>标签ID</td>
<td>Int</td>
<td> </td>
<td>FK</td>
</tr>
<tr>
<td>ThreadID</td>
<td>主题ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>PostID</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="Posts"></a>表[Posts]</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="108"><strong>字段名</strong></td>
<td width="288"><strong>字段中文说明</strong></td>
<td width="120"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>PostID</td>
<td>帖子ID</td>
<td>Int</td>
<td> </td>
<td>自动编号、PK</td>
</tr>
<tr>
<td>ThreadID</td>
<td>主题ID</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ParentID</td>
<td>帖子父ID [0为主题帖]</td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>PostAuthor</td>
<td>作者 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Subject</td>
<td>标题 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Body</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>Visible</td>
<td>是否可见[0=未通过审核 1=通过审核 2=已删除]</td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>PostDate</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="PostTags"></a>表[PostTags]</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>TagID</td>
<td>标签ID</td>
<td>Int</td>
<td> </td>
<td>自动编号、PK</td>
</tr>
<tr>
<td>TagName</td>
<td>标签名称 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>IsEnabled</td>
<td>是否启用 </td>
<td>Int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>TotalPosts</td>
<td>使用总帖子数 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>MostRecentPostDate</td>
<td>最后使用日期 </td>
<td>DateTime</td>
<td>now()</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="PrivateMessages"></a>表[PrivateMessages]</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>MessageID</td>
<td>短消息ID</td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>SenderUserName</td>
<td>发送用户 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>RecipientUserName</td>
<td>接收用户 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Subject</td>
<td>标题 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Body</td>
<td>正文内容 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>IsRead</td>
<td>是否已读 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>IsRecipientDelete</td>
<td>发送人是否删除 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>IsSenderDelete</td>
<td>接收人是否删除 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>CreateTime</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="Ranks"></a>表[Ranks]</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>RankID</td>
<td> </td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>RoleID</td>
<td>角色ID</td>
<td>Int</td>
<td>0</td>
<td>FK</td>
</tr>
<tr>
<td>RankName</td>
<td>等级名称 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>PostingCountMin</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="Reputation"></a>表[Reputation]</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>ReputationID</td>
<td> </td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>Reputation</td>
<td>评价分数 </td>
<td>Int</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -