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 |