One option is to create SQL Server user defined data types. One trick with new databases is to create the objects in the model database, so as new databases are created the user defined data types will automatically be available. References: https://www.mssqltips.com/sqlservertip/1628/sql-server-user-defined-data-types-rules-and-defaults/