SchemaSpy - Table marinedb.abhab_substrate

the substrate codes for abalone habitat surveys

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

substrate_code

varchar

abhab_plot_physical_info.substrate_code	FK_abhab_plot_info_substrate R
abhab_plot_physical_info_active.substrate_code	FK_abhab_plot_info_active_substrate R
abhab_segment_info.substrate_code	FK_abhab_seg_info_substrate R
abhab_segment_info_active.substrate_code	FK_abhab_seg_info_active_substrate R

substrate_description

varchar

150

create_date

date

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

Indexes:

Column(s)	Type	Sort	Constraint Name
substrate_code	Primary key	Asc	PRIMARY