calendar-with

Tables (5)

calendar (캘린더 (일정 그룹))

  • id (calendar_id) — number — Primary key — NOT NULL
  • active (활성여부) — bool
  • created_at (생성일) — date
  • updated_at (수정일) — date
  • name (calendar_name) — text

calendar_attendee (캘린더 참여자)

  • id (group_attendee_id) — number — Primary key — NOT NULL
  • is_owner (그룹생성자?) — bool
  • calendar_id — number — Foreign key → calendar.id — NOT NULL
  • user_id — uuid — Foreign key → users.id — NOT NULL

schedule_attendee (일정 참여자)

  • id (schedule_attendee_id) — number — Primary key — NOT NULL
  • created_at (생성일) — date
  • schedule_id — number — Foreign key → schedules.id — NOT NULL
  • user_id — uuid — Foreign key → users.id — NOT NULL

schedules (일정)

  • id (스케줄id) — number — Primary key — NOT NULL
  • active (활성여부) — bool
  • created_at (생성일) — date
  • updated_at (수정일) — date
  • title (제목) — text
  • content (내용) — text
  • startDate (시작일) — date
  • endDate (종료일) — date
  • is_all_day (하루종일) — bool
  • calendar_id — number — Foreign key → calendar.id — NOT NULL

users (사용자)

  • id — number — Primary key — NOT NULL
  • user_id — uuid — NOT NULL
  • active (활성여부) — bool
  • email (이메일) — text
  • type (소셜타입) — text
  • nick (닉네임) — number