sync_publishers definition

CREATE TABLE [dbo].[sync_publishers](
    [sync_publisher_id] [int] IDENTITY(1,1) NOT NULL,
    [sync_object_id] [int] NOT NULL,
    [sync_registered_object_type_id] [int] NOT NULL,
    [sync_publisher_source_id] [int] NOT NULL,
    [master_update_date] [datetime] NOT NULL,
 CONSTRAINT [PK__sync_publishers] PRIMARY KEY CLUSTERED
 (
    [sync_publisher_id] ASC
 )
)

GO

ALTER TABLE [dbo].[sync_publishers]  WITH CHECK ADD  CONSTRAINT [FK__sync_publishers__sync_publisher_sources] FOREIGN KEY([sync_publisher_source_id])
REFERENCES [dbo].[sync_publisher_sources] ([sync_publisher_source_id])
GO

ALTER TABLE [dbo].[sync_publishers] CHECK CONSTRAINT [FK__sync_publishers__sync_publisher_sources]
GO

ALTER TABLE [dbo].[sync_publishers]  WITH CHECK ADD  CONSTRAINT [FK__sync_publishers__sync_registered_object_types] FOREIGN KEY([sync_registered_object_type_id])
REFERENCES [dbo].[sync_registered_object_types] ([registered_object_type_id])
GO

ALTER TABLE [dbo].[sync_publishers] CHECK CONSTRAINT [FK__sync_publishers__sync_registered_object_types]
GO

CREATE NONCLUSTERED INDEX [IX__sync_publishers__sync_registered_object_type_id__sync_publisher_id] ON [dbo].[sync_publishers]
(
    [sync_registered_object_type_id] ASC,
    [sync_publisher_id] ASC
)
INCLUDE (   [sync_object_id],
    [master_update_date]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [IX__sync_publishers__master_update_date] ON [dbo].[sync_publishers]
(
    [master_update_date] ASC,
    [sync_registered_object_type_id] ASC
)
INCLUDE (   [sync_object_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX__sync_publishers__registered_object_type_id__sync_object_id] ON [dbo].[sync_publishers]
(
    [sync_registered_object_type_id] ASC,
    [sync_object_id] ASC
)
INCLUDE (   [master_update_date]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO