Reshape the Products Table

Easy

Description

The products table is being tidied up:

rename stock to stock_qty
store price as NUMERIC(12, 2)
remove the tags column, which is no longer used

Then check the table with this query:

Code
SELECT column_name, data_type, numeric_precision, numeric_scale
FROM information_schema.columns
WHERE table_name = 'products'
ORDER BY ordinal_position;

Finish with exactly this query.

Tables

products
product_id (PK)
product_name
category_id (FK)
price
stock
rating
is_available
tags
specs
created_at

Description

The products table is being tidied up:

column_name	data_type	numeric_precision	numeric_scale
product_id	integer	32	0
product_name	character varying	NULL	NULL
category_id	integer	32	0
price	numeric	12	2
stock_qty	integer	32	0
rating	numeric	2	1
is_available	boolean	NULL	NULL
specs	jsonb	NULL	NULL
created_at	timestamp with time zone	NULL	NULL

rename stock to stock_qty

store price as NUMERIC(12, 2)

remove the tags column, which is no longer used

Then check the table with this query:

Code
SELECT column_name, data_type, numeric_precision, numeric_scale
FROM information_schema.columns
WHERE table_name = 'products'
ORDER BY ordinal_position;

Finish with exactly this query.

products

product_id (PK)

product_name

category_id (FK)

price

stock

rating

is_available

tags

specs

created_at

Description

The products table is being tidied up:

rename stock to stock_qty

store price as NUMERIC(12, 2)

remove the tags column, which is no longer used

Then check the table with this query:

Code
SELECT column_name, data_type, numeric_precision, numeric_scale
FROM information_schema.columns
WHERE table_name = 'products'
ORDER BY ordinal_position;

Finish with exactly this query.

products

product_id (PK)

product_name

category_id (FK)

price

stock

rating

is_available