CREATE TABLE [dbo].[ShEntryTypes]
(
[ShEntryTypeID] [int] NOT NULL IDENTITY(2000, 1),
[EntryName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeID] [int] NOT NULL,
[BaseTypeID] [int] NULL,
[EquipmentHistoryDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionTypeID] [int] NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_ShEntryTypes_Active] DEFAULT ((1)),
[CreatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ShEntryTypes_CreateDate] DEFAULT (getdate()),
[UpdateDate] [datetime] NOT NULL CONSTRAINT [DF_ShEntryTypes_UpdateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ShEntryTypes] ADD CONSTRAINT [PK_ShEntryTypes] PRIMARY KEY CLUSTERED ([ShEntryTypeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ShEntryTypes] ADD CONSTRAINT [FK_ShEntryTypes_BaseTypeID_ShEntryTypeBaseTypes] FOREIGN KEY ([BaseTypeID]) REFERENCES [dbo].[ShEntryTypeBaseTypes] ([BaseTypeID])
GO