Tables [dbo].[Device_Location]
PropertyValue
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:22 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_Device_Location_DeviceID_LocationID: DeviceID\LocationIDForeign Keys FK_Device_Location_DeviceID_Device_DeviceID: [dbo].[Device].DeviceIDDeviceIDint4
False
Cluster Primary Key PK_Device_Location_DeviceID_LocationID: DeviceID\LocationIDForeign Keys FK_Device_Location_LocationID_AccountLocation_LocationID: [dbo].[AccountLocation].LocationIDLocationIDint4
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_Device_Location_DeviceID_LocationID: DeviceID\LocationIDPK_Device_Location_DeviceID_LocationIDDeviceID, LocationID
True
NameColumns
FK_Device_Location_DeviceID_Device_DeviceIDDeviceID->[dbo].[Device].[DeviceID]
FK_Device_Location_LocationID_AccountLocation_LocationIDLocationID->[dbo].[AccountLocation].[LocationID]
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