projekt kivitendo

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

__PACKAGE__->meta->columns(

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

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

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

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

);

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

__PACKAGE__->meta->foreign_keys(

  parts => {

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

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

  },

  pricegroup => {

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

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

  },

# __PACKAGE__->meta->initialize;