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 |