TempTravel

테이블 (16)

DetailMapPing (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • Key (ping_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (detail_id) — NOT NULL — 외래 키 → DetailSchedule.Key — NOT NULL
  • Field (longitude)
  • Field4 (latitude)

DetailSchedule (CopyOfCopyOfUntitled)

  • Key (detail_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (total_id) — NOT NULL — 외래 키 → TotalSchedule.Key — NOT NULL
  • Field (cur_date)
  • Field3 (title)
  • Field4 (content)

DetailTodoCheckBox (CopyOfCopyOfCopyOfUntitled)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (detail_id) — NOT NULL — 외래 키 → DetailSchedule.Key — NOT NULL
  • Key (total_id) — NOT NULL — 외래 키 → DetailSchedule.Key — NOT NULL
  • Field4 (description)
  • Field (status)

MapPinInfo

  • Key (info_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (pin_id) — NOT NULL — 외래 키 → DetailMapPing.Key — NOT NULL
  • Field (title)
  • Field4 (content)
  • Field (image_url)

Member (Untitled)

  • Key (member_id) — NOT NULL — 기본 키 — NOT NULL
  • Field (name)
  • Field (age)
  • Field2 (gender)
  • Field3 (phone_number)
  • Field4 (email)
  • Field (password)

Memberth소유 개인챗 리스트 (CopyOfUntitled22)

  • Key (id) — 기본 키 — NOT NULL
  • Field (room_id)
  • Field (friend_id)
  • Field (member_id)

Member개인채팅룸 (Untitled2)

  • Key (room_id) — 기본 키 — NOT NULL
  • Field (member_id)
  • Field (content)

Tag (CopyOfUntitled2)

  • Key (tag_id) — NOT NULL — 기본 키 — NOT NULL
  • Field (name)

TotalMembers (CopyOfTotalVote)

  • Key (total_id) — NOT NULL — 외래 키 → TotalSchedule.Key — NOT NULL
  • Key (member_id) — NOT NULL — 외래 키 → Member.Key — NOT NULL

TotalMemo (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (total_id) — NOT NULL — 외래 키 → TotalSchedule.Key — NOT NULL
  • Field4 (description)

TotalSchedule (CopyOfUntitled)

  • Key (total_id) — NOT NULL — 기본 키 — NOT NULL
  • Field (start_date)
  • Field (end_date)
  • Field2 (notice)
  • Field3 (title)
  • Field4 (content)

TotalTag

  • Key (total_id) — NOT NULL — 외래 키 → TotalSchedule.Key — NOT NULL
  • Key (tag_id) — NOT NULL — 외래 키 → Tag.Key — NOT NULL

TotalTodoCheckBox (CopyOfCopyOfCopyOfCopyOfUntitled)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (total_id) — NOT NULL — 외래 키 → TotalSchedule.Key — NOT NULL
  • Field4 (description)
  • Field (status)

TotalVote

  • Key (vote_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (total_id) — NOT NULL — 외래 키 → TotalSchedule.Key — NOT NULL
  • Field4 (title)
  • Field (content)

VoteItem (CopyOfTotalVote2)

  • Key (vote_item_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (vote_id) — NOT NULL — 외래 키 → TotalVote.Key — NOT NULL
  • Field4 (description)
  • Field (vote_count)

VoteMember (CopyOfCopyOfTotalVote2)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (member_id) — NOT NULL — 외래 키 → Member.Key — NOT NULL
  • Key (vote_item_id) — NOT NULL — 외래 키 → VoteItem.Key — NOT NULL
  • Key (vote_id) — NOT NULL — 외래 키 → VoteItem.Key — NOT NULL
  • Field (vote_status)