Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Seq | int identity | 4 | √ | null |
|
|
||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedBy | varchar | 50 | ('') |
|
|
|||
| ReportCode | varchar | 40 | ('') |
|
|
|||
| ReportSource | char | 1 | ('') |
|
|
|||
| ReportSeq | smallint | 2 | ((0)) |
|
|
|||
| ControlType | varchar | 30 | ('') |
|
|
|||
| ControlLevel | tinyint | 1 | ((0)) |
|
|
|||
| PrpTopRel | smallint | 2 | ((0)) |
|
|
|||
| PrpLeftRelRight | smallint | 2 | ((0)) |
|
|
|||
| PrpAdditional | varchar | 2000 | ('') |
|
|
|||
| LabelCaption | varchar | 50 | ('') |
|
|
|||
| FieldName | varchar | 2000 | ('') |
|
|
|||
| FieldType | varchar | 15 | ('') |
|
|
|||
| FieldDefaultValue | varchar | 30 | ('') |
|
|
|||
| FieldSelectJoin | varchar | 15 | √ | ('') |
|
|
||
| FieldSelectOperator | varchar | 10 | ('') |
|
|
|||
| FieldSortOrder | varchar | 4 | ('') |
|
|
|||
| LookupTable | varchar | 50 | ('') |
|
|
|||
| LookupSQL | varchar | 2000 | ('') |
|
|
|||
| ClearAllAbleFlag | bit | 1 | ((0)) |
|
|
|||
| MandatoryFlag | bit | 1 | ((0)) |
|
|
|||
| FieldSelectType | varchar | 5 | ('') |
|
|
|||
| FieldReference | varchar | 10 | ('') |
|
|
|||
| Comment | varchar | 50 | ('') |
|
|
|||
| Workstation | varchar | 50 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ConfigReportFormsArchive_Seq | Primary key | Asc | Seq |