DB Schema Documentation

ABM Database Schema

"user" table is modified to add more fields, the “name” field is made the PRIMARY key to uniquely identify every user by username.

a. For the > User Profile> , to edit the data. The following fields are saved in the database:

• affiliation
• email
• firstname
• lastname
• password

b. To lock and unlock the user account, the following field is added:

• locked

c. To approve a user, the following fields are updated:

• approved
• approval_token

---

“reset_token” table is newly added for the “Reset password API” which will allow the user to reset the password if forgotten.

The following fields are included

• username – the user requesting the password reset, also the foreign key referencing the "name" column of "user" table.
• expired_period- the time limit for the user to reset the password.
• token- the reset password token

---

"collection" table is modified to 1 field:

• isActive - the status whether this collection is activated(1) / deactivated(0)

Whereas the other fields in the "collection" table are as follows:

• id
• description
• name
• user
• privateStatus
• creation_date

---

All the fields in the "role" table are as follows:

• role_name - username of user/name of user group
• role_type - 1: for all users, 2: user groups like UserAdmin,RegisteredUser etc.

---