涉及外键插入的操作在单元测试阶段导致问题

I have the following schema:

我有以下架构:

create table statuslookup
{
  statusid int primary key,
  statusname string unique,
  description string
}

create table job
{
  jobid int primary key,
  jobname string unique,
  status_id foreign key reference statuslookup(statusid)
}
create