SchemaSpy - Table marinedb.abhab_segment_info_active

abalone habitat segment physical info data entry

Generated by
SchemaSpy

Legend:

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 0 rows at Thu Apr 03 16:08 PDT 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