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