Revision 5286
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1860 | 1860 |
|
| 1861 | 1861 |
|
| 1862 | 1862 |
-- |
| 1863 |
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1864 |
-- |
|
| 1865 |
|
|
| 1866 |
CREATE TABLE plantcorrelation ( |
|
| 1867 |
plantcorrelation_id int(11) NOT NULL, |
|
| 1868 |
plantstatus_id int(11) NOT NULL, |
|
| 1869 |
taxonconcept_id int(11) NOT NULL, |
|
| 1870 |
plantconvergence text NOT NULL, |
|
| 1871 |
correlationstart timestamp NOT NULL, |
|
| 1872 |
correlationstop timestamp NULL |
|
| 1873 |
); |
|
| 1874 |
|
|
| 1875 |
|
|
| 1876 |
-- |
|
| 1877 |
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1878 |
-- |
|
| 1879 |
|
|
| 1880 |
|
|
| 1881 |
|
|
| 1882 |
|
|
| 1883 |
-- |
|
| 1884 |
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1885 |
-- |
|
| 1886 |
|
|
| 1887 |
|
|
| 1888 |
|
|
| 1889 |
|
|
| 1890 |
-- |
|
| 1891 |
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1892 |
-- |
|
| 1893 |
|
|
| 1894 |
CREATE TABLE plantlineage ( |
|
| 1895 |
plantlineage_id int(11) NOT NULL, |
|
| 1896 |
childplantstatus_id int(11) NOT NULL, |
|
| 1897 |
parentplantstatus_id int(11) NOT NULL |
|
| 1898 |
); |
|
| 1899 |
|
|
| 1900 |
|
|
| 1901 |
-- |
|
| 1902 |
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1903 |
-- |
|
| 1904 |
|
|
| 1905 |
|
|
| 1906 |
|
|
| 1907 |
|
|
| 1908 |
-- |
|
| 1909 |
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1910 |
-- |
|
| 1911 |
|
|
| 1912 |
|
|
| 1913 |
|
|
| 1914 |
|
|
| 1915 |
-- |
|
| 1916 | 1863 |
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1917 | 1864 |
-- |
| 1918 | 1865 |
|
| ... | ... | |
| 1927 | 1874 |
|
| 1928 | 1875 |
|
| 1929 | 1876 |
-- |
| 1930 |
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1931 |
-- |
|
| 1932 |
|
|
| 1933 |
CREATE TABLE plantstatus ( |
|
| 1934 |
plantstatus_id int(11) NOT NULL, |
|
| 1935 |
taxonconcept_id int(11) NOT NULL, |
|
| 1936 |
party_id int(11), |
|
| 1937 |
taxonconceptstatus text DEFAULT 'undetermined' NOT NULL, |
|
| 1938 |
reference_id int(11), |
|
| 1939 |
plantpartycomments text, |
|
| 1940 |
startdate timestamp NULL, |
|
| 1941 |
stopdate timestamp NULL, |
|
| 1942 |
accessioncode text |
|
| 1943 |
); |
|
| 1944 |
|
|
| 1945 |
|
|
| 1946 |
-- |
|
| 1947 |
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1948 |
-- |
|
| 1949 |
|
|
| 1950 |
|
|
| 1951 |
|
|
| 1952 |
|
|
| 1953 |
-- |
|
| 1954 |
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1955 |
-- |
|
| 1956 |
|
|
| 1957 |
|
|
| 1958 |
|
|
| 1959 |
|
|
| 1960 |
-- |
|
| 1961 |
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1962 |
-- |
|
| 1963 |
|
|
| 1964 |
CREATE TABLE plantusage ( |
|
| 1965 |
plantusage_id int(11) NOT NULL, |
|
| 1966 |
taxonconcept_id int(11) NOT NULL, |
|
| 1967 |
taxonstatus text, |
|
| 1968 |
taxon text, |
|
| 1969 |
classsystem text, |
|
| 1970 |
acceptedsynonym text, |
|
| 1971 |
party_id int(11), |
|
| 1972 |
plantstatus_id int(11), |
|
| 1973 |
usagestart timestamp NULL, |
|
| 1974 |
usagestop timestamp NULL |
|
| 1975 |
); |
|
| 1976 |
|
|
| 1977 |
|
|
| 1978 |
-- |
|
| 1979 |
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1980 |
-- |
|
| 1981 |
|
|
| 1982 |
|
|
| 1983 |
|
|
| 1984 |
|
|
| 1985 |
-- |
|
| 1986 |
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1987 |
-- |
|
| 1988 |
|
|
| 1989 |
|
|
| 1990 |
|
|
| 1991 |
|
|
| 1992 |
-- |
|
| 1993 | 1877 |
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1994 | 1878 |
-- |
| 1995 | 1879 |
|
| ... | ... | |
| 2496 | 2380 |
|
| 2497 | 2381 |
|
| 2498 | 2382 |
-- |
| 2383 |
-- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2384 |
-- |
|
| 2385 |
|
|
| 2386 |
CREATE TABLE taxoncorrelation ( |
|
| 2387 |
taxoncorrelation_id int(11) NOT NULL, |
|
| 2388 |
taxonstatus_id int(11) NOT NULL, |
|
| 2389 |
taxonconcept_id int(11) NOT NULL, |
|
| 2390 |
plantconvergence text NOT NULL, |
|
| 2391 |
correlationstart timestamp NOT NULL, |
|
| 2392 |
correlationstop timestamp NULL |
|
| 2393 |
); |
|
| 2394 |
|
|
| 2395 |
|
|
| 2396 |
-- |
|
| 2397 |
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2398 |
-- |
|
| 2399 |
|
|
| 2400 |
|
|
| 2401 |
|
|
| 2402 |
|
|
| 2403 |
-- |
|
| 2404 |
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2405 |
-- |
|
| 2406 |
|
|
| 2407 |
|
|
| 2408 |
|
|
| 2409 |
|
|
| 2410 |
-- |
|
| 2499 | 2411 |
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2500 | 2412 |
-- |
| 2501 | 2413 |
|
| ... | ... | |
| 2510 | 2422 |
|
| 2511 | 2423 |
|
| 2512 | 2424 |
-- |
| 2425 |
-- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2426 |
-- |
|
| 2427 |
|
|
| 2428 |
CREATE TABLE taxonlineage ( |
|
| 2429 |
taxonlineage_id int(11) NOT NULL, |
|
| 2430 |
childtaxonstatus_id int(11) NOT NULL, |
|
| 2431 |
parenttaxonstatus_id int(11) NOT NULL |
|
| 2432 |
); |
|
| 2433 |
|
|
| 2434 |
|
|
| 2435 |
-- |
|
| 2436 |
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2437 |
-- |
|
| 2438 |
|
|
| 2439 |
|
|
| 2440 |
|
|
| 2441 |
|
|
| 2442 |
-- |
|
| 2443 |
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2444 |
-- |
|
| 2445 |
|
|
| 2446 |
|
|
| 2447 |
|
|
| 2448 |
|
|
| 2449 |
-- |
|
| 2513 | 2450 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2514 | 2451 |
-- |
| 2515 | 2452 |
|
| ... | ... | |
| 2524 | 2461 |
|
| 2525 | 2462 |
|
| 2526 | 2463 |
-- |
| 2464 |
-- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2465 |
-- |
|
| 2466 |
|
|
| 2467 |
CREATE TABLE taxonstatus ( |
|
| 2468 |
taxonstatus_id int(11) NOT NULL, |
|
| 2469 |
taxonconcept_id int(11) NOT NULL, |
|
| 2470 |
party_id int(11), |
|
| 2471 |
taxonconceptstatus text DEFAULT 'undetermined' NOT NULL, |
|
| 2472 |
reference_id int(11), |
|
| 2473 |
plantpartycomments text, |
|
| 2474 |
startdate timestamp NULL, |
|
| 2475 |
stopdate timestamp NULL, |
|
| 2476 |
accessioncode text |
|
| 2477 |
); |
|
| 2478 |
|
|
| 2479 |
|
|
| 2480 |
-- |
|
| 2481 |
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2482 |
-- |
|
| 2483 |
|
|
| 2484 |
|
|
| 2485 |
|
|
| 2486 |
|
|
| 2487 |
-- |
|
| 2488 |
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2489 |
-- |
|
| 2490 |
|
|
| 2491 |
|
|
| 2492 |
|
|
| 2493 |
|
|
| 2494 |
-- |
|
| 2495 |
-- Name: taxonusage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2496 |
-- |
|
| 2497 |
|
|
| 2498 |
CREATE TABLE taxonusage ( |
|
| 2499 |
taxonusage_id int(11) NOT NULL, |
|
| 2500 |
taxonconcept_id int(11) NOT NULL, |
|
| 2501 |
taxonstatus text, |
|
| 2502 |
taxon text, |
|
| 2503 |
classsystem text, |
|
| 2504 |
acceptedsynonym text, |
|
| 2505 |
party_id int(11), |
|
| 2506 |
taxonstatus_id int(11), |
|
| 2507 |
usagestart timestamp NULL, |
|
| 2508 |
usagestop timestamp NULL |
|
| 2509 |
); |
|
| 2510 |
|
|
| 2511 |
|
|
| 2512 |
-- |
|
| 2513 |
-- Name: taxonusage_taxonusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2514 |
-- |
|
| 2515 |
|
|
| 2516 |
|
|
| 2517 |
|
|
| 2518 |
|
|
| 2519 |
-- |
|
| 2520 |
-- Name: taxonusage_taxonusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2521 |
-- |
|
| 2522 |
|
|
| 2523 |
|
|
| 2524 |
|
|
| 2525 |
|
|
| 2526 |
-- |
|
| 2527 | 2527 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2528 | 2528 |
-- |
| 2529 | 2529 |
|
| ... | ... | |
| 2854 | 2854 |
|
| 2855 | 2855 |
|
| 2856 | 2856 |
-- |
| 2857 |
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2857 |
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2858 | 2858 |
-- |
| 2859 | 2859 |
|
| 2860 | 2860 |
|
| 2861 | 2861 |
|
| 2862 | 2862 |
|
| 2863 | 2863 |
-- |
| 2864 |
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2864 |
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2865 | 2865 |
-- |
| 2866 | 2866 |
|
| 2867 | 2867 |
|
| 2868 | 2868 |
|
| 2869 | 2869 |
|
| 2870 | 2870 |
-- |
| 2871 |
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2871 |
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2872 | 2872 |
-- |
| 2873 | 2873 |
|
| 2874 | 2874 |
|
| 2875 | 2875 |
|
| 2876 | 2876 |
|
| 2877 | 2877 |
-- |
| 2878 |
-- Name: plantstatus_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2878 |
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2879 | 2879 |
-- |
| 2880 | 2880 |
|
| 2881 | 2881 |
|
| 2882 | 2882 |
|
| 2883 | 2883 |
|
| 2884 | 2884 |
-- |
| 2885 |
-- Name: plantusage_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2885 |
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2886 | 2886 |
-- |
| 2887 | 2887 |
|
| 2888 | 2888 |
|
| 2889 | 2889 |
|
| 2890 | 2890 |
|
| 2891 | 2891 |
-- |
| 2892 |
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2892 |
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2893 | 2893 |
-- |
| 2894 | 2894 |
|
| 2895 | 2895 |
|
| 2896 | 2896 |
|
| 2897 | 2897 |
|
| 2898 | 2898 |
-- |
| 2899 |
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2899 |
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2900 | 2900 |
-- |
| 2901 | 2901 |
|
| 2902 | 2902 |
|
| 2903 | 2903 |
|
| 2904 | 2904 |
|
| 2905 | 2905 |
-- |
| 2906 |
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2906 |
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2907 | 2907 |
-- |
| 2908 | 2908 |
|
| 2909 | 2909 |
|
| 2910 | 2910 |
|
| 2911 | 2911 |
|
| 2912 | 2912 |
-- |
| 2913 |
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2913 |
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2914 | 2914 |
-- |
| 2915 | 2915 |
|
| 2916 | 2916 |
|
| 2917 | 2917 |
|
| 2918 | 2918 |
|
| 2919 | 2919 |
-- |
| 2920 |
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2920 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2921 | 2921 |
-- |
| 2922 | 2922 |
|
| 2923 | 2923 |
|
| 2924 | 2924 |
|
| 2925 | 2925 |
|
| 2926 | 2926 |
-- |
| 2927 |
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2927 |
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2928 | 2928 |
-- |
| 2929 | 2929 |
|
| 2930 | 2930 |
|
| 2931 | 2931 |
|
| 2932 | 2932 |
|
| 2933 | 2933 |
-- |
| 2934 |
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2934 |
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2935 | 2935 |
-- |
| 2936 | 2936 |
|
| 2937 | 2937 |
|
| 2938 | 2938 |
|
| 2939 | 2939 |
|
| 2940 | 2940 |
-- |
| 2941 |
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2941 |
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2942 | 2942 |
-- |
| 2943 | 2943 |
|
| 2944 | 2944 |
|
| 2945 | 2945 |
|
| 2946 | 2946 |
|
| 2947 | 2947 |
-- |
| 2948 |
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2948 |
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2949 | 2949 |
-- |
| 2950 | 2950 |
|
| 2951 | 2951 |
|
| 2952 | 2952 |
|
| 2953 | 2953 |
|
| 2954 | 2954 |
-- |
| 2955 |
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2955 |
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2956 | 2956 |
-- |
| 2957 | 2957 |
|
| 2958 | 2958 |
|
| 2959 | 2959 |
|
| 2960 | 2960 |
|
| 2961 | 2961 |
-- |
| 2962 |
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2962 |
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2963 | 2963 |
-- |
| 2964 | 2964 |
|
| 2965 | 2965 |
|
| 2966 | 2966 |
|
| 2967 | 2967 |
|
| 2968 | 2968 |
-- |
| 2969 |
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2969 |
-- Name: taxonconcept_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2970 | 2970 |
-- |
| 2971 | 2971 |
|
| 2972 | 2972 |
|
| 2973 | 2973 |
|
| 2974 | 2974 |
|
| 2975 | 2975 |
-- |
| 2976 |
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2976 |
-- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2977 | 2977 |
-- |
| 2978 | 2978 |
|
| 2979 | 2979 |
|
| 2980 | 2980 |
|
| 2981 | 2981 |
|
| 2982 | 2982 |
-- |
| 2983 |
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2983 |
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2984 | 2984 |
-- |
| 2985 | 2985 |
|
| 2986 | 2986 |
|
| 2987 | 2987 |
|
| 2988 | 2988 |
|
| 2989 | 2989 |
-- |
| 2990 |
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2990 |
-- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2991 | 2991 |
-- |
| 2992 | 2992 |
|
| 2993 | 2993 |
|
| 2994 | 2994 |
|
| 2995 | 2995 |
|
| 2996 | 2996 |
-- |
| 2997 |
-- Name: taxonconcept_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2997 |
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2998 | 2998 |
-- |
| 2999 | 2999 |
|
| 3000 | 3000 |
|
| 3001 | 3001 |
|
| 3002 | 3002 |
|
| 3003 | 3003 |
-- |
| 3004 |
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3004 |
-- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3005 | 3005 |
-- |
| 3006 | 3006 |
|
| 3007 | 3007 |
|
| 3008 | 3008 |
|
| 3009 | 3009 |
|
| 3010 | 3010 |
-- |
| 3011 |
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3011 |
-- Name: taxonusage_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3012 | 3012 |
-- |
| 3013 | 3013 |
|
| 3014 | 3014 |
|
| ... | ... | |
| 3355 | 3355 |
|
| 3356 | 3356 |
|
| 3357 | 3357 |
-- |
| 3358 |
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3359 |
-- |
|
| 3360 |
|
|
| 3361 |
ALTER TABLE plantcorrelation |
|
| 3362 |
ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id); |
|
| 3363 |
|
|
| 3364 |
|
|
| 3365 |
-- |
|
| 3366 |
-- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3367 |
-- |
|
| 3368 |
|
|
| 3369 |
ALTER TABLE plantlineage |
|
| 3370 |
ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id); |
|
| 3371 |
|
|
| 3372 |
|
|
| 3373 |
-- |
|
| 3374 | 3358 |
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3375 | 3359 |
-- |
| 3376 | 3360 |
|
| ... | ... | |
| 3379 | 3363 |
|
| 3380 | 3364 |
|
| 3381 | 3365 |
-- |
| 3382 |
-- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3383 |
-- |
|
| 3384 |
|
|
| 3385 |
ALTER TABLE plantstatus |
|
| 3386 |
ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id); |
|
| 3387 |
|
|
| 3388 |
|
|
| 3389 |
-- |
|
| 3390 |
-- Name: plantstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3391 |
-- |
|
| 3392 |
|
|
| 3393 |
ALTER TABLE plantstatus |
|
| 3394 |
ADD CONSTRAINT plantstatus_unique UNIQUE (taxonconcept_id, party_id); |
|
| 3395 |
|
|
| 3396 |
|
|
| 3397 |
-- |
|
| 3398 |
-- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3399 |
-- |
|
| 3400 |
|
|
| 3401 |
ALTER TABLE plantusage |
|
| 3402 |
ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id); |
|
| 3403 |
|
|
| 3404 |
|
|
| 3405 |
-- |
|
| 3406 | 3366 |
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3407 | 3367 |
-- |
| 3408 | 3368 |
|
| ... | ... | |
| 3555 | 3515 |
|
| 3556 | 3516 |
|
| 3557 | 3517 |
-- |
| 3518 |
-- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3519 |
-- |
|
| 3520 |
|
|
| 3521 |
ALTER TABLE taxoncorrelation |
|
| 3522 |
ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id); |
|
| 3523 |
|
|
| 3524 |
|
|
| 3525 |
-- |
|
| 3558 | 3526 |
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3559 | 3527 |
-- |
| 3560 | 3528 |
|
| ... | ... | |
| 3563 | 3531 |
|
| 3564 | 3532 |
|
| 3565 | 3533 |
-- |
| 3534 |
-- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3535 |
-- |
|
| 3536 |
|
|
| 3537 |
ALTER TABLE taxonlineage |
|
| 3538 |
ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id); |
|
| 3539 |
|
|
| 3540 |
|
|
| 3541 |
-- |
|
| 3566 | 3542 |
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3567 | 3543 |
-- |
| 3568 | 3544 |
|
| ... | ... | |
| 3571 | 3547 |
|
| 3572 | 3548 |
|
| 3573 | 3549 |
-- |
| 3550 |
-- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3551 |
-- |
|
| 3552 |
|
|
| 3553 |
ALTER TABLE taxonstatus |
|
| 3554 |
ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id); |
|
| 3555 |
|
|
| 3556 |
|
|
| 3557 |
-- |
|
| 3558 |
-- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3559 |
-- |
|
| 3560 |
|
|
| 3561 |
ALTER TABLE taxonstatus |
|
| 3562 |
ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonconcept_id, party_id); |
|
| 3563 |
|
|
| 3564 |
|
|
| 3565 |
-- |
|
| 3566 |
-- Name: taxonusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3567 |
-- |
|
| 3568 |
|
|
| 3569 |
ALTER TABLE taxonusage |
|
| 3570 |
ADD CONSTRAINT taxonusage_pkey PRIMARY KEY (taxonusage_id); |
|
| 3571 |
|
|
| 3572 |
|
|
| 3573 |
-- |
|
| 3574 | 3574 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3575 | 3575 |
-- |
| 3576 | 3576 |
|
| ... | ... | |
| 3864 | 3864 |
|
| 3865 | 3865 |
|
| 3866 | 3866 |
-- |
| 3867 |
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3868 |
-- |
|
| 3869 |
|
|
| 3870 |
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus (accessioncode); |
|
| 3871 |
|
|
| 3872 |
|
|
| 3873 |
-- |
|
| 3874 | 3867 |
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3875 | 3868 |
-- |
| 3876 | 3869 |
|
| ... | ... | |
| 4039 | 4032 |
|
| 4040 | 4033 |
|
| 4041 | 4034 |
-- |
| 4035 |
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4036 |
-- |
|
| 4037 |
|
|
| 4038 |
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus (accessioncode); |
|
| 4039 |
|
|
| 4040 |
|
|
| 4041 |
-- |
|
| 4042 | 4042 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4043 | 4043 |
-- |
| 4044 | 4044 |
|
| ... | ... | |
| 4649 | 4649 |
|
| 4650 | 4650 |
|
| 4651 | 4651 |
-- |
| 4652 |
-- Name: plantcorrelation_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4653 |
-- |
|
| 4654 |
|
|
| 4655 |
ALTER TABLE plantcorrelation |
|
| 4656 |
ADD CONSTRAINT plantcorrelation_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4657 |
|
|
| 4658 |
|
|
| 4659 |
-- |
|
| 4660 |
-- Name: plantcorrelation_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4661 |
-- |
|
| 4662 |
|
|
| 4663 |
|
|
| 4664 |
|
|
| 4665 |
|
|
| 4666 |
-- |
|
| 4667 |
-- Name: plantlineage_childplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4668 |
-- |
|
| 4669 |
|
|
| 4670 |
ALTER TABLE plantlineage |
|
| 4671 |
ADD CONSTRAINT plantlineage_childplantstatus_id_fkey FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4672 |
|
|
| 4673 |
|
|
| 4674 |
-- |
|
| 4675 |
-- Name: plantlineage_parentplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4676 |
-- |
|
| 4677 |
|
|
| 4678 |
ALTER TABLE plantlineage |
|
| 4679 |
ADD CONSTRAINT plantlineage_parentplantstatus_id_fkey FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4680 |
|
|
| 4681 |
|
|
| 4682 |
-- |
|
| 4683 | 4652 |
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4684 | 4653 |
-- |
| 4685 | 4654 |
|
| ... | ... | |
| 4703 | 4672 |
|
| 4704 | 4673 |
|
| 4705 | 4674 |
-- |
| 4706 |
-- Name: plantstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4707 |
-- |
|
| 4708 |
|
|
| 4709 |
|
|
| 4710 |
|
|
| 4711 |
|
|
| 4712 |
-- |
|
| 4713 |
-- Name: plantstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4714 |
-- |
|
| 4715 |
|
|
| 4716 |
|
|
| 4717 |
|
|
| 4718 |
|
|
| 4719 |
-- |
|
| 4720 |
-- Name: plantstatus_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4721 |
-- |
|
| 4722 |
|
|
| 4723 |
ALTER TABLE plantstatus |
|
| 4724 |
ADD CONSTRAINT plantstatus_taxonconcept_id_fkey FOREIGN KEY (taxonconcept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4725 |
|
|
| 4726 |
|
|
| 4727 |
-- |
|
| 4728 |
-- Name: plantusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4729 |
-- |
|
| 4730 |
|
|
| 4731 |
|
|
| 4732 |
|
|
| 4733 |
|
|
| 4734 |
-- |
|
| 4735 |
-- Name: plantusage_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4736 |
-- |
|
| 4737 |
|
|
| 4738 |
ALTER TABLE plantusage |
|
| 4739 |
ADD CONSTRAINT plantusage_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4740 |
|
|
| 4741 |
|
|
| 4742 |
-- |
|
| 4743 |
-- Name: plantusage_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4744 |
-- |
|
| 4745 |
|
|
| 4746 |
|
|
| 4747 |
|
|
| 4748 |
|
|
| 4749 |
-- |
|
| 4750 | 4675 |
-- Name: project_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4751 | 4676 |
-- |
| 4752 | 4677 |
|
| ... | ... | |
| 4948 | 4873 |
|
| 4949 | 4874 |
|
| 4950 | 4875 |
-- |
| 4876 |
-- Name: taxoncorrelation_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4877 |
-- |
|
| 4878 |
|
|
| 4879 |
|
|
| 4880 |
|
|
| 4881 |
|
|
| 4882 |
-- |
|
| 4883 |
-- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4884 |
-- |
|
| 4885 |
|
|
| 4886 |
ALTER TABLE taxoncorrelation |
|
| 4887 |
ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4888 |
|
|
| 4889 |
|
|
| 4890 |
-- |
|
| 4951 | 4891 |
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4952 | 4892 |
-- |
| 4953 | 4893 |
|
| ... | ... | |
| 4978 | 4918 |
|
| 4979 | 4919 |
|
| 4980 | 4920 |
-- |
| 4921 |
-- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4922 |
-- |
|
| 4923 |
|
|
| 4924 |
ALTER TABLE taxonlineage |
|
| 4925 |
ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4926 |
|
|
| 4927 |
|
|
| 4928 |
-- |
|
| 4929 |
-- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4930 |
-- |
|
| 4931 |
|
|
| 4932 |
ALTER TABLE taxonlineage |
|
| 4933 |
ADD CONSTRAINT taxonlineage_parenttaxonstatus_id_fkey FOREIGN KEY (parenttaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4934 |
|
|
| 4935 |
|
|
| 4936 |
-- |
|
| 4981 | 4937 |
-- Name: taxonoccurrence_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4982 | 4938 |
-- |
| 4983 | 4939 |
|
| ... | ... | |
| 4993 | 4949 |
|
| 4994 | 4950 |
|
| 4995 | 4951 |
-- |
| 4952 |
-- Name: taxonstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4953 |
-- |
|
| 4954 |
|
|
| 4955 |
|
|
| 4956 |
|
|
| 4957 |
|
|
| 4958 |
-- |
|
| 4959 |
-- Name: taxonstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4960 |
-- |
|
| 4961 |
|
|
| 4962 |
|
|
| 4963 |
|
|
| 4964 |
|
|
| 4965 |
-- |
|
| 4966 |
-- Name: taxonstatus_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4967 |
-- |
|
| 4968 |
|
|
| 4969 |
ALTER TABLE taxonstatus |
|
| 4970 |
ADD CONSTRAINT taxonstatus_taxonconcept_id_fkey FOREIGN KEY (taxonconcept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4971 |
|
|
| 4972 |
|
|
| 4973 |
-- |
|
| 4974 |
-- Name: taxonusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4975 |
-- |
|
| 4976 |
|
|
| 4977 |
|
|
| 4978 |
|
|
| 4979 |
|
|
| 4980 |
-- |
|
| 4981 |
-- Name: taxonusage_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4982 |
-- |
|
| 4983 |
|
|
| 4984 |
|
|
| 4985 |
|
|
| 4986 |
|
|
| 4987 |
-- |
|
| 4988 |
-- Name: taxonusage_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4989 |
-- |
|
| 4990 |
|
|
| 4991 |
ALTER TABLE taxonusage |
|
| 4992 |
ADD CONSTRAINT taxonusage_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4993 |
|
|
| 4994 |
|
|
| 4995 |
-- |
|
| 4996 | 4996 |
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4997 | 4997 |
-- |
| 4998 | 4998 |
|
| schemas/filter_ERD.csv | ||
|---|---|---|
| 1 | 1 |
"PostgreSQL","MySQL","Comments" |
| 2 | 2 |
,,"fkeys to heavily-linked tables" |
| 3 | 3 |
"^ALTER TABLE (?:commclass)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES \b[^;]*;",,outward |
| 4 |
"^ALTER TABLE (?!plantstatus)(?:plant\w+)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonconcept\b[^;]*;",,inward
|
|
| 4 |
"^ALTER TABLE (?:taxoncorrelation|taxonlineage|taxonusage)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonconcept\b[^;]*;",,inward
|
|
| 5 | 5 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES coverindex\b[^;]*;",,inward |
| 6 | 6 |
"^ALTER TABLE (?!method)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES method\b[^;]*;",,inward |
| 7 | 7 |
"^ALTER TABLE (?!party|address|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward |
| schemas/vegbien.sql | ||
|---|---|---|
| 2370 | 2370 |
|
| 2371 | 2371 |
|
| 2372 | 2372 |
-- |
| 2373 |
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2374 |
-- |
|
| 2375 |
|
|
| 2376 |
CREATE TABLE plantcorrelation ( |
|
| 2377 |
plantcorrelation_id integer NOT NULL, |
|
| 2378 |
plantstatus_id integer NOT NULL, |
|
| 2379 |
taxonconcept_id integer NOT NULL, |
|
| 2380 |
plantconvergence text NOT NULL, |
|
| 2381 |
correlationstart timestamp with time zone NOT NULL, |
|
| 2382 |
correlationstop timestamp with time zone |
|
| 2383 |
); |
|
| 2384 |
|
|
| 2385 |
|
|
| 2386 |
-- |
|
| 2387 |
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2388 |
-- |
|
| 2389 |
|
|
| 2390 |
CREATE SEQUENCE plantcorrelation_plantcorrelation_id_seq |
|
| 2391 |
START WITH 1 |
|
| 2392 |
INCREMENT BY 1 |
|
| 2393 |
NO MINVALUE |
|
| 2394 |
NO MAXVALUE |
|
| 2395 |
CACHE 1; |
|
| 2396 |
|
|
| 2397 |
|
|
| 2398 |
-- |
|
| 2399 |
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2400 |
-- |
|
| 2401 |
|
|
| 2402 |
ALTER SEQUENCE plantcorrelation_plantcorrelation_id_seq OWNED BY plantcorrelation.plantcorrelation_id; |
|
| 2403 |
|
|
| 2404 |
|
|
| 2405 |
-- |
|
| 2406 |
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2407 |
-- |
|
| 2408 |
|
|
| 2409 |
CREATE TABLE plantlineage ( |
|
| 2410 |
plantlineage_id integer NOT NULL, |
|
| 2411 |
childplantstatus_id integer NOT NULL, |
|
| 2412 |
parentplantstatus_id integer NOT NULL |
|
| 2413 |
); |
|
| 2414 |
|
|
| 2415 |
|
|
| 2416 |
-- |
|
| 2417 |
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2418 |
-- |
|
| 2419 |
|
|
| 2420 |
CREATE SEQUENCE plantlineage_plantlineage_id_seq |
|
| 2421 |
START WITH 1 |
|
| 2422 |
INCREMENT BY 1 |
|
| 2423 |
NO MINVALUE |
|
| 2424 |
NO MAXVALUE |
|
| 2425 |
CACHE 1; |
|
| 2426 |
|
|
| 2427 |
|
|
| 2428 |
-- |
|
| 2429 |
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2430 |
-- |
|
| 2431 |
|
|
| 2432 |
ALTER SEQUENCE plantlineage_plantlineage_id_seq OWNED BY plantlineage.plantlineage_id; |
|
| 2433 |
|
|
| 2434 |
|
|
| 2435 |
-- |
|
| 2436 | 2373 |
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2437 | 2374 |
-- |
| 2438 | 2375 |
|
| ... | ... | |
| 2452 | 2389 |
|
| 2453 | 2390 |
|
| 2454 | 2391 |
-- |
| 2455 |
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2456 |
-- |
|
| 2457 |
|
|
| 2458 |
CREATE TABLE plantstatus ( |
|
| 2459 |
plantstatus_id integer NOT NULL, |
|
| 2460 |
taxonconcept_id integer NOT NULL, |
|
| 2461 |
party_id integer, |
|
| 2462 |
taxonconceptstatus text DEFAULT 'undetermined'::text NOT NULL, |
|
| 2463 |
reference_id integer, |
|
| 2464 |
plantpartycomments text, |
|
| 2465 |
startdate timestamp with time zone, |
|
| 2466 |
stopdate timestamp with time zone, |
|
| 2467 |
accessioncode text |
|
| 2468 |
); |
|
| 2469 |
|
|
| 2470 |
|
|
| 2471 |
-- |
|
| 2472 |
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2473 |
-- |
|
| 2474 |
|
|
| 2475 |
CREATE SEQUENCE plantstatus_plantstatus_id_seq |
|
| 2476 |
START WITH 1 |
|
| 2477 |
INCREMENT BY 1 |
|
| 2478 |
NO MINVALUE |
|
| 2479 |
NO MAXVALUE |
|
| 2480 |
CACHE 1; |
|
| 2481 |
|
|
| 2482 |
|
|
| 2483 |
-- |
|
| 2484 |
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2485 |
-- |
|
| 2486 |
|
|
| 2487 |
ALTER SEQUENCE plantstatus_plantstatus_id_seq OWNED BY plantstatus.plantstatus_id; |
|
| 2488 |
|
|
| 2489 |
|
|
| 2490 |
-- |
|
| 2491 |
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2492 |
-- |
|
| 2493 |
|
|
| 2494 |
CREATE TABLE plantusage ( |
|
| 2495 |
plantusage_id integer NOT NULL, |
|
| 2496 |
taxonconcept_id integer NOT NULL, |
|
| 2497 |
taxonstatus text, |
|
| 2498 |
taxon text, |
|
| 2499 |
classsystem text, |
|
| 2500 |
acceptedsynonym text, |
|
| 2501 |
party_id integer, |
|
| 2502 |
plantstatus_id integer, |
|
| 2503 |
usagestart timestamp with time zone, |
|
| 2504 |
usagestop timestamp with time zone |
|
| 2505 |
); |
|
| 2506 |
|
|
| 2507 |
|
|
| 2508 |
-- |
|
| 2509 |
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2510 |
-- |
|
| 2511 |
|
|
| 2512 |
CREATE SEQUENCE plantusage_plantusage_id_seq |
|
| 2513 |
START WITH 1 |
|
| 2514 |
INCREMENT BY 1 |
|
| 2515 |
NO MINVALUE |
|
| 2516 |
NO MAXVALUE |
|
| 2517 |
CACHE 1; |
|
| 2518 |
|
|
| 2519 |
|
|
| 2520 |
-- |
|
| 2521 |
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2522 |
-- |
|
| 2523 |
|
|
| 2524 |
ALTER SEQUENCE plantusage_plantusage_id_seq OWNED BY plantusage.plantusage_id; |
|
| 2525 |
|
|
| 2526 |
|
|
| 2527 |
-- |
|
| 2528 | 2392 |
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2529 | 2393 |
-- |
| 2530 | 2394 |
|
| ... | ... | |
| 3112 | 2976 |
|
| 3113 | 2977 |
|
| 3114 | 2978 |
-- |
| 2979 |
-- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2980 |
-- |
|
| 2981 |
|
|
| 2982 |
CREATE TABLE taxoncorrelation ( |
|
| 2983 |
taxoncorrelation_id integer NOT NULL, |
|
| 2984 |
taxonstatus_id integer NOT NULL, |
|
| 2985 |
taxonconcept_id integer NOT NULL, |
|
| 2986 |
plantconvergence text NOT NULL, |
|
| 2987 |
correlationstart timestamp with time zone NOT NULL, |
|
| 2988 |
correlationstop timestamp with time zone |
|
| 2989 |
); |
|
| 2990 |
|
|
| 2991 |
|
|
| 2992 |
-- |
|
| 2993 |
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2994 |
-- |
|
| 2995 |
|
|
| 2996 |
CREATE SEQUENCE taxoncorrelation_taxoncorrelation_id_seq |
|
| 2997 |
START WITH 1 |
|
| 2998 |
INCREMENT BY 1 |
|
| 2999 |
NO MINVALUE |
|
| 3000 |
NO MAXVALUE |
|
| 3001 |
CACHE 1; |
|
| 3002 |
|
|
| 3003 |
|
|
| 3004 |
-- |
|
| 3005 |
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3006 |
-- |
|
| 3007 |
|
|
| 3008 |
ALTER SEQUENCE taxoncorrelation_taxoncorrelation_id_seq OWNED BY taxoncorrelation.taxoncorrelation_id; |
|
| 3009 |
|
|
| 3010 |
|
|
| 3011 |
-- |
|
| 3115 | 3012 |
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 3116 | 3013 |
-- |
| 3117 | 3014 |
|
| ... | ... | |
| 3131 | 3028 |
|
| 3132 | 3029 |
|
| 3133 | 3030 |
-- |
| 3031 |
-- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3032 |
-- |
|
| 3033 |
|
|
| 3034 |
CREATE TABLE taxonlineage ( |
|
| 3035 |
taxonlineage_id integer NOT NULL, |
|
| 3036 |
childtaxonstatus_id integer NOT NULL, |
|
| 3037 |
parenttaxonstatus_id integer NOT NULL |
|
| 3038 |
); |
|
| 3039 |
|
|
| 3040 |
|
|
| 3041 |
-- |
|
| 3042 |
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3043 |
-- |
|
| 3044 |
|
|
| 3045 |
CREATE SEQUENCE taxonlineage_taxonlineage_id_seq |
|
| 3046 |
START WITH 1 |
|
| 3047 |
INCREMENT BY 1 |
|
| 3048 |
NO MINVALUE |
|
| 3049 |
NO MAXVALUE |
|
| 3050 |
CACHE 1; |
|
| 3051 |
|
|
| 3052 |
|
|
| 3053 |
-- |
|
| 3054 |
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3055 |
-- |
|
| 3056 |
|
|
| 3057 |
ALTER SEQUENCE taxonlineage_taxonlineage_id_seq OWNED BY taxonlineage.taxonlineage_id; |
|
| 3058 |
|
|
| 3059 |
|
|
| 3060 |
-- |
|
| 3134 | 3061 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 3135 | 3062 |
-- |
| 3136 | 3063 |
|
| ... | ... | |
| 3150 | 3077 |
|
| 3151 | 3078 |
|
| 3152 | 3079 |
-- |
| 3080 |
-- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3081 |
-- |
|
| 3082 |
|
|
| 3083 |
CREATE TABLE taxonstatus ( |
|
| 3084 |
taxonstatus_id integer NOT NULL, |
|
| 3085 |
taxonconcept_id integer NOT NULL, |
|
| 3086 |
party_id integer, |
|
| 3087 |
taxonconceptstatus text DEFAULT 'undetermined'::text NOT NULL, |
|
| 3088 |
reference_id integer, |
|
| 3089 |
plantpartycomments text, |
|
| 3090 |
startdate timestamp with time zone, |
|
| 3091 |
stopdate timestamp with time zone, |
|
| 3092 |
accessioncode text |
|
| 3093 |
); |
|
| 3094 |
|
|
| 3095 |
|
|
| 3096 |
-- |
|
| 3097 |
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3098 |
-- |
|
| 3099 |
|
|
| 3100 |
CREATE SEQUENCE taxonstatus_taxonstatus_id_seq |
|
| 3101 |
START WITH 1 |
|
| 3102 |
INCREMENT BY 1 |
|
| 3103 |
NO MINVALUE |
|
| 3104 |
NO MAXVALUE |
|
| 3105 |
CACHE 1; |
|
| 3106 |
|
|
| 3107 |
|
|
| 3108 |
-- |
|
| 3109 |
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3110 |
-- |
|
| 3111 |
|
|
| 3112 |
ALTER SEQUENCE taxonstatus_taxonstatus_id_seq OWNED BY taxonstatus.taxonstatus_id; |
|
| 3113 |
|
|
| 3114 |
|
|
| 3115 |
-- |
|
| 3116 |
-- Name: taxonusage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3117 |
-- |
|
| 3118 |
|
|
| 3119 |
CREATE TABLE taxonusage ( |
|
| 3120 |
taxonusage_id integer NOT NULL, |
|
| 3121 |
taxonconcept_id integer NOT NULL, |
|
| 3122 |
taxonstatus text, |
|
| 3123 |
taxon text, |
|
| 3124 |
classsystem text, |
|
| 3125 |
acceptedsynonym text, |
|
| 3126 |
party_id integer, |
|
| 3127 |
taxonstatus_id integer, |
|
| 3128 |
usagestart timestamp with time zone, |
|
| 3129 |
usagestop timestamp with time zone |
|
| 3130 |
); |
|
| 3131 |
|
|
| 3132 |
|
|
| 3133 |
-- |
|
| 3134 |
-- Name: taxonusage_taxonusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3135 |
-- |
|
| 3136 |
|
|
| 3137 |
CREATE SEQUENCE taxonusage_taxonusage_id_seq |
|
| 3138 |
START WITH 1 |
|
| 3139 |
INCREMENT BY 1 |
|
| 3140 |
NO MINVALUE |
|
| 3141 |
NO MAXVALUE |
|
| 3142 |
CACHE 1; |
|
| 3143 |
|
|
| 3144 |
|
|
| 3145 |
-- |
|
| 3146 |
-- Name: taxonusage_taxonusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3147 |
-- |
|
| 3148 |
|
|
| 3149 |
ALTER SEQUENCE taxonusage_taxonusage_id_seq OWNED BY taxonusage.taxonusage_id; |
|
| 3150 |
|
|
| 3151 |
|
|
| 3152 |
-- |
|
| 3153 | 3153 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3154 | 3154 |
-- |
| 3155 | 3155 |
|
| ... | ... | |
| 3500 | 3500 |
|
| 3501 | 3501 |
|
| 3502 | 3502 |
-- |
| 3503 |
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3504 |
-- |
|
| 3505 |
|
|
| 3506 |
ALTER TABLE plantcorrelation ALTER COLUMN plantcorrelation_id SET DEFAULT nextval('plantcorrelation_plantcorrelation_id_seq'::regclass);
|
|
| 3507 |
|
|
| 3508 |
|
|
| 3509 |
-- |
|
| 3510 |
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3511 |
-- |
|
| 3512 |
|
|
| 3513 |
ALTER TABLE plantlineage ALTER COLUMN plantlineage_id SET DEFAULT nextval('plantlineage_plantlineage_id_seq'::regclass);
|
|
| 3514 |
|
|
| 3515 |
|
|
| 3516 |
-- |
|
| 3517 | 3503 |
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: - |
| 3518 | 3504 |
-- |
| 3519 | 3505 |
|
| ... | ... | |
| 3521 | 3507 |
|
| 3522 | 3508 |
|
| 3523 | 3509 |
-- |
| 3524 |
-- Name: plantstatus_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3525 |
-- |
|
| 3526 |
|
|
| 3527 |
ALTER TABLE plantstatus ALTER COLUMN plantstatus_id SET DEFAULT nextval('plantstatus_plantstatus_id_seq'::regclass);
|
|
| 3528 |
|
|
| 3529 |
|
|
| 3530 |
-- |
|
| 3531 |
-- Name: plantusage_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3532 |
-- |
|
| 3533 |
|
|
| 3534 |
ALTER TABLE plantusage ALTER COLUMN plantusage_id SET DEFAULT nextval('plantusage_plantusage_id_seq'::regclass);
|
|
| 3535 |
|
|
| 3536 |
|
|
| 3537 |
-- |
|
| 3538 | 3510 |
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: - |
| 3539 | 3511 |
-- |
| 3540 | 3512 |
|
| ... | ... | |
| 3647 | 3619 |
|
| 3648 | 3620 |
|
| 3649 | 3621 |
-- |
| 3622 |
-- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3623 |
-- |
|
| 3624 |
|
|
| 3625 |
ALTER TABLE taxoncorrelation ALTER COLUMN taxoncorrelation_id SET DEFAULT nextval('taxoncorrelation_taxoncorrelation_id_seq'::regclass);
|
|
| 3626 |
|
|
| 3627 |
|
|
| 3628 |
-- |
|
| 3650 | 3629 |
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: - |
| 3651 | 3630 |
-- |
| 3652 | 3631 |
|
| ... | ... | |
| 3654 | 3633 |
|
| 3655 | 3634 |
|
| 3656 | 3635 |
-- |
| 3636 |
-- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3637 |
-- |
|
| 3638 |
|
|
| 3639 |
ALTER TABLE taxonlineage ALTER COLUMN taxonlineage_id SET DEFAULT nextval('taxonlineage_taxonlineage_id_seq'::regclass);
|
|
| 3640 |
|
|
| 3641 |
|
|
| 3642 |
-- |
|
| 3657 | 3643 |
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: - |
| 3658 | 3644 |
-- |
| 3659 | 3645 |
|
| ... | ... | |
| 3661 | 3647 |
|
| 3662 | 3648 |
|
| 3663 | 3649 |
-- |
| 3650 |
-- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3651 |
-- |
|
| 3652 |
|
|
| 3653 |
ALTER TABLE taxonstatus ALTER COLUMN taxonstatus_id SET DEFAULT nextval('taxonstatus_taxonstatus_id_seq'::regclass);
|
|
| 3654 |
|
|
| 3655 |
|
|
| 3656 |
-- |
|
| 3657 |
-- Name: taxonusage_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3658 |
-- |
|
| 3659 |
|
|
| 3660 |
ALTER TABLE taxonusage ALTER COLUMN taxonusage_id SET DEFAULT nextval('taxonusage_taxonusage_id_seq'::regclass);
|
|
| 3661 |
|
|
| 3662 |
|
|
| 3663 |
-- |
|
| 3664 | 3664 |
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: - |
| 3665 | 3665 |
-- |
| 3666 | 3666 |
|
| ... | ... | |
| 4001 | 4001 |
|
| 4002 | 4002 |
|
| 4003 | 4003 |
-- |
| 4004 |
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4005 |
-- |
|
| 4006 |
|
|
| 4007 |
ALTER TABLE ONLY plantcorrelation |
|
| 4008 |
ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id); |
|
| 4009 |
|
|
| 4010 |
|
|
| 4011 |
-- |
|
| 4012 |
-- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4013 |
-- |
|
| 4014 |
|
|
| 4015 |
ALTER TABLE ONLY plantlineage |
|
| 4016 |
ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id); |
|
| 4017 |
|
|
| 4018 |
|
|
| 4019 |
-- |
|
| 4020 | 4004 |
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4021 | 4005 |
-- |
| 4022 | 4006 |
|
| ... | ... | |
| 4025 | 4009 |
|
| 4026 | 4010 |
|
| 4027 | 4011 |
-- |
| 4028 |
-- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4029 |
-- |
|
| 4030 |
|
|
| 4031 |
ALTER TABLE ONLY plantstatus |
|
| 4032 |
ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id); |
|
| 4033 |
|
|
| 4034 |
|
|
| 4035 |
-- |
|
| 4036 |
-- Name: plantstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4037 |
-- |
|
| 4038 |
|
|
| 4039 |
ALTER TABLE ONLY plantstatus |
|
| 4040 |
ADD CONSTRAINT plantstatus_unique UNIQUE (taxonconcept_id, party_id); |
|
| 4041 |
|
|
| 4042 |
|
|
| 4043 |
-- |
|
| 4044 |
-- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4045 |
-- |
|
| 4046 |
|
|
| 4047 |
ALTER TABLE ONLY plantusage |
|
| 4048 |
ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id); |
|
| 4049 |
|
|
| 4050 |
|
|
| 4051 |
-- |
|
| 4052 | 4012 |
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4053 | 4013 |
-- |
| 4054 | 4014 |
|
| ... | ... | |
| 4201 | 4161 |
|
| 4202 | 4162 |
|
| 4203 | 4163 |
-- |
| 4164 |
-- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4165 |
-- |
|
| 4166 |
|
|
| 4167 |
ALTER TABLE ONLY taxoncorrelation |
|
| 4168 |
ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id); |
|
| 4169 |
|
|
| 4170 |
|
|
| 4171 |
-- |
|
| 4204 | 4172 |
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4205 | 4173 |
-- |
| 4206 | 4174 |
|
| ... | ... | |
| 4209 | 4177 |
|
| 4210 | 4178 |
|
| 4211 | 4179 |
-- |
| 4180 |
-- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4181 |
-- |
|
| 4182 |
|
|
| 4183 |
ALTER TABLE ONLY taxonlineage |
|
| 4184 |
ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id); |
|
| 4185 |
|
|
| 4186 |
|
|
| 4187 |
-- |
|
| 4212 | 4188 |
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4213 | 4189 |
-- |
| 4214 | 4190 |
|
| ... | ... | |
| 4217 | 4193 |
|
| 4218 | 4194 |
|
| 4219 | 4195 |
-- |
| 4196 |
-- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4197 |
-- |
|
| 4198 |
|
|
| 4199 |
ALTER TABLE ONLY taxonstatus |
|
| 4200 |
ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id); |
|
| 4201 |
|
|
| 4202 |
|
|
| 4203 |
-- |
|
| 4204 |
-- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4205 |
-- |
|
| 4206 |
|
|
| 4207 |
ALTER TABLE ONLY taxonstatus |
|
| 4208 |
ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonconcept_id, party_id); |
|
| 4209 |
|
|
| 4210 |
|
|
| 4211 |
-- |
|
| 4212 |
-- Name: taxonusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4213 |
-- |
|
| 4214 |
|
|
| 4215 |
ALTER TABLE ONLY taxonusage |
|
| 4216 |
ADD CONSTRAINT taxonusage_pkey PRIMARY KEY (taxonusage_id); |
|
| 4217 |
|
|
| 4218 |
|
|
| 4219 |
-- |
|
| 4220 | 4220 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4221 | 4221 |
-- |
| 4222 | 4222 |
|
| ... | ... | |
| 4510 | 4510 |
|
| 4511 | 4511 |
|
| 4512 | 4512 |
-- |
| 4513 |
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4514 |
-- |
|
| 4515 |
|
|
| 4516 |
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus USING btree (accessioncode); |
|
| 4517 |
|
|
| 4518 |
|
|
| 4519 |
-- |
|
| 4520 | 4513 |
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4521 | 4514 |
-- |
| 4522 | 4515 |
|
| ... | ... | |
| 4685 | 4678 |
|
| 4686 | 4679 |
|
| 4687 | 4680 |
-- |
| 4681 |
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4682 |
-- |
|
| 4683 |
|
|
| 4684 |
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus USING btree (accessioncode); |
|
| 4685 |
|
|
| 4686 |
|
|
| 4687 |
-- |
|
| 4688 | 4688 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4689 | 4689 |
-- |
| 4690 | 4690 |
|
| ... | ... | |
| 5318 | 5318 |
|
| 5319 | 5319 |
|
| 5320 | 5320 |
-- |
| 5321 |
-- Name: plantcorrelation_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5322 |
-- |
|
| 5323 |
|
|
| 5324 |
ALTER TABLE ONLY plantcorrelation |
|
| 5325 |
ADD CONSTRAINT plantcorrelation_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5326 |
|
|
| 5327 |
|
|
| 5328 |
-- |
|
| 5329 |
-- Name: plantcorrelation_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5330 |
-- |
|
| 5331 |
|
|
| 5332 |
ALTER TABLE ONLY plantcorrelation |
|
| 5333 |
ADD CONSTRAINT plantcorrelation_taxonconcept_id_fkey FOREIGN KEY (taxonconcept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5334 |
|
|
| 5335 |
|
|
| 5336 |
-- |
|
| 5337 |
-- Name: plantlineage_childplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5338 |
-- |
|
| 5339 |
|
|
| 5340 |
ALTER TABLE ONLY plantlineage |
|
| 5341 |
ADD CONSTRAINT plantlineage_childplantstatus_id_fkey FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5342 |
|
|
| 5343 |
|
|
| 5344 |
-- |
|
| 5345 |
-- Name: plantlineage_parentplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5346 |
-- |
|
| 5347 |
|
|
| 5348 |
ALTER TABLE ONLY plantlineage |
|
| 5349 |
ADD CONSTRAINT plantlineage_parentplantstatus_id_fkey FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5350 |
|
|
| 5351 |
|
|
| 5352 |
-- |
|
| 5353 | 5321 |
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5354 | 5322 |
-- |
| 5355 | 5323 |
|
| ... | ... | |
| 5374 | 5342 |
|
| 5375 | 5343 |
|
| 5376 | 5344 |
-- |
| 5377 |
-- Name: plantstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5378 |
-- |
|
| 5379 |
|
|
| 5380 |
ALTER TABLE ONLY plantstatus |
|
| 5381 |
ADD CONSTRAINT plantstatus_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5382 |
|
|
| 5383 |
|
|
| 5384 |
-- |
|
| 5385 |
-- Name: plantstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5386 |
-- |
|
| 5387 |
|
|
| 5388 |
ALTER TABLE ONLY plantstatus |
|
| 5389 |
ADD CONSTRAINT plantstatus_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5390 |
|
|
| 5391 |
|
|
| 5392 |
-- |
|
| 5393 |
-- Name: plantstatus_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5394 |
-- |
|
| 5395 |
|
|
| 5396 |
ALTER TABLE ONLY plantstatus |
|
| 5397 |
ADD CONSTRAINT plantstatus_taxonconcept_id_fkey FOREIGN KEY (taxonconcept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5398 |
|
|
| 5399 |
|
|
| 5400 |
-- |
|
| 5401 |
-- Name: plantusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5402 |
-- |
|
| 5403 |
|
|
| 5404 |
ALTER TABLE ONLY plantusage |
|
| 5405 |
ADD CONSTRAINT plantusage_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5406 |
|
|
| 5407 |
|
|
| 5408 |
-- |
|
| 5409 |
-- Name: plantusage_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5410 |
-- |
|
| 5411 |
|
|
| 5412 |
ALTER TABLE ONLY plantusage |
|
| 5413 |
ADD CONSTRAINT plantusage_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5414 |
|
|
| 5415 |
|
|
| 5416 |
-- |
|
| 5417 |
-- Name: plantusage_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5418 |
-- |
|
| 5419 |
|
|
| 5420 |
ALTER TABLE ONLY plantusage |
|
| 5421 |
ADD CONSTRAINT plantusage_taxonconcept_id_fkey FOREIGN KEY (taxonconcept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5422 |
|
|
| 5423 |
|
|
| 5424 |
-- |
|
| 5425 | 5345 |
-- Name: project_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5426 | 5346 |
-- |
| 5427 | 5347 |
|
| ... | ... | |
| 5630 | 5550 |
|
| 5631 | 5551 |
|
| 5632 | 5552 |
-- |
| 5553 |
-- Name: taxoncorrelation_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5554 |
-- |
|
| 5555 |
|
|
| 5556 |
ALTER TABLE ONLY taxoncorrelation |
|
| 5557 |
ADD CONSTRAINT taxoncorrelation_taxonconcept_id_fkey FOREIGN KEY (taxonconcept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5558 |
|
|
| 5559 |
|
|
| 5560 |
-- |
|
| 5561 |
-- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5562 |
-- |
|
| 5563 |
|
|
| 5564 |
ALTER TABLE ONLY taxoncorrelation |
|
| 5565 |
ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5566 |
|
|
| 5567 |
|
|
| 5568 |
-- |
|
| 5633 | 5569 |
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5634 | 5570 |
-- |
| 5635 | 5571 |
|
| ... | ... | |
| 5662 | 5598 |
|
| 5663 | 5599 |
|
| 5664 | 5600 |
-- |
| 5601 |
-- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5602 |
-- |
|
| 5603 |
|
|
| 5604 |
ALTER TABLE ONLY taxonlineage |
|
| 5605 |
ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5606 |
|
|
| 5607 |
|
|
| 5608 |
-- |
|
| 5609 |
-- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5610 |
-- |
|
| 5611 |
|
|
| 5612 |
ALTER TABLE ONLY taxonlineage |
|
Also available in: Unified diff
schemas/vegbien.sql: Renamed plant* taxonomic tables -> taxon*, as part of the taxonomic schema refactoring at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/2012-10-03_conference_call#Taxonomic-schema-refactoring>