ナレッジ-tblEmployee

ALTER TABLE [dbo].[tblCategory_1999FEB] DROP CONSTRAINT FK_tblCategory_1999FEB_16__17
GO

ALTER TABLE [dbo].[tblSyllabus_1999MAR] DROP CONSTRAINT FK_tblSyllabus_1999MAR_tblEmployee_1999FEB
GO

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

CREATE TABLE [dbo].[tblEmployee_1999FEB] (
[nEmployeeID] [int] IDENTITY (1, 1) NOT NULL ,
[szEmployeeNameJPN] [varchar] (16) NOT NULL ,
[nPersonID] [int] NOT NULL ,
[szPersonName] [varchar] (16) NOT NULL ,
[szPersonLastNameJPN] [varchar] (8) NOT NULL ,
[szPersonFirstNameJPN] [varchar] (8) NOT NULL ,
[szPersonNameRuby] [varchar] (32) NOT NULL ,
[szPersonLastNameRuby] [varchar] (16) NOT NULL ,
[szPersonFirstNameRuby] [varchar] (16) NOT NULL ,
[szPersonRomaji] [varchar] (32) NOT NULL ,
[szPersonLastName] [varchar] (16) NOT NULL ,
[szPersonFirstName] [varchar] (16) NOT NULL ,
[dtBirthday] [datetime] NOT NULL ,
[nAffiliationID] [int] NOT NULL ,
[ID_Section] [int] NOT NULL ,
[ID_Position] [int] NOT NULL ,
[memoPersonComment] [text] NULL ,
[szPersonEMail] [text] NULL ,
[szPersonTel] [varchar] (32) NOT NULL ,
[szPersonFax] [varchar] (32) NOT NULL ,
[szPasonEMailName] [varchar] (16) NOT NULL ,
[szEmployeeHomePostalCode] [varchar] (8) NOT NULL ,
[szEmployeeHomeAddress] [text] NULL ,
[szEmployeeHomeTel] [varchar] (32) NOT NULL ,
[szEmployeeExtTel] [varchar] (4) NOT NULL ,
[dPersonUpdated] [datetime] NULL ,
[dPersonRegisted] [datetime] NULL ,
[dPersonExpired] [datetime] NULL ,
[bPersonDeleted] [int] NOT NULL ,
[szEmployeeUserName] [char] (64) NULL ,
[szPersonPassWord] [varchar] (16) NULL ,
[szPersonRemoteIP] [varchar] (16) NULL ,
[bPersonIPLock] [int] NULL ,
[bPersonDirty] [int] NULL ,
[nPage] [int] NULL ,
[nLocationID] [int] NULL
)
GO