When you create database tables with Python objects, you use a class to declare the behavior of each field first, then its type. For instance, a mandatory, distinct name field would be name ...

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 ...