简述

本文转自http://yuangang.cnblogs.com并加以整理。今天我们来建立几个表，考虑到他们之间的关系，并根据数据库生成EF实体模型。

索引

项目开始

表名：SYS_CODE

序号	列名	数据类型	长度	小数位	主键	允许空	说明
1	ID	int	4	0	是	否	主键ID
2	CODETYPE	nvarchar	50	0		是	代码类型
3	NAMETEXT	nvarchar	200	0		是	代码显示文本
4	CODEVALUE	nvarchar	100	0		是	代码值
5	SHOWORDER	int	4	0		是	排序值
6	ISCODE	int	4	0		是	是否为编码（0否1是）
7	REMARK	nvarchar	2000	0		是	备注
8	CREATEDATE	datetime	8	3		是	创建时间
9	CREATEUSER	nvarchar	36	0		是	创建者
10	UPDATEDATE	datetime	8	3		是	修改时间
11	UPDATEUSER	nvarchar	36	0		是	修改者
12	PARENTID	int	4	0		是	父级ID（使用时注意ISCODE为0）

表名：SYS_CODE_AREA

序号	列名	数据类型	长度	允许空	说明
1	ID	varchar	50	否	主键ID
2	PID	varchar	50	否	上级ID
3	NAME	nvarchar	200	是	名称
4	LEVELS	tinyint	1	否	级别

表名：SYS_DEPARTMENT

序号	列名	数据类型	长度	允许空	说明
1	ID	nvarchar	36	否	主键ID
2	CODE	nvarchar	100	是	部门编号，横向增长
3	NAME	nvarchar	200	是	部门名称
4	BUSINESSLEVEL	int	4	是	业务等级
5	SHOWORDER	int	4	是	部门排序
6	CREATEPERID	nvarchar	36	是	创建者编号
7	CREATEDATE	date	3	是	创建时间
8	PARENTID	nvarchar	36	是	上级部门ID
9	UPDATEDATE	date	3	是	修改时间
10	UPDATEUSER	nvarchar	36	是	修改人
11	PARENTCODE	nvarchar	100	是

表名：SYS_MODULE

序号	列名	数据类型	长度	小数位	标识	主键	外键	允许空	说明
1	ID	int	4	0	是	是		否	主键ID
2	FK_BELONGSYSTEM	nvarchar	36	0			是	否	所属系统
3	PARENTID	int	4	0				否	父ID，级联
4	NAME	nvarchar	50	0				是	显示名称
5	ALIAS	nvarchar	50	0				是	别名
6	MODULETYPE	int	4	0				否	模块类型
7	ICON	nvarchar	200	0				是	自定义图标
8	MODULEPATH	nvarchar	500	0				是	连接路径
9	ISSHOW	int	4	0				否	是否展示（0否1是）
10	SHOWORDER	int	4	0				否	排序值
11	LEVELS	int	4	0				否	级别
12	IsVillage	bit	1	0				否
13	CREATEUSER	nvarchar	50	0				是	创建者
14	CREATEDATE	datetime	8	3				是	创建时间
15	UPDATEUSER	nvarchar	36	0				是	修改者
16	UPDATEDATE	datetime	8	3				是	修改时间

表名：SYS_PERMISSION

序号	列名	数据类型	长度	标识	主键	外键	允许空	说明
1	ID	int	4	是	是		否	主键ID
2	MODULEID	int	4			是	否	模块ID
3	NAME	nvarchar	36				是	授权名称
4	PERVALUE	nvarchar	100				是	权限值（对应SYS_CODE表）
5	ICON	nvarchar	50				是	图标ID
6	SHOWORDER	int	4				是	显示排序
7	CREATEDATE	date	3				是	创建时间
8	CREATEUSER	nvarchar	36				是	创建者
9	UPDATEDATE	date	3				是	修改时间
10	UPDATEUSER	nvarchar	36				是	修改者

表名：SYS_POST

序号	列名	数据类型	长度	小数位	允许空	说明
1	ID	nvarchar	36	0	否	主键ID
2	POSTNAME	nvarchar	100	0	是	岗位名称
3	POSTTYPE	nvarchar	36	0	否	岗位类型
4	REMARK	nvarchar	500	0	是	岗位备注
5	SHOWORDER	int	4	0	是	排序
6	CREATEUSERID	int	4	0	是	创建者ID
7	CREATEDATE	datetime	8	3	否	创建时间
8	UPDATEDATE	datetime	8	3	是	修改时间
9	UPDATEUSER	nvarchar	36	0	是	修改者

表名：SYS_POST_DEPARTMENT

序号	列名	数据类型	长度	标识	主键	外键	允许空	说明
1	ID	int	4	是	是		否	主键ID
2	FK_DEPARTMENT_ID	nvarchar	36			是	否	部门ID
3	FK_POST_ID	nvarchar	36				否	岗位ID

表名：SYS_POST_USER

序号	列名	数据类型	长度	标识	主键	外键	允许空	说明
1	ID	int	4	是	是		否	主键ID
2	FK_USERID	int	4				否	用户ID
3	FK_POST_DEPARTMENTID	int	4			是	否	岗位部门ID

表名：SYS_ROLE

序号	列名	数据类型	长度	小数位	允许空	说明
1	ID	int	4	0	否	主键ID
2	ROLENAME	nvarchar	50	0	是	角色名称
3	ISCUSTOM	int	4	0	否	是否自定义（0否1是）
4	ROLEDESC	nvarchar	1000	0	是	角色说明
5	CREATEPERID	nvarchar	36	0	否	创建者ID（关联SYS_USER的ID）
6	CREATEDATE	datetime	8	3	否	创建时间
7	UPDATEDATE	datetime	8	3	否	修改时间
8	UPDATEUSER	nvarchar	36	0	是	修改者

表名：SYS_ROLE_PERMISSION

序号	列名	数据类型	长度	标识	主键	外键	允许空	说明
1	ID	int	4	是	是		否	主键ID
2	ROLEID	int	4				否	角色ID
3	PERMISSIONID	int	4			是	否	授权ID

表名：SYS_SYSTEM

序号	列名	数据类型	长度	允许空	说明
1	ID	nvarchar	36	否	主键ID
2	NAME	nvarchar	200	是	系统名称
3	SITEURL	nvarchar	500	是	系统地址
4	IS_LOGIN	tinyint	1	是	是否允许登录系统（0否1是）
5	DOCKUSER	nvarchar	100	是	系统对接用户名
6	DOCKPASS	nvarchar	200	是	系统对接密码
7	CREATEDATE	date	3	是	系统创建时间
8	REMARK	nvarchar	2000	是	备注

表名：SYS_USER_DEPARTMENT

序号	列名	数据类型	长度	标识	主键	外键	允许空	说明
1	ID	int	4	是	是		否	主键ID
2	USER_ID	int	4				否	用户ID
3	DEPARTMENT_ID	nvarchar	36			是	否	部门ID

表名：SYS_USER_PERMISSION

序号	列名	数据类型	长度	标识	主键	外键	允许空	说明
1	ID	int	4	是	是		否	主键ID
2	FK_USERID	int	4				否	用户ID
3	FK_PERMISSIONID	int	4			是	否	授权ID

表名：SYS_USER_ROLE

序号	列名	数据类型	长度	标识	主键	外键	允许空	说明
1	ID	int	4	是	是		否	主键ID
2	FK_USERID	int	4				否	用户ID
3	FK_ROLEID	int	4			是	否	角色ID

表名：SYS_USERINFO

序号	列名	数据类型	长度	小数位	主键	外键	允许空	说明
1	ID	int	4	0	是		否	主键ID
2	USERID	int	4	0		是	否	用户ID，外键
3	POSTCODE	int	4	0			是	职务，编码
4	PHONE	nvarchar	200	0			是	手机号码
5	OFFICEPHONE	nvarchar	200	0			是	办公电话
6	EMAILADDRESS	nvarchar	200	0			是	Email
7	SECONDPHONE	nvarchar	200	0			是	第二手机号码
8	WORKCODE	int	4	0			是	在岗状态，编码
9	SEXCODE	int	4	0			是	性别，编码
10	BIRTHDAY	datetime	8	3			是	出生日期
11	NATIONCODE	int	4	0			是	民族，编码
12	IDNUMBER	nvarchar	18	0			是	身份证号码
13	MARRYCODE	int	4	0			是	婚姻状况，编码
14	IDENTITYCODE	int	4	0			是	政治面貌，编码
15	HomeTown	nvarchar	200	0			是	籍贯，编码（关联至TBCode_Area的CodeValue）
16	ACCOUNTLOCATION	nvarchar	200	0			是	户籍所在地
17	XUELI	int	4	0			是	学历，编码
18	ZHICHENG	int	4	0			是	职称，编码
19	GRADUATIONSCHOOL	nvarchar	200	0			是	毕业院校
20	SPECIALTY	nvarchar	200	0			是	专业
21	PHOTOOLDNAME	nvarchar	200	0			是	照片原文件名
22	PHOTONEWNAME	nvarchar	200	0			是	照片新文件名
23	PHOTOTYPE	nvarchar	200	0			是	照片格式
24	RESUMEOLDNAME	nvarchar	200	0			是	简历原文件名
25	RESUMENEWNAME	nvarchar	200	0			是	简历新文件名
26	RESUMETYPE	nvarchar	200	0			是	简历格式
27	HuJiSuoZaiDi	nvarchar	200	0			是	户籍所在地，编码（关联至TBCode_Area的CodeValue）
28	HUJIPAICHUSUO	nvarchar	200	0			是	户籍所在派出所
29	WORKDATE	datetime	8	3			是	工作时间
30	JINRUDATE	datetime	8	3			是	加入公司时间
31	CARNUMBER	nvarchar	200	0			是	车牌号
32	QQ	nvarchar	15	0			是	QQ号
33	WEBCHATOPENID	nvarchar	200	0			是	微信公众账号对应的OpenID
34	CREATEDATE	datetime	8	3			是	创建时间
35	CREATEUSER	nvarchar	36	0			是	创建者
36	UPDATEDATE	datetime	8	3			是	修改时间
37	UPDATEUSER	nvarchar	36	0			是	修改者

以下是创建表的sql脚本：

USE [wkmvc_db]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_CODE](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [CODETYPE] [nvarchar](50) NULL,
    [NAMETEXT] [nvarchar](200) NULL,
    [CODEVALUE] [nvarchar](100) NULL,
    [SHOWORDER] [int] NULL,
    [ISCODE] [int] NULL,
    [REMARK] [nvarchar](2000) NULL,
    [CREATEDATE] [datetime] NULL,
    [CREATEUSER] [nvarchar](36) NULL,
    [UPDATEDATE] [datetime] NULL,
    [UPDATEUSER] [nvarchar](36) NULL,
    [PARENTID] [int] NULL,
 CONSTRAINT [PK_SYS_CODE] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SYS_CODE_AREA](
    [ID] [varchar](50) NOT NULL,
    [PID] [varchar](50) NOT NULL,
    [NAME] [nvarchar](200) NULL,
    [LEVELS] [tinyint] NOT NULL,
 CONSTRAINT [PK_SYS_CODE_AREA] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_DEPARTMENT](
    [ID] [nvarchar](36) NOT NULL,
    [CODE] [nvarchar](100) NULL,
    [NAME] [nvarchar](200) NULL,
    [BUSINESSLEVEL] [int] NULL,
    [SHOWORDER] [int] NULL,
    [CREATEPERID] [nvarchar](36) NULL,
    [CREATEDATE] [date] NULL,
    [PARENTID] [nvarchar](36) NULL,
    [UPDATEDATE] [date] NULL,
    [UPDATEUSER] [nvarchar](36) NULL,
    [PARENTCODE] [nvarchar](100) NULL,
 CONSTRAINT [PK_SYS_DEPARTMENT] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_MODULE](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FK_BELONGSYSTEM] [nvarchar](36) NOT NULL,
    [PARENTID] [int] NOT NULL,
    [NAME] [nvarchar](50) NULL,
    [ALIAS] [nvarchar](50) NULL,
    [MODULETYPE] [int] NOT NULL,
    [ICON] [nvarchar](200) NULL,
    [MODULEPATH] [nvarchar](500) NULL,
    [ISSHOW] [int] NOT NULL,
    [SHOWORDER] [int] NOT NULL,
    [LEVELS] [int] NOT NULL,
    [IsVillage] [bit] NOT NULL,
    [CREATEUSER] [nvarchar](50) NULL,
    [CREATEDATE] [datetime] NULL,
    [UPDATEUSER] [nvarchar](36) NULL,
    [UPDATEDATE] [datetime] NULL,
 CONSTRAINT [PK_SYS_MODULE] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_PERMISSION](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [MODULEID] [int] NOT NULL,
    [NAME] [nvarchar](36) NULL,
    [PERVALUE] [nvarchar](100) NULL,
    [ICON] [nvarchar](50) NULL,
    [SHOWORDER] [int] NULL,
    [CREATEDATE] [date] NULL,
    [CREATEUSER] [nvarchar](36) NULL,
    [UPDATEDATE] [date] NULL,
    [UPDATEUSER] [nvarchar](36) NULL,
 CONSTRAINT [PK_SYS_PERMISSION] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_POST](
    [ID] [nvarchar](36) NOT NULL,
    [POSTNAME] [nvarchar](100) NULL,
    [POSTTYPE] [nvarchar](36) NOT NULL,
    [REMARK] [nvarchar](500) NULL,
    [SHOWORDER] [int] NULL,
    [CREATEUSERID] [int] NULL,
    [CREATEDATE] [datetime] NOT NULL,
    [UPDATEDATE] [datetime] NULL,
    [UPDATEUSER] [nvarchar](36) NULL,
 CONSTRAINT [PK_SYS_POST] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_POST_DEPARTMENT](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FK_DEPARTMENT_ID] [nvarchar](36) NOT NULL,
    [FK_POST_ID] [nvarchar](36) NOT NULL,
 CONSTRAINT [PK_SYS_POST_DEPARTMENT] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_POST_USER](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FK_USERID] [int] NOT NULL,
    [FK_POST_DEPARTMENTID] [int] NOT NULL,
 CONSTRAINT [PK_SYS_POST_USER] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_ROLE](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [ROLENAME] [nvarchar](50) NULL,
    [ISCUSTOM] [int] NOT NULL,
    [ROLEDESC] [nvarchar](1000) NULL,
    [CREATEPERID] [nvarchar](36) NOT NULL,
    [CREATEDATE] [datetime] NOT NULL,
    [UPDATEDATE] [datetime] NOT NULL,
    [UPDATEUSER] [nvarchar](36) NULL,
 CONSTRAINT [PK_SYS_ROLE] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_ROLE_PERMISSION](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [ROLEID] [int] NOT NULL,
    [PERMISSIONID] [int] NOT NULL,
 CONSTRAINT [PK_SYS_ROLE_PERMISSION] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_SYSTEM](
    [ID] [nvarchar](36) NOT NULL,
    [NAME] [nvarchar](200) NULL,
    [SITEURL] [nvarchar](500) NULL,
    [IS_LOGIN] [tinyint] NULL,
    [DOCKUSER] [nvarchar](100) NULL,
    [DOCKPASS] [nvarchar](200) NULL,
    [CREATEDATE] [date] NULL,
    [REMARK] [nvarchar](2000) NULL,
 CONSTRAINT [PK_SYS_SYSTEM] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_USER_DEPARTMENT](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [USER_ID] [int] NOT NULL,
    [DEPARTMENT_ID] [nvarchar](36) NOT NULL,
 CONSTRAINT [PK_SYS_USER_DEPARTMENT] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_USER_PERMISSION](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FK_USERID] [int] NOT NULL,
    [FK_PERMISSIONID] [int] NOT NULL,
 CONSTRAINT [PK_SYS_USER_PERMISSION] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_USER_ROLE](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FK_USERID] [int] NOT NULL,
    [FK_ROLEID] [int] NOT NULL,
 CONSTRAINT [PK_SYS_USER_ROLE] PRIMARY KEY CLUSTERED
(
    [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]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SYS_USERINFO](
    [ID] [int] NOT NULL,
    [USERID] [int] NOT NULL,
    [POSTCODE] [int] NULL,
    [PHONE] [nvarchar](200) NULL,
    [OFFICEPHONE] [nvarchar](200) NULL,
    [EMAILADDRESS] [nvarchar](200) NULL,
    [SECONDPHONE] [nvarchar](200) NULL,
    [WORKCODE] [int] NULL,
    [SEXCODE] [int] NULL,
    [BIRTHDAY] [datetime] NULL,
    [NATIONCODE] [int] NULL,
    [IDNUMBER] [nvarchar](18) NULL,
    [MARRYCODE] [int] NULL,
    [IDENTITYCODE] [int] NULL,
    [HomeTown] [nvarchar](200) NULL,
    [ACCOUNTLOCATION] [nvarchar](200) NULL,
    [XUELI] [int] NULL,
    [ZHICHENG] [int] NULL,
    [GRADUATIONSCHOOL] [nvarchar](200) NULL,
    [SPECIALTY] [nvarchar](200) NULL,
    [PHOTOOLDNAME] [nvarchar](200) NULL,
    [PHOTONEWNAME] [nvarchar](200) NULL,
    [PHOTOTYPE] [nvarchar](200) NULL,
    [RESUMEOLDNAME] [nvarchar](200) NULL,
    [RESUMENEWNAME] [nvarchar](200) NULL,
    [RESUMETYPE] [nvarchar](200) NULL,
    [HuJiSuoZaiDi] [nvarchar](200) NULL,
    [HUJIPAICHUSUO] [nvarchar](200) NULL,
    [WORKDATE] [datetime] NULL,
    [JINRUDATE] [datetime] NULL,
    [CARNUMBER] [nvarchar](200) NULL,
    [QQ] [nvarchar](15) NULL,
    [WEBCHATOPENID] [nvarchar](200) NULL,
    [CREATEDATE] [datetime] NULL,
    [CREATEUSER] [nvarchar](36) NULL,
    [UPDATEDATE] [datetime] NULL,
    [UPDATEUSER] [nvarchar](36) NULL,
 CONSTRAINT [PK_SYS_USERINFO] PRIMARY KEY CLUSTERED
(
    [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]

GO
ALTER TABLE [dbo].[SYS_MODULE]  WITH CHECK ADD  CONSTRAINT [FK_SYS_MODULE_SYSTEMID] FOREIGN KEY([FK_BELONGSYSTEM])
REFERENCES [dbo].[SYS_SYSTEM] ([ID])
GO
ALTER TABLE [dbo].[SYS_MODULE] CHECK CONSTRAINT [FK_SYS_MODULE_SYSTEMID]
GO
ALTER TABLE [dbo].[SYS_PERMISSION]  WITH CHECK ADD  CONSTRAINT [FK_SYS_PERMISSION_MODULEID] FOREIGN KEY([MODULEID])
REFERENCES [dbo].[SYS_MODULE] ([ID])
GO
ALTER TABLE [dbo].[SYS_PERMISSION] CHECK CONSTRAINT [FK_SYS_PERMISSION_MODULEID]
GO
ALTER TABLE [dbo].[SYS_POST_DEPARTMENT]  WITH CHECK ADD  CONSTRAINT [FK_SYS_POST_DEPARTMENT_DPTID] FOREIGN KEY([FK_DEPARTMENT_ID])
REFERENCES [dbo].[SYS_DEPARTMENT] ([ID])
GO
ALTER TABLE [dbo].[SYS_POST_DEPARTMENT] CHECK CONSTRAINT [FK_SYS_POST_DEPARTMENT_DPTID]
GO
ALTER TABLE [dbo].[SYS_POST_DEPARTMENT]  WITH CHECK ADD  CONSTRAINT [FK_SYS_POST_DEPARTMENT_POSTID] FOREIGN KEY([FK_POST_ID])
REFERENCES [dbo].[SYS_POST] ([ID])
GO
ALTER TABLE [dbo].[SYS_POST_DEPARTMENT] CHECK CONSTRAINT [FK_SYS_POST_DEPARTMENT_POSTID]
GO
ALTER TABLE [dbo].[SYS_POST_USER]  WITH CHECK ADD  CONSTRAINT [FK_SYS_POST_USER_POSTDPTID] FOREIGN KEY([FK_POST_DEPARTMENTID])
REFERENCES [dbo].[SYS_POST_DEPARTMENT] ([ID])
GO
ALTER TABLE [dbo].[SYS_POST_USER] CHECK CONSTRAINT [FK_SYS_POST_USER_POSTDPTID]
GO
ALTER TABLE [dbo].[SYS_POST_USER]  WITH CHECK ADD  CONSTRAINT [FK_SYS_POST_USER_USERID] FOREIGN KEY([FK_USERID])
REFERENCES [dbo].[SYS_USER] ([ID])
GO
ALTER TABLE [dbo].[SYS_POST_USER] CHECK CONSTRAINT [FK_SYS_POST_USER_USERID]
GO
ALTER TABLE [dbo].[SYS_ROLE_PERMISSION]  WITH CHECK ADD  CONSTRAINT [FK_SYS_ROLE_PERMISSION_PERID] FOREIGN KEY([PERMISSIONID])
REFERENCES [dbo].[SYS_PERMISSION] ([ID])
GO
ALTER TABLE [dbo].[SYS_ROLE_PERMISSION] CHECK CONSTRAINT [FK_SYS_ROLE_PERMISSION_PERID]
GO
ALTER TABLE [dbo].[SYS_ROLE_PERMISSION]  WITH CHECK ADD  CONSTRAINT [FK_SYS_ROLE_PERMISSION_ROLEID] FOREIGN KEY([ROLEID])
REFERENCES [dbo].[SYS_ROLE] ([ID])
GO
ALTER TABLE [dbo].[SYS_ROLE_PERMISSION] CHECK CONSTRAINT [FK_SYS_ROLE_PERMISSION_ROLEID]
GO
ALTER TABLE [dbo].[SYS_USER_DEPARTMENT]  WITH CHECK ADD  CONSTRAINT [FK_SYS_USER_DEPARTMENT_DPTID] FOREIGN KEY([DEPARTMENT_ID])
REFERENCES [dbo].[SYS_DEPARTMENT] ([ID])
GO
ALTER TABLE [dbo].[SYS_USER_DEPARTMENT] CHECK CONSTRAINT [FK_SYS_USER_DEPARTMENT_DPTID]
GO
ALTER TABLE [dbo].[SYS_USER_DEPARTMENT]  WITH CHECK ADD  CONSTRAINT [FK_SYS_USER_DEPARTMENT_USERID] FOREIGN KEY([USER_ID])
REFERENCES [dbo].[SYS_USER] ([ID])
GO
ALTER TABLE [dbo].[SYS_USER_DEPARTMENT] CHECK CONSTRAINT [FK_SYS_USER_DEPARTMENT_USERID]
GO
ALTER TABLE [dbo].[SYS_USER_PERMISSION]  WITH CHECK ADD  CONSTRAINT [FK_SYS_USER_PERMISSION_PERID] FOREIGN KEY([FK_PERMISSIONID])
REFERENCES [dbo].[SYS_PERMISSION] ([ID])
GO
ALTER TABLE [dbo].[SYS_USER_PERMISSION] CHECK CONSTRAINT [FK_SYS_USER_PERMISSION_PERID]
GO
ALTER TABLE [dbo].[SYS_USER_PERMISSION]  WITH CHECK ADD  CONSTRAINT [FK_SYS_USER_PERMISSION_USERID] FOREIGN KEY([FK_USERID])
REFERENCES [dbo].[SYS_USER] ([ID])
GO
ALTER TABLE [dbo].[SYS_USER_PERMISSION] CHECK CONSTRAINT [FK_SYS_USER_PERMISSION_USERID]
GO
ALTER TABLE [dbo].[SYS_USER_ROLE]  WITH CHECK ADD  CONSTRAINT [FK_SYS_USER_ROLE_ROLEID] FOREIGN KEY([FK_ROLEID])
REFERENCES [dbo].[SYS_ROLE] ([ID])
GO
ALTER TABLE [dbo].[SYS_USER_ROLE] CHECK CONSTRAINT [FK_SYS_USER_ROLE_ROLEID]
GO
ALTER TABLE [dbo].[SYS_USER_ROLE]  WITH CHECK ADD  CONSTRAINT [FK_SYS_USER_ROLE_USERID] FOREIGN KEY([FK_USERID])
REFERENCES [dbo].[SYS_USER] ([ID])
GO
ALTER TABLE [dbo].[SYS_USER_ROLE] CHECK CONSTRAINT [FK_SYS_USER_ROLE_USERID]
GO
ALTER TABLE [dbo].[SYS_USERINFO]  WITH CHECK ADD  CONSTRAINT [FK_SYS_USERINFO_SYSUSERID] FOREIGN KEY([USERID])
REFERENCES [dbo].[SYS_USER] ([ID])
GO
ALTER TABLE [dbo].[SYS_USERINFO] CHECK CONSTRAINT [FK_SYS_USERINFO_SYSUSERID]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代码类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'CODETYPE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代码显示文本' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'NAMETEXT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'代码值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'CODEVALUE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'SHOWORDER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否为编码（0否1是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'ISCODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'REMARK'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'CREATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'CREATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'UPDATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'UPDATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级ID（使用时注意ISCODE为0）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE', @level2type=N'COLUMN',@level2name=N'PARENTID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE_AREA', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上级ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE_AREA', @level2type=N'COLUMN',@level2name=N'PID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE_AREA', @level2type=N'COLUMN',@level2name=N'NAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'级别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_CODE_AREA', @level2type=N'COLUMN',@level2name=N'LEVELS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门编号，横向增长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'CODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'NAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务等级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'BUSINESSLEVEL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'SHOWORDER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'CREATEPERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'CREATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上级部门ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'PARENTID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'UPDATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'UPDATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属系统' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'FK_BELONGSYSTEM'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父ID，级联' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'PARENTID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'NAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'别名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'ALIAS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模块类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'MODULETYPE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自定义图标' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'ICON'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'连接路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'MODULEPATH'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否展示（0否1是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'ISSHOW'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'SHOWORDER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'级别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'LEVELS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'CREATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'CREATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'UPDATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_MODULE', @level2type=N'COLUMN',@level2name=N'UPDATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模块ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'MODULEID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'授权名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'NAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限值（对应SYS_CODE表）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'PERVALUE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图标ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'ICON'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'SHOWORDER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'CREATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'CREATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'UPDATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_PERMISSION', @level2type=N'COLUMN',@level2name=N'UPDATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'POSTNAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'POSTTYPE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'REMARK'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'SHOWORDER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'CREATEUSERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'CREATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'UPDATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST', @level2type=N'COLUMN',@level2name=N'UPDATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'FK_DEPARTMENT_ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'FK_POST_ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST_USER', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST_USER', @level2type=N'COLUMN',@level2name=N'FK_USERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位部门ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_POST_USER', @level2type=N'COLUMN',@level2name=N'FK_POST_DEPARTMENTID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE', @level2type=N'COLUMN',@level2name=N'ROLENAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否自定义（0否1是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE', @level2type=N'COLUMN',@level2name=N'ISCUSTOM'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色说明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE', @level2type=N'COLUMN',@level2name=N'ROLEDESC'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者ID（关联SYS_USER的ID）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE', @level2type=N'COLUMN',@level2name=N'CREATEPERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE', @level2type=N'COLUMN',@level2name=N'CREATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE', @level2type=N'COLUMN',@level2name=N'UPDATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE', @level2type=N'COLUMN',@level2name=N'UPDATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE_PERMISSION', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE_PERMISSION', @level2type=N'COLUMN',@level2name=N'ROLEID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'授权ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_ROLE_PERMISSION', @level2type=N'COLUMN',@level2name=N'PERMISSIONID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_SYSTEM', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_SYSTEM', @level2type=N'COLUMN',@level2name=N'NAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_SYSTEM', @level2type=N'COLUMN',@level2name=N'SITEURL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否允许登录系统（0否1是）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_SYSTEM', @level2type=N'COLUMN',@level2name=N'IS_LOGIN'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统对接用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_SYSTEM', @level2type=N'COLUMN',@level2name=N'DOCKUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统对接密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_SYSTEM', @level2type=N'COLUMN',@level2name=N'DOCKPASS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_SYSTEM', @level2type=N'COLUMN',@level2name=N'CREATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_SYSTEM', @level2type=N'COLUMN',@level2name=N'REMARK'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'USER_ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_DEPARTMENT', @level2type=N'COLUMN',@level2name=N'DEPARTMENT_ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_PERMISSION', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_PERMISSION', @level2type=N'COLUMN',@level2name=N'FK_USERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'授权ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_PERMISSION', @level2type=N'COLUMN',@level2name=N'FK_PERMISSIONID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_ROLE', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_ROLE', @level2type=N'COLUMN',@level2name=N'FK_USERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USER_ROLE', @level2type=N'COLUMN',@level2name=N'FK_ROLEID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID，外键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'USERID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职务，编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'POSTCODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'PHONE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'办公电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'OFFICEPHONE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Email' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'EMAILADDRESS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第二手机号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'SECONDPHONE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'在岗状态，编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'WORKCODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别，编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'SEXCODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'BIRTHDAY'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'民族，编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'NATIONCODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份证号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'IDNUMBER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'婚姻状况，编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'MARRYCODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'政治面貌，编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'IDENTITYCODE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'籍贯，编码（关联至TBCode_Area的CodeValue）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'HomeTown'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'户籍所在地' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'ACCOUNTLOCATION'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学历，编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'XUELI'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职称，编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'ZHICHENG'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'毕业院校' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'GRADUATIONSCHOOL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专业' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'SPECIALTY'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片原文件名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'PHOTOOLDNAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片新文件名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'PHOTONEWNAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片格式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'PHOTOTYPE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简历原文件名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'RESUMEOLDNAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简历新文件名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'RESUMENEWNAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简历格式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'RESUMETYPE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'户籍所在地，编码（关联至TBCode_Area的CodeValue）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'HuJiSuoZaiDi'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'户籍所在派出所' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'HUJIPAICHUSUO'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'WORKDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加入公司时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'JINRUDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车牌号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'CARNUMBER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'QQ号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'QQ'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信公众账号对应的OpenID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'WEBCHATOPENID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'CREATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'CREATEUSER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'UPDATEDATE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYS_USERINFO', @level2type=N'COLUMN',@level2name=N'UPDATEUSER'
GO

当执行完脚本无误后，我们要根据现有的数据库更新EF实体模型。具体操作是在edmx空白区域右键→从数据库更新模型→选择所有表后点击完成

简述
索引
项目开始

Asp.net MVC系列教程6——丰富数据表、建立关联

简述

索引

项目开始

表名：SYS_CODE

表名：SYS_CODE_AREA

表名：SYS_DEPARTMENT

表名：SYS_MODULE

表名：SYS_PERMISSION

表名：SYS_POST

表名：SYS_POST_DEPARTMENT

表名：SYS_POST_USER

表名：SYS_ROLE

表名：SYS_ROLE_PERMISSION

表名：SYS_SYSTEM

表名：SYS_USER_DEPARTMENT

表名：SYS_USER_PERMISSION

表名：SYS_USER_ROLE

表名：SYS_USERINFO

FEATURED TAGS