I have studied about ArcSDE schema and SDE tables in Oracle, MSSQL and also PostgreSQL. But after my research I still have many questions that I haven't been able to find out.
Initially I want you to take a look at this image. http://help.arcgis.com/en/arcgisdesktop/10.0/help/002n/pdf/sdesystables_diagram.pdf
In this diagram you can see SDE tables, but the thing is we don't know when to reconcile/post/edit also move -whatever I want- how does this mechanism work?
As you can see on the diagram, there is no relationships in these tables. In fact they are, but we don't know what kind of relationship.