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