| Table Name: | MPBuchSeitenFreigabe |
| View Name: | MARIBookPageApproval |
| Group: | Group: Book |
| Description: | Project Dokumentation: Book Page Approval Flow |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| SeitenID | PageID INT Primary |
MPBuchSeite.SeitenID | |
| ArchivSatzID | ArchiveSetID INT Primary |
||
| Schritt | ApprovalStep INT Primary |
||
| FreigabeTyp | ApprovalType INT Index |
||
| FreigabeTypSub | ApprovalSubType INT |
||
| FreigabeTypClearer | ApprovalSubTypeClearer INT |
||
| Freigebender | Approver NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| Freigabe | ApprovalMode SMALLINT (0=false,-1=true) Index |
||
| FreigegebenAm | ApprovedDate Datetime |
||
| FreigegebenID | ApprovedUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| FreigabeWartend | ApprovedPending SMALLINT (0=false,-1=true) |
||
| Freigabetext | ApprovalText NTEXT |
||
| AnzahlFreigebender | NumberOfApprovers INT |
||
| UpdateStamp | UpdateStamp INT |