The 8 tables behind a real auth system (Postgres schema, explained column by column)

This is day 2 of the series. Yesterday I showed the architecture diagram. Today we are looking at the database that sits underneath it. Every table, every column, every index, and the reason each one exists. If you are following with kavachOS , pnpm kavachos migrate creates all of this for you, and you can skim the article to understand what is in your database. If you are building it yourself, this is your schema. The shape at a glance Eight tables. One user-centric join key. No fancy polymorph