test
Tables (6)
clubs
- id — BIGINT
- name — VARCHAR(100)
- field — VARCHAR(255)
departments
- id — BIGINT
- name — VARCHAR(100)
- college_name — VARCHAR(100)
event_users
- id — BIGINT
- user_id — BIGINT — NOT NULL
- event_id — BIGINT — NOT NULL
- attendance — ENUM('pending', 'attended', 'absent')
events
- id — BIGINT
- club_id — BIGINT
- department_id — BIGINT
- title — VARCHAR(200)
- description — TEXT
- location — VARCHAR(200)
- event_time — DATETIME
notifications
- id — BIGINT
- user_id — BIGINT — NOT NULL
- event_id — BIGINT — NOT NULL
- scheduled_time — DATETIME
- sent — BOOLEAN
users
- id — BIGINT
- department_id — BIGINT — NOT NULL
- club_id — BIGINT
- name — VARCHAR(50)
- student_number — VARCHAR(20)
- password — VARCHAR(255)
- role — ENUM('student', 'admin')