package Orchard::DB::Schema::RoyaltyAccounting::SigningEntity;

use strict;
use warnings;

use lib '/var/app/orchard/collab/jgetter/perllib';
use base 'Orchard::DB::DBIxCore';

## table
__PACKAGE__->table('royalty_accounting.signing_entity');

## columns
__PACKAGE__->add_columns(
    'signing_entity_id' => {'is_auto_increment'=>1,'data_type'=>'mediumint','is_nullable'=>0},
    'signing_entity_name' => {'data_type'=>'varchar','is_nullable'=>0},
    'legal_name' => {'data_type'=>'varchar','is_nullable'=>1},
    'vat_number' => {'data_type'=>'varchar','is_nullable'=>1},
    'sap_id' => {'data_type'=>'mediumint','is_nullable'=>1},
    'address' => {'data_type'=>'varchar','is_nullable'=>1}
);

## primary key
__PACKAGE__->set_primary_key('signing_entity_id');

1;