Table webco_3.9.1.public.person_ext 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
obj_oid serial 10  √  nextval('person_ext_obj_oid_seq'::regclass)
origin varchar 2147483647  √  null
csv_line_number int4 10  √  null
academic_career varchar 2147483647  √  null
academic_level varchar 2147483647  √  null
barcode varchar 2147483647  √  null
city varchar 2147483647  √  null
contact_note varchar 2147483647  √  null
country varchar 2147483647  √  null
department varchar 2147483647  √  null
email varchar 2147483647  √  null
expires varchar 2147483647  √  null
fax varchar 2147483647  √  null
first_name varchar 2147483647  √  null
last_name varchar 2147483647  √  null
note varchar 2147483647  √  null
other_name varchar 2147483647  √  null
password varchar 2147483647  √  null
patron_class varchar 2147483647  √  null
postal_code varchar 2147483647  √  null
state varchar 2147483647  √  null
status varchar 2147483647  √  null
street varchar 2147483647  √  null
street2 varchar 2147483647  √  null
telephone varchar 2147483647  √  null
userid varchar 2147483647  √  null

Table contained 0 rows at Tue Feb 04 14:58 EST 2014