Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ConfigReportScheduleSeq | int identity | 4 | √ | null |
|
|
||
| ScheduleSeq | smallint | 2 | √ | null |
|
|
||
| DeliveryMode | varchar | 1 | ('') |
|
|
|||
| StartDateTime | datetime | 16,3 | √ | null |
|
|
||
| RepeatFrequency | varchar | 5 | √ | ('') |
|
|
||
| RepeatInterval | smallint | 2 | √ | null |
|
|
||
| RepeatIntraDayMinutes | smallint | 2 | √ | null |
|
|
||
| RepeatIntraDayCount | smallint | 2 | √ | null |
|
|
||
| EndDateTime | datetime | 16,3 | √ | null |
|
|
||
| NextDateTime | datetime | 16,3 | √ | null |
|
|
||
| LastDateTime | datetime | 16,3 | √ | null |
|
|
||
| EmailFromID | int | 4 | √ | null |
|
|
||
| EmailToID | int | 4 | √ | null |
|
|
||
| EmailSubject | varchar | 1000 | ('') |
|
|
|||
| ScheduleType | varchar | 1 | ('') |
|
|
|||
| EnabledFlag | bit | 1 | ((1)) |
|
|
|||
| OneTimeOccurence | datetime | 16,3 | √ | null |
|
|
||
| DWFlagMonday | bit | 1 | ((0)) |
|
|
|||
| DWFlagTuesday | bit | 1 | ((0)) |
|
|
|||
| DWFlagWednesday | bit | 1 | ((0)) |
|
|
|||
| DWFlagThursday | bit | 1 | ((0)) |
|
|
|||
| DWFlagFriday | bit | 1 | ((0)) |
|
|
|||
| DWFlagSaturday | bit | 1 | ((0)) |
|
|
|||
| DWFlagSunday | bit | 1 | ((0)) |
|
|
|||
| MonthlyFrequencyDay | tinyint | 1 | √ | null |
|
|
||
| MonthlyNthWeek | tinyint | 1 | √ | null |
|
|
||
| DailyOccurOnceAt | datetime | 16,3 | √ | null |
|
|
||
| DailyStartAt | datetime | 16,3 | √ | null |
|
|
||
| DailyEndAt | datetime | 16,3 | √ | null |
|
|
||
| EmailToAddresses | varchar | 1000 | ('') |
|
|
|||
| ResourceType | varchar | 5 | ('') |
|
|
|||
| Module | varchar | 30 | ('') |
|
|
|||
| Resource1 | varchar | 50 | ('') |
|
|
|||
| Resource2 | varchar | 50 | ('') |
|
|
|||
| Resource3 | varchar | 50 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ConfigReportSchedule | Primary key | Asc | ConfigReportScheduleSeq |
| AK_ConfigReportSchedule_ResourceType_Module_Resource1_Resource2_Resource3_ScheduleSeq | Performance | Asc/Asc/Asc/Asc/Asc/Asc | ScheduleSeq + ResourceType + Module + Resource1 + Resource2 + Resource3 |