package Common::DB::Schema::Report::AwsEc2List;

use strict;
use warnings;

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

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

## columns
__PACKAGE__->add_columns(qw/
    id
    instance_id
    instance_name
    instance_type
    image_id
    zone
    ip
    private_ip
    vpc_id
    subnet
    security_groups
    state
    created_at
    updated_at
/);

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

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

1;