Composite key; one field is also foreign key

[Rich Shepard]

I understand that multiple fields in a declarative base class can be
specified as a composite primary key. In my application rather than using a
unique, serialized primary key for each table/field I use a foreign key
reference to a row in the locations table and a date. For example,

site_name = Column(Integer, ForeignKey('locations.site_name', \
onupdate='CASCADE', ondelete='RESTRICT'))
sampdate = Column(Date, nullable=False)

How do I specify both as a composite primary key?

TIA,

Rich

[Jonathan Vanasco]

adding `primary_key=True` to each of the `Column` constructors should do it.

[Rich Shepard]

On Tue, 18 Jun 2019, Jonathan Vanasco wrote:

> adding `primary_key=True` to each of the `Column` constructors should do it.

Thanks, Jonathan.

Rich