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