Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
configid | int4 | 10 | √ | null |
|
|
Foreign key to warehouse.filemon_config.id |
|||
filename | text | 2147483647 | null |
|
|
The file name |
||||
filedate | timestamptz | 35,6 | null |
|
|
The last modification time of the file as it was most recently observed |
||||
lastseen | timestamptz | 35,6 | null |
|
|
The system time when this file was last seen |
||||
lastimportstatus | text | 2147483647 | null |
|
|
The status of the last import: SUCCESS or an error indication |
||||
lastimportdate | timestamptz | 35,6 | √ | null |
|
|
The date of the last successful import (not modified when lastimportstatus is not SUCCESS) |
|||
lastimportdurationmillis | int8 | 19 | √ | null |
|
|
The amount of time spent on the last successful import (not modified when lastimportstatus is not SUCCESS) |
|||
lastimportdatalength | int8 | 19 | √ | null |
|
|
The number of bytes imported during the most recent successful import (not modified when lastimportstatus is not SUCCESS) |
|||
lastoffsetbytes | int8 | 19 | √ | null |
|
|
The end position of the most recent successful import |
|||
lastfingerprint | text | 2147483647 | √ | null |
|
|
The fingerprint for this file as it was last observed |
|||
lastfingerprintlength | int4 | 10 | √ | null |
|
|
The number of bytes used to calculate lastfingerprint |
Table contained 3 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
uk_fm_fn | Must be unique | Asc/Asc | configid + filename |