Fields in DSPACE eperson table
dspace_sr=> \d eperson
Table "public.eperson"
Column | Type | Modifiers
---------------------+-----------------------------+-----------
eperson_id | integer | not null
email | character varying(64) |
password | character varying(64) |
firstname | character varying(64) |
lastname | character varying(64) |
can_log_in | boolean |
require_certificate | boolean |
self_registered | boolean |
last_active | timestamp without time zone |
sub_frequency | integer |
phone | character varying(32) |
netid | character varying(64) |
Indexes:
"eperson_pkey" primary key, btree (eperson_id)
"eperson_email_key" unique, btree (email)
"eperson_email_idx" btree (email)
"eperson_netid_idx" btree (netid)
SQL to check for empty fields
field: last_active
dspace_sr=> select last_active from eperson where last_active ~ '.*';
last_active
-------------
(0 rows)
last_active is empty
field: netid
dspace_sr=> select netid from eperson where netid~'.*';
netid
-------------
(0 rows)
last_active is netid
field: require_certificate are all false
dspace_sr=> select require_certificate from eperson where require_certificate = 't';
require_certificate
---------------------
(0 rows)
field: can_log_in are all true
dspace_sr=> select can_log_in from eperson where can_log_in = 'f' ;
can_log_in
------------
(0 rows)
field: can_log_in are all true
dspace_sr=> select can_log_in from eperson where can_log_in = 'f' ;
can_log_in
------------
(0 rows)
field: self_registered is a small group
dspace_sr=> select * from eperson where self_registered = 'f' ;
eperson_id | email | password | firstname | lastname | can_log_in | require_certificate | self_registered | last_active | sub_frequency | phone | netid
------------+--------------------+----------------------------------+-----------+----------+------------+---------------------+-----------------+-------------+---------------+-------+-------
1 | teale003@umn.edu | 76419c58730d9f35de7ac538c2fd6737 | Brad | Teale | t | f | f | | | |
3 | jkelly@umn.edu | 1a9bb0d26640ffb18ee06ae398d201ad | Julia | Kelly | t | f | f | | | |
5 | skill@umn.edu | fa483ad4f1d094e0d5aaa31856d618ec | Sharon | Kill | t | f | f | | | |
21 | ruddy005@gmail.com | f850f3fb454e369b8b3444ad66fcd469 | Martha | Ruddy | t | f | f | | | |
2 | lletnes@umn.edu | a8113a9b4f61b178cd1fea4efa5bf4c8 | Louise | Letnes | t | f | f | | | |
15 | jsilvis@umn.edu | 7f8b6712b097089167df2fd678ae8133 | Jeff | Silvis | t | f | f | | | |
(6 rows)
These people were put in by a bash script.