Tables [dbo].[ServeqQuantityActual]
Properties
PropertyValue
HeapYes
Row Count (~)0
Created8:24:32 AM Friday, December 7, 2018
Last Modified7:28:51 PM Tuesday, September 24, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
ServeqQuantityActualIDint4
No
1 - 1
Foreign Keys FK_ServeqQuantityActual_Serveq: [dbo].[Serveq].ServeqFIDIndexes IX_ServeqQuantityActual_ServeqFID: ServeqFID\IsFromMobileApiServeqFIDint4
No
ReturnedQuantityint4
No
((0))
Foreign Keys FK_ServeqQuantityActual_Sysuser: [dbo].[Sysuser].ActualCreatedByIndexes IX_ServeqQuantityActual_ActualCreatedBy: ActualCreatedByActualCreatedByint4
No
Indexes IX_ServeqQuantityActual_ServeqFID: ServeqFID\IsFromMobileApiIsFromMobileApibit1
No
((0))
Datedatetime8
Yes
DeliveredQuantityint4
No
((0))
Indexes Indexes
NameColumns
IX_ServeqQuantityActual_ActualCreatedByActualCreatedBy
IX_ServeqQuantityActual_ServeqFIDServeqFID, IsFromMobileApi
Foreign Keys Foreign Keys
NameColumns
FK_ServeqQuantityActual_SysuserActualCreatedBy->[dbo].[Sysuser].[SysUserID]
FK_ServeqQuantityActual_ServeqServeqFID->[dbo].[Serveq].[PRIKEY]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[ServeqQuantityActual]
(
[ServeqQuantityActualID] [int] NOT NULL IDENTITY(1, 1),
[ServeqFID] [int] NOT NULL,
[ReturnedQuantity] [int] NOT NULL CONSTRAINT [DF_ServeqQuantityActual_ReturnedQuantity] DEFAULT ((0)),
[ActualCreatedBy] [int] NOT NULL,
[IsFromMobileApi] [bit] NOT NULL CONSTRAINT [DF_ServeqQuantityActual_IsFromMobileApi] DEFAULT ((0)),
[Date] [datetime] NULL,
[DeliveredQuantity] [int] NOT NULL CONSTRAINT [DF_ServeqQuantityActual_DeliveredQuantity] DEFAULT ((0))
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ServeqQuantityActual_ActualCreatedBy] ON [dbo].[ServeqQuantityActual] ([ActualCreatedBy]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ServeqQuantityActual_ServeqFID] ON [dbo].[ServeqQuantityActual] ([ServeqFID], [IsFromMobileApi]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ServeqQuantityActual] ADD CONSTRAINT [FK_ServeqQuantityActual_Sysuser] FOREIGN KEY ([ActualCreatedBy]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
ALTER TABLE [dbo].[ServeqQuantityActual] ADD CONSTRAINT [FK_ServeqQuantityActual_Serveq] FOREIGN KEY ([ServeqFID]) REFERENCES [dbo].[Serveq] ([PRIKEY])
GO
GRANT SELECT ON  [dbo].[ServeqQuantityActual] TO [MssExec]
GRANT INSERT ON  [dbo].[ServeqQuantityActual] TO [MssExec]
GRANT DELETE ON  [dbo].[ServeqQuantityActual] TO [MssExec]
GRANT UPDATE ON  [dbo].[ServeqQuantityActual] TO [MssExec]
GO
Uses