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)