Skip to content

Instantly share code, notes, and snippets.

@tugberkugurlu
Created October 14, 2011 08:55
Show Gist options
  • Save tugberkugurlu/1286601 to your computer and use it in GitHub Desktop.
Save tugberkugurlu/1286601 to your computer and use it in GitHub Desktop.
PaymentActions
/****** Object: Table [dbo].[PaymentActions] Script Date: 10/14/2011 11:53:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PaymentActions](
[PaymentActionID] [uniqueidentifier] NOT NULL,
[PaymentID] [uniqueidentifier] NOT NULL,
[ActionDate] [datetime] NULL,
[ActionIp] [nvarchar](50) NULL,
[DetectedCountry] [nvarchar](50) NULL,
[DetectedRegion] [nvarchar](50) NULL,
[DetectedCity] [nvarchar](50) NULL,
[IsPriceTL] [bit] NULL,
[TLPrice] [decimal](18, 2) NULL,
[TransactionReferenceNo] [nvarchar](100) NULL,
[ProvisionNumber] [nvarchar](100) NULL,
[OID] [nvarchar](100) NULL,
[BankErrorCode] [nvarchar](1000) NULL,
[ComplatedWithMailOrder] [bit] NULL,
[Complated] [bit] NULL,
[InComplated] [bit] NULL,
[InComplateWithUnexpectedErrors] [bit] NULL,
CONSTRAINT [PK_PaymentActions] PRIMARY KEY CLUSTERED
(
[PaymentActionID] 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 [dbo].[PaymentActions] WITH CHECK ADD CONSTRAINT [FK_PaymentActions_Payments] FOREIGN KEY([PaymentID])
REFERENCES [dbo].[Payments] ([PaymentID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[PaymentActions] CHECK CONSTRAINT [FK_PaymentActions_Payments]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment