Tables [dbo].[ShEntryTypes]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:07 AM Thursday, March 21, 2019
Last Modified1:15:36 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_ShEntryTypes: ShEntryTypeIDShEntryTypeIDint4
False
2000 - 1
EntryNamevarchar(50)50
False
Descriptionvarchar(255)255
True
TypeIDint4
False
Foreign Keys FK_ShEntryTypes_BaseTypeID_ShEntryTypeBaseTypes: [dbo].[ShEntryTypeBaseTypes].BaseTypeIDBaseTypeIDint4
True
EquipmentHistoryDescriptionvarchar(50)50
True
TransactionTypeIDint4
True
Activebit1
False
((1))
CreatorIDvarchar(8)8
False
UpdatorIDvarchar(8)8
False
CreateDatedatetime8
False
(getdate())
UpdateDatedatetime8
False
(getdate())
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ShEntryTypes: ShEntryTypeIDPK_ShEntryTypesShEntryTypeID
True
80
NameColumns
FK_ShEntryTypes_BaseTypeID_ShEntryTypeBaseTypesBaseTypeID->[dbo].[ShEntryTypeBaseTypes].[BaseTypeID]
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