Table db173.checklist_detail Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
DETAIL_ID int 11  √ 
CHECKLIST_ID smallint 6  √  null
checklist.CHECKLIST_ID checklist_detail_ibfk_1
LOCALE_ID smallint 6  √  null
supported_locale.LOCALE_ID checklist_detail_ibfk_2
DETAIL_TEXT varchar 250  √  null
ANSWER_TYPE smallint 6

Table contained 0 rows at Mon Feb 04 14:59 PST 2008

Indexes:
Column(s) Type Sort Constraint Name
DETAIL_ID Primary key Asc PRIMARY
CHECKLIST_ID + LOCALE_ID Performance Asc/Asc CHK_DETAIL_IDX
LOCALE_ID Performance Asc LOCALE_ID

Close relationships  within one two degrees of separation :