package DBSchema::Result::User;

# Created by DBIx::Class::Schema::Loader v0.03000 @ 2006-10-02 08:24:09

use strict;
use warnings;

use base 'DBIx::Class';
#use overload '""' => sub {$_[0]->name}, fallback => 1;

__PACKAGE__->load_components('Core');
__PACKAGE__->table("usr");
__PACKAGE__->add_columns(
    "id" => {
        data_type => 'integer',
        is_auto_increment => 1,
    },
    "username" => {
        data_type => 'varchar',
        size      => '100',
    },
    "password" => {
        data_type => 'varchar',
        size      => '100',
    },
    "name" => {
        data_type => 'varchar',
        size      => '100',
      },
  );
__PACKAGE__->set_primary_key("id");
__PACKAGE__->has_many("user_roles", "UserRole", { "foreign.user" => "self.id" });
__PACKAGE__->has_many("owned_dvds", "Dvd", { "foreign.owner" => "self.id" });
__PACKAGE__->has_many(
  "borrowed_dvds",
  "Dvd",
  { "foreign.current_borrower" => "self.id" },
);
__PACKAGE__->many_to_many('roles', 'user_roles' => 'role');

__PACKAGE__->might_have(
    "address",
    "DBSchema::Result::Address",
    { 'foreign.user_id' => 'self.id' }
);

1;