sample

12 rows


Description

Samples within a survey

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sample_id serial 10 √ nextval('examples.sample_sample_id_seq'::regclass)
data_source_id int4 10 √ null
data_source.data_source_id sample_data_source_id_fkeyR
institute_id int4 10 √ null
institute.institute_id sample_institute_id_fkeyR

Institute that undertook survey
gear_id int4 10 √ null
gear.gear_id sample_gear_id_fkeyR

Gear used
vessel_id int4 10 √ null
vessel.vessel_id sample_vessel_id_fkeyR

Vessel used
trip_id int4 10 √ null
trip.trip_id sample_trip_id_fkeyR

Part of trip
tow_id int4 10 √ null
tow.tow_id sample_tow_id_fkeyR

Tow used
sampling_type_id int4 10 √ null
sampling_type.sampling_type_id sample_sampling_type_id_fkeyR

Sampling type
year int4 10 null

Year sample was undertaken
month int4 10 null

Month sample was undertaken
areacell_id int4 10 √ null
areacell.areacell_id sample_areacell_id_fkeyR

Areacell data relates to
species_id int8 19 √ null
species.species_id sample_species_id_fkeyR
age numeric 10,5 √ null

Age (years)
sex_id int4 10 √ null
sex.sex_id sample_sex_id_fkeyR

Sex ID
maturity_stage_id int4 10 √ null
maturity_stage.maturity_stage_id sample_maturity_stage_id_fkeyR

Maturity Stage ID
population_id int4 10 √ null
population.population_id sample_population_id_fkeyR

Population sample is part of
length float4 8,8 √ null

Length of fish / mean length of all fish
length_var float4 8,8 √ null

Length variance of all fish (given aggregated data)
length_min int4 10 √ null

Minimum theoretical value in this group
weight float4 8,8 √ null

Weight of fish / mean weight of all fish
weight_var float4 8,8 √ null

Weight variance of all fish (given aggregated data)
liver_weight float4 8,8 √ null

(mean) Weight of fish liver
liver_weight_var float4 8,8 √ null

(mean) Weight variance of fish liver (given aggregated data)
gonad_weight float4 8,8 √ null

(mean) Weight of fish gonads
gonad_weight_var float4 8,8 √ null

(mean) Weight variance of fish gonads (given aggregated data)
stomach_weight float4 8,8 √ null

(mean) Weight of fish stomach
stomach_weight_var float4 8,8 √ null

(mean) Weight variance of fish stomach (given aggregated data)
gutted_weight float4 8,8 √ null

(mean) Gutted weight of fish
gutted_weight_var float4 8,8 √ null

(mean) Gutted weight variance of fish (given aggregated data)
count float8 17,17 √ 1

Number of fish meeting this criteria

Indexes

Constraint Name Type Sort Column(s)
sample_pkey Primary key Asc sample_id

Check Constraints

Constraint Name Constraint
sample_month_check (((month >= 1) AND (month <= 12)))

Relationships

Close relationships within degrees of separation