Open-ILS/src/perlmods/lib/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 deleted juvenile
  16                                 active master_account ident_type ident_value
  17                                 ident_type2 ident_value2 net_access_level alias
  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_org_unit_opt_in;
  25 use base qw/actor/;
  26 __PACKAGE__->table( 'actor_usr_org_unit_opt_in' );
  27 __PACKAGE__->columns( Primary => qw/id/ );
  28 __PACKAGE__->columns( Essential => qw/org_unit usr staff opt_in_ts opt_in_ws/ );
  29
  30 #-------------------------------------------------------------------------------
  31 package actor::org_unit_proximity;
  32 use base qw/actor/;
  33 __PACKAGE__->table( 'actor_org_unit_proximity' );
  34 __PACKAGE__->columns( Primary => qw/id/ );
  35 __PACKAGE__->columns( Essential => qw/from_org to_org prox/ );
  36
  37 #-------------------------------------------------------------------------------
  38 package actor::usr_note;
  39 use base qw/actor/;
  40
  41 __PACKAGE__->table( 'actor_usr_note' );
  42 __PACKAGE__->columns( Primary => qw/id/ );
  43 __PACKAGE__->columns( Essential => qw/usr title creator create_date value pub/ );
  44
  45 #-------------------------------------------------------------------------------
  46 package actor::workstation;
  47 use base qw/actor/;
  48
  49 __PACKAGE__->table( 'actor_workstation' );
  50 __PACKAGE__->columns( Primary => qw/id/);
  51 __PACKAGE__->columns( Essential => qw/name owning_lib/);
  52
  53 #-------------------------------------------------------------------------------
  54 package actor::user_standing_penalty;
  55 use base qw/actor/;
  56
  57 __PACKAGE__->table( 'actor_user_standing_penalty' );
  58 __PACKAGE__->columns( Primary => qw/id/);
  59 __PACKAGE__->columns( Essential => qw/usr penalty_type/);
  60
  61 #-------------------------------------------------------------------------------
  62 package actor::user_setting;
  63 use base qw/actor/;
  64
  65 __PACKAGE__->table( 'actor_user_setting' );
  66 __PACKAGE__->columns( Primary => qw/id/);
  67 __PACKAGE__->columns( Essential => qw/usr name value/);
  68
  69 #-------------------------------------------------------------------------------
  70 package actor::org_unit_type;
  71 use base qw/actor/;
  72
  73 __PACKAGE__->table( 'actor_org_unit_type' );
  74 __PACKAGE__->columns( Primary => qw/id/);
  75 __PACKAGE__->columns( Essential => qw/name opac_label depth parent can_have_vols can_have_users/);
  76
  77 #-------------------------------------------------------------------------------
  78 package actor::org_unit;
  79 use base qw/actor/;
  80
  81 __PACKAGE__->table( 'actor_org_unit' );
  82 __PACKAGE__->columns( Primary => qw/id/);
  83 __PACKAGE__->columns( Essential => qw/parent_ou ou_type mailing_address billing_address
  84                                 ill_address holds_address shortname name email phone opac_visible fiscal_calendar/);
  85
  86 #-------------------------------------------------------------------------------
  87 package actor::org_unit::hours_of_operation;
  88 use base qw/actor/;
  89
  90 __PACKAGE__->table( 'actor_hours_of_operation' );
  91 __PACKAGE__->columns( Primary => qw/id/);
  92 __PACKAGE__->columns( Essential => qw/dow_0_open dow_0_close dow_1_open dow_1_close dow_2_open dow_2_close
  93                                         dow_3_open dow_3_close dow_4_open dow_4_close dow_5_open dow_5_close
  94                                         dow_6_open dow_6_close/);
  95
  96 #-------------------------------------------------------------------------------
  97 package actor::org_unit::closed_date;
  98 use base qw/actor/;
  99
 100 __PACKAGE__->table( 'actor_org_unit_closed' );
 101 __PACKAGE__->columns( Primary => qw/id/);
 102 __PACKAGE__->columns( Essential => qw/org_unit close_start close_end reason/);
 103
 104
 105 #-------------------------------------------------------------------------------
 106 package actor::org_unit_setting;
 107 use base qw/actor/;
 108
 109 __PACKAGE__->table( 'actor_org_unit_setting' );
 110 __PACKAGE__->columns( Primary => qw/id/);
 111 __PACKAGE__->columns( Essential => qw/org_unit name value/);
 112
 113
 114 #-------------------------------------------------------------------------------
 115 package actor::stat_cat;
 116 use base qw/actor/;
 117
 118 __PACKAGE__->table( 'actor_stat_cat' );
 119 __PACKAGE__->columns( Primary => qw/id/ );
 120 __PACKAGE__->columns( Essential => qw/owner name opac_visible usr_summary/ );
 121
 122 #-------------------------------------------------------------------------------
 123 package actor::stat_cat_entry;
 124 use base qw/actor/;
 125
 126 __PACKAGE__->table( 'actor_stat_cat_entry' );
 127 __PACKAGE__->columns( Primary => qw/id/ );
 128 __PACKAGE__->columns( Essential => qw/stat_cat owner value/ );
 129
 130 #-------------------------------------------------------------------------------
 131 package actor::stat_cat_entry_user_map;
 132 use base qw/actor/;
 133
 134 __PACKAGE__->table( 'actor_stat_cat_entry_usr_map' );
 135 __PACKAGE__->columns( Primary => qw/id/ );
 136 __PACKAGE__->columns( Essential => qw/stat_cat stat_cat_entry target_usr/ );
 137
 138 #-------------------------------------------------------------------------------
 139 package actor::card;
 140 use base qw/actor/;
 141
 142 __PACKAGE__->table( 'actor_card' );
 143 __PACKAGE__->columns( Primary => qw/id/ );
 144 __PACKAGE__->columns( Essential => qw/usr barcode active/ );
 145
 146 #-------------------------------------------------------------------------------
 147 package actor::user_access_entry;
 148 use base qw/actor/;
 149 #-------------------------------------------------------------------------------
 150 package actor::perm_group;
 151 use base qw/actor/;
 152 #-------------------------------------------------------------------------------
 153 package actor::permission;
 154 use base qw/actor/;
 155 #-------------------------------------------------------------------------------
 156 package actor::perm_group_permission_map;
 157 use base qw/actor/;
 158 #-------------------------------------------------------------------------------
 159 package actor::perm_group_user_map;
 160 use base qw/actor/;
 161 #-------------------------------------------------------------------------------
 162 package actor::user_address;
 163 use base qw/actor/;
 164
 165 __PACKAGE__->table( 'actor_usr_address' );
 166 __PACKAGE__->columns( Primary => qw/id/ );
 167 __PACKAGE__->columns( Essential => qw/valid address_type usr street1 street2
 168                                       city county state country post_code
 169                                       within_city_limits/ );
 170
 171 #-------------------------------------------------------------------------------
 172 package actor::org_address;
 173 use base qw/actor/;
 174
 175 __PACKAGE__->table( 'actor_org_address' );
 176 __PACKAGE__->columns( Primary => qw/id/ );
 177 __PACKAGE__->columns( Essential => qw/valid address_type org_unit street1 street2
 178                                       city county state country post_code/ );
 179
 180 #-------------------------------------------------------------------------------
 181 1;
 182