This repo contains a database file for your favorite database type if it's one of the following:
- MSSQL
- MySQL
- SQLite
- PostgreSQL
Contained within are all the known official and unofficial system views (except _MobileSubscription since it's effectively replaced my _SMSSubscriptionLog).
I built the schema using dbdesigner.net in a "generic" mode, meaning that I didn't have the ability to specific between a couple of different field types like nvarchar and varchar.
Foreign keys, primary keys, unique fields, etc have been identified to the best of my knowledge offhand. I haven't tested it completely yet. If anything is off, please submit a pull request or open an issue and I will make updates as soon as I can get to it.
If you found this, and you're good with Marketing Cloud and you want to join a great consulting team, hit me up.