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