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