Replying to @asmah2107
This is a classic problem in production database migrations at scale.
When you run ALTER TABLE ADD COLUMN phone_number VARCHAR(20) NOT NULL, the DB engine typically rewrites the entire table to add that column (especially in MySQL, Postgres pre-11, etc.). That’s what locks it.
