ex

Tables (24)

ai_summaries

  • id — UUID
  • room_id — UUID — Foreign key → study_rooms.id — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • summary_date — DATE
  • type — VARCHAR(20)
  • selected_message_ids — JSON
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

blocks

  • id — UUID
  • blocker_id — UUID — Foreign key → users.id — NOT NULL
  • blocked_id — UUID — Foreign key → users.id — NOT NULL
  • blocked_at — TIMESTAMP

chat_files

  • id — UUID
  • message_id — UUID — Foreign key → chat_messages.id — NOT NULL
  • room_id — UUID — Foreign key → study_rooms.id — NOT NULL
  • file_url — TEXT — NOT NULL
  • file_name — VARCHAR(255)
  • file_type — VARCHAR(100)
  • file_size — BIGINT
  • uploaded_at — TIMESTAMP
  • expires_at — TIMESTAMP

chat_messages

  • id — UUID
  • room_id — UUID — Foreign key → study_rooms.id — NOT NULL
  • sender_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT
  • is_deleted — BOOLEAN
  • sent_at — TIMESTAMP
  • deleted_at — TIMESTAMP

direct_message_rooms

  • id — UUID
  • type — VARCHAR(20)
  • name — VARCHAR(255)
  • created_at — TIMESTAMP

direct_messages

  • id — UUID
  • dm_room_id — UUID — Foreign key → direct_message_rooms.id — NOT NULL
  • sender_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT
  • is_deleted — BOOLEAN
  • sent_at — TIMESTAMP
  • deleted_at — TIMESTAMP

dm_files

  • id — UUID
  • dm_message_id — UUID — Foreign key → direct_messages.id — NOT NULL
  • file_url — TEXT — NOT NULL
  • file_name — VARCHAR(255)
  • file_type — VARCHAR(100)
  • file_size — BIGINT
  • uploaded_at — TIMESTAMP
  • expires_at — TIMESTAMP

dm_room_members

  • id — UUID
  • dm_room_id — UUID — Foreign key → direct_message_rooms.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • is_pinned — BOOLEAN
  • is_notified — BOOLEAN
  • status — VARCHAR(20)
  • joined_at — TIMESTAMP
  • left_at — TIMESTAMP

friends

  • id — UUID
  • requester_id — UUID — Foreign key → users.id — NOT NULL
  • receiver_id — UUID — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • requested_at — TIMESTAMP
  • responded_at — TIMESTAMP

notice_files

  • id — UUID
  • notice_id — UUID — Foreign key → study_notices.id — NOT NULL
  • file_url — TEXT — NOT NULL
  • file_name — VARCHAR(255)
  • file_type — VARCHAR(100)
  • file_size — BIGINT
  • uploaded_at — TIMESTAMP
  • expires_at — TIMESTAMP

notifications

  • id — UUID
  • receiver_id — UUID — Foreign key → users.id — NOT NULL
  • actor_id — UUID — Foreign key → users.id
  • type — VARCHAR(50)
  • reference_id — UUID
  • reference_type — VARCHAR(100)
  • is_read — BOOLEAN
  • created_at — TIMESTAMP
  • expires_at — TIMESTAMP

reviews

  • id — UUID
  • reviewer_id — UUID — Foreign key → users.id — NOT NULL
  • reviewee_id — UUID — Foreign key → users.id — NOT NULL
  • room_id — UUID — Foreign key → study_rooms.id — NOT NULL
  • selected_keywords — JSON
  • comment — TEXT — EX
  • created_at — TIMESTAMP

study_applications

  • id — UUID
  • post_id — UUID — Foreign key → study_posts.id — NOT NULL
  • applicant_id — UUID — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20)
  • message — VARCHAR(255)
  • applied_at — TIMESTAMP
  • responded_at — TIMESTAMP

study_bookmarks

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • post_id — UUID — Foreign key → study_posts.id — NOT NULL
  • bookmarked_at — TIMESTAMP

study_notices

  • id — UUID
  • room_id — UUID — Foreign key → study_rooms.id — NOT NULL
  • author_id — UUID — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • is_pinned — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

study_post_tags

  • id — UUID
  • post_id — UUID — Foreign key → study_posts.id — NOT NULL
  • tag_id — UUID — Foreign key → tags.id — NOT NULL

study_posts

  • id — UUID
  • author_id — UUID — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • goal — TEXT
  • thumbnail_url — TEXT
  • max_members — INT — NOT NULL
  • current_members — INT
  • category — VARCHAR(50)
  • recruit_start_at — DATE
  • recruit_end_at — DATE
  • study_start_at — DATE
  • study_end_at — DATE
  • time_zone — VARCHAR(100)
  • status — VARCHAR(30)
  • is_modified — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

study_room_members

  • id — UUID
  • room_id — UUID — Foreign key → study_rooms.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20)
  • status — VARCHAR(20)
  • joined_at — TIMESTAMP
  • left_at — TIMESTAMP

study_rooms

  • id — UUID
  • post_id — UUID — Foreign key → study_posts.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • goal — TEXT
  • start_at — DATE
  • end_at — DATE
  • status — VARCHAR(30)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

study_schedules

  • id — UUID
  • room_id — UUID — Foreign key → study_rooms.id — NOT NULL
  • creator_id — UUID — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • start_time — TIME
  • end_time — TIME
  • location_type — VARCHAR(20)
  • location — VARCHAR(255)
  • memo — TEXT
  • repeat_type — VARCHAR(20)
  • repeat_days — JSON
  • repeat_group_id — UUID
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

tags

  • id — UUID
  • name — VARCHAR(50) — NOT NULL

user_account_settings

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • notify_friend_request — BOOLEAN
  • notify_study_apply — BOOLEAN
  • notify_study_approve — BOOLEAN
  • notify_study_info_change — BOOLEAN
  • notify_schedule — BOOLEAN
  • notify_message — BOOLEAN
  • notify_file_upload — BOOLEAN
  • notify_chat — BOOLEAN
  • updated_at — TIMESTAMP

user_profiles

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • introduce — TEXT
  • time_zones — JSON
  • skills — JSON
  • goals — JSON
  • interest_fields — JSON
  • portfolio_links — JSON
  • visibility — VARCHAR(20)
  • updated_at — TIMESTAMP

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • last_visited_at — TIMESTAMP