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