create table seat_type
(name varchar(15) NOT NULL,
 description varchar(120),
 relative_quality INTEGER,
 constraint st_seat_type_pk primary key(name)
);

insert into seat_type(name,description,relative_quality)
values('luxury','Excellent seats - box seats, behind the plate, etc. etc.',1);
insert into seat_type(name,description,relative_quality)
values('premium','Really good seats - first level, mid field, etc. etc.',2);
insert into seat_type(name,description,relative_quality)
values('standard','Standard seats - not super awesome but pretty good',3);
insert into seat_type(name,description,relative_quality)
values('sub-standard','End zone, nose bleed, etc.',4);
insert into seat_type(name,description,relative_quality)
values('obstructed','Pretty crappy, partially obstructed seats',5);
insert into seat_type(name,description,relative_quality)
values('standing','Really? That''s not a seat at all now, is it?',10);