scheduler-personal project
Tables (4)
Comment (댓글)
- id (댓글 id) — NOT NULL — Primary key — NOT NULL
- scheduleId (일정 id) — NOT NULL — Foreign key → Schdule.id — NOT NULL
- userId (유저 id) — NOT NULL — Foreign key → Schdule.userId — NOT NULL
- comment (댓글 내용) — NOT NULL — NOT NULL
- writerID (작성자 ID) — NOT NULL — NOT NULL
- createdAt (작성일) — NOT NULL — NOT NULL
- updatedAt (수정일) — NOT NULL — NOT NULL
Reply (대댓글)
- id (대댓글 id) — NOT NULL — Primary key — NOT NULL
- scheduleId (일정 id) — NOT NULL — Foreign key → Comment.scheduleId — NOT NULL
- commentId (댓글 id) — NOT NULL — Foreign key → Comment.id — NOT NULL
- userId (유저 id) — NOT NULL — Foreign key → Comment.userId — NOT NULL
- reply (대댓글 내용) — NOT NULL — NOT NULL
- writerID (작성자 ID) — NOT NULL — NOT NULL
- createdAt (작성일) — NOT NULL — NOT NULL
- updatedAt (수정일) — NOT NULL — NOT NULL
Schdule (일정)
- id (일정 id) — NOT NULL — Primary key — NOT NULL
- userId (유저 id) — NOT NULL — Foreign key → User.id — NOT NULL
- title (일정 제목) — NOT NULL — NOT NULL
- content (일정 내용) — NOT NULL — NOT NULL
- writerID (작성자 ID) — NOT NULL — NOT NULL
- createdAt (작성일) — NOT NULL — NOT NULL
- updatedAt (수정일) — NOT NULL — NOT NULL
- commentCount (댓글 개수) — NULL
User (유저)
- id (유저 id) — NOT NULL — Primary key — NOT NULL
- name (유저명) — NOT NULL