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 |
Relationships
Close relationships within degrees of separation
