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