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)