SchemaSpy - Table marinedb.size

MARINe size qualifiers

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

size_qualifier_code

varchar

abalone_count_sizes.size_qualifier_code	FK_abalone_count_sizes_size_code R
abalone_count_sizes_active.size_qualifier_code	FK_abalone_count_sizes_active_size_code R
abalone_empty_shells.size_qualifier_code	FK_abalone_emptys_size_code R
abalone_empty_shells_active.size_qualifier_code	FK_abalone_emptys_active_size_code R
abhab_plots_count_sizes.size_qualifier_code	FK_abhabplot_count_sizes_size_code R
abhab_plots_count_sizes_active.size_qualifier_code	FK_abhabplot_count_sizes_active_size_code R
abhab_segments_count_sizes.size_qualifier_code	FK_abhab_count_sizes_size_code R
abhab_segments_count_sizes_active.size_qualifier_code	FK_abhab_count_sizes_active_size_code R
cryptochiton_count_sizes.size_qualifier_code	FK_cry_count_sizes_size_qualifier R
cryptochiton_count_sizes_active.size_qualifier_code	FK_cry_count_sizes_active_size_qualifier R
katharina_count_sizes.size_qualifier_code	FK_kat_count_sizes_size_qualifier R
katharina_count_sizes_active.size_qualifier_code	FK_kat_count_sizes_active_sz_qual R
lottia_count_sizes.size_qualifier_code	FK_lottia_count_sizes_size_code R
lottia_count_sizes_active.size_qualifier_code	FK_lottia_count_sizes_active_size_code R
sea_star_color_count_sizes.size_qualifier_code	FK_sea_star_colors_size_code R
sea_star_disease_count_sizes.size_qualifier_code	FK_sea_star_disease_count_sizes_size_code R
sea_star_disease_count_sizes_active.size_qualifier_code	FK_sea_star_disease_count_sizes_active_size_code R
urchin_count_sizes.size_qualifier_code	FK_urchin_count_sizes_size_code R
urchin_count_sizes_active.size_qualifier_code	FK_urchin_count_sizes_active_size_code R

qualifier_codes.qualifier_code

FK_size_qualifiers_code R

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

Indexes:

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