Table odyssey_test._watiam.watiam_dept_name 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_entry.pdbid watiam_dept_name_pdbid_fkey R
dept_name_seq int4 10
dept_name text 2147483647

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

Indexes:
Column(s) Type Sort Constraint Name
pdbid + dept_name_seq Primary key Asc/Asc watiam_dept_name_pkey
dept_name Performance Asc watiam_dept_name_dept_name_idx

Close relationships  within of separation: