SchemaSpy - Table marinedb.qualifier

MARINe qualifier codes

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

qualifier_code

varchar

collection_qualifiers.collection_qualifier_code	FK_collection_qualifiers_code R
count_qualifiers.count_qualifier_code	FK_count_qualifiers_code R
mussel_depth_qualifiers.qualifier_code	FK_mussel_depth_qualifiers_code R
mussel_size_qualifiers.qualifier_code	FK_mussel_size_qualifier_code R
photo_plot_qualifiers.qualifier_code	FK_photo_plot_qualifiers_code R
postelsia_qualifiers.postelsia_qualifier_code	FK_postelsia_qualifiers_code R
size_qualifiers.size_qualifier_code	FK_size_qualifiers_code R
transect_qualifiers.transect_qualifier_code	FK_transect_qualifiers_code R

qualifier_description

varchar

100

create_date

date

modify_date

timestamp

current_timestamp()

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

Indexes:

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