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')