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