connex_request_log


Description

To troubleshoot the sending of connex requests to Irvin’s API

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idconnex_request_log bigserial 19 √ nextval('connex_request_log_idconnex_request_log_seq'::regclass)
iddevice int4 10 null
device.iddevice connex_request_log_iddevice_fkey R
idmayauser int4 10 √ null
mayauser.idmayauser connex_request_log_idmayauser_fkey R
request_date timestamptz 35,6 null
payload varchar 2147483647 null
response json 2147483647 √ null
response_code int4 10 √ null
request_status int4 10 null
status_date timestamptz 35,6 √ null
request_url varchar 200 √ null

Indexes

Constraint Name Type Sort Column(s)
connex_request_log_pkey Primary key Asc idconnex_request_log

Relationships

Close relationships within degrees of separation