Tables


SchemaSpy Analysis of mf

Generated on Wed Nov 16 12:35 UTC 2022

XML Representation
Insertion Order Deletion Order
TABLES 28
VIEWS 0
COLUMNS 183
Constraints 60
Anomalies 2
Routines 0

Database Properties

Database Type: PostgreSQL - 15.1 (Debian 15.1-1.pgdg110+1)

Tables

Table / View Children Parents Columns Rows Type Comments
population 2 1 4 0 Table
survey_index 0 3 7 24 Table

Indices used to modify surveys

trip 3 3 9 0 Table
vessel 3 3 9 2 Table
sex 3 1 4 5 Table
species 4 1 4 1483 Table
data_source 4 1 4 2 Table
division 0 1 3 4 Table

Grouping of area cells into divisions

predator 1 12 19 0 Table

Predators in predator/prey sample

index_type 2 1 4 1 Table
vessel_type 2 1 4 21 Table
prey 0 3 7 0 Table

Prey in predator/prey sample

sampling_type 3 1 4 0 Table
bait_type 2 1 4 0 Table
net_type 2 1 4 0 Table
port 3 2 6 0 Table
case_study 1 1 4 12 Table
stomach_state 2 1 4 6 Table
gear 3 1 7 147 Table
maturity_stage 3 1 4 5 Table
sample 0 12 30 12 Table

Samples within a survey

vessel_owner 2 1 4 0 Table
areacell 5 1 5 3 Table
institute 4 1 4 41 Table
mfdb_schema 0 0 1 1 Table

Table to keep track of schema version

digestion_stage 2 1 4 5 Table
market_category 1 1 4 0 Table
tow 3 3 16 0 Table