drop table emp; create table emp ( code integer primary key, name text not null, gender integer check(gender in(1, 2)), -- 1:male, 2:female age integer check(age >= 18), tel text not null, salary integer, constraint emp_salary check(salary between age*10000 and age*20000) );