newple

Tables (8)

ExerciseStyle (운동스타일)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (style_id) — bigint — Foreign key → Profile.Key — NOT NULL
  • Field (value) — varchar

Interests (관심사)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (interest_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

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 (content) — varchar
  • Field (region_name) — varchar
  • Field (sport) — varchar
  • Field (status) — varchar
  • Field (title) — varchar
  • Field (age) — varchar
  • Field (gender) — varchar
  • Field (runtime) — String
  • Field (written_date) — timestamp

PostTag (게시글태그)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (post_tag_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