Table marinedb.abhab_segment_info_active
abalone habitat segment physical info data entry

 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
site_code char 6
abhab_not_sampled_active.site_code FK_abhab_notsampled_active_segments R
abhab_sampled_active.site_code FK_abhab_sampled_active_segments R
abhab_segments_count_sizes_active.site_code FK_abhab_count_sizes_active_segments R
marine_sites.site_code FK_abhab_seg_info_active_marine_sites R
field_events_active.site_code FK_abhab_seg_info_active_fe R
survey_date date 10
abhab_not_sampled_active.survey_date FK_abhab_notsampled_active_segments R
abhab_sampled_active.survey_date FK_abhab_sampled_active_segments R
abhab_segments_count_sizes_active.survey_date FK_abhab_count_sizes_active_segments R
field_events_active.survey_date FK_abhab_seg_info_active_fe R
group_code varchar 8
abhab_not_sampled_active.group_code FK_abhab_notsampled_active_segments R
abhab_sampled_active.group_code FK_abhab_sampled_active_segments R
abhab_segments_count_sizes_active.group_code FK_abhab_count_sizes_active_segments R
field_events_active.group_code FK_abhab_seg_info_active_fe R
target_assemblage varchar 8
target_assemblages.target_assemblage FK_abhab_seg_info_active_target R
segment_id varchar 8
abhab_not_sampled_active.segment_id FK_abhab_notsampled_active_segments R
abhab_sampled_active.segment_id FK_abhab_sampled_active_segments R
abhab_segments_count_sizes_active.segment_id FK_abhab_count_sizes_active_segments R
abhab_segment_ids.segment_id FK_abhab_seg_info_active_segment_id R
sub_of_segment_id varchar 8 NA
abhab_segment_ids.segment_id FK_abhab_seg_info_active_subseg_id R
start_time time 8
end_time time 8
segment_type enum 12 full_sample
percent_good int 10
percent_moderate int 10
percent_poor int 10
percent_good_nobio varchar 3 NA
percent_moderate_nobio varchar 3 NA
percent_poor_nobio varchar 3 NA
percent_abs_removable varchar 3 NA
shoreline_length_m int 10
area_m2 int 10
adjusted_area_m2 int 10
substrate_code varchar 40
abhab_substrate_codes.substrate_code FK_abhab_seg_info_active_substrate R
relief enum 8 ND
rock_type varchar 20
abhab_rock_type_codes.rock_type_code FK_abhab_seg_info_active_rock_type R
exposure enum 8 ND
sediment_influence enum 8 ND
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 157 rows at Thu Nov 06 11:53 PST 2025

Indexes:
Column(s) Type Sort Constraint Name
site_code + survey_date + group_code + segment_id Primary key Asc/Asc/Asc/Asc PRIMARY
rock_type Performance Asc FK_abhab_seg_info_active_rock_type
segment_id Performance Asc FK_abhab_seg_info_active_sub_segment_id
sub_of_segment_id Performance Asc FK_abhab_seg_info_active_subseg_id
substrate_code Performance Asc FK_abhab_seg_info_active_substrate
target_assemblage Performance Asc FK_abhab_seg_info_active_target

Close relationships  within of separation: