if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TDA社員M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TDA社員M]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TTA社員台帳M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TTA社員台帳M]
GO

CREATE TABLE [dbo].[TDA社員M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[社員CD] [int] NOT NULL ,
	[氏名] [varchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TTA社員台帳M] (
	[システムCD] [varchar] (12) NOT NULL ,
	[演習CD] [varchar] (12) NOT NULL ,
	[会社CD] [varchar] (20) NOT NULL ,
	[社員番号] [int] NOT NULL ,
	[マスタCD] [int] NULL ,
	[社員番号ラベル] [varchar] (50) NULL ,
	[氏名] [varchar] (20) NULL ,
	[郵便番号] [varchar] (8) NULL ,
	[住所] [varchar] (50) NULL ,
	[電話番号] [varchar] (15) NULL ,
	[ケータイ] [varchar] (15) NULL ,
	[生年月日] [datetime] NULL ,
	[扶養家族人数] [smallint] NULL ,
	[入社年月日] [datetime] NULL ,
	[離職年月日] [datetime] NULL ,
	[役職] [varchar] (20) NULL ,
	[基本給] [money] NULL ,
	[職務手当] [money] NULL ,
	[家族手当] [money] NULL ,
	[住宅手当] [money] NULL ,
	[精勤手当] [money] NULL ,
	[皆勤手当] [money] NULL ,
	[通勤手当] [money] NULL ,
	[健康保険] [money] NULL ,
	[厚生年金] [money] NULL ,
	[年金基金] [money] NULL ,
	[雇用保険] [money] NULL ,
	[介護保険] [money] NULL ,
	[代表取締役フラグ] [varchar] (2) NULL ,
	[学生番号] [varchar] (12) NULL ,
	[予備あ] [varchar] (200) NULL ,
	[予備い] [varchar] (200) NULL ,
	[予備う] [varchar] (200) NULL ,
	[予備1] [int] NULL ,
	[予備2] [int] NULL ,
	[予備3] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TDA社員M] ADD 
	CONSTRAINT [PK_TDA社員M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[社員CD]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TTA社員台帳M] ADD 
	CONSTRAINT [PK_TTA社員台帳M] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[演習CD],
		[会社CD],
		[社員番号]
	)  ON [PRIMARY] 
GO