SchemaSpy - Table marinedb.form_postelsia_site_plot_location

reference table for postelsia web 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

postelsia_info.site_code

FK_postelsia_meter_info R

target_assemblage

varchar

postelsia_info.target_assemblage

FK_postelsia_meter_info R

plot_code

varchar

postelsia_info.plot_code

FK_postelsia_meter_info R

location

decimal

2,1

postelsia_direction_code

varchar

postelsia_direction_codes.postelsia_direction_code

FK_postelsia_direction_codes R

meter

decimal

3,1

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

Indexes:

Column(s)	Type	Sort	Constraint Name
postelsia_direction_code	Performance	Asc	FK_postelsia_direction_codes
site_code + target_assemblage + plot_code	Performance	Asc/Asc/Asc	FK_postelsia_meter_info