v_dataset_result

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

citation_num

int4

√

null

citation_code

text

2147483647

√

null

citation_title

varchar

256

√

null

dataset_num

int4

√

null

dataset.dataset_num

Implied ConstraintR

dataset_code

varchar

√

null

dataset_title

varchar

512

√

null

station_num

int4

√

null

expedition_num

int4

√

null

expedition_code

varchar

256

√

null

expedition_name_leg_alias

varchar

2000

√

null

station_code

varchar

√

null

specimen_num

int4

√

null

specimen_code

varchar

√

null

analyzed_sample_num

int4

√

null

analyzed_sample_code

varchar

√

null

analysis_comment

varchar

2000

√

null

material_code

varchar

255

√

null

material_name

varchar

255

√

null

taxon

varchar

2000

√

null

taxonomic_classifier_name

varchar

256

√

null

method_code

varchar

√

null

method_name

varchar

2000

√

null

laboratory

varchar

256

√

null

method_comment

varchar

2000

√

null

action_num

int4

√

null

action.action_num

Implied ConstraintR

variable_num

int4

√

null

variable.variable_num

Implied ConstraintR

variable_code

varchar

√

null

variable_definition

varchar

2000

√

null

variable_order

int4

√

null

variable_type_code

varchar

255

√

null

variable_type_description

varchar

255

√

null

value_meas

text

2147483647

√

null

stdev

float8

17,17

√

null

stdev_type

varchar

255

√

null

processing_level_num

int4

√

null

processing_level.processing_level_num

Implied ConstraintR

unit

varchar

√

null

sample_taxon

_text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT cd.citation_num,
    cd.citation_code,
    cd.citation_title,
    ds.dataset_num,
    ds.dataset_code,
    ds.dataset_title,
    sfs.sampling_feature_num AS station_num,
    sfs.action_num AS expedition_num,
    sfs.action_name AS expedition_code,
    sfs.action_description AS expedition_name_leg_alias,
    sfs.sampling_feature_code AS station_code,
    sfp.sampling_feature_num AS specimen_num,
    sfp.sampling_feature_code AS specimen_code,
    sf.sampling_feature_num AS analyzed_sample_num,
    sf.sampling_feature_code AS analyzed_sample_code,
    sf.sampling_feature_description AS analysis_comment,
    material.material_code,
    material.material_name,
    tc.taxonomic_classifier_common_name AS taxon,
    tc.taxonomic_classifier_name,
    me.method_code,
    me.method_name,
    org.organization_name AS laboratory,
    a.action_description AS method_comment,
    a.action_num,
    var.variable_num,
    var.variable_code,
    var.variable_definition,
    var.display_order AS variable_order,
    vartype.variable_type_code,
    vartype.variable_type_description,
    to_char(round((nd.value_meas)::numeric, 60), 'FM999999999999999999999999999990.099999999999999999999999999999'::text) AS value_meas,
    nd.stdev,
    nd.stdev_type,
    r.processing_level_num,
    unit.unit_abbreviation AS unit,
    sptc.taxon AS sample_taxon
   FROM (((dataset ds
     JOIN ( SELECT cd_1.dataset_num,
            cd_1.citation_num,
            ci.title AS citation_title,
            (((p.last_name)::text || ','::text) || ci.publication_year) AS citation_code
           FROM citation_dataset cd_1,
            citation ci,
            author_list al,
            person p
          WHERE ((ci.citation_num = cd_1.citation_num) AND (cd_1.citation_num = al.citation_num) AND (al.person_num = p.person_num) AND (al.author_order = 1))) cd ON ((cd.dataset_num = ds.dataset_num)))
     JOIN (((action a
     JOIN method me ON ((a.method_num = me.method_num)))
     JOIN organization org ON ((a.organization_num = org.organization_num)))
     JOIN ((feature_action fa
     JOIN (((sampling_feature sf
     JOIN (related_feature rf
     LEFT JOIN (sampling_feature sfp
     JOIN (related_feature rfs
     LEFT JOIN ( SELECT s.sampling_feature_num,
            s.sampling_feature_code,
            a_1.action_num,
            a_1.action_description,
            a_1.action_name
           FROM sampling_feature s,
            feature_action fa_1,
            action a_1
          WHERE ((a_1.action_num = fa_1.action_num) AND (a_1.action_type_num = ANY (ARRAY[3, 11, 12, 25])) AND (fa_1.sampling_feature_num = s.sampling_feature_num))) sfs ON ((sfs.sampling_feature_num = rfs.related_sampling_feature_num))) ON (((sfp.sampling_feature_num = rfs.sampling_feature_num) AND (rfs.relationship_type_num = 22)))) ON ((sfp.sampling_feature_num = rf.related_sampling_feature_num))) ON (((sf.sampling_feature_num = rf.sampling_feature_num) AND (rf.relationship_type_num = 9))))
     JOIN (specimen
     JOIN material ON ((material.material_num = specimen.material_num))) ON ((specimen.sampling_feature_num = sf.sampling_feature_num)))
     LEFT JOIN (sampling_feature_taxonomic_classifier sftc
     JOIN taxonomic_classifier tc ON ((sftc.taxonomic_classifier_num = tc.taxonomic_classifier_num))) ON ((sftc.sampling_feature_num = sf.sampling_feature_num))) ON ((sf.sampling_feature_num = fa.sampling_feature_num)))
     JOIN (((result r
     JOIN variable var ON ((r.variable_num = var.variable_num)))
     JOIN variable_type vartype ON ((var.variable_type_num = vartype.variable_type_num)))
     JOIN (numeric_data nd
     JOIN unit ON ((nd.unit_num = unit.unit_num))) ON ((nd.result_num = r.result_num))) ON ((r.feature_action_num = fa.feature_action_num))) ON ((a.action_num = fa.action_num))) ON (((a.dataset_num = ds.dataset_num) AND (a.action_type_num = 20))))
     LEFT JOIN ( SELECT sftc_1.sampling_feature_num,
            array_agg(DISTINCT (((((((tc_1.rock_type)::text || '|'::text) || (tc_1.rock_class)::text) || '|'::text) || cia.citation_code) || '|'::text) || cia.citation_num)) AS taxon
           FROM ((sampling_feature_taxonomic_classifier sftc_1
             JOIN ( SELECT tc1.taxonomic_classifier_num AS rock_class_num,
                    tc2.taxonomic_classifier_common_name AS rock_type,
                    tc1.taxonomic_classifier_name AS rock_class
                   FROM (taxonomic_classifier tc1
                     JOIN taxonomic_classifier tc2 ON ((tc1.parent_taxonomic_classifier_num = tc2.taxonomic_classifier_num)))
                  WHERE ((tc1.taxonomic_classifier_type_cv)::text = 'Rock Class'::text)
                  ORDER BY tc2.taxonomic_classifier_name, tc1.taxonomic_classifier_name) tc_1 ON ((sftc_1.taxonomic_classifier_num = tc_1.rock_class_num)))
             JOIN ( SELECT ci.citation_num,
                    (((p.last_name)::text || ','::text) || ci.publication_year) AS citation_code
                   FROM citation ci,
                    author_list al,
                    person p
                  WHERE ((ci.citation_num = al.citation_num) AND (al.person_num = p.person_num) AND (al.author_order = 1))) cia ON ((cia.citation_num = sftc_1.citation_num)))
          GROUP BY sftc_1.sampling_feature_num) sptc ON ((sptc.sampling_feature_num = sfp.sampling_feature_num)))
  ORDER BY ds.dataset_num;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views