Task #549

Updated by Aaron Marcuse-Kubitza over 11 years ago

* include cascading fkeys 

 h3. Fkeys' covering indexes 

 |*Table*|*Field*|*Covering index*| 
 |aggregateoccurrence|source_id| _none_| 
 |commclass|classpublication_id| _unused_| 
 |commconcept|reference_id| _unused_| 
 |commdetermination|commauthority_id| _unused_| 
 |commname|source_id| _unused_| 
 |commstatus|source_id| _unused_| 
 |coordinates|source_id|coordinates_unique| 
 |covermethod|source_id| _unused_| 
 |location|source_id|location_creator| 
 |locationevent|source_id| _none_| 
 |method|source_id|method_unique| 
 |party|source_id| _none_| 
 |place|source_id|place_unique_within_creator_by_name| 
 |plantobservation|source_id| _none_| 
 |project|source_id| _none_| 
 |sourcecontributor|source_id| _unused_| 
 |sourcelist|source_id|sourcelist_unique| 
 |sourcename|matched_source_id| _none_| 
 |specimenreplicate|source_id| _none_| |specimenreplicate|source_id|| 
 |stemobservation|source_id| _none_| |stemobservation|source_id|| 
 |taxonconcept|concept_reference_id| _unused_| |taxonconcept|concept_reference_id|| 
 |taxondetermination|source_id| _none_| |taxondetermination|source_id|| 
 |taxondetermination|reference_id| _unused_| |taxondetermination|reference_id|| 
 |taxonlabel|source_id| _none_| |taxonlabel|source_id|| 
 |taxonoccurrence|source_id| _none_| |taxonoccurrence|source_id|| 
 |taxonstatus|source_id| _unused_| |taxonstatus|source_id|| 

Back