create table a(
id varchar(20) not null primary key,
name varchar(30)
);
create table b(
id varchar(20) not null primary key
);
create table c(
id varchar(20) not null primary key
);
alter table b add constraint a_id foreign key(id) references a(id);