一、用户登录信息表(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 ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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'
GO
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_UserId'
GO
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_UserPassword'
GO
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_UserSecretkey'
GO
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_AllowStartTime'
GO
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_AllowEndTime'
GO
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_LockStartDate'
GO
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_LockEndDate'
GO
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_FirstVisitTime'
GO
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_PreviousVisitTime'
GO
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_LastVisitTime'
GO
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_ChangePasswordDate'
GO
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_MultiUserLogin'
GO
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_LogOnCount'
GO
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_UserOnLine'
GO
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_Question'
GO
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_AnswerQuestion'
GO
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_CheckIPAddress'
GO
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_Language'
GO
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_Theme'
GO
EXEC 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 ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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'
GO
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_Account'
GO
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_RealName'
GO
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_NickName'
GO
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_HeadIcon'
GO
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_Gender'
GO
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_Birthday'
GO
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_MobilePhone'
GO
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_Email'
GO
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_WeChat'
GO
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_ManagerId'
GO
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_SecurityLevel'
GO
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_Signature'
GO
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_OrganizeId'
GO
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_DepartmentId'
GO
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_RoleId'
GO
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_DutyId'
GO
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_IsAdministrator'
GO
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_SortCode'
GO
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_DeleteMark'
GO
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_EnabledMark'
GO
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_Description'
GO
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_CreatorTime'
GO
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_CreatorUserId'
GO
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_LastModifyTime'
GO
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_LastModifyUserId'
GO
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_DeleteTime'
GO
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_DeleteUserId'
GO
EXEC 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 |
|
|
| 是 |
| 创建用户 |
sql语句:
/****** Object: Table [dbo].[Sys_Log] Script Date: 2017/11/22 20:38:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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'
GO
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_Date'
GO
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_Account'
GO
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_NickName'
GO
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_Type'
GO
EXEC 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'
GO
EXEC 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'
GO
EXEC 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'
GO
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_ModuleName'
GO
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_Result'
GO
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_Description'
GO
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_CreatorTime'
GO
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_CreatorUserId'
GO
EXEC 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 |
|
|
| 是 |
| 删除用户 |
sql语句:
/****** Object: Table [dbo].[Sys_DbBackup] Script Date: 2017/11/22 20:38:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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'
GO
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_BackupType'
GO
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_DbName'
GO
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_FileName'
GO
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_FileSize'
GO
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_FilePath'
GO
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_BackupTime'
GO
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_SortCode'
GO
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_DeleteMark'
GO
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_EnabledMark'
GO
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_Description'
GO
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_CreatorTime'
GO
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_CreatorUserId'
GO
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_LastModifyTime'
GO
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_LastModifyUserId'
GO
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_DeleteTime'
GO
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_DeleteUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库备份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup'
GO
标签:Description,dbo,EXEC,数据库,Sys,TABLE,GO,设计 From: https://blog.51cto.com/u_11566683/6149263