RemindMe

Tables (5)

Friend (친구목록)

  • id — BIGINT — Primary key — NOT NULL
  • 사용자 (user) — BIGINT — Foreign key → User.id — NOT NULL
  • 친구 (friend) — BIGINT — Foreign key → User.id — NOT NULL
  • 생성날짜 (createDate) — DATETIME(6)
  • 수정날짜 (modifiedDate) — DATETIME(6)

Schedule (스케쥴)

  • id — BIGINT — Primary key — NOT NULL
  • 사용자 (user) — BIGINT — Foreign key → User.id — NOT NULL
  • 생성날짜 (createDate) — DATETIME(6)
  • 수정날짜 (modifiedDate) — DATETiME(6)
  • 제목 (title) — VARCHAR(255)
  • 내용 (description) — LONGTEXT
  • 썸네일 (thubnail) — VARCHAR(255)
  • 시작날짜 (startDate) — DATETIME(6)
  • 종료날짜 (endDate) — DATETIME(6)
  • 소요시간 (duration) — VARCHAR(255)
  • 반복타입 (intervalType) — VARCHAR(255)
  • 반복간격 (intervalValue) — INT
  • 상태 (status) — INT
  • 삭제여부 (isDeleted) — BIT(1)

ScheduleMember (스케쥴 참여자)

  • id — BIGINT — Primary key — NOT NULL
  • 멤버 (member) — BIGINT — Foreign key → User.id — NOT NULL
  • 스케쥴 (schedule) — BIGINT — Foreign key → Schedule.id — NOT NULL
  • 참가확인 (acceptance) — BIT(1)

ScheduleReply (스케쥴 댓글)

  • id — BIGINT — Primary key — NOT NULL
  • 유저 (user) — BIGINT — Foreign key → User.id — NOT NULL
  • 스케쥴 (schedule) — BIGINT — Foreign key → Schedule.id — NOT NULL
  • 생성날짜 (createdDate) — DATETIME(6)
  • 수정날짜 (Field2) — DATETIME(6)
  • 내용 (description) — VARCHAR(255)
  • 상태 (status) — INT
  • 삭제여부 (isDeleted) — BIT(1)

User (유저)

  • id — BIGINT — Primary key — NOT NULL
  • 생성날짜 (createDate) — DATETIME(6)
  • 수정날짜 (modifiedDate) — DATETIME(6)
  • 이메일 (email) — VARCHAR(255)
  • 이름 (name) — VARCHAR(255)
  • 닉네임 (nickname) — VARCHAR(255)
  • 프로필사진 (picture) — VARCHAR(255)
  • 역할 (role) — VARCHAR(255)
  • 상태 (status) — INT
  • refreshToken — VARCHAR(255)