I’m ready to start implementing the ETL from EHR to CDM.But one last little question before I start:How to generate unique id in every table.
There are the following technologies of database：
I prefer the first two methods.But I don’t know which is the best choice.So I want to see your best practice.
Hi @kevin.wu ,
auto_increment is okay.