Database Model: Participates

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)