Tables [dbo].[MoveType]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)1179
Created4:57:08 PM Thursday, September 7, 2006
Last Modified9:10:52 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_MOVETYPE: PriKeyPriKeyint4
No
1 - 1
Indexes IX_MoveType_MoveName_BranchPriKey: MoveName\BranchPriKeyMoveNamevarchar(15)15
No
IsLongDistanceDispatchbit1
No
((0))
Foreign Keys FK_MOVETYPE_OrderNumbers: [dbo].[OrderNumbers].OrderNumbersIDOrderNumbersIDint4
Yes
Foreign Keys FK_MOVETYPE_BRANCH: [dbo].[Branch].BranchPriKeyIndexes IX_MoveType_MoveName_BranchPriKey: MoveName\BranchPriKeyBranchPriKeyint4
No
Foreign Keys FK_MOVETYPE_MoveTypeGroups: [dbo].[MoveTypeGroups].MTGroupPriKeyMTGroupPriKeyint4
No
ManualOrderNumberint4
Yes
Inactivebit1
No
((0))
InternationalAutoRegisterbit1
No
((0))
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_MOVETYPE: PriKeyPK_MOVETYPEPriKey
Yes
80
IX_MoveType_MoveName_BranchPriKeyMoveName, BranchPriKey
Yes
80
Foreign Keys Foreign Keys
NameColumns
FK_MOVETYPE_BRANCHBranchPriKey->[dbo].[Branch].[BranchPriKey]
FK_MOVETYPE_MoveTypeGroupsMTGroupPriKey->[dbo].[MoveTypeGroups].[MTGroupPriKey]
FK_MOVETYPE_OrderNumbersOrderNumbersID->[dbo].[OrderNumbers].[OrderNumbersID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[MoveType]
(
[PriKey] [int] NOT NULL IDENTITY(1, 1),
[MoveName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsLongDistanceDispatch] [bit] NOT NULL CONSTRAINT [DF_MoveType_IsLongDistanceDispatch] DEFAULT ((0)),
[OrderNumbersID] [int] NULL,
[BranchPriKey] [int] NOT NULL,
[MTGroupPriKey] [int] NOT NULL,
[ManualOrderNumber] [int] NULL,
[Inactive] [bit] NOT NULL CONSTRAINT [DF_MoveType_Inactive] DEFAULT ((0)),
[InternationalAutoRegister] [bit] NOT NULL CONSTRAINT [DF_MoveType_InternationalAutoRegister] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoveType] ADD CONSTRAINT [PK_MOVETYPE] PRIMARY KEY CLUSTERED  ([PriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoveType] ADD CONSTRAINT [IX_MoveType_MoveName_BranchPriKey] UNIQUE NONCLUSTERED  ([MoveName], [BranchPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoveType] ADD CONSTRAINT [FK_MOVETYPE_BRANCH] FOREIGN KEY ([BranchPriKey]) REFERENCES [dbo].[Branch] ([BranchPriKey])
GO
ALTER TABLE [dbo].[MoveType] ADD CONSTRAINT [FK_MOVETYPE_MoveTypeGroups] FOREIGN KEY ([MTGroupPriKey]) REFERENCES [dbo].[MoveTypeGroups] ([MTGroupPriKey])
GO
ALTER TABLE [dbo].[MoveType] ADD CONSTRAINT [FK_MOVETYPE_OrderNumbers] FOREIGN KEY ([OrderNumbersID]) REFERENCES [dbo].[OrderNumbers] ([OrderNumbersID])
GO
GRANT SELECT ON  [dbo].[MoveType] TO [MssExec]
GRANT INSERT ON  [dbo].[MoveType] TO [MssExec]
GRANT DELETE ON  [dbo].[MoveType] TO [MssExec]
GRANT UPDATE ON  [dbo].[MoveType] TO [MssExec]
GO
Uses
Used By