topic Re: why column name carries _ at the end in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/why-column-name-carries-at-the-end/m-p/241146#M194276 <HTML><HEAD></HEAD><BODY><SPAN>The reason is to avoid any conflict with any database and reserved keywords.</SPAN><BR /><BR /><SPAN>"And secondly, do I need to follow any particular naming convention while naming tables and columns for my customization?"</SPAN><BR /><BR /><SPAN>No, you don't. That's all up to you.</SPAN></BODY></HTML> Thu, 07 Apr 2016 10:31:28 GMT jbarrez 2016-04-07T10:31:28Z why column name carries _ at the end https://connect.hyland.com/t5/alfresco-archive/why-column-name-carries-at-the-end/m-p/241145#M194275 I am developing a custom application like explorer for a client. I need to create many new tables in the database to fulfill requirement. I was looking at the existing activiti tables and found that each column name ends with an underscore "_". Is there any particular reason this is done so. Is any Thu, 07 Apr 2016 06:35:55 GMT https://connect.hyland.com/t5/alfresco-archive/why-column-name-carries-at-the-end/m-p/241145#M194275 logicallimit 2016-04-07T06:35:55Z Re: why column name carries _ at the end https://connect.hyland.com/t5/alfresco-archive/why-column-name-carries-at-the-end/m-p/241146#M194276 <HTML><HEAD></HEAD><BODY><SPAN>The reason is to avoid any conflict with any database and reserved keywords.</SPAN><BR /><BR /><SPAN>"And secondly, do I need to follow any particular naming convention while naming tables and columns for my customization?"</SPAN><BR /><BR /><SPAN>No, you don't. That's all up to you.</SPAN></BODY></HTML> Thu, 07 Apr 2016 10:31:28 GMT https://connect.hyland.com/t5/alfresco-archive/why-column-name-carries-at-the-end/m-p/241146#M194276 jbarrez 2016-04-07T10:31:28Z Re: why column name carries _ at the end https://connect.hyland.com/t5/alfresco-archive/why-column-name-carries-at-the-end/m-p/241147#M194277 <HTML><HEAD></HEAD><BODY><SPAN>Ah Ok! Got it.</SPAN><BR /><BR /><SPAN>Thank you so much for this information. </SPAN></BODY></HTML> Thu, 07 Apr 2016 12:47:25 GMT https://connect.hyland.com/t5/alfresco-archive/why-column-name-carries-at-the-end/m-p/241147#M194277 logicallimit 2016-04-07T12:47:25Z