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_field_check | ((field !~ similar_to_escape(' *'::text))) |
| upload_problems_value_check | ((value !~ similar_to_escape(' *'::text))) |
| upload_problems_message_check | ((message !~ similar_to_escape(' *'::text))) |