knock-in-test-realationship

Tables (27)

agreement

  • agreement_id — BIGINT — Primary key — NOT NULL

attach_file

  • attach_file_id — BIGINT — Primary key — NOT NULL

chat_message

  • chat_message_id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • sender_member_id — BIGINT — Foreign key → member.member_id — NOT NULL

chat_message_file

  • chat_message_id — BIGINT — Foreign key → chat_message.chat_message_id — NOT NULL
  • attach_file_id — BIGINT — Foreign key → attach_file.attach_file_id — NOT NULL

chat_room

  • chat_room_id — BIGINT — Primary key — NOT NULL
  • matching_process_id — BIGINT — Foreign key → matching_process.matching_process_id

chat_room_member

  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

inquiry

  • inquiry_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

matching_process

  • matching_process_id — BIGINT — Primary key — NOT NULL
  • requester_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • receiver_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • room_post_id — BIGINT — Foreign key → room_post.room_post_id

member (회원)

  • member_id — BIGINT — Primary key — NOT NULL

member_agreement

  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • agreement_id — BIGINT — Foreign key → agreement.agreement_id — NOT NULL

member_block

  • blocker_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • blocked_member_id — BIGINT — Foreign key → member.member_id — NOT NULL

member_identity

  • member_identity_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

member_life_pattern

  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

member_prefer_condition

  • member_prefer_condition_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

member_primary_condition

  • member_primary_condition_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • member_prefer_condition_id — BIGINT — Foreign key → member_prefer_condition.member_prefer_condition_id — NOT NULL

member_report

  • member_report_id — BIGINT — Primary key — NOT NULL
  • reporter_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • reported_member_id — BIGINT — Foreign key → member.member_id — NOT NULL

member_wanted_region

  • region_id — BIGINT — Foreign key → region.region_id — NOT NULL
  • wanted_room_profile_id — BIGINT — Foreign key → wanted_room_profile.wanted_room_profile_id — NOT NULL

notice

  • notice_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id

owned_room_profile

  • owned_room_profile_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • region_id — BIGINT — Foreign key → region.region_id — NOT NULL

region (지역)

  • region_id — BIGINT — Primary key — NOT NULL
  • parent_region_id — BIGINT — Foreign key → region.region_id

room_post

  • room_post_id — BIGINT — Primary key — NOT NULL
  • owned_room_profile_id — BIGINT — Foreign key → owned_room_profile.owned_room_profile_id — NOT NULL

room_post_file

  • room_post_id — BIGINT — Foreign key → room_post.room_post_id — NOT NULL
  • attach_file_id — BIGINT — Foreign key → attach_file.attach_file_id — NOT NULL

room_post_like

  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • room_post_id — BIGINT — Foreign key → room_post.room_post_id — NOT NULL

roommate_like

  • from_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • to_member_id — BIGINT — Foreign key → member.member_id — NOT NULL

search_log

  • search_log_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id
  • region_id — BIGINT — Foreign key → region.region_id

wanted_room_profile

  • wanted_room_profile_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL

wanted_room_type

  • wanted_room_type_id — BIGINT — Primary key — NOT NULL
  • wanted_room_profile_id — BIGINT — Foreign key → wanted_room_profile.wanted_room_profile_id — NOT NULL