Tables [dbo].[CTTeamDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:17 AM Thursday, March 21, 2019
Last Modified1:10:47 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_CTTeamDetails: TeamIDForeign Keys FK_CTTeamDetails_TeamID_SATeams: [dbo].[SATeams].TeamIDTeamIDint4
False
Foreign Keys FK_CTTeamDetails_ManagerID_SHAgents: [dbo].[ShAgents].ManagerIDManagerIDint4
False
Foreign Keys FK_CTTeamDetails_CommissionModeID_CTCommissionModes: [dbo].[CTCommissionModes].CommissionModeIDCommissionModeIDint4
False
IsDollarRewardbit1
False
TeamTypeint4
False
((1))
Activebit1
False
((1))
CreatorIDchar(8)8
False
UpdaterIDchar(8)8
False
CreateDatedatetime8
False
LastUpdatedatetime8
False
timestamptimestamp8
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_CTTeamDetails: TeamIDPK_CTTeamDetailsTeamID
True
80
NameColumns
FK_CTTeamDetails_CommissionModeID_CTCommissionModesCommissionModeID->[dbo].[CTCommissionModes].[CommissionModeID]
FK_CTTeamDetails_ManagerID_SHAgentsManagerID->[dbo].[ShAgents].[AgentID]
FK_CTTeamDetails_TeamID_SATeamsTeamID->[dbo].[SATeams].[TeamID]
CREATE TABLE [dbo].[CTTeamDetails]
(
[TeamID] [int] NOT NULL,
[ManagerID] [int] NOT NULL,
[CommissionModeID] [int] NOT NULL,
[IsDollarReward] [bit] NOT NULL,
[TeamType] [int] NOT NULL CONSTRAINT [DF_CTTeamDetails_TeamType] DEFAULT ((1)),
[Active] [bit] NOT NULL CONSTRAINT [DF_CTTeamDetails_Active] DEFAULT ((1)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdaterID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[timestamp] [timestamp] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTTeamDetails] ADD CONSTRAINT [PK_CTTeamDetails] PRIMARY KEY CLUSTERED  ([TeamID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTTeamDetails] ADD CONSTRAINT [FK_CTTeamDetails_CommissionModeID_CTCommissionModes] FOREIGN KEY ([CommissionModeID]) REFERENCES [dbo].[CTCommissionModes] ([CommissionModeID])
GO
ALTER TABLE [dbo].[CTTeamDetails] ADD CONSTRAINT [FK_CTTeamDetails_ManagerID_SHAgents] FOREIGN KEY ([ManagerID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[CTTeamDetails] ADD CONSTRAINT [FK_CTTeamDetails_TeamID_SATeams] FOREIGN KEY ([TeamID]) REFERENCES [dbo].[SATeams] ([TeamID])
GO