Table marinedb.abhab_segment_ids
list of segment ids that can be used for abalone habitat surveys

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
segment_id varchar 8
abhab_not_sampled.segment_id FK_abhab_notsampled_segment_id R
abhab_not_sampled_active.segment_id FK_abhab_notsampled_active_segment_id R
abhab_sampled.segment_id FK_abhab_sampled_segment_id R
abhab_sampled_active.segment_id FK_abhab_sampled_active_segment_id R
abhab_segment_boundaries.segment_id FK_abhab_seg_gps_segment_id R
abhab_segment_boundaries_active.segment_id FK_abhab_seg_gps_active_segment_id R
abhab_segment_info.segment_id FK_abhab_seg_info_segment_id R
abhab_segment_info.sub_of_segment_id FK_abhab_seg_info_subseg_id R
abhab_segment_info_active.segment_id FK_abhab_seg_info_active_segment_id R
abhab_segment_info_active.sub_of_segment_id FK_abhab_seg_info_active_subseg_id R
sort_order int 10
create_date date 10

Table contained 70 rows at Thu Apr 03 16:08 PDT 2025

Indexes:
Column(s) Type Sort Constraint Name
segment_id Primary key Asc PRIMARY

Close relationships  within of separation: