drop table emp cascade;
create table emp (
	code integer primary key,
	depcode integer not null,
	depname text not null,
	name text not null,
	gender integer check(gender in(1,2)) -- 1:male, 2:female
);
insert into emp values(564001, 1001, '総務部', '鈴木義男', 1);
insert into emp values(564002, 1001, '営業部', '斎藤洋子', 2);