Tables [dbo].[CommissionedDetailHold]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created7:29:54 PM Tuesday, June 11, 2024
Last Modified7:29:54 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_CommissionedDetailHold: CommissionedDetailHoldIDIndexes IX_CommissionedDetailHold_CommissionedDetail: CommissionedDetailFID\CommissionedDetailHoldIDCommissionedDetailHoldIDint4
No
1 - 1
Foreign Keys FK_CommissionedDetailHold_CommissionedDetail: [dbo].[CommissionedDetail].CommissionedDetailFIDIndexes IX_CommissionedDetailHold_CommissionedDetail: CommissionedDetailFID\CommissionedDetailHoldIDCommissionedDetailFIDint4
No
Foreign Keys FK_CommissionedDetailHold_Sysuser: [dbo].[Sysuser].SysUserFIDSysUserFIDint4
No
ChangedOndatetime8
No
HoldUpdateStatusbit1
No
HoldUpdateDescriptionvarchar(30)30
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_CommissionedDetailHold: CommissionedDetailHoldIDPK_CommissionedDetailHoldCommissionedDetailHoldID
Yes
IX_CommissionedDetailHold_CommissionedDetailCommissionedDetailFID, CommissionedDetailHoldID
Foreign Keys Foreign Keys
NameColumns
FK_CommissionedDetailHold_CommissionedDetailCommissionedDetailFID->[dbo].[CommissionedDetail].[CDPriKey]
FK_CommissionedDetailHold_SysuserSysUserFID->[dbo].[Sysuser].[SysUserID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[CommissionedDetailHold]
(
[CommissionedDetailHoldID] [int] NOT NULL IDENTITY(1, 1),
[CommissionedDetailFID] [int] NOT NULL,
[SysUserFID] [int] NOT NULL,
[ChangedOn] [datetime] NOT NULL,
[HoldUpdateStatus] [bit] NOT NULL,
[HoldUpdateDescription] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CommissionedDetailHold] ADD CONSTRAINT [PK_CommissionedDetailHold] PRIMARY KEY CLUSTERED  ([CommissionedDetailHoldID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CommissionedDetailHold_CommissionedDetail] ON [dbo].[CommissionedDetailHold] ([CommissionedDetailFID], [CommissionedDetailHoldID] DESC) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CommissionedDetailHold] ADD CONSTRAINT [FK_CommissionedDetailHold_CommissionedDetail] FOREIGN KEY ([CommissionedDetailFID]) REFERENCES [dbo].[CommissionedDetail] ([CDPriKey])
GO
ALTER TABLE [dbo].[CommissionedDetailHold] ADD CONSTRAINT [FK_CommissionedDetailHold_Sysuser] FOREIGN KEY ([SysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[CommissionedDetailHold] TO [MssExec]
GRANT INSERT ON  [dbo].[CommissionedDetailHold] TO [MssExec]
GRANT DELETE ON  [dbo].[CommissionedDetailHold] TO [MssExec]
GRANT UPDATE ON  [dbo].[CommissionedDetailHold] TO [MssExec]
GO
Uses