mju-project

Tables (28)

ai_matching_group

  • ai_matching_group_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • matching_reason — TEXT
  • recommended_activity — TEXT
  • suggested_location — VARCHAR(200)
  • suggested_time — TIMESTAMP
  • group_status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

ai_matching_group_member

  • ai_matching_group_member_id — BIGINT — Primary key — NOT NULL
  • ai_matching_group_id — BIGINT — Foreign key → ai_matching_group.ai_matching_group_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

campus_canvas_pixel

  • campus_canvas_pixel_id — BIGINT — Primary key — NOT NULL
  • verification_id — BIGINT — Foreign key → verification.verification_id — NOT NULL
  • gathering_id — BIGINT — Foreign key → gathering.gathering_id
  • ai_matching_group_id — BIGINT — Foreign key → ai_matching_group.ai_matching_group_id
  • x_position — INT — NOT NULL
  • y_position — INT — NOT NULL
  • color — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

chat_room

  • chat_room_id — BIGINT — Primary key — NOT NULL
  • gathering_id — BIGINT — Foreign key → gathering.gathering_id
  • ai_matching_group_id — BIGINT — Foreign key → ai_matching_group.ai_matching_group_id
  • room_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(100)
  • is_active — BOOLEAN — NOT NULL
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

chat_room_member

  • chat_room_member_id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL
  • last_read_message_id — BIGINT

department

  • department_id — BIGINT — Primary key — NOT NULL
  • university_id — BIGINT — Foreign key → university.university_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • campus — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

email_verification

  • email_verification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • email — VARCHAR(100) — NOT NULL
  • verification_code — VARCHAR(20) — NOT NULL
  • verified — BOOLEAN — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • verified_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

gathering

  • gathering_id — BIGINT — Primary key — NOT NULL
  • host_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • max_member_count — INT — NOT NULL
  • current_member_count — INT — NOT NULL
  • gathering_status — VARCHAR(20) — NOT NULL
  • fusion_enabled — BOOLEAN — NOT NULL
  • is_ai_generated — BOOLEAN — NOT NULL
  • recommended_activity — TEXT
  • matching_reason — TEXT
  • meeting_location — VARCHAR(200)
  • meeting_time — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

gathering_application

  • gathering_application_id — BIGINT — Primary key — NOT NULL
  • gathering_id — BIGINT — Foreign key → gathering.gathering_id — NOT NULL
  • applicant_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • application_message — TEXT
  • application_status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

gathering_gathering_tag

  • gathering_gathering_tag_id — BIGINT — Primary key — NOT NULL
  • gathering_id — BIGINT — Foreign key → gathering.gathering_id — NOT NULL
  • gathering_tag_id — BIGINT — Foreign key → gathering_tag.gathering_tag_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

gathering_member

  • gathering_member_id — BIGINT — Primary key — NOT NULL
  • gathering_id — BIGINT — Foreign key → gathering.gathering_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • member_role — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL

gathering_recommendation

  • gathering_recommendation_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • gathering_id — BIGINT — Foreign key → gathering.gathering_id — NOT NULL
  • recommendation_reason — TEXT
  • score — DECIMAL(5,2)
  • created_at — TIMESTAMP — NOT NULL

gathering_tag

  • gathering_tag_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

hobby_tag

  • hobby_tag_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

idea

  • idea_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • ai_summary — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

idea_candidate_user

  • idea_candidate_user_id — BIGINT — Primary key — NOT NULL
  • idea_id — BIGINT — Foreign key → idea.idea_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • recommended_role — VARCHAR(50)
  • recommendation_reason — TEXT
  • score — DECIMAL(5,2)
  • created_at — TIMESTAMP — NOT NULL

idea_required_role

  • idea_required_role_id — BIGINT — Primary key — NOT NULL
  • idea_id — BIGINT — Foreign key → idea.idea_id — NOT NULL
  • role_name — VARCHAR(50) — NOT NULL
  • required_count — INT — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMP — NOT NULL

local_credential

  • local_credential_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

message

  • message_id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • sender_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • message_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

quick_connect_code

  • quick_connect_code_id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • issuer_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • code — VARCHAR(6) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • used — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

skill_tag

  • skill_tag_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

social_account

  • social_account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

university

  • university_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email_domain — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_available_time

  • available_time_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • day_of_week — VARCHAR(10) — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • repeat_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_hobby_tag

  • user_hobby_tag_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • hobby_tag_id — BIGINT — Foreign key → hobby_tag.hobby_tag_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_skill_tag

  • user_skill_tag_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • skill_tag_id — BIGINT — Foreign key → skill_tag.skill_tag_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • university_id — BIGINT — Foreign key → university.university_id — NOT NULL
  • department_id — BIGINT — Foreign key → department.department_id
  • email — VARCHAR(100) — NOT NULL
  • real_name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • age — INT
  • student_no — VARCHAR(20)
  • campus — VARCHAR(20)
  • home_area — VARCHAR(100)
  • profile_image_url — VARCHAR(500)
  • email_verified — BOOLEAN — NOT NULL
  • user_status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

verification

  • verification_id — BIGINT — Primary key — NOT NULL
  • gathering_id — BIGINT — Foreign key → gathering.gathering_id
  • ai_matching_group_id — BIGINT — Foreign key → ai_matching_group.ai_matching_group_id
  • uploaded_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • review_text — TEXT
  • ai_result — VARCHAR(20) — NOT NULL
  • ai_summary — TEXT
  • verified_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL