newple-2
Tables (11)
ExerciseStyle (운동스타일)
- Key (exercise_style_id) — bigint — Primary key — NOT NULL
- Key (profile_id) — bigint — Foreign key → Profile.Key — NOT NULL
- Field (value) — varchar
History (기록)
- Key (history_id) — bigint — Primary key — NOT NULL
- Key (profile_id) — bigint — Foreign key → Profile.Key — NOT NULL
- Key (member_id) — bigint — Foreign key → Profile.Key — NOT NULL
Interests (관심사)
- Key (interest_id) — bigint — Primary key — NOT NULL
- Key (profile_id) — bigint — Foreign key → Profile.Key — NOT NULL
- Field (value) — varchar
Match (매칭)
- Key (id) — bigint — Primary key — NOT NULL
- Key (applicant_id) — bigint — Foreign key → Member.Key — NOT NULL
- Key (applicationi_post_id) — bigint — Foreign key → Post.Key — NOT NULL
- Field (match_status) — varchar
Member (회원)
- Key (member_id) — bigint — Primary key — NOT NULL
- Field (provider) — varchar
- Field (provider_id) — varchar
- Field (oauth2_provider) — varchar
- Field (username) — varchar
- Field (password) — varchar
- Field (email) — varchar
- Field (age) — varchar
- Field (birth) — varchar
- Field (gender) — varchar
- Field (role) — varchar
- Field (profile_id) — bigint
- Field (profile_url) — varchar
Message (쪽지)
- Key (message_id) — bigint — Primary key — NOT NULL
- Key (sender_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (receiver_id) — bigint
- Field (content) — varchar
- Field (sent_date) — timestamp
Post (게시글)
- Key (post_id) — bigint — Primary key — NOT NULL
- Key (writer_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (title) — varchar
- Field (content) — varchar
- Field (written_date) — timestamp
- Field (sport) — varchar
- Field (post_region) — varchar
- Field (status) — varchar
- Field (wanted_age) — varchar
- Field (wanted_gender) — varchar
- Field (wanted_runtime) — timestamp
- Field (matched_member_id) — bigint
PostTag (게시글태그)
- Key (id) — Long — Primary key — NOT NULL
- Key (post_id) — Long — Foreign key → Post.Key — NOT NULL
- Field (tag) — varchar
Profile (프로필)
- Key (profile_id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (profile_img) — varchar
- Field (introduce) — varchar
- Field (mbti_type) — varchar
- Field (gpa_value) — varchar
- Field (region_name) — varchar
- Field (sport_name) — varchar
- Field (exercise_period) — varchar
- Field (wanted_age) — varchar
- Field (wanted_gender) — varchar
- Field (wanted_personality) — varchar
- Field (wanted_periodex) — varchar
Review (리뷰)
- Key (review_id) — bigint — Primary key — NOT NULL
- Key (rater_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (target_id) — bigint
- Field (score) — int
ReviewMessage (리뷰내용)
- Key (review_message_id) — bigint — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → Review.Key — NOT NULL
- Field (value) — varchar