create table t_post (
  post_cd char(2) not null,
  post_name varchar2(20) not null
);
alter table t_post add constraint PK_POST primary key (post_cd);

create table t_emp (
  emp_cd char(5) not null,
  post_cd char(2) not null,
  f_enable char(1) not null default '1',
  name varchar2(50) not null,
  address varchar2(200)
);
alter table t_emp add constraint PK_EMP primary key (emp_cd);
alter table t_emp add constraint FK_EMP_POST foreign key (post_cd) references (t_post.post_cd);
alter table t_emp add constraint CK_EMP_ENABLE check f_enable in ('0', '1');