| Table marinedb.field_event_recon_active field event reconnaisance data entry from the field log
|
Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 0 rows at Thu Nov 06 11:53 PST 2025 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| site_code + survey_date + group_code + species_code | Primary key | Asc/Asc/Asc/Asc | PRIMARY |
| recon_abundance_code | Performance | Asc | FK_field_event_recon_active_abundance_codes |
| bleached_recon_condition_code | Performance | Asc | FK_field_event_recon_active_bleached_condition_codes |
| damaged_recon_condition_code | Performance | Asc | FK_field_event_recon_active_damaged_condition_codes |
| fertile_recon_condition_code | Performance | Asc | FK_field_event_recon_active_fertile_condition_codes |
| group_code + species_code | Performance | Asc/Asc | FK_field_event_recon_active_group_species |
| recon_recruitment_code | Performance | Asc | FK_field_event_recon_active_recruitment_codes |
|