SHU
Tables (16)
Board
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- school_id — BIGINT — Foreign key → School.id — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
ChatMessage
- id — BIGINT — Primary key — NOT NULL
- content — TEXT — 이미지만 전송할 경우
- has_media — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- chatroom_id — BIGINT — Foreign key → ChatRoom.id — NOT NULL
- sender_id — BIGINT — Foreign key → User.id — NOT NULL
ChatRoom
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
ChatRoomUser
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
- chatroom_id — BIGINT — Foreign key → ChatRoom.id — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
Comment
- id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('ACTIVE','HIDDEN','DELETED') — NOT NULL
- created_at — DATETIME — NOT NULL
- post_id — BIGINT — Foreign key → Post.id — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- parent_comment_id — BIGINT — Foreign key → Comment.id
Media
- id — BIGINT — Primary key — NOT NULL
- target_type — ENUM('POST','CHAT_MSG') — NOT NULL
- target_id — BIGINT — NOT NULL
- url — VARCHAR(255) — NOT NULL
- media_type — ENUM('IMAGE','VIDEO') — NOT NULL
- created_at — DATETIME — NOT NULL
- uploader_id — BIGINT — Foreign key → User.id — NOT NULL
Notification
- id — BIGINT — Primary key — NOT NULL
- type — ENUM('COMMENT','REPLY','POST_LIKE','COMMENT_LIKE','CHAT','SYSTEM') — NOT NULL
- target_type — ENUM('POST','COMMENT','CHAT_MSG') — NOT NULL
- target_id — BIGINT — NOT NULL
- message — VARCHAR(255) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- user_id (id2) — BIGINT — Foreign key → User.id — NOT NULL
- actor_id — BIGINT — Foreign key → User.id — NOT NULL
Penalty
- id — BIGINT — Primary key — NOT NULL
- penalty_type — ENUM('WARNING','WRITE_BAN','SUSPEND','PERMANENT') — NOT NULL
- reason_code — ENUM('ABUSE','SPAM','SYSTEM','ADMIN') — NOT NULL
- detail — TEXT
- created_at — DATETIME — NOT NULL
- expires_at — DATETIME
- created_by — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- report_id — BIGINT — Foreign key → Report.id — NOT NULL
Post
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INTEGER — NOT NULL
- status — ENUM('ACTIVE','HIDDEN','DELETED') — NOT NULL
- created_at — DATETIME — NOT NULL
- like_count — INTEGER — NOT NULL
- dislike_count (disclike_count) — INTEGER — NOT NULL
- anonymous — TINYINT(1) — NOT NULL
- board_id — BIGINT — Foreign key → Board.id — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
Reaction
- id — BIGINT — Primary key — NOT NULL
- target_type — ENUM('POST','COMMENT') — NOT NULL
- target_id — BIGINT — NOT NULL — 다형적 fk
- liked — TINYINT(1) — NOT NULL
- disliked — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
Report
- id — BIGINT — Primary key — NOT NULL
- target_type — ENUM('POST','COMMENT','USER','CHAT_MSG') — NOT NULL
- target_id — BIGINT — NOT NULL
- snapshot_school_id — BIGINT
- snapshot_board_id — BIGINT
- snapshot_post_id — BIGINT
- snapshot_post_title — VARCHAR(200)
- snapshot_comment_id — BIGINT
- snapshot_comment_content — VARCHAR(500)
- snapshot_chat_message — TEXT
- reason_code — ENUM('ABUSE','HATE','SPAM','SEXUAL','ETC') — NOT NULL
- description — TEXT
- status — ENUM('PENDING','ACCEPTED','REJECTED') — NOT NULL
- created_at — DATETIME — NOT NULL
- processed_at — DATETIME
- processed_by — BIGINT
- reporter_id — BIGINT — Foreign key → User.id — NOT NULL
- reported_user_id — BIGINT — Foreign key → User.id — NOT NULL
School
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- logo_image_url — VARCHAR(255)
User
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- profile_image_url — VARCHAR(255)
- is_write_banned — TINYINT(1) — NOT NULL
- write_ban_expires_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- role — ENUM('USER', 'ADMIN') — NOT NULL
- userStatus — ENUM('ACITVE',) — NOT NULL
- school_id — BIGINT — Foreign key → School.id — NOT NULL
UserSchoolVerification
- id — BIGINT — Primary key — NOT NULL
- verified_at — DATETIME — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- school_id — BIGINT — Foreign key → School.id — NOT NULL
UserSchoolVerificationRequest
- id — BIGINT — Primary key — NOT NULL
- request_image_url — VARCHAR(255) — NOT NULL
- status — ENUM('PENDING','APPROVED','REJECTED') — NOT NULL
- admin_comment — TEXT
- requested_at — DATETIME — NOT NULL
- processed_at — DATETIME
- processed_by — BIGINT
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- school_id — BIGINT — Foreign key → School.id — NOT NULL
UserSetting
- id — BIGINT — Primary key — NOT NULL
- allow_push — TINYINT(1) — NOT NULL
- allow_comment_notification — TINYINT(1) — NOT NULL
- allow_reply_notification — TINYINT(1) — NOT NULL
- allow_like_notification — TINYINT(1) — NOT NULL
- allow_chat_notification — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- user_id — BIGINT — Foreign key → User.id — NOT NULL