title: ERD 3 tables in 1 relationship
body: <p>i am having a hard time creating an ERD for my table relationship. I have 4 tables: film, ticket_type, studio, and schedule. The schedule table is a relationship table that contain the primary key from the other three tables as foreign key. The question is how can i picture it in ERD? Something like many-to-many relationship but with 3 table, is it possible to do it like this? The database works fine when i try to create it so i think there's​ no problem in my concept. Thanks in advance.</p>
  
  <p>Edit: forgot to add the ticket_type table is for pricing and type like: 2d,3d,or 4d, i create it like this to avoid redundancy.
  One more question, can i add another field to a relationship table? If I remember correctly it should be fine, but just to make sure.</p>