Skip to content

Database Model: Participates

Jump to bottom
Kev edited this page Apr 27, 2020 · 1 revision

Participates Model

Defines relationship between Transactions and non-Owner Users

Properties

  • transactionID: ID of Transaction (PK)
  • participantID: ID of user who is listed on a participant (PK)
  • participantTotal: how much does the user owe in this particular transaction
  • isPaid: boolean saying if participant has paid the owner

Associations/References

Both transactionID and participantID are foreign keys referring to Users and Transaction models
Primary key of this model is (transactionID, participantID)

Clone this wiki locally