projekt kivitendo

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::ShopOrder;

#package SL::DB::ShopOrder;

use strict;

use parent qw(SL::DB::Object);

__PACKAGE__->meta->table('shop_orders');

__PACKAGE__->meta->columns(

  amount                 => { type => 'numeric', precision => 15, scale => 5 },

  billing_city           => { type => 'text' },

  billing_company        => { type => 'text' },

  billing_country        => { type => 'text' },

  billing_department     => { type => 'text' },

  billing_email          => { type => 'text' },

  billing_fax            => { type => 'text' },

  billing_firstname      => { type => 'text' },

  billing_greeting       => { type => 'text' },

  billing_lastname       => { type => 'text' },

  billing_phone          => { type => 'text' },

  billing_street         => { type => 'text' },

  billing_vat            => { type => 'text' },

  billing_zipcode        => { type => 'text' },

  customer_city          => { type => 'text' },

  customer_company       => { type => 'text' },

  customer_country       => { type => 'text' },

  customer_department    => { type => 'text' },

  customer_email         => { type => 'text' },

  customer_fax           => { type => 'text' },

  customer_firstname     => { type => 'text' },

  customer_greeting      => { type => 'text' },

  customer_lastname      => { type => 'text' },

  customer_newsletter    => { type => 'boolean' },

  customer_phone         => { type => 'text' },

  customer_street        => { type => 'text' },

  customer_vat           => { type => 'text' },

  customer_zipcode       => { type => 'text' },

  delivery_city          => { type => 'text' },

  delivery_company       => { type => 'text' },

  delivery_country       => { type => 'text' },

  delivery_department    => { type => 'text' },

  delivery_email         => { type => 'text' },

  delivery_fax           => { type => 'text' },

  delivery_firstname     => { type => 'text' },

  delivery_greeting      => { type => 'text' },

  delivery_lastname      => { type => 'text' },

  delivery_phone         => { type => 'text' },

  delivery_street        => { type => 'text' },

  delivery_vat           => { type => 'text' },

  delivery_zipcode       => { type => 'text' },

  host                   => { type => 'text' },

  id                     => { type => 'serial', not_null => 1 },

  itime                  => { type => 'timestamp', default => 'now()' },

  kivi_customer_id       => { type => 'integer' },

  mtime                  => { type => 'timestamp' },

  netamount              => { type => 'numeric', precision => 15, scale => 5 },

  oe_transid             => { type => 'integer' },

  order_date             => { type => 'timestamp' },

  payment_description    => { type => 'text' },

  payment_id             => { type => 'integer' },

  remote_ip              => { type => 'text' },

  sepa_account_holder    => { type => 'text' },

  sepa_bic               => { type => 'text' },

  sepa_iban              => { type => 'text' },

  shipping_costs         => { type => 'numeric', precision => 15, scale => 5 },

  shipping_costs_id      => { type => 'integer' },

  shipping_costs_net     => { type => 'numeric', precision => 15, scale => 5 },

  shop_c_billing_id      => { type => 'integer' },

  shop_c_billing_number  => { type => 'text' },

  shop_c_delivery_id     => { type => 'integer' },

  shop_c_delivery_number => { type => 'text' },

  shop_customer_comment  => { type => 'text' },

  shop_customer_id       => { type => 'integer' },

  shop_customer_number   => { type => 'text' },

  shop_data              => { type => 'text' },

  shop_id                => { type => 'integer' },

  shop_ordernumber       => { type => 'text' },

  shop_trans_id          => { type => 'integer', not_null => 1 },

  tax_included           => { type => 'boolean' },

  transfer_date          => { type => 'date' },

  transferred            => { type => 'boolean', default => 'false' },

);

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

__PACKAGE__->meta->allow_inline_column_values(1);

1;

;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::ShopOrderItem;

#package SL::DB::ShopOrderItem;

use strict;

use parent qw(SL::DB::Object);

__PACKAGE__->meta->table('shop_order_items');

__PACKAGE__->meta->columns(

  description   => { type => 'text' },

  id            => { type => 'serial', not_null => 1 },

  partnumber    => { type => 'text' },

  position      => { type => 'integer' },

  price         => { type => 'numeric', precision => 15, scale => 5 },

  quantity      => { type => 'numeric', precision => 25, scale => 5 },

  shop_id       => { type => 'integer' },

  shop_order_id => { type => 'integer' },

  shop_trans_id => { type => 'integer', not_null => 1 },

  tax_rate      => { type => 'numeric', precision => 15, scale => 2 },

);

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

__PACKAGE__->meta->foreign_keys(

  shop_order => {

    class       => 'SL::DB::ShopOrder',

    key_columns => { shop_order_id => 'id' },

  },

);

1;

;