package Common::DB::Schema::Report::DDb;

use strict;
use warnings;

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

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

## columns
__PACKAGE__->add_columns(qw/
    d_db_id
    d_db_host_id
    db_name
    db_status
    client_id
    client_type
    db_backup
    calc_stat
    is_test
    date_created
    date_deleted
/);

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

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

## relationships

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

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


1;