github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/create_table.ref.golden.short (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 NOT NULL PRIMARY KEY,
     8  	product_name
     9  		STRING(50) NOT NULL UNIQUE,
    10  	product_description
    11  		STRING(2000),
    12  	category_id
    13  		STRING(1)
    14  		NOT NULL
    15  		CHECK (
    16  			category_id
    17  			IN ('A', 'B', 'C')
    18  		),
    19  	weight_class
    20  		INT8,
    21  	warranty_period
    22  		INT8
    23  		CONSTRAINT valid_warranty CHECK (
    24  			warranty_period BETWEEN 0 AND 24
    25  		),
    26  	supplier_id
    27  		INT8,
    28  	product_status
    29  		STRING(20),
    30  	list_price
    31  		DECIMAL(8,2),
    32  	min_price
    33  		DECIMAL(8,2),
    34  	catalog_url
    35  		STRING(50) UNIQUE,
    36  	date_added
    37  		DATE DEFAULT current_date(),
    38  	misc
    39  		JSONB,
    40  	full_name
    41  		STRING
    42  		AS (
    43  			concat(
    44  				first_name,
    45  				' ',
    46  				last_name
    47  			)
    48  		) STORED,
    49  	INDEX date_added_idx (date_added),
    50  	INDEX supp_id_prod_status_idx (
    51  		supplier_id,
    52  		product_status
    53  	),
    54  	customer_id
    55  		INT8
    56  		REFERENCES customers_2 (id)
    57  			MATCH FULL
    58  			ON DELETE CASCADE ON UPDATE CASCADE,
    59  	INVERTED INDEX details (misc),
    60  	CONSTRAINT price_check
    61  		CHECK (list_price >= min_price),
    62  	CONSTRAINT supplied_id_fk
    63  		FOREIGN KEY (supplier_id)
    64  		REFERENCES suppliers (id)
    65  		ON UPDATE CASCADE,
    66  	FOREIGN KEY (category_id)
    67  		REFERENCES categories (id)
    68  )
    69  
    70