【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-gzgl.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_职工信息表_职工分类编码表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[职工信息表] DROP CONSTRAINT FK_职工信息表_职工分类编码表
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_职工信息表_部门编码表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[职工信息表] DROP CONSTRAINT FK_职工信息表_部门编码表
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_用户菜单_用户]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[用户菜单] DROP CONSTRAINT FK_用户菜单_用户
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[使用单位]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[使用单位]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[职工分类编码表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[职工分类编码表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[部门编码表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[部门编码表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[职工信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[职工信息表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[月工资]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[月工资]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用户]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[用户]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用户菜单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[用户菜单]
GO
CREATE TABLE [dbo].[使用单位] (
[使用单位] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[职工分类编码表] (
[职工分类编码] [int] IDENTITY (1, 1) NOT NULL ,
[职工分类] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[部门编码表] (
[部门编码] [int] IDENTITY (1, 1) NOT NULL ,
[部门] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[职工信息表] (
[职工ID] [bigint] IDENTITY (1, 1) NOT NULL ,
[] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[性别] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[身份证号] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NULL ,
[银行帐号] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[部门编码] [int] NOT NULL ,
[职工分类编码] [int] NOT NULL ,
[基础工资] [money] NOT NULL ,
[岗位工资] [money] NOT NULL ,
[工会费] [money] NOT NULL ,
[公积金] [money] NOT NULL ,
[医保] [money] NOT NULL ,
[操作人1] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[操作人2] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[操作时间1] [datetime] NULL ,
[操作时间2] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[月工资] (
[ID] [bigint] IDENTITY (1, 1) NOT NULL ,
[职工ID] [bigint] NOT NULL ,
[年月] [varchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[性别] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[银行帐号] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[部门编码] [int] NOT NULL ,
[职工分类编码] [int] NOT NULL ,
[基础工资] [money] NOT NULL ,
[岗位工资] [money] NOT NULL ,
[所得税] [money] NOT NULL ,
[工会费] [money] NOT NULL ,
[公积金] [money] NOT NULL ,
[医保] [money] NOT NULL ,
[部门] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[职工分类] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[操作人] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[操作时间] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[用户] (
[用户] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[用户名] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[密码] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[操作人] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[操作时间] [datetime] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[用户菜单] (
[用户] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[菜单名] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[使用单位] WITH NOCHECK ADD
CONSTRAINT [PK_使用