CREATE TABLE [dbo].[Device_Location]
(
[DeviceID] [int] NOT NULL,
[LocationID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Device_Location] ADD CONSTRAINT [PK_Device_Location_DeviceID_LocationID] PRIMARY KEY CLUSTERED ([DeviceID], [LocationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Device_Location] ADD CONSTRAINT [FK_Device_Location_DeviceID_Device_DeviceID] FOREIGN KEY ([DeviceID]) REFERENCES [dbo].[Device] ([DeviceID])
GO
ALTER TABLE [dbo].[Device_Location] ADD CONSTRAINT [FK_Device_Location_LocationID_AccountLocation_LocationID] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[AccountLocation] ([LocationID])
GO