| Field Name | Data Type/ Range | Size | Description | Reference |
| user_id | Int | 4 | Primary Key for user table | user table |
| Uname | Varchar | 32 | User name of the system administrator or students | user table |
| Password | Varchar | 32 | Password of the system administrator or students | user table |
| user_type | Int | 1 | Type of users in the system, it can be the OJT coordinator or OJT students | user table |
| ui_id | Int | 4 | Primary Key for user information table | user_info table |
| Fname | Varchar | 50 | First name of the system end-user | user_info table |
| Mname | Varchar | 50 | Middle name of the system end-user | user_info table |
| Lname | Varchar | 50 | Last name of the system end-user | user_info table |
| Bday | Date | -- | Birthday of the system end-user | user_info table |
| Gender | Char | 1 | Gender of the system end-user, either male or female | user_info table |
| Address | Varchar | 255 | Address of the system end-user | user_info table |
| contact number | Varchar | 11 | Contact number of the system end-user | user_info table |
| Specialization | char | 3 | Specialization of the system end-user, it can be Web Applications Programming, Database Applications Programming, Network Analysis and Design | user_info table |
| Section | char | 1 | Section of the system end-user | user_info table |
| | varchar | 100 | Email of the system end-user | user_info table |
| announce_id | int | 5 | Primary Key for Announcement table | announce table |
| announce_date | datetime | -- | Date and time when the announcement was posted | announce table |
| announce_subject | varchar | 100 | Subject or title of the announcement | announce table |
| announce_content | text | -- | Content of the announcement | announce table |
| ar_id | int | 5 | Primary Key for announcement reply table | announce_reply table |
| reply_date | Datetime | -- | Date and time when the reply for the announcement was posted | announce_reply table |
| reply_content | text | -- | Content of the reply for the announcement | announce_reply table |
| inquiry_id | int | 5 | Primary Key for inquiry table | inquiry table |
| inquiry_date | datetime | -- | Date and time when the inquiry of the student was posted | inquiry table |
| inquiry_content | Text | -- | Content of the student’s inquiry | inquiry table |
| ir_id | Int | 8 | Primary Key for inquiry reply table | inquiry_reply table |
| reply_date | Datetime | -- | Date and time when the reply for the inquiry was posted | inquiry_reply table |
| reply_content | Varchar | -- | Content of the reply for the inquiry | inquiry_reply table |
| report_id | Int | 8 | Primary Key for report table | report table |
| report_date | Datetime | -- | Date and time when the report was uploaded | report table |
| report_filename | Varchar | 255 | File name of the student’s report | report table |
| report_status | Int | 1 | Status of student’s report, either checked or pending | report table |
| company_id | Int | 5 | Primary Key for company table | company table |
| company_name | Varchar | 255 | Name of the company | company table |
| company_address | Varchar | 255 | Address of the company | company table |