How is the MYSQL Database Structured?

The Different Tables And Their Attributes

The column headers signifies the table in the database and the rows under shows the attributes of the table

userAccount	flashcardCategory	flashcard
iD	categoryCode	flashcardId
	categoryName	flashcardName
	userAccountId	category
		question
		answer
		userAccountId

Stored Procedures

These Procedures can be called from a sql query to simplify the process of inserting/fetching data from the database

getAllUserFlashcards (in userId nvarchar(250))

---

getAllUserFlashcardsOfCategory (in userId nvarchar(250), in categoryCode int)

---

getCategoryCode (_userId nvarchar(250), _categoryName nvarchar(25))

---

checkCategoryName(_userId nvarchar(250), _categoryName nvarchar(25))

---

createNewFlashcardCategory (in _userId nvarchar(250), _categoryName nvarchar(25))

---

createNewFlashcard (in _userId nvarchar(250), _category nvarchar(25), _flashcardLabel nvarchar(25), _question text, _answer text)

---

getAllflashcardCategoriesForUser (in userId nvarchar(250))