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)