Tables [dbo].[MoversConnectSetup]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)1
Created10:34:26 AM Monday, March 30, 2015
Last Modified7:28:37 PM Tuesday, September 24, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Primary Key PK_MoversConnectSetup: MoversConnectSetupIDCheck Constraints CK_MoversConnectSetupID : ([MoversConnectSetupID]=(1))MoversConnectSetupIDint4
No
CloudServiceLoginvarchar(255)255
No
CloudServiceUrlvarchar(255)255
No
CloudServiceAppNamevarchar(64)64
No
CloudServiceAppVersionvarchar(10)10
No
Tokenvarchar(max)max
Yes
TokenObtaineddatetime8
Yes
TokenExpiresdatetime8
Yes
Check Constraints CK_WorkTimeStart : ([WorkTimeStart]>=(0) AND [WorkTimeStart]<(24))WorkTimeStartnumeric(5,2)5
Yes
WorkTimeEndnumeric(5,2)5
Yes
UserNamevarchar(255)255
Yes
Passwordvarchar(255)255
Yes
DateModifieddatetime8
No
Foreign Keys FK_MoversConnectSetup_Sysuser: [dbo].[Sysuser].ModifiedBySysUserFIDModifiedBySysUserFIDint4
No
ActivateEmailbit1
No
EmailProfile[sys].[sysname]256
Yes
ConnectionsLastVerifiedDatedatetime8
Yes
ExternalAccountIdentifiervarchar(30)30
Yes
MoversConnectBaseUrlvarchar(255)255
No
(' ')
ApiServiceUrlvarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK_MoversConnectSetup: MoversConnectSetupIDPK_MoversConnectSetupMoversConnectSetupID
Yes
Check Constraints Check Constraints
NameOn ColumnConstraint
CK_MoversConnectSetupIDMoversConnectSetupID([MoversConnectSetupID]=(1))
CK_WorkTimeEnd([WorkTimeStart]<[WorkTimeEnd] AND [WorkTimeEnd]<=(24))
CK_WorkTimeStartWorkTimeStart([WorkTimeStart]>=(0) AND [WorkTimeStart]<(24))
Foreign Keys Foreign Keys
NameColumns
FK_MoversConnectSetup_SysuserModifiedBySysUserFID->[dbo].[Sysuser].[SysUserID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
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
Uses
Used By