Coupons With an Identity Column

Easy

Description

Create a coupons table:

column	rule
coupon_id	a whole number, numbered automatically; an id typed by hand is always refused; the primary key
code	text of up to 20 characters, required, and no two coupons share a code
discount_pct	`NUMERIC(5, 2)`, required

Then check the table with this query:

Code
SELECT column_name, data_type, character_maximum_length, numeric_precision, numeric_scale,
       is_nullable, is_identity, identity_generation
FROM information_schema.columns
WHERE table_name = 'coupons'
ORDER BY ordinal_position;

Finish with exactly this query.

Tables

This problem only uses the table you create.

Description

column_name	data_type	character_maximum_length	numeric_precision	numeric_scale	is_nullable	is_identity	identity_generation
coupon_id	integer	NULL	32	0	NO	YES	ALWAYS
code	character varying	20	NULL	NULL	NO	NO	NULL
discount_pct	numeric	NULL	5	2	NO	NO	NULL

Create a coupons table:

column	rule
coupon_id	a whole number, numbered automatically; an id typed by hand is always refused; the primary key
code	text of up to 20 characters, required, and no two coupons share a code
discount_pct	`NUMERIC(5, 2)`, required

Then check the table with this query:

Code
SELECT column_name, data_type, character_maximum_length, numeric_precision, numeric_scale,
       is_nullable, is_identity, identity_generation
FROM information_schema.columns
WHERE table_name = 'coupons'
ORDER BY ordinal_position;

Finish with exactly this query.

Description

Create a coupons table:

column	rule
coupon_id	a whole number, numbered automatically; an id typed by hand is always refused; the primary key
code	text of up to 20 characters, required, and no two coupons share a code
discount_pct	`NUMERIC(5, 2)`, required

Then check the table with this query:

Code
SELECT column_name, data_type, character_maximum_length, numeric_precision, numeric_scale,
       is_nullable, is_identity, identity_generation
FROM information_schema.columns
WHERE table_name = 'coupons'
ORDER BY ordinal_position;

Finish with exactly this query.

column_name	data_type	character_maximum_length	numeric_precision	numeric_scale	is_nullable	is_identity	identity_generation
coupon_id	integer	NULL	32	0	NO	YES	ALWAYS
code	character varying	20	NULL	NULL	NO	NO	NULL
discount_pct	numeric	NULL	5	2	NO	NO	NULL

column_name

data_type

character_maximum_length

numeric_precision

numeric_scale

is_nullable

is_identity

identity_generation

coupon_id

integer

NULL

YES

ALWAYS

code

character varying

NULL

discount_pct

numeric

NULL