Doors open to the matching color character. Marine opens green doors, Scientist Opens White doors and engineer opens the yellow doors. The "red key card" is a fuel tank that you need for the shuttle...if you get all 3 items you can leave in the shuttle :) It's in the How To Play menu.
Thank you for the feedback!