| View Name: | MARIBookArchive |
| Based on table: | MPBuchArchiv |
| Group: | Group: Book |
| Description: | Project Dokumentation: Archived Book Content |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ArchiveSetID | ArchivSatzID INT Primary |
||
| BookID | BuchID INT Index |
MARIBook.BookID | |
| BookDescription | BuchBezeichnung NVARCHAR (100) Index |
||
| BookType | BuchTyp INT Index |
||
| Icon | Ikone INT |
||
| Color | Farbe INT |
||
| MaxHierarchy | MaxHierarchie INT |
||
| Template | Template INT |
||
| Predesessor | Vorgaenger INT |
||
| Group1 | Gruppe1 INT |
MARIGroups.Group1 (WHERE GruppenArt=10681) | |
| Group2 | Gruppe2 INT |
MARIGroups.Group2 (WHERE GruppenArt=10682) | |
| Group3 | Gruppe3 INT |
MARIGroups.Group3 (WHERE GruppenArt=10683) | |
| Workflow | Workflow INT |
MARISysClassApprovalRule.Workflow (WHERE ClassID=698) | |
| RightsRead | Lesen BIGINT |
MARIUserGroups.RightsRead (WHERE BenutzerTyp=1) | |
| RightsChange | Aendern BIGINT |
MARIUserGroups.RightsChange (WHERE BenutzerTyp=1) | |
| RightsInsert | Einfuegen BIGINT |
MARIUserGroups.RightsInsert (WHERE BenutzerTyp=1) | |
| RightsDelete | Loeschen BIGINT |
MARIUserGroups.RightsDelete (WHERE BenutzerTyp=1) | |
| RightsAll | Alles BIGINT |
Rights for structure change | MARIUserGroups.RightsAll (WHERE BenutzerTyp=1) |
| CustomerPortalRightsRead | KundeLesen BIGINT |
MARIUserGroups.CustomerPortalRightsRead (WHERE BenutzerTyp=2) | |
| CustomerPortalRightsChange | KundeAendern BIGINT |
MARIUserGroups.CustomerPortalRightsChange (WHERE BenutzerTyp=2) | |
| CustomerPortalRightsCreate | KundeEinfuegen BIGINT |
MARIUserGroups.CustomerPortalRightsCreate (WHERE BenutzerTyp=2) | |
| CustomerPortalRightsDelete | KundeLoeschen BIGINT |
MARIUserGroups.CustomerPortalRightsDelete (WHERE BenutzerTyp=2) | |
| CustomerPortalRightsAll | KundeAlles BIGINT |
Rights for structure change | MARIUserGroups.CustomerPortalRightsAll (WHERE BenutzerTyp=2) |
| Approver | Freigebender NVARCHAR (20) Index |
MARIEmployeeMaster.Approver | |
| ApprovedDate | FreigegebenAm Datetime |
||
| ApprovedUser | FreigegebenID NVARCHAR (4) |
MARIUser.ApprovedUser (WHERE BenutzerTyp=1) | |
| ApprovalText | FreigabeText NTEXT |
||
| ReferencePageID | VerweisArchivSatzID INT Index |
MARIBookPage.ReferencePageID | |
| BasePageID | BasisSeitenID INT Index |
MARIBookPageArchive.BasePageID | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
||
| Memo | Memo NTEXT |
||
| MemoLevel | MemoLevel SMALLINT |
||
| 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 |
| Table | Description |
|---|---|
| MARIBookPropertiesArchive | Project Dokumentation: Book Archived Properties |
| MARIBookLinkArchive | Project Dokumentation: externale link archive |
| MARIBookPageArchive | Project Dokumentation: Book Page Archive (Left hierarchy) |
| MARIBookPageElementArchive | Project Dokumentation: Book Page Content Element Archive |
| MARIBookPageContentArchive | Project Dokumentation: Book Page Content Data Archive |