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