| View Name: | MARIBookPageElementArchive |
| Based on table: | MPBuchSeitenElementArchiv |
| Group: | Group: Book |
| Description: | Project Dokumentation: Book Page Content Element Archive |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ArchiveElementID | ArchivElementID INT Primary |
||
| ArchiveSetID | ArchivSatzID INT Index |
MARIBookArchive.ArchiveSetID | |
| ElementVersionID | ElementVersionsID INT Index |
||
| ContentID | InhaltID INT Index |
MARIBookPageContent.ContentID | |
| Version | Version INT Index |
||
| PageID | SeitenID INT Index |
MARIBookPage.PageID | |
| ElementTitle | ElementTitel NVARCHAR (255) |
||
| SortOrder | Reihenfolge INT Index |
||
| ContentType | InhaltsTyp INT |
||
| LayoutID | LayoutID INT |
||
| ClassID | ClassID INT |
ClassID | |
| ClassKey | ClassKey NVARCHAR (50) |
||
| ParentClassKey | ParentClassKey NVARCHAR (50) Index |
||
| Company | Mandant SMALLINT |
||
| Priority | Prioritaet INT |
||
| Status | Status INT |
||
| Intern | Intern SMALLINT (0=false,-1=true) |
||
| FolderGroupID | SammelmappenGruppenID INT |
MARIFolderDocumentsGroups.FolderGroupID | |
| Height | Hoehe INT |
||
| DocumentID | DokumentID INT |
MARIDocuments.DocumentID | |
| PictureID | BildID INT |
MARIPictures.PictureID | |
| DocumentVersionsID | DokumentVersionsID INT |
MARIDocumentsVersions.DocumentVersionsID | |
| TemplateID | TemplateID INT Index |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |