TimeTogether

테이블 (10)

개인일정 (meeting)

  • MeetId (meetId) — int — 기본 키 — NOT NULL
  • LocationId (locationId) — int — 외래 키 → 장소.LocationId — NOT NULL
  • CalendarId (calendarId) — int — 외래 키 → 캘린더.CalendarId — NOT NULL
  • MeetDTstart (meetDTstart) — timestamp
  • MeetDTend (meetDTend) — timestamp
  • MeetType (meetType) — enum
  • MeetTitle (meetTitle) — varchar(20)
  • MeetContent (meetContent) — varchar(255)
  • GroupName (groupName) — varchar(10)

그룹 (group_table)

  • id (Id) — Long — 기본 키 — NOT NULL
  • GroupName (groupName) — varchar(10)
  • GroupImg (groupImg) — varchar(20)
  • GroupMgrId (groupMgrId) — varchar(255)
  • GroupTimes (groupTimes) — varchar(255)
  • GroupUrl (groupUrl) — varchar(255)
  • GroupIntro (groupIntro) — varchar(255)

그룹 장소 (group_where)

  • GroupWhereId (groupWhereId) — int — 기본 키 — NOT NULL
  • GroupMeetId (groupMeetingId) — Long — 외래 키 → 회의일정.GroupMeetId — NOT NULL
  • GroupId (groupId) — Long — 외래 키 → 회의일정.GroupId — NOT NULL
  • GroupWhereName (groupWhereName) — String
  • GroupWhereUrl (groupWhereUrl) — String
  • Count (count) — int
  • ChooseThis (chooseThis) — boolean

로그인 (login)

  • SocialId (socialId) — varchar(50) — 외래 키 → 사용자.SocialId — NOT NULL
  • AccessToken (accessToken)
  • RefreshToken (refreshToken)

사용자 (user)

  • SocialId (socialId) — varchar(50) — 기본 키 — NOT NULL
  • CalendarId (calendarId) — int — 외래 키 → 캘린더.CalendarId — NOT NULL
  • GroupId (groupId) — Long — 외래 키 → 그룹.id — NOT NULL
  • UserName (userName) — varchar(10)

순위시간 (rank_time)

  • RankTimeId (rankTimeId) — int — 기본 키 — NOT NULL
  • When2meetId (when2meetId) — Long — 외래 키 → 특정날짜.When2meetId — NOT NULL
  • GroupId (groupId) — Long — 외래 키 → 특정날짜.GroupId — NOT NULL
  • Rank (rank) — varchar(255)
  • Time (time) — varchar(255)
  • Date (date) — varchar(10)

장소 (where2meet)

  • LocationId (locationId) — int — 기본 키 — NOT NULL
  • LocationName (locationName) — varchar(255)
  • LocationUrl (locationUrl) — varchar(255)

캘린더 (calender)

  • CalendarId (calendarId) — int — 기본 키 — NOT NULL

특정날짜 (when2meet)

  • When2meetId (when2meetId) — Long — 기본 키 — NOT NULL
  • GroupMeetId (groupMeetingId) — Long — 외래 키 → 회의일정.GroupMeetId — NOT NULL
  • GroupId (groupId) — Long — 외래 키 → 회의일정.GroupId — NOT NULL
  • Day (day) — varchar(10)
  • Date (date) — varchar(10)
  • Type (type) — enum

회의일정 (group_meeting)

  • GroupMeetId (groupMeetingId) — Long — 기본 키 — NOT NULL
  • GroupId (groupId) — Long — 외래 키 → 사용자.GroupId — NOT NULL
  • GroupMeetingTitle (groupMeetingTitle) — varchar(255)
  • GroupMeetingDays (groupMeetingDays) — varchar(255)