Revision ca247333
Von Moritz Bunkus vor etwa 4 Jahren hinzugefügt
| sql/lx-office.sql | ||
|---|---|---|
| 3 | 3 |
-- |
| 4 | 4 |
|
| 5 | 5 |
-- |
| 6 |
-- TOC entry 5 (OID 1981863) |
|
| 7 | 6 |
-- Name: id; Type: SEQUENCE; Schema: public; Owner: postgres |
| 8 | 7 |
-- |
| 9 | 8 |
|
| ... | ... | |
| 15 | 14 |
|
| 16 | 15 |
|
| 17 | 16 |
-- |
| 18 |
-- TOC entry 7 (OID 1981865) |
|
| 19 | 17 |
-- Name: glid; Type: SEQUENCE; Schema: public; Owner: postgres |
| 20 | 18 |
-- |
| 21 | 19 |
|
| ... | ... | |
| 28 | 26 |
|
| 29 | 27 |
|
| 30 | 28 |
-- |
| 31 |
-- TOC entry 13 (OID 1981867) |
|
| 32 | 29 |
-- Name: gl; Type: TABLE; Schema: public; Owner: postgres |
| 33 | 30 |
-- |
| 34 | 31 |
|
| ... | ... | |
| 49 | 46 |
|
| 50 | 47 |
|
| 51 | 48 |
-- |
| 52 |
-- TOC entry 14 (OID 1981879) |
|
| 53 | 49 |
-- Name: chart; Type: TABLE; Schema: public; Owner: postgres |
| 54 | 50 |
-- |
| 55 | 51 |
|
| ... | ... | |
| 75 | 71 |
|
| 76 | 72 |
|
| 77 | 73 |
-- |
| 78 |
-- TOC entry 15 (OID 1981890) |
|
| 79 | 74 |
-- Name: datev; Type: TABLE; Schema: public; Owner: postgres |
| 80 | 75 |
-- |
| 81 | 76 |
|
| ... | ... | |
| 92 | 87 |
|
| 93 | 88 |
|
| 94 | 89 |
-- |
| 95 |
-- TOC entry 16 (OID 1981893) |
|
| 96 | 90 |
-- Name: gifi; Type: TABLE; Schema: public; Owner: postgres |
| 97 | 91 |
-- |
| 98 | 92 |
|
| ... | ... | |
| 103 | 97 |
|
| 104 | 98 |
|
| 105 | 99 |
-- |
| 106 |
-- TOC entry 17 (OID 1981898) |
|
| 107 | 100 |
-- Name: parts; Type: TABLE; Schema: public; Owner: postgres |
| 108 | 101 |
-- |
| 109 | 102 |
|
| ... | ... | |
| 142 | 135 |
not_discountable boolean DEFAULT false, |
| 143 | 136 |
buchungsgruppen_id integer, |
| 144 | 137 |
payment_id integer |
| 145 |
) WITH OIDS;
|
|
| 138 |
); |
|
| 146 | 139 |
|
| 147 | 140 |
|
| 148 | 141 |
-- |
| 149 |
-- TOC entry 18 (OID 1981915) |
|
| 150 | 142 |
-- Name: defaults; Type: TABLE; Schema: public; Owner: postgres |
| 151 | 143 |
-- |
| 152 | 144 |
|
| ... | ... | |
| 185 | 177 |
|
| 186 | 178 |
|
| 187 | 179 |
-- |
| 188 |
-- TOC entry 19 (OID 1981924) |
|
| 189 | 180 |
-- Name: audittrail; Type: TABLE; Schema: public; Owner: postgres |
| 190 | 181 |
-- |
| 191 | 182 |
|
| ... | ... | |
| 201 | 192 |
|
| 202 | 193 |
|
| 203 | 194 |
-- |
| 204 |
-- TOC entry 20 (OID 1981930) |
|
| 205 | 195 |
-- Name: acc_trans; Type: TABLE; Schema: public; Owner: postgres |
| 206 | 196 |
-- |
| 207 | 197 |
|
| ... | ... | |
| 219 | 209 |
taxkey integer, |
| 220 | 210 |
itime timestamp without time zone DEFAULT now(), |
| 221 | 211 |
mtime timestamp without time zone |
| 222 |
) WITH OIDS;
|
|
| 212 |
); |
|
| 223 | 213 |
|
| 224 | 214 |
|
| 225 | 215 |
-- |
| 226 |
-- TOC entry 21 (OID 1981944) |
|
| 227 | 216 |
-- Name: invoice; Type: TABLE; Schema: public; Owner: postgres |
| 228 | 217 |
-- |
| 229 | 218 |
|
| ... | ... | |
| 251 | 240 |
base_qty real, |
| 252 | 241 |
subtotal boolean DEFAULT false, |
| 253 | 242 |
longdescription text |
| 254 |
) WITH OIDS;
|
|
| 243 |
); |
|
| 255 | 244 |
|
| 256 | 245 |
|
| 257 | 246 |
-- |
| 258 |
-- TOC entry 22 (OID 1981958) |
|
| 259 | 247 |
-- Name: vendor; Type: TABLE; Schema: public; Owner: postgres |
| 260 | 248 |
-- |
| 261 | 249 |
|
| ... | ... | |
| 306 | 294 |
|
| 307 | 295 |
|
| 308 | 296 |
-- |
| 309 |
-- TOC entry 23 (OID 1981969) |
|
| 310 | 297 |
-- Name: customer; Type: TABLE; Schema: public; Owner: postgres |
| 311 | 298 |
-- |
| 312 | 299 |
|
| ... | ... | |
| 357 | 344 |
|
| 358 | 345 |
|
| 359 | 346 |
-- |
| 360 |
-- TOC entry 24 (OID 1981982) |
|
| 361 | 347 |
-- Name: contacts; Type: TABLE; Schema: public; Owner: postgres |
| 362 | 348 |
-- |
| 363 | 349 |
|
| ... | ... | |
| 387 | 373 |
|
| 388 | 374 |
|
| 389 | 375 |
-- |
| 390 |
-- TOC entry 25 (OID 1981991) |
|
| 391 | 376 |
-- Name: assembly; Type: TABLE; Schema: public; Owner: postgres |
| 392 | 377 |
-- |
| 393 | 378 |
|
| ... | ... | |
| 398 | 383 |
bom boolean, |
| 399 | 384 |
itime timestamp without time zone DEFAULT now(), |
| 400 | 385 |
mtime timestamp without time zone |
| 401 |
) WITH OIDS;
|
|
| 386 |
); |
|
| 402 | 387 |
|
| 403 | 388 |
|
| 404 | 389 |
-- |
| 405 |
-- TOC entry 26 (OID 1981994) |
|
| 406 | 390 |
-- Name: ar; Type: TABLE; Schema: public; Owner: postgres |
| 407 | 391 |
-- |
| 408 | 392 |
|
| ... | ... | |
| 447 | 431 |
|
| 448 | 432 |
|
| 449 | 433 |
-- |
| 450 |
-- TOC entry 27 (OID 1982012) |
|
| 451 | 434 |
-- Name: ap; Type: TABLE; Schema: public; Owner: postgres |
| 452 | 435 |
-- |
| 453 | 436 |
|
| ... | ... | |
| 484 | 467 |
|
| 485 | 468 |
|
| 486 | 469 |
-- |
| 487 |
-- TOC entry 28 (OID 1982030) |
|
| 488 | 470 |
-- Name: partstax; Type: TABLE; Schema: public; Owner: postgres |
| 489 | 471 |
-- |
| 490 | 472 |
|
| ... | ... | |
| 497 | 479 |
|
| 498 | 480 |
|
| 499 | 481 |
-- |
| 500 |
-- TOC entry 29 (OID 1982033) |
|
| 501 | 482 |
-- Name: tax; Type: TABLE; Schema: public; Owner: postgres |
| 502 | 483 |
-- |
| 503 | 484 |
|
| ... | ... | |
| 514 | 495 |
|
| 515 | 496 |
|
| 516 | 497 |
-- |
| 517 |
-- TOC entry 30 (OID 1982039) |
|
| 518 | 498 |
-- Name: customertax; Type: TABLE; Schema: public; Owner: postgres |
| 519 | 499 |
-- |
| 520 | 500 |
|
| ... | ... | |
| 527 | 507 |
|
| 528 | 508 |
|
| 529 | 509 |
-- |
| 530 |
-- TOC entry 31 (OID 1982042) |
|
| 531 | 510 |
-- Name: vendortax; Type: TABLE; Schema: public; Owner: postgres |
| 532 | 511 |
-- |
| 533 | 512 |
|
| ... | ... | |
| 540 | 519 |
|
| 541 | 520 |
|
| 542 | 521 |
-- |
| 543 |
-- TOC entry 32 (OID 1982045) |
|
| 544 | 522 |
-- Name: oe; Type: TABLE; Schema: public; Owner: postgres |
| 545 | 523 |
-- |
| 546 | 524 |
|
| ... | ... | |
| 579 | 557 |
|
| 580 | 558 |
|
| 581 | 559 |
-- |
| 582 |
-- TOC entry 33 (OID 1982058) |
|
| 583 | 560 |
-- Name: orderitems; Type: TABLE; Schema: public; Owner: postgres |
| 584 | 561 |
-- |
| 585 | 562 |
|
| ... | ... | |
| 605 | 582 |
base_qty real, |
| 606 | 583 |
subtotal boolean DEFAULT false, |
| 607 | 584 |
longdescription text |
| 608 |
) WITH OIDS;
|
|
| 585 |
); |
|
| 609 | 586 |
|
| 610 | 587 |
|
| 611 | 588 |
-- |
| 612 |
-- TOC entry 34 (OID 1982069) |
|
| 613 | 589 |
-- Name: exchangerate; Type: TABLE; Schema: public; Owner: postgres |
| 614 | 590 |
-- |
| 615 | 591 |
|
| ... | ... | |
| 624 | 600 |
|
| 625 | 601 |
|
| 626 | 602 |
-- |
| 627 |
-- TOC entry 35 (OID 1982072) |
|
| 628 | 603 |
-- Name: employee; Type: TABLE; Schema: public; Owner: postgres |
| 629 | 604 |
-- |
| 630 | 605 |
|
| ... | ... | |
| 649 | 624 |
|
| 650 | 625 |
|
| 651 | 626 |
-- |
| 652 |
-- TOC entry 36 (OID 1982083) |
|
| 653 | 627 |
-- Name: shipto; Type: TABLE; Schema: public; Owner: postgres |
| 654 | 628 |
-- |
| 655 | 629 |
|
| ... | ... | |
| 674 | 648 |
|
| 675 | 649 |
|
| 676 | 650 |
-- |
| 677 |
-- TOC entry 37 (OID 1982089) |
|
| 678 | 651 |
-- Name: project; Type: TABLE; Schema: public; Owner: postgres |
| 679 | 652 |
-- |
| 680 | 653 |
|
| ... | ... | |
| 688 | 661 |
|
| 689 | 662 |
|
| 690 | 663 |
-- |
| 691 |
-- TOC entry 38 (OID 1982100) |
|
| 692 | 664 |
-- Name: partsgroup; Type: TABLE; Schema: public; Owner: postgres |
| 693 | 665 |
-- |
| 694 | 666 |
|
| ... | ... | |
| 697 | 669 |
partsgroup text, |
| 698 | 670 |
itime timestamp without time zone DEFAULT now(), |
| 699 | 671 |
mtime timestamp without time zone |
| 700 |
) WITH OIDS;
|
|
| 672 |
); |
|
| 701 | 673 |
|
| 702 | 674 |
|
| 703 | 675 |
-- |
| 704 |
-- TOC entry 39 (OID 1982107) |
|
| 705 | 676 |
-- Name: makemodel; Type: TABLE; Schema: public; Owner: postgres |
| 706 | 677 |
-- |
| 707 | 678 |
|
| ... | ... | |
| 715 | 686 |
|
| 716 | 687 |
|
| 717 | 688 |
-- |
| 718 |
-- TOC entry 40 (OID 1982113) |
|
| 719 | 689 |
-- Name: status; Type: TABLE; Schema: public; Owner: postgres |
| 720 | 690 |
-- |
| 721 | 691 |
|
| ... | ... | |
| 732 | 702 |
|
| 733 | 703 |
|
| 734 | 704 |
-- |
| 735 |
-- TOC entry 9 (OID 1982121) |
|
| 736 | 705 |
-- Name: invoiceid; Type: SEQUENCE; Schema: public; Owner: postgres |
| 737 | 706 |
-- |
| 738 | 707 |
|
| ... | ... | |
| 745 | 714 |
|
| 746 | 715 |
|
| 747 | 716 |
-- |
| 748 |
-- TOC entry 11 (OID 1982123) |
|
| 749 | 717 |
-- Name: orderitemsid; Type: SEQUENCE; Schema: public; Owner: postgres |
| 750 | 718 |
-- |
| 751 | 719 |
|
| ... | ... | |
| 759 | 727 |
|
| 760 | 728 |
|
| 761 | 729 |
-- |
| 762 |
-- TOC entry 41 (OID 1982125) |
|
| 763 | 730 |
-- Name: warehouse; Type: TABLE; Schema: public; Owner: postgres |
| 764 | 731 |
-- |
| 765 | 732 |
|
| ... | ... | |
| 772 | 739 |
|
| 773 | 740 |
|
| 774 | 741 |
-- |
| 775 |
-- TOC entry 42 (OID 1982134) |
|
| 776 | 742 |
-- Name: inventory; Type: TABLE; Schema: public; Owner: postgres |
| 777 | 743 |
-- |
| 778 | 744 |
|
| ... | ... | |
| 790 | 756 |
|
| 791 | 757 |
|
| 792 | 758 |
-- |
| 793 |
-- TOC entry 43 (OID 1982137) |
|
| 794 | 759 |
-- Name: department; Type: TABLE; Schema: public; Owner: postgres |
| 795 | 760 |
-- |
| 796 | 761 |
|
| ... | ... | |
| 804 | 769 |
|
| 805 | 770 |
|
| 806 | 771 |
-- |
| 807 |
-- TOC entry 44 (OID 1982145) |
|
| 808 | 772 |
-- Name: dpt_trans; Type: TABLE; Schema: public; Owner: postgres |
| 809 | 773 |
-- |
| 810 | 774 |
|
| ... | ... | |
| 817 | 781 |
|
| 818 | 782 |
|
| 819 | 783 |
-- |
| 820 |
-- TOC entry 45 (OID 1982148) |
|
| 821 | 784 |
-- Name: business; Type: TABLE; Schema: public; Owner: postgres |
| 822 | 785 |
-- |
| 823 | 786 |
|
| ... | ... | |
| 833 | 796 |
|
| 834 | 797 |
|
| 835 | 798 |
-- |
| 836 |
-- TOC entry 46 (OID 1982158) |
|
| 837 | 799 |
-- Name: sic; Type: TABLE; Schema: public; Owner: postgres |
| 838 | 800 |
-- |
| 839 | 801 |
|
| ... | ... | |
| 847 | 809 |
|
| 848 | 810 |
|
| 849 | 811 |
-- |
| 850 |
-- TOC entry 47 (OID 1982164) |
|
| 851 | 812 |
-- Name: license; Type: TABLE; Schema: public; Owner: postgres |
| 852 | 813 |
-- |
| 853 | 814 |
|
| ... | ... | |
| 864 | 825 |
|
| 865 | 826 |
|
| 866 | 827 |
-- |
| 867 |
-- TOC entry 48 (OID 1982174) |
|
| 868 | 828 |
-- Name: licenseinvoice; Type: TABLE; Schema: public; Owner: postgres |
| 869 | 829 |
-- |
| 870 | 830 |
|
| ... | ... | |
| 875 | 835 |
|
| 876 | 836 |
|
| 877 | 837 |
-- |
| 878 |
-- TOC entry 49 (OID 1982176) |
|
| 879 | 838 |
-- Name: pricegroup; Type: TABLE; Schema: public; Owner: postgres |
| 880 | 839 |
-- |
| 881 | 840 |
|
| ... | ... | |
| 886 | 845 |
|
| 887 | 846 |
|
| 888 | 847 |
-- |
| 889 |
-- TOC entry 50 (OID 1982184) |
|
| 890 | 848 |
-- Name: prices; Type: TABLE; Schema: public; Owner: postgres |
| 891 | 849 |
-- |
| 892 | 850 |
|
| ... | ... | |
| 898 | 856 |
|
| 899 | 857 |
|
| 900 | 858 |
-- |
| 901 |
-- TOC entry 51 (OID 1982194) |
|
| 902 | 859 |
-- Name: finanzamt; Type: TABLE; Schema: public; Owner: postgres |
| 903 | 860 |
-- |
| 904 | 861 |
|
| ... | ... | |
| 927 | 884 |
|
| 928 | 885 |
|
| 929 | 886 |
-- |
| 930 |
-- TOC entry 157 (OID 1982885) |
|
| 931 | 887 |
-- Name: check_department(); Type: FUNCTION; Schema: public; Owner: postgres |
| 932 | 888 |
-- |
| 933 | 889 |
|
| ... | ... | |
| 937 | 893 |
|
| 938 | 894 |
|
| 939 | 895 |
-- |
| 940 |
-- TOC entry 158 (OID 1982886) |
|
| 941 | 896 |
-- Name: del_department(); Type: FUNCTION; Schema: public; Owner: postgres |
| 942 | 897 |
-- |
| 943 | 898 |
|
| ... | ... | |
| 947 | 902 |
|
| 948 | 903 |
|
| 949 | 904 |
-- |
| 950 |
-- TOC entry 159 (OID 1982887) |
|
| 951 | 905 |
-- Name: del_customer(); Type: FUNCTION; Schema: public; Owner: postgres |
| 952 | 906 |
-- |
| 953 | 907 |
|
| ... | ... | |
| 957 | 911 |
|
| 958 | 912 |
|
| 959 | 913 |
-- |
| 960 |
-- TOC entry 160 (OID 1982888) |
|
| 961 | 914 |
-- Name: del_vendor(); Type: FUNCTION; Schema: public; Owner: postgres |
| 962 | 915 |
-- |
| 963 | 916 |
|
| ... | ... | |
| 967 | 920 |
|
| 968 | 921 |
|
| 969 | 922 |
-- |
| 970 |
-- TOC entry 161 (OID 1982889) |
|
| 971 | 923 |
-- Name: del_exchangerate(); Type: FUNCTION; Schema: public; Owner: postgres |
| 972 | 924 |
-- |
| 973 | 925 |
|
| ... | ... | |
| 977 | 929 |
|
| 978 | 930 |
|
| 979 | 931 |
-- |
| 980 |
-- TOC entry 162 (OID 1982890) |
|
| 981 | 932 |
-- Name: check_inventory(); Type: FUNCTION; Schema: public; Owner: postgres |
| 982 | 933 |
-- |
| 983 | 934 |
|
| ... | ... | |
| 987 | 938 |
|
| 988 | 939 |
|
| 989 | 940 |
-- |
| 990 |
-- TOC entry 163 (OID 1982968) |
|
| 991 | 941 |
-- Name: set_datevexport(); Type: FUNCTION; Schema: public; Owner: postgres |
| 992 | 942 |
-- |
| 993 | 943 |
|
| ... | ... | |
| 997 | 947 |
|
| 998 | 948 |
|
| 999 | 949 |
-- |
| 1000 |
-- TOC entry 164 (OID 1982971) |
|
| 1001 | 950 |
-- Name: set_mtime(); Type: FUNCTION; Schema: public; Owner: postgres |
| 1002 | 951 |
-- |
| 1003 | 952 |
|
| ... | ... | |
| 1007 | 956 |
|
| 1008 | 957 |
|
| 1009 | 958 |
-- |
| 1010 |
-- TOC entry 52 (OID 1983721) |
|
| 1011 | 959 |
-- Name: language; Type: TABLE; Schema: public; Owner: postgres |
| 1012 | 960 |
-- |
| 1013 | 961 |
|
| ... | ... | |
| 1022 | 970 |
|
| 1023 | 971 |
|
| 1024 | 972 |
-- |
| 1025 |
-- TOC entry 53 (OID 1983730) |
|
| 1026 | 973 |
-- Name: payment_terms; Type: TABLE; Schema: public; Owner: postgres |
| 1027 | 974 |
-- |
| 1028 | 975 |
|
| ... | ... | |
| 1040 | 987 |
|
| 1041 | 988 |
|
| 1042 | 989 |
-- |
| 1043 |
-- TOC entry 54 (OID 1983739) |
|
| 1044 | 990 |
-- Name: translation; Type: TABLE; Schema: public; Owner: postgres |
| 1045 | 991 |
-- |
| 1046 | 992 |
|
| ... | ... | |
| 1055 | 1001 |
|
| 1056 | 1002 |
|
| 1057 | 1003 |
-- |
| 1058 |
-- TOC entry 55 (OID 1983745) |
|
| 1059 | 1004 |
-- Name: units; Type: TABLE; Schema: public; Owner: postgres |
| 1060 | 1005 |
-- |
| 1061 | 1006 |
|
| ... | ... | |
| 1068 | 1013 |
|
| 1069 | 1014 |
|
| 1070 | 1015 |
-- |
| 1071 |
-- TOC entry 56 (OID 1983761) |
|
| 1072 | 1016 |
-- Name: rma; Type: TABLE; Schema: public; Owner: postgres |
| 1073 | 1017 |
-- |
| 1074 | 1018 |
|
| ... | ... | |
| 1104 | 1048 |
|
| 1105 | 1049 |
|
| 1106 | 1050 |
-- |
| 1107 |
-- TOC entry 57 (OID 1983774) |
|
| 1108 | 1051 |
-- Name: rmaitems; Type: TABLE; Schema: public; Owner: postgres |
| 1109 | 1052 |
-- |
| 1110 | 1053 |
|
| ... | ... | |
| 1132 | 1075 |
|
| 1133 | 1076 |
|
| 1134 | 1077 |
-- |
| 1135 |
-- TOC entry 58 (OID 1983785) |
|
| 1136 | 1078 |
-- Name: printers; Type: TABLE; Schema: public; Owner: postgres |
| 1137 | 1079 |
-- |
| 1138 | 1080 |
|
| ... | ... | |
| 1145 | 1087 |
|
| 1146 | 1088 |
|
| 1147 | 1089 |
-- |
| 1148 |
-- TOC entry 59 (OID 1983798) |
|
| 1149 | 1090 |
-- Name: tax_zones; Type: TABLE; Schema: public; Owner: postgres |
| 1150 | 1091 |
-- |
| 1151 | 1092 |
|
| ... | ... | |
| 1156 | 1097 |
|
| 1157 | 1098 |
|
| 1158 | 1099 |
-- |
| 1159 |
-- TOC entry 60 (OID 1983807) |
|
| 1160 | 1100 |
-- Name: buchungsgruppen; Type: TABLE; Schema: public; Owner: postgres |
| 1161 | 1101 |
-- |
| 1162 | 1102 |
|
| ... | ... | |
| 1176 | 1116 |
|
| 1177 | 1117 |
|
| 1178 | 1118 |
-- |
| 1179 |
-- TOC entry 61 (OID 1983825) |
|
| 1180 | 1119 |
-- Name: dunning_config; Type: TABLE; Schema: public; Owner: postgres |
| 1181 | 1120 |
-- |
| 1182 | 1121 |
|
| ... | ... | |
| 1199 | 1138 |
|
| 1200 | 1139 |
|
| 1201 | 1140 |
-- |
| 1202 |
-- TOC entry 62 (OID 1983833) |
|
| 1203 | 1141 |
-- Name: dunning; Type: TABLE; Schema: public; Owner: postgres |
| 1204 | 1142 |
-- |
| 1205 | 1143 |
|
| ... | ... | |
| 1216 | 1154 |
|
| 1217 | 1155 |
|
| 1218 | 1156 |
-- |
| 1219 |
-- TOC entry 165 (OID 1983838) |
|
| 1220 | 1157 |
-- Name: set_priceupdate_parts(); Type: FUNCTION; Schema: public; Owner: postgres |
| 1221 | 1158 |
-- |
| 1222 | 1159 |
|
| ... | ... | |
| 1226 | 1163 |
|
| 1227 | 1164 |
|
| 1228 | 1165 |
-- |
| 1229 |
-- TOC entry 63 (OID 1983846) |
|
| 1230 | 1166 |
-- Name: leads; Type: TABLE; Schema: public; Owner: postgres |
| 1231 | 1167 |
-- |
| 1232 | 1168 |
|
| ... | ... | |
| 1237 | 1173 |
|
| 1238 | 1174 |
|
| 1239 | 1175 |
-- |
| 1240 |
-- TOC entry 64 (OID 1983849) |
|
| 1241 | 1176 |
-- Name: taxkeys; Type: TABLE; Schema: public; Owner: postgres |
| 1242 | 1177 |
-- |
| 1243 | 1178 |
|
| ... | ... | |
| 1252 | 1187 |
|
| 1253 | 1188 |
|
| 1254 | 1189 |
-- |
| 1255 |
-- Data for TOC entry 171 (OID 1981915) |
|
| 1256 | 1190 |
-- Name: defaults; Type: TABLE DATA; Schema: public; Owner: postgres |
| 1257 | 1191 |
-- |
| 1258 | 1192 |
|
| 1259 | 1193 |
INSERT INTO "defaults" ("version", "curr") VALUES ('2.4.0.0', 'EUR:USD');
|
| 1260 | 1194 |
|
| 1261 | 1195 |
-- |
| 1262 |
-- Data for TOC entry 204 (OID 1982194) |
|
| 1263 | 1196 |
-- Name: finanzamt; Type: TABLE DATA; Schema: public; Owner: postgres |
| 1264 | 1197 |
-- |
| 1265 | 1198 |
|
| ... | ... | |
| 1952 | 1885 |
|
| 1953 | 1886 |
|
| 1954 | 1887 |
-- |
| 1955 |
-- Data for TOC entry 208 (OID 1983745) |
|
| 1956 | 1888 |
-- Name: units; Type: TABLE DATA; Schema: public; Owner: postgres |
| 1957 | 1889 |
-- |
| 1958 | 1890 |
|
| ... | ... | |
| 1970 | 1902 |
|
| 1971 | 1903 |
|
| 1972 | 1904 |
-- |
| 1973 |
-- Data for TOC entry 212 (OID 1983798) |
|
| 1974 | 1905 |
-- Name: tax_zones; Type: TABLE DATA; Schema: public; Owner: postgres |
| 1975 | 1906 |
-- |
| 1976 | 1907 |
|
| ... | ... | |
| 1980 | 1911 |
INSERT INTO tax_zones (id, description) VALUES (3, 'Außerhalb EU'); |
| 1981 | 1912 |
|
| 1982 | 1913 |
-- |
| 1983 |
-- TOC entry 143 (OID 1982173) |
|
| 1984 | 1914 |
-- Name: license_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 1985 | 1915 |
-- |
| 1986 | 1916 |
|
| ... | ... | |
| 1988 | 1918 |
|
| 1989 | 1919 |
|
| 1990 | 1920 |
-- |
| 1991 |
-- TOC entry 84 (OID 1982891) |
|
| 1992 | 1921 |
-- Name: acc_trans_trans_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 1993 | 1922 |
-- |
| 1994 | 1923 |
|
| ... | ... | |
| 1996 | 1925 |
|
| 1997 | 1926 |
|
| 1998 | 1927 |
-- |
| 1999 |
-- TOC entry 82 (OID 1982892) |
|
| 2000 | 1928 |
-- Name: acc_trans_chart_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2001 | 1929 |
-- |
| 2002 | 1930 |
|
| ... | ... | |
| 2004 | 1932 |
|
| 2005 | 1933 |
|
| 2006 | 1934 |
-- |
| 2007 |
-- TOC entry 85 (OID 1982893) |
|
| 2008 | 1935 |
-- Name: acc_trans_transdate_key; Type: INDEX; Schema: public; Owner: postgres |
| 2009 | 1936 |
-- |
| 2010 | 1937 |
|
| ... | ... | |
| 2012 | 1939 |
|
| 2013 | 1940 |
|
| 2014 | 1941 |
-- |
| 2015 |
-- TOC entry 83 (OID 1982894) |
|
| 2016 | 1942 |
-- Name: acc_trans_source_key; Type: INDEX; Schema: public; Owner: postgres |
| 2017 | 1943 |
-- |
| 2018 | 1944 |
|
| ... | ... | |
| 2020 | 1946 |
|
| 2021 | 1947 |
|
| 2022 | 1948 |
-- |
| 2023 |
-- TOC entry 110 (OID 1982895) |
|
| 2024 | 1949 |
-- Name: ap_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2025 | 1950 |
-- |
| 2026 | 1951 |
|
| ... | ... | |
| 2028 | 1953 |
|
| 2029 | 1954 |
|
| 2030 | 1955 |
-- |
| 2031 |
-- TOC entry 115 (OID 1982896) |
|
| 2032 | 1956 |
-- Name: ap_transdate_key; Type: INDEX; Schema: public; Owner: postgres |
| 2033 | 1957 |
-- |
| 2034 | 1958 |
|
| ... | ... | |
| 2036 | 1960 |
|
| 2037 | 1961 |
|
| 2038 | 1962 |
-- |
| 2039 |
-- TOC entry 111 (OID 1982897) |
|
| 2040 | 1963 |
-- Name: ap_invnumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2041 | 1964 |
-- |
| 2042 | 1965 |
|
| ... | ... | |
| 2044 | 1967 |
|
| 2045 | 1968 |
|
| 2046 | 1969 |
-- |
| 2047 |
-- TOC entry 112 (OID 1982898) |
|
| 2048 | 1970 |
-- Name: ap_ordnumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2049 | 1971 |
-- |
| 2050 | 1972 |
|
| ... | ... | |
| 2052 | 1974 |
|
| 2053 | 1975 |
|
| 2054 | 1976 |
-- |
| 2055 |
-- TOC entry 116 (OID 1982899) |
|
| 2056 | 1977 |
-- Name: ap_vendor_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2057 | 1978 |
-- |
| 2058 | 1979 |
|
| ... | ... | |
| 2060 | 1981 |
|
| 2061 | 1982 |
|
| 2062 | 1983 |
-- |
| 2063 |
-- TOC entry 109 (OID 1982900) |
|
| 2064 | 1984 |
-- Name: ap_employee_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2065 | 1985 |
-- |
| 2066 | 1986 |
|
| ... | ... | |
| 2068 | 1988 |
|
| 2069 | 1989 |
|
| 2070 | 1990 |
-- |
| 2071 |
-- TOC entry 103 (OID 1982901) |
|
| 2072 | 1991 |
-- Name: ar_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2073 | 1992 |
-- |
| 2074 | 1993 |
|
| ... | ... | |
| 2076 | 1995 |
|
| 2077 | 1996 |
|
| 2078 | 1997 |
-- |
| 2079 |
-- TOC entry 108 (OID 1982902) |
|
| 2080 | 1998 |
-- Name: ar_transdate_key; Type: INDEX; Schema: public; Owner: postgres |
| 2081 | 1999 |
-- |
| 2082 | 2000 |
|
| ... | ... | |
| 2084 | 2002 |
|
| 2085 | 2003 |
|
| 2086 | 2004 |
-- |
| 2087 |
-- TOC entry 104 (OID 1982903) |
|
| 2088 | 2005 |
-- Name: ar_invnumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2089 | 2006 |
-- |
| 2090 | 2007 |
|
| ... | ... | |
| 2092 | 2009 |
|
| 2093 | 2010 |
|
| 2094 | 2011 |
-- |
| 2095 |
-- TOC entry 105 (OID 1982904) |
|
| 2096 | 2012 |
-- Name: ar_ordnumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2097 | 2013 |
-- |
| 2098 | 2014 |
|
| ... | ... | |
| 2100 | 2016 |
|
| 2101 | 2017 |
|
| 2102 | 2018 |
-- |
| 2103 |
-- TOC entry 101 (OID 1982905) |
|
| 2104 | 2019 |
-- Name: ar_customer_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2105 | 2020 |
-- |
| 2106 | 2021 |
|
| ... | ... | |
| 2108 | 2023 |
|
| 2109 | 2024 |
|
| 2110 | 2025 |
-- |
| 2111 |
-- TOC entry 102 (OID 1982906) |
|
| 2112 | 2026 |
-- Name: ar_employee_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2113 | 2027 |
-- |
| 2114 | 2028 |
|
| ... | ... | |
| 2116 | 2030 |
|
| 2117 | 2031 |
|
| 2118 | 2032 |
-- |
| 2119 |
-- TOC entry 100 (OID 1982907) |
|
| 2120 | 2033 |
-- Name: assembly_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2121 | 2034 |
-- |
| 2122 | 2035 |
|
| ... | ... | |
| 2124 | 2037 |
|
| 2125 | 2038 |
|
| 2126 | 2039 |
-- |
| 2127 |
-- TOC entry 74 (OID 1982908) |
|
| 2128 | 2040 |
-- Name: chart_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2129 | 2041 |
-- |
| 2130 | 2042 |
|
| ... | ... | |
| 2132 | 2044 |
|
| 2133 | 2045 |
|
| 2134 | 2046 |
-- |
| 2135 |
-- TOC entry 71 (OID 1982909) |
|
| 2136 | 2047 |
-- Name: chart_accno_key; Type: INDEX; Schema: public; Owner: postgres |
| 2137 | 2048 |
-- |
| 2138 | 2049 |
|
| ... | ... | |
| 2140 | 2051 |
|
| 2141 | 2052 |
|
| 2142 | 2053 |
-- |
| 2143 |
-- TOC entry 72 (OID 1982910) |
|
| 2144 | 2054 |
-- Name: chart_category_key; Type: INDEX; Schema: public; Owner: postgres |
| 2145 | 2055 |
-- |
| 2146 | 2056 |
|
| ... | ... | |
| 2148 | 2058 |
|
| 2149 | 2059 |
|
| 2150 | 2060 |
-- |
| 2151 |
-- TOC entry 75 (OID 1982911) |
|
| 2152 | 2061 |
-- Name: chart_link_key; Type: INDEX; Schema: public; Owner: postgres |
| 2153 | 2062 |
-- |
| 2154 | 2063 |
|
| ... | ... | |
| 2156 | 2065 |
|
| 2157 | 2066 |
|
| 2158 | 2067 |
-- |
| 2159 |
-- TOC entry 73 (OID 1982912) |
|
| 2160 | 2068 |
-- Name: chart_gifi_accno_key; Type: INDEX; Schema: public; Owner: postgres |
| 2161 | 2069 |
-- |
| 2162 | 2070 |
|
| ... | ... | |
| 2164 | 2072 |
|
| 2165 | 2073 |
|
| 2166 | 2074 |
-- |
| 2167 |
-- TOC entry 96 (OID 1982913) |
|
| 2168 | 2075 |
-- Name: customer_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2169 | 2076 |
-- |
| 2170 | 2077 |
|
| ... | ... | |
| 2172 | 2079 |
|
| 2173 | 2080 |
|
| 2174 | 2081 |
-- |
| 2175 |
-- TOC entry 118 (OID 1982914) |
|
| 2176 | 2082 |
-- Name: customer_customer_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2177 | 2083 |
-- |
| 2178 | 2084 |
|
| ... | ... | |
| 2180 | 2086 |
|
| 2181 | 2087 |
|
| 2182 | 2088 |
-- |
| 2183 |
-- TOC entry 95 (OID 1982915) |
|
| 2184 | 2089 |
-- Name: customer_customernumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2185 | 2090 |
-- |
| 2186 | 2091 |
|
| ... | ... | |
| 2188 | 2093 |
|
| 2189 | 2094 |
|
| 2190 | 2095 |
-- |
| 2191 |
-- TOC entry 97 (OID 1982916) |
|
| 2192 | 2096 |
-- Name: customer_name_key; Type: INDEX; Schema: public; Owner: postgres |
| 2193 | 2097 |
-- |
| 2194 | 2098 |
|
| ... | ... | |
| 2196 | 2100 |
|
| 2197 | 2101 |
|
| 2198 | 2102 |
-- |
| 2199 |
-- TOC entry 94 (OID 1982917) |
|
| 2200 | 2103 |
-- Name: customer_contact_key; Type: INDEX; Schema: public; Owner: postgres |
| 2201 | 2104 |
-- |
| 2202 | 2105 |
|
| ... | ... | |
| 2204 | 2107 |
|
| 2205 | 2108 |
|
| 2206 | 2109 |
-- |
| 2207 |
-- TOC entry 128 (OID 1982918) |
|
| 2208 | 2110 |
-- Name: employee_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2209 | 2111 |
-- |
| 2210 | 2112 |
|
| ... | ... | |
| 2212 | 2114 |
|
| 2213 | 2115 |
|
| 2214 | 2116 |
-- |
| 2215 |
-- TOC entry 129 (OID 1982919) |
|
| 2216 | 2117 |
-- Name: employee_login_key; Type: INDEX; Schema: public; Owner: postgres |
| 2217 | 2118 |
-- |
| 2218 | 2119 |
|
| ... | ... | |
| 2220 | 2121 |
|
| 2221 | 2122 |
|
| 2222 | 2123 |
-- |
| 2223 |
-- TOC entry 130 (OID 1982920) |
|
| 2224 | 2124 |
-- Name: employee_name_key; Type: INDEX; Schema: public; Owner: postgres |
| 2225 | 2125 |
-- |
| 2226 | 2126 |
|
| ... | ... | |
| 2228 | 2128 |
|
| 2229 | 2129 |
|
| 2230 | 2130 |
-- |
| 2231 |
-- TOC entry 127 (OID 1982921) |
|
| 2232 | 2131 |
-- Name: exchangerate_ct_key; Type: INDEX; Schema: public; Owner: postgres |
| 2233 | 2132 |
-- |
| 2234 | 2133 |
|
| ... | ... | |
| 2236 | 2135 |
|
| 2237 | 2136 |
|
| 2238 | 2137 |
-- |
| 2239 |
-- TOC entry 77 (OID 1982922) |
|
| 2240 | 2138 |
-- Name: gifi_accno_key; Type: INDEX; Schema: public; Owner: postgres |
| 2241 | 2139 |
-- |
| 2242 | 2140 |
|
| ... | ... | |
| 2244 | 2142 |
|
| 2245 | 2143 |
|
| 2246 | 2144 |
-- |
| 2247 |
-- TOC entry 67 (OID 1982923) |
|
| 2248 | 2145 |
-- Name: gl_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2249 | 2146 |
-- |
| 2250 | 2147 |
|
| ... | ... | |
| 2252 | 2149 |
|
| 2253 | 2150 |
|
| 2254 | 2151 |
-- |
| 2255 |
-- TOC entry 70 (OID 1982924) |
|
| 2256 | 2152 |
-- Name: gl_transdate_key; Type: INDEX; Schema: public; Owner: postgres |
| 2257 | 2153 |
-- |
| 2258 | 2154 |
|
| ... | ... | |
| 2260 | 2156 |
|
| 2261 | 2157 |
|
| 2262 | 2158 |
-- |
| 2263 |
-- TOC entry 69 (OID 1982925) |
|
| 2264 | 2159 |
-- Name: gl_reference_key; Type: INDEX; Schema: public; Owner: postgres |
| 2265 | 2160 |
-- |
| 2266 | 2161 |
|
| ... | ... | |
| 2268 | 2163 |
|
| 2269 | 2164 |
|
| 2270 | 2165 |
-- |
| 2271 |
-- TOC entry 65 (OID 1982926) |
|
| 2272 | 2166 |
-- Name: gl_description_key; Type: INDEX; Schema: public; Owner: postgres |
| 2273 | 2167 |
-- |
| 2274 | 2168 |
|
| ... | ... | |
| 2276 | 2170 |
|
| 2277 | 2171 |
|
| 2278 | 2172 |
-- |
| 2279 |
-- TOC entry 66 (OID 1982927) |
|
| 2280 | 2173 |
-- Name: gl_employee_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2281 | 2174 |
-- |
| 2282 | 2175 |
|
| ... | ... | |
| 2284 | 2177 |
|
| 2285 | 2178 |
|
| 2286 | 2179 |
-- |
| 2287 |
-- TOC entry 86 (OID 1982928) |
|
| 2288 | 2180 |
-- Name: invoice_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2289 | 2181 |
-- |
| 2290 | 2182 |
|
| ... | ... | |
| 2292 | 2184 |
|
| 2293 | 2185 |
|
| 2294 | 2186 |
-- |
| 2295 |
-- TOC entry 88 (OID 1982929) |
|
| 2296 | 2187 |
-- Name: invoice_trans_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2297 | 2188 |
-- |
| 2298 | 2189 |
|
| ... | ... | |
| 2300 | 2191 |
|
| 2301 | 2192 |
|
| 2302 | 2193 |
-- |
| 2303 |
-- TOC entry 121 (OID 1982930) |
|
| 2304 | 2194 |
-- Name: oe_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2305 | 2195 |
-- |
| 2306 | 2196 |
|
| ... | ... | |
| 2308 | 2198 |
|
| 2309 | 2199 |
|
| 2310 | 2200 |
-- |
| 2311 |
-- TOC entry 124 (OID 1982931) |
|
| 2312 | 2201 |
-- Name: oe_transdate_key; Type: INDEX; Schema: public; Owner: postgres |
| 2313 | 2202 |
-- |
| 2314 | 2203 |
|
| ... | ... | |
| 2316 | 2205 |
|
| 2317 | 2206 |
|
| 2318 | 2207 |
-- |
| 2319 |
-- TOC entry 122 (OID 1982932) |
|
| 2320 | 2208 |
-- Name: oe_ordnumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2321 | 2209 |
-- |
| 2322 | 2210 |
|
| ... | ... | |
| 2324 | 2212 |
|
| 2325 | 2213 |
|
| 2326 | 2214 |
-- |
| 2327 |
-- TOC entry 120 (OID 1982933) |
|
| 2328 | 2215 |
-- Name: oe_employee_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2329 | 2216 |
-- |
| 2330 | 2217 |
|
| ... | ... | |
| 2332 | 2219 |
|
| 2333 | 2220 |
|
| 2334 | 2221 |
-- |
| 2335 |
-- TOC entry 126 (OID 1982934) |
|
| 2336 | 2222 |
-- Name: orderitems_trans_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2337 | 2223 |
-- |
| 2338 | 2224 |
|
| ... | ... | |
| 2340 | 2226 |
|
| 2341 | 2227 |
|
| 2342 | 2228 |
-- |
| 2343 |
-- TOC entry 79 (OID 1982935) |
|
| 2344 | 2229 |
-- Name: parts_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2345 | 2230 |
-- |
| 2346 | 2231 |
|
| ... | ... | |
| 2348 | 2233 |
|
| 2349 | 2234 |
|
| 2350 | 2235 |
-- |
| 2351 |
-- TOC entry 80 (OID 1982936) |
|
| 2352 | 2236 |
-- Name: parts_partnumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2353 | 2237 |
-- |
| 2354 | 2238 |
|
| ... | ... | |
| 2356 | 2240 |
|
| 2357 | 2241 |
|
| 2358 | 2242 |
-- |
| 2359 |
-- TOC entry 78 (OID 1982937) |
|
| 2360 | 2243 |
-- Name: parts_description_key; Type: INDEX; Schema: public; Owner: postgres |
| 2361 | 2244 |
-- |
| 2362 | 2245 |
|
| ... | ... | |
| 2364 | 2247 |
|
| 2365 | 2248 |
|
| 2366 | 2249 |
-- |
| 2367 |
-- TOC entry 117 (OID 1982938) |
|
| 2368 | 2250 |
-- Name: partstax_parts_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2369 | 2251 |
-- |
| 2370 | 2252 |
|
| ... | ... | |
| 2372 | 2254 |
|
| 2373 | 2255 |
|
| 2374 | 2256 |
-- |
| 2375 |
-- TOC entry 90 (OID 1982939) |
|
| 2376 | 2257 |
-- Name: vendor_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2377 | 2258 |
-- |
| 2378 | 2259 |
|
| ... | ... | |
| 2380 | 2261 |
|
| 2381 | 2262 |
|
| 2382 | 2263 |
-- |
| 2383 |
-- TOC entry 91 (OID 1982940) |
|
| 2384 | 2264 |
-- Name: vendor_name_key; Type: INDEX; Schema: public; Owner: postgres |
| 2385 | 2265 |
-- |
| 2386 | 2266 |
|
| ... | ... | |
| 2388 | 2268 |
|
| 2389 | 2269 |
|
| 2390 | 2270 |
-- |
| 2391 |
-- TOC entry 93 (OID 1982941) |
|
| 2392 | 2271 |
-- Name: vendor_vendornumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2393 | 2272 |
-- |
| 2394 | 2273 |
|
| ... | ... | |
| 2396 | 2275 |
|
| 2397 | 2276 |
|
| 2398 | 2277 |
-- |
| 2399 |
-- TOC entry 89 (OID 1982942) |
|
| 2400 | 2278 |
-- Name: vendor_contact_key; Type: INDEX; Schema: public; Owner: postgres |
| 2401 | 2279 |
-- |
| 2402 | 2280 |
|
| ... | ... | |
| 2404 | 2282 |
|
| 2405 | 2283 |
|
| 2406 | 2284 |
-- |
| 2407 |
-- TOC entry 119 (OID 1982943) |
|
| 2408 | 2285 |
-- Name: vendortax_vendor_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2409 | 2286 |
-- |
| 2410 | 2287 |
|
| ... | ... | |
| 2412 | 2289 |
|
| 2413 | 2290 |
|
| 2414 | 2291 |
-- |
| 2415 |
-- TOC entry 132 (OID 1982944) |
|
| 2416 | 2292 |
-- Name: shipto_trans_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2417 | 2293 |
-- |
| 2418 | 2294 |
|
| ... | ... | |
| 2420 | 2296 |
|
| 2421 | 2297 |
|
| 2422 | 2298 |
-- |
| 2423 |
-- TOC entry 133 (OID 1982945) |
|
| 2424 | 2299 |
-- Name: project_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2425 | 2300 |
-- |
| 2426 | 2301 |
|
| ... | ... | |
| 2428 | 2303 |
|
| 2429 | 2304 |
|
| 2430 | 2305 |
-- |
| 2431 |
-- TOC entry 107 (OID 1982946) |
|
| 2432 | 2306 |
-- Name: ar_quonumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2433 | 2307 |
-- |
| 2434 | 2308 |
|
| ... | ... | |
| 2436 | 2310 |
|
| 2437 | 2311 |
|
| 2438 | 2312 |
-- |
| 2439 |
-- TOC entry 114 (OID 1982947) |
|
| 2440 | 2313 |
-- Name: ap_quonumber_key; Type: INDEX; Schema: public; Owner: postgres |
| 2441 | 2314 |
-- |
| 2442 | 2315 |
|
| ... | ... | |
| 2444 | 2317 |
|
| 2445 | 2318 |
|
| 2446 | 2319 |
-- |
| 2447 |
-- TOC entry 138 (OID 1982948) |
|
| 2448 | 2320 |
-- Name: makemodel_parts_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2449 | 2321 |
-- |
| 2450 | 2322 |
|
| ... | ... | |
| 2452 | 2324 |
|
| 2453 | 2325 |
|
| 2454 | 2326 |
-- |
| 2455 |
-- TOC entry 136 (OID 1982949) |
|
| 2456 | 2327 |
-- Name: makemodel_make_key; Type: INDEX; Schema: public; Owner: postgres |
| 2457 | 2328 |
-- |
| 2458 | 2329 |
|
| ... | ... | |
| 2460 | 2331 |
|
| 2461 | 2332 |
|
| 2462 | 2333 |
-- |
| 2463 |
-- TOC entry 137 (OID 1982950) |
|
| 2464 | 2334 |
-- Name: makemodel_model_key; Type: INDEX; Schema: public; Owner: postgres |
| 2465 | 2335 |
-- |
| 2466 | 2336 |
|
| ... | ... | |
| 2468 | 2338 |
|
| 2469 | 2339 |
|
| 2470 | 2340 |
-- |
| 2471 |
-- TOC entry 139 (OID 1982951) |
|
| 2472 | 2341 |
-- Name: status_trans_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2473 | 2342 |
-- |
| 2474 | 2343 |
|
| ... | ... | |
| 2476 | 2345 |
|
| 2477 | 2346 |
|
| 2478 | 2347 |
-- |
| 2479 |
-- TOC entry 141 (OID 1982952) |
|
| 2480 | 2348 |
-- Name: department_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2481 | 2349 |
-- |
| 2482 | 2350 |
|
| ... | ... | |
| 2484 | 2352 |
|
| 2485 | 2353 |
|
| 2486 | 2354 |
-- |
| 2487 |
-- TOC entry 125 (OID 1982953) |
|
| 2488 | 2355 |
-- Name: orderitems_id_key; Type: INDEX; Schema: public; Owner: postgres |
| 2489 | 2356 |
-- |
| 2490 | 2357 |
|
| ... | ... | |
| 2492 | 2359 |
|
| 2493 | 2360 |
|
| 2494 | 2361 |
-- |
| 2495 |
-- TOC entry 68 (OID 1981877) |
|
| 2496 | 2362 |
-- Name: gl_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2497 | 2363 |
-- |
| 2498 | 2364 |
|
| ... | ... | |
| 2501 | 2367 |
|
| 2502 | 2368 |
|
| 2503 | 2369 |
-- |
| 2504 |
-- TOC entry 76 (OID 1981888) |
|
| 2505 | 2370 |
-- Name: chart_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2506 | 2371 |
-- |
| 2507 | 2372 |
|
| ... | ... | |
| 2510 | 2375 |
|
| 2511 | 2376 |
|
| 2512 | 2377 |
-- |
| 2513 |
-- TOC entry 81 (OID 1981913) |
|
| 2514 | 2378 |
-- Name: parts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2515 | 2379 |
-- |
| 2516 | 2380 |
|
| ... | ... | |
| 2519 | 2383 |
|
| 2520 | 2384 |
|
| 2521 | 2385 |
-- |
| 2522 |
-- TOC entry 87 (OID 1981952) |
|
| 2523 | 2386 |
-- Name: invoice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2524 | 2387 |
-- |
| 2525 | 2388 |
|
| ... | ... | |
| 2528 | 2391 |
|
| 2529 | 2392 |
|
| 2530 | 2393 |
-- |
| 2531 |
-- TOC entry 92 (OID 1981967) |
|
| 2532 | 2394 |
-- Name: vendor_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2533 | 2395 |
-- |
| 2534 | 2396 |
|
| ... | ... | |
| 2537 | 2399 |
|
| 2538 | 2400 |
|
| 2539 | 2401 |
-- |
| 2540 |
-- TOC entry 98 (OID 1981980) |
|
| 2541 | 2402 |
-- Name: customer_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2542 | 2403 |
-- |
| 2543 | 2404 |
|
| ... | ... | |
| 2546 | 2407 |
|
| 2547 | 2408 |
|
| 2548 | 2409 |
-- |
| 2549 |
-- TOC entry 99 (OID 1981989) |
|
| 2550 | 2410 |
-- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2551 | 2411 |
-- |
| 2552 | 2412 |
|
| ... | ... | |
| 2555 | 2415 |
|
| 2556 | 2416 |
|
| 2557 | 2417 |
-- |
| 2558 |
-- TOC entry 106 (OID 1982006) |
|
| 2559 | 2418 |
-- Name: ar_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2560 | 2419 |
-- |
| 2561 | 2420 |
|
| ... | ... | |
| 2564 | 2423 |
|
| 2565 | 2424 |
|
| 2566 | 2425 |
-- |
| 2567 |
-- TOC entry 113 (OID 1982024) |
|
| 2568 | 2426 |
-- Name: ap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2569 | 2427 |
-- |
| 2570 | 2428 |
|
| ... | ... | |
| 2573 | 2431 |
|
| 2574 | 2432 |
|
| 2575 | 2433 |
-- |
| 2576 |
-- TOC entry 123 (OID 1982056) |
|
| 2577 | 2434 |
-- Name: oe_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2578 | 2435 |
-- |
| 2579 | 2436 |
|
| ... | ... | |
| 2582 | 2439 |
|
| 2583 | 2440 |
|
| 2584 | 2441 |
-- |
| 2585 |
-- TOC entry 131 (OID 1982081) |
|
| 2586 | 2442 |
-- Name: employee_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2587 | 2443 |
-- |
| 2588 | 2444 |
|
| ... | ... | |
| 2591 | 2447 |
|
| 2592 | 2448 |
|
| 2593 | 2449 |
-- |
| 2594 |
-- TOC entry 134 (OID 1982096) |
|
| 2595 | 2450 |
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2596 | 2451 |
-- |
| 2597 | 2452 |
|
| ... | ... | |
| 2600 | 2455 |
|
| 2601 | 2456 |
|
| 2602 | 2457 |
-- |
| 2603 |
-- TOC entry 135 (OID 1982098) |
|
| 2604 | 2458 |
-- Name: project_projectnumber_key; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2605 | 2459 |
-- |
| 2606 | 2460 |
|
| ... | ... | |
| 2609 | 2463 |
|
| 2610 | 2464 |
|
| 2611 | 2465 |
-- |
| 2612 |
-- TOC entry 140 (OID 1982132) |
|
| 2613 | 2466 |
-- Name: warehouse_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2614 | 2467 |
-- |
| 2615 | 2468 |
|
| ... | ... | |
| 2618 | 2471 |
|
| 2619 | 2472 |
|
| 2620 | 2473 |
-- |
| 2621 |
-- TOC entry 142 (OID 1982156) |
|
| 2622 | 2474 |
-- Name: business_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2623 | 2475 |
-- |
| 2624 | 2476 |
|
| ... | ... | |
| 2627 | 2479 |
|
| 2628 | 2480 |
|
| 2629 | 2481 |
-- |
| 2630 |
-- TOC entry 144 (OID 1982171) |
|
| 2631 | 2482 |
-- Name: license_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2632 | 2483 |
-- |
| 2633 | 2484 |
|
| ... | ... | |
| 2636 | 2487 |
|
| 2637 | 2488 |
|
| 2638 | 2489 |
-- |
| 2639 |
-- TOC entry 145 (OID 1982182) |
|
| 2640 | 2490 |
-- Name: pricegroup_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2641 | 2491 |
-- |
| 2642 | 2492 |
|
| ... | ... | |
| 2645 | 2495 |
|
| 2646 | 2496 |
|
| 2647 | 2497 |
-- |
| 2648 |
-- TOC entry 146 (OID 1983728) |
|
| 2649 | 2498 |
-- Name: language_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2650 | 2499 |
-- |
| 2651 | 2500 |
|
| ... | ... | |
| 2654 | 2503 |
|
| 2655 | 2504 |
|
| 2656 | 2505 |
-- |
| 2657 |
-- TOC entry 147 (OID 1983737) |
|
| 2658 | 2506 |
-- Name: payment_terms_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2659 | 2507 |
-- |
| 2660 | 2508 |
|
| ... | ... | |
| 2663 | 2511 |
|
| 2664 | 2512 |
|
| 2665 | 2513 |
-- |
| 2666 |
-- TOC entry 148 (OID 1983747) |
|
| 2667 | 2514 |
-- Name: units_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2668 | 2515 |
-- |
| 2669 | 2516 |
|
| ... | ... | |
| 2672 | 2519 |
|
| 2673 | 2520 |
|
| 2674 | 2521 |
-- |
| 2675 |
-- TOC entry 149 (OID 1983772) |
|
| 2676 | 2522 |
-- Name: rma_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2677 | 2523 |
-- |
| 2678 | 2524 |
|
| ... | ... | |
| 2681 | 2527 |
|
| 2682 | 2528 |
|
| 2683 | 2529 |
-- |
| 2684 |
-- TOC entry 150 (OID 1983791) |
|
| 2685 | 2530 |
-- Name: printers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2686 | 2531 |
-- |
| 2687 | 2532 |
|
| ... | ... | |
| 2690 | 2535 |
|
| 2691 | 2536 |
|
| 2692 | 2537 |
-- |
| 2693 |
-- TOC entry 151 (OID 1983813) |
|
| 2694 | 2538 |
-- Name: buchungsgruppen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2695 | 2539 |
-- |
| 2696 | 2540 |
|
| ... | ... | |
| 2699 | 2543 |
|
| 2700 | 2544 |
|
| 2701 | 2545 |
-- |
| 2702 |
-- TOC entry 152 (OID 1983831) |
|
| 2703 | 2546 |
-- Name: dunning_config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2704 | 2547 |
-- |
| 2705 | 2548 |
|
| ... | ... | |
| 2708 | 2551 |
|
| 2709 | 2552 |
|
| 2710 | 2553 |
-- |
| 2711 |
-- TOC entry 153 (OID 1983836) |
|
| 2712 | 2554 |
-- Name: dunning_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2713 | 2555 |
-- |
| 2714 | 2556 |
|
| ... | ... | |
| 2717 | 2559 |
|
| 2718 | 2560 |
|
| 2719 | 2561 |
-- |
| 2720 |
-- TOC entry 154 (OID 1983852) |
|
| 2721 | 2562 |
-- Name: taxkeys_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres |
| 2722 | 2563 |
-- |
| 2723 | 2564 |
|
| ... | ... | |
| 2726 | 2567 |
|
| 2727 | 2568 |
|
| 2728 | 2569 |
-- |
| 2729 |
-- TOC entry 219 (OID 1981940) |
|
| 2730 | 2570 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2731 | 2571 |
-- |
| 2732 | 2572 |
|
| ... | ... | |
| 2735 | 2575 |
|
| 2736 | 2576 |
|
| 2737 | 2577 |
-- |
| 2738 |
-- TOC entry 220 (OID 1981954) |
|
| 2739 | 2578 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2740 | 2579 |
-- |
| 2741 | 2580 |
|
| ... | ... | |
| 2744 | 2583 |
|
| 2745 | 2584 |
|
| 2746 | 2585 |
-- |
| 2747 |
-- TOC entry 221 (OID 1982008) |
|
| 2748 | 2586 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2749 | 2587 |
-- |
| 2750 | 2588 |
|
| ... | ... | |
| 2753 | 2591 |
|
| 2754 | 2592 |
|
| 2755 | 2593 |
-- |
| 2756 |
-- TOC entry 222 (OID 1982026) |
|
| 2757 | 2594 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2758 | 2595 |
-- |
| 2759 | 2596 |
|
| ... | ... | |
| 2762 | 2599 |
|
| 2763 | 2600 |
|
| 2764 | 2601 |
-- |
| 2765 |
-- TOC entry 223 (OID 1982065) |
|
| 2766 | 2602 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2767 | 2603 |
-- |
| 2768 | 2604 |
|
| ... | ... | |
| 2771 | 2607 |
|
| 2772 | 2608 |
|
| 2773 | 2609 |
-- |
| 2774 |
-- TOC entry 224 (OID 1982186) |
|
| 2775 | 2610 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2776 | 2611 |
-- |
| 2777 | 2612 |
|
| ... | ... | |
| 2780 | 2615 |
|
| 2781 | 2616 |
|
| 2782 | 2617 |
-- |
| 2783 |
-- TOC entry 225 (OID 1982190) |
|
| 2784 | 2618 |
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2785 | 2619 |
-- |
| 2786 | 2620 |
|
| ... | ... | |
| 2789 | 2623 |
|
| 2790 | 2624 |
|
| 2791 | 2625 |
-- |
| 2792 |
-- TOC entry 226 (OID 1983749) |
|
| 2793 | 2626 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2794 | 2627 |
-- |
| 2795 | 2628 |
|
| ... | ... | |
| 2798 | 2631 |
|
| 2799 | 2632 |
|
| 2800 | 2633 |
-- |
| 2801 |
-- TOC entry 227 (OID 1983781) |
|
| 2802 | 2634 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2803 | 2635 |
-- |
| 2804 | 2636 |
|
| ... | ... | |
| 2807 | 2639 |
|
| 2808 | 2640 |
|
| 2809 | 2641 |
-- |
| 2810 |
-- TOC entry 218 (OID 1984290) |
|
| 2811 | 2642 |
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| 2812 | 2643 |
-- |
| 2813 | 2644 |
|
| ... | ... | |
| 2816 | 2647 |
|
| 2817 | 2648 |
|
| 2818 | 2649 |
-- |
| 2819 |
-- TOC entry 243 (OID 1982954) |
|
| 2820 | 2650 |
-- Name: check_department; Type: TRIGGER; Schema: public; Owner: postgres |
| 2821 | 2651 |
-- |
| 2822 | 2652 |
|
| ... | ... | |
| 2827 | 2657 |
|
| 2828 | 2658 |
|
| 2829 | 2659 |
-- |
| 2830 |
-- TOC entry 247 (OID 1982955) |
|
| 2831 | 2660 |
-- Name: check_department; Type: TRIGGER; Schema: public; Owner: postgres |
| 2832 | 2661 |
-- |
| 2833 | 2662 |
|
| ... | ... | |
| 2838 | 2667 |
|
| 2839 | 2668 |
|
| 2840 | 2669 |
-- |
| 2841 |
-- TOC entry 228 (OID 1982956) |
|
| 2842 | 2670 |
-- Name: check_department; Type: TRIGGER; Schema: public; Owner: postgres |
| 2843 | 2671 |
-- |
| 2844 | 2672 |
|
| ... | ... | |
| 2849 | 2677 |
|
| 2850 | 2678 |
|
| 2851 | 2679 |
-- |
| 2852 |
-- TOC entry 252 (OID 1982957) |
|
| 2853 | 2680 |
-- Name: check_department; Type: TRIGGER; Schema: public; Owner: postgres |
| 2854 | 2681 |
-- |
| 2855 | 2682 |
|
| ... | ... | |
| 2860 | 2687 |
|
| 2861 | 2688 |
|
| 2862 | 2689 |
-- |
| 2863 |
-- TOC entry 244 (OID 1982958) |
|
| 2864 | 2690 |
-- Name: del_department; Type: TRIGGER; Schema: public; Owner: postgres |
| 2865 | 2691 |
-- |
| 2866 | 2692 |
|
| ... | ... | |
| 2871 | 2697 |
|
| 2872 | 2698 |
|
| 2873 | 2699 |
-- |
| 2874 |
-- TOC entry 248 (OID 1982959) |
|
| 2875 | 2700 |
-- Name: del_department; Type: TRIGGER; Schema: public; Owner: postgres |
| 2876 | 2701 |
-- |
| 2877 | 2702 |
|
| ... | ... | |
| 2882 | 2707 |
|
| 2883 | 2708 |
|
| 2884 | 2709 |
-- |
| 2885 |
-- TOC entry 229 (OID 1982960) |
|
| 2886 | 2710 |
-- Name: del_department; Type: TRIGGER; Schema: public; Owner: postgres |
| 2887 | 2711 |
-- |
| 2888 | 2712 |
|
| ... | ... | |
| 2893 | 2717 |
|
| 2894 | 2718 |
|
| 2895 | 2719 |
-- |
| 2896 |
-- TOC entry 254 (OID 1982961) |
|
| 2897 | 2720 |
-- Name: del_department; Type: TRIGGER; Schema: public; Owner: postgres |
| 2898 | 2721 |
-- |
| 2899 | 2722 |
|
| ... | ... | |
| 2904 | 2727 |
|
| 2905 | 2728 |
|
| 2906 | 2729 |
-- |
| 2907 |
-- TOC entry 240 (OID 1982962) |
|
| 2908 | 2730 |
-- Name: del_customer; Type: TRIGGER; Schema: public; Owner: postgres |
| 2909 | 2731 |
-- |
| 2910 | 2732 |
|
| ... | ... | |
| 2915 | 2737 |
|
| 2916 | 2738 |
|
| 2917 | 2739 |
-- |
| 2918 |
-- TOC entry 236 (OID 1982963) |
|
| 2919 | 2740 |
-- Name: del_vendor; Type: TRIGGER; Schema: public; Owner: postgres |
| 2920 | 2741 |
-- |
| 2921 | 2742 |
|
| ... | ... | |
| 2926 | 2747 |
|
| 2927 | 2748 |
|
| 2928 | 2749 |
-- |
| 2929 |
-- TOC entry 245 (OID 1982964) |
|
| 2930 | 2750 |
-- Name: del_exchangerate; Type: TRIGGER; Schema: public; Owner: postgres |
| 2931 | 2751 |
-- |
| 2932 | 2752 |
|
| ... | ... | |
| 2937 | 2757 |
|
| 2938 | 2758 |
|
| 2939 | 2759 |
-- |
| 2940 |
-- TOC entry 249 (OID 1982965) |
|
| 2941 | 2760 |
-- Name: del_exchangerate; Type: TRIGGER; Schema: public; Owner: postgres |
| 2942 | 2761 |
-- |
| 2943 | 2762 |
|
| ... | ... | |
| 2948 | 2767 |
|
| 2949 | 2768 |
|
| 2950 | 2769 |
-- |
| 2951 |
-- TOC entry 255 (OID 1982966) |
|
| 2952 | 2770 |
-- Name: del_exchangerate; Type: TRIGGER; Schema: public; Owner: postgres |
| 2953 | 2771 |
-- |
| 2954 | 2772 |
|
| ... | ... | |
| 2959 | 2777 |
|
| 2960 | 2778 |
|
Auch abrufbar als: Unified diff
Unterstützung für PostgreSQL 12 Teil 2
PostgreSQL 12 unterstützt OIDs nicht mehr. Daher die letzten Stellen
umgestellt, an denen noch OIDs verwendet wurden.