Change the default value in PowerDesigner or add a new one
At FastChangeCo, the data modelers within the Data Management Center of Excellence (DMCE) team are constantly designing new database objects to store data. One of the data modelers on the team is Xuefang Kaya. When she takes a new user story/task, she usually models multiple tables, their columns, and specifies a data type for each column.
For example, if a column needs to store the timestamp for an event, Xuefang sets the date/time data type for that column (in that case, it even depends on the database in each case). If additional columns have to store names and addresses, it sets the columns to the ‘text’ data type.