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