Table TBASE2.TBASE2.PERSON Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
ID Column Type Size Nulls Auto Default Children Parents Comments
0 PERSON_ID bigint 8  √ 
CITATION_AUTHOR.AUTHORS_PERSON_ID FK24AA55E36707573B
CITATION_EDITOR.EDITORS_PERSON_ID FK2A8955C568F6F619
USER.PERSON_ID FK27E3CBE3910672
1 VERSION integer 4  √  null
2 EMAIL varchar 255  √  null
3 FIRSTNAME varchar 255  √  null
4 LASTNAME varchar 255
5 MNAME varchar 255  √  null
6 PHONE varchar 50  √  null
7 AUTHORID varchar 50  √  null

Table contained 1,775 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 PERSON_ID Must be unique Asc SQL080501230722990
2 LASTNAME Performance Asc PERSON_LNAME_IDX
3 EMAIL Performance Asc PERSON_EMAIL_IDX

Close relationships  within of separation: