Tables [dbo].[SelfHealingUser]
Properties
PropertyValue
Row Count0
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__SelfHealingUser__39E294A9: userIDForeign Keys FK__SelfHeali__userI__3AD6B8E2: [dbo].[Users].userIDuserIDint4
No
divisionIDint4
No
Foreign Keys FK__SelfHeali__group__3BCADD1B: [dbo].[SHGroup].groupIDgroupIDint4
No
NextUpdateEpochdecimal(18,0)9
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__SelfHealingUser__39E294A9: userIDPK__SelfHealingUser__39E294A9userID
Yes
Foreign Keys Foreign Keys
NameColumns
FK__SelfHeali__group__3BCADD1BgroupID->[dbo].[SHGroup].[groupID]
FK__SelfHeali__userI__3AD6B8E2userID->[dbo].[Users].[userID]
SQL Script
CREATE TABLE [dbo].[SelfHealingUser]
(
[userID] [int] NOT NULL,
[divisionID] [int] NOT NULL,
[groupID] [int] NOT NULL,
[NextUpdateEpoch] [decimal] (18, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SelfHealingUser] ADD CONSTRAINT [PK__SelfHealingUser__39E294A9] PRIMARY KEY CLUSTERED ([userID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SelfHealingUser] ADD CONSTRAINT [FK__SelfHeali__group__3BCADD1B] FOREIGN KEY ([groupID]) REFERENCES [dbo].[SHGroup] ([groupID])
GO
ALTER TABLE [dbo].[SelfHealingUser] ADD CONSTRAINT [FK__SelfHeali__userI__3AD6B8E2] FOREIGN KEY ([userID]) REFERENCES [dbo].[Users] ([userID])
GO
Uses
Used By