SiteCopy

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
CreateDate	datetime		Default = getutcdate()
Status	int	yes
ErrorLog	nvarchar(max)	yes
RollbackDate	datetime	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
OwnerUserID	int	yes	ClientUsers.ID
SourceClientSitesID	int	yes	ClientSites.ID
TargetClientSitesID	int	yes	ClientSites.ID
RollbackUserID	int	yes	ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_SiteCopy	ID	yes	yes