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