ImageAlbum
Primary Key
| Primary Key |
Field Type |
| ID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| DisplayName |
nvarchar(50) |
|
|
|
| Location |
nvarchar(50) |
|
|
|
| Description |
nvarchar(255) |
|
|
|
| AlbumType |
int |
yes |
|
|
| AlbumArtImageID |
int |
yes |
|
|
| OwnerUserID |
int |
yes |
|
|
| CreateDate |
datetime |
|
Default = getutcdate() |
|
| UpdateDate |
datetime |
|
Default = getutcdate() |
|
| Deleted |
bit |
yes |
|
|
| DeletedDate |
datetime |
yes |
|
|
| DeletedUserID |
int |
yes |
|
|
| IsDefault |
bit |
yes |
|
|
| Security |
int |
|
Default = 0 |
|
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| PK_ImageAlbum |
ID |
yes |
yes |
|
Referenced by