📄 bbsxp2008 数据结构说明.htm
字号:
<br /><br />
<table width="780" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="left"><span class="TableNav"><a name="UserActivation"></a>表[UserActivation]</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>ActivationKey</td>
<td>邀请码 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </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>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="UserOnline"></a>表[UserOnline]</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>0</td>
<td> </td>
</tr>
<tr>
<td>SessionID</td>
<td>SessionID</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserName</td>
<td>用户名称 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>IPAddress</td>
<td>IP地址 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>IsInvisible</td>
<td>是否隐身 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>ForumName</td>
<td>所在论坛 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ThreadID</td>
<td>当前所在主题ID</td>
<td>int</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Topic</td>
<td>当前所在主题</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ComeTime</td>
<td>来访时间 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>LastTime</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="Users"></a>表[Users]</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="254"><strong>字段中文说明</strong></td>
<td width="120"><strong>数据类型</strong></td>
<td width="120"><strong>默认值</strong></td>
<td width="120"><strong>备注</strong></td>
</tr>
<tr>
<td>UserID</td>
<td width="254"> </td>
<td>Int</td>
<td> </td>
<td>自动编号 </td>
</tr>
<tr>
<td>UserName</td>
<td width="254">用户名 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td>PK</td>
</tr>
<tr>
<td>UserPassword</td>
<td width="254">用户密码 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserSex</td>
<td width="254">性别（0=未设置 1=男 2=女） </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>UserRoleID</td>
<td width="254">角色ID<br>1=管理员<br>2=超级版主<br>3=注册会员</td>
<td>Int</td>
<td>3</td>
<td> </td>
</tr>
<tr>
<td>UserAccountStatus</td>
<td width="254">0=正等待审核<br />
1=已通过审核<br />
2=已禁用<br />
3=未通过审核 </td>
<td>int</td>
<td>1</td>
<td> </td>
</tr>
<tr>
<td>ModerationLevel</td>
<td width="254">信任用户等级（针对审核论坛才生效）<br>0=不信任<br>1=信任 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>UserEmail</td>
<td width="254">Email</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>PasswordQuestion</td>
<td width="254">密码问题 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>PasswordAnswer</td>
<td width="254">问题答案 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>WebAddress</td>
<td width="254">主页 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>WebLog</td>
<td width="254">博客 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>WebGallery</td>
<td width="254">相册 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserRank</td>
<td width="254">用户等级 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Birthday</td>
<td width="254">生日 </td>
<td>DateTime</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>NewMessage</td>
<td width="254">新留言 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>TotalPosts</td>
<td width="254">发表帖数 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>UserMoney</td>
<td width="254">用户金币 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>Experience</td>
<td width="254">经 验 值 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>UserFaceUrl</td>
<td width="254">头像URL</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserRegisterIP</td>
<td width="254">用户注册IP</td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserActivityIP</td>
<td width="254">最后活动IP</td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserRegisterTime</td>
<td width="254">注册日期 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>UserPostTime</td>
<td width="254">发帖日期 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>UserActivityTime</td>
<td width="254">最后活动日期 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>ReferrerName</td>
<td width="254">邀请人 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>RealName</td>
<td width="254">真实姓名 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserMate</td>
<td width="254">配偶 </td>
<td>Nvarchar(50)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Occupation</td>
<td width="254">职业 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Address</td>
<td width="254">联系地址 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>QQ</td>
<td>QQ帐号</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>ICQ</td>
<td>ICQ帐号</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>AIM</td>
<td>AIM帐号</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>MSN</td>
<td>MSN帐号</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Yahoo</td>
<td>雅虎通</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Skype</td>
<td>Skype</td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Interests</td>
<td width="254">个人兴趣 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserTitle</td>
<td width="254">用户头衔 </td>
<td>Nvarchar(255)</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Reputation</td>
<td width="254">声望 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>UserActivityDay</td>
<td width="254">用户活跃天数 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>BankMoney</td>
<td width="254">银行存款 </td>
<td>int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>BankDate</td>
<td width="254">存款日期 </td>
<td>DateTime</td>
<td>now()</td>
<td> </td>
</tr>
<tr>
<td>UserSign</td>
<td width="254">签名档 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserBio</td>
<td width="254">个人简介 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>UserNote</td>
<td width="254">用户备注 </td>
<td>ntext</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="Votes"></a>表[Votes]</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> </td>
</tr>
<tr>
<td>IsMultiplePoll</td>
<td>类型：0=单选，1=多选 </td>
<td>Int</td>
<td>0</td>
<td> </td>
</tr>
<tr>
<td>Expiry</td>
<td>过期时间 </td>
<td>DateTime</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Items</td>
<td>投票内容 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Result</td>
<td>投票结果 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>BallotUserList</td>
<td>投票用户名单 </td>
<td>Ntext</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>BallotIPList</td>
<td>投票IP名单 </td>
<td>ntext</td>
<td> </td>
<td> </td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -