Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.bib_notes 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
_refs_key int4 10
bib_refs._refs_key bib_notes__refs_key R
sequencenum int4 10
note bpchar 255
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 12,005 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_refs_key + sequencenum Primary key Asc/Asc bib_notes_pkey
_refs_key + sequencenum Must be unique Asc/Asc bib_notes_idx_refs_sequence_key
note Performance Asc bib_notes_idx_note

Close relationships  within of separation: