CREATE TABLE [dbo].[TAログ] (
	[システムCD] [varchar] (12) NOT NULL ,
	[ログイン試行日時] [datetime] NOT NULL ,
	[Seq] [int] NOT NULL ,
	[ログインID] [varchar] (12) NULL ,
	[ログインパスワード] [varchar] (12) NULL ,
	[リモートアドレス] [varchar] (30) NULL ,
	[接続成否] [varchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TA区分] (
	[分類] [varchar] (50) NOT NULL ,
	[区分] [varchar] (50) NOT NULL ,
	[名称] [varchar] (100) NULL ,
	[表示順] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TAログ] ADD 
	CONSTRAINT [PK_TAログ] PRIMARY KEY  CLUSTERED 
	(
		[システムCD],
		[ログイン試行日時],
		[Seq]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[TA区分] ADD 
	CONSTRAINT [PK_TC9区分M] PRIMARY KEY  CLUSTERED 
	(
		[分類],
		[区分]
	)  ON [PRIMARY] 
GO