##
package NEOpS::WDS::Systems;
use base qw/DBIx::Class/;
__PACKAGE__->load_components(qw/PK::Auto Core/);
__PACKAGE__->table('systems');
__PACKAGE__->add_columns(obid =>
{ accessor => 'elements',
data_type => 'integer',
size => 16,
is_nullable => 0,
is_auto_increment => 1,
default_value => '',
},
name =>
{
data_type => 'varchar',
size => 64,
is_nullable => 1,
is_auto_increment => 0,
default_value => '',
},
descrip =>
{
data_type => 'varchar',
size => 256,
is_nullable => 1,
is_auto_increment => 0,
default_value => '',
}
);
__PACKAGE__->set_primary_key('obid');
__PACKAGE__->has_one('username', 'NEOpS::WDS::Users', 'Point_of_Contact' );
1;
##
##
package NEOpS::WDS::Users;
use base qw/DBIx::Class/;
__PACKAGE__->load_components(qw/PK::Auto Core/);
__PACKAGE__->table('users');
__PACKAGE__->add_columns(obid=>
{ accessor => 'users',
data_type => 'integer',
size => 16,
is_nullable => 0,
is_auto_increment => 1,
default_value => '',
},
username=>
{
data_type => 'varchar',
size => 64,
is_nullable => 0,
is_auto_increment => 0,
default_value => '',
},
password=>
{
data_type => 'varchar',
size => 64,
is_nullable => 0,
is_auto_increment => 0,
default_value => '',
},
firstname=>
{
data_type => 'varchar',
size => 64,
is_nullable => 1,
is_auto_increment => 0,
default_value => '',
},
lastname=>
{
data_type => 'varchar',
size => 64,
is_nullable => 1,
is_auto_increment => 0,
default_value => '',
},
email=>
{
data_type => 'varchar',
size => 128,
is_nullable => 0,
is_auto_increment => 0,
default_value => '',
},
active=>
{
data_type => 'integer',
size => 16,
is_nullable => 0,
is_auto_increment => 0,
default_value => '',
}
);
__PACKAGE__->set_primary_key('obid');
__PACKAGE__->has_many(role, 'NEOpS::WDS::Roles', role);
1;
##
##
package NEOpS::WDS::Roles;
use base qw/DBIx::Class/;
__PACKAGE__->load_components(qw/PK::Auto Core/);
__PACKAGE__->table('roles');
__PACKAGE__->add_columns(obid=>
{ accessor => 'roles',
data_type => 'integer',
size => 16,
is_nullable => 0,
is_auto_increment => 1,
default_value => '',
},
role=>
{
data_type => 'varchar',
size => 64,
is_nullable => 0,
is_auto_increment => 0,
default_value => '',
}
);
__PACKAGE__->set_primary_key('obid');
1;