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