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