AnsweredAssumed Answered

About the data model

Question asked by dagagno1 on Sep 15, 2010
Latest reply on Sep 16, 2010 by dagagno1
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.  It delete all the node properties with the same id.  But I can't make the difference between the "active" and "inactive" content.  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.

But I don't know where I can find the description of the tables and their relationships between them.

Maybe I should look at the source code of the application to know how they extract all the active content…

Where can I find those informations ?

Thank you !