package Common::DB::Schema::Report::SqsEmailBounce;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use base 'Common::DB::DBIxCore';

## table
__PACKAGE__->table('report.sqs_email_bounce');

## columns
__PACKAGE__->add_columns(qw/
    id
    email_address
    email_subject
    diagnostic_code
    bounce_type
    bounce_subtype
    bounce_action
    bounced
    mailed
    created_at
    updated_at
/);

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

## unique key (email_address)
__PACKAGE__->add_unique_constraint('uidx_email_address' => [qw/email_address/]);

1;