Structuring SQLite database with 2 relationships?
If I get you right then one post is linked to one user but one user can have many posts.
I think this is a one to many relationship. So, put a field user_id in your table post then you know which post is linked to which user.

It's a german page but the first image would help you.