Create a Wishlist Table

Easy

Description

Customers want to save products for later. Create a table wishlist with these columns, in this order:

column	holds	required
wishlist_id	a whole number	no
customer_id	a whole number	yes
product_id	a whole number	yes
note	text of up to 100 characters	no
added_on	a date	yes

Then check the table with this query:

Code
SELECT column_name, data_type, character_maximum_length, is_nullable
FROM information_schema.columns
WHERE table_name = 'wishlist'
ORDER BY ordinal_position;

Finish with exactly this query.

Tables

This problem only uses the table you create.

Create a Wishlist Table

Easy

Description

Customers want to save products for later. Create a table wishlist with these columns, in this order:

column	holds	required
wishlist_id	a whole number	no
customer_id	a whole number	yes
product_id	a whole number	yes
note	text of up to 100 characters	no
added_on	a date	yes

Then check the table with this query:

Code
SELECT column_name, data_type, character_maximum_length, is_nullable
FROM information_schema.columns
WHERE table_name = 'wishlist'
ORDER BY ordinal_position;

Finish with exactly this query.

Tables

This problem only uses the table you create.

column_name	data_type	character_maximum_length	is_nullable
wishlist_id	integer	NULL	YES
customer_id	integer	NULL	NO
product_id	integer	NULL	NO
note	character varying	100	YES
added_on	date	NULL	NO

Create a Wishlist Table

Easy

Description

Customers want to save products for later. Create a table wishlist with these columns, in this order:

column	holds	required
wishlist_id	a whole number	no
customer_id	a whole number	yes
product_id	a whole number	yes
note	text of up to 100 characters	no
added_on	a date	yes

Then check the table with this query:

Code
SELECT column_name, data_type, character_maximum_length, is_nullable
FROM information_schema.columns
WHERE table_name = 'wishlist'
ORDER BY ordinal_position;

Finish with exactly this query.

Tables

This problem only uses the table you create.

Create a Wishlist Table

Easy

Description

Customers want to save products for later. Create a table wishlist with these columns, in this order:

column	holds	required
wishlist_id	a whole number	no
customer_id	a whole number	yes
product_id	a whole number	yes
note	text of up to 100 characters	no
added_on	a date	yes

Then check the table with this query:

Code
SELECT column_name, data_type, character_maximum_length, is_nullable
FROM information_schema.columns
WHERE table_name = 'wishlist'
ORDER BY ordinal_position;

Finish with exactly this query.

Tables

This problem only uses the table you create.