DB_51Aspx/sql2000/奖惩记录数据表.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [MyPersonnel]
GO
/****** 对象:  Table [dbo].[奖惩记录]    脚本日期: 02/23/2007 11:05:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[奖惩记录](
	[自编号] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[员工编号] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[员工姓名] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[奖惩日期] [datetime] NULL,
	[奖惩类型] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[奖惩原因] [nvarchar](150) COLLATE Chinese_PRC_CI_AS NULL,
	[奖惩批准单位] [nvarchar](150) COLLATE Chinese_PRC_CI_AS NULL,
	[解除处分日期] [datetime] NULL,
	[说明] [nvarchar](150) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_奖惩记录] PRIMARY KEY CLUSTERED 
(
	[自编号] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
USE [MyPersonnel]
GO
ALTER TABLE [dbo].[奖惩记录]  WITH CHECK ADD  CONSTRAINT [FK_奖惩记录_基本档案] FOREIGN KEY([员工编号])
REFERENCES [dbo].[基本档案] ([员工编号])