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