| View Name: | MARIBook |
| Based on table: | MPBuch |
| Group: | Group: Book |
| Description: | Project Dokumentation: Book Header |
| ClassID: | 698. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| BookID | BuchID INT Primary |
||
| BookDescription | BuchBezeichnung NVARCHAR (100) Index |
||
| BookType | BuchTyp INT Index |
1=Standard Book and more | |
| Icon | Ikone INT |
||
| Color | Farbe INT |
||
| MaxHierarchy | MaxHierarchie INT |
0=no max | |
| Template | Template INT |
MARIBook.Template | |
| 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 |
Approval Process for publishing | 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) |
| ReferencePageID | VerweisArchivSatzID INT Index |
MARIBookPage.ReferencePageID | |
| 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 |
|---|---|
| MARIBook | Project Dokumentation: Book Header |
| MARIBookArchive | Project Dokumentation: Archived Book Content |
| MARIBookProperties | Project Dokumentation: Book Properties |
| MARIBookPropertiesUser | Project Dokumentation: Book User Properties |
| MARIBookLink | Project Dokumentation: externale links to pages |
| MARIBookLinkArchive | Project Dokumentation: externale link archive |
| MARIBookPage | Project Dokumentation: Book Page (Left hierarchy) |
| MARIBookPageArchive | Project Dokumentation: Book Page Archive (Left hierarchy) |