CREATE TABLE [dbo].[RequireableFieldLocationMap]
(
[RequireableFieldLocationMapID] [int] NOT NULL IDENTITY(1, 1),
[RequireableFieldLocationFID] [int] NOT NULL,
[RequireableFieldFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RequireableFieldLocationMap] ADD CONSTRAINT [PK_RequireableFieldLocationMap] PRIMARY KEY NONCLUSTERED  ([RequireableFieldLocationMapID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RequireableFieldLocationMap_RequireableFieldFID] ON [dbo].[RequireableFieldLocationMap] ([RequireableFieldFID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_RequireableFieldLocationMap_RequireableFieldLocationFID_RequireableFieldFID] ON [dbo].[RequireableFieldLocationMap] ([RequireableFieldLocationFID], [RequireableFieldFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RequireableFieldLocationMap] ADD CONSTRAINT [FK_RequireableFieldLocationMap_RequireableField] FOREIGN KEY ([RequireableFieldFID]) REFERENCES [dbo].[RequireableField] ([RequireableFieldID])
GO
ALTER TABLE [dbo].[RequireableFieldLocationMap] ADD CONSTRAINT [FK_RequireableFieldLocationMap_RequireableFieldLocation] FOREIGN KEY ([RequireableFieldLocationFID]) REFERENCES [dbo].[RequireableFieldLocation] ([RequireableFieldLocationID])
GO
GRANT SELECT ON  [dbo].[RequireableFieldLocationMap] TO [MssExec]
GRANT INSERT ON  [dbo].[RequireableFieldLocationMap] TO [MssExec]
GRANT DELETE ON  [dbo].[RequireableFieldLocationMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[RequireableFieldLocationMap] TO [MssExec]
GO