fix: unique index name for bucket_id index

Summary

Unique index name for bucket_id index in format {table_name}_bucket_id

---

• Close #604 (closed)
• Changes should be cherry-picked to 24.2: no
• Docs follow-up: not necessary