How do you know if the user agrees or not?

Question

MySQL

We have 4 tables

deals (deals)
id, name

documents (documents in the deal)
id, name, deal_id

members (deal participants)
id, deal_id, user_id

document_user (who agreed with the document)
document_id user_id

All deal participants are automatically participants in any deal document .

We need to display a list of all participants in the transaction of the document, and also add an is_signed column to each, in which there will be 0 or 1, depending on whether the person agreed with the document or not. How to do it?

Answer 1

create a new table users_documents_confirm, where the id of the user and the document to which he agrees will be stored