Generated using SQL Data Dictionary demo version.
| Column | Data Type | Identity | Nullable | Default | |
|---|---|---|---|---|---|
| PK | BannerId | int | X | ||
| FK | VendorId | int | |||
| ImageFile | nvarchar(100) | X | |||
| BannerName | nvarchar(100) | ||||
| Impressions | int | ||||
| CPM | float | ||||
| Views | int | 0 | |||
| ClickThroughs | int | 0 | |||
| StartDate | datetime | X | |||
| EndDate | datetime | X | |||
| CreatedByUser | nvarchar(100) | ||||
| CreatedDate | datetime | ||||
| BannerTypeId | int | X | |||
| Description | nvarchar(2000) | X | |||
| GroupName | nvarchar(100) | X | |||
| Criteria | bit | 1 | |||
| URL | nvarchar(255) | X | |||
| Width | int | 0 | |||
| Height | int | 0 |