c2e631b900eb173a118b4b47c6f530c6dfe03b53
[Evergreen.git] / 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