数据库设计
来源:互联网 发布:还珠格格 中视版源码 编辑:程序博客网 时间:2024/06/06 14:05
一、用户登录信息表(Sys_UserLogOn)
序号
列名
数据类型
长度
小数位
标识
主键
外键
允许空
默认值
说明
1
F_Id
varchar
50
0
是
否
用户登录主键
2
F_UserId
varchar
50
0
是
用户主键
3
F_UserPassword
varchar
50
0
是
用户密码
4
F_UserSecretkey
varchar
50
0
是
用户秘钥
5
F_AllowStartTime
datetime
8
3
是
允许登录时间开始
6
F_AllowEndTime
datetime
8
3
是
允许登录时间结束
7
F_LockStartDate
datetime
8
3
是
暂停用户开始日期
8
F_LockEndDate
datetime
8
3
是
暂停用户结束日期
9
F_FirstVisitTime
datetime
8
3
是
第一次访问时间
10
F_PreviousVisitTime
datetime
8
3
是
上一次访问时间
11
F_LastVisitTime
datetime
8
3
是
最后访问时间
12
F_ChangePasswordDate
datetime
8
3
是
最后修改密码日期
13
F_MultiUserLogin
bit
1
0
是
允许同时有多用户登录
14
F_LogOnCount
int
4
0
是
登录次数
15
F_UserOnLine
bit
1
0
是
在线状态
16
F_Question
varchar
50
0
是
密码提示问题
17
F_AnswerQuestion
varchar
500
0
是
密码提示答案
18
F_CheckIPAddress
bit
1
0
是
是否访问限制
19
F_Language
varchar
50
0
是
系统语言
20
F_Theme
varchar
50
0
是
系统样式
sql创建语句:
/****** Object: Table [dbo].[Sys_UserLogOn] Script Date: 2017/11/22 20:38:06 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Sys_UserLogOn]([F_Id] [varchar](50) NOT NULL,[F_UserId] [varchar](50) NULL,[F_UserPassword] [varchar](50) NULL,[F_UserSecretkey] [varchar](50) NULL,[F_AllowStartTime] [datetime] NULL,[F_AllowEndTime] [datetime] NULL,[F_LockStartDate] [datetime] NULL,[F_LockEndDate] [datetime] NULL,[F_FirstVisitTime] [datetime] NULL,[F_PreviousVisitTime] [datetime] NULL,[F_LastVisitTime] [datetime] NULL,[F_ChangePasswordDate] [datetime] NULL,[F_MultiUserLogin] [bit] NULL,[F_LogOnCount] [int] NULL,[F_UserOnLine] [bit] NULL,[F_Question] [varchar](50) NULL,[F_AnswerQuestion] [varchar](500) NULL,[F_CheckIPAddress] [bit] NULL,[F_Language] [varchar](50) NULL,[F_Theme] [varchar](50) NULL, CONSTRAINT [PK_SYS_USERLOGON] PRIMARY KEY NONCLUSTERED ([F_Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户登录主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_UserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_UserPassword'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户秘钥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_UserSecretkey'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许登录时间开始' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_AllowStartTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许登录时间结束' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_AllowEndTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'暂停用户开始日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_LockStartDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'暂停用户结束日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_LockEndDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_FirstVisitTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_PreviousVisitTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_LastVisitTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改密码日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_ChangePasswordDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许同时有多用户登录' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_MultiUserLogin'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_LogOnCount'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'在线状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_UserOnLine'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码提示问题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_Question'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码提示答案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_AnswerQuestion'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否访问限制' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_CheckIPAddress'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统语言' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_Language'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统样式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn', @level2type=N'COLUMN',@level2name=N'F_Theme'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户登录信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn'GO
二、用户表(Sys_Uers)
序号
列名
数据类型
长度
小数位
标识
主键
外键
允许空
默认值
说明
1
F_Id
varchar
50
0
是
否
用户主键
2
F_Account
varchar
50
0
是
账户
3
F_RealName
varchar
50
0
是
姓名
4
F_NickName
varchar
50
0
是
呢称
5
F_HeadIcon
varchar
50
0
是
头像
6
F_Gender
bit
1
0
是
性别
7
F_Birthday
datetime
8
3
是
生日
8
F_MobilePhone
varchar
20
0
是
手机
9
F_Email
varchar
50
0
是
邮箱
10
F_WeChat
varchar
50
0
是
微信
11
F_ManagerId
varchar
50
0
是
主管主键
12
F_SecurityLevel
int
4
0
是
安全级别
13
F_Signature
varchar
500
0
是
个性签名
14
F_OrganizeId
varchar
50
0
是
组织主键
15
F_DepartmentId
varchar
500
0
是
部门主键
16
F_RoleId
varchar
500
0
是
角色主键
17
F_DutyId
varchar
500
0
是
岗位主键
18
F_IsAdministrator
bit
1
0
是
是否管理员
19
F_SortCode
int
4
0
是
排序码
20
F_DeleteMark
bit
1
0
是
删除标志
21
F_EnabledMark
bit
1
0
是
有效标志
22
F_Description
varchar
500
0
是
描述
23
F_CreatorTime
datetime
8
3
是
创建时间
24
F_CreatorUserId
varchar
50
0
是
创建用户
25
F_LastModifyTime
datetime
8
3
是
最后修改时间
26
F_LastModifyUserId
varchar
50
0
是
最后修改用户
27
F_DeleteTime
datetime
8
3
是
删除时间
28
F_DeleteUserId
varchar
500
0
是
删除用户
sql语句:
/****** Object: Table [dbo].[Sys_User] Script Date: 2017/11/22 20:38:06 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Sys_User]([F_Id] [varchar](50) NOT NULL,[F_Account] [varchar](50) NULL,[F_RealName] [varchar](50) NULL,[F_NickName] [varchar](50) NULL,[F_HeadIcon] [varchar](50) NULL,[F_Gender] [bit] NULL,[F_Birthday] [datetime] NULL,[F_MobilePhone] [varchar](20) NULL,[F_Email] [varchar](50) NULL,[F_WeChat] [varchar](50) NULL,[F_ManagerId] [varchar](50) NULL,[F_SecurityLevel] [int] NULL,[F_Signature] [varchar](500) NULL,[F_OrganizeId] [varchar](50) NULL,[F_DepartmentId] [varchar](500) NULL,[F_RoleId] [varchar](500) NULL,[F_DutyId] [varchar](500) NULL,[F_IsAdministrator] [bit] NULL,[F_SortCode] [int] NULL,[F_DeleteMark] [bit] NULL,[F_EnabledMark] [bit] NULL,[F_Description] [varchar](500) NULL,[F_CreatorTime] [datetime] NULL,[F_CreatorUserId] [varchar](50) NULL,[F_LastModifyTime] [datetime] NULL,[F_LastModifyUserId] [varchar](50) NULL,[F_DeleteTime] [datetime] NULL,[F_DeleteUserId] [varchar](500) NULL, CONSTRAINT [PK_SYS_USER] PRIMARY KEY NONCLUSTERED ([F_Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'账户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_Account'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_RealName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'呢称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_NickName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_HeadIcon'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_Gender'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生日' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_Birthday'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_MobilePhone'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_Email'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_WeChat'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主管主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_ManagerId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全级别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_SecurityLevel'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'个性签名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_Signature'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_OrganizeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_DepartmentId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_RoleId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_DutyId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否管理员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_IsAdministrator'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_SortCode'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_EnabledMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_Description'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_CreatorTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_CreatorUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_LastModifyTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_LastModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_DeleteTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'F_DeleteUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User'GO
三、系统日志(Sys_Log)
序号
列名
数据类型
长度
小数位
标识
主键
外键
允许空
默认值
说明
1
F_Id
varchar
50
0
是
否
日志主键
2
F_Date
datetime
8
3
是
日期
3
F_Account
varchar
50
0
是
用户名
4
F_NickName
varchar
50
0
是
姓名
5
F_Type
varchar
50
0
是
类型
6
F_IPAddress
varchar
50
0
是
IP地址
7
F_IPAddressName
varchar
50
0
是
IP所在城市
8
F_ModuleId
varchar
50
0
是
系统模块Id
9
F_ModuleName
varchar
50
0
是
系统模块
10
F_Result
bit
1
0
是
结果
11
F_Description
varchar
500
0
是
描述
12
F_CreatorTime
datetime
8
3
是
创建时间
13
F_CreatorUserId
varchar
50
0
是
创建用户
/****** Object: Table [dbo].[Sys_Log] Script Date: 2017/11/22 20:38:06 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Sys_Log]([F_Id] [varchar](50) NOT NULL,[F_Date] [datetime] NULL,[F_Account] [varchar](50) NULL,[F_NickName] [varchar](50) NULL,[F_Type] [varchar](50) NULL,[F_IPAddress] [varchar](50) NULL,[F_IPAddressName] [varchar](50) NULL,[F_ModuleId] [varchar](50) NULL,[F_ModuleName] [varchar](50) NULL,[F_Result] [bit] NULL,[F_Description] [varchar](500) NULL,[F_CreatorTime] [datetime] NULL,[F_CreatorUserId] [varchar](50) NULL, CONSTRAINT [PK_SYS_LOG] PRIMARY KEY NONCLUSTERED ([F_Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_Date'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_Account'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_NickName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_Type'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IP地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_IPAddress'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IP所在城市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_IPAddressName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统模块Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_ModuleId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统模块' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_ModuleName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结果' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_Result'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_Description'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_CreatorTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'F_CreatorUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统日志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log'GO
四、数据库备份(Sys_DbBackup)
序号
列名
数据类型
长度
小数位
标识
主键
外键
允许空
默认值
说明
1
F_Id
varchar
50
0
是
否
备份主键
2
F_BackupType
varchar
50
0
是
备份类型
3
F_DbName
varchar
50
0
是
数据库名称
4
F_FileName
varchar
50
0
是
文件名称
5
F_FileSize
varchar
50
0
是
文件大小
6
F_FilePath
varchar
500
0
是
文件路径
7
F_BackupTime
datetime
8
3
是
备份时间
8
F_SortCode
int
4
0
是
排序码
9
F_DeleteMark
bit
1
0
是
删除标志
10
F_EnabledMark
bit
1
0
是
有效标志
11
F_Description
varchar
500
0
是
描述
12
F_CreatorTime
datetime
8
3
是
创建时间
13
F_CreatorUserId
varchar
50
0
是
创建用户
14
F_LastModifyTime
datetime
8
3
是
最后修改时间
15
F_LastModifyUserId
varchar
50
0
是
最后修改用户
16
F_DeleteTime
datetime
8
3
是
删除时间
17
F_DeleteUserId
varchar
500
0
是
删除用户
/****** Object: Table [dbo].[Sys_DbBackup] Script Date: 2017/11/22 20:38:06 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Sys_DbBackup]([F_Id] [varchar](50) NOT NULL,[F_BackupType] [varchar](50) NULL,[F_DbName] [varchar](50) NULL,[F_FileName] [varchar](50) NULL,[F_FileSize] [varchar](50) NULL,[F_FilePath] [varchar](500) NULL,[F_BackupTime] [datetime] NULL,[F_SortCode] [int] NULL,[F_DeleteMark] [bit] NULL,[F_EnabledMark] [bit] NULL,[F_Description] [varchar](500) NULL,[F_CreatorTime] [datetime] NULL,[F_CreatorUserId] [varchar](50) NULL,[F_LastModifyTime] [datetime] NULL,[F_LastModifyUserId] [varchar](50) NULL,[F_DeleteTime] [datetime] NULL,[F_DeleteUserId] [varchar](500) NULL, CONSTRAINT [PK_SYS_DBBACKUP] PRIMARY KEY NONCLUSTERED ([F_Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备份主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备份类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_BackupType'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_DbName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_FileName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件大小' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_FileSize'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_FilePath'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备份时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_BackupTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_SortCode'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_EnabledMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_Description'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_CreatorTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_CreatorUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_LastModifyTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_LastModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_DeleteTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup', @level2type=N'COLUMN',@level2name=N'F_DeleteUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库备份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup'GO
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 数据库设计
- 高并发下的HashMap
- ARM汇编配置重启代码分析
- Linux命令简介
- 银联支付证书下载及导出流程(带图)
- 【转载】为什么javainterface中变量默认final static
- 数据库设计
- 走进大前端:ES6深入剖析解析彩票项目实战
- 【Scikit-Learn 中文文档】最近邻
- 输入一些数求其平均数,以-1为结束标志
- Unable to save settings: Failed to save settings. Please restart PyCharm解决
- POJ 2240 Arbitrage
- 怎么做一个没有大坑的项目方案
- Blog20@linux启动阶段系统排错
- E-R图