The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

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