Here are the views I created just in case anyone else wants to see their character info.
CREATE VIEW "CharcterView" AS Select accounts.account ,characters.character , personas.class, personas.level ,characters.id
from accounts
inner join characters on characters.account_id = accounts.id...