package Common::DB::Schema::Report::FDatabaseSize;

use strict;
use warnings;

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

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

## columns
__PACKAGE__->add_columns(qw/
    f_database_size_id
    d_db_id
    data_bytes
    index_bytes
    total_bytes
    date_opened
    date_closed
/);

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

## unique key (d_db_id, total_bytes)
__PACKAGE__->add_unique_constraint('uidx_id_total_bytes' => [qw/d_db_id total_bytes/]);

1;