Please note that types of tables are obsolete.
TIS is often used to manipulate data, in particular time records, that adhere to a certain format. Some operators are defined for tables that contain columns in such formats.
The following types of tables are relevant to some operators.
Durations (Zeitdauer) table
A table that contains two columns indicating the duration of events. These two columns must be in the Date format, are typically named "From" and "To" (German "Von" and "Bis") and contain a date and a time indicating any interval between the two. The date and time in the "From" column must be later than the date and time in the "To" column.
Example:
... | Von | Bis | ... |
---|---|---|---|
... | 01/01/2016 06:00 | 01/01/2016 14:30 | ... |
... | 02/01/2016 22:00 | 03/01/2016 6:15 | ... |
TimeRaster (Zeitraster) table
A table that contains two columns indicating the duration of events. These two columns must be in the Date format, are typically named "From" and "To" (German "Von" and "Bis") and contain a date and a time indicating an intervall between the two.
The date and time in the "From" column must be later than the date and time in the "To" column.
The interval between the two columns must be of the same length in all rows of the table.
The value in the "To" ("Bis") column of each row must be the same as the value in the "From" ("Von") row of its successor row.
... | Von | Bis | ... |
---|---|---|---|
... | 01/01/2016 06:00 | 01/01/2016 07:00 | ... |
... | 01/01/2016 07:00 | 01/01/2016 08:00 | ... |
... | 01/01/2016 08:00 | 01/01/2016 09:00 | ... |
Events (Ereignis/Zeitpunkt) table
A table that contains a column of the Date format with each row indicating a date and a time in this column.
... | Event | ... |
---|---|---|
... | 01/01/2016 06:00 | ... |
... | 01/01/2016 07:00 | ... |
... | 01/01/2016 08:00 | ... |
IDurations (Zeitdauer) table
Like the durations table, this table also contains columns indicating time durations.
Other then the durations table, the IDurations table contains three columns, one Date column and two Time columns. The two Time columns indicate the start time "From" ("Von") and the end time "To" ("Bis"). Hence, the time intervall always takes place at the same day. The time in the "From" column must be earlier than the time in the "To" column.
Tables in this format often have to be converted to a durations table by applying the Convert "From-Date/From-Time/To-Time" operator.
... | Datum | Von | Bis | ... |
---|---|---|---|---|
... | 01/01/2016 | 06:00 | 14:30 | ... |
... | 02/01/2016 | 22:00 | 6:15 | ... |
ITimePattern (Zeitraster) table
This table contains three columns, one Date column and two Time columns "From" ("Von") and "To" ("Bis"), and the intervals between the two Time columns are the same in all rows. The time in the "From" column must be earlier than the time in the "To" column.
Tables in this format often have to be converted to a durations table by applying the Convert "From-Date/From-Time/To-Time" operator.
... | Datum | Von | Bis | ... |
---|---|---|---|---|
... | 01/01/2016 | 06:00 | 07:00 | ... |
... | 01/01/2016 | 07:00 | 08:00 | ... |
IEvents (Ereignis/Zeitpunkt) table
This table contains two columns, one Date and one Time column, indicating the date and the time of an event.
... | Datum | Uhrzeit | ... |
---|---|---|---|
... | 01/01/2016 | 06:00 | ... |
... | 01/01/2016 | 07:00 | ... |
Undefined table
A table that does not fulfill any of the above tables' criteria.