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