Project

General

Profile

« Previous | Next » 

Revision 11963

schemas/vegbien.sql: plot.**, analytical_stem_view, analytical_plot: added project_contributors

View differences:

schemas/vegbien.my.sql
810 810
    geovalid_bien int(11),
811 811
    `isNewWorld_bien` int(11),
812 812
    `projectID` varchar(255),
813
    project_contributors varchar(255),
813 814
    `locationID` varchar(255) NOT NULL,
814 815
    `locationName` varchar(255),
815 816
    subplot varchar(255),
......
1784 1785

  
1785 1786

  
1786 1787
--
1787
-- Name: VIEW collected_dates; Type: COMMENT; Schema: public; Owner: -
1788
--
1789

  
1790

  
1791

  
1792

  
1793
--
1794 1788
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1795 1789
--
1796 1790

  
schemas/vegbien.sql
1713 1713
    geovalid_bien integer,
1714 1714
    "isNewWorld_bien" integer,
1715 1715
    "projectID" text,
1716
    project_contributors text[],
1716 1717
    "locationID" text NOT NULL,
1717 1718
    "locationName" text,
1718 1719
    subplot text,
......
1924 1925
    analytical_stem.geovalid_bien, 
1925 1926
    analytical_stem."isNewWorld_bien", 
1926 1927
    analytical_stem."projectID", 
1928
    analytical_stem.project_contributors, 
1927 1929
    analytical_stem."locationID", 
1928 1930
    analytical_stem."locationName", 
1929 1931
    analytical_stem.subplot, 
......
2572 2574
    (geoscrub_output.geovalid)::integer AS geovalid_bien, 
2573 2575
    ("newWorldCountries"."isNewWorld")::integer AS "isNewWorld_bien", 
2574 2576
    COALESCE(project.sourceaccessioncode, project.projectname) AS "projectID", 
2577
    ARRAY( SELECT project_contributors(project.project_id) AS project_contributors) AS project_contributors, 
2575 2578
    COALESCE(location.sourceaccessioncode, NULLIF(concat_ws('; '::text, COALESCE(parent_location.sourceaccessioncode, parent_location.authorlocationcode), location.authorlocationcode), ''::text)) AS "locationID", 
2576 2579
    COALESCE(parent_location.authorlocationcode, location.authorlocationcode) AS "locationName", 
2577 2580
        CASE
......
2894 2897
    "plot.**".geovalid_bien, 
2895 2898
    "plot.**"."isNewWorld_bien", 
2896 2899
    "plot.**"."projectID", 
2900
    "plot.**".project_contributors, 
2897 2901
    "plot.**"."locationID", 
2898 2902
    "plot.**"."locationName", 
2899 2903
    "plot.**".subplot, 
......
3024 3028

  
3025 3029

  
3026 3030
--
3027
-- Name: VIEW collected_dates; Type: COMMENT; Schema: public; Owner: -
3028
--
3029

  
3030
COMMENT ON VIEW collected_dates IS 'runtime: 2.5 min ("155959 ms. 52527 rows retrieved.")';
3031

  
3032

  
3033
--
3034 3031
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3035 3032
--
3036 3033

  

Also available in: Unified diff