fip_db_view_2023

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

uuid

varchar

√

null

db_version_year

int4

√

null

fip_current_name

text

2147483647

√

null

fip_url

text

2147483647

√

null

acronym

varchar

√

null

fip_start_date

date

√

null

progress_pattern

varchar

√

null

fip_fleet_type

varchar

√

null

artisanal_component_stock

bool

√

null

artisanal_component_notes

text

2147483647

√

null

first_msc_pa_date

date

√

null

scope

varchar

√

null

gfp_id

int4

√

null

sr_id

int4

√

null

fip_stat_status

varchar

√

null

volume

float8

17,17

√

null

progress_rating

varchar

√

null

fip_stat_type

varchar

√

null

fip_stat_created_at

timestamp

29,6

√

null

fip_stat_year

int4

√

null

isscfg

varchar

√

null

gears.isscfg

Implied ConstraintR

stock_name

text

2147483647

√

null

management_unit_name

text

2147483647

√

null

gfp_name

text

2147483647

√

null

gfp_url

varchar

255

√

null

fao_areas

text

2147483647

√

null

species_id

int4

√

null

iso_alpha3

varchar

√

null

countries.iso_alpha3

Implied ConstraintR

data_last_updated_at

timestamp

29,6

√

null

status

varchar

√

null

longitude

float8

17,17

√

null

latitude

float8

17,17

√

null

t75_seafood_sector

varchar

2147483647

√

null

gfp_created_at

timestamp

29,6

√

null

sr_name

varchar

255

√

null

first_meeting_date

date

√

null

sr_created_at

timestamp

29,6

√

null

fip_lead_type

text

2147483647

√

null

fip_lead_type_name

varchar

255

√

null

country_name

text

2147483647

√

null

unregion

text

2147483647

√

null

unregion_code

int4

√

null

country_created_at

timestamp

29,6

√

null

group_isscfg

varchar

√

null

gears.isscfg

Implied ConstraintR

gear_name

text

2147483647

√

null

abbreviation

varchar

√

null

gear_created_at

timestamp

29,6

√

null

fao_name

varchar

2147483647

√

null

species_type

varchar

2147483647

√

null

genus

varchar

2147483647

√

null

specific_descriptor

varchar

2147483647

√

null

common_names

varchar

2147483647

√

null

family

varchar

2147483647

√

null

fao_isscaap_group

varchar

2147483647

√

null

code_3a

varchar

√

null

taxocode

varchar

2147483647

√

null

species_created_at

timestamp

29,6

√

null

max_fip_stage_db_2023_current_name

text

2147483647

√

null

max_fip_stage_db_2023_fleet_type

varchar

√

null

max_stage

int4

√

null

months_to_stage3_db_2023_current_name

text

2147483647

√

null

months_to_stage3_db_2023_start_date

date

√

null

days_taken

int4

√

null

months_taken

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT fips.uuid,
    fips.db_version_year,
    fips.current_name AS fip_current_name,
    fips.url AS fip_url,
    fips.acronym,
    fips.start_date AS fip_start_date,
    fips.progress_pattern,
    fips.fleet_type AS fip_fleet_type,
    fips.artisanal_component_stock,
    fips.artisanal_component_notes,
    fips.first_msc_pa_date,
    fips.scope,
    fips_gfps.gfp_id,
    fips_srs.sr_id,
    fips_stats.status AS fip_stat_status,
    fips_stats.volume,
    fips_stats.progress_rating,
    fips_stats.type AS fip_stat_type,
    fips_stats.created_at AS fip_stat_created_at,
    fips_stats.year AS fip_stat_year,
    gfps.isscfg,
    gfps.stock_name,
    gfps.management_unit_name,
    gfps.name AS gfp_name,
    gfps.url AS gfp_url,
    gfps.fao_areas,
    gfps.species_id,
    gfps.iso_alpha3,
    gfps.data_last_updated_at,
    gfps.status,
    gfps.longitude,
    gfps.latitude,
    gfps.t75_seafood_sector,
    gfps.created_at AS gfp_created_at,
    srs.name AS sr_name,
    srs.start_date AS first_meeting_date,
    srs.created_at AS sr_created_at,
    fip_lead_types_db_2023.type AS fip_lead_type,
    fip_lead_types_db_2023.name AS fip_lead_type_name,
    countries.country_name,
    countries.unregion,
    countries.unregion_code,
    countries.created_at AS country_created_at,
    gears.group_isscfg,
    gears.name AS gear_name,
    gears.abbreviation,
    gears.created_at AS gear_created_at,
    species.fao_name,
    species.type AS species_type,
    species.genus,
    species.specific_descriptor,
    species.common_names,
    species.family,
    species.fao_isscaap_group,
    species.code_3a,
    species.taxocode,
    species.created_at AS species_created_at,
    max_fip_stage_db_2023.current_name AS max_fip_stage_db_2023_current_name,
    max_fip_stage_db_2023.fleet_type AS max_fip_stage_db_2023_fleet_type,
    max_fip_stage_db_2023.max_stage,
    months_to_stage3_db_2023.current_name AS months_to_stage3_db_2023_current_name,
    months_to_stage3_db_2023.start_date AS months_to_stage3_db_2023_start_date,
    months_to_stage3_db_2023.days_taken,
    months_to_stage3_db_2023.months_taken
   FROM (((((((((((fips
     LEFT JOIN fips_gfps ON ((((fips.uuid)::text = (fips_gfps.fip_uuid)::text) AND (fips.db_version_year = fips_gfps.db_version_year))))
     LEFT JOIN fips_srs ON ((((fips.uuid)::text = (fips_srs.fip_uuid)::text) AND (fips.db_version_year = fips_srs.db_version_year))))
     LEFT JOIN fips_stats ON ((((fips.uuid)::text = (fips_stats.fip_uuid)::text) AND (fips.db_version_year = fips_stats.year))))
     LEFT JOIN gfps ON ((fips_gfps.gfp_id = gfps.id)))
     LEFT JOIN srs ON ((fips_srs.sr_id = srs.id)))
     LEFT JOIN fip_lead_types_db_2023 ON (((fips_stats.fip_uuid)::text = (fip_lead_types_db_2023.uuid)::text)))
     LEFT JOIN countries ON (((gfps.iso_alpha3)::text = (countries.iso_alpha3)::text)))
     LEFT JOIN gears ON (((gfps.isscfg)::text = (gears.isscfg)::text)))
     LEFT JOIN species ON ((gfps.species_id = species.id)))
     LEFT JOIN max_fip_stage_db_2023 ON (((fip_lead_types_db_2023.uuid)::text = (max_fip_stage_db_2023.uuid)::text)))
     LEFT JOIN months_to_stage3_db_2023 ON (((max_fip_stage_db_2023.uuid)::text = (months_to_stage3_db_2023.uuid)::text)))
  WHERE (fips.db_version_year = 2023);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views