| View Name: | MARIBookLink |
| Based on table: | MPBuchLink |
| Group: | Group: Book |
| Description: | Project Dokumentation: externale links to pages |
| ClassID: | 703. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| BookLinkID | BuchLinkID INT Primary |
||
| BookID | BuchID INT Index |
MARIBook.BookID | |
| PageID | SeitenID INT Index |
MARIBookPage.PageID | |
| LinkType | LinkTyp INT |
||
| ClassID | ClassID INT Index |
ClassID | |
| ClassKey | ClassKey NVARCHAR (50) Index |
||
| ParentClassKey | ParentClassKey NVARCHAR (50) Index |
||
| ParentClassKeyVisible | ParentClassKeyVisible NVARCHAR (255) |
||
| ClassKeyVisible | ClassKeyVisible NVARCHAR (255) |
||
| Company | Mandant SMALLINT Index |
||
| SortOrder | Reihenfolge INT |
||
| AuthType | RechteTyp INT |
||
| AuthRead | RechtLesen BIGINT |
MARIUserGroups.AuthRead (WHERE BenutzerTyp=1) | |
| AuthChange | RechtAendern BIGINT |
MARIUserGroups.AuthChange (WHERE BenutzerTyp=1) | |
| AuthCreate | RechtEinfuegen BIGINT |
MARIUserGroups.AuthCreate (WHERE BenutzerTyp=1) | |
| AuthDelete | RechtLoeschen BIGINT |
MARIUserGroups.AuthDelete (WHERE BenutzerTyp=1) | |
| AuthAll | RechtAlles BIGINT |
MARIUserGroups.AuthAll (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| 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 |