github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_table.ref.golden (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 CREATE TABLE product_information ( 6 product_id 7 INT8 8 NOT NULL 9 PRIMARY KEY, 10 product_name 11 STRING(50) 12 NOT NULL 13 UNIQUE, 14 product_description 15 STRING(2000), 16 category_id 17 STRING(1) 18 NOT NULL 19 CHECK ( 20 category_id 21 IN ( 22 'A', 23 'B', 24 'C' 25 ) 26 ), 27 weight_class 28 INT8, 29 warranty_period 30 INT8 31 CONSTRAINT valid_warranty CHECK ( 32 warranty_period BETWEEN 0 AND 24 33 ), 34 supplier_id 35 INT8, 36 product_status 37 STRING(20), 38 list_price 39 DECIMAL(8,2), 40 min_price 41 DECIMAL(8,2), 42 catalog_url 43 STRING(50) 44 UNIQUE, 45 date_added 46 DATE 47 DEFAULT current_date(), 48 misc 49 JSONB, 50 full_name 51 STRING 52 AS ( 53 concat( 54 first_name, 55 ' ', 56 last_name 57 ) 58 ) STORED, 59 INDEX date_added_idx ( 60 date_added 61 ), 62 INDEX supp_id_prod_status_idx ( 63 supplier_id, 64 product_status 65 ), 66 customer_id 67 INT8 68 REFERENCES customers_2 ( 69 id 70 ) 71 MATCH FULL 72 ON DELETE CASCADE ON UPDATE CASCADE, 73 INVERTED INDEX details ( 74 misc 75 ), 76 CONSTRAINT price_check 77 CHECK ( 78 list_price 79 >= min_price 80 ), 81 CONSTRAINT supplied_id_fk 82 FOREIGN KEY ( 83 supplier_id 84 ) 85 REFERENCES suppliers ( 86 id 87 ) 88 ON UPDATE CASCADE, 89 FOREIGN KEY ( 90 category_id 91 ) 92 REFERENCES categories ( 93 id 94 ) 95 ) 96 97 26: 98 -------------------------- 99 CREATE TABLE product_information ( 100 product_id 101 INT8 102 NOT NULL 103 PRIMARY KEY, 104 product_name 105 STRING(50) 106 NOT NULL 107 UNIQUE, 108 product_description 109 STRING(2000), 110 category_id 111 STRING(1) 112 NOT NULL 113 CHECK ( 114 category_id 115 IN ( 116 'A', 117 'B', 118 'C' 119 ) 120 ), 121 weight_class 122 INT8, 123 warranty_period 124 INT8 125 CONSTRAINT valid_warranty CHECK ( 126 warranty_period BETWEEN 0 AND 24 127 ), 128 supplier_id 129 INT8, 130 product_status 131 STRING(20), 132 list_price 133 DECIMAL(8,2), 134 min_price 135 DECIMAL(8,2), 136 catalog_url 137 STRING(50) UNIQUE, 138 date_added 139 DATE 140 DEFAULT current_date(), 141 misc 142 JSONB, 143 full_name 144 STRING 145 AS ( 146 concat( 147 first_name, 148 ' ', 149 last_name 150 ) 151 ) STORED, 152 INDEX date_added_idx ( 153 date_added 154 ), 155 INDEX supp_id_prod_status_idx ( 156 supplier_id, 157 product_status 158 ), 159 customer_id 160 INT8 161 REFERENCES customers_2 ( 162 id 163 ) 164 MATCH FULL 165 ON DELETE CASCADE ON UPDATE CASCADE, 166 INVERTED INDEX details ( 167 misc 168 ), 169 CONSTRAINT price_check 170 CHECK ( 171 list_price 172 >= min_price 173 ), 174 CONSTRAINT supplied_id_fk 175 FOREIGN KEY ( 176 supplier_id 177 ) 178 REFERENCES suppliers ( 179 id 180 ) 181 ON UPDATE CASCADE, 182 FOREIGN KEY ( 183 category_id 184 ) 185 REFERENCES categories ( 186 id 187 ) 188 ) 189 190 29: 191 ----------------------------- 192 CREATE TABLE product_information ( 193 product_id 194 INT8 195 NOT NULL 196 PRIMARY KEY, 197 product_name 198 STRING(50) 199 NOT NULL 200 UNIQUE, 201 product_description 202 STRING(2000), 203 category_id 204 STRING(1) 205 NOT NULL 206 CHECK ( 207 category_id 208 IN ( 209 'A', 210 'B', 211 'C' 212 ) 213 ), 214 weight_class 215 INT8, 216 warranty_period 217 INT8 218 CONSTRAINT valid_warranty CHECK ( 219 warranty_period BETWEEN 0 AND 24 220 ), 221 supplier_id 222 INT8, 223 product_status 224 STRING(20), 225 list_price 226 DECIMAL(8,2), 227 min_price 228 DECIMAL(8,2), 229 catalog_url 230 STRING(50) UNIQUE, 231 date_added 232 DATE 233 DEFAULT current_date(), 234 misc 235 JSONB, 236 full_name 237 STRING 238 AS ( 239 concat( 240 first_name, 241 ' ', 242 last_name 243 ) 244 ) STORED, 245 INDEX date_added_idx ( 246 date_added 247 ), 248 INDEX supp_id_prod_status_idx ( 249 supplier_id, 250 product_status 251 ), 252 customer_id 253 INT8 254 REFERENCES customers_2 ( 255 id 256 ) 257 MATCH FULL 258 ON DELETE CASCADE ON UPDATE CASCADE, 259 INVERTED INDEX details ( 260 misc 261 ), 262 CONSTRAINT price_check 263 CHECK ( 264 list_price 265 >= min_price 266 ), 267 CONSTRAINT supplied_id_fk 268 FOREIGN KEY ( 269 supplier_id 270 ) 271 REFERENCES suppliers ( 272 id 273 ) 274 ON UPDATE CASCADE, 275 FOREIGN KEY (category_id) 276 REFERENCES categories ( 277 id 278 ) 279 ) 280 281 30: 282 ------------------------------ 283 CREATE TABLE product_information ( 284 product_id 285 INT8 286 NOT NULL 287 PRIMARY KEY, 288 product_name 289 STRING(50) 290 NOT NULL 291 UNIQUE, 292 product_description 293 STRING(2000), 294 category_id 295 STRING(1) 296 NOT NULL 297 CHECK ( 298 category_id 299 IN ('A', 'B', 'C') 300 ), 301 weight_class 302 INT8, 303 warranty_period 304 INT8 305 CONSTRAINT valid_warranty CHECK ( 306 warranty_period BETWEEN 0 AND 24 307 ), 308 supplier_id 309 INT8, 310 product_status 311 STRING(20), 312 list_price 313 DECIMAL(8,2), 314 min_price 315 DECIMAL(8,2), 316 catalog_url 317 STRING(50) UNIQUE, 318 date_added 319 DATE 320 DEFAULT current_date(), 321 misc 322 JSONB, 323 full_name 324 STRING 325 AS ( 326 concat( 327 first_name, 328 ' ', 329 last_name 330 ) 331 ) STORED, 332 INDEX date_added_idx ( 333 date_added 334 ), 335 INDEX supp_id_prod_status_idx ( 336 supplier_id, 337 product_status 338 ), 339 customer_id 340 INT8 341 REFERENCES customers_2 ( 342 id 343 ) 344 MATCH FULL 345 ON DELETE CASCADE ON UPDATE CASCADE, 346 INVERTED INDEX details ( 347 misc 348 ), 349 CONSTRAINT price_check 350 CHECK ( 351 list_price 352 >= min_price 353 ), 354 CONSTRAINT supplied_id_fk 355 FOREIGN KEY ( 356 supplier_id 357 ) 358 REFERENCES suppliers ( 359 id 360 ) 361 ON UPDATE CASCADE, 362 FOREIGN KEY (category_id) 363 REFERENCES categories ( 364 id 365 ) 366 ) 367 368 33: 369 --------------------------------- 370 CREATE TABLE product_information ( 371 product_id 372 INT8 373 NOT NULL 374 PRIMARY KEY, 375 product_name 376 STRING(50) 377 NOT NULL 378 UNIQUE, 379 product_description 380 STRING(2000), 381 category_id 382 STRING(1) 383 NOT NULL 384 CHECK ( 385 category_id 386 IN ('A', 'B', 'C') 387 ), 388 weight_class 389 INT8, 390 warranty_period 391 INT8 392 CONSTRAINT valid_warranty CHECK ( 393 warranty_period BETWEEN 0 AND 24 394 ), 395 supplier_id 396 INT8, 397 product_status 398 STRING(20), 399 list_price 400 DECIMAL(8,2), 401 min_price 402 DECIMAL(8,2), 403 catalog_url 404 STRING(50) UNIQUE, 405 date_added 406 DATE 407 DEFAULT current_date(), 408 misc 409 JSONB, 410 full_name 411 STRING 412 AS ( 413 concat( 414 first_name, 415 ' ', 416 last_name 417 ) 418 ) STORED, 419 INDEX date_added_idx ( 420 date_added 421 ), 422 INDEX supp_id_prod_status_idx ( 423 supplier_id, 424 product_status 425 ), 426 customer_id 427 INT8 428 REFERENCES customers_2 ( 429 id 430 ) 431 MATCH FULL 432 ON DELETE CASCADE ON UPDATE CASCADE, 433 INVERTED INDEX details ( 434 misc 435 ), 436 CONSTRAINT price_check 437 CHECK ( 438 list_price 439 >= min_price 440 ), 441 CONSTRAINT supplied_id_fk 442 FOREIGN KEY (supplier_id) 443 REFERENCES suppliers (id) 444 ON UPDATE CASCADE, 445 FOREIGN KEY (category_id) 446 REFERENCES categories ( 447 id 448 ) 449 ) 450 451 34: 452 ---------------------------------- 453 CREATE TABLE product_information ( 454 product_id 455 INT8 NOT NULL PRIMARY KEY, 456 product_name 457 STRING(50) 458 NOT NULL 459 UNIQUE, 460 product_description 461 STRING(2000), 462 category_id 463 STRING(1) 464 NOT NULL 465 CHECK ( 466 category_id 467 IN ('A', 'B', 'C') 468 ), 469 weight_class 470 INT8, 471 warranty_period 472 INT8 473 CONSTRAINT valid_warranty CHECK ( 474 warranty_period BETWEEN 0 AND 24 475 ), 476 supplier_id 477 INT8, 478 product_status 479 STRING(20), 480 list_price 481 DECIMAL(8,2), 482 min_price 483 DECIMAL(8,2), 484 catalog_url 485 STRING(50) UNIQUE, 486 date_added 487 DATE 488 DEFAULT current_date(), 489 misc 490 JSONB, 491 full_name 492 STRING 493 AS ( 494 concat( 495 first_name, 496 ' ', 497 last_name 498 ) 499 ) STORED, 500 INDEX date_added_idx ( 501 date_added 502 ), 503 INDEX supp_id_prod_status_idx ( 504 supplier_id, 505 product_status 506 ), 507 customer_id 508 INT8 509 REFERENCES customers_2 ( 510 id 511 ) 512 MATCH FULL 513 ON DELETE CASCADE ON UPDATE CASCADE, 514 INVERTED INDEX details (misc), 515 CONSTRAINT price_check 516 CHECK ( 517 list_price 518 >= min_price 519 ), 520 CONSTRAINT supplied_id_fk 521 FOREIGN KEY (supplier_id) 522 REFERENCES suppliers (id) 523 ON UPDATE CASCADE, 524 FOREIGN KEY (category_id) 525 REFERENCES categories (id) 526 ) 527 528 35: 529 ----------------------------------- 530 CREATE TABLE product_information ( 531 product_id 532 INT8 NOT NULL PRIMARY KEY, 533 product_name 534 STRING(50) NOT NULL UNIQUE, 535 product_description 536 STRING(2000), 537 category_id 538 STRING(1) 539 NOT NULL 540 CHECK ( 541 category_id 542 IN ('A', 'B', 'C') 543 ), 544 weight_class 545 INT8, 546 warranty_period 547 INT8 548 CONSTRAINT valid_warranty CHECK ( 549 warranty_period BETWEEN 0 AND 24 550 ), 551 supplier_id 552 INT8, 553 product_status 554 STRING(20), 555 list_price 556 DECIMAL(8,2), 557 min_price 558 DECIMAL(8,2), 559 catalog_url 560 STRING(50) UNIQUE, 561 date_added 562 DATE 563 DEFAULT current_date(), 564 misc 565 JSONB, 566 full_name 567 STRING 568 AS ( 569 concat( 570 first_name, 571 ' ', 572 last_name 573 ) 574 ) STORED, 575 INDEX date_added_idx ( 576 date_added 577 ), 578 INDEX supp_id_prod_status_idx ( 579 supplier_id, 580 product_status 581 ), 582 customer_id 583 INT8 584 REFERENCES customers_2 (id) 585 MATCH FULL 586 ON DELETE CASCADE ON UPDATE CASCADE, 587 INVERTED INDEX details (misc), 588 CONSTRAINT price_check 589 CHECK ( 590 list_price >= min_price 591 ), 592 CONSTRAINT supplied_id_fk 593 FOREIGN KEY (supplier_id) 594 REFERENCES suppliers (id) 595 ON UPDATE CASCADE, 596 FOREIGN KEY (category_id) 597 REFERENCES categories (id) 598 ) 599 600 36: 601 ------------------------------------ 602 CREATE TABLE product_information ( 603 product_id 604 INT8 NOT NULL PRIMARY KEY, 605 product_name 606 STRING(50) NOT NULL UNIQUE, 607 product_description 608 STRING(2000), 609 category_id 610 STRING(1) 611 NOT NULL 612 CHECK ( 613 category_id 614 IN ('A', 'B', 'C') 615 ), 616 weight_class 617 INT8, 618 warranty_period 619 INT8 620 CONSTRAINT valid_warranty CHECK ( 621 warranty_period BETWEEN 0 AND 24 622 ), 623 supplier_id 624 INT8, 625 product_status 626 STRING(20), 627 list_price 628 DECIMAL(8,2), 629 min_price 630 DECIMAL(8,2), 631 catalog_url 632 STRING(50) UNIQUE, 633 date_added 634 DATE DEFAULT current_date(), 635 misc 636 JSONB, 637 full_name 638 STRING 639 AS ( 640 concat( 641 first_name, 642 ' ', 643 last_name 644 ) 645 ) STORED, 646 INDEX date_added_idx ( 647 date_added 648 ), 649 INDEX supp_id_prod_status_idx ( 650 supplier_id, 651 product_status 652 ), 653 customer_id 654 INT8 655 REFERENCES customers_2 (id) 656 MATCH FULL 657 ON DELETE CASCADE ON UPDATE CASCADE, 658 INVERTED INDEX details (misc), 659 CONSTRAINT price_check 660 CHECK ( 661 list_price >= min_price 662 ), 663 CONSTRAINT supplied_id_fk 664 FOREIGN KEY (supplier_id) 665 REFERENCES suppliers (id) 666 ON UPDATE CASCADE, 667 FOREIGN KEY (category_id) 668 REFERENCES categories (id) 669 ) 670 671 38: 672 -------------------------------------- 673 CREATE TABLE product_information ( 674 product_id 675 INT8 NOT NULL PRIMARY KEY, 676 product_name 677 STRING(50) NOT NULL UNIQUE, 678 product_description 679 STRING(2000), 680 category_id 681 STRING(1) 682 NOT NULL 683 CHECK ( 684 category_id 685 IN ('A', 'B', 'C') 686 ), 687 weight_class 688 INT8, 689 warranty_period 690 INT8 691 CONSTRAINT valid_warranty CHECK ( 692 warranty_period BETWEEN 0 AND 24 693 ), 694 supplier_id 695 INT8, 696 product_status 697 STRING(20), 698 list_price 699 DECIMAL(8,2), 700 min_price 701 DECIMAL(8,2), 702 catalog_url 703 STRING(50) UNIQUE, 704 date_added 705 DATE DEFAULT current_date(), 706 misc 707 JSONB, 708 full_name 709 STRING 710 AS ( 711 concat( 712 first_name, 713 ' ', 714 last_name 715 ) 716 ) STORED, 717 INDEX date_added_idx (date_added), 718 INDEX supp_id_prod_status_idx ( 719 supplier_id, 720 product_status 721 ), 722 customer_id 723 INT8 724 REFERENCES customers_2 (id) 725 MATCH FULL 726 ON DELETE CASCADE ON UPDATE CASCADE, 727 INVERTED INDEX details (misc), 728 CONSTRAINT price_check 729 CHECK ( 730 list_price >= min_price 731 ), 732 CONSTRAINT supplied_id_fk 733 FOREIGN KEY (supplier_id) 734 REFERENCES suppliers (id) 735 ON UPDATE CASCADE, 736 FOREIGN KEY (category_id) 737 REFERENCES categories (id) 738 ) 739 740 40: 741 ---------------------------------------- 742 CREATE TABLE product_information ( 743 product_id 744 INT8 NOT NULL PRIMARY KEY, 745 product_name 746 STRING(50) NOT NULL UNIQUE, 747 product_description 748 STRING(2000), 749 category_id 750 STRING(1) 751 NOT NULL 752 CHECK ( 753 category_id 754 IN ('A', 'B', 'C') 755 ), 756 weight_class 757 INT8, 758 warranty_period 759 INT8 760 CONSTRAINT valid_warranty CHECK ( 761 warranty_period BETWEEN 0 AND 24 762 ), 763 supplier_id 764 INT8, 765 product_status 766 STRING(20), 767 list_price 768 DECIMAL(8,2), 769 min_price 770 DECIMAL(8,2), 771 catalog_url 772 STRING(50) UNIQUE, 773 date_added 774 DATE DEFAULT current_date(), 775 misc 776 JSONB, 777 full_name 778 STRING 779 AS ( 780 concat( 781 first_name, 782 ' ', 783 last_name 784 ) 785 ) STORED, 786 INDEX date_added_idx (date_added), 787 INDEX supp_id_prod_status_idx ( 788 supplier_id, 789 product_status 790 ), 791 customer_id 792 INT8 793 REFERENCES customers_2 (id) 794 MATCH FULL 795 ON DELETE CASCADE ON UPDATE CASCADE, 796 INVERTED INDEX details (misc), 797 CONSTRAINT price_check 798 CHECK (list_price >= min_price), 799 CONSTRAINT supplied_id_fk 800 FOREIGN KEY (supplier_id) 801 REFERENCES suppliers (id) 802 ON UPDATE CASCADE, 803 FOREIGN KEY (category_id) 804 REFERENCES categories (id) 805 ) 806 807 42: 808 ------------------------------------------ 809 CREATE TABLE product_information ( 810 product_id 811 INT8 NOT NULL PRIMARY KEY, 812 product_name 813 STRING(50) NOT NULL UNIQUE, 814 product_description 815 STRING(2000), 816 category_id 817 STRING(1) 818 NOT NULL 819 CHECK ( 820 category_id IN ('A', 'B', 'C') 821 ), 822 weight_class 823 INT8, 824 warranty_period 825 INT8 826 CONSTRAINT valid_warranty CHECK ( 827 warranty_period BETWEEN 0 AND 24 828 ), 829 supplier_id 830 INT8, 831 product_status 832 STRING(20), 833 list_price 834 DECIMAL(8,2), 835 min_price 836 DECIMAL(8,2), 837 catalog_url 838 STRING(50) UNIQUE, 839 date_added 840 DATE DEFAULT current_date(), 841 misc 842 JSONB, 843 full_name 844 STRING 845 AS ( 846 concat( 847 first_name, 848 ' ', 849 last_name 850 ) 851 ) STORED, 852 INDEX date_added_idx (date_added), 853 INDEX supp_id_prod_status_idx ( 854 supplier_id, 855 product_status 856 ), 857 customer_id 858 INT8 859 REFERENCES customers_2 (id) 860 MATCH FULL 861 ON DELETE CASCADE ON UPDATE CASCADE, 862 INVERTED INDEX details (misc), 863 CONSTRAINT price_check 864 CHECK (list_price >= min_price), 865 CONSTRAINT supplied_id_fk 866 FOREIGN KEY (supplier_id) 867 REFERENCES suppliers (id) 868 ON UPDATE CASCADE, 869 FOREIGN KEY (category_id) 870 REFERENCES categories (id) 871 ) 872 873 46: 874 ---------------------------------------------- 875 CREATE TABLE product_information ( 876 product_id 877 INT8 NOT NULL PRIMARY KEY, 878 product_name 879 STRING(50) NOT NULL UNIQUE, 880 product_description 881 STRING(2000), 882 category_id 883 STRING(1) 884 NOT NULL 885 CHECK ( 886 category_id IN ('A', 'B', 'C') 887 ), 888 weight_class 889 INT8, 890 warranty_period 891 INT8 892 CONSTRAINT valid_warranty CHECK ( 893 warranty_period BETWEEN 0 AND 24 894 ), 895 supplier_id 896 INT8, 897 product_status 898 STRING(20), 899 list_price 900 DECIMAL(8,2), 901 min_price 902 DECIMAL(8,2), 903 catalog_url 904 STRING(50) UNIQUE, 905 date_added 906 DATE DEFAULT current_date(), 907 misc 908 JSONB, 909 full_name 910 STRING 911 AS ( 912 concat(first_name, ' ', last_name) 913 ) STORED, 914 INDEX date_added_idx (date_added), 915 INDEX supp_id_prod_status_idx ( 916 supplier_id, 917 product_status 918 ), 919 customer_id 920 INT8 921 REFERENCES customers_2 (id) 922 MATCH FULL 923 ON DELETE CASCADE ON UPDATE CASCADE, 924 INVERTED INDEX details (misc), 925 CONSTRAINT price_check 926 CHECK (list_price >= min_price), 927 CONSTRAINT supplied_id_fk 928 FOREIGN KEY (supplier_id) 929 REFERENCES suppliers (id) 930 ON UPDATE CASCADE, 931 FOREIGN KEY (category_id) 932 REFERENCES categories (id) 933 ) 934 935 47: 936 ----------------------------------------------- 937 CREATE TABLE product_information ( 938 product_id 939 INT8 NOT NULL PRIMARY KEY, 940 product_name 941 STRING(50) NOT NULL UNIQUE, 942 product_description 943 STRING(2000), 944 category_id 945 STRING(1) 946 NOT NULL 947 CHECK (category_id IN ('A', 'B', 'C')), 948 weight_class 949 INT8, 950 warranty_period 951 INT8 952 CONSTRAINT valid_warranty CHECK ( 953 warranty_period BETWEEN 0 AND 24 954 ), 955 supplier_id 956 INT8, 957 product_status 958 STRING(20), 959 list_price 960 DECIMAL(8,2), 961 min_price 962 DECIMAL(8,2), 963 catalog_url 964 STRING(50) UNIQUE, 965 date_added 966 DATE DEFAULT current_date(), 967 misc 968 JSONB, 969 full_name 970 STRING 971 AS ( 972 concat(first_name, ' ', last_name) 973 ) STORED, 974 INDEX date_added_idx (date_added), 975 INDEX supp_id_prod_status_idx ( 976 supplier_id, 977 product_status 978 ), 979 customer_id 980 INT8 981 REFERENCES customers_2 (id) 982 MATCH FULL 983 ON DELETE CASCADE ON UPDATE CASCADE, 984 INVERTED INDEX details (misc), 985 CONSTRAINT price_check 986 CHECK (list_price >= min_price), 987 CONSTRAINT supplied_id_fk 988 FOREIGN KEY (supplier_id) 989 REFERENCES suppliers (id) 990 ON UPDATE CASCADE, 991 FOREIGN KEY (category_id) 992 REFERENCES categories (id) 993 ) 994 995 55: 996 ------------------------------------------------------- 997 CREATE TABLE product_information ( 998 product_id 999 INT8 NOT NULL PRIMARY KEY, 1000 product_name 1001 STRING(50) NOT NULL UNIQUE, 1002 product_description 1003 STRING(2000), 1004 category_id 1005 STRING(1) 1006 NOT NULL 1007 CHECK (category_id IN ('A', 'B', 'C')), 1008 weight_class 1009 INT8, 1010 warranty_period 1011 INT8 1012 CONSTRAINT valid_warranty CHECK ( 1013 warranty_period BETWEEN 0 AND 24 1014 ), 1015 supplier_id 1016 INT8, 1017 product_status 1018 STRING(20), 1019 list_price 1020 DECIMAL(8,2), 1021 min_price 1022 DECIMAL(8,2), 1023 catalog_url 1024 STRING(50) UNIQUE, 1025 date_added 1026 DATE DEFAULT current_date(), 1027 misc 1028 JSONB, 1029 full_name 1030 STRING 1031 AS (concat(first_name, ' ', last_name)) STORED, 1032 INDEX date_added_idx (date_added), 1033 INDEX supp_id_prod_status_idx ( 1034 supplier_id, 1035 product_status 1036 ), 1037 customer_id 1038 INT8 1039 REFERENCES customers_2 (id) 1040 MATCH FULL 1041 ON DELETE CASCADE ON UPDATE CASCADE, 1042 INVERTED INDEX details (misc), 1043 CONSTRAINT price_check 1044 CHECK (list_price >= min_price), 1045 CONSTRAINT supplied_id_fk 1046 FOREIGN KEY (supplier_id) 1047 REFERENCES suppliers (id) 1048 ON UPDATE CASCADE, 1049 FOREIGN KEY (category_id) 1050 REFERENCES categories (id) 1051 ) 1052 1053 56: 1054 -------------------------------------------------------- 1055 CREATE TABLE product_information ( 1056 product_id 1057 INT8 NOT NULL PRIMARY KEY, 1058 product_name 1059 STRING(50) NOT NULL UNIQUE, 1060 product_description 1061 STRING(2000), 1062 category_id 1063 STRING(1) 1064 NOT NULL 1065 CHECK (category_id IN ('A', 'B', 'C')), 1066 weight_class 1067 INT8, 1068 warranty_period 1069 INT8 1070 CONSTRAINT valid_warranty CHECK ( 1071 warranty_period BETWEEN 0 AND 24 1072 ), 1073 supplier_id 1074 INT8, 1075 product_status 1076 STRING(20), 1077 list_price 1078 DECIMAL(8,2), 1079 min_price 1080 DECIMAL(8,2), 1081 catalog_url 1082 STRING(50) UNIQUE, 1083 date_added 1084 DATE DEFAULT current_date(), 1085 misc 1086 JSONB, 1087 full_name 1088 STRING 1089 AS (concat(first_name, ' ', last_name)) STORED, 1090 INDEX date_added_idx (date_added), 1091 INDEX supp_id_prod_status_idx ( 1092 supplier_id, 1093 product_status 1094 ), 1095 customer_id 1096 INT8 1097 REFERENCES customers_2 (id) 1098 MATCH FULL 1099 ON DELETE CASCADE ON UPDATE CASCADE, 1100 INVERTED INDEX details (misc), 1101 CONSTRAINT price_check 1102 CHECK (list_price >= min_price), 1103 CONSTRAINT supplied_id_fk 1104 FOREIGN KEY (supplier_id) 1105 REFERENCES suppliers (id) 1106 ON UPDATE CASCADE, 1107 FOREIGN KEY (category_id) REFERENCES categories (id) 1108 ) 1109 1110 59: 1111 ----------------------------------------------------------- 1112 CREATE TABLE product_information ( 1113 product_id 1114 INT8 NOT NULL PRIMARY KEY, 1115 product_name 1116 STRING(50) NOT NULL UNIQUE, 1117 product_description 1118 STRING(2000), 1119 category_id 1120 STRING(1) 1121 NOT NULL 1122 CHECK (category_id IN ('A', 'B', 'C')), 1123 weight_class 1124 INT8, 1125 warranty_period 1126 INT8 1127 CONSTRAINT valid_warranty CHECK ( 1128 warranty_period BETWEEN 0 AND 24 1129 ), 1130 supplier_id 1131 INT8, 1132 product_status 1133 STRING(20), 1134 list_price 1135 DECIMAL(8,2), 1136 min_price 1137 DECIMAL(8,2), 1138 catalog_url 1139 STRING(50) UNIQUE, 1140 date_added 1141 DATE DEFAULT current_date(), 1142 misc 1143 JSONB, 1144 full_name 1145 STRING 1146 AS (concat(first_name, ' ', last_name)) STORED, 1147 INDEX date_added_idx (date_added), 1148 INDEX supp_id_prod_status_idx ( 1149 supplier_id, 1150 product_status 1151 ), 1152 customer_id 1153 INT8 1154 REFERENCES customers_2 (id) 1155 MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1156 INVERTED INDEX details (misc), 1157 CONSTRAINT price_check CHECK (list_price >= min_price), 1158 CONSTRAINT supplied_id_fk 1159 FOREIGN KEY (supplier_id) 1160 REFERENCES suppliers (id) 1161 ON UPDATE CASCADE, 1162 FOREIGN KEY (category_id) REFERENCES categories (id) 1163 ) 1164 1165 62: 1166 -------------------------------------------------------------- 1167 CREATE TABLE product_information ( 1168 product_id 1169 INT8 NOT NULL PRIMARY KEY, 1170 product_name 1171 STRING(50) NOT NULL UNIQUE, 1172 product_description 1173 STRING(2000), 1174 category_id 1175 STRING(1) 1176 NOT NULL 1177 CHECK (category_id IN ('A', 'B', 'C')), 1178 weight_class 1179 INT8, 1180 warranty_period 1181 INT8 1182 CONSTRAINT valid_warranty CHECK ( 1183 warranty_period BETWEEN 0 AND 24 1184 ), 1185 supplier_id 1186 INT8, 1187 product_status 1188 STRING(20), 1189 list_price 1190 DECIMAL(8,2), 1191 min_price 1192 DECIMAL(8,2), 1193 catalog_url 1194 STRING(50) UNIQUE, 1195 date_added 1196 DATE DEFAULT current_date(), 1197 misc 1198 JSONB, 1199 full_name 1200 STRING AS (concat(first_name, ' ', last_name)) STORED, 1201 INDEX date_added_idx (date_added), 1202 INDEX supp_id_prod_status_idx ( 1203 supplier_id, 1204 product_status 1205 ), 1206 customer_id 1207 INT8 1208 REFERENCES customers_2 (id) 1209 MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1210 INVERTED INDEX details (misc), 1211 CONSTRAINT price_check CHECK (list_price >= min_price), 1212 CONSTRAINT supplied_id_fk 1213 FOREIGN KEY (supplier_id) 1214 REFERENCES suppliers (id) 1215 ON UPDATE CASCADE, 1216 FOREIGN KEY (category_id) REFERENCES categories (id) 1217 ) 1218 1219 64: 1220 ---------------------------------------------------------------- 1221 CREATE TABLE product_information ( 1222 product_id 1223 INT8 NOT NULL PRIMARY KEY, 1224 product_name 1225 STRING(50) NOT NULL UNIQUE, 1226 product_description 1227 STRING(2000), 1228 category_id 1229 STRING(1) 1230 NOT NULL 1231 CHECK (category_id IN ('A', 'B', 'C')), 1232 weight_class 1233 INT8, 1234 warranty_period 1235 INT8 1236 CONSTRAINT valid_warranty CHECK ( 1237 warranty_period BETWEEN 0 AND 24 1238 ), 1239 supplier_id 1240 INT8, 1241 product_status 1242 STRING(20), 1243 list_price 1244 DECIMAL(8,2), 1245 min_price 1246 DECIMAL(8,2), 1247 catalog_url 1248 STRING(50) UNIQUE, 1249 date_added 1250 DATE DEFAULT current_date(), 1251 misc 1252 JSONB, 1253 full_name 1254 STRING AS (concat(first_name, ' ', last_name)) STORED, 1255 INDEX date_added_idx (date_added), 1256 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1257 customer_id 1258 INT8 1259 REFERENCES customers_2 (id) 1260 MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1261 INVERTED INDEX details (misc), 1262 CONSTRAINT price_check CHECK (list_price >= min_price), 1263 CONSTRAINT supplied_id_fk 1264 FOREIGN KEY (supplier_id) 1265 REFERENCES suppliers (id) 1266 ON UPDATE CASCADE, 1267 FOREIGN KEY (category_id) REFERENCES categories (id) 1268 ) 1269 1270 66: 1271 ------------------------------------------------------------------ 1272 CREATE TABLE product_information ( 1273 product_id 1274 INT8 NOT NULL PRIMARY KEY, 1275 product_name 1276 STRING(50) NOT NULL UNIQUE, 1277 product_description 1278 STRING(2000), 1279 category_id 1280 STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), 1281 weight_class 1282 INT8, 1283 warranty_period 1284 INT8 1285 CONSTRAINT valid_warranty CHECK ( 1286 warranty_period BETWEEN 0 AND 24 1287 ), 1288 supplier_id 1289 INT8, 1290 product_status 1291 STRING(20), 1292 list_price 1293 DECIMAL(8,2), 1294 min_price 1295 DECIMAL(8,2), 1296 catalog_url 1297 STRING(50) UNIQUE, 1298 date_added 1299 DATE DEFAULT current_date(), 1300 misc 1301 JSONB, 1302 full_name 1303 STRING AS (concat(first_name, ' ', last_name)) STORED, 1304 INDEX date_added_idx (date_added), 1305 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1306 customer_id 1307 INT8 1308 REFERENCES customers_2 (id) 1309 MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1310 INVERTED INDEX details (misc), 1311 CONSTRAINT price_check CHECK (list_price >= min_price), 1312 CONSTRAINT supplied_id_fk 1313 FOREIGN KEY (supplier_id) 1314 REFERENCES suppliers (id) 1315 ON UPDATE CASCADE, 1316 FOREIGN KEY (category_id) REFERENCES categories (id) 1317 ) 1318 1319 75: 1320 --------------------------------------------------------------------------- 1321 CREATE TABLE product_information ( 1322 product_id 1323 INT8 NOT NULL PRIMARY KEY, 1324 product_name 1325 STRING(50) NOT NULL UNIQUE, 1326 product_description 1327 STRING(2000), 1328 category_id 1329 STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), 1330 weight_class 1331 INT8, 1332 warranty_period 1333 INT8 1334 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), 1335 supplier_id 1336 INT8, 1337 product_status 1338 STRING(20), 1339 list_price 1340 DECIMAL(8,2), 1341 min_price 1342 DECIMAL(8,2), 1343 catalog_url 1344 STRING(50) UNIQUE, 1345 date_added 1346 DATE DEFAULT current_date(), 1347 misc 1348 JSONB, 1349 full_name 1350 STRING AS (concat(first_name, ' ', last_name)) STORED, 1351 INDEX date_added_idx (date_added), 1352 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1353 customer_id 1354 INT8 1355 REFERENCES customers_2 (id) 1356 MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1357 INVERTED INDEX details (misc), 1358 CONSTRAINT price_check CHECK (list_price >= min_price), 1359 CONSTRAINT supplied_id_fk 1360 FOREIGN KEY (supplier_id) 1361 REFERENCES suppliers (id) 1362 ON UPDATE CASCADE, 1363 FOREIGN KEY (category_id) REFERENCES categories (id) 1364 ) 1365 1366 78: 1367 ------------------------------------------------------------------------------ 1368 CREATE TABLE product_information ( 1369 product_id 1370 INT8 NOT NULL PRIMARY KEY, 1371 product_name 1372 STRING(50) NOT NULL UNIQUE, 1373 product_description 1374 STRING(2000), 1375 category_id 1376 STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), 1377 weight_class 1378 INT8, 1379 warranty_period 1380 INT8 1381 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), 1382 supplier_id 1383 INT8, 1384 product_status 1385 STRING(20), 1386 list_price 1387 DECIMAL(8,2), 1388 min_price 1389 DECIMAL(8,2), 1390 catalog_url 1391 STRING(50) UNIQUE, 1392 date_added 1393 DATE DEFAULT current_date(), 1394 misc 1395 JSONB, 1396 full_name 1397 STRING AS (concat(first_name, ' ', last_name)) STORED, 1398 INDEX date_added_idx (date_added), 1399 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1400 customer_id 1401 INT8 1402 REFERENCES customers_2 (id) 1403 MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1404 INVERTED INDEX details (misc), 1405 CONSTRAINT price_check CHECK (list_price >= min_price), 1406 CONSTRAINT supplied_id_fk 1407 FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ON UPDATE CASCADE, 1408 FOREIGN KEY (category_id) REFERENCES categories (id) 1409 ) 1410 1411 80: 1412 -------------------------------------------------------------------------------- 1413 CREATE TABLE product_information ( 1414 product_id 1415 INT8 NOT NULL PRIMARY KEY, 1416 product_name 1417 STRING(50) NOT NULL UNIQUE, 1418 product_description 1419 STRING(2000), 1420 category_id 1421 STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), 1422 weight_class 1423 INT8, 1424 warranty_period 1425 INT8 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), 1426 supplier_id 1427 INT8, 1428 product_status 1429 STRING(20), 1430 list_price 1431 DECIMAL(8,2), 1432 min_price 1433 DECIMAL(8,2), 1434 catalog_url 1435 STRING(50) UNIQUE, 1436 date_added 1437 DATE DEFAULT current_date(), 1438 misc 1439 JSONB, 1440 full_name 1441 STRING AS (concat(first_name, ' ', last_name)) STORED, 1442 INDEX date_added_idx (date_added), 1443 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1444 customer_id 1445 INT8 1446 REFERENCES customers_2 (id) 1447 MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1448 INVERTED INDEX details (misc), 1449 CONSTRAINT price_check CHECK (list_price >= min_price), 1450 CONSTRAINT supplied_id_fk 1451 FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ON UPDATE CASCADE, 1452 FOREIGN KEY (category_id) REFERENCES categories (id) 1453 ) 1454 1455 83: 1456 ----------------------------------------------------------------------------------- 1457 CREATE TABLE product_information ( 1458 product_id 1459 INT8 NOT NULL PRIMARY KEY, 1460 product_name 1461 STRING(50) NOT NULL UNIQUE, 1462 product_description 1463 STRING(2000), 1464 category_id 1465 STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), 1466 weight_class 1467 INT8, 1468 warranty_period 1469 INT8 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), 1470 supplier_id 1471 INT8, 1472 product_status 1473 STRING(20), 1474 list_price 1475 DECIMAL(8,2), 1476 min_price 1477 DECIMAL(8,2), 1478 catalog_url 1479 STRING(50) UNIQUE, 1480 date_added 1481 DATE DEFAULT current_date(), 1482 misc 1483 JSONB, 1484 full_name 1485 STRING AS (concat(first_name, ' ', last_name)) STORED, 1486 INDEX date_added_idx (date_added), 1487 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1488 customer_id 1489 INT8 1490 REFERENCES customers_2 (id) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1491 INVERTED INDEX details (misc), 1492 CONSTRAINT price_check CHECK (list_price >= min_price), 1493 CONSTRAINT supplied_id_fk 1494 FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ON UPDATE CASCADE, 1495 FOREIGN KEY (category_id) REFERENCES categories (id) 1496 ) 1497 1498 88: 1499 ---------------------------------------------------------------------------------------- 1500 CREATE TABLE product_information ( 1501 product_id 1502 INT8 NOT NULL PRIMARY KEY, 1503 product_name 1504 STRING(50) NOT NULL UNIQUE, 1505 product_description 1506 STRING(2000), 1507 category_id 1508 STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), 1509 weight_class 1510 INT8, 1511 warranty_period 1512 INT8 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), 1513 supplier_id 1514 INT8, 1515 product_status 1516 STRING(20), 1517 list_price 1518 DECIMAL(8,2), 1519 min_price 1520 DECIMAL(8,2), 1521 catalog_url 1522 STRING(50) UNIQUE, 1523 date_added 1524 DATE DEFAULT current_date(), 1525 misc 1526 JSONB, 1527 full_name 1528 STRING AS (concat(first_name, ' ', last_name)) STORED, 1529 INDEX date_added_idx (date_added), 1530 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1531 customer_id 1532 INT8 REFERENCES customers_2 (id) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1533 INVERTED INDEX details (misc), 1534 CONSTRAINT price_check CHECK (list_price >= min_price), 1535 CONSTRAINT supplied_id_fk 1536 FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ON UPDATE CASCADE, 1537 FOREIGN KEY (category_id) REFERENCES categories (id) 1538 ) 1539 1540 96: 1541 ------------------------------------------------------------------------------------------------ 1542 CREATE TABLE product_information ( 1543 product_id 1544 INT8 NOT NULL PRIMARY KEY, 1545 product_name 1546 STRING(50) NOT NULL UNIQUE, 1547 product_description 1548 STRING(2000), 1549 category_id 1550 STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), 1551 weight_class 1552 INT8, 1553 warranty_period 1554 INT8 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), 1555 supplier_id 1556 INT8, 1557 product_status 1558 STRING(20), 1559 list_price 1560 DECIMAL(8,2), 1561 min_price 1562 DECIMAL(8,2), 1563 catalog_url 1564 STRING(50) UNIQUE, 1565 date_added 1566 DATE DEFAULT current_date(), 1567 misc 1568 JSONB, 1569 full_name 1570 STRING AS (concat(first_name, ' ', last_name)) STORED, 1571 INDEX date_added_idx (date_added), 1572 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1573 customer_id INT8 REFERENCES customers_2 (id) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1574 INVERTED INDEX details (misc), 1575 CONSTRAINT price_check CHECK (list_price >= min_price), 1576 CONSTRAINT supplied_id_fk 1577 FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ON UPDATE CASCADE, 1578 FOREIGN KEY (category_id) REFERENCES categories (id) 1579 ) 1580 1581 100: 1582 ---------------------------------------------------------------------------------------------------- 1583 CREATE TABLE product_information ( 1584 product_id 1585 INT8 NOT NULL PRIMARY KEY, 1586 product_name 1587 STRING(50) NOT NULL UNIQUE, 1588 product_description 1589 STRING(2000), 1590 category_id 1591 STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), 1592 weight_class 1593 INT8, 1594 warranty_period 1595 INT8 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), 1596 supplier_id 1597 INT8, 1598 product_status 1599 STRING(20), 1600 list_price 1601 DECIMAL(8,2), 1602 min_price 1603 DECIMAL(8,2), 1604 catalog_url 1605 STRING(50) UNIQUE, 1606 date_added 1607 DATE DEFAULT current_date(), 1608 misc 1609 JSONB, 1610 full_name 1611 STRING AS (concat(first_name, ' ', last_name)) STORED, 1612 INDEX date_added_idx (date_added), 1613 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1614 customer_id INT8 REFERENCES customers_2 (id) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1615 INVERTED INDEX details (misc), 1616 CONSTRAINT price_check CHECK (list_price >= min_price), 1617 CONSTRAINT supplied_id_fk FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ON UPDATE CASCADE, 1618 FOREIGN KEY (category_id) REFERENCES categories (id) 1619 ) 1620 1621 537: 1622 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1623 CREATE TABLE product_information ( 1624 product_id INT8 NOT NULL PRIMARY KEY, product_name STRING(50) NOT NULL UNIQUE, product_description STRING(2000), category_id STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), weight_class INT8, warranty_period INT8 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), supplier_id INT8, product_status STRING(20), list_price DECIMAL(8,2), min_price DECIMAL(8,2), catalog_url STRING(50) UNIQUE, date_added DATE DEFAULT current_date(), misc JSONB, full_name STRING AS (concat(first_name, ' ', last_name)) STORED, 1625 INDEX date_added_idx (date_added), 1626 INDEX supp_id_prod_status_idx (supplier_id, product_status), 1627 customer_id INT8 REFERENCES customers_2 (id) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, 1628 INVERTED INDEX details (misc), 1629 CONSTRAINT price_check CHECK (list_price >= min_price), 1630 CONSTRAINT supplied_id_fk FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ON UPDATE CASCADE, 1631 FOREIGN KEY (category_id) REFERENCES categories (id) 1632 ) 1633 1634 994: 1635 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1636 CREATE TABLE product_information (product_id INT8 NOT NULL PRIMARY KEY, product_name STRING(50) NOT NULL UNIQUE, product_description STRING(2000), category_id STRING(1) NOT NULL CHECK (category_id IN ('A', 'B', 'C')), weight_class INT8, warranty_period INT8 CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24), supplier_id INT8, product_status STRING(20), list_price DECIMAL(8,2), min_price DECIMAL(8,2), catalog_url STRING(50) UNIQUE, date_added DATE DEFAULT current_date(), misc JSONB, full_name STRING AS (concat(first_name, ' ', last_name)) STORED, INDEX date_added_idx (date_added), INDEX supp_id_prod_status_idx (supplier_id, product_status), customer_id INT8 REFERENCES customers_2 (id) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, INVERTED INDEX details (misc), CONSTRAINT price_check CHECK (list_price >= min_price), CONSTRAINT supplied_id_fk FOREIGN KEY (supplier_id) REFERENCES suppliers (id) ON UPDATE CASCADE, FOREIGN KEY (category_id) REFERENCES categories (id)) 1637 1638