The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
 / 
Interchange6-Schema-0.053
River stage one • 1 direct dependent • 1 total dependent
3 ++
/ Interchange6::Schema::Result::PaymentOrder

NAME

Interchange6::Schema::Result::PaymentOrder

TABLE: payment_orders

DESCRIPTION

The payment_sessions_id is used to store the session id provided by the gateway. For example, with Business::OnlinePayment::IPayment you put the session id into the HTML form for the silent CGI mode.

The sessions_id is used here so we can track down payments without orders. We usually turn a guest user into a real user after confirmation of a successful payment, so we need the session information here in the case the payment is made but the confirmation didn't reach the online shop.

ACCESSORS

payment_orders_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0
  sequence: 'payment_orders_payment_orders_id_seq'

payment_mode

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 32

payment_action

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 32

payment_id

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 32

auth_code

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 255

users_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

sessions_id

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 255

orders_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

amount

  data_type: 'numeric'
  default_value: 0.0
  is_nullable: 0
  size: [11,2]

status

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 32

payment_sessions_id

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 255

payment_error_code

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 32

payment_error_message

  data_type: 'text'
  is_nullable: 1

payment_fee

  data_type: 'numeric'
  default_value: 0.0
  is_nullable: 0
  size: [11,2]

Some gateways (notably PayPal) charge a fee for each transaction. This column should be used to store the transaction fee (if any).

created

  data_type: 'datetime'
  set_on_create: 1
  is_nullable: 0

last_modified

  data_type: 'datetime'
  set_on_create: 1
  set_on_update: 1
  is_nullable: 0

PRIMARY KEY

RELATIONS

order

Type: belongs_to

Related object: Interchange6::Schema::Result::Order

user

Type: belongs_to

Related object: Interchange6::Schema::Result::User

session

Type: belongs_to

Related object: Interchange6::Schema::Result::Session