Rainbow（SQL）数据库
表：dtproperties
|
序号 |
字段名 |
类型 |
长度 |
精度 |
小数位数 |
默认值 |
允许空 |
主键 |
说明 |
|
1 |
id |
int |
4 |
|
|
|
|
√ |
|
|
2 |
objectid |
int |
4 |
|
|
|
√ |
|
|
|
3 |
property |
varchar |
64 |
|
|
|
|
√ |
|
|
4 |
value |
varchar |
255 |
|
|
|
√ |
|
|
|
5 |
uvalue |
nvarchar |
255 |
|
|
|
√ |
|
|
|
6 |
lvalue |
image |
16 |
|
|
|
√ |
|
|
|
7 |
version |
int |
4 |
|
|
(0) |
|
|
|
表：rb_Announcements
|
序号 |
字段名 |
类型 |
长度 |
精度 |
小数位数 |
默认值 |
允许空 |
主键 |
说明 |
|
1 |
ItemID |
int |
4 |
|
|
|
|
√ |
|
|
2 |
ModuleID |
int |
4 |
|
|
|
|
|
|
|
3 |
CreatedByUser |
nvarchar |
100 |
|
|
|
√ |
|
|
|
4 |
CreatedDate |
datetime |
8 |
|
|
|
√ |
|
|
|
5 |
Title |
nvarchar |
150 |
|
|
|
√ |
|
|
|
6 |
MoreLink |
nvarchar |
150 |
|
|
|
√ |
|
|
|
7 |
MobileMoreLink |
nvarchar |
150 |
|
|
|
√ |
|
|
|
8 |
ExpireDate |
datetime |
8 |
|
|
|
√ |
|
|
|
9 |
Description |
nvarchar |
2000 |
|
|
|
√ |
|
|
表：rb_Announcements_st
|
序号 |
字段名 |
类型 |
长度 |
精度 |
小数位数 |
默认值 |
允许空 |
主键 |
说明 |
|
1 |
ItemID |
int |
4 |
|
|
|
|
√ |
|
|
2 |
ModuleID |
int |
4 |
|
|
|
|
|
|
|
3 |
CreatedByUser |
nvarchar |
100 |
|
|
|
√ |
|
|
|
4 |
CreatedDate |
datetime |
8 |
|
|
|
√ |
|
|
|
5 |
Title |
nvarchar |
150 |
|
|
|
√ |
|
|
|
6 |
MoreLink |
nvarchar |
150 |
|
|
|
√ |
|
|
|
7 |
MobileMoreLink |
nvarchar |
150 |
|
|
|
√ |
|
|
|
8 |
ExpireDate |
datetime |
8 |
|
|
|
√ |
|
|
|
9 |
Description |
nvarchar |
2000 |
|
|
|
√ |
|
|
表：rb_Articles
|
序号 |
字段名 |
类型 |
长度 |
精度 |
小数位数 |
默认值 |
允许空 |
主键 |
说明 |
|
1 |
ItemID |
int |
4 |
|
|
|
|
√ |
|
|
2 |
ModuleID |
int |
4 |
|
|
|
|
|
|
|
3 |
CreatedByUser |
nvarchar |
100 |
|
|
|
√ |
|
|
|
4 |
CreatedDate |
datetime |
8 |
|
|
|
√ |
|
|
|
5 |
Title |
nvarchar |
100 |
|
|
|
√ |
|
|
|
6 |
Subtitle |
nvarchar |
200 |
|
|
|
√ |
|
|
|
7 |
Abstract |
nvarchar |
512 |
|
|
|
√ |
|
|
|
8 |
StartDate |
datetime |
8 |
|
|
|
√ |
|
|
|
9 |
ExpireDate |
datetime |
8 |
|
|
|
√ |
|
|
|
10 |
IsInNewsletter |
bit |
1 |
|
|
|
√ |
|
|
|
11 |
MoreLink |
nvarchar |
150 |
|
|
|
√ |
|
|
|
12 |
Description |
ntext |
16 |
|
|
|
√ |
|
|
表：rb_Blacklist
|
序号 |
字段名 |
类型 |
长度 |
精度 |
小数位数 |
默认值 |
允许空 |
主键 |
说明 |
|
1 |
PortalID |
int |
4 |
|
|
|
|
√ |
|
|
2 |
Email |
nvarchar |
100 |
|
|
|
|
√ |
|
|
3 |
Date |
smalldatetime |
4 |
|
|
|
√ |
|
|
|
4 |
Reason |
nvarchar |
150 |
|
|
|
√ |
|
|
表：rb_BlogComments
|
序号 |
字段名 |
类型 |
长度 |
精度 |
小数位数 |
默认值 |
允许空 |
主键 |
说明 |
|
1 |
BlogCommentID |
int |
4 |
|
|
|
|
√ |
|
|
2 |
ModuleID |
int |
4 |
|
|
|
|
|
|
|
3 |
ItemID |
int |
4 |
|
|
|
|
|
|
|
4 |
Comment |
ntext |
16 |
|
|
|
|
|
|
|
5 |
Title |
nvarchar |
100 |
|
|
|
√ |
|
|
|
6 |
Name |
nvarchar |
100 |
|
|
|
√ |
|
|
|
7 |
URL |
nvarchar |
200 |
|
|
|
√ |
|
|
|
8 |
DateCreated |
datetime |
8 |
|
|
(getdate()) |
|
|
|
表：rb_Blogs
|
序号 |
字段名 |
类型 |
长度 |
精度 |
小数位数 |
默认值 |
允许空 |
主键 |
说明 |
|
1 |
ItemID |
int |
4 |
|
|
|
|
√ |
|
|
2 |
ModuleID |
int |
4 |
|
|
|
|
|
|
|
3 |
CreatedByUser |
nvarchar |
100 |
|
|
|
√ |
|
|
|
4 |
CreatedDate |
datetime |
8 |
|
|
|
√ |
|
|
|
5 |
Title |
nvarchar |
100 |
|
|
|
√ |
|
|
|
6 |
Excerpt |
nvarchar |
512 |
|
|
|
√ |
|
|
|
7 |
StartDate |
datetime |
8 |
|
|
|
√ |
|
|
|
8 |
IsInNewsletter |
bit |
1 |
|
|
|
√ |
|
|
|
9 |
Description |
ntext |
16 |
|
|
|
√ |
|
|
|
10 |
CommentCount |
int |
4 |
|
|
(0) |
|
|
|
|
11 |
TrackBackCount |
int |
4 |
|
|
(0) |
|
|
|
表：rb_BlogStats
|
序号 |
字段名 |
类型 |
长度 |
精度 |
小数位数 |
默认值 |
允许空 |
主键 |
说明 |
|
1 |
ModuleID |
int |
4 |
|
|
|
|
|
|
|
2 |
EntryCount |
int |
4 |
|
|
(0) |
|
|
|
|
3 |
CommentCount |
int |
4 |
|
|
(0) |
|
|
|
|
4 |
TrackBackCount |
int |
4 |
|
|
(0) |
|
|
|
