Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReportID | int | 4 | null |
|
|
Report identifier - Unique identifier for each report |
||
| ReportCatName | int | 4 | √ | null |
|
|
Report category - Category classification for the report |
|
| ReportName | varchar | 50 | null |
|
|
Report name - Descriptive name of the report |
||
| ReportDesc | varchar | 500 | null |
|
|
Report description - Detailed description of report purpose |
||
| BillingTypeID | int | 4 | √ | null |
|
|
Billing type - Associated billing type if applicable |
|
| Temp_ID | int | 4 | √ | null |
|
|
Template ID - Report template identifier |
|
| Type | int | 4 | √ | null |
|
|
Report type - Type or format of the report |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by - User who created the report |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when report was created |
|
| criteriaStr | varchar | 5000 | √ | null |
|
|
Criteria string - Report filter criteria |
|
| int | 4 | √ | null |
|
|
Share flag - Indicates if report is shared |
||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update date - Date of last modification |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by - User who last modified the report |
Relationships
Close relationships within degrees of separation
