| View Name: | MARIPicturesVersions |
| Based on table: | MPBilderVersionen |
| Group: | |
| Description: | Revisions of the pirctures |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PictureID | BildID INT Primary |
MARIPictures.PictureID | |
| VersionId | VersionsID INT Primary |
||
| FileName | Datei NVARCHAR (255) |
||
| PathName | Pfad NVARCHAR (255) |
||
| Extension | Typ NVARCHAR (10) |
"GIF", "JPEG", "PNP".... | |
| Height | Hoehe INT |
pixel | |
| Width | Breite INT |
pixel | |
| ThumbHeight | ThumbHeight INT |
pixel | |
| ThumbWidth | ThumbWidth INT |
pixel | |
| Source | Quelle INT Index |
ClassID | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| ChangeText | AenderungsText NVARCHAR (255) |
||
| PictureHashCode | BildHash NVARCHAR (32) |
||
| Image | Bild Image |
||
| ThumbNail | ThumbNail Image |
||
| UpdateStamp | UpdateStamp INT |