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
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/ );
23 #-------------------------------------------------------------------------------
24 package actor::workstation;
27 __PACKAGE__->table( 'actor_workstation' );
28 __PACKAGE__->columns( Primary => qw/id/);
29 __PACKAGE__->columns( Essential => qw/name owning_lib/);
31 #-------------------------------------------------------------------------------
32 package actor::user_standing_penalty;
35 __PACKAGE__->table( 'actor_user_standing_penalty' );
36 __PACKAGE__->columns( Primary => qw/id/);
37 __PACKAGE__->columns( Essential => qw/usr penalty_type/);
39 #-------------------------------------------------------------------------------
40 package actor::user_setting;
43 __PACKAGE__->table( 'actor_user_setting' );
44 __PACKAGE__->columns( Primary => qw/id/);
45 __PACKAGE__->columns( Essential => qw/usr name value/);
47 #-------------------------------------------------------------------------------
48 package actor::profile;
51 __PACKAGE__->table( 'actor_profile' );
52 __PACKAGE__->columns( Primary => qw/id/);
53 __PACKAGE__->columns( Essential => qw/name/);
55 #-------------------------------------------------------------------------------
56 package actor::org_unit_type;
59 __PACKAGE__->table( 'actor_org_unit_type' );
60 __PACKAGE__->columns( Primary => qw/id/);
61 __PACKAGE__->columns( Essential => qw/name opac_label depth parent can_have_vols can_have_users/);
63 #-------------------------------------------------------------------------------
64 package actor::org_unit;
67 __PACKAGE__->table( 'actor_org_unit' );
68 __PACKAGE__->columns( Primary => qw/id/);
69 __PACKAGE__->columns( Essential => qw/parent_ou ou_type mailing_address billing_address
70 ill_address holds_address shortname name/);
72 #-------------------------------------------------------------------------------
73 package actor::org_unit_setting;
76 __PACKAGE__->table( 'actor_org_unit_setting' );
77 __PACKAGE__->columns( Primary => qw/id/);
78 __PACKAGE__->columns( Essential => qw/org_unit name value/);
81 #-------------------------------------------------------------------------------
82 package actor::stat_cat;
85 __PACKAGE__->table( 'actor_stat_cat' );
86 __PACKAGE__->columns( Primary => qw/id/ );
87 __PACKAGE__->columns( Essential => qw/owner name opac_visible/ );
89 #-------------------------------------------------------------------------------
90 package actor::stat_cat_entry;
93 __PACKAGE__->table( 'actor_stat_cat_entry' );
94 __PACKAGE__->columns( Primary => qw/id/ );
95 __PACKAGE__->columns( Essential => qw/stat_cat owner value/ );
97 #-------------------------------------------------------------------------------
98 package actor::stat_cat_entry_user_map;
101 __PACKAGE__->table( 'actor_stat_cat_entry_usr_map' );
102 __PACKAGE__->columns( Primary => qw/id/ );
103 __PACKAGE__->columns( Essential => qw/stat_cat stat_cat_entry target_usr/ );
105 #-------------------------------------------------------------------------------
109 __PACKAGE__->table( 'actor_card' );
110 __PACKAGE__->columns( Primary => qw/id/ );
111 __PACKAGE__->columns( Essential => qw/usr barcode active/ );
113 #-------------------------------------------------------------------------------
114 package actor::user_access_entry;
116 #-------------------------------------------------------------------------------
117 package actor::perm_group;
119 #-------------------------------------------------------------------------------
120 package actor::permission;
122 #-------------------------------------------------------------------------------
123 package actor::perm_group_permission_map;
125 #-------------------------------------------------------------------------------
126 package actor::perm_group_user_map;
128 #-------------------------------------------------------------------------------
129 package actor::user_address;
132 __PACKAGE__->table( 'actor_usr_address' );
133 __PACKAGE__->columns( Primary => qw/id/ );
134 __PACKAGE__->columns( Essential => qw/valid address_type usr street1 street2
135 city county state country post_code/ );
137 #-------------------------------------------------------------------------------
138 package actor::org_address;
141 __PACKAGE__->table( 'actor_org_address' );
142 __PACKAGE__->columns( Primary => qw/id/ );
143 __PACKAGE__->columns( Essential => qw/valid address_type org_unit street1 street2
144 city county state country post_code/ );
146 #-------------------------------------------------------------------------------
147 package actor::profile;
150 __PACKAGE__->table( 'actor_profile' );
151 __PACKAGE__->columns( Primary => qw/id/ );
152 __PACKAGE__->columns( Essential => qw/name/ );
154 #-------------------------------------------------------------------------------