Jen jmosky

## sql.md

      
        
          
            
              
              1 file
            
          
          
            
              
              3 forks
            
          
          
            
              
              1 comment
            
          
          
            
              
              4 stars
            
          
        
        
          
              
          
          
            
                jmosky
                / sql.md
            
            
              Last active
              January 14, 2021 20:29
            
          
        
      
        
  
      
    Imagine we're rolling out a live chat tool to existing customers who have expressed interest trying it.
Customers could have expressed interest in two ways: either by filling out an interest form or mentioning to our support team that they want to try it.
For the interest form, there is one table, form.contact, with two relevant fields:

email - The user's email address
property_chat_interest - A Unix timestamp in milliseconds representing when they filled out the form or null if they have not expressed interest