I want to create a domain and use it in the Logical Model, e.g. GENERIC_PATIENT_ID.
Not all attributes will need this obviously but I do have some attributes that need to be auto-incremented when "fwd engineered".
That will mean a DDL that defines the attributes as:
idImagen bigint not null identity(1,1) primary key
or something equivalent.
I know I can change the column definition in the relational model but I would like to automate this process as part of the Fwd Engineering without touching the RelationalModel for this.
How would I setup a domain, attach it to a datatype and achieve this?
Please advise.
I am using SQL Server Data Modeler Standalone 18.1
DB Target is SQL Server 2012