id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
title = Column(String)
# How do I make this a list of foreign keys???
list_of_actors = Column(UUID(as_uuid=True), ForeignKey('actors.id'))

I understand that this can be done with a many-to-many relationship, but is there a more simple solution? Note that I don't need to look up which

Movie

's an

Actor

is in - I just want to create a new

Movie

model and access the list of my

Actor

's. And ideally, I would prefer not to add any new fields to my

Actor

model.

I've gone through the tutorials using the relationships API, which outlines the various one-to-many/many-to-many combinations using

Also, if it matters, I am using Postgres 9.5. I see from this post there might be support for arrays in Postgres, so any thoughts on that could be helpful.

Update

It looks like the only reasonable approach here is to create an association table, as shown in the selected answer below. I tried using ARRAY from SQLAlchemy's Postgres Dialect but it doesn't seem to support Foreign Keys. In my example above, I used the following column:

If you want many actors to be associated to a movie, and many movies be associated to an actor, you want a many-to-many. This means you need an association table. Otherwise, you could chuck away normalisation and use a NoSQL database.