Query Defining the BIOGRAPHY

%entities; %constants; ]>

Query Defining the BIOGRAPHY_UPLOAD View

SELECT biography_data.animid::TEXT AS "B_AnimID"
     , biography_data.animid_num::TEXT AS "B_AnimID_num"
     , biography_data.animname::TEXT AS "B_AnimName"
     , biography_data.birthgroup::TEXT AS "B_BirthGroup"
     , biography_data.bgcertainty::TEXT AS "B_BGCertainty"
     , biography_data.sex::TEXT AS "B_Sex"
     , biography_data.momid::TEXT AS "B_MomID"
     , CASE
         WHEN biography_data.dad_prelim THEN
           (biography_data.dadid || 'gmi_dadid_prelim')::TEXT
         ELSE
           biography_data.dadid::TEXT
       END AS "B_DadID"
     , biography_data.dad_published AS "B_DadID_publication_info"
     , biography_data.firstborn::TEXT AS "B_FirstBorn"
     , biography_data.birthdate AS "B_Birthdate"
     , biography_data.bdmin AS "B_BDMin"
     , biography_data.bdmax AS "B_BDMax"
     , biography_data.bddist::TEXT AS "B_BDDist"
     , biography_data.entrydate AS "B_Entrydate"
     , biography_data.entrytype::TEXT AS "B_Entrytype"
     , biography_data.departdate AS "B_Departdate"
     , biography_data.departdateerror AS "B_DepartdateError"
     , biography_data.departtype::TEXT AS "B_Departtype"
  FROM biography_data

;

Entity Relationship Diagram of the BIOGRAPHY_UPLOAD View If we could we would display here the diagram showing how the BIOGRAPHY_UPLOAD view is constructed.