CREATE TABLE staff
(
address_id integer NOT NULL,
mobile varchar(15) NOT NULL,
job_title_id integer NOT NULL,
is_active char(1) NOT NULL DEFAULT Y,
CONSTRAINT staff_pk PRIMARY KEY (id)
)
Y需要用引号括起来