PostgreSQL is powerful and widely compatible, supporting the complete SQL standard, including transactions, foreign keys, ...

Creating a database as you've described is a lot of work, and as others have mentioned their might be better alternatives than a relational database. (or at least the typical structure for a ...