MARIProject Database Structure

View Name:MARIBookPage
Based on table:MPBuchSeite
Group:Group: Book
Description:Project Dokumentation: Book Page (Left hierarchy)
ClassID: 699. See Overview of ClassIDs by table.

Field Table(Germ.field)/Type Description Related
PageID SeitenID

INT Primary

BookID BuchID

INT Index

MARIBook.BookID
Indent Indent

INT

Parent Parent

INT

Position Position

INT Index

IndentType IndentType

SMALLINT

PageTitle SeitenTitel

NVARCHAR (100)

Icon Ikone

INT

Color Farbe

INT

PageVersion InhaltsVersion

INT Index

ReferencePageID VerweisArchivSatzID

INT

MARIBookPage.ReferencePageID
Intern Intern

SMALLINT (0=false,-1=true)

Workflow Workflow

INT

not used MARISysClassApprovalRule.Workflow (WHERE ClassID=699)
TOCMode KapitelNummernMode

INT

ChapterStart KapitelNummerStartWert

INT

ChapterNumber KapitelNummerText

NVARCHAR (50)

RightsMode RechteMode

INT

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

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

MARIUserGroups.CustomerPortalRightsAll (WHERE BenutzerTyp=2)
PageChangeText SeitenAenderungsText

NTEXT

Memo Memo

NTEXT

ExtraProperties Eigenschaften

NTEXT

ExtraPropertiesType EigenschaftenTyp

INT

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


Linked by

Table Description
MARIBook Project Dokumentation: Book Header
MARIBookArchive Project Dokumentation: Archived Book Content
MARIBookLink Project Dokumentation: externale links to pages
MARIBookPage Project Dokumentation: Book Page (Left hierarchy)
MARIBookPageArchive Project Dokumentation: Book Page Archive (Left hierarchy)
MARIBookPageElements Project Dokumentation: Book Page Content Element
MARIBookPageApproval Project Dokumentation: Book Page Approval Flow
MARIBookPageElementArchive Project Dokumentation: Book Page Content Element Archive
MARIBookPrintSequenceElements Project Dokumentation: Print Action PageElementPrintLines


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany