Question defining a relationship in Doctrine
I am experimenting with designing a model for a project I am working on in Doctrine, and I wanted some advice on how I would define different relationships.

I've got 3 tables

Venue, Series and Event

* Venue has many events, and can host events that are sometimes but not necessarily part of a series.
* Series is a set of events, which can always occur at the same venue or different venues.
* Event always has to occur at a venue and can optionally be part of a series.

My understanding is that Venue and Series would be a many-to-many relationship as many venues can have many series of events and vice versa.  Does the fact that this relationship is "optional" change things?

I also understand that event would be a one to many relationship with both Venue and Series as one Venue can have many events and one Series can have many events, but an event can only have one of each.

Am I looking at this the correct way, and can anyone advise on the best way to define this within Doctrine?

Thanks in advance for helping me understand this!
Question defining a relationship in Doctrine
===

I am experimenting with designing a model for a project I am working on in Doctrine, and I wanted some advice on how I would define different relationships.

I've got 3 tables

Venue, Series and Event

* Venue has many events, and can host events that are sometimes but not necessarily part of a series.
* Series is a set of events, which can always occur at the same venue or different venues.
* Event always has to occur at a venue and can optionally be part of a series.

My understanding is that Venue and Series would be a many-to-many relationship as many venues can have many series of events and vice versa.  Does the fact that this relationship is "optional" change things?

I also understand that event would be a one to many relationship with both Venue and Series as one Venue can have many events and one Series can have many events, but an event can only have one of each.

Am I looking at this the correct way, and can anyone advise on the best way to define this within Doctrine?

Thanks in advance for helping me understand this!