Kezuler ERD
Tables (7)
Fixed Event (fixedEvent)
- Fixed Event ID (fixedEventId) — str — Primary key — NOT NULL
- Host User ID (hostUserId) — str — Foreign key → User.User ID — NOT NULL
- Title (title) — str
- Duration (duration) — int
- Final Date (date) — datetime
- Final Place Address (placeAddress) — str
- Final Place URL (placeUrl) — str
- Attachment (attachment) — url
- Participants (participants) — List[str] — Foreign key → User.User ID — NOT NULL
- IsDisabled (isDisabled) — bool
Pending Event (pendingEvent)
- Pending Event ID (pendingEventId) — str — Primary key — NOT NULL
- Host User ID (hostUserId) — str — Foreign key → User.User ID — NOT NULL
- Title (title) — str
- Duration (duration) — int
- Available Time (dates) — List[datetime]
- Available Space (placeAddress) — str
- Available URL (placeUrl) — str
- Attachment (attachment) — url
Reminder (reminder)
- Reminder ID (reminderId) — str — Primary key — NOT NULL
- Fixed Event ID (fixedEventId) — str — Foreign key → Fixed Event.Fixed Event ID — NOT NULL
- User ID (userId) — str — Foreign key → Fixed Event.Host User ID — NOT NULL
- Date (date) — datetime
Time Survey - Declined (declinedSurvey)
- Declined Survey ID (dsId) — str — Primary key — NOT NULL
- User ID (user_id) — str — Foreign key → User.User ID — NOT NULL
- Pending Event ID (pendingEventId) — str — Foreign key → Pending Event.Pending Event ID — NOT NULL
- Declined Reason (reason) — str
Time survey - Accepted (acceptedSurvey)
- Accepted Survey ID (asId) — str — Primary key — NOT NULL
- User ID (user_id) — str — Foreign key → User.User ID — NOT NULL
- Pending Event ID (pendingEventId) — str — Foreign key → Pending Event.Pending Event ID — NOT NULL
- Available Day (date) — date
Token (token)
- Token ID (token_id) — str — Primary key — NOT NULL
- User ID (user_id) — str — Foreign key → User.User ID — NOT NULL
- Auth Token (authToken) — str
- Auth Token Expiration Date (authTokenExpiresAt) — datetime
- Refresh Token (refreshToken) — str
- Refresh Token Expiration Date (refreshTokenExpiresAt) — datetime
User (user)
- User ID (user_id) — str — Primary key — NOT NULL
- Name (name) — str
- Kakao ID (kakao_id) — str
- Email (email) — str
- Phone Number (phone_number) — str
- Profile Image (profile_image) — str
- Google Calendar ID (googleCalendarId) — str
- Timezone (timezone) — tz