topic About the data model in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/about-the-data-model/m-p/221565#M174695 <HTML><HEAD></HEAD><BODY><SPAN>Hi everybody,</SPAN><BR /><BR /><SPAN>I'm searching a way to notice the difference between the active content, the inactive content and the deleted content.</SPAN><BR /><BR /><SPAN>I know that the field node_deleted in the alf_node table is used for maintenance.&nbsp; It delete all the node properties with the same id.&nbsp; But I can't make the difference between the "active" and "inactive" content.&nbsp; By inactive content, I'm talking about the nodes that do not appears in the web interface but are still in the alf_node and alf_node_properties tables.</SPAN><BR /><BR /><SPAN>But I don't know where I can find the description of the tables and their relationships between them.</SPAN><BR /><BR /><SPAN>Maybe I should look at the source code of the application to know how they extract all the active content…</SPAN><BR /><BR /><SPAN>Where can I find those informations ?</SPAN><BR /><BR /><SPAN>Thank you !</SPAN></BODY></HTML> Wed, 15 Sep 2010 15:22:36 GMT dagagno1 2010-09-15T15:22:36Z About the data model https://connect.hyland.com/t5/alfresco-archive/about-the-data-model/m-p/221565#M174695 Hi everybody,I'm searching a way to notice the difference between the active content, the inactive content and the deleted content.I know that the field node_deleted in the alf_node table is used for maintenance.&nbsp; It delete all the node properties with the same id.&nbsp; But I can't make the difference b Wed, 15 Sep 2010 15:22:36 GMT https://connect.hyland.com/t5/alfresco-archive/about-the-data-model/m-p/221565#M174695 dagagno1 2010-09-15T15:22:36Z Re: About the data model https://connect.hyland.com/t5/alfresco-archive/about-the-data-model/m-p/221566#M174696 <HTML><HEAD></HEAD><BODY><SPAN>Hello,&nbsp; I finally found how to know if our content is active or not.&nbsp; It's the ALF_STORE table, with the fields protocol and identifier.</SPAN></BODY></HTML> Thu, 16 Sep 2010 18:26:16 GMT https://connect.hyland.com/t5/alfresco-archive/about-the-data-model/m-p/221566#M174696 dagagno1 2010-09-16T18:26:16Z