hostel-management-system
Tables (9)
Block
- id — INT
- name — VARCHAR(255) — NOT NULL
Complaint
- id — INT
- studentId — INT — NOT NULL
- message — TEXT — NOT NULL
- status — VARCHAR(50)
- createdAt — DATETIME
- updatedAt — DATETIME
Maintenance
- id — INT
- roomId — INT — NOT NULL
- description — TEXT — NOT NULL
- status — VARCHAR(50)
- reportedAt — DATETIME
- resolvedAt — DATETIME
Mess
- id — INT
- name — VARCHAR(255) — NOT NULL
- capacity — INT — NOT NULL
- menu — TEXT
Payment
- id — INT
- studentId — INT — NOT NULL
- amount — FLOAT — NOT NULL
- status — VARCHAR(50)
- dueDate — DATETIME — NOT NULL
- paidAt — DATETIME
- createdAt — DATETIME
- updatedAt — DATETIME
Room
- id — INT
- roomNumber — VARCHAR(50) — NOT NULL
- capacity — INT
- blockId — INT — NOT NULL
Student
- id — INT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- cgpa — FLOAT — NOT NULL
- preference — VARCHAR(255)
- roomId — INT
- messId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
User
- id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(50)
- studentId — INT
- wardenId — INT
- createdAt — DATETIME
- updatedAt — DATETIME
Warden
- id — INT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- blockId — INT