After new records are loaded into the table backpage, the process should follow the following steps for each records:
- For each phone number found in the ad...
- Check if the phone number is in the
phone table
- If the phone number is not found in the
phone, add it to the phone table
- Take the phond_id from the
phone table, and the ad_id from the ad table, and insert a new record into the ad_to_phone table