package Common::DB::Schema::Report::SysDbBackup;

use strict;
use warnings;

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

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

## columns
__PACKAGE__->add_columns(qw/
    sys_db_backup_id
    d_db_id
    data_filename
    data_filesize
    data_md5sum
    backup_storage
    backup_directory
    backup_datetime
    backup_ttc_secs
/);

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

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


## relationships

## FK DDb
__PACKAGE__->has_one(
	'database',
	'Common::DB::Schema::Report::DDb',
	{
		'foreign.d_db_id' => 'self.d_db_id',
	},
	{'cascade_delete' => 0, 'cascade_update' => 0, 'cascade_copy' => 0}
);


1;