First
Tables (7)
Calendar (캘린더)
- id (Key) — int — Primary key — NOT NULL
- IsPublic (공개/비공개) — Bool
- Name (캘린더 이름) — varchar
- Content (내용) — varchar
- Image (캘린더 이미지) — varchar
Favorite Calendar (캘린더 즐겨찾기)
- id (Key) — int — Primary key — NOT NULL
- User.id (유저 id) — int — Foreign key → User.id — NOT NULL
- Calendar.id (캘린더 id) — int — Foreign key → Calendar.id — NOT NULL
Favorite Schedule (일정 즐겨찾기)
- id (Key) — int — Primary key — NOT NULL
- User.id (유저 id) — int — Foreign key → User.id — NOT NULL
- Schedule.id (스케줄 id) — int — Foreign key → Schedule.id — NOT NULL
Holiday (휴일)
- id (Key) — int — Primary key — NOT NULL
- Holiday (휴일) — timestamp
- Calendar.id (캘린더 id) — int — Foreign key → Calendar.id — NOT NULL
- Field
Schedule (일정)
- id (Key) — int — Primary key — NOT NULL
- User.id (유저 id) — int — Foreign key → User.id — NOT NULL
- Calendar.id (캘린더 id) — int — Foreign key → Calendar.id — NOT NULL
- Title (제목) — varchar
- StartDate (시작일) — timestamp
- EndDate (종료일) — timestamp
- Content (내용) — varchar
- Location (위치) — varchar
- Tag (태그) — varchar
- AllDay (종일) — Bool
User (유저)
- id (Key) — int — Primary key — NOT NULL
- NickName (닉네임) — varchar
- Image (프사) — varchar
User_Calendar (유저 - 캘린더)
- id (Key) — int — Primary key — NOT NULL
- User.id (유저 id') — int — Foreign key → User.id — NOT NULL
- Calendar.id (캘린더 id) — int — Foreign key → Calendar.id — NOT NULL