基于asp.net的个人博客系统

CREATE TABLE [dbo].[Employee] ( [EmployeeID] [int] IDENTITY (1, 1) NOT NULL , [EmployName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [EmployNo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Sex] [int] NULL , [Nationality] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Birthday] [datetime] NULL , [Political] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Culture] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Marital] [int] NULL , [FamilyPlace] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [IdentityCard] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Phone] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Mobile] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [HireDate] [datetime] NULL , [Position] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [State] [int] NULL , [BankName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [AccountNo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [PubName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Pubdate] [datetime] NULL , [DepartmentID] [int] NULL , [PictureID] [int] NULL , [Remark] [text] COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED ( [EmployeeID] ) ON [PRIMARY] , CONSTRAINT [FK_Employee_Department] FOREIGN KEY ( [DepartmentID] ) REFERENCES [dbo].[Department] ( [DepartmentID] ), CONSTRAINT [FK_Employee_Picture] FOREIGN KEY ( [PictureID] ) REFERENCES [dbo].[Picture] ( [PictureID] ) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO