Tables [dbo].[SHExportModulePSNExports]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:42 AM Thursday, March 21, 2019
Last Modified1:15:34 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_SHExportModulePSNExports_POID: POIDForeign Keys FK_SHExportModulePSNExports_POID_POOrders: [dbo].[POOrders].POIDPOIDint4
False
Foreign Keys FK_SHExportModulePSNExports_StateID_SHExportModulePSNStates: [dbo].[SHExportModulePSNStates].StateIDStateIDint4
False
StateLastUpdateddatetime8
False
PSNTransactionIDvarchar(64)64
True
TransactionReferenceNumbervarchar(64)64
True
StatusTextvarchar(4000)4000
True
VendorOrderNumbervarchar(16)16
True
VendorOrderStatusvarchar(256)256
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_SHExportModulePSNExports_POID: POIDPK_SHExportModulePSNExports_POIDPOID
True
NameColumns
FK_SHExportModulePSNExports_POID_POOrdersPOID->[dbo].[POOrders].[POID]
FK_SHExportModulePSNExports_StateID_SHExportModulePSNStatesStateID->[dbo].[SHExportModulePSNStates].[StateID]
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