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