Like it's done in QGEP: https://github.com/QGEP/datamodel/blob/master/09_qgep_dictionaries.sql It would be very helpful for newcomers.