Add a database object type column to the SchemaChange history table

[CalculusAce]

Is your feature request related to a problem? Please describe.
When viewing or leveraging the SchemaChange history table in a query or function, it is currently not possible to identify the database object type (table, function, procedure, task, etc) a particular change script corresponds to.

Describe the solution you'd like
Add a database object type (table, function, procedure, task, etc) column to the standard SchemaChange history table that is populated when SchemaChange runs.

Describe alternatives you've considered
N/A

Additional context
N/A