日期:2014-05-18 浏览次数:20769 次
USE [master] GO /****** 对象: Table [dbo].[Table_Emp] 脚本日期: 02/20/2012 15:36:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Table_Emp]( [Fid] [int] IDENTITY(1,1) NOT NULL, [FEmpName] [varchar](50) NULL, [Fsex] [char](10) NULL, [FHobby] [varchar](50) NULL, [FAge] [int] NULL, [FtypeID] [int] NULL, [FclassID] [int] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Emp', @level2type=N'COLUMN',@level2name=N'FEmpName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Emp', @level2type=N'COLUMN',@level2name=N'Fsex' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'爱好' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Emp', @level2type=N'COLUMN',@level2name=N'FHobby' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Emp', @level2type=N'COLUMN',@level2name=N'FAge' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'从事方向ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Emp', @level2type=N'COLUMN',@level2name=N'FtypeID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'从事类别ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Emp', @level2type=N'COLUMN',@level2name=N'FclassID'
USE [master]--企业要求表 GO /****** 对象: Table [dbo].[Table_Ent] 脚本日期: 02/20/2012 15:36:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Table_Ent]( [Fid] [int] IDENTITY(1,1) NOT NULL, [FEntName] [varchar](50) NULL, [FHobby_yaoqiu] [varchar](50) NULL, [FAge_yaoqiu] [int] NULL, [FtypeID_yaoqiu] [int] NULL, [FclassID_yaoqiu] [int] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'企业名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Ent', @level2type=N'COLUMN',@level2name=N'FEntName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'兴趣要求' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Ent', @level2type=N'COLUMN',@level2name=N'FHobby_yaoqiu' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄要求' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Ent', @level2type=N'COLUMN',@level2name=N'FAge_yaoqiu' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'从事方向要求' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Table_Ent', @level2type=N'COLUMN',@level2name=N'FtypeID_yaoqiu' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别要求' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'