I'm building a municipal model with many pipes, manholes & other structures as vector layers - these are coming from several different sources of information and the field structure can be slightly different depending on the source. I then need to add many new fields to each table for field data capture. What I'm wondering, is if there's a way to build an empty table within a template, or a script that I can run (or something else) to automate this task? I'll have many tables that I need to add these same fields to in this project, and I've got another dozen similar projects after this one... I would really like to find a way to add these same fields automatically rather than manually.
I'm sure this can be done with a script as well. But the easiest way to do it would be using the Processing Modeler. From Processing> Graphical Modeler...
There is the "Add field to attributes table" function.
Simply create model that adds the fields that you need and run it for each table. You can even run it in batch mode for multiple layers at once.