| View Name: | MARIBookPropertiesUser |
| Based on table: | MPBuchEigenschaftenUser |
| Group: | Group: Book |
| Description: | Project Dokumentation: Book User Properties |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| BookID | BuchID INT Primary |
MARIBook.BookID | |
| Property | Eigenschaft INT Primary |
||
| PropertyIndex | EigenschaftIndex INT Primary |
||
| UserCode | Benutzer NVARCHAR (4) Primary |
MARIUser.UserCode (WHERE BenutzerTyp=1) | |
| ValueNumber | WertZahl INT |
||
| ValueText | WertText NVARCHAR (255) |
||
| ValueDate | WertDatum Datetime |
||
| ValueMemo | WertMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |