clearinghouse_submissions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
clearinghouse_submission_claims.submission_id fk_ch_sub_claim_submission C
location_business_line_id VARCHAR 36 null
billing_batch_id VARCHAR 36 null
billing_batches.id fk_ch_sub_batch R
provider VARCHAR 50 null
filename VARCHAR 255 null
content_type VARCHAR 100 √ null
fileid VARCHAR 100 √ null
status VARCHAR 30 null
submitted_at DATETIME 19 √ null
acknowledged_at DATETIME 19 √ null
last_error TEXT 65535 √ null
raw_response LONGTEXT 2147483647 √ null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 √ null
created_by VARCHAR 36 √ null
updated_by VARCHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_ch_sub_batch Performance Asc billing_batch_id
idx_ch_sub_location Performance Asc location_business_line_id
idx_ch_sub_provider_status Performance Asc/Asc provider + status

Relationships

Close relationships within degrees of separation