[dbo].[AgentConsultingHistory]

(local) > SupportBridge > Tables > dbo.AgentConsultingHistory

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Row Count	2
Created	12:44:46 PM Thursday, October 04, 2007
Last Modified	12:44:46 PM Thursday, October 04, 2007

Columns

Name	Data Type	Max Length (Bytes)	Identity
id	int	4	1 - 1
userID	int	4
epoch	decimal(18,0)	9
groupID	int	4
type	int	4
targetID	int	4
divisionID	int	4

Indexes

	Name	Columns	Unique
	PK__AgentConsultingH__6E8B6712	id

SQL Script

CREATE TABLE [dbo].[AgentConsultingHistory]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[userID] [int] NOT NULL,
[epoch] [decimal] (18, 0) NOT NULL,
[groupID] [int] NULL,
[type] [int] NULL,
[targetID] [int] NULL,
[divisionID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AgentConsultingHistory] ADD CONSTRAINT [PK__AgentConsultingH__6E8B6712] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO

Uses