view release on metacpan or  search on metacpan

lib/OpusVL/Preferences/Schema/Result/PrfPreference.pm  view on Meta::CPAN

use namespace::autoclean;

extends 'DBIx::Class::Core';

__PACKAGE__->table("prf_preferences");

__PACKAGE__->add_columns
(
	prf_preference_id =>
	{
		data_type   => "integer",
		is_nullable => 0,
		is_auto_increment => 1
	},

	prf_owner_id =>
	{
		data_type   => 'integer',
		is_nullable => 0
	},

	prf_owner_type_id =>
	{
		data_type   => "integer",
		is_nullable => 0,
	},

	name =>
	{
		data_type   => 'varchar',
		is_nullable => 0
	},

	value =>
	{
		data_type   => 'varchar',
		is_nullable => 1
	},
);

__PACKAGE__->set_primary_key("prf_preference_id");

__PACKAGE__->add_unique_constraint([ qw/prf_preference_id prf_owner_type_id name/ ]);

__PACKAGE__->belongs_to
(
	prf_owner => 'OpusVL::Preferences::Schema::Result::PrfOwner',
	{
		'foreign.prf_owner_id'      => 'self.prf_owner_id',
		'foreign.prf_owner_type_id' => 'self.prf_owner_type_id'
	}
);

__PACKAGE__->might_have(unique_value =>
  "OpusVL::Preferences::Schema::Result::CustomDataUniqueValues",
    { 
      "foreign.prf_owner_type_id"   => "self.prf_owner_type_id", 
      "foreign.name"                => "self.name", 
      "foreign.value_id"            => "self.prf_preference_id" 
    },
  { is_foreign_key_constraint => 0, cascade_delete => 1 });


return 1;


=head1 DESCRIPTION

This table actually contains the preference values; there is one row per field, per owner.

The owner_id column and owner_type_id column do the exact same thing as the
PrfOwner table, except here, they're a foreign key into the PrfOwner table.

That is to say, the prf_owner_id relates to an arbitrary table defined by the
host schema, and prf_owner_type_id refers to the prf_owner_types table, which
maps a number to the tables defined by the host schema.

For literally no reason whatsoever, the prf_owners table *also* encodes this
association, in a completely redundant fashion.

=head1 METHODS

=head1 ATTRIBUTES

=head2 prf_owner

=head2 prf_preference_id

=head2 prf_owner_id

=head2 prf_owner_type_id

=head2 name

=head2 value


=head1 LICENSE AND COPYRIGHT

Copyright 2012 OpusVL.

This software is licensed according to the "IP Assignment Schedule" provided with the development project.

=cut