What columns would you include in a CRM customer table? Can you list some example columns?

A CRM customer table typically contains a primary key (customer_id), personal identifiers (first_name, last_name, email, phone), demographic details (address, city, state, zip, country), account status (active, inactive), and timestamps (created_at, updated_at). Additional columns might include preferred_contact_method, loyalty_status, and notes. If the CRM tracks interactions, foreign keys to interaction or activity tables are also common.