Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| error_code | varchar | 50 | √ | null |
|
|
|||||
| error_message | text | 2147483647 | √ | null |
|
|
|||||
| stack_trace | text | 2147483647 | √ | null |
|
|
|||||
| exception_type | varchar | 100 | √ | null |
|
|
|||||
| url | varchar | 500 | √ | null |
|
|
|||||
| method | varchar | 10 | √ | null |
|
|
|||||
| status_code | int4 | 10 | √ | null |
|
|
|||||
| user_agent | text | 2147483647 | √ | null |
|
|
|||||
| ip_address | inet | 2147483647 | √ | null |
|
|
|||||
| country_code | varchar | 10 | √ | null |
|
|
|||||
| session_id | varchar | 100 | √ | null |
|
|
|||||
| book_id | varchar | 20 | √ | null |
|
|
|||||
| proxy_used | bool | 1 | √ | null |
|
|
|||||
| proxy_address | varchar | 200 | √ | null |
|
|
|||||
| captcha_detected | bool | 1 | √ | null |
|
|
|||||
| blocked_by_amazon | bool | 1 | √ | null |
|
|
|||||
| block_reason | varchar | 200 | √ | null |
|
|
|||||
| selector_used | varchar | 200 | √ | null |
|
|
|||||
| selector_file | varchar | 100 | √ | null |
|
|
|||||
| selector_success | bool | 1 | √ | null |
|
|
|||||
| log_id | int8 | 19 | null |
|
|
||||||
| check_by_validation | bool | 1 | null |
|
|
||||||
| in_data_validation | bool | 1 | null |
|
|
||||||
| status_data_validation | jsonb | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| amz_log_details_pkey | Primary key | Asc | id |
| amz_log_details_log_id_5aee24a0 | Performance | Asc | log_id |
