whereareyou

Tables (13)

EmailCode (이메일 인증)

  • code_id (PK) — VARCHAR — Primary key — NOT NULL
  • code (이메일 코드) — VARCHAR
  • email (이메일) — VARCHAR

FcmToken (푸시알림 개인 Token)

  • fcm_token_id (PK) — VARCHAR — Primary key — NOT NULL
  • member_id (회원 ID) — VARCHAR
  • target_token (개인 Firebase Token) — VARCHAR

Friend (친구 목록)

  • friend_id (PK) — VARCHAR — Primary key — NOT NULL
  • friends_id (PK2) — VARCHAR — Foreign key → member.member_id — NOT NULL
  • owner_id (PK3) — VARCHAR — Foreign key → member.member_id — NOT NULL

FriendBookMark (친구 즐겨찾기)

  • friend_book_mark_id (PK) — VARCHAR — Primary key — NOT NULL
  • member_id (PK2) — VARCHAR — Foreign key → member.member_id — NOT NULL

FriendGroup (친구 그룹)

  • group_id (PK) — VARCHAR — Primary key — NOT NULL
  • member_id (PK2) — VARCHAR — Foreign key → member.member_id — NOT NULL
  • name (그룹 이름) — VARCHAR

FriendGroupMember (친구 그룹에 속해 있는 Member)

  • friend_group_member_id (PK) — VARCHAR — Primary key — NOT NULL
  • friend_id (PK2) — VARCHAR — Foreign key → member.member_id — NOT NULL
  • group_id (PK3) — VARCHAR — Foreign key → FriendGroup.group_id — NOT NULL

FriendRequest (친구 요청 목록)

  • friend_request_id (PK) — VARCHAR — Primary key — NOT NULL
  • sender_id (PK2) — VARCHAR — Foreign key → member.member_id — NOT NULL
  • receiver_id (PK3) — VARCHAR — Foreign key → member.member_id — NOT NULL

MemberInfo (회원 위치 정보)

  • member_info_id (PK) — VARCHAR — Primary key — NOT NULL
  • latitude (위도) — DOUBLE
  • longitude (경도) — DOUBLE
  • member_id (회원 ID) — VARCHAR

MemberSchedule (공유 일정에 들어 있는 Member)

  • member_schedule_id (PK) — VARCHAR — Primary key — NOT NULL
  • schedule_id (PK2) — VARCHAR — Foreign key → Schedule.schedule_id — NOT NULL
  • member_id (PK3) — VARCHAR — Foreign key → member.member_id — NOT NULL
  • accept (일정 수락 여부) — BIT
  • arrived (일정 도착 여부)

RefreshToken

  • refresh_token_id (PK) — VARCHAR — Primary key — NOT NULL
  • member_id (회원 ID) — VARCHAR
  • refresh_token (RefreshToken) — VARCHAR

Schedule (공유 일정)

  • schedule_id (PK) — VARCHAR — Primary key — NOT NULL
  • member_id (PK2) — VARCHAR — Foreign key → member.member_id — NOT NULL
  • start (일정 시작 시간) — DATETIME
  • end (일정 끝나는 시간) — DATETIME
  • title (일정 제목) — VARCHAR
  • memo (일정 memo) — VARCHAR
  • place (장소) — VARCHAR
  • destination_latitude (일정 위도) — DOUBLE
  • destination_longitude (일정 경도) — DOUBLE

SearchHistory (검색 기록)

  • search_history_id (PK) — VARCHAR — Primary key — NOT NULL
  • member_id (PK2) — VARCHAR — Foreign key → member.member_id — NOT NULL
  • search_history (검색 기록) — VARCHAR

member (회원)

  • member_id (PK) — VARCHAR — Primary key — NOT NULL
  • email (이메일) — VARCHAR
  • password (비밀번호) — VARCHAR
  • profile_image (프로필 이미지) — VARCHAR
  • user_id (로그인 아이디) — VARCHAR
  • user_name (회원 이름) — VARCHAR