package API::Schema::Result::CompleteNumberE164View;

use utf8;
use strict;
use warnings;

use base qw/DBIx::Class::Core/;

__PACKAGE__->table_class('DBIx::Class::ResultSource::View');
__PACKAGE__->table('complete_number_e164');
__PACKAGE__->result_source_instance->view_definition(
"SELECT '44' || area_code || local_number AS ddi, area_code, local_number, number_quality, is_used 
        FROM assigned_number;"
);

__PACKAGE__->add_columns(
    ddi => {
        data_type     => 'INTEGER',
        default_value => undef,
        is_nullable   => 0,
    },
    area_code => {
        data_type     => 'INTEGER',
        default_value => undef,
        is_nullable   => 0,
    },
    local_number => {
        data_type     => 'INTEGER',
        default_value => undef,
        is_nullable   => 0,
    },
    number_quality => {
        data_type     => 'TEXT',
        default_value => undef,
        is_nullable   => 0,
        size          => 255,
    },
    is_used => {
        data_type     => 'BOOLEAN',
        default_value => 'false',
        is_nullable   => 0,
    },
);
__PACKAGE__->belongs_to(
    'area_code_assigned_number',
    'API::Schema::Result::Area',
    { 'foreign.area_code' => 'self.area_code' }
);
__PACKAGE__->belongs_to(
    'number_quality_assigned_number',
    'API::Schema::Result::NumberQuality',
    { 'foreign.number_quality' => 'self.number_quality' }
);

1;