aggregation_candidates

552 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_id1 BIGINT UNSIGNED 20 null
customers.id aggregation_candidates_customer_id1_foreignR

顧客ID
customer_id2 BIGINT UNSIGNED 20 null
customers.id aggregation_candidates_customer_id2_foreignR

顧客ID
denied_at TIMESTAMP 26 √ null

同一人物ではないとした日時

Indexes

Constraint Name Type Sort Column(s)
aggregation_candidates_customer_id1_customer_id2_unique Must be unique Asc/Asc customer_id1 + customer_id2
aggregation_candidates_customer_id2_foreign Performance Asc customer_id2

Relationships

Close relationships within degrees of separation