Datenbankstruktur


Gesamtübersicht


{{:de:webedition:developer-information:internal-basics:database-strukture:datenbank-uebersicht.png?830|}}

Details


^ tblFile (Tree) ^ tblLink ^ tblContent ^
| ID \\ ParentID \\ Text \\ IsFolder \\ Path \\ TemplateID | DID \\ CID \\ Name | Dat |
|{{:de:webedition:developer-information:internal-basics:database-strukture:datenbank-tblfile.png?830}}|||
<box 100% round blue|Ausgabe der Felder des Dokuments mit der ID 70>
<code sql>
SELECT tblContent.Dat AS Inhalt, tblLink.Name AS Name FROM tblFile, tblLink,
tblContent WHERE tblFile.ID=tblLink.DID AND tblLink.CID=tblContent.ID AND
tblLink.DocumentTable='tblFile' AND tblFile.ID=70
</code>
</box>
^ tblObject = Klassen (Tree) ^ tblObjectFile = Objekte (Tree) ^ tblObject_x = Daten^
| | ID, ParentID, ... \\ TableID = ID der Klasse | OF_Feldname = Felder aus tblObjectFile \\ Typ_Name (input_Name) |
|{{:de:webedition:developer-information:internal-basics:database-strukture:datenbank-tblobjekt.png?830|}} |||
powered by webEdition CMS