Table odyssey_test._watiam.watiam_entry
Information from one line of the WatIAM Extract

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
pdbid int4 10
watiam_dept_name.pdbid watiam_dept_name_pdbid_fkey R
watiam_dept_num.pdbid watiam_dept_num_pdbid_fkey R
watiam_hr_id.pdbid watiam_hr_id_pdbid_fkey R
watiam_office.pdbid watiam_office_pdbid_fkey R
watiam_phone.pdbid watiam_phone_pdbid_fkey R
watiam_ts_id.pdbid watiam_ts_id_pdbid_fkey R
watiam_uw_id.pdbid watiam_uw_id_pdbid_fkey R
Persistent DB Identifier
surname text 2147483647 Surname (example, Smith)
givennames text 2147483647  √  null Given names (example, John Edward)
nicknames text 2147483647  √  null Familiar names (example, Ted)
email text 2147483647  √  null Electronic mail (example, jsmith@forestry.uwaterloo.ca)
homepage text 2147483647  √  null Personal web page (example, http://forestry.uwaterloo.ca/~jsmith)
visible bool 1 Privacy request, do not publish if FALSE
authority text 2147483647  √  null Authority who created entry
created date 13  √  null Date entry created
lastmentioned date 13  √  null Date last mentioned in authoritative source
activated date 13  √  null Date authentication token assigned
lastchanged date 13  √  null Date entry last changed
expires date 13  √  null Date entry should expire
hr_id int4 10  √  null First HR ID number
uw_id int4 10  √  null First student ID number
ts_id int4 10  √  null First Telephone Services ID number
userid text 2147483647 Standard UW userid (maximum 8 characters)
useridext text 2147483647 Additional UW userid characters; concatenate with userid to get full long userid
ou _text 2147483647  √  null Active Directory OU, separated into components
campus_email text 2147483647  √  null

Table contained 395,220 rows at Wed Feb 19 10:32 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
pdbid Primary key Asc watiam_entry_pkey
userid Must be unique Asc watiam_entry_userid_key

Close relationships: