| Table Name: JSON Tests - 15 Fields |
| PrimaryKey |
Normal, Text |
Auto-Enter:
Validation:
- Only during data entry
- Not empty
- Unique
- Strict validation
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: Unicode Raw
|
Unique identifier of each record in this table |
|
|
|
|
| CreationTimestamp |
Normal, Timestamp |
Auto-Enter:
Validation:
- Only during data entry
- Strict data type: 4 digit year
- Not empty
- Strict validation
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
Date and time each record was created |
|
|
|
|
| CreatedBy |
Normal, Text |
Auto-Enter:
Validation:
- Only during data entry
- Not empty
- Strict validation
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
Account name of the user who created each record |
|
|
|
|
| ModificationTimestamp |
Normal, Timestamp |
Auto-Enter:
Validation:
- Only during data entry
- Strict data type: 4 digit year
- Not empty
- Strict validation
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
Date and time each record was last modified |
|
|
|
|
| ModifiedBy |
Normal, Text |
Auto-Enter:- Modification account name
Validation:
- Only during data entry
- Not empty
- Strict validation
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
Account name of the user who last modified each record |
|
|
|
|
| Input |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Output |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Expression |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Expected Output |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Test Result |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Last Success Date |
Normal, Timestamp |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Last Failed Date |
Normal, Timestamp |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: German
|
|
|
|
|
|
| Success MBS Version |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Failed MBS Version |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Title |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|