NAME

Interchange6::Schema::Result::PaymentOrder

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'
primary key

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

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

cpanm Interchange6::Schema

perl -MCPAN -e shell
install Interchange6::Schema