package AppSys::MapPrUser;
use base AppSys::DBI;
__PACKAGE__->table("map_pr_usr");
__PACKAGE__->columns(Primary => qw(provider_id user_id));
__PACKAGE__->has_a(provider_id => AppSys::Provider);
__PACKAGE__->has_a(user_id => AppSys::User);

package AppSys::User;
use base AppSys::DBI;
__PACKAGE__->set_up_table("ap_uprofile");
__PACKAGE__->has_many(providers => ['AppSys::MapPrUser' => 'provider_id']);
__PACKAGE__->has_many(appointments => 'AppSys::PrAppointments', 'userid');

package AppSys::Provider;
use base AppSys::DBI;
__PACKAGE__->set_up_table("ap_prprofile");
__PACKAGE__->has_a(defAptType => 'AppSys::ApptTypes');
__PACKAGE__->has_many(appointments => 'AppSys::PrAppointments', 'providerid', {sort => 'appdate'});
__PACKAGE__->has_many(users => ['AppSys::MapPrUser' => 'user_id']);
__PACKAGE__->has_many(appointment_types => 'AppSys::ApptTypes', 'providerid');