projekt kivitendo

  ap_gl                          => 'ap_gl',

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Manager::ApGl;

use strict;

use parent qw(SL::DB::Helper::Manager);

sub object_class { 'SL::DB::ApGl' }

__PACKAGE__->make_manager_methods;

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::ApGl;

use strict;

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

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

__PACKAGE__->meta->columns(

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

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

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

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

);

__PACKAGE__->meta->primary_key_columns([ 'ap_id', 'gl_id' ]);

__PACKAGE__->meta->allow_inline_column_values(1);

__PACKAGE__->meta->foreign_keys(

  ap => {

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

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

  },

  gl => {

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

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

  },

);

1;

;

-- @tag: ap_gl

-- @description: Hilfstabelle für automatische GL-Buchung nach Kreditorenbuchung

-- @depends: release_3_5_0

-- @ignore: 0

      CREATE TABLE ap_gl (

        ap_id                   integer,

        gl_id                   integer,

        itime                   TIMESTAMP      DEFAULT now(),

        mtime                   TIMESTAMP,

        PRIMARY KEY (ap_id, gl_id),

        FOREIGN KEY (ap_id)                    REFERENCES ap (id),

        FOREIGN KEY (gl_id)                    REFERENCES gl (id) ON DELETE CASCADE);