1 package OpenILS::Application::Storage::CDBI::actor;
4 #-------------------------------------------------------------------------------
6 use base qw/OpenILS::Application::Storage::CDBI/;
7 #-------------------------------------------------------------------------------
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/ );
23 #-------------------------------------------------------------------------------
24 package actor::usr_org_unit_opt_in;
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/ );
30 #-------------------------------------------------------------------------------
31 package actor::org_unit_proximity;
33 __PACKAGE__->table( 'actor_org_unit_proximity' );
34 __PACKAGE__->columns( Primary => qw/id/ );
35 __PACKAGE__->columns( Essential => qw/from_org to_org prox/ );
37 #-------------------------------------------------------------------------------
38 package actor::usr_note;
41 __PACKAGE__->table( 'actor_usr_note' );
42 __PACKAGE__->columns( Primary => qw/id/ );
43 __PACKAGE__->columns( Essential => qw/usr title creator create_date value pub/ );
45 #-------------------------------------------------------------------------------
46 package actor::workstation;
49 __PACKAGE__->table( 'actor_workstation' );
50 __PACKAGE__->columns( Primary => qw/id/);
51 __PACKAGE__->columns( Essential => qw/name owning_lib/);
53 #-------------------------------------------------------------------------------
54 package actor::user_standing_penalty;
57 __PACKAGE__->table( 'actor_user_standing_penalty' );
58 __PACKAGE__->columns( Primary => qw/id/);
59 __PACKAGE__->columns( Essential => qw/usr penalty_type/);
61 #-------------------------------------------------------------------------------
62 package actor::user_setting;
65 __PACKAGE__->table( 'actor_user_setting' );
66 __PACKAGE__->columns( Primary => qw/id/);
67 __PACKAGE__->columns( Essential => qw/usr name value/);
69 #-------------------------------------------------------------------------------
70 package actor::org_unit_type;
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/);
77 #-------------------------------------------------------------------------------
78 package actor::org_unit;
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/);
86 #-------------------------------------------------------------------------------
87 package actor::org_unit::hours_of_operation;
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/);
96 #-------------------------------------------------------------------------------
97 package actor::org_unit::closed_date;
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/);
105 #-------------------------------------------------------------------------------
106 package actor::org_unit_setting;
109 __PACKAGE__->table( 'actor_org_unit_setting' );
110 __PACKAGE__->columns( Primary => qw/id/);
111 __PACKAGE__->columns( Essential => qw/org_unit name value/);
114 #-------------------------------------------------------------------------------
115 package actor::stat_cat;
118 __PACKAGE__->table( 'actor_stat_cat' );
119 __PACKAGE__->columns( Primary => qw/id/ );
120 __PACKAGE__->columns( Essential => qw/owner name opac_visible usr_summary/ );
122 #-------------------------------------------------------------------------------
123 package actor::stat_cat_entry;
126 __PACKAGE__->table( 'actor_stat_cat_entry' );
127 __PACKAGE__->columns( Primary => qw/id/ );
128 __PACKAGE__->columns( Essential => qw/stat_cat owner value/ );
130 #-------------------------------------------------------------------------------
131 package actor::stat_cat_entry_user_map;
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/ );
138 #-------------------------------------------------------------------------------
142 __PACKAGE__->table( 'actor_card' );
143 __PACKAGE__->columns( Primary => qw/id/ );
144 __PACKAGE__->columns( Essential => qw/usr barcode active/ );
146 #-------------------------------------------------------------------------------
147 package actor::user_access_entry;
149 #-------------------------------------------------------------------------------
150 package actor::perm_group;
152 #-------------------------------------------------------------------------------
153 package actor::permission;
155 #-------------------------------------------------------------------------------
156 package actor::perm_group_permission_map;
158 #-------------------------------------------------------------------------------
159 package actor::perm_group_user_map;
161 #-------------------------------------------------------------------------------
162 package actor::user_address;
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/ );
171 #-------------------------------------------------------------------------------
172 package actor::org_address;
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/ );
180 #-------------------------------------------------------------------------------