Revision 1060
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 547 | 547 |
|
| 548 | 548 |
|
| 549 | 549 |
-- |
| 550 |
-- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 551 |
-- |
|
| 552 |
|
|
| 553 |
CREATE TABLE dba_confidentialitystatus ( |
|
| 554 |
confidentialitystatus integer NOT NULL, |
|
| 555 |
confidentialitytext text, |
|
| 556 |
confidentialityshorttext text |
|
| 557 |
); |
|
| 558 |
|
|
| 559 |
|
|
| 560 |
-- |
|
| 561 |
-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 562 |
-- |
|
| 563 |
|
|
| 564 |
CREATE TABLE dba_cookie ( |
|
| 565 |
cookie_id integer NOT NULL, |
|
| 566 |
cookiename text NOT NULL, |
|
| 567 |
defaultvalue text NOT NULL, |
|
| 568 |
viewname text NOT NULL, |
|
| 569 |
description text, |
|
| 570 |
examplepk integer NOT NULL, |
|
| 571 |
sortorder integer, |
|
| 572 |
startgroup boolean, |
|
| 573 |
prefixhtml text, |
|
| 574 |
suffixhtml text |
|
| 575 |
); |
|
| 576 |
|
|
| 577 |
|
|
| 578 |
-- |
|
| 579 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 580 |
-- |
|
| 581 |
|
|
| 582 |
CREATE SEQUENCE dba_cookie_cookie_id_seq |
|
| 583 |
START WITH 1 |
|
| 584 |
INCREMENT BY 1 |
|
| 585 |
NO MINVALUE |
|
| 586 |
NO MAXVALUE |
|
| 587 |
CACHE 1; |
|
| 588 |
|
|
| 589 |
|
|
| 590 |
-- |
|
| 591 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 592 |
-- |
|
| 593 |
|
|
| 594 |
ALTER SEQUENCE dba_cookie_cookie_id_seq OWNED BY dba_cookie.cookie_id; |
|
| 595 |
|
|
| 596 |
|
|
| 597 |
-- |
|
| 598 |
-- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 599 |
-- |
|
| 600 |
|
|
| 601 |
CREATE TABLE dba_cookielabels ( |
|
| 602 |
cookielabel_id integer NOT NULL, |
|
| 603 |
vieworcookie text NOT NULL, |
|
| 604 |
description text |
|
| 605 |
); |
|
| 606 |
|
|
| 607 |
|
|
| 608 |
-- |
|
| 609 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 610 |
-- |
|
| 611 |
|
|
| 612 |
CREATE SEQUENCE dba_cookielabels_cookielabel_id_seq |
|
| 613 |
START WITH 1 |
|
| 614 |
INCREMENT BY 1 |
|
| 615 |
NO MINVALUE |
|
| 616 |
NO MAXVALUE |
|
| 617 |
CACHE 1; |
|
| 618 |
|
|
| 619 |
|
|
| 620 |
-- |
|
| 621 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 622 |
-- |
|
| 623 |
|
|
| 624 |
ALTER SEQUENCE dba_cookielabels_cookielabel_id_seq OWNED BY dba_cookielabels.cookielabel_id; |
|
| 625 |
|
|
| 626 |
|
|
| 627 |
SET default_with_oids = false; |
|
| 628 |
|
|
| 629 |
-- |
|
| 630 |
-- Name: dba_datacache; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 631 |
-- |
|
| 632 |
|
|
| 633 |
CREATE TABLE dba_datacache ( |
|
| 634 |
dba_datacache_id integer NOT NULL, |
|
| 635 |
cache_key text NOT NULL, |
|
| 636 |
cache_label text, |
|
| 637 |
cache_order double precision, |
|
| 638 |
data1 text, |
|
| 639 |
data2 text, |
|
| 640 |
data3 text, |
|
| 641 |
data4 text, |
|
| 642 |
data5 text, |
|
| 643 |
data6 text, |
|
| 644 |
data7 text, |
|
| 645 |
data8 text, |
|
| 646 |
data9 text, |
|
| 647 |
data10 text |
|
| 648 |
); |
|
| 649 |
|
|
| 650 |
|
|
| 651 |
-- |
|
| 652 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 653 |
-- |
|
| 654 |
|
|
| 655 |
CREATE SEQUENCE dba_datacache_dba_datacache_id_seq |
|
| 656 |
START WITH 1 |
|
| 657 |
INCREMENT BY 1 |
|
| 658 |
NO MINVALUE |
|
| 659 |
NO MAXVALUE |
|
| 660 |
CACHE 1; |
|
| 661 |
|
|
| 662 |
|
|
| 663 |
-- |
|
| 664 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 665 |
-- |
|
| 666 |
|
|
| 667 |
ALTER SEQUENCE dba_datacache_dba_datacache_id_seq OWNED BY dba_datacache.dba_datacache_id; |
|
| 668 |
|
|
| 669 |
|
|
| 670 |
-- |
|
| 671 |
-- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 672 |
-- |
|
| 673 |
|
|
| 674 |
CREATE TABLE dba_datamodelversion ( |
|
| 675 |
dba_datamodelversion_id integer NOT NULL, |
|
| 676 |
versiontext text NOT NULL, |
|
| 677 |
versionimplemented timestamp with time zone DEFAULT now() |
|
| 678 |
); |
|
| 679 |
|
|
| 680 |
|
|
| 681 |
-- |
|
| 682 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 683 |
-- |
|
| 684 |
|
|
| 685 |
CREATE SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq |
|
| 686 |
START WITH 1 |
|
| 687 |
INCREMENT BY 1 |
|
| 688 |
NO MINVALUE |
|
| 689 |
NO MAXVALUE |
|
| 690 |
CACHE 1; |
|
| 691 |
|
|
| 692 |
|
|
| 693 |
-- |
|
| 694 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 695 |
-- |
|
| 696 |
|
|
| 697 |
ALTER SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq OWNED BY dba_datamodelversion.dba_datamodelversion_id; |
|
| 698 |
|
|
| 699 |
|
|
| 700 |
SET default_with_oids = true; |
|
| 701 |
|
|
| 702 |
-- |
|
| 703 |
-- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 704 |
-- |
|
| 705 |
|
|
| 706 |
CREATE TABLE dba_dbstatstime ( |
|
| 707 |
stat_id integer NOT NULL, |
|
| 708 |
statdate timestamp with time zone, |
|
| 709 |
statpkg integer, |
|
| 710 |
statname text, |
|
| 711 |
stattable text, |
|
| 712 |
minpk integer, |
|
| 713 |
maxpk integer, |
|
| 714 |
countrecs integer |
|
| 715 |
); |
|
| 716 |
|
|
| 717 |
|
|
| 718 |
-- |
|
| 719 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 720 |
-- |
|
| 721 |
|
|
| 722 |
CREATE SEQUENCE dba_dbstatstime_stat_id_seq |
|
| 723 |
START WITH 1 |
|
| 724 |
INCREMENT BY 1 |
|
| 725 |
NO MINVALUE |
|
| 726 |
NO MAXVALUE |
|
| 727 |
CACHE 1; |
|
| 728 |
|
|
| 729 |
|
|
| 730 |
-- |
|
| 731 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 732 |
-- |
|
| 733 |
|
|
| 734 |
ALTER SEQUENCE dba_dbstatstime_stat_id_seq OWNED BY dba_dbstatstime.stat_id; |
|
| 735 |
|
|
| 736 |
|
|
| 737 |
SET default_with_oids = false; |
|
| 738 |
|
|
| 739 |
-- |
|
| 740 |
-- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 741 |
-- |
|
| 742 |
|
|
| 743 |
CREATE TABLE dba_fielddescription ( |
|
| 744 |
dba_fielddescription_id integer NOT NULL, |
|
| 745 |
tablename text, |
|
| 746 |
fieldname text, |
|
| 747 |
fieldlabel text, |
|
| 748 |
fieldmodel text, |
|
| 749 |
fieldnulls text, |
|
| 750 |
fieldtype text, |
|
| 751 |
fieldkey text, |
|
| 752 |
fieldreferences text, |
|
| 753 |
fieldlist text, |
|
| 754 |
fieldnotes text, |
|
| 755 |
fielddefinition text, |
|
| 756 |
fieldkeywords text |
|
| 757 |
); |
|
| 758 |
|
|
| 759 |
|
|
| 760 |
-- |
|
| 761 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 762 |
-- |
|
| 763 |
|
|
| 764 |
CREATE SEQUENCE dba_fielddescription_dba_fielddescription_id_seq |
|
| 765 |
START WITH 1 |
|
| 766 |
INCREMENT BY 1 |
|
| 767 |
NO MINVALUE |
|
| 768 |
NO MAXVALUE |
|
| 769 |
CACHE 1; |
|
| 770 |
|
|
| 771 |
|
|
| 772 |
-- |
|
| 773 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 774 |
-- |
|
| 775 |
|
|
| 776 |
ALTER SEQUENCE dba_fielddescription_dba_fielddescription_id_seq OWNED BY dba_fielddescription.dba_fielddescription_id; |
|
| 777 |
|
|
| 778 |
|
|
| 779 |
-- |
|
| 780 |
-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 781 |
-- |
|
| 782 |
|
|
| 783 |
CREATE TABLE dba_fieldlist ( |
|
| 784 |
dba_fieldlist_id integer NOT NULL, |
|
| 785 |
tablename text, |
|
| 786 |
fieldname text, |
|
| 787 |
listvalue text, |
|
| 788 |
listvaluedescription text, |
|
| 789 |
listvaluesortorder double precision |
|
| 790 |
); |
|
| 791 |
|
|
| 792 |
|
|
| 793 |
-- |
|
| 794 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 795 |
-- |
|
| 796 |
|
|
| 797 |
CREATE SEQUENCE dba_fieldlist_dba_fieldlist_id_seq |
|
| 798 |
START WITH 1 |
|
| 799 |
INCREMENT BY 1 |
|
| 800 |
NO MINVALUE |
|
| 801 |
NO MAXVALUE |
|
| 802 |
CACHE 1; |
|
| 803 |
|
|
| 804 |
|
|
| 805 |
-- |
|
| 806 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 807 |
-- |
|
| 808 |
|
|
| 809 |
ALTER SEQUENCE dba_fieldlist_dba_fieldlist_id_seq OWNED BY dba_fieldlist.dba_fieldlist_id; |
|
| 810 |
|
|
| 811 |
|
|
| 812 |
-- |
|
| 813 |
-- Name: dba_onerow; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 814 |
-- |
|
| 815 |
|
|
| 816 |
CREATE TABLE dba_onerow ( |
|
| 817 |
dba_onerow_id integer NOT NULL |
|
| 818 |
); |
|
| 819 |
|
|
| 820 |
|
|
| 821 |
-- |
|
| 822 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 823 |
-- |
|
| 824 |
|
|
| 825 |
CREATE SEQUENCE dba_onerow_dba_onerow_id_seq |
|
| 826 |
START WITH 1 |
|
| 827 |
INCREMENT BY 1 |
|
| 828 |
NO MINVALUE |
|
| 829 |
NO MAXVALUE |
|
| 830 |
CACHE 1; |
|
| 831 |
|
|
| 832 |
|
|
| 833 |
-- |
|
| 834 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 835 |
-- |
|
| 836 |
|
|
| 837 |
ALTER SEQUENCE dba_onerow_dba_onerow_id_seq OWNED BY dba_onerow.dba_onerow_id; |
|
| 838 |
|
|
| 839 |
|
|
| 840 |
-- |
|
| 841 |
-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 842 |
-- |
|
| 843 |
|
|
| 844 |
CREATE TABLE dba_preassignacccode ( |
|
| 845 |
dba_preassignacccode_id integer NOT NULL, |
|
| 846 |
dba_requestnumber integer NOT NULL, |
|
| 847 |
databasekey text NOT NULL, |
|
| 848 |
tableabbrev text NOT NULL, |
|
| 849 |
confirmcode text DEFAULT ((replace(replace(replace(replace((now())::text, ' '::text, 'T'::text), '-'::text, ''::text), ':'::text, ''::text), '.'::text, 'd'::text) || 'R'::text) || (floor((random() * (1000000)::double precision)))::text) NOT NULL, |
|
| 850 |
codeisused boolean, |
|
| 851 |
accessioncode text |
|
| 852 |
); |
|
| 853 |
|
|
| 854 |
|
|
| 855 |
-- |
|
| 856 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 857 |
-- |
|
| 858 |
|
|
| 859 |
CREATE SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq |
|
| 860 |
START WITH 1 |
|
| 861 |
INCREMENT BY 1 |
|
| 862 |
NO MINVALUE |
|
| 863 |
NO MAXVALUE |
|
| 864 |
CACHE 1; |
|
| 865 |
|
|
| 866 |
|
|
| 867 |
-- |
|
| 868 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 869 |
-- |
|
| 870 |
|
|
| 871 |
ALTER SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq OWNED BY dba_preassignacccode.dba_preassignacccode_id; |
|
| 872 |
|
|
| 873 |
|
|
| 874 |
-- |
|
| 875 | 550 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 876 | 551 |
-- |
| 877 | 552 |
|
| ... | ... | |
| 884 | 559 |
|
| 885 | 560 |
|
| 886 | 561 |
-- |
| 887 |
-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 888 |
-- |
|
| 889 |
|
|
| 890 |
CREATE TABLE dba_tabledescription ( |
|
| 891 |
dba_tabledescription_id integer NOT NULL, |
|
| 892 |
tablename text, |
|
| 893 |
tablelabel text, |
|
| 894 |
tablenotes text, |
|
| 895 |
tabledescription text, |
|
| 896 |
tablekeywords text |
|
| 897 |
); |
|
| 898 |
|
|
| 899 |
|
|
| 900 |
-- |
|
| 901 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 902 |
-- |
|
| 903 |
|
|
| 904 |
CREATE SEQUENCE dba_tabledescription_dba_tabledescription_id_seq |
|
| 905 |
START WITH 1 |
|
| 906 |
INCREMENT BY 1 |
|
| 907 |
NO MINVALUE |
|
| 908 |
NO MAXVALUE |
|
| 909 |
CACHE 1; |
|
| 910 |
|
|
| 911 |
|
|
| 912 |
-- |
|
| 913 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 914 |
-- |
|
| 915 |
|
|
| 916 |
ALTER SEQUENCE dba_tabledescription_dba_tabledescription_id_seq OWNED BY dba_tabledescription.dba_tabledescription_id; |
|
| 917 |
|
|
| 918 |
|
|
| 919 |
-- |
|
| 920 |
-- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 921 |
-- |
|
| 922 |
|
|
| 923 |
CREATE TABLE dba_xmlcache ( |
|
| 924 |
xml bytea, |
|
| 925 |
accessioncode text |
|
| 926 |
); |
|
| 927 |
|
|
| 928 |
|
|
| 929 |
SET default_with_oids = true; |
|
| 930 |
|
|
| 931 |
-- |
|
| 932 | 562 |
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 933 | 563 |
-- |
| 934 | 564 |
|
| ... | ... | |
| 1064 | 694 |
|
| 1065 | 695 |
|
| 1066 | 696 |
-- |
| 1067 |
-- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1068 |
-- |
|
| 1069 |
|
|
| 1070 |
CREATE TABLE keywords ( |
|
| 1071 |
table_id integer NOT NULL, |
|
| 1072 |
entity text NOT NULL, |
|
| 1073 |
keywords text |
|
| 1074 |
); |
|
| 1075 |
|
|
| 1076 |
|
|
| 1077 |
-- |
|
| 1078 |
-- Name: keywords_extra; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1079 |
-- |
|
| 1080 |
|
|
| 1081 |
CREATE TABLE keywords_extra ( |
|
| 1082 |
table_id integer NOT NULL, |
|
| 1083 |
entity text NOT NULL, |
|
| 1084 |
keywords text |
|
| 1085 |
); |
|
| 1086 |
|
|
| 1087 |
|
|
| 1088 |
-- |
|
| 1089 | 697 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1090 | 698 |
-- |
| 1091 | 699 |
|
| ... | ... | |
| 2870 | 2478 |
ALTER SEQUENCE telephone_telephone_id_seq OWNED BY telephone.telephone_id; |
| 2871 | 2479 |
|
| 2872 | 2480 |
|
| 2873 |
-- |
|
| 2874 |
-- Name: temptbl_std_commnames; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2875 |
-- |
|
| 2876 |
|
|
| 2877 |
CREATE TABLE temptbl_std_commnames ( |
|
| 2878 |
commconcept_id integer NOT NULL, |
|
| 2879 |
sciname text, |
|
| 2880 |
translated text, |
|
| 2881 |
code text, |
|
| 2882 |
common text |
|
| 2883 |
); |
|
| 2884 |
|
|
| 2885 |
|
|
| 2886 |
-- |
|
| 2887 |
-- Name: temptbl_std_commnames_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2888 |
-- |
|
| 2889 |
|
|
| 2890 |
CREATE SEQUENCE temptbl_std_commnames_commconcept_id_seq |
|
| 2891 |
START WITH 1 |
|
| 2892 |
INCREMENT BY 1 |
|
| 2893 |
NO MINVALUE |
|
| 2894 |
NO MAXVALUE |
|
| 2895 |
CACHE 1; |
|
| 2896 |
|
|
| 2897 |
|
|
| 2898 |
-- |
|
| 2899 |
-- Name: temptbl_std_commnames_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2900 |
-- |
|
| 2901 |
|
|
| 2902 |
ALTER SEQUENCE temptbl_std_commnames_commconcept_id_seq OWNED BY temptbl_std_commnames.commconcept_id; |
|
| 2903 |
|
|
| 2904 |
|
|
| 2905 |
-- |
|
| 2906 |
-- Name: temptbl_std_plantnames; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2907 |
-- |
|
| 2908 |
|
|
| 2909 |
CREATE TABLE temptbl_std_plantnames ( |
|
| 2910 |
plantconcept_id integer NOT NULL, |
|
| 2911 |
plantname text, |
|
| 2912 |
sciname text, |
|
| 2913 |
scinamenoauth text, |
|
| 2914 |
code text, |
|
| 2915 |
common text |
|
| 2916 |
); |
|
| 2917 |
|
|
| 2918 |
|
|
| 2919 |
-- |
|
| 2920 |
-- Name: temptbl_std_plantnames_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2921 |
-- |
|
| 2922 |
|
|
| 2923 |
CREATE SEQUENCE temptbl_std_plantnames_plantconcept_id_seq |
|
| 2924 |
START WITH 1 |
|
| 2925 |
INCREMENT BY 1 |
|
| 2926 |
NO MINVALUE |
|
| 2927 |
NO MAXVALUE |
|
| 2928 |
CACHE 1; |
|
| 2929 |
|
|
| 2930 |
|
|
| 2931 |
-- |
|
| 2932 |
-- Name: temptbl_std_plantnames_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2933 |
-- |
|
| 2934 |
|
|
| 2935 |
ALTER SEQUENCE temptbl_std_plantnames_plantconcept_id_seq OWNED BY temptbl_std_plantnames.plantconcept_id; |
|
| 2936 |
|
|
| 2937 |
|
|
| 2938 | 2481 |
SET default_with_oids = false; |
| 2939 | 2482 |
|
| 2940 | 2483 |
-- |
| ... | ... | |
| 2971 | 2514 |
SET default_with_oids = true; |
| 2972 | 2515 |
|
| 2973 | 2516 |
-- |
| 2974 |
-- Name: usercertification; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2975 |
-- |
|
| 2976 |
|
|
| 2977 |
CREATE TABLE usercertification ( |
|
| 2978 |
usercertification_id integer NOT NULL, |
|
| 2979 |
usr_id integer NOT NULL, |
|
| 2980 |
current_cert_level integer NOT NULL, |
|
| 2981 |
requested_cert_level integer NOT NULL, |
|
| 2982 |
highest_degree text, |
|
| 2983 |
degree_year text, |
|
| 2984 |
degree_institution text, |
|
| 2985 |
current_org text, |
|
| 2986 |
current_pos text, |
|
| 2987 |
esa_member boolean, |
|
| 2988 |
prof_exp text, |
|
| 2989 |
relevant_pubs text, |
|
| 2990 |
veg_sampling_exp text, |
|
| 2991 |
veg_analysis_exp text, |
|
| 2992 |
usnvc_exp text, |
|
| 2993 |
vb_exp text, |
|
| 2994 |
vb_intention text, |
|
| 2995 |
tools_exp text, |
|
| 2996 |
esa_sponsor_name_a text, |
|
| 2997 |
esa_sponsor_email_a text, |
|
| 2998 |
esa_sponsor_name_b text, |
|
| 2999 |
esa_sponsor_email_b text, |
|
| 3000 |
peer_review boolean, |
|
| 3001 |
addl_stmt text, |
|
| 3002 |
certificationstatus text, |
|
| 3003 |
certificationstatuscomments text, |
|
| 3004 |
exp_region_a text, |
|
| 3005 |
exp_region_b text, |
|
| 3006 |
exp_region_c text, |
|
| 3007 |
exp_region_a_veg text, |
|
| 3008 |
exp_region_b_veg text, |
|
| 3009 |
exp_region_c_veg text, |
|
| 3010 |
exp_region_a_flor text, |
|
| 3011 |
exp_region_b_flor text, |
|
| 3012 |
exp_region_c_flor text, |
|
| 3013 |
exp_region_a_nvc text, |
|
| 3014 |
exp_region_b_nvc text, |
|
| 3015 |
exp_region_c_nvc text |
|
| 3016 |
); |
|
| 3017 |
|
|
| 3018 |
|
|
| 3019 |
-- |
|
| 3020 |
-- Name: usercertification_usercertification_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3021 |
-- |
|
| 3022 |
|
|
| 3023 |
CREATE SEQUENCE usercertification_usercertification_id_seq |
|
| 3024 |
START WITH 1 |
|
| 3025 |
INCREMENT BY 1 |
|
| 3026 |
NO MINVALUE |
|
| 3027 |
NO MAXVALUE |
|
| 3028 |
CACHE 1; |
|
| 3029 |
|
|
| 3030 |
|
|
| 3031 |
-- |
|
| 3032 |
-- Name: usercertification_usercertification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3033 |
-- |
|
| 3034 |
|
|
| 3035 |
ALTER SEQUENCE usercertification_usercertification_id_seq OWNED BY usercertification.usercertification_id; |
|
| 3036 |
|
|
| 3037 |
|
|
| 3038 |
-- |
|
| 3039 |
-- Name: userdataset; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3040 |
-- |
|
| 3041 |
|
|
| 3042 |
CREATE TABLE userdataset ( |
|
| 3043 |
userdataset_id integer NOT NULL, |
|
| 3044 |
usr_id integer, |
|
| 3045 |
datasetname text NOT NULL, |
|
| 3046 |
datasetdescription text, |
|
| 3047 |
datasettype text, |
|
| 3048 |
datasetsharing text, |
|
| 3049 |
datasetpassword text, |
|
| 3050 |
datasetstop timestamp with time zone, |
|
| 3051 |
datasetstart timestamp with time zone DEFAULT now(), |
|
| 3052 |
accessioncode text |
|
| 3053 |
); |
|
| 3054 |
|
|
| 3055 |
|
|
| 3056 |
-- |
|
| 3057 |
-- Name: userdataset_userdataset_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3058 |
-- |
|
| 3059 |
|
|
| 3060 |
CREATE SEQUENCE userdataset_userdataset_id_seq |
|
| 3061 |
START WITH 1 |
|
| 3062 |
INCREMENT BY 1 |
|
| 3063 |
NO MINVALUE |
|
| 3064 |
NO MAXVALUE |
|
| 3065 |
CACHE 1; |
|
| 3066 |
|
|
| 3067 |
|
|
| 3068 |
-- |
|
| 3069 |
-- Name: userdataset_userdataset_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3070 |
-- |
|
| 3071 |
|
|
| 3072 |
ALTER SEQUENCE userdataset_userdataset_id_seq OWNED BY userdataset.userdataset_id; |
|
| 3073 |
|
|
| 3074 |
|
|
| 3075 |
-- |
|
| 3076 |
-- Name: userdatasetitem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3077 |
-- |
|
| 3078 |
|
|
| 3079 |
CREATE TABLE userdatasetitem ( |
|
| 3080 |
userdatasetitem_id integer NOT NULL, |
|
| 3081 |
userdataset_id integer NOT NULL, |
|
| 3082 |
itemaccessioncode text NOT NULL, |
|
| 3083 |
itemtype text, |
|
| 3084 |
notes text, |
|
| 3085 |
itemstart timestamp with time zone DEFAULT now() NOT NULL, |
|
| 3086 |
itemstop timestamp with time zone, |
|
| 3087 |
externalaccessioncode text, |
|
| 3088 |
itemdatabase text NOT NULL, |
|
| 3089 |
itemtable text NOT NULL, |
|
| 3090 |
itemrecord integer NOT NULL |
|
| 3091 |
); |
|
| 3092 |
|
|
| 3093 |
|
|
| 3094 |
-- |
|
| 3095 |
-- Name: userdatasetitem_userdatasetitem_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3096 |
-- |
|
| 3097 |
|
|
| 3098 |
CREATE SEQUENCE userdatasetitem_userdatasetitem_id_seq |
|
| 3099 |
START WITH 1 |
|
| 3100 |
INCREMENT BY 1 |
|
| 3101 |
NO MINVALUE |
|
| 3102 |
NO MAXVALUE |
|
| 3103 |
CACHE 1; |
|
| 3104 |
|
|
| 3105 |
|
|
| 3106 |
-- |
|
| 3107 |
-- Name: userdatasetitem_userdatasetitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3108 |
-- |
|
| 3109 |
|
|
| 3110 |
ALTER SEQUENCE userdatasetitem_userdatasetitem_id_seq OWNED BY userdatasetitem.userdatasetitem_id; |
|
| 3111 |
|
|
| 3112 |
|
|
| 3113 |
-- |
|
| 3114 | 2517 |
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3115 | 2518 |
-- |
| 3116 | 2519 |
|
| ... | ... | |
| 3144 | 2547 |
ALTER SEQUENCE userdefined_userdefined_id_seq OWNED BY userdefined.userdefined_id; |
| 3145 | 2548 |
|
| 3146 | 2549 |
|
| 3147 |
-- |
|
| 3148 |
-- Name: usernotify; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3149 |
-- |
|
| 3150 |
|
|
| 3151 |
CREATE TABLE usernotify ( |
|
| 3152 |
usernotify_id integer NOT NULL, |
|
| 3153 |
usr_id integer NOT NULL, |
|
| 3154 |
notifyname text, |
|
| 3155 |
notifydescription text, |
|
| 3156 |
notifysql text, |
|
| 3157 |
notifystart timestamp with time zone DEFAULT now(), |
|
| 3158 |
notifystop timestamp with time zone, |
|
| 3159 |
lastcheckdate timestamp with time zone |
|
| 3160 |
); |
|
| 3161 |
|
|
| 3162 |
|
|
| 3163 |
-- |
|
| 3164 |
-- Name: usernotify_usernotify_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3165 |
-- |
|
| 3166 |
|
|
| 3167 |
CREATE SEQUENCE usernotify_usernotify_id_seq |
|
| 3168 |
START WITH 1 |
|
| 3169 |
INCREMENT BY 1 |
|
| 3170 |
NO MINVALUE |
|
| 3171 |
NO MAXVALUE |
|
| 3172 |
CACHE 1; |
|
| 3173 |
|
|
| 3174 |
|
|
| 3175 |
-- |
|
| 3176 |
-- Name: usernotify_usernotify_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3177 |
-- |
|
| 3178 |
|
|
| 3179 |
ALTER SEQUENCE usernotify_usernotify_id_seq OWNED BY usernotify.usernotify_id; |
|
| 3180 |
|
|
| 3181 |
|
|
| 3182 |
-- |
|
| 3183 |
-- Name: userpermission; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3184 |
-- |
|
| 3185 |
|
|
| 3186 |
CREATE TABLE userpermission ( |
|
| 3187 |
userpermission_id integer NOT NULL, |
|
| 3188 |
embargo_id integer NOT NULL, |
|
| 3189 |
usr_id integer NOT NULL, |
|
| 3190 |
permissionstatus integer NOT NULL, |
|
| 3191 |
permissionnotes text, |
|
| 3192 |
permissionstop timestamp with time zone, |
|
| 3193 |
permissionstart timestamp with time zone DEFAULT now() NOT NULL |
|
| 3194 |
); |
|
| 3195 |
|
|
| 3196 |
|
|
| 3197 |
-- |
|
| 3198 |
-- Name: userpermission_userpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3199 |
-- |
|
| 3200 |
|
|
| 3201 |
CREATE SEQUENCE userpermission_userpermission_id_seq |
|
| 3202 |
START WITH 1 |
|
| 3203 |
INCREMENT BY 1 |
|
| 3204 |
NO MINVALUE |
|
| 3205 |
NO MAXVALUE |
|
| 3206 |
CACHE 1; |
|
| 3207 |
|
|
| 3208 |
|
|
| 3209 |
-- |
|
| 3210 |
-- Name: userpermission_userpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3211 |
-- |
|
| 3212 |
|
|
| 3213 |
ALTER SEQUENCE userpermission_userpermission_id_seq OWNED BY userpermission.userpermission_id; |
|
| 3214 |
|
|
| 3215 |
|
|
| 3216 |
-- |
|
| 3217 |
-- Name: userpreference; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3218 |
-- |
|
| 3219 |
|
|
| 3220 |
CREATE TABLE userpreference ( |
|
| 3221 |
userpreference_id integer NOT NULL, |
|
| 3222 |
usr_id integer NOT NULL, |
|
| 3223 |
preferencename text, |
|
| 3224 |
preferencevalue text, |
|
| 3225 |
preferencepriority double precision, |
|
| 3226 |
preferencestop timestamp with time zone, |
|
| 3227 |
preferencestart timestamp with time zone DEFAULT now() |
|
| 3228 |
); |
|
| 3229 |
|
|
| 3230 |
|
|
| 3231 |
-- |
|
| 3232 |
-- Name: userpreference_userpreference_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3233 |
-- |
|
| 3234 |
|
|
| 3235 |
CREATE SEQUENCE userpreference_userpreference_id_seq |
|
| 3236 |
START WITH 1 |
|
| 3237 |
INCREMENT BY 1 |
|
| 3238 |
NO MINVALUE |
|
| 3239 |
NO MAXVALUE |
|
| 3240 |
CACHE 1; |
|
| 3241 |
|
|
| 3242 |
|
|
| 3243 |
-- |
|
| 3244 |
-- Name: userpreference_userpreference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3245 |
-- |
|
| 3246 |
|
|
| 3247 |
ALTER SEQUENCE userpreference_userpreference_id_seq OWNED BY userpreference.userpreference_id; |
|
| 3248 |
|
|
| 3249 |
|
|
| 3250 |
-- |
|
| 3251 |
-- Name: userquery; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3252 |
-- |
|
| 3253 |
|
|
| 3254 |
CREATE TABLE userquery ( |
|
| 3255 |
userquery_id integer NOT NULL, |
|
| 3256 |
usr_id integer NOT NULL, |
|
| 3257 |
queryname text, |
|
| 3258 |
querydescription text, |
|
| 3259 |
querysql text, |
|
| 3260 |
querytype text, |
|
| 3261 |
querysharing text, |
|
| 3262 |
querypassword text, |
|
| 3263 |
querystop timestamp with time zone, |
|
| 3264 |
querystart timestamp with time zone DEFAULT now(), |
|
| 3265 |
accessioncode text |
|
| 3266 |
); |
|
| 3267 |
|
|
| 3268 |
|
|
| 3269 |
-- |
|
| 3270 |
-- Name: userquery_userquery_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3271 |
-- |
|
| 3272 |
|
|
| 3273 |
CREATE SEQUENCE userquery_userquery_id_seq |
|
| 3274 |
START WITH 1 |
|
| 3275 |
INCREMENT BY 1 |
|
| 3276 |
NO MINVALUE |
|
| 3277 |
NO MAXVALUE |
|
| 3278 |
CACHE 1; |
|
| 3279 |
|
|
| 3280 |
|
|
| 3281 |
-- |
|
| 3282 |
-- Name: userquery_userquery_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3283 |
-- |
|
| 3284 |
|
|
| 3285 |
ALTER SEQUENCE userquery_userquery_id_seq OWNED BY userquery.userquery_id; |
|
| 3286 |
|
|
| 3287 |
|
|
| 3288 |
-- |
|
| 3289 |
-- Name: userrecordowner; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3290 |
-- |
|
| 3291 |
|
|
| 3292 |
CREATE TABLE userrecordowner ( |
|
| 3293 |
userrecordowner_id integer NOT NULL, |
|
| 3294 |
usr_id integer NOT NULL, |
|
| 3295 |
tablename text NOT NULL, |
|
| 3296 |
tablerecord integer NOT NULL, |
|
| 3297 |
ownertype text NOT NULL, |
|
| 3298 |
recordcreationdate timestamp with time zone NOT NULL, |
|
| 3299 |
ownerstop timestamp with time zone, |
|
| 3300 |
ownerstart timestamp with time zone DEFAULT now() NOT NULL |
|
| 3301 |
); |
|
| 3302 |
|
|
| 3303 |
|
|
| 3304 |
-- |
|
| 3305 |
-- Name: userrecordowner_userrecordowner_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3306 |
-- |
|
| 3307 |
|
|
| 3308 |
CREATE SEQUENCE userrecordowner_userrecordowner_id_seq |
|
| 3309 |
START WITH 1 |
|
| 3310 |
INCREMENT BY 1 |
|
| 3311 |
NO MINVALUE |
|
| 3312 |
NO MAXVALUE |
|
| 3313 |
CACHE 1; |
|
| 3314 |
|
|
| 3315 |
|
|
| 3316 |
-- |
|
| 3317 |
-- Name: userrecordowner_userrecordowner_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3318 |
-- |
|
| 3319 |
|
|
| 3320 |
ALTER SEQUENCE userrecordowner_userrecordowner_id_seq OWNED BY userrecordowner.userrecordowner_id; |
|
| 3321 |
|
|
| 3322 |
|
|
| 3323 |
-- |
|
| 3324 |
-- Name: userregionalexp; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3325 |
-- |
|
| 3326 |
|
|
| 3327 |
CREATE TABLE userregionalexp ( |
|
| 3328 |
userregionalexp_id integer NOT NULL, |
|
| 3329 |
usercertification_id integer NOT NULL, |
|
| 3330 |
region text NOT NULL, |
|
| 3331 |
vegetation text, |
|
| 3332 |
floristics text, |
|
| 3333 |
nvc_ivc text |
|
| 3334 |
); |
|
| 3335 |
|
|
| 3336 |
|
|
| 3337 |
-- |
|
| 3338 |
-- Name: userregionalexp_userregionalexp_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3339 |
-- |
|
| 3340 |
|
|
| 3341 |
CREATE SEQUENCE userregionalexp_userregionalexp_id_seq |
|
| 3342 |
START WITH 1 |
|
| 3343 |
INCREMENT BY 1 |
|
| 3344 |
NO MINVALUE |
|
| 3345 |
NO MAXVALUE |
|
| 3346 |
CACHE 1; |
|
| 3347 |
|
|
| 3348 |
|
|
| 3349 |
-- |
|
| 3350 |
-- Name: userregionalexp_userregionalexp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3351 |
-- |
|
| 3352 |
|
|
| 3353 |
ALTER SEQUENCE userregionalexp_userregionalexp_id_seq OWNED BY userregionalexp.userregionalexp_id; |
|
| 3354 |
|
|
| 3355 |
|
|
| 3356 |
-- |
|
| 3357 |
-- Name: usr; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3358 |
-- |
|
| 3359 |
|
|
| 3360 |
CREATE TABLE usr ( |
|
| 3361 |
usr_id integer NOT NULL, |
|
| 3362 |
party_id integer NOT NULL, |
|
| 3363 |
permission_type integer NOT NULL, |
|
| 3364 |
ticket_count integer, |
|
| 3365 |
email_address text NOT NULL, |
|
| 3366 |
preferred_name text, |
|
| 3367 |
remote_address text, |
|
| 3368 |
last_connect timestamp with time zone, |
|
| 3369 |
begin_time timestamp with time zone, |
|
| 3370 |
password text |
|
| 3371 |
); |
|
| 3372 |
|
|
| 3373 |
|
|
| 3374 |
-- |
|
| 3375 |
-- Name: usr_usr_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 3376 |
-- |
|
| 3377 |
|
|
| 3378 |
CREATE SEQUENCE usr_usr_id_seq |
|
| 3379 |
START WITH 1 |
|
| 3380 |
INCREMENT BY 1 |
|
| 3381 |
NO MINVALUE |
|
| 3382 |
NO MAXVALUE |
|
| 3383 |
CACHE 1; |
|
| 3384 |
|
|
| 3385 |
|
|
| 3386 |
-- |
|
| 3387 |
-- Name: usr_usr_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 3388 |
-- |
|
| 3389 |
|
|
| 3390 |
ALTER SEQUENCE usr_usr_id_seq OWNED BY usr.usr_id; |
|
| 3391 |
|
|
| 3392 |
|
|
| 3393 | 2550 |
SET default_with_oids = false; |
| 3394 | 2551 |
|
| 3395 | 2552 |
-- |
| ... | ... | |
| 3515 | 2672 |
|
| 3516 | 2673 |
|
| 3517 | 2674 |
-- |
| 3518 |
-- Name: cookie_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3519 |
-- |
|
| 3520 |
|
|
| 3521 |
ALTER TABLE dba_cookie ALTER COLUMN cookie_id SET DEFAULT nextval('dba_cookie_cookie_id_seq'::regclass);
|
|
| 3522 |
|
|
| 3523 |
|
|
| 3524 |
-- |
|
| 3525 |
-- Name: cookielabel_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3526 |
-- |
|
| 3527 |
|
|
| 3528 |
ALTER TABLE dba_cookielabels ALTER COLUMN cookielabel_id SET DEFAULT nextval('dba_cookielabels_cookielabel_id_seq'::regclass);
|
|
| 3529 |
|
|
| 3530 |
|
|
| 3531 |
-- |
|
| 3532 |
-- Name: dba_datacache_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3533 |
-- |
|
| 3534 |
|
|
| 3535 |
ALTER TABLE dba_datacache ALTER COLUMN dba_datacache_id SET DEFAULT nextval('dba_datacache_dba_datacache_id_seq'::regclass);
|
|
| 3536 |
|
|
| 3537 |
|
|
| 3538 |
-- |
|
| 3539 |
-- Name: dba_datamodelversion_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3540 |
-- |
|
| 3541 |
|
|
| 3542 |
ALTER TABLE dba_datamodelversion ALTER COLUMN dba_datamodelversion_id SET DEFAULT nextval('dba_datamodelversion_dba_datamodelversion_id_seq'::regclass);
|
|
| 3543 |
|
|
| 3544 |
|
|
| 3545 |
-- |
|
| 3546 |
-- Name: stat_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3547 |
-- |
|
| 3548 |
|
|
| 3549 |
ALTER TABLE dba_dbstatstime ALTER COLUMN stat_id SET DEFAULT nextval('dba_dbstatstime_stat_id_seq'::regclass);
|
|
| 3550 |
|
|
| 3551 |
|
|
| 3552 |
-- |
|
| 3553 |
-- Name: dba_fielddescription_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3554 |
-- |
|
| 3555 |
|
|
| 3556 |
ALTER TABLE dba_fielddescription ALTER COLUMN dba_fielddescription_id SET DEFAULT nextval('dba_fielddescription_dba_fielddescription_id_seq'::regclass);
|
|
| 3557 |
|
|
| 3558 |
|
|
| 3559 |
-- |
|
| 3560 |
-- Name: dba_fieldlist_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3561 |
-- |
|
| 3562 |
|
|
| 3563 |
ALTER TABLE dba_fieldlist ALTER COLUMN dba_fieldlist_id SET DEFAULT nextval('dba_fieldlist_dba_fieldlist_id_seq'::regclass);
|
|
| 3564 |
|
|
| 3565 |
|
|
| 3566 |
-- |
|
| 3567 |
-- Name: dba_onerow_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3568 |
-- |
|
| 3569 |
|
|
| 3570 |
ALTER TABLE dba_onerow ALTER COLUMN dba_onerow_id SET DEFAULT nextval('dba_onerow_dba_onerow_id_seq'::regclass);
|
|
| 3571 |
|
|
| 3572 |
|
|
| 3573 |
-- |
|
| 3574 |
-- Name: dba_preassignacccode_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3575 |
-- |
|
| 3576 |
|
|
| 3577 |
ALTER TABLE dba_preassignacccode ALTER COLUMN dba_preassignacccode_id SET DEFAULT nextval('dba_preassignacccode_dba_preassignacccode_id_seq'::regclass);
|
|
| 3578 |
|
|
| 3579 |
|
|
| 3580 |
-- |
|
| 3581 |
-- Name: dba_tabledescription_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3582 |
-- |
|
| 3583 |
|
|
| 3584 |
ALTER TABLE dba_tabledescription ALTER COLUMN dba_tabledescription_id SET DEFAULT nextval('dba_tabledescription_dba_tabledescription_id_seq'::regclass);
|
|
| 3585 |
|
|
| 3586 |
|
|
| 3587 |
-- |
|
| 3588 | 2675 |
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: - |
| 3589 | 2676 |
-- |
| 3590 | 2677 |
|
| ... | ... | |
| 3907 | 2994 |
|
| 3908 | 2995 |
|
| 3909 | 2996 |
-- |
| 3910 |
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3911 |
-- |
|
| 3912 |
|
|
| 3913 |
ALTER TABLE temptbl_std_commnames ALTER COLUMN commconcept_id SET DEFAULT nextval('temptbl_std_commnames_commconcept_id_seq'::regclass);
|
|
| 3914 |
|
|
| 3915 |
|
|
| 3916 |
-- |
|
| 3917 |
-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3918 |
-- |
|
| 3919 |
|
|
| 3920 |
ALTER TABLE temptbl_std_plantnames ALTER COLUMN plantconcept_id SET DEFAULT nextval('temptbl_std_plantnames_plantconcept_id_seq'::regclass);
|
|
| 3921 |
|
|
| 3922 |
|
|
| 3923 |
-- |
|
| 3924 | 2997 |
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: - |
| 3925 | 2998 |
-- |
| 3926 | 2999 |
|
| ... | ... | |
| 3928 | 3001 |
|
| 3929 | 3002 |
|
| 3930 | 3003 |
-- |
| 3931 |
-- Name: usercertification_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3932 |
-- |
|
| 3933 |
|
|
| 3934 |
ALTER TABLE usercertification ALTER COLUMN usercertification_id SET DEFAULT nextval('usercertification_usercertification_id_seq'::regclass);
|
|
| 3935 |
|
|
| 3936 |
|
|
| 3937 |
-- |
|
| 3938 |
-- Name: userdataset_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3939 |
-- |
|
| 3940 |
|
|
| 3941 |
ALTER TABLE userdataset ALTER COLUMN userdataset_id SET DEFAULT nextval('userdataset_userdataset_id_seq'::regclass);
|
|
| 3942 |
|
|
| 3943 |
|
|
| 3944 |
-- |
|
| 3945 |
-- Name: userdatasetitem_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3946 |
-- |
|
| 3947 |
|
|
| 3948 |
ALTER TABLE userdatasetitem ALTER COLUMN userdatasetitem_id SET DEFAULT nextval('userdatasetitem_userdatasetitem_id_seq'::regclass);
|
|
| 3949 |
|
|
| 3950 |
|
|
| 3951 |
-- |
|
| 3952 | 3004 |
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: - |
| 3953 | 3005 |
-- |
| 3954 | 3006 |
|
| ... | ... | |
| 3956 | 3008 |
|
| 3957 | 3009 |
|
| 3958 | 3010 |
-- |
| 3959 |
-- Name: usernotify_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3960 |
-- |
|
| 3961 |
|
|
| 3962 |
ALTER TABLE usernotify ALTER COLUMN usernotify_id SET DEFAULT nextval('usernotify_usernotify_id_seq'::regclass);
|
|
| 3963 |
|
|
| 3964 |
|
|
| 3965 |
-- |
|
| 3966 |
-- Name: userpermission_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3967 |
-- |
|
| 3968 |
|
|
| 3969 |
ALTER TABLE userpermission ALTER COLUMN userpermission_id SET DEFAULT nextval('userpermission_userpermission_id_seq'::regclass);
|
|
| 3970 |
|
|
| 3971 |
|
|
| 3972 |
-- |
|
| 3973 |
-- Name: userpreference_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3974 |
-- |
|
| 3975 |
|
|
| 3976 |
ALTER TABLE userpreference ALTER COLUMN userpreference_id SET DEFAULT nextval('userpreference_userpreference_id_seq'::regclass);
|
|
| 3977 |
|
|
| 3978 |
|
|
| 3979 |
-- |
|
| 3980 |
-- Name: userquery_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3981 |
-- |
|
| 3982 |
|
|
| 3983 |
ALTER TABLE userquery ALTER COLUMN userquery_id SET DEFAULT nextval('userquery_userquery_id_seq'::regclass);
|
|
| 3984 |
|
|
| 3985 |
|
|
| 3986 |
-- |
|
| 3987 |
-- Name: userrecordowner_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3988 |
-- |
|
| 3989 |
|
|
| 3990 |
ALTER TABLE userrecordowner ALTER COLUMN userrecordowner_id SET DEFAULT nextval('userrecordowner_userrecordowner_id_seq'::regclass);
|
|
| 3991 |
|
|
| 3992 |
|
|
| 3993 |
-- |
|
| 3994 |
-- Name: userregionalexp_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3995 |
-- |
|
| 3996 |
|
|
| 3997 |
ALTER TABLE userregionalexp ALTER COLUMN userregionalexp_id SET DEFAULT nextval('userregionalexp_userregionalexp_id_seq'::regclass);
|
|
| 3998 |
|
|
| 3999 |
|
|
| 4000 |
-- |
|
| 4001 |
-- Name: usr_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 4002 |
-- |
|
| 4003 |
|
|
| 4004 |
ALTER TABLE usr ALTER COLUMN usr_id SET DEFAULT nextval('usr_usr_id_seq'::regclass);
|
|
| 4005 |
|
|
| 4006 |
|
|
| 4007 |
-- |
|
| 4008 | 3011 |
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: - |
| 4009 | 3012 |
-- |
| 4010 | 3013 |
|
| ... | ... | |
| 4156 | 3159 |
|
| 4157 | 3160 |
|
| 4158 | 3161 |
-- |
| 4159 |
-- Name: dba_confidentialitystatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4160 |
-- |
|
| 4161 |
|
|
| 4162 |
ALTER TABLE ONLY dba_confidentialitystatus |
|
| 4163 |
ADD CONSTRAINT dba_confidentialitystatus_pkey PRIMARY KEY (confidentialitystatus); |
|
| 4164 |
|
|
| 4165 |
|
|
| 4166 |
-- |
|
| 4167 |
-- Name: dba_cookie_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4168 |
-- |
|
| 4169 |
|
|
| 4170 |
ALTER TABLE ONLY dba_cookie |
|
| 4171 |
ADD CONSTRAINT dba_cookie_pkey PRIMARY KEY (cookie_id); |
|
| 4172 |
|
|
| 4173 |
|
|
| 4174 |
-- |
|
| 4175 |
-- Name: dba_cookielabels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4176 |
-- |
|
| 4177 |
|
|
| 4178 |
ALTER TABLE ONLY dba_cookielabels |
|
| 4179 |
ADD CONSTRAINT dba_cookielabels_pkey PRIMARY KEY (vieworcookie); |
|
| 4180 |
|
|
| 4181 |
|
|
| 4182 |
-- |
|
| 4183 |
-- Name: dba_datacache_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4184 |
-- |
|
| 4185 |
|
|
| 4186 |
ALTER TABLE ONLY dba_datacache |
|
| 4187 |
ADD CONSTRAINT dba_datacache_pkey PRIMARY KEY (dba_datacache_id); |
|
| 4188 |
|
|
| 4189 |
|
|
| 4190 |
-- |
|
| 4191 |
-- Name: dba_datamodelversion_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4192 |
-- |
|
| 4193 |
|
|
| 4194 |
ALTER TABLE ONLY dba_datamodelversion |
|
| 4195 |
ADD CONSTRAINT dba_datamodelversion_pkey PRIMARY KEY (dba_datamodelversion_id); |
|
| 4196 |
|
|
| 4197 |
|
|
| 4198 |
-- |
|
| 4199 |
-- Name: dba_dbstatstime_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4200 |
-- |
|
| 4201 |
|
|
| 4202 |
ALTER TABLE ONLY dba_dbstatstime |
|
| 4203 |
ADD CONSTRAINT dba_dbstatstime_pkey PRIMARY KEY (stat_id); |
|
| 4204 |
|
|
| 4205 |
|
|
| 4206 |
-- |
|
| 4207 |
-- Name: dba_fielddescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4208 |
-- |
|
| 4209 |
|
|
| 4210 |
ALTER TABLE ONLY dba_fielddescription |
|
| 4211 |
ADD CONSTRAINT dba_fielddescription_pkey PRIMARY KEY (dba_fielddescription_id); |
|
| 4212 |
|
|
| 4213 |
|
|
| 4214 |
-- |
|
| 4215 |
-- Name: dba_fieldlist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4216 |
-- |
|
| 4217 |
|
|
| 4218 |
ALTER TABLE ONLY dba_fieldlist |
|
| 4219 |
ADD CONSTRAINT dba_fieldlist_pkey PRIMARY KEY (dba_fieldlist_id); |
|
| 4220 |
|
|
| 4221 |
|
|
| 4222 |
-- |
|
| 4223 |
-- Name: dba_onerow_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4224 |
-- |
|
| 4225 |
|
|
| 4226 |
ALTER TABLE ONLY dba_onerow |
|
| 4227 |
ADD CONSTRAINT dba_onerow_pkey PRIMARY KEY (dba_onerow_id); |
|
| 4228 |
|
|
| 4229 |
|
|
| 4230 |
-- |
|
| 4231 |
-- Name: dba_preassignacccode_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4232 |
-- |
|
| 4233 |
|
|
| 4234 |
ALTER TABLE ONLY dba_preassignacccode |
|
| 4235 |
ADD CONSTRAINT dba_preassignacccode_pkey PRIMARY KEY (dba_preassignacccode_id); |
|
| 4236 |
|
|
| 4237 |
|
|
| 4238 |
-- |
|
| 4239 |
-- Name: dba_tabledescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4240 |
-- |
|
| 4241 |
|
|
| 4242 |
ALTER TABLE ONLY dba_tabledescription |
|
| 4243 |
ADD CONSTRAINT dba_tabledescription_pkey PRIMARY KEY (dba_tabledescription_id); |
|
| 4244 |
|
|
| 4245 |
|
|
| 4246 |
-- |
|
| 4247 | 3162 |
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4248 | 3163 |
-- |
| 4249 | 3164 |
|
| ... | ... | |
| 4724 | 3639 |
|
| 4725 | 3640 |
|
| 4726 | 3641 |
-- |
| 4727 |
-- Name: temptbl_std_commnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4728 |
-- |
|
| 4729 |
|
|
| 4730 |
ALTER TABLE ONLY temptbl_std_commnames |
|
| 4731 |
ADD CONSTRAINT temptbl_std_commnames_pkey PRIMARY KEY (commconcept_id); |
|
| 4732 |
|
|
| 4733 |
|
|
| 4734 |
-- |
|
| 4735 |
-- Name: temptbl_std_plantnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4736 |
-- |
|
| 4737 |
|
|
| 4738 |
ALTER TABLE ONLY temptbl_std_plantnames |
|
| 4739 |
ADD CONSTRAINT temptbl_std_plantnames_pkey PRIMARY KEY (plantconcept_id); |
|
| 4740 |
|
|
| 4741 |
|
|
| 4742 |
-- |
|
| 4743 | 3642 |
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4744 | 3643 |
-- |
| 4745 | 3644 |
|
| ... | ... | |
| 4748 | 3647 |
|
| 4749 | 3648 |
|
| 4750 | 3649 |
-- |
| 4751 |
-- Name: usercertification_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4752 |
-- |
|
| 4753 |
|
|
| 4754 |
ALTER TABLE ONLY usercertification |
|
| 4755 |
ADD CONSTRAINT usercertification_pkey PRIMARY KEY (usercertification_id); |
|
| 4756 |
|
|
| 4757 |
|
|
| 4758 |
-- |
|
| 4759 |
-- Name: userdataset_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4760 |
-- |
|
| 4761 |
|
|
| 4762 |
ALTER TABLE ONLY userdataset |
|
| 4763 |
ADD CONSTRAINT userdataset_pkey PRIMARY KEY (userdataset_id); |
|
| 4764 |
|
|
| 4765 |
|
|
| 4766 |
-- |
|
| 4767 |
-- Name: userdatasetitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4768 |
-- |
|
| 4769 |
|
|
| 4770 |
ALTER TABLE ONLY userdatasetitem |
|
| 4771 |
ADD CONSTRAINT userdatasetitem_pkey PRIMARY KEY (userdatasetitem_id); |
|
| 4772 |
|
|
| 4773 |
|
|
| 4774 |
-- |
|
| 4775 |
-- Name: userdatasetitem_userdataset_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4776 |
-- |
|
| 4777 |
|
|
| 4778 |
ALTER TABLE ONLY userdatasetitem |
|
| 4779 |
ADD CONSTRAINT userdatasetitem_userdataset_id_key UNIQUE (userdataset_id, itemaccessioncode); |
|
| 4780 |
|
|
| 4781 |
|
|
| 4782 |
-- |
|
| 4783 | 3650 |
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4784 | 3651 |
-- |
| 4785 | 3652 |
|
| ... | ... | |
| 4788 | 3655 |
|
| 4789 | 3656 |
|
| 4790 | 3657 |
-- |
| 4791 |
-- Name: usernotify_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4792 |
-- |
|
| 4793 |
|
|
| 4794 |
ALTER TABLE ONLY usernotify |
|
| 4795 |
ADD CONSTRAINT usernotify_pkey PRIMARY KEY (usernotify_id); |
|
| 4796 |
|
|
| 4797 |
|
|
| 4798 |
-- |
|
| 4799 |
-- Name: userpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4800 |
-- |
|
| 4801 |
|
|
| 4802 |
ALTER TABLE ONLY userpermission |
|
| 4803 |
ADD CONSTRAINT userpermission_pkey PRIMARY KEY (userpermission_id); |
|
| 4804 |
|
|
| 4805 |
|
|
| 4806 |
-- |
|
| 4807 |
-- Name: userpreference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4808 |
-- |
|
| 4809 |
|
|
| 4810 |
ALTER TABLE ONLY userpreference |
|
| 4811 |
ADD CONSTRAINT userpreference_pkey PRIMARY KEY (userpreference_id); |
|
| 4812 |
|
|
| 4813 |
|
|
| 4814 |
-- |
|
| 4815 |
-- Name: userquery_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4816 |
-- |
|
| 4817 |
|
|
| 4818 |
ALTER TABLE ONLY userquery |
|
| 4819 |
ADD CONSTRAINT userquery_pkey PRIMARY KEY (userquery_id); |
|
| 4820 |
|
|
| 4821 |
|
|
| 4822 |
-- |
|
| 4823 |
-- Name: userrecordowner_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4824 |
-- |
|
| 4825 |
|
|
| 4826 |
ALTER TABLE ONLY userrecordowner |
|
| 4827 |
ADD CONSTRAINT userrecordowner_pkey PRIMARY KEY (userrecordowner_id); |
|
| 4828 |
|
|
| 4829 |
|
|
| 4830 |
-- |
|
| 4831 |
-- Name: userregionalexp_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4832 |
-- |
|
| 4833 |
|
|
| 4834 |
ALTER TABLE ONLY userregionalexp |
|
| 4835 |
ADD CONSTRAINT userregionalexp_pkey PRIMARY KEY (userregionalexp_id); |
|
| 4836 |
|
|
| 4837 |
|
|
| 4838 |
-- |
|
| 4839 |
-- Name: usr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4840 |
-- |
|
| 4841 |
|
|
| 4842 |
ALTER TABLE ONLY usr |
|
| 4843 |
ADD CONSTRAINT usr_pkey PRIMARY KEY (usr_id); |
|
| 4844 |
|
|
| 4845 |
|
|
| 4846 |
-- |
|
| 4847 | 3658 |
-- Name: voucher_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4848 | 3659 |
-- |
| 4849 | 3660 |
|
| ... | ... | |
| 5112 | 3923 |
|
| 5113 | 3924 |
|
| 5114 | 3925 |
-- |
| 5115 |
-- Name: dba_datacache_key; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5116 |
-- |
|
| 5117 |
|
|
| 5118 |
CREATE UNIQUE INDEX dba_datacache_key ON dba_datacache USING btree (cache_key); |
|
| 5119 |
|
|
| 5120 |
|
|
| 5121 |
-- |
|
| 5122 | 3926 |
-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5123 | 3927 |
-- |
| 5124 | 3928 |
|
| ... | ... | |
| 5385 | 4189 |
|
| 5386 | 4190 |
|
| 5387 | 4191 |
-- |
| 5388 |
-- Name: keywords_table_id_entity_key; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5389 |
-- |
|
| 5390 |
|
|
| 5391 |
CREATE INDEX keywords_table_id_entity_key ON keywords USING btree (table_id, entity); |
|
| 5392 |
|
|
| 5393 |
|
|
| 5394 |
-- |
|
| 5395 | 4192 |
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5396 | 4193 |
-- |
| 5397 | 4194 |
|
| ... | ... | |
| 6036 | 4833 |
|
| 6037 | 4834 |
|
| 6038 | 4835 |
-- |
| 6039 |
-- Name: usercertification_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6040 |
-- |
|
| 6041 |
|
|
| 6042 |
CREATE INDEX usercertification_usr_id_x ON usercertification USING btree (usr_id); |
|
| 6043 |
|
|
| 6044 |
|
|
| 6045 |
-- |
|
| 6046 |
-- Name: userdataset_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6047 |
-- |
|
| 6048 |
|
|
| 6049 |
CREATE UNIQUE INDEX userdataset_accessioncode_index ON userdataset USING btree (accessioncode); |
|
| 6050 |
|
|
| 6051 |
|
|
| 6052 |
-- |
|
| 6053 |
-- Name: userdataset_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6054 |
-- |
|
| 6055 |
|
|
| 6056 |
CREATE INDEX userdataset_usr_id_x ON userdataset USING btree (usr_id); |
|
| 6057 |
|
|
| 6058 |
|
|
| 6059 |
-- |
|
| 6060 |
-- Name: userdatasetitem2_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6061 |
-- |
|
| 6062 |
|
|
| 6063 |
CREATE INDEX userdatasetitem2_accessioncode_index ON userdatasetitem USING btree (externalaccessioncode); |
|
| 6064 |
|
|
| 6065 |
|
|
| 6066 |
-- |
|
| 6067 |
-- Name: userdatasetitem_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6068 |
-- |
|
| 6069 |
|
|
| 6070 |
CREATE INDEX userdatasetitem_accessioncode_index ON userdatasetitem USING btree (itemaccessioncode); |
|
| 6071 |
|
|
| 6072 |
|
|
| 6073 |
-- |
|
| 6074 |
-- Name: userdatasetitem_userdataset_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6075 |
-- |
|
| 6076 |
|
|
| 6077 |
CREATE INDEX userdatasetitem_userdataset_id_x ON userdatasetitem USING btree (userdataset_id); |
|
| 6078 |
|
|
| 6079 |
|
|
| 6080 |
-- |
|
| 6081 | 4836 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6082 | 4837 |
-- |
| 6083 | 4838 |
|
| ... | ... | |
| 6085 | 4840 |
|
| 6086 | 4841 |
|
| 6087 | 4842 |
-- |
| 6088 |
-- Name: usernotify_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6089 |
-- |
|
| 6090 |
|
|
| 6091 |
CREATE INDEX usernotify_usr_id_x ON usernotify USING btree (usr_id); |
|
| 6092 |
|
|
| 6093 |
|
|
| 6094 |
-- |
|
| 6095 |
-- Name: userpermission_embargo_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6096 |
-- |
|
| 6097 |
|
|
| 6098 |
CREATE INDEX userpermission_embargo_id_x ON userpermission USING btree (embargo_id); |
|
| 6099 |
|
|
| 6100 |
|
|
| 6101 |
-- |
|
| 6102 |
-- Name: userpermission_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6103 |
-- |
|
| 6104 |
|
|
| 6105 |
CREATE INDEX userpermission_usr_id_x ON userpermission USING btree (usr_id); |
|
| 6106 |
|
|
| 6107 |
|
|
| 6108 |
-- |
|
| 6109 |
-- Name: userpreference_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6110 |
-- |
|
| 6111 |
|
|
| 6112 |
CREATE INDEX userpreference_usr_id_x ON userpreference USING btree (usr_id); |
|
| 6113 |
|
|
| 6114 |
|
|
| 6115 |
-- |
|
| 6116 |
-- Name: userquery_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6117 |
-- |
|
| 6118 |
|
|
| 6119 |
CREATE UNIQUE INDEX userquery_accessioncode_index ON userquery USING btree (accessioncode); |
|
| 6120 |
|
|
| 6121 |
|
|
| 6122 |
-- |
|
| 6123 |
-- Name: userquery_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6124 |
-- |
|
| 6125 |
|
|
| 6126 |
CREATE INDEX userquery_usr_id_x ON userquery USING btree (usr_id); |
|
| 6127 |
|
|
| 6128 |
|
|
| 6129 |
-- |
|
| 6130 |
-- Name: userrecordowner_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6131 |
-- |
|
| 6132 |
|
|
| 6133 |
CREATE INDEX userrecordowner_usr_id_x ON userrecordowner USING btree (usr_id); |
|
| 6134 |
|
|
| 6135 |
|
|
| 6136 |
-- |
|
| 6137 |
-- Name: userregionalexp_usercertification_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6138 |
-- |
|
| 6139 |
|
|
| 6140 |
CREATE INDEX userregionalexp_usercertification_id_x ON userregionalexp USING btree (usercertification_id); |
|
| 6141 |
|
|
| 6142 |
|
|
| 6143 |
-- |
|
| 6144 |
-- Name: usr_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6145 |
-- |
|
| 6146 |
|
|
| 6147 |
CREATE INDEX usr_party_id_x ON usr USING btree (party_id); |
|
| 6148 |
|
|
| 6149 |
|
|
| 6150 |
-- |
|
| 6151 | 4843 |
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: - |
| 6152 | 4844 |
-- |
| 6153 | 4845 |
|
| ... | ... | |
| 7091 | 5783 |
|
| 7092 | 5784 |
|
| 7093 | 5785 |
-- |
| 7094 |
-- Name: usercertification_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7095 |
-- |
|
| 7096 |
|
|
| 7097 |
ALTER TABLE ONLY usercertification |
|
| 7098 |
ADD CONSTRAINT usercertification_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7099 |
|
|
| 7100 |
|
|
| 7101 |
-- |
|
| 7102 |
-- Name: userdataset_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7103 |
-- |
|
| 7104 |
|
|
| 7105 |
ALTER TABLE ONLY userdataset |
|
| 7106 |
ADD CONSTRAINT userdataset_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7107 |
|
|
| 7108 |
|
|
| 7109 |
-- |
|
| 7110 |
-- Name: userdatasetitem_userdataset_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7111 |
-- |
|
| 7112 |
|
|
| 7113 |
ALTER TABLE ONLY userdatasetitem |
|
| 7114 |
ADD CONSTRAINT userdatasetitem_userdataset_id FOREIGN KEY (userdataset_id) REFERENCES userdataset(userdataset_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7115 |
|
|
| 7116 |
|
|
| 7117 |
-- |
|
| 7118 |
-- Name: usernotify_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7119 |
-- |
|
| 7120 |
|
|
| 7121 |
ALTER TABLE ONLY usernotify |
|
| 7122 |
ADD CONSTRAINT usernotify_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7123 |
|
|
| 7124 |
|
|
| 7125 |
-- |
|
| 7126 |
-- Name: userpermission_embargo_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7127 |
-- |
|
| 7128 |
|
|
| 7129 |
ALTER TABLE ONLY userpermission |
|
| 7130 |
ADD CONSTRAINT userpermission_embargo_id FOREIGN KEY (embargo_id) REFERENCES embargo(embargo_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7131 |
|
|
| 7132 |
|
|
| 7133 |
-- |
|
| 7134 |
-- Name: userpermission_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7135 |
-- |
|
| 7136 |
|
|
| 7137 |
ALTER TABLE ONLY userpermission |
|
| 7138 |
ADD CONSTRAINT userpermission_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7139 |
|
|
| 7140 |
|
|
| 7141 |
-- |
|
| 7142 |
-- Name: userpreference_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7143 |
-- |
|
| 7144 |
|
|
| 7145 |
ALTER TABLE ONLY userpreference |
|
| 7146 |
ADD CONSTRAINT userpreference_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7147 |
|
|
| 7148 |
|
|
| 7149 |
-- |
|
| 7150 |
-- Name: userquery_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7151 |
-- |
|
| 7152 |
|
|
Also available in: Unified diff
vegbien.sql: Removed VegBank-internal tables (including user account tables) because they do not belong in the ecological database. Any web interface should store user account information, cached queries, etc. in a separate interface-specific database.