github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_table.sql (about)

     1  CREATE TABLE product_information (
     2      product_id           INT PRIMARY KEY NOT NULL,
     3      product_name         STRING(50) UNIQUE NOT NULL,
     4      product_description  STRING(2000),
     5      category_id          STRING(1) NOT NULL CHECK (category_id IN ('A','B','C')),
     6      weight_class         INT,
     7      warranty_period      INT CONSTRAINT valid_warranty CHECK (warranty_period BETWEEN 0 AND 24),
     8      supplier_id          INT,
     9      product_status       STRING(20),
    10      list_price           DECIMAL(8,2),
    11      min_price            DECIMAL(8,2),
    12      catalog_url          STRING(50) UNIQUE,
    13      date_added           DATE DEFAULT current_date(),
    14      misc                 JSONB,
    15      full_name STRING AS (concat(first_name, ' ', last_name)) STORED,
    16      INDEX date_added_idx (date_added),
    17      INDEX supp_id_prod_status_idx (supplier_id, product_status),
    18      customer_id INT REFERENCES customers_2(id) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE,
    19      INVERTED INDEX details (misc),
    20      CONSTRAINT price_check CHECK (list_price >= min_price),
    21      CONSTRAINT supplied_id_fk FOREIGN KEY (supplier_id) REFERENCES suppliers(id) ON UPDATE CASCADE,
    22      FOREIGN KEY (category_id) REFERENCES categories(id)
    23  )