Roles and mission state tables.

Some foreign key dependencies