calendar

Tables (10)

calender (Untitled2)

  • CalendarId (calendarId) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(20)
  • OwnerId (ownerId) — INT(11) — Foreign key → user.UserId — NOT NULL

calenderMembers (Untitled3)

  • CalendarMembersId (calendarMembersId) — INT(11) — Primary key — NOT NULL
  • Authority (authority) — VARCHAR(20)
  • UserId (userId) — INT(11) — Foreign key → user.UserId — NOT NULL
  • CalendarId (calendarId) — INT(11) — Foreign key → calender.CalendarId — NOT NULL

event (Untitled4)

  • EventId (eventId) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(20_
  • Color (color) — VARCHAR(10)
  • Priority (priority) — INT(10)
  • Memo (memo) — VARCHAR(200)
  • StartTime (startTime) — DATE
  • EndTime (endTime) — DATE
  • CalendarId (calendarId) — INT(11) — Foreign key → calender.CalendarId — NOT NULL
  • PrivateCalendarId (privateCalendarId) — INT(11) — Foreign key → privateCalender.PrivateCalendarId
  • MakerId (makerId) — INT(11) — Foreign key → user.UserId — NOT NULL

eventMembers (Untitled5)

  • EventMembersId (eventMembersId) — INT(11) — Primary key — NOT NULL
  • State (state) — VARCHAR(20)
  • EventId (eventId) — INT(11) — Foreign key → event.EventId — NOT NULL
  • UserId (userId2) — INT(11) — Foreign key → user.UserId — NOT NULL

inviteCalender (invite)

  • InviteCalendarId (inviteCalendarId) — INT(11) — Primary key — NOT NULL
  • HostId (hostId) — INT(11) — Foreign key → user.UserId — NOT NULL
  • GuestId (guestId) — INT(11) — Foreign key → user.UserId — NOT NULL
  • CalendarId (calendarId) — INT(11) — Foreign key → calender.CalendarId — NOT NULL
  • State (state) — VARCHAR(20)

inviteEvnet (inviteEvent)

  • Key — Primary key — NOT NULL
  • HostId (hostId) — INT(11) — Foreign key → user.UserId — NOT NULL
  • GuestId (guestId) — INT(11) — Foreign key → user.UserId — NOT NULL
  • EventId (eventId) — INT(11) — Foreign key → event.EventId — NOT NULL
  • CalendarId (calendarId) — INT(11) — Foreign key → calender.CalendarId — NOT NULL
  • State (state) — VARCHAR(20)

privateCalender (Untitled6)

  • PrivateCalendarId (privateCalendarId) — INT(11) — Primary key
  • UserId (userId) — INT(11) — Foreign key → user.UserId — NOT NULL
  • CalendarName (calendarName) — VARCHAR(20)

privateEvent (CopyOfUntitled4)

  • EventId (eventId) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(20_
  • Color (color) — VARCHAR(10)
  • Priority (priority) — INT(10)
  • Memo (memo) — VARCHAR(200)
  • StartTime (startTime) — DATE
  • EndTime (endTime) — DATE
  • PrivateCalendarId (privateCalendarId) — INT(11) — Foreign key → privateCalender.PrivateCalendarId

user (Untitled)

  • UserId (userId) — INT(11) — Primary key — NOT NULL
  • Email (email) — VARCHAR(200)
  • Password (password) — VARCAHR(200)
  • Nickname (nickname) — VARCHAR(20)

userProfileImage (Untitled7)

  • UserProfileImageId (userProfileImageId) — INT(11) — Primary key — NOT NULL
  • Src (src) — VARCHAR(200)
  • UserId (userId) — INT(11) — Foreign key → user.UserId — NOT NULL