cancel
Showing results for 
Search instead for 
Did you mean: 

About the data model

dagagno1
Champ in-the-making
Champ in-the-making
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 !
1 REPLY 1

dagagno1
Champ in-the-making
Champ in-the-making
Hello,  I finally found how to know if our content is active or not.  It's the ALF_STORE table, with the fields protocol and identifier.