notice

Tables (10)

chat_message

  • message_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • sender_type — VARCHAR(10) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

file

  • file_id — BIGINT — Primary key — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • uploaded_by — BIGINT — Foreign key → user.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

notice

  • notice_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • pinned — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_by — BIGINT — Foreign key → user.user_id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notice_attachment

  • attachment_id — BIGINT — Primary key — NOT NULL
  • notice_id — BIGINT — Foreign key → notice.notice_id — NOT NULL
  • file_id — BIGINT — Foreign key → file.file_id — NOT NULL

notice_image

  • image_id — BIGINT — Primary key — NOT NULL
  • notice_id — BIGINT — Foreign key → notice.notice_id — NOT NULL
  • file_id — BIGINT — Foreign key → file.file_id — NOT NULL
  • sort_order — INT — NOT NULL

open_feedback

  • feedback_id — BIGINT — Primary key — NOT NULL
  • round — INT — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • question — VARCHAR(1000) — NOT NULL
  • questioned_at — DATETIME — NOT NULL
  • answered_at — DATETIME
  • answer — TEXT
  • created_by — BIGINT — Foreign key → user.user_id — NOT NULL
  • answered_by — BIGINT — Foreign key → user.user_id

staff

  • staff_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL

student_fee

  • student_fee_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • amount — INT — NOT NULL
  • payment_status — VARCHAR(20) — NOT NULL
  • payment_link_url — VARCHAR(500)
  • paid_at — DATETIME
  • confirmed_by — BIGINT — Foreign key → user.user_id
  • updated_at — DATETIME — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL

work_schedule

  • schedule_id — BIGINT — Primary key — NOT NULL
  • day_of_week — VARCHAR(10) — NOT NULL
  • start_hour — TINYINT — NOT NULL
  • end_hour — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • staff_id — BIGINT — Foreign key → staff.staff_id — NOT NULL