Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| upload_id | int8 | 19 | null |
|
|
||||||
| type_id | int4 | 10 | null |
|
|
||||||
| is_error | bool | 1 | null |
|
|
||||||
| position | int4 | 10 | √ | null |
|
|
Where in the uploaded file the problem appears, or null if it is a problem with the file as a whole. This may be a byte offset, a line number, or a record number depending on the type of file. |
||||
| field | text | 2147483647 | √ | null |
|
|
If the problem pertains to a specific field, its name. Null if the problem affects an entire record or the entire file. |
||||
| message | text | 2147483647 | √ | null |
|
|
|||||
| value | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| upload_problems_pkey | Primary key | Asc | id |
| upload_problems_upload_id_idx | Performance | Asc | upload_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| upload_problems_value_check | (value !~ similar_to_escape(' *'::text)) |
| upload_problems_message_check | (message !~ similar_to_escape(' *'::text)) |
| upload_problems_field_check | (field !~ similar_to_escape(' *'::text)) |