Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Student profile #9

Open
4 tasks
Tracked by #12
GetPsyched opened this issue Dec 22, 2023 · 1 comment
Open
4 tasks
Tracked by #12

Student profile #9

GetPsyched opened this issue Dec 22, 2023 · 1 comment
Labels
feature New feature or request
Milestone

Comments

@GetPsyched
Copy link
Member

GetPsyched commented Dec 22, 2023

Most details will be non-editable:

  • Personal details (with non-editable profile picture)
  • Academic details - Results, DMCs, bonafide certificate, degree, etc.
  • A list of courses of the corresponding semester. This will just be a card with an image of the faculty teaching the course, some basic meta data of the course and the card hyperlinks to the actual course scheme/syllabi page. (My Courses #39)
  • Cultural Details - Club participation, Certificates issued, etc.

A reference for the student details going to be stored in the database:

nitkkr/database/schema.sql

Lines 136 to 159 in af102f6

roll_number varchar NOT NULL ,
name varchar(100) NOT NULL ,
sex varchar NOT NULL ,
telephone varchar[] NOT NULL ,
personal_email varchar NOT NULL ,
institute_email varchar NOT NULL ,
fathers_name varchar(100) NOT NULL ,
fathers_telephone varchar NOT NULL ,
mothers_name varchar(100) NOT NULL ,
mothers_telephone varchar NOT NULL ,
local_guardians_name varchar(100) ,
local_guardians_telephone varchar ,
pincode integer NOT NULL ,
permanent_address varchar NOT NULL ,
aadhaar varchar(12) ,
passport_number varchar ,
category varchar ,
birthday date NOT NULL ,
application_number varchar NOT NULL ,
admission_category varchar NOT NULL ,
date_of_admission date NOT NULL ,
is_pwd boolean DEFAULT false NOT NULL ,
admission_subcategory varchar ,
image varchar NOT NULL ,

@GetPsyched
Copy link
Member Author

Partially completed in #117

@GetPsyched GetPsyched added the feature New feature or request label Sep 15, 2024
@github-project-automation github-project-automation bot moved this to Backlog in Design Sep 15, 2024
@github-project-automation github-project-automation bot moved this to Backlog in Development Sep 15, 2024
@GetPsyched GetPsyched added this to the next milestone Sep 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature New feature or request
Projects
Status: Done
Status: Backlog
Development

No branches or pull requests

1 participant