Study Helper

This is a platform where students can save and use their class notes.

Tech Stacks used:

1. Node Js
2. HTML
3. Vannila JavaScript
4. CSS
5. BootStrap 5
6. MySQL

For Running the project,

1. Clone this repository
2. Run 'npm install' command to install the required packages
3. Run 'node app' to start the server

Database Details

Note: Change your database connection details in the .env file

• Table details
  

  +-----------------------+
  | Tables_in_studyhelper |
  +-----------------------+
  | chapters              |
  | courses               |
  | notes                 |
  | student               |
  +-----------------------+
  

• student table description
  

  +------------+-------------+------+-----+-------------------+-------------------+
  | Field      | Type        | Null | Key | Default           | Extra             |
  +------------+-------------+------+-----+-------------------+-------------------+
  | S_Id       | int         | NO   | PRI | NULL              | auto_increment    |
  | name       | varchar(32) | NO   |     | NULL              |                   |
  | age        | int         | NO   |     | NULL              |                   |
  | email      | varchar(64) | NO   | UNI | NULL              |                   |
  | roll_no    | varchar(30) | YES  |     | NULL              |                   |
  | time_stamp | datetime    | YES  |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
  | password   | varchar(30) | NO   |     | NULL              |                   |
  +------------+-------------+------+-----+-------------------+-------------------+
  

• Course table description
  

  +-------------+-------------+------+-----+---------+----------------+
  | Field       | Type        | Null | Key | Default | Extra          |
  +-------------+-------------+------+-----+---------+----------------+
  | S_Id        | int         | YES  | MUL | NULL    |                |
  | C_Id        | int         | NO   | PRI | NULL    | auto_increment |
  | Course_name | varchar(32) | NO   |     | NULL    |                |
  +-------------+-------------+------+-----+---------+----------------+
      

• Chapters tables description
          
  
  +--------------+-------------+------+-----+---------+----------------+
  | Field        | Type        | Null | Key | Default | Extra          |
  +--------------+-------------+------+-----+---------+----------------+
  | chapter_id   | int         | NO   | PRI | NULL    | auto_increment |
  | course_id    | int         | YES  | MUL | NULL    |                |
  | chapter_name | varchar(32) | NO   |     | NULL    |                |
  +--------------+-------------+------+-----+---------+----------------+
          

• Notes table description
  

  +------------+---------------+------+-----+---------+----------------+
  | Field      | Type          | Null | Key | Default | Extra          |
  +------------+---------------+------+-----+---------+----------------+
  | Notes_id   | int           | NO   | PRI | NULL    | auto_increment |
  | chapter_id | int           | YES  | MUL | NULL    |                |
  | topic      | varchar(32)   | NO   |     | NULL    |                |
  | notes      | varchar(2048) | NO   |     | NULL    |                |
  +------------+---------------+------+-----+---------+----------------+
      

Thanks for visiting!