db101

queries

• 2 joins
• aggregate
• group by
• order by
• group by with having
• nested

more

• 2 views
  • none yet
• 2 triggers
  • whenever a BigPharma is deleted all the Sells, Prescriptions, Contracts and Drugs that reference that BigPharma, directly or indirectly are also deleted.
  • one more to go

TODO

• don't bigpharma_id from drug_search
• prescription search
• drugs_for_patient