create table outpost ( 
    id integer not null primary key 
)

insert into outpost values ( 1 )

insert into outpost values ( 2 )

create table jedi_unit ( 
    id integer not null primary key, 
    members integer default 10 not null 
)

insert into jedi_unit values ( 1, 10 )

insert into jedi_unit values ( 2, 10 )

insert into jedi_unit values ( 3, 10 )

create table jedi_guard_contingent ( 
    id integer not null primary key, 
    fk_jedi_unit integer not null, 
    fk_outpost integer, 
    used_members integer not null, 
    constraint jgc_fk_unit foreign key ( fk_jedi_unit ) references jedi_unit( id ), 
    constraint jgc_fk_outpost foreign key ( fk_outpost ) references outpost( id ) 
)

insert into jedi_guard_contingent values ( 1, 1, null, 5 )

insert into jedi_guard_contingent values ( 2, 1, 1, 5 )

insert into jedi_guard_contingent values ( 3, 2, 1, 5 )

insert into jedi_guard_contingent values ( 4, 2, 2, 5 )

insert into jedi_guard_contingent values ( 5, 3, null, 10 )

select id, fk_jedi_unit, fk_outpost, used_members, case when id in (1,2) then 'illegal' else 'ok' end status from jedi_guard_contingent;