devbox
从前慢现在也慢
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

数据库设计_数据库用户表设计

作者：从前慢现在也慢 | 2024-07-15 00:22:12

赞

踩

数据库用户表设计

一、用户登录信息表（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创建语句：

  1. /****** Object:  Table [dbo].[Sys_UserLogOn]    Script Date: 2017/11/22 20:38:06 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. SET ANSI_PADDING ON
  7. GO
  8. CREATE TABLE [dbo].[Sys_UserLogOn](
  9. 	[F_Id] [varchar](50) NOT NULL,
  10. 	[F_UserId] [varchar](50) NULL,
  11. 	[F_UserPassword] [varchar](50) NULL,
  12. 	[F_UserSecretkey] [varchar](50) NULL,
  13. 	[F_AllowStartTime] [datetime] NULL,
  14. 	[F_AllowEndTime] [datetime] NULL,
  15. 	[F_LockStartDate] [datetime] NULL,
  16. 	[F_LockEndDate] [datetime] NULL,
  17. 	[F_FirstVisitTime] [datetime] NULL,
  18. 	[F_PreviousVisitTime] [datetime] NULL,
  19. 	[F_LastVisitTime] [datetime] NULL,
  20. 	[F_ChangePasswordDate] [datetime] NULL,
  21. 	[F_MultiUserLogin] [bit] NULL,
  22. 	[F_LogOnCount] [int] NULL,
  23. 	[F_UserOnLine] [bit] NULL,
  24. 	[F_Question] [varchar](50) NULL,
  25. 	[F_AnswerQuestion] [varchar](500) NULL,
  26. 	[F_CheckIPAddress] [bit] NULL,
  27. 	[F_Language] [varchar](50) NULL,
  28. 	[F_Theme] [varchar](50) NULL,
  29.  CONSTRAINT [PK_SYS_USERLOGON] PRIMARY KEY NONCLUSTERED 
  30. (
  31. 	[F_Id] ASC
  32. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  33. ) ON [PRIMARY]

 

  1. 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'
  2. GO
  3. 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'
  4. GO
  5. 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'
  6. GO
  7. 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'
  8. GO
  9. 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'
  10. GO
  11. 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'
  12. GO
  13. 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'
  14. GO
  15. 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'
  16. GO
  17. 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'
  18. GO
  19. 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'
  20. GO
  21. 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'
  22. GO
  23. 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'
  24. GO
  25. 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'
  26. GO
  27. 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'
  28. GO
  29. 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'
  30. GO
  31. 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'
  32. GO
  33. 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'
  34. GO
  35. 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'
  36. GO
  37. 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'
  38. GO
  39. 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'
  40. GO
  41. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户登录信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_UserLogOn'
  42. 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语句：

  1. /****** Object:  Table [dbo].[Sys_User]    Script Date: 2017/11/22 20:38:06 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. SET ANSI_PADDING ON
  7. GO
  8. CREATE TABLE [dbo].[Sys_User](
  9. 	[F_Id] [varchar](50) NOT NULL,
  10. 	[F_Account] [varchar](50) NULL,
  11. 	[F_RealName] [varchar](50) NULL,
  12. 	[F_NickName] [varchar](50) NULL,
  13. 	[F_HeadIcon] [varchar](50) NULL,
  14. 	[F_Gender] [bit] NULL,
  15. 	[F_Birthday] [datetime] NULL,
  16. 	[F_MobilePhone] [varchar](20) NULL,
  17. 	[F_Email] [varchar](50) NULL,
  18. 	[F_WeChat] [varchar](50) NULL,
  19. 	[F_ManagerId] [varchar](50) NULL,
  20. 	[F_SecurityLevel] [int] NULL,
  21. 	[F_Signature] [varchar](500) NULL,
  22. 	[F_OrganizeId] [varchar](50) NULL,
  23. 	[F_DepartmentId] [varchar](500) NULL,
  24. 	[F_RoleId] [varchar](500) NULL,
  25. 	[F_DutyId] [varchar](500) NULL,
  26. 	[F_IsAdministrator] [bit] NULL,
  27. 	[F_SortCode] [int] NULL,
  28. 	[F_DeleteMark] [bit] NULL,
  29. 	[F_EnabledMark] [bit] NULL,
  30. 	[F_Description] [varchar](500) NULL,
  31. 	[F_CreatorTime] [datetime] NULL,
  32. 	[F_CreatorUserId] [varchar](50) NULL,
  33. 	[F_LastModifyTime] [datetime] NULL,
  34. 	[F_LastModifyUserId] [varchar](50) NULL,
  35. 	[F_DeleteTime] [datetime] NULL,
  36. 	[F_DeleteUserId] [varchar](500) NULL,
  37.  CONSTRAINT [PK_SYS_USER] PRIMARY KEY NONCLUSTERED 
  38. (
  39. 	[F_Id] ASC
  40. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  41. ) ON [PRIMARY]

 

  1. 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'
  2. GO
  3. 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'
  4. GO
  5. 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'
  6. GO
  7. 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'
  8. GO
  9. 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'
  10. GO
  11. 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'
  12. GO
  13. 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'
  14. GO
  15. 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'
  16. GO
  17. 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'
  18. GO
  19. 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'
  20. GO
  21. 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'
  22. GO
  23. 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'
  24. GO
  25. 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'
  26. GO
  27. 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'
  28. GO
  29. 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'
  30. GO
  31. 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'
  32. GO
  33. 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'
  34. GO
  35. 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'
  36. GO
  37. 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'
  38. GO
  39. 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'
  40. GO
  41. 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'
  42. GO
  43. 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'
  44. GO
  45. 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'
  46. GO
  47. 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'
  48. GO
  49. 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'
  50. GO
  51. 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'
  52. GO
  53. 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'
  54. GO
  55. 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'
  56. GO
  57. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User'
  58. 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语句：

  1. /****** Object:  Table [dbo].[Sys_Log]    Script Date: 2017/11/22 20:38:06 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. SET ANSI_PADDING ON
  7. GO
  8. CREATE TABLE [dbo].[Sys_Log](
  9. 	[F_Id] [varchar](50) NOT NULL,
  10. 	[F_Date] [datetime] NULL,
  11. 	[F_Account] [varchar](50) NULL,
  12. 	[F_NickName] [varchar](50) NULL,
  13. 	[F_Type] [varchar](50) NULL,
  14. 	[F_IPAddress] [varchar](50) NULL,
  15. 	[F_IPAddressName] [varchar](50) NULL,
  16. 	[F_ModuleId] [varchar](50) NULL,
  17. 	[F_ModuleName] [varchar](50) NULL,
  18. 	[F_Result] [bit] NULL,
  19. 	[F_Description] [varchar](500) NULL,
  20. 	[F_CreatorTime] [datetime] NULL,
  21. 	[F_CreatorUserId] [varchar](50) NULL,
  22.  CONSTRAINT [PK_SYS_LOG] PRIMARY KEY NONCLUSTERED 
  23. (
  24. 	[F_Id] ASC
  25. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  26. ) ON [PRIMARY]

 

  1. 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'
  2. GO
  3. 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'
  4. GO
  5. 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'
  6. GO
  7. 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'
  8. GO
  9. 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'
  10. GO
  11. 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'
  12. GO
  13. 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'
  14. GO
  15. 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'
  16. GO
  17. 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'
  18. GO
  19. 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'
  20. GO
  21. 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'
  22. GO
  23. 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'
  24. GO
  25. 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'
  26. GO
  27. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统日志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log'
  28. 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语句：

  1. /****** Object:  Table [dbo].[Sys_DbBackup]    Script Date: 2017/11/22 20:38:06 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. SET ANSI_PADDING ON
  7. GO
  8. CREATE TABLE [dbo].[Sys_DbBackup](
  9. 	[F_Id] [varchar](50) NOT NULL,
  10. 	[F_BackupType] [varchar](50) NULL,
  11. 	[F_DbName] [varchar](50) NULL,
  12. 	[F_FileName] [varchar](50) NULL,
  13. 	[F_FileSize] [varchar](50) NULL,
  14. 	[F_FilePath] [varchar](500) NULL,
  15. 	[F_BackupTime] [datetime] NULL,
  16. 	[F_SortCode] [int] NULL,
  17. 	[F_DeleteMark] [bit] NULL,
  18. 	[F_EnabledMark] [bit] NULL,
  19. 	[F_Description] [varchar](500) NULL,
  20. 	[F_CreatorTime] [datetime] NULL,
  21. 	[F_CreatorUserId] [varchar](50) NULL,
  22. 	[F_LastModifyTime] [datetime] NULL,
  23. 	[F_LastModifyUserId] [varchar](50) NULL,
  24. 	[F_DeleteTime] [datetime] NULL,
  25. 	[F_DeleteUserId] [varchar](500) NULL,
  26.  CONSTRAINT [PK_SYS_DBBACKUP] PRIMARY KEY NONCLUSTERED 
  27. (
  28. 	[F_Id] ASC
  29. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  30. ) ON [PRIMARY]

 

  1. 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'
  2. GO
  3. 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'
  4. GO
  5. 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'
  6. GO
  7. 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'
  8. GO
  9. 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'
  10. GO
  11. 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'
  12. GO
  13. 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'
  14. GO
  15. 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'
  16. GO
  17. 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'
  18. GO
  19. 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'
  20. GO
  21. 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'
  22. GO
  23. 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'
  24. GO
  25. 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'
  26. GO
  27. 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'
  28. GO
  29. 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'
  30. GO
  31. 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'
  32. GO
  33. 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'
  34. GO
  35. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库备份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DbBackup'
  36. GO

 

声明：本文内容由网友自发贡献，转载请注明出处：【wpsshop】
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号