student_id: INT (PK) - Auto Increment
name: VARCHAR(100) - NOT NULL
email: VARCHAR(100) - NOT NULL, UNIQUE
marks: FLOAT - NOT NULL
caste: VARCHAR(50) - NOT NULL
income: INT - NOT NULL
scholarship_id: INT (PK) - Auto Increment
category: VARCHAR(50) - NOT NULL
min_marks: FLOAT - NOT NULL
income_limit: INT - NOT NULL
deadline: DATE - NOT NULL
application_id: INT (PK) - Auto Increment
student_id: INT (FK) - References Student(student_id)
scholarship_id: INT (FK) - References Scholarship(scholarship_id)
status: VARCHAR(20) - Default 'Submitted'
applied_date: DATE - Default CURRENT_DATE
admin_id: INT (PK) - Auto Increment
username: VARCHAR(50) - NOT NULL, UNIQUE
password: VARCHAR(100) - NOT NULL
by Anuksha