title: How to work around circular dependency in databases?
body: <p>Two tables (Post and Thread) in my database refer to one another which is suppose to be a solution for SQL server not supporting 1-to-1 relationships. See <a href="https://i.stack.imgur.com/iVdzL.png" rel="nofollow noreferrer">diagram </a>. I made key_post not accept null values in my first Database, but that meant that I couldn't insert into either tables so I had to make key_post nullable to at least be able to create the thread first before filing the key_post field and I can set key_post to null if I wanted to remove that post , but I wanted to find a solution that doesn't require special attention in code because it can get messy.</p>