Tables [dbo].[ICRequests]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:41 AM Thursday, March 21, 2019
Last Modified1:11:52 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_ICRequests: RequestIDRequestIDint4
False
RequestNumbervarchar(15)15
False
Datedatetime8
False
Descriptionvarchar(255)255
False
ReqDatedatetime8
True
Remarksvarchar(255)255
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_ICRequests_AgentID_ShAgents: [dbo].[ShAgents].AgentIDAgentIDint4
True
Foreign Keys FK_ICRequests_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_ICRequests_NoteID_ICRequestNotes: [dbo].[ICRequestNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
NoteCountint4
False
((0))
Foreign Keys FK_ICRequests_ShTrackingConfigID_ShTrackingConfigs: [dbo].[ShTrackingConfigs].ShTrackingConfigIDShTrackingConfigIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICRequests: RequestIDPK_ICRequestsRequestID
True
80
NameColumns
FK_ICRequests_AgentID_ShAgentsAgentID->[dbo].[ShAgents].[AgentID]
FK_ICRequests_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ICRequests_NoteID_ICRequestNotesNoteID->[dbo].[ICRequestNotes].[NoteID]
FK_ICRequests_ShTrackingConfigID_ShTrackingConfigsShTrackingConfigID->[dbo].[ShTrackingConfigs].[ShTrackingConfigID]
CREATE TABLE [dbo].[ICRequests]
(
[RequestID] [int] NOT NULL,
[RequestNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReqDate] [datetime] NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ICRequests_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICRequests_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[AgentID] [int] NULL,
[BranchID] [int] NOT NULL,
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_ICRequests_NoteFlag] DEFAULT ((0)),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ICRequests_NoteCount] DEFAULT ((0)),
[ShTrackingConfigID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICRequests] ADD CONSTRAINT [PK_ICRequests] PRIMARY KEY CLUSTERED  ([RequestID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICRequests] ADD CONSTRAINT [FK_ICRequests_AgentID_ShAgents] FOREIGN KEY ([AgentID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ICRequests] ADD CONSTRAINT [FK_ICRequests_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICRequests] ADD CONSTRAINT [FK_ICRequests_NoteID_ICRequestNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[ICRequestNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ICRequests] ADD CONSTRAINT [FK_ICRequests_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO