new_reports

0 rows


Description

new reports consumed from Kafka topic and stored to database in shrunk format

Columns

Column Type Size Nulls Auto Default Children Parents Comments
org_id int4 10 null
read_errors.org_id read_errors_org_id_cluster_updated_at_fkeyC
account_number int4 10 null
cluster bpchar 36 null
read_errors.cluster read_errors_org_id_cluster_updated_at_fkeyC
report varchar 2147483647 null
updated_at timestamp 29,6 null
read_errors.updated_at read_errors_org_id_cluster_updated_at_fkeyC
kafka_offset int8 19 0

Indexes

Constraint Name Type Sort Column(s)
new_reports_pkey Primary key Asc/Asc/Asc org_id + cluster + updated_at
new_reports_cluster_idx Performance Asc cluster
new_reports_org_id_idx Performance Asc org_id
new_reports_updated_at_asc_idx Performance Asc updated_at
new_reports_updated_at_desc_idx Performance Desc updated_at
report_kafka_offset_btree_idx Performance Asc kafka_offset

Relationships

Close relationships within degrees of separation