/ 
Interchange6-Schema-0.040
River stage one • 1 direct dependent • 1 total dependent
/ Interchange6::Schema::Result::PaymentOrder

NAME

Interchange6::Schema::Result::PaymentOrder

TABLE: payment_orders

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: 0
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'
default_value: (empty string)
is_nullable: 0

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