drop table emp;
drop sequence seq;
create sequence seq start 564001;
create table emp (
	code integer primary key default nextval('seq'),
	name text not null,
	gender integer check(gender in(1, 2)), -- 1:male, 2:female
	age integer check(age >= 18) default 22,
	hiredate date default current_date
);