Table odyssey_test._watiam.watiam_dept_num 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_num_pdbid_fkey R
dept_code_seq int4 10
dept_code text 2147483647

Table contained 103,547 rows at Wed Feb 19 10:32 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
pdbid + dept_code_seq Primary key Asc/Asc watiam_dept_num_pkey
dept_code Performance Asc watiam_dept_num_dept_code_idx

Close relationships  within of separation: