Setting up the database at Checkdomain

[denmarx]

Users (probably taken care of by Google Firebase):

• id (primary key): Unique identifier for each user.
• username: The user name of the user.
• email: The user's email address.
• password_hash: A hashed password of the user.
• optional: name, surname, profile pic, ...

Documents:

• id (primary key): Unique identifier for each document.
• title: The title of the document.
• description: A description of the document.
• author_id: The ID of the user who created the document (foreign key to user table).
• file_path: The file path to the saved PDF document.
• optional: date of creation, date of edit, tags, ...

Document Access Control:

• id (primary key): Unique identifier for each access control entry.
• user_id: The ID of the user to whom access is granted or denied (foreign key to user table).
• document_id: The ID of the document to which access is granted or denied (foreign key to document table).
• access_granted: A boolean value that specifies whether access is granted or denied.
• optional: access period, access rights (read/write), ...

Transactions:

• id (primary key): Unique identifier for each transaction.
• user_id: The ID of the user carrying out the transaction (foreign key to user table).
• document_id: The ID of the document for which the transaction takes place (foreign key to document table).
• amount: The amount of the transaction (e.g. payment amount for accessing a document).
• timestamp: Timestamp of the transaction.
• optional: transaction type (purchase, refund), status of the transaction (completed, pending), ...