No title

Database Design - AI Mental Health Chatbot

Table: login

Primary Key: id

FieldTypeDescription
idINTUnique identifier for login
usernameVARCHAREmail or username
passwordVARCHARUser password
usertypeVARCHARRole: user / mentor / admin

Table: user

Primary Key: id | Foreign Key: login_id → login.id

FieldTypeDescription
idINTUnique identifier for user
login_idINTLogin ID reference
nameVARCHARUser's full name
ageINTUser's age
emailVARCHAREmail
phoneVARCHARPhone number
photoVARCHARProfile image path

Table: mentor

Primary Key: id | Foreign Key: login_id → login.id

FieldTypeDescription
idINTUnique mentor ID
login_idINTLogin ID reference
nameVARCHARMentor's name
qualificationVARCHAREducational background
experienceVARCHARExperience details
photoVARCHARProfile image
statusVARCHARAdmin approval status

Post a Comment

Previous Post Next Post