projekt kivitendo

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

__PACKAGE__->meta->columns(

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

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

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

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

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

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

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

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

__PACKAGE__->meta->allow_inline_column_values(1);

__PACKAGE__->meta->foreign_keys(

  currency => {

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

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

  },

);

# __PACKAGE__->meta->initialize;