[dbo].[MoversConnectSetup]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count (~)	1
Created	10:34:26 AM Monday, March 30, 2015
Last Modified	9:09:40 AM Friday, November 8, 2024

Name	Data Type	Max Length (Bytes)	Default
MoversConnectSetupID	int	4
CloudServiceLogin	varchar(255)	255
CloudServiceUrl	varchar(255)	255
CloudServiceAppName	varchar(64)	64
CloudServiceAppVersion	varchar(10)	10
Token	varchar(max)	max
TokenObtained	datetime	8
TokenExpires	datetime	8
WorkTimeStart	numeric(5,2)	5
WorkTimeEnd	numeric(5,2)	5
UserName	varchar(255)	255
Password	varchar(255)	255
DateModified	datetime	8
ModifiedBySysUserFID	int	4
ActivateEmail	bit	1
EmailProfile	[sys].[sysname]	256
ConnectionsLastVerifiedDate	datetime	8
ExternalAccountIdentifier	varchar(30)	30
MoversConnectBaseUrl	varchar(255)	255	(' ')
ApiServiceUrl	varchar(255)	255

	Name	Columns	Unique
	PK_MoversConnectSetup	MoversConnectSetupID

Name	On Column	Constraint
CK_MoversConnectSetupID	MoversConnectSetupID	([MoversConnectSetupID]=(1))
CK_WorkTimeEnd		([WorkTimeStart]<[WorkTimeEnd] AND [WorkTimeEnd]<=(24))
CK_WorkTimeStart	WorkTimeStart	([WorkTimeStart]>=(0) AND [WorkTimeStart]<(24))

Name	Columns
FK_MoversConnectSetup_Sysuser	ModifiedBySysUserFID->[dbo].[Sysuser].[SysUserID]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

CREATE TABLE [dbo].[MoversConnectSetup]
(
[MoversConnectSetupID] [int] NOT NULL,
[CloudServiceLogin] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CloudServiceUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CloudServiceAppName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CloudServiceAppVersion] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Token] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TokenObtained] [datetime] NULL,
[TokenExpires] [datetime] NULL,
[WorkTimeStart] [numeric] (5, 2) NULL,
[WorkTimeEnd] [numeric] (5, 2) NULL,
[UserName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateModified] [datetime] NOT NULL,
[ModifiedBySysUserFID] [int] NOT NULL,
[ActivateEmail] [bit] NOT NULL,
[EmailProfile] [sys].[sysname] NULL,
[ConnectionsLastVerifiedDate] [datetime] NULL,
[ExternalAccountIdentifier] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MoversConnectBaseUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_MoversConnectSetup_MoversConnectBaseUrl] DEFAULT (' '),
[ApiServiceUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [CK_MoversConnectSetupID] CHECK (([MoversConnectSetupID]=(1)))
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [CK_WorkTimeEnd] CHECK (([WorkTimeStart]<[WorkTimeEnd] AND [WorkTimeEnd]<=(24)))
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [CK_WorkTimeStart] CHECK (([WorkTimeStart]>=(0) AND [WorkTimeStart]<(24)))
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [PK_MoversConnectSetup] PRIMARY KEY NONCLUSTERED  ([MoversConnectSetupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [FK_MoversConnectSetup_Sysuser] FOREIGN KEY ([ModifiedBySysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[MoversConnectSetup] TO [MssExec]
GRANT INSERT ON  [dbo].[MoversConnectSetup] TO [MssExec]
GRANT DELETE ON  [dbo].[MoversConnectSetup] TO [MssExec]
GRANT UPDATE ON  [dbo].[MoversConnectSetup] TO [MssExec]
GO