Table marinedb.postelsia_info
postelsia plot information

 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
form_postelsia_site_plot_location_meter.site_code FK_postelsia_meter_info R
postelsia.site_code FK_postelsia_sinfo R
postelsia_notes.site_code FK_postelsia_notes_target R
marine_sites.site_code FK_postelsia_info_site_code R
target_assemblage varchar 20
form_postelsia_site_plot_location_meter.target_assemblage FK_postelsia_meter_info R
postelsia.target_assemblage FK_postelsia_sinfo R
postelsia_notes.target_assemblage FK_postelsia_notes_target R
target_assemblages.target_assemblage FK_postelsia_info_assemblage R
plot_code varchar 6
form_postelsia_site_plot_location_meter.plot_code FK_postelsia_meter_info R
postelsia.plot_code FK_postelsia_sinfo R
count_size_plot_codes.plot_code FK_postelsia_info_plot_code R
length_m int 10
standard_location_number varchar 3  √  null
standard_location_width varchar 3  √  null
swath_location_number varchar 3  √  null
swath_location_width varchar 3  √  null
plot_area_m2 int 10
established_date date 10
end_date date 10  √  null
active_status enum 8
comments varchar 100  √  null
create_date date 10
modify_date timestamp 19 current_timestamp()

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

Indexes:
Column(s) Type Sort Constraint Name
site_code + target_assemblage + plot_code Primary key Asc/Asc/Asc PRIMARY
target_assemblage Performance Asc FK_postelsia_info_assemblage
plot_code Performance Asc FK_postelsia_info_plot_code

Close relationships  within of separation: