CREATE TABLE [stc].[BrokerContracts](
	[PK] [int] IDENTITY(1,1) NOT NULL,
	[FK_DocTemplate] [int] NULL,
	[FK_Broker_AlphabetCustomer] [int] NULL,
	[DateCreated] [datetime] NULL,
	[DateAccepted] [datetime] NULL,
	[AcceptingUser] [nvarchar](500) NULL,
	[Status] [nvarchar](500) NULL,
 CONSTRAINT [PK_BrokerContracts] PRIMARY KEY CLUSTERED
(
	[PK] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [stc].[BrokerContracts]  WITH CHECK ADD  CONSTRAINT [FK_BrokerContracts_BrokerAlphabetCustomer] FOREIGN KEY([FK_Broker_AlphabetCustomer])
REFERENCES [stc].[BrokerAlphabetCustomer] ([PK])
GO

ALTER TABLE [stc].[BrokerContracts] CHECK CONSTRAINT [FK_BrokerContracts_BrokerAlphabetCustomer]
GO

ALTER TABLE [stc].[BrokerContracts]  WITH CHECK ADD  CONSTRAINT [FK_BrokerContracts_DocTemplate] FOREIGN KEY([FK_DocTemplate])
REFERENCES [stc].[DocTemplate] ([PK])
GO

ALTER TABLE [stc].[BrokerContracts] CHECK CONSTRAINT [FK_BrokerContracts_DocTemplate]
GO