Open-ILS/src/perlmods/OpenILS/Application/Storage/CDBI/actor.pm

   1 package OpenILS::Application::Storage::CDBI::actor;
   2 our $VERSION = 1;
   3
   4 #-------------------------------------------------------------------------------
   5 package actor;
   6 use base qw/OpenILS::Application::Storage::CDBI/;
   7 #-------------------------------------------------------------------------------
   8 package actor::user;
   9 use base qw/actor/;
  10
  11 __PACKAGE__->table( 'actor_usr' );
  12 __PACKAGE__->columns( Primary => qw/id/ );
  13 __PACKAGE__->columns( Essential => qw/usrname email first_given_name
  14                                 second_given_name family_name billing_address
  15                                 claims_returned_count home_ou dob
  16                                 active master_account ident_type ident_value
  17                                 ident_type2 ident_value2 net_access_level
  18                                 photo_url create_date expire_date credit_forward_balance
  19                                 super_user usrgroup passwd card last_xact_id
  20                                 standing barred profile prefix suffix alert_message
  21                                 day_phone evening_phone other_phone mailing_address/ );
  22
  23 #-------------------------------------------------------------------------------
  24 package actor::usr_note;
  25 use base qw/actor/;
  26
  27 __PACKAGE__->table( 'actor_usr_note' );
  28 __PACKAGE__->columns( Primary => qw/id/ );
  29 __PACKAGE__->columns( Essential => qw/usr title creator create_date value pub/ );
  30
  31 #-------------------------------------------------------------------------------
  32 package actor::workstation;
  33 use base qw/actor/;
  34
  35 __PACKAGE__->table( 'actor_workstation' );
  36 __PACKAGE__->columns( Primary => qw/id/);
  37 __PACKAGE__->columns( Essential => qw/name owning_lib/);
  38
  39 #-------------------------------------------------------------------------------
  40 package actor::user_standing_penalty;
  41 use base qw/actor/;
  42
  43 __PACKAGE__->table( 'actor_user_standing_penalty' );
  44 __PACKAGE__->columns( Primary => qw/id/);
  45 __PACKAGE__->columns( Essential => qw/usr penalty_type/);
  46
  47 #-------------------------------------------------------------------------------
  48 package actor::user_setting;
  49 use base qw/actor/;
  50
  51 __PACKAGE__->table( 'actor_user_setting' );
  52 __PACKAGE__->columns( Primary => qw/id/);
  53 __PACKAGE__->columns( Essential => qw/usr name value/);
  54
  55 #-------------------------------------------------------------------------------
  56 package actor::org_unit_type;
  57 use base qw/actor/;
  58
  59 __PACKAGE__->table( 'actor_org_unit_type' );
  60 __PACKAGE__->columns( Primary => qw/id/);
  61 __PACKAGE__->columns( Essential => qw/name opac_label depth parent can_have_vols can_have_users/);
  62
  63 #-------------------------------------------------------------------------------
  64 package actor::org_unit;
  65 use base qw/actor/;
  66
  67 __PACKAGE__->table( 'actor_org_unit' );
  68 __PACKAGE__->columns( Primary => qw/id/);
  69 __PACKAGE__->columns( Essential => qw/parent_ou ou_type mailing_address billing_address
  70                                 ill_address holds_address shortname name/);
  71
  72 #-------------------------------------------------------------------------------
  73 package actor::org_unit::hours_of_operation;
  74 use base qw/actor/;
  75
  76 __PACKAGE__->table( 'actor_hours_of_operation' );
  77 __PACKAGE__->columns( Primary => qw/id/);
  78 __PACKAGE__->columns( Essential => qw/dow_0_open dow_0_close dow_1_open dow_1_close dow_2_open dow_2_close
  79                                         dow_3_open dow_3_close dow_4_open dow_4_close dow_5_open dow_5_close
  80                                         dow_6_open dow_6_close/);
  81
  82 #-------------------------------------------------------------------------------
  83 package actor::org_unit::closed_date;
  84 use base qw/actor/;
  85
  86 __PACKAGE__->table( 'actor_org_unit_closed' );
  87 __PACKAGE__->columns( Primary => qw/id/);
  88 __PACKAGE__->columns( Essential => qw/org_unit close_start close_end reason/);
  89
  90
  91 #-------------------------------------------------------------------------------
  92 package actor::org_unit_setting;
  93 use base qw/actor/;
  94
  95 __PACKAGE__->table( 'actor_org_unit_setting' );
  96 __PACKAGE__->columns( Primary => qw/id/);
  97 __PACKAGE__->columns( Essential => qw/org_unit name value/);
  98
  99
 100 #-------------------------------------------------------------------------------
 101 package actor::stat_cat;
 102 use base qw/actor/;
 103
 104 __PACKAGE__->table( 'actor_stat_cat' );
 105 __PACKAGE__->columns( Primary => qw/id/ );
 106 __PACKAGE__->columns( Essential => qw/owner name opac_visible/ );
 107
 108 #-------------------------------------------------------------------------------
 109 package actor::stat_cat_entry;
 110 use base qw/actor/;
 111
 112 __PACKAGE__->table( 'actor_stat_cat_entry' );
 113 __PACKAGE__->columns( Primary => qw/id/ );
 114 __PACKAGE__->columns( Essential => qw/stat_cat owner value/ );
 115
 116 #-------------------------------------------------------------------------------
 117 package actor::stat_cat_entry_user_map;
 118 use base qw/actor/;
 119
 120 __PACKAGE__->table( 'actor_stat_cat_entry_usr_map' );
 121 __PACKAGE__->columns( Primary => qw/id/ );
 122 __PACKAGE__->columns( Essential => qw/stat_cat stat_cat_entry target_usr/ );
 123
 124 #-------------------------------------------------------------------------------
 125 package actor::card;
 126 use base qw/actor/;
 127
 128 __PACKAGE__->table( 'actor_card' );
 129 __PACKAGE__->columns( Primary => qw/id/ );
 130 __PACKAGE__->columns( Essential => qw/usr barcode active/ );
 131
 132 #-------------------------------------------------------------------------------
 133 package actor::user_access_entry;
 134 use base qw/actor/;
 135 #-------------------------------------------------------------------------------
 136 package actor::perm_group;
 137 use base qw/actor/;
 138 #-------------------------------------------------------------------------------
 139 package actor::permission;
 140 use base qw/actor/;
 141 #-------------------------------------------------------------------------------
 142 package actor::perm_group_permission_map;
 143 use base qw/actor/;
 144 #-------------------------------------------------------------------------------
 145 package actor::perm_group_user_map;
 146 use base qw/actor/;
 147 #-------------------------------------------------------------------------------
 148 package actor::user_address;
 149 use base qw/actor/;
 150
 151 __PACKAGE__->table( 'actor_usr_address' );
 152 __PACKAGE__->columns( Primary => qw/id/ );
 153 __PACKAGE__->columns( Essential => qw/valid address_type usr street1 street2
 154                                       city county state country post_code
 155                                       within_city_limits/ );
 156
 157 #-------------------------------------------------------------------------------
 158 package actor::org_address;
 159 use base qw/actor/;
 160
 161 __PACKAGE__->table( 'actor_org_address' );
 162 __PACKAGE__->columns( Primary => qw/id/ );
 163 __PACKAGE__->columns( Essential => qw/valid address_type org_unit street1 street2
 164                                       city county state country post_code/ );
 165
 166 #-------------------------------------------------------------------------------
 167 1;
 168