I have more than 20 tables in my database. There are some columns which occur in almost all of the tables. In that case what should I do? Do I put all those columns in every table or is there a better way to solve this problem?
Country Table Example
CountryID, CountryName, AddedBy, AddedTime, LastUpdatedBy, LastUpdateDTime, DeletedBy, DeletedTime, DeleteFlag
As we can see in the table structure above there are 9 columns. Except for
CountrynName all occur in most tables. I don't want to keep above repeating columns in all tables. So if there is any solution then please let me know.