use strict;
-use base qw(SL::DB::Object);
+use parent qw(SL::DB::Object);
__PACKAGE__->meta->table('prices');
__PACKAGE__->meta->columns(
id => { type => 'serial', not_null => 1 },
- parts_id => { type => 'integer' },
+ parts_id => { type => 'integer', not_null => 1 },
price => { type => 'numeric', precision => 15, scale => 5 },
- pricegroup_id => { type => 'integer' },
+ pricegroup_id => { type => 'integer', not_null => 1 },
);
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
+__PACKAGE__->meta->unique_keys([ 'parts_id', 'pricegroup_id' ]);
+
__PACKAGE__->meta->foreign_keys(
parts => {
class => 'SL::DB::Part',