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
22 claims_never_checked_out_count last_update_time/ );
24 #-------------------------------------------------------------------------------
25 package actor::usr_org_unit_opt_in;
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/ );
31 #-------------------------------------------------------------------------------
32 package actor::org_unit_proximity;
34 __PACKAGE__->table( 'actor_org_unit_proximity' );
35 __PACKAGE__->columns( Primary => qw/id/ );
36 __PACKAGE__->columns( Essential => qw/from_org to_org prox/ );
38 #-------------------------------------------------------------------------------
39 package actor::usr_note;
42 __PACKAGE__->table( 'actor_usr_note' );
43 __PACKAGE__->columns( Primary => qw/id/ );
44 __PACKAGE__->columns( Essential => qw/usr title creator create_date value pub/ );
46 #-------------------------------------------------------------------------------
47 package actor::workstation;
50 __PACKAGE__->table( 'actor_workstation' );
51 __PACKAGE__->columns( Primary => qw/id/);
52 __PACKAGE__->columns( Essential => qw/name owning_lib/);
54 #-------------------------------------------------------------------------------
55 package actor::user_standing_penalty;
58 __PACKAGE__->table( 'actor_user_standing_penalty' );
59 __PACKAGE__->columns( Primary => qw/id/);
60 __PACKAGE__->columns( Essential => qw/usr penalty_type/);
62 #-------------------------------------------------------------------------------
63 package actor::user_setting;
66 __PACKAGE__->table( 'actor_user_setting' );
67 __PACKAGE__->columns( Primary => qw/id/);
68 __PACKAGE__->columns( Essential => qw/usr name value/);
70 #-------------------------------------------------------------------------------
71 package actor::org_unit_type;
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/);
78 #-------------------------------------------------------------------------------
79 package actor::org_unit;
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/);
87 #-------------------------------------------------------------------------------
88 package actor::org_unit::hours_of_operation;
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/);
97 #-------------------------------------------------------------------------------
98 package actor::org_unit::closed_date;
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/);
106 #-------------------------------------------------------------------------------
107 package actor::org_unit_setting;
110 __PACKAGE__->table( 'actor_org_unit_setting' );
111 __PACKAGE__->columns( Primary => qw/id/);
112 __PACKAGE__->columns( Essential => qw/org_unit name value/);
115 #-------------------------------------------------------------------------------
116 package actor::stat_cat;
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/ );
123 #-------------------------------------------------------------------------------
124 package actor::stat_cat_entry;
127 __PACKAGE__->table( 'actor_stat_cat_entry' );
128 __PACKAGE__->columns( Primary => qw/id/ );
129 __PACKAGE__->columns( Essential => qw/stat_cat owner value/ );
131 #-------------------------------------------------------------------------------
132 package actor::stat_cat_entry_default;
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/ );
139 #-------------------------------------------------------------------------------
140 package actor::stat_cat_entry_user_map;
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/ );
147 #-------------------------------------------------------------------------------
151 __PACKAGE__->table( 'actor_card' );
152 __PACKAGE__->columns( Primary => qw/id/ );
153 __PACKAGE__->columns( Essential => qw/usr barcode active/ );
155 #-------------------------------------------------------------------------------
156 package actor::user_access_entry;
158 #-------------------------------------------------------------------------------
159 package actor::perm_group;
161 #-------------------------------------------------------------------------------
162 package actor::permission;
164 #-------------------------------------------------------------------------------
165 package actor::perm_group_permission_map;
167 #-------------------------------------------------------------------------------
168 package actor::perm_group_user_map;
170 #-------------------------------------------------------------------------------
171 package actor::user_address;
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/ );
180 #-------------------------------------------------------------------------------
181 package actor::org_address;
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/ );
189 #-------------------------------------------------------------------------------