Scribd
Upload
9 views3 pages

User Schema Overview

The document outlines a database schema for a user management system, detailing the attributes of the 'User' entity and its relationships with other entities such as 'Document', 'Notification', and 'FieldPlacement'. It includes various fields related to user information, notifications, attendance, evaluations, logbooks, and fieldwork progress. The schema is designed to manage student data and their associated activities effectively.

Uploaded by

lemapriase
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views3 pages

User Schema Overview

The document outlines a database schema for a user management system, detailing the attributes of the 'User' entity and its relationships with other entities such as 'Document', 'Notification', and 'FieldPlacement'. It includes various fields related to user information, notifications, attendance, evaluations, logbooks, and fieldwork progress. The schema is designed to manage student data and their associated activities effectively.

Uploaded by

lemapriase
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

+----------------------+

| User |

+----------------------+

| +user_id: int |

| +registration_number |

| +password_hash |

| +email |

| +first_name |

| +last_name |

| +role |

| +program |

| +intake |

| +year_of_study |

| +NTA_level |

| +phone_Number |

| +profile_picture |

| +status |

| +created_at |

| +updated_at |

+----------------------+

|1

|*

+------+------+-----------------------------+

| | | |

| | | |

V V V V

| +----------+ +-----------------+ +-------------------+

| | Document | | Notification | | FieldPlacement |


| +----------+ +-----------------+ +-------------------+

| | +doc_id | | +notification_id| | +placement_id |

| | +student | | +user_id | | +student_id |

| | +file_* | | +title, message | | +supervisor_id |

| +----------+ +-----------------+ | +organization_* |

| | +department |

| | +status |

| | +start_date |

| | +end_date |

| +---------+----------+

| |

| +------------------------+---------------------------+

| | | |

V V V V

+-------------+ +----------------+ +---------------+ +--------------------+

| Attendance | | Evaluation | | Logbook | | FieldWorkProgress |

+-------------+ +----------------+ +---------------+ +--------------------+

| +attendance | | +evaluation_id | | +logbook_id | | +progress_id |

| +check_in | | +student_id | | +placement_id | | +student_id |

| +check_out | | +supervisor_id | +---------------+ | +tasks, skills |

| +location | | +ratings, etc. | | +hours, date, etc. |

+-------------+ +----------------+ +--------------------+

+------------------------+

| LogbookProgress |

+------------------------+

| +lp_id |

| +logbook_id |
| +taskTitle |

| +taskDescription |

| +date, hours |

+------------------------+

You might also like