[dbo].[XmlExternalInterfaceLogin]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count (~)	0
Created	5:34:51 PM Monday, May 4, 2009
Last Modified	7:30:27 PM Thursday, August 29, 2024

	Name	Data Type	Max Length (Bytes)	Identity
	XmlExternalInterfaceLoginID	int	4	1 - 1
$Indexes IX_XmlExternalInterfaceLogin_XMLInterface_UserAccess: XmlInterfaceFID\UserAccessFID$	XmlInterfaceFID	int	4
$Indexes IX_XmlExternalInterfaceLogin_XMLInterface_UserAccess: XmlInterfaceFID\UserAccessFID$	UserAccessFID	int	4
	Username	varchar(64)	64

	Name	Columns	Unique	Fill Factor
	PK_XmlExternalInterfaceLogin	XmlExternalInterfaceLoginID		80
	IX_XmlExternalInterfaceLogin_XMLInterface_UserAccess	XmlInterfaceFID, UserAccessFID		80

Name	Delete	Columns
FK_XmlExternalInterfaceLogin_UserAccess	Cascade	UserAccessFID->[dbo].[UserAccess].[UserAccessPriKey]
FK_XmlExternalInterfaceLogin_XMLInterface		XmlInterfaceFID->[dbo].[XmlInterface].[XmlInterfaceID]

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

Name	Level 2 Type	Level 2 Name	Value
Description			Holds login information for a particular user and external interface
Description	COLUMN	UserAccessFID	Foreign key to a useraccess record
Description	COLUMN	Username	Login username for an external interface.
Description	COLUMN	XmlExternalInterfaceLoginID	Primary key of the XmlExternalInterfaceLogin table.
Description	COLUMN	XmlInterfaceFID	Foreign key to an external interface.

SQL Script

CREATE TABLE [dbo].[XmlExternalInterfaceLogin]
(
[XmlExternalInterfaceLoginID] [int] NOT NULL IDENTITY(1, 1),
[XmlInterfaceFID] [int] NOT NULL,
[UserAccessFID] [int] NOT NULL,
[Username] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlExternalInterfaceLogin] ADD CONSTRAINT [PK_XmlExternalInterfaceLogin] PRIMARY KEY NONCLUSTERED  ([XmlExternalInterfaceLoginID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlExternalInterfaceLogin] ADD CONSTRAINT [IX_XmlExternalInterfaceLogin_XMLInterface_UserAccess] UNIQUE NONCLUSTERED  ([XmlInterfaceFID], [UserAccessFID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlExternalInterfaceLogin] ADD CONSTRAINT [FK_XmlExternalInterfaceLogin_UserAccess] FOREIGN KEY ([UserAccessFID]) REFERENCES [dbo].[UserAccess] ([UserAccessPriKey]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[XmlExternalInterfaceLogin] ADD CONSTRAINT [FK_XmlExternalInterfaceLogin_XMLInterface] FOREIGN KEY ([XmlInterfaceFID]) REFERENCES [dbo].[XmlInterface] ([XmlInterfaceID])
GO
GRANT SELECT ON  [dbo].[XmlExternalInterfaceLogin] TO [MssExec]
GRANT INSERT ON  [dbo].[XmlExternalInterfaceLogin] TO [MssExec]
GRANT DELETE ON  [dbo].[XmlExternalInterfaceLogin] TO [MssExec]
GRANT UPDATE ON  [dbo].[XmlExternalInterfaceLogin] TO [MssExec]
GO
EXEC sp_addextendedproperty N'Description', N'Holds login information for a particular user and external interface', 'SCHEMA', N'dbo', 'TABLE', N'XmlExternalInterfaceLogin', NULL, NULL
GO
EXEC sp_addextendedproperty N'Description', N'Foreign key to a useraccess record', 'SCHEMA', N'dbo', 'TABLE', N'XmlExternalInterfaceLogin', 'COLUMN', N'UserAccessFID'
GO
EXEC sp_addextendedproperty N'Description', N'Login username for an external interface.', 'SCHEMA', N'dbo', 'TABLE', N'XmlExternalInterfaceLogin', 'COLUMN', N'Username'
GO
EXEC sp_addextendedproperty N'Description', N'Primary key of the XmlExternalInterfaceLogin table.', 'SCHEMA', N'dbo', 'TABLE', N'XmlExternalInterfaceLogin', 'COLUMN', N'XmlExternalInterfaceLoginID'
GO
EXEC sp_addextendedproperty N'Description', N'Foreign key to an external interface.', 'SCHEMA', N'dbo', 'TABLE', N'XmlExternalInterfaceLogin', 'COLUMN', N'XmlInterfaceFID'
GO