Revision 1060
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 461 | 461 |
|
| 462 | 462 |
|
| 463 | 463 |
-- |
| 464 |
-- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 465 |
-- |
|
| 466 |
|
|
| 467 |
CREATE TABLE dba_confidentialitystatus ( |
|
| 468 |
confidentialitystatus int(11) NOT NULL, |
|
| 469 |
confidentialitytext text, |
|
| 470 |
confidentialityshorttext text |
|
| 471 |
); |
|
| 472 |
|
|
| 473 |
|
|
| 474 |
-- |
|
| 475 |
-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 476 |
-- |
|
| 477 |
|
|
| 478 |
CREATE TABLE dba_cookie ( |
|
| 479 |
cookie_id int(11) NOT NULL, |
|
| 480 |
cookiename text NOT NULL, |
|
| 481 |
defaultvalue text NOT NULL, |
|
| 482 |
viewname text NOT NULL, |
|
| 483 |
description text, |
|
| 484 |
examplepk int(11) NOT NULL, |
|
| 485 |
sortorder int(11), |
|
| 486 |
startgroup int(1), |
|
| 487 |
prefixhtml text, |
|
| 488 |
suffixhtml text |
|
| 489 |
); |
|
| 490 |
|
|
| 491 |
|
|
| 492 |
-- |
|
| 493 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 494 |
-- |
|
| 495 |
|
|
| 496 |
|
|
| 497 |
|
|
| 498 |
|
|
| 499 |
-- |
|
| 500 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 501 |
-- |
|
| 502 |
|
|
| 503 |
|
|
| 504 |
|
|
| 505 |
|
|
| 506 |
-- |
|
| 507 |
-- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 508 |
-- |
|
| 509 |
|
|
| 510 |
CREATE TABLE dba_cookielabels ( |
|
| 511 |
cookielabel_id int(11) NOT NULL, |
|
| 512 |
vieworcookie text NOT NULL, |
|
| 513 |
description text |
|
| 514 |
); |
|
| 515 |
|
|
| 516 |
|
|
| 517 |
-- |
|
| 518 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 519 |
-- |
|
| 520 |
|
|
| 521 |
|
|
| 522 |
|
|
| 523 |
|
|
| 524 |
-- |
|
| 525 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 526 |
-- |
|
| 527 |
|
|
| 528 |
|
|
| 529 |
|
|
| 530 |
|
|
| 531 |
|
|
| 532 |
|
|
| 533 |
-- |
|
| 534 |
-- Name: dba_datacache; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 535 |
-- |
|
| 536 |
|
|
| 537 |
CREATE TABLE dba_datacache ( |
|
| 538 |
dba_datacache_id int(11) NOT NULL, |
|
| 539 |
cache_key text NOT NULL, |
|
| 540 |
cache_label text, |
|
| 541 |
cache_order double precision, |
|
| 542 |
data1 text, |
|
| 543 |
data2 text, |
|
| 544 |
data3 text, |
|
| 545 |
data4 text, |
|
| 546 |
data5 text, |
|
| 547 |
data6 text, |
|
| 548 |
data7 text, |
|
| 549 |
data8 text, |
|
| 550 |
data9 text, |
|
| 551 |
data10 text |
|
| 552 |
); |
|
| 553 |
|
|
| 554 |
|
|
| 555 |
-- |
|
| 556 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 557 |
-- |
|
| 558 |
|
|
| 559 |
|
|
| 560 |
|
|
| 561 |
|
|
| 562 |
-- |
|
| 563 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 564 |
-- |
|
| 565 |
|
|
| 566 |
|
|
| 567 |
|
|
| 568 |
|
|
| 569 |
-- |
|
| 570 |
-- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 571 |
-- |
|
| 572 |
|
|
| 573 |
CREATE TABLE dba_datamodelversion ( |
|
| 574 |
dba_datamodelversion_id int(11) NOT NULL, |
|
| 575 |
versiontext text NOT NULL, |
|
| 576 |
versionimplemented timestamp NULL |
|
| 577 |
); |
|
| 578 |
|
|
| 579 |
|
|
| 580 |
-- |
|
| 581 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 582 |
-- |
|
| 583 |
|
|
| 584 |
|
|
| 585 |
|
|
| 586 |
|
|
| 587 |
-- |
|
| 588 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 589 |
-- |
|
| 590 |
|
|
| 591 |
|
|
| 592 |
|
|
| 593 |
|
|
| 594 |
|
|
| 595 |
|
|
| 596 |
-- |
|
| 597 |
-- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 598 |
-- |
|
| 599 |
|
|
| 600 |
CREATE TABLE dba_dbstatstime ( |
|
| 601 |
stat_id int(11) NOT NULL, |
|
| 602 |
statdate timestamp NULL, |
|
| 603 |
statpkg int(11), |
|
| 604 |
statname text, |
|
| 605 |
stattable text, |
|
| 606 |
minpk int(11), |
|
| 607 |
maxpk int(11), |
|
| 608 |
countrecs int(11) |
|
| 609 |
); |
|
| 610 |
|
|
| 611 |
|
|
| 612 |
-- |
|
| 613 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 614 |
-- |
|
| 615 |
|
|
| 616 |
|
|
| 617 |
|
|
| 618 |
|
|
| 619 |
-- |
|
| 620 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 621 |
-- |
|
| 622 |
|
|
| 623 |
|
|
| 624 |
|
|
| 625 |
|
|
| 626 |
|
|
| 627 |
|
|
| 628 |
-- |
|
| 629 |
-- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 630 |
-- |
|
| 631 |
|
|
| 632 |
CREATE TABLE dba_fielddescription ( |
|
| 633 |
dba_fielddescription_id int(11) NOT NULL, |
|
| 634 |
tablename text, |
|
| 635 |
fieldname text, |
|
| 636 |
fieldlabel text, |
|
| 637 |
fieldmodel text, |
|
| 638 |
fieldnulls text, |
|
| 639 |
fieldtype text, |
|
| 640 |
fieldkey text, |
|
| 641 |
fieldreferences text, |
|
| 642 |
fieldlist text, |
|
| 643 |
fieldnotes text, |
|
| 644 |
fielddefinition text, |
|
| 645 |
fieldkeywords text |
|
| 646 |
); |
|
| 647 |
|
|
| 648 |
|
|
| 649 |
-- |
|
| 650 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 651 |
-- |
|
| 652 |
|
|
| 653 |
|
|
| 654 |
|
|
| 655 |
|
|
| 656 |
-- |
|
| 657 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 658 |
-- |
|
| 659 |
|
|
| 660 |
|
|
| 661 |
|
|
| 662 |
|
|
| 663 |
-- |
|
| 664 |
-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 665 |
-- |
|
| 666 |
|
|
| 667 |
CREATE TABLE dba_fieldlist ( |
|
| 668 |
dba_fieldlist_id int(11) NOT NULL, |
|
| 669 |
tablename text, |
|
| 670 |
fieldname text, |
|
| 671 |
listvalue text, |
|
| 672 |
listvaluedescription text, |
|
| 673 |
listvaluesortorder double precision |
|
| 674 |
); |
|
| 675 |
|
|
| 676 |
|
|
| 677 |
-- |
|
| 678 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 679 |
-- |
|
| 680 |
|
|
| 681 |
|
|
| 682 |
|
|
| 683 |
|
|
| 684 |
-- |
|
| 685 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 686 |
-- |
|
| 687 |
|
|
| 688 |
|
|
| 689 |
|
|
| 690 |
|
|
| 691 |
-- |
|
| 692 |
-- Name: dba_onerow; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 693 |
-- |
|
| 694 |
|
|
| 695 |
CREATE TABLE dba_onerow ( |
|
| 696 |
dba_onerow_id int(11) NOT NULL |
|
| 697 |
); |
|
| 698 |
|
|
| 699 |
|
|
| 700 |
-- |
|
| 701 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 702 |
-- |
|
| 703 |
|
|
| 704 |
|
|
| 705 |
|
|
| 706 |
|
|
| 707 |
-- |
|
| 708 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 709 |
-- |
|
| 710 |
|
|
| 711 |
|
|
| 712 |
|
|
| 713 |
|
|
| 714 |
-- |
|
| 715 |
-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 716 |
-- |
|
| 717 |
|
|
| 718 |
CREATE TABLE dba_preassignacccode ( |
|
| 719 |
dba_preassignacccode_id int(11) NOT NULL, |
|
| 720 |
dba_requestnumber int(11) NOT NULL, |
|
| 721 |
databasekey text NOT NULL, |
|
| 722 |
tableabbrev text NOT NULL, |
|
| 723 |
confirmcode text NOT NULL, |
|
| 724 |
codeisused int(1), |
|
| 725 |
accessioncode text |
|
| 726 |
); |
|
| 727 |
|
|
| 728 |
|
|
| 729 |
-- |
|
| 730 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 731 |
-- |
|
| 732 |
|
|
| 733 |
|
|
| 734 |
|
|
| 735 |
|
|
| 736 |
-- |
|
| 737 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 738 |
-- |
|
| 739 |
|
|
| 740 |
|
|
| 741 |
|
|
| 742 |
|
|
| 743 |
-- |
|
| 744 | 464 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 745 | 465 |
-- |
| 746 | 466 |
|
| ... | ... | |
| 748 | 468 |
|
| 749 | 469 |
|
| 750 | 470 |
-- |
| 751 |
-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 752 |
-- |
|
| 753 |
|
|
| 754 |
CREATE TABLE dba_tabledescription ( |
|
| 755 |
dba_tabledescription_id int(11) NOT NULL, |
|
| 756 |
tablename text, |
|
| 757 |
tablelabel text, |
|
| 758 |
tablenotes text, |
|
| 759 |
tabledescription text, |
|
| 760 |
tablekeywords text |
|
| 761 |
); |
|
| 762 |
|
|
| 763 |
|
|
| 764 |
-- |
|
| 765 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 766 |
-- |
|
| 767 |
|
|
| 768 |
|
|
| 769 |
|
|
| 770 |
|
|
| 771 |
-- |
|
| 772 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 773 |
-- |
|
| 774 |
|
|
| 775 |
|
|
| 776 |
|
|
| 777 |
|
|
| 778 |
-- |
|
| 779 |
-- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 780 |
-- |
|
| 781 |
|
|
| 782 |
CREATE TABLE dba_xmlcache ( |
|
| 783 |
xml blob, |
|
| 784 |
accessioncode text |
|
| 785 |
); |
|
| 786 |
|
|
| 787 |
|
|
| 788 |
|
|
| 789 |
|
|
| 790 |
-- |
|
| 791 | 471 |
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 792 | 472 |
-- |
| 793 | 473 |
|
| ... | ... | |
| 903 | 583 |
|
| 904 | 584 |
|
| 905 | 585 |
-- |
| 906 |
-- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 907 |
-- |
|
| 908 |
|
|
| 909 |
CREATE TABLE keywords ( |
|
| 910 |
table_id int(11) NOT NULL, |
|
| 911 |
entity text NOT NULL, |
|
| 912 |
keywords text |
|
| 913 |
); |
|
| 914 |
|
|
| 915 |
|
|
| 916 |
-- |
|
| 917 |
-- Name: keywords_extra; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 918 |
-- |
|
| 919 |
|
|
| 920 |
CREATE TABLE keywords_extra ( |
|
| 921 |
table_id int(11) NOT NULL, |
|
| 922 |
entity text NOT NULL, |
|
| 923 |
keywords text |
|
| 924 |
); |
|
| 925 |
|
|
| 926 |
|
|
| 927 |
-- |
|
| 928 | 586 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 929 | 587 |
-- |
| 930 | 588 |
|
| ... | ... | |
| 2499 | 2157 |
|
| 2500 | 2158 |
|
| 2501 | 2159 |
|
| 2502 |
-- |
|
| 2503 |
-- Name: temptbl_std_commnames; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2504 |
-- |
|
| 2505 | 2160 |
|
| 2506 |
CREATE TABLE temptbl_std_commnames ( |
|
| 2507 |
commconcept_id int(11) NOT NULL, |
|
| 2508 |
sciname text, |
|
| 2509 |
translated text, |
|
| 2510 |
code text, |
|
| 2511 |
common text |
|
| 2512 |
); |
|
| 2513 | 2161 |
|
| 2514 |
|
|
| 2515 | 2162 |
-- |
| 2516 |
-- Name: temptbl_std_commnames_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2517 |
-- |
|
| 2518 |
|
|
| 2519 |
|
|
| 2520 |
|
|
| 2521 |
|
|
| 2522 |
-- |
|
| 2523 |
-- Name: temptbl_std_commnames_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2524 |
-- |
|
| 2525 |
|
|
| 2526 |
|
|
| 2527 |
|
|
| 2528 |
|
|
| 2529 |
-- |
|
| 2530 |
-- Name: temptbl_std_plantnames; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2531 |
-- |
|
| 2532 |
|
|
| 2533 |
CREATE TABLE temptbl_std_plantnames ( |
|
| 2534 |
plantconcept_id int(11) NOT NULL, |
|
| 2535 |
plantname text, |
|
| 2536 |
sciname text, |
|
| 2537 |
scinamenoauth text, |
|
| 2538 |
code text, |
|
| 2539 |
common text |
|
| 2540 |
); |
|
| 2541 |
|
|
| 2542 |
|
|
| 2543 |
-- |
|
| 2544 |
-- Name: temptbl_std_plantnames_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2545 |
-- |
|
| 2546 |
|
|
| 2547 |
|
|
| 2548 |
|
|
| 2549 |
|
|
| 2550 |
-- |
|
| 2551 |
-- Name: temptbl_std_plantnames_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2552 |
-- |
|
| 2553 |
|
|
| 2554 |
|
|
| 2555 |
|
|
| 2556 |
|
|
| 2557 |
|
|
| 2558 |
|
|
| 2559 |
-- |
|
| 2560 | 2163 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2561 | 2164 |
-- |
| 2562 | 2165 |
|
| ... | ... | |
| 2585 | 2188 |
|
| 2586 | 2189 |
|
| 2587 | 2190 |
-- |
| 2588 |
-- Name: usercertification; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2589 |
-- |
|
| 2590 |
|
|
| 2591 |
CREATE TABLE usercertification ( |
|
| 2592 |
usercertification_id int(11) NOT NULL, |
|
| 2593 |
usr_id int(11) NOT NULL, |
|
| 2594 |
current_cert_level int(11) NOT NULL, |
|
| 2595 |
requested_cert_level int(11) NOT NULL, |
|
| 2596 |
highest_degree text, |
|
| 2597 |
degree_year text, |
|
| 2598 |
degree_institution text, |
|
| 2599 |
current_org text, |
|
| 2600 |
current_pos text, |
|
| 2601 |
esa_member int(1), |
|
| 2602 |
prof_exp text, |
|
| 2603 |
relevant_pubs text, |
|
| 2604 |
veg_sampling_exp text, |
|
| 2605 |
veg_analysis_exp text, |
|
| 2606 |
usnvc_exp text, |
|
| 2607 |
vb_exp text, |
|
| 2608 |
vb_intention text, |
|
| 2609 |
tools_exp text, |
|
| 2610 |
esa_sponsor_name_a text, |
|
| 2611 |
esa_sponsor_email_a text, |
|
| 2612 |
esa_sponsor_name_b text, |
|
| 2613 |
esa_sponsor_email_b text, |
|
| 2614 |
peer_review int(1), |
|
| 2615 |
addl_stmt text, |
|
| 2616 |
certificationstatus text, |
|
| 2617 |
certificationstatuscomments text, |
|
| 2618 |
exp_region_a text, |
|
| 2619 |
exp_region_b text, |
|
| 2620 |
exp_region_c text, |
|
| 2621 |
exp_region_a_veg text, |
|
| 2622 |
exp_region_b_veg text, |
|
| 2623 |
exp_region_c_veg text, |
|
| 2624 |
exp_region_a_flor text, |
|
| 2625 |
exp_region_b_flor text, |
|
| 2626 |
exp_region_c_flor text, |
|
| 2627 |
exp_region_a_nvc text, |
|
| 2628 |
exp_region_b_nvc text, |
|
| 2629 |
exp_region_c_nvc text |
|
| 2630 |
); |
|
| 2631 |
|
|
| 2632 |
|
|
| 2633 |
-- |
|
| 2634 |
-- Name: usercertification_usercertification_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2635 |
-- |
|
| 2636 |
|
|
| 2637 |
|
|
| 2638 |
|
|
| 2639 |
|
|
| 2640 |
-- |
|
| 2641 |
-- Name: usercertification_usercertification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2642 |
-- |
|
| 2643 |
|
|
| 2644 |
|
|
| 2645 |
|
|
| 2646 |
|
|
| 2647 |
-- |
|
| 2648 |
-- Name: userdataset; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2649 |
-- |
|
| 2650 |
|
|
| 2651 |
CREATE TABLE userdataset ( |
|
| 2652 |
userdataset_id int(11) NOT NULL, |
|
| 2653 |
usr_id int(11), |
|
| 2654 |
datasetname text NOT NULL, |
|
| 2655 |
datasetdescription text, |
|
| 2656 |
datasettype text, |
|
| 2657 |
datasetsharing text, |
|
| 2658 |
datasetpassword text, |
|
| 2659 |
datasetstop timestamp NULL, |
|
| 2660 |
datasetstart timestamp NULL , |
|
| 2661 |
accessioncode text |
|
| 2662 |
); |
|
| 2663 |
|
|
| 2664 |
|
|
| 2665 |
-- |
|
| 2666 |
-- Name: userdataset_userdataset_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2667 |
-- |
|
| 2668 |
|
|
| 2669 |
|
|
| 2670 |
|
|
| 2671 |
|
|
| 2672 |
-- |
|
| 2673 |
-- Name: userdataset_userdataset_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2674 |
-- |
|
| 2675 |
|
|
| 2676 |
|
|
| 2677 |
|
|
| 2678 |
|
|
| 2679 |
-- |
|
| 2680 |
-- Name: userdatasetitem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2681 |
-- |
|
| 2682 |
|
|
| 2683 |
CREATE TABLE userdatasetitem ( |
|
| 2684 |
userdatasetitem_id int(11) NOT NULL, |
|
| 2685 |
userdataset_id int(11) NOT NULL, |
|
| 2686 |
itemaccessioncode text NOT NULL, |
|
| 2687 |
itemtype text, |
|
| 2688 |
notes text, |
|
| 2689 |
itemstart timestamp NULL NOT NULL, |
|
| 2690 |
itemstop timestamp NULL, |
|
| 2691 |
externalaccessioncode text, |
|
| 2692 |
itemdatabase text NOT NULL, |
|
| 2693 |
itemtable text NOT NULL, |
|
| 2694 |
itemrecord int(11) NOT NULL |
|
| 2695 |
); |
|
| 2696 |
|
|
| 2697 |
|
|
| 2698 |
-- |
|
| 2699 |
-- Name: userdatasetitem_userdatasetitem_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2700 |
-- |
|
| 2701 |
|
|
| 2702 |
|
|
| 2703 |
|
|
| 2704 |
|
|
| 2705 |
-- |
|
| 2706 |
-- Name: userdatasetitem_userdatasetitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2707 |
-- |
|
| 2708 |
|
|
| 2709 |
|
|
| 2710 |
|
|
| 2711 |
|
|
| 2712 |
-- |
|
| 2713 | 2191 |
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2714 | 2192 |
-- |
| 2715 | 2193 |
|
| ... | ... | |
| 2738 | 2216 |
|
| 2739 | 2217 |
|
| 2740 | 2218 |
|
| 2741 |
-- |
|
| 2742 |
-- Name: usernotify; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2743 |
-- |
|
| 2744 | 2219 |
|
| 2745 |
CREATE TABLE usernotify ( |
|
| 2746 |
usernotify_id int(11) NOT NULL, |
|
| 2747 |
usr_id int(11) NOT NULL, |
|
| 2748 |
notifyname text, |
|
| 2749 |
notifydescription text, |
|
| 2750 |
notifysql text, |
|
| 2751 |
notifystart timestamp NULL , |
|
| 2752 |
notifystop timestamp NULL, |
|
| 2753 |
lastcheckdate timestamp NULL |
|
| 2754 |
); |
|
| 2755 | 2220 |
|
| 2756 |
|
|
| 2757 | 2221 |
-- |
| 2758 |
-- Name: usernotify_usernotify_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2759 |
-- |
|
| 2760 |
|
|
| 2761 |
|
|
| 2762 |
|
|
| 2763 |
|
|
| 2764 |
-- |
|
| 2765 |
-- Name: usernotify_usernotify_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2766 |
-- |
|
| 2767 |
|
|
| 2768 |
|
|
| 2769 |
|
|
| 2770 |
|
|
| 2771 |
-- |
|
| 2772 |
-- Name: userpermission; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2773 |
-- |
|
| 2774 |
|
|
| 2775 |
CREATE TABLE userpermission ( |
|
| 2776 |
userpermission_id int(11) NOT NULL, |
|
| 2777 |
embargo_id int(11) NOT NULL, |
|
| 2778 |
usr_id int(11) NOT NULL, |
|
| 2779 |
permissionstatus int(11) NOT NULL, |
|
| 2780 |
permissionnotes text, |
|
| 2781 |
permissionstop timestamp NULL, |
|
| 2782 |
permissionstart timestamp NULL NOT NULL |
|
| 2783 |
); |
|
| 2784 |
|
|
| 2785 |
|
|
| 2786 |
-- |
|
| 2787 |
-- Name: userpermission_userpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2788 |
-- |
|
| 2789 |
|
|
| 2790 |
|
|
| 2791 |
|
|
| 2792 |
|
|
| 2793 |
-- |
|
| 2794 |
-- Name: userpermission_userpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2795 |
-- |
|
| 2796 |
|
|
| 2797 |
|
|
| 2798 |
|
|
| 2799 |
|
|
| 2800 |
-- |
|
| 2801 |
-- Name: userpreference; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2802 |
-- |
|
| 2803 |
|
|
| 2804 |
CREATE TABLE userpreference ( |
|
| 2805 |
userpreference_id int(11) NOT NULL, |
|
| 2806 |
usr_id int(11) NOT NULL, |
|
| 2807 |
preferencename text, |
|
| 2808 |
preferencevalue text, |
|
| 2809 |
preferencepriority double precision, |
|
| 2810 |
preferencestop timestamp NULL, |
|
| 2811 |
preferencestart timestamp NULL |
|
| 2812 |
); |
|
| 2813 |
|
|
| 2814 |
|
|
| 2815 |
-- |
|
| 2816 |
-- Name: userpreference_userpreference_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2817 |
-- |
|
| 2818 |
|
|
| 2819 |
|
|
| 2820 |
|
|
| 2821 |
|
|
| 2822 |
-- |
|
| 2823 |
-- Name: userpreference_userpreference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2824 |
-- |
|
| 2825 |
|
|
| 2826 |
|
|
| 2827 |
|
|
| 2828 |
|
|
| 2829 |
-- |
|
| 2830 |
-- Name: userquery; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2831 |
-- |
|
| 2832 |
|
|
| 2833 |
CREATE TABLE userquery ( |
|
| 2834 |
userquery_id int(11) NOT NULL, |
|
| 2835 |
usr_id int(11) NOT NULL, |
|
| 2836 |
queryname text, |
|
| 2837 |
querydescription text, |
|
| 2838 |
querysql text, |
|
| 2839 |
querytype text, |
|
| 2840 |
querysharing text, |
|
| 2841 |
querypassword text, |
|
| 2842 |
querystop timestamp NULL, |
|
| 2843 |
querystart timestamp NULL , |
|
| 2844 |
accessioncode text |
|
| 2845 |
); |
|
| 2846 |
|
|
| 2847 |
|
|
| 2848 |
-- |
|
| 2849 |
-- Name: userquery_userquery_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2850 |
-- |
|
| 2851 |
|
|
| 2852 |
|
|
| 2853 |
|
|
| 2854 |
|
|
| 2855 |
-- |
|
| 2856 |
-- Name: userquery_userquery_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2857 |
-- |
|
| 2858 |
|
|
| 2859 |
|
|
| 2860 |
|
|
| 2861 |
|
|
| 2862 |
-- |
|
| 2863 |
-- Name: userrecordowner; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2864 |
-- |
|
| 2865 |
|
|
| 2866 |
CREATE TABLE userrecordowner ( |
|
| 2867 |
userrecordowner_id int(11) NOT NULL, |
|
| 2868 |
usr_id int(11) NOT NULL, |
|
| 2869 |
tablename text NOT NULL, |
|
| 2870 |
tablerecord int(11) NOT NULL, |
|
| 2871 |
ownertype text NOT NULL, |
|
| 2872 |
recordcreationdate timestamp NOT NULL, |
|
| 2873 |
ownerstop timestamp NULL, |
|
| 2874 |
ownerstart timestamp NULL NOT NULL |
|
| 2875 |
); |
|
| 2876 |
|
|
| 2877 |
|
|
| 2878 |
-- |
|
| 2879 |
-- Name: userrecordowner_userrecordowner_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2880 |
-- |
|
| 2881 |
|
|
| 2882 |
|
|
| 2883 |
|
|
| 2884 |
|
|
| 2885 |
-- |
|
| 2886 |
-- Name: userrecordowner_userrecordowner_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2887 |
-- |
|
| 2888 |
|
|
| 2889 |
|
|
| 2890 |
|
|
| 2891 |
|
|
| 2892 |
-- |
|
| 2893 |
-- Name: userregionalexp; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2894 |
-- |
|
| 2895 |
|
|
| 2896 |
CREATE TABLE userregionalexp ( |
|
| 2897 |
userregionalexp_id int(11) NOT NULL, |
|
| 2898 |
usercertification_id int(11) NOT NULL, |
|
| 2899 |
region text NOT NULL, |
|
| 2900 |
vegetation text, |
|
| 2901 |
floristics text, |
|
| 2902 |
nvc_ivc text |
|
| 2903 |
); |
|
| 2904 |
|
|
| 2905 |
|
|
| 2906 |
-- |
|
| 2907 |
-- Name: userregionalexp_userregionalexp_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2908 |
-- |
|
| 2909 |
|
|
| 2910 |
|
|
| 2911 |
|
|
| 2912 |
|
|
| 2913 |
-- |
|
| 2914 |
-- Name: userregionalexp_userregionalexp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2915 |
-- |
|
| 2916 |
|
|
| 2917 |
|
|
| 2918 |
|
|
| 2919 |
|
|
| 2920 |
-- |
|
| 2921 |
-- Name: usr; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2922 |
-- |
|
| 2923 |
|
|
| 2924 |
CREATE TABLE usr ( |
|
| 2925 |
usr_id int(11) NOT NULL, |
|
| 2926 |
party_id int(11) NOT NULL, |
|
| 2927 |
permission_type int(11) NOT NULL, |
|
| 2928 |
ticket_count int(11), |
|
| 2929 |
email_address text NOT NULL, |
|
| 2930 |
preferred_name text, |
|
| 2931 |
remote_address text, |
|
| 2932 |
last_connect timestamp NULL, |
|
| 2933 |
begin_time timestamp NULL, |
|
| 2934 |
password text |
|
| 2935 |
); |
|
| 2936 |
|
|
| 2937 |
|
|
| 2938 |
-- |
|
| 2939 |
-- Name: usr_usr_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 2940 |
-- |
|
| 2941 |
|
|
| 2942 |
|
|
| 2943 |
|
|
| 2944 |
|
|
| 2945 |
-- |
|
| 2946 |
-- Name: usr_usr_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 2947 |
-- |
|
| 2948 |
|
|
| 2949 |
|
|
| 2950 |
|
|
| 2951 |
|
|
| 2952 |
|
|
| 2953 |
|
|
| 2954 |
-- |
|
| 2955 | 2222 |
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2956 | 2223 |
-- |
| 2957 | 2224 |
|
| ... | ... | |
| 3069 | 2336 |
|
| 3070 | 2337 |
|
| 3071 | 2338 |
-- |
| 3072 |
-- Name: cookie_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3073 |
-- |
|
| 3074 |
|
|
| 3075 |
|
|
| 3076 |
|
|
| 3077 |
|
|
| 3078 |
-- |
|
| 3079 |
-- Name: cookielabel_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3080 |
-- |
|
| 3081 |
|
|
| 3082 |
|
|
| 3083 |
|
|
| 3084 |
|
|
| 3085 |
-- |
|
| 3086 |
-- Name: dba_datacache_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3087 |
-- |
|
| 3088 |
|
|
| 3089 |
|
|
| 3090 |
|
|
| 3091 |
|
|
| 3092 |
-- |
|
| 3093 |
-- Name: dba_datamodelversion_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3094 |
-- |
|
| 3095 |
|
|
| 3096 |
|
|
| 3097 |
|
|
| 3098 |
|
|
| 3099 |
-- |
|
| 3100 |
-- Name: stat_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3101 |
-- |
|
| 3102 |
|
|
| 3103 |
|
|
| 3104 |
|
|
| 3105 |
|
|
| 3106 |
-- |
|
| 3107 |
-- Name: dba_fielddescription_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3108 |
-- |
|
| 3109 |
|
|
| 3110 |
|
|
| 3111 |
|
|
| 3112 |
|
|
| 3113 |
-- |
|
| 3114 |
-- Name: dba_fieldlist_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3115 |
-- |
|
| 3116 |
|
|
| 3117 |
|
|
| 3118 |
|
|
| 3119 |
|
|
| 3120 |
-- |
|
| 3121 |
-- Name: dba_onerow_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3122 |
-- |
|
| 3123 |
|
|
| 3124 |
|
|
| 3125 |
|
|
| 3126 |
|
|
| 3127 |
-- |
|
| 3128 |
-- Name: dba_preassignacccode_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3129 |
-- |
|
| 3130 |
|
|
| 3131 |
|
|
| 3132 |
|
|
| 3133 |
|
|
| 3134 |
-- |
|
| 3135 |
-- Name: dba_tabledescription_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3136 |
-- |
|
| 3137 |
|
|
| 3138 |
|
|
| 3139 |
|
|
| 3140 |
|
|
| 3141 |
-- |
|
| 3142 | 2339 |
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: - |
| 3143 | 2340 |
-- |
| 3144 | 2341 |
|
| ... | ... | |
| 3461 | 2658 |
|
| 3462 | 2659 |
|
| 3463 | 2660 |
-- |
| 3464 |
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3465 |
-- |
|
| 3466 |
|
|
| 3467 |
|
|
| 3468 |
|
|
| 3469 |
|
|
| 3470 |
-- |
|
| 3471 |
-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3472 |
-- |
|
| 3473 |
|
|
| 3474 |
|
|
| 3475 |
|
|
| 3476 |
|
|
| 3477 |
-- |
|
| 3478 | 2661 |
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: - |
| 3479 | 2662 |
-- |
| 3480 | 2663 |
|
| ... | ... | |
| 3482 | 2665 |
|
| 3483 | 2666 |
|
| 3484 | 2667 |
-- |
| 3485 |
-- Name: usercertification_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3486 |
-- |
|
| 3487 |
|
|
| 3488 |
|
|
| 3489 |
|
|
| 3490 |
|
|
| 3491 |
-- |
|
| 3492 |
-- Name: userdataset_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3493 |
-- |
|
| 3494 |
|
|
| 3495 |
|
|
| 3496 |
|
|
| 3497 |
|
|
| 3498 |
-- |
|
| 3499 |
-- Name: userdatasetitem_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3500 |
-- |
|
| 3501 |
|
|
| 3502 |
|
|
| 3503 |
|
|
| 3504 |
|
|
| 3505 |
-- |
|
| 3506 | 2668 |
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: - |
| 3507 | 2669 |
-- |
| 3508 | 2670 |
|
| ... | ... | |
| 3510 | 2672 |
|
| 3511 | 2673 |
|
| 3512 | 2674 |
-- |
| 3513 |
-- Name: usernotify_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3514 |
-- |
|
| 3515 |
|
|
| 3516 |
|
|
| 3517 |
|
|
| 3518 |
|
|
| 3519 |
-- |
|
| 3520 |
-- Name: userpermission_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3521 |
-- |
|
| 3522 |
|
|
| 3523 |
|
|
| 3524 |
|
|
| 3525 |
|
|
| 3526 |
-- |
|
| 3527 |
-- Name: userpreference_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3528 |
-- |
|
| 3529 |
|
|
| 3530 |
|
|
| 3531 |
|
|
| 3532 |
|
|
| 3533 |
-- |
|
| 3534 |
-- Name: userquery_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3535 |
-- |
|
| 3536 |
|
|
| 3537 |
|
|
| 3538 |
|
|
| 3539 |
|
|
| 3540 |
-- |
|
| 3541 |
-- Name: userrecordowner_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3542 |
-- |
|
| 3543 |
|
|
| 3544 |
|
|
| 3545 |
|
|
| 3546 |
|
|
| 3547 |
-- |
|
| 3548 |
-- Name: userregionalexp_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3549 |
-- |
|
| 3550 |
|
|
| 3551 |
|
|
| 3552 |
|
|
| 3553 |
|
|
| 3554 |
-- |
|
| 3555 |
-- Name: usr_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3556 |
-- |
|
| 3557 |
|
|
| 3558 |
|
|
| 3559 |
|
|
| 3560 |
|
|
| 3561 |
-- |
|
| 3562 | 2675 |
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: - |
| 3563 | 2676 |
-- |
| 3564 | 2677 |
|
| ... | ... | |
| 3710 | 2823 |
|
| 3711 | 2824 |
|
| 3712 | 2825 |
-- |
| 3713 |
-- Name: dba_confidentialitystatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3714 |
-- |
|
| 3715 |
|
|
| 3716 |
ALTER TABLE dba_confidentialitystatus |
|
| 3717 |
ADD CONSTRAINT dba_confidentialitystatus_pkey PRIMARY KEY (confidentialitystatus); |
|
| 3718 |
|
|
| 3719 |
|
|
| 3720 |
-- |
|
| 3721 |
-- Name: dba_cookie_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3722 |
-- |
|
| 3723 |
|
|
| 3724 |
ALTER TABLE dba_cookie |
|
| 3725 |
ADD CONSTRAINT dba_cookie_pkey PRIMARY KEY (cookie_id); |
|
| 3726 |
|
|
| 3727 |
|
|
| 3728 |
-- |
|
| 3729 |
-- Name: dba_cookielabels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3730 |
-- |
|
| 3731 |
|
|
| 3732 |
ALTER TABLE dba_cookielabels |
|
| 3733 |
ADD CONSTRAINT dba_cookielabels_pkey PRIMARY KEY (vieworcookie); |
|
| 3734 |
|
|
| 3735 |
|
|
| 3736 |
-- |
|
| 3737 |
-- Name: dba_datacache_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3738 |
-- |
|
| 3739 |
|
|
| 3740 |
ALTER TABLE dba_datacache |
|
| 3741 |
ADD CONSTRAINT dba_datacache_pkey PRIMARY KEY (dba_datacache_id); |
|
| 3742 |
|
|
| 3743 |
|
|
| 3744 |
-- |
|
| 3745 |
-- Name: dba_datamodelversion_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3746 |
-- |
|
| 3747 |
|
|
| 3748 |
ALTER TABLE dba_datamodelversion |
|
| 3749 |
ADD CONSTRAINT dba_datamodelversion_pkey PRIMARY KEY (dba_datamodelversion_id); |
|
| 3750 |
|
|
| 3751 |
|
|
| 3752 |
-- |
|
| 3753 |
-- Name: dba_dbstatstime_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3754 |
-- |
|
| 3755 |
|
|
| 3756 |
ALTER TABLE dba_dbstatstime |
|
| 3757 |
ADD CONSTRAINT dba_dbstatstime_pkey PRIMARY KEY (stat_id); |
|
| 3758 |
|
|
| 3759 |
|
|
| 3760 |
-- |
|
| 3761 |
-- Name: dba_fielddescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3762 |
-- |
|
| 3763 |
|
|
| 3764 |
ALTER TABLE dba_fielddescription |
|
| 3765 |
ADD CONSTRAINT dba_fielddescription_pkey PRIMARY KEY (dba_fielddescription_id); |
|
| 3766 |
|
|
| 3767 |
|
|
| 3768 |
-- |
|
| 3769 |
-- Name: dba_fieldlist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3770 |
-- |
|
| 3771 |
|
|
| 3772 |
ALTER TABLE dba_fieldlist |
|
| 3773 |
ADD CONSTRAINT dba_fieldlist_pkey PRIMARY KEY (dba_fieldlist_id); |
|
| 3774 |
|
|
| 3775 |
|
|
| 3776 |
-- |
|
| 3777 |
-- Name: dba_onerow_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3778 |
-- |
|
| 3779 |
|
|
| 3780 |
ALTER TABLE dba_onerow |
|
| 3781 |
ADD CONSTRAINT dba_onerow_pkey PRIMARY KEY (dba_onerow_id); |
|
| 3782 |
|
|
| 3783 |
|
|
| 3784 |
-- |
|
| 3785 |
-- Name: dba_preassignacccode_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3786 |
-- |
|
| 3787 |
|
|
| 3788 |
ALTER TABLE dba_preassignacccode |
|
| 3789 |
ADD CONSTRAINT dba_preassignacccode_pkey PRIMARY KEY (dba_preassignacccode_id); |
|
| 3790 |
|
|
| 3791 |
|
|
| 3792 |
-- |
|
| 3793 |
-- Name: dba_tabledescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3794 |
-- |
|
| 3795 |
|
|
| 3796 |
ALTER TABLE dba_tabledescription |
|
| 3797 |
ADD CONSTRAINT dba_tabledescription_pkey PRIMARY KEY (dba_tabledescription_id); |
|
| 3798 |
|
|
| 3799 |
|
|
| 3800 |
-- |
|
| 3801 | 2826 |
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3802 | 2827 |
-- |
| 3803 | 2828 |
|
| ... | ... | |
| 4278 | 3303 |
|
| 4279 | 3304 |
|
| 4280 | 3305 |
-- |
| 4281 |
-- Name: temptbl_std_commnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4282 |
-- |
|
| 4283 |
|
|
| 4284 |
ALTER TABLE temptbl_std_commnames |
|
| 4285 |
ADD CONSTRAINT temptbl_std_commnames_pkey PRIMARY KEY (commconcept_id); |
|
| 4286 |
|
|
| 4287 |
|
|
| 4288 |
-- |
|
| 4289 |
-- Name: temptbl_std_plantnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4290 |
-- |
|
| 4291 |
|
|
| 4292 |
ALTER TABLE temptbl_std_plantnames |
|
| 4293 |
ADD CONSTRAINT temptbl_std_plantnames_pkey PRIMARY KEY (plantconcept_id); |
|
| 4294 |
|
|
| 4295 |
|
|
| 4296 |
-- |
|
| 4297 | 3306 |
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4298 | 3307 |
-- |
| 4299 | 3308 |
|
| ... | ... | |
| 4302 | 3311 |
|
| 4303 | 3312 |
|
| 4304 | 3313 |
-- |
| 4305 |
-- Name: usercertification_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4306 |
-- |
|
| 4307 |
|
|
| 4308 |
ALTER TABLE usercertification |
|
| 4309 |
ADD CONSTRAINT usercertification_pkey PRIMARY KEY (usercertification_id); |
|
| 4310 |
|
|
| 4311 |
|
|
| 4312 |
-- |
|
| 4313 |
-- Name: userdataset_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4314 |
-- |
|
| 4315 |
|
|
| 4316 |
ALTER TABLE userdataset |
|
| 4317 |
ADD CONSTRAINT userdataset_pkey PRIMARY KEY (userdataset_id); |
|
| 4318 |
|
|
| 4319 |
|
|
| 4320 |
-- |
|
| 4321 |
-- Name: userdatasetitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4322 |
-- |
|
| 4323 |
|
|
| 4324 |
ALTER TABLE userdatasetitem |
|
| 4325 |
ADD CONSTRAINT userdatasetitem_pkey PRIMARY KEY (userdatasetitem_id); |
|
| 4326 |
|
|
| 4327 |
|
|
| 4328 |
-- |
|
| 4329 |
-- Name: userdatasetitem_userdataset_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4330 |
-- |
|
| 4331 |
|
|
| 4332 |
ALTER TABLE userdatasetitem |
|
| 4333 |
ADD CONSTRAINT userdatasetitem_userdataset_id_key UNIQUE (userdataset_id, itemaccessioncode); |
|
| 4334 |
|
|
| 4335 |
|
|
| 4336 |
-- |
|
| 4337 | 3314 |
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4338 | 3315 |
-- |
| 4339 | 3316 |
|
| ... | ... | |
| 4342 | 3319 |
|
| 4343 | 3320 |
|
| 4344 | 3321 |
-- |
| 4345 |
-- Name: usernotify_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4346 |
-- |
|
| 4347 |
|
|
| 4348 |
ALTER TABLE usernotify |
|
| 4349 |
ADD CONSTRAINT usernotify_pkey PRIMARY KEY (usernotify_id); |
|
| 4350 |
|
|
| 4351 |
|
|
| 4352 |
-- |
|
| 4353 |
-- Name: userpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4354 |
-- |
|
| 4355 |
|
|
| 4356 |
ALTER TABLE userpermission |
|
| 4357 |
ADD CONSTRAINT userpermission_pkey PRIMARY KEY (userpermission_id); |
|
| 4358 |
|
|
| 4359 |
|
|
| 4360 |
-- |
|
| 4361 |
-- Name: userpreference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4362 |
-- |
|
| 4363 |
|
|
| 4364 |
ALTER TABLE userpreference |
|
| 4365 |
ADD CONSTRAINT userpreference_pkey PRIMARY KEY (userpreference_id); |
|
| 4366 |
|
|
| 4367 |
|
|
| 4368 |
-- |
|
| 4369 |
-- Name: userquery_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4370 |
-- |
|
| 4371 |
|
|
| 4372 |
ALTER TABLE userquery |
|
| 4373 |
ADD CONSTRAINT userquery_pkey PRIMARY KEY (userquery_id); |
|
| 4374 |
|
|
| 4375 |
|
|
| 4376 |
-- |
|
| 4377 |
-- Name: userrecordowner_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4378 |
-- |
|
| 4379 |
|
|
| 4380 |
ALTER TABLE userrecordowner |
|
| 4381 |
ADD CONSTRAINT userrecordowner_pkey PRIMARY KEY (userrecordowner_id); |
|
| 4382 |
|
|
| 4383 |
|
|
| 4384 |
-- |
|
| 4385 |
-- Name: userregionalexp_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4386 |
-- |
|
| 4387 |
|
|
| 4388 |
ALTER TABLE userregionalexp |
|
| 4389 |
ADD CONSTRAINT userregionalexp_pkey PRIMARY KEY (userregionalexp_id); |
|
| 4390 |
|
|
| 4391 |
|
|
| 4392 |
-- |
|
| 4393 |
-- Name: usr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4394 |
-- |
|
| 4395 |
|
|
| 4396 |
ALTER TABLE usr |
|
| 4397 |
ADD CONSTRAINT usr_pkey PRIMARY KEY (usr_id); |
|
| 4398 |
|
|
| 4399 |
|
|
| 4400 |
-- |
|
| 4401 | 3322 |
-- Name: voucher_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4402 | 3323 |
-- |
| 4403 | 3324 |
|
| ... | ... | |
| 4666 | 3587 |
|
| 4667 | 3588 |
|
| 4668 | 3589 |
-- |
| 4669 |
-- Name: dba_datacache_key; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4670 |
-- |
|
| 4671 |
|
|
| 4672 |
CREATE UNIQUE INDEX dba_datacache_key ON dba_datacache (cache_key); |
|
| 4673 |
|
|
| 4674 |
|
|
| 4675 |
-- |
|
| 4676 | 3590 |
-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4677 | 3591 |
-- |
| 4678 | 3592 |
|
| ... | ... | |
| 4939 | 3853 |
|
| 4940 | 3854 |
|
| 4941 | 3855 |
-- |
| 4942 |
-- Name: keywords_table_id_entity_key; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4943 |
-- |
|
| 4944 |
|
|
| 4945 |
CREATE INDEX keywords_table_id_entity_key ON keywords (table_id, entity); |
|
| 4946 |
|
|
| 4947 |
|
|
| 4948 |
-- |
|
| 4949 | 3856 |
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4950 | 3857 |
-- |
| 4951 | 3858 |
|
| ... | ... | |
| 5590 | 4497 |
|
| 5591 | 4498 |
|
| 5592 | 4499 |
-- |
| 5593 |
-- Name: usercertification_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5594 |
-- |
|
| 5595 |
|
|
| 5596 |
CREATE INDEX usercertification_usr_id_x ON usercertification (usr_id); |
|
| 5597 |
|
|
| 5598 |
|
|
| 5599 |
-- |
|
| 5600 |
-- Name: userdataset_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5601 |
-- |
|
| 5602 |
|
|
| 5603 |
CREATE UNIQUE INDEX userdataset_accessioncode_index ON userdataset (accessioncode); |
|
| 5604 |
|
|
| 5605 |
|
|
| 5606 |
-- |
|
| 5607 |
-- Name: userdataset_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5608 |
-- |
|
| 5609 |
|
|
| 5610 |
CREATE INDEX userdataset_usr_id_x ON userdataset (usr_id); |
|
| 5611 |
|
|
| 5612 |
|
|
| 5613 |
-- |
|
| 5614 |
-- Name: userdatasetitem2_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5615 |
-- |
|
| 5616 |
|
|
| 5617 |
CREATE INDEX userdatasetitem2_accessioncode_index ON userdatasetitem (externalaccessioncode); |
|
| 5618 |
|
|
| 5619 |
|
|
| 5620 |
-- |
|
| 5621 |
-- Name: userdatasetitem_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5622 |
-- |
|
| 5623 |
|
|
| 5624 |
CREATE INDEX userdatasetitem_accessioncode_index ON userdatasetitem (itemaccessioncode); |
|
| 5625 |
|
|
| 5626 |
|
|
| 5627 |
-- |
|
| 5628 |
-- Name: userdatasetitem_userdataset_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5629 |
-- |
|
| 5630 |
|
|
| 5631 |
CREATE INDEX userdatasetitem_userdataset_id_x ON userdatasetitem (userdataset_id); |
|
| 5632 |
|
|
| 5633 |
|
|
| 5634 |
-- |
|
| 5635 | 4500 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5636 | 4501 |
-- |
| 5637 | 4502 |
|
| ... | ... | |
| 5639 | 4504 |
|
| 5640 | 4505 |
|
| 5641 | 4506 |
-- |
| 5642 |
-- Name: usernotify_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5643 |
-- |
|
| 5644 |
|
|
| 5645 |
CREATE INDEX usernotify_usr_id_x ON usernotify (usr_id); |
|
| 5646 |
|
|
| 5647 |
|
|
| 5648 |
-- |
|
| 5649 |
-- Name: userpermission_embargo_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5650 |
-- |
|
| 5651 |
|
|
| 5652 |
CREATE INDEX userpermission_embargo_id_x ON userpermission (embargo_id); |
|
| 5653 |
|
|
| 5654 |
|
|
| 5655 |
-- |
|
| 5656 |
-- Name: userpermission_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5657 |
-- |
|
| 5658 |
|
|
| 5659 |
CREATE INDEX userpermission_usr_id_x ON userpermission (usr_id); |
|
| 5660 |
|
|
| 5661 |
|
|
| 5662 |
-- |
|
| 5663 |
-- Name: userpreference_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5664 |
-- |
|
| 5665 |
|
|
| 5666 |
CREATE INDEX userpreference_usr_id_x ON userpreference (usr_id); |
|
| 5667 |
|
|
| 5668 |
|
|
| 5669 |
-- |
|
| 5670 |
-- Name: userquery_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5671 |
-- |
|
| 5672 |
|
|
| 5673 |
CREATE UNIQUE INDEX userquery_accessioncode_index ON userquery (accessioncode); |
|
| 5674 |
|
|
| 5675 |
|
|
| 5676 |
-- |
|
| 5677 |
-- Name: userquery_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5678 |
-- |
|
| 5679 |
|
|
| 5680 |
CREATE INDEX userquery_usr_id_x ON userquery (usr_id); |
|
| 5681 |
|
|
| 5682 |
|
|
| 5683 |
-- |
|
| 5684 |
-- Name: userrecordowner_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5685 |
-- |
|
| 5686 |
|
|
| 5687 |
CREATE INDEX userrecordowner_usr_id_x ON userrecordowner (usr_id); |
|
| 5688 |
|
|
| 5689 |
|
|
| 5690 |
-- |
|
| 5691 |
-- Name: userregionalexp_usercertification_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5692 |
-- |
|
| 5693 |
|
|
| 5694 |
CREATE INDEX userregionalexp_usercertification_id_x ON userregionalexp (usercertification_id); |
|
| 5695 |
|
|
| 5696 |
|
|
| 5697 |
-- |
|
| 5698 |
-- Name: usr_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5699 |
-- |
|
| 5700 |
|
|
| 5701 |
CREATE INDEX usr_party_id_x ON usr (party_id); |
|
| 5702 |
|
|
| 5703 |
|
|
| 5704 |
-- |
|
| 5705 | 4507 |
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: - |
| 5706 | 4508 |
-- |
| 5707 | 4509 |
|
| ... | ... | |
| 6617 | 5419 |
|
| 6618 | 5420 |
|
| 6619 | 5421 |
-- |
| 6620 |
-- Name: usercertification_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6621 |
-- |
|
| 6622 |
|
|
| 6623 |
ALTER TABLE usercertification |
|
| 6624 |
ADD CONSTRAINT usercertification_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6625 |
|
|
| 6626 |
|
|
| 6627 |
-- |
|
| 6628 |
-- Name: userdataset_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6629 |
-- |
|
| 6630 |
|
|
| 6631 |
ALTER TABLE userdataset |
|
| 6632 |
ADD CONSTRAINT userdataset_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6633 |
|
|
| 6634 |
|
|
| 6635 |
-- |
|
| 6636 |
-- Name: userdatasetitem_userdataset_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6637 |
-- |
|
| 6638 |
|
|
| 6639 |
ALTER TABLE userdatasetitem |
|
| 6640 |
ADD CONSTRAINT userdatasetitem_userdataset_id FOREIGN KEY (userdataset_id) REFERENCES userdataset(userdataset_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6641 |
|
|
| 6642 |
|
|
| 6643 |
-- |
|
| 6644 |
-- Name: usernotify_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6645 |
-- |
|
| 6646 |
|
|
| 6647 |
ALTER TABLE usernotify |
|
| 6648 |
ADD CONSTRAINT usernotify_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6649 |
|
|
| 6650 |
|
|
| 6651 |
-- |
|
| 6652 |
-- Name: userpermission_embargo_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6653 |
-- |
|
| 6654 |
|
|
| 6655 |
ALTER TABLE userpermission |
|
| 6656 |
ADD CONSTRAINT userpermission_embargo_id FOREIGN KEY (embargo_id) REFERENCES embargo(embargo_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6657 |
|
|
| 6658 |
|
|
| 6659 |
-- |
|
| 6660 |
-- Name: userpermission_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6661 |
-- |
|
| 6662 |
|
|
| 6663 |
ALTER TABLE userpermission |
|
| 6664 |
ADD CONSTRAINT userpermission_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6665 |
|
|
| 6666 |
|
|
| 6667 |
-- |
|
| 6668 |
-- Name: userpreference_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6669 |
-- |
|
| 6670 |
|
|
| 6671 |
ALTER TABLE userpreference |
|
| 6672 |
ADD CONSTRAINT userpreference_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6673 |
|
|
| 6674 |
|
|
| 6675 |
-- |
|
| 6676 |
-- Name: userquery_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6677 |
-- |
|
| 6678 |
|
|
| 6679 |
ALTER TABLE userquery |
|
| 6680 |
ADD CONSTRAINT userquery_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6681 |
|
|
| 6682 |
|
|
| 6683 |
-- |
|
| 6684 |
-- Name: userrecordowner_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6685 |
-- |
|
| 6686 |
|
|
| 6687 |
ALTER TABLE userrecordowner |
|
| 6688 |
ADD CONSTRAINT userrecordowner_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6689 |
|
|
| 6690 |
|
|
| 6691 |
-- |
|
| 6692 |
-- Name: userregionalexp_usercertification_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6693 |
-- |
|
| 6694 |
|
|
| 6695 |
ALTER TABLE userregionalexp |
|
| 6696 |
ADD CONSTRAINT userregionalexp_usercertification_id FOREIGN KEY (usercertification_id) REFERENCES usercertification(usercertification_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6697 |
|
|
| 6698 |
|
|
| 6699 |
-- |
|
| 6700 |
-- Name: usr_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6701 |
-- |
|
| 6702 |
|
|
| 6703 |
|
|
| 6704 |
|
|
| 6705 |
|
|
| 6706 |
-- |
|
| 6707 | 5422 |
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6708 | 5423 |
-- |
| 6709 | 5424 |
|
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.