CREATE TABLE [dbo].[SHExportModulePSNExports]
(
[POID] [int] NOT NULL,
[StateID] [int] NOT NULL,
[StateLastUpdated] [datetime] NOT NULL,
[PSNTransactionID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionReferenceNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusText] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorOrderNumber] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorOrderStatus] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHExportModulePSNExports] ADD CONSTRAINT [PK_SHExportModulePSNExports_POID] PRIMARY KEY CLUSTERED ([POID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHExportModulePSNExports] ADD CONSTRAINT [FK_SHExportModulePSNExports_POID_POOrders] FOREIGN KEY ([POID]) REFERENCES [dbo].[POOrders] ([POID])
GO
ALTER TABLE [dbo].[SHExportModulePSNExports] ADD CONSTRAINT [FK_SHExportModulePSNExports_StateID_SHExportModulePSNStates] FOREIGN KEY ([StateID]) REFERENCES [dbo].[SHExportModulePSNStates] ([StateID])
GO