erd

Tables (5)

Calendar (캘린더)

  • calendar_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • name (Field2)

Calendar_Member (CopyOf일정 공유)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • calendar_id (Key2) — Foreign key → Calendar.calendar_id — NOT NULL

Event (일정)

  • event_id (Key) — Primary key — NOT NULL
  • calendar_id (Key2) — Foreign key → Calendar.calendar_id — NOT NULL
  • title (Field2)
  • description (Field3)
  • start_time (Field4)
  • end_time (Field5)

Event_Member (일정 공유)

  • event_id (Key2) — Foreign key → Event.event_id — NOT NULL
  • user_id (Key) — Foreign key → User.user_id — NOT NULL

User (유저)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • name (Field2)
  • password (Field3)