Guest User

Untitled

a guest
Aug 20th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. Analytics Dashboard Strategy
  2. client: id, name, address, ...
  3. call: id, client_id, created_at, duration, ...
  4. calls_summary: id, client_id, date_start, date_end, nb_calls
  5.  
  6. SELECT * FROM client
  7. LEFT JOIN call ON call.client_id = client.id
  8. WHERE client.id = 42
  9.  
  10. SELECT * FROM call where client_id = 42
Add Comment
Please, Sign In to add comment