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

name: VARCHAR(100) - NOT NULL

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