| View Name: | MARIBookLinkArchive |
| Based on table: | MPBuchLinkArchiv |
| Group: | Group: Book |
| Description: | Project Dokumentation: externale link archive |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ArchiveLinkID | ArchivLinkID INT Primary |
||
| BookLinkID | BuchLinkID INT Index |
||
| ArchiveSetID | ArchivSatzID INT Index |
MARIBookArchive.ArchiveSetID | |
| BookID | BuchID INT Index |
MARIBook.BookID | |
| PageID | SeitenID INT Index |
MARIBookPageArchive.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 |