Schedule
Tables (3)
Comment (댓글)
- id (comment_id) — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → Member.id — NOT NULL
- schedule_id — bigint — Foreign key → Schedule.id — NOT NULL
- comment (댓글) — varchar(255) — NOT NULL
Member (유저)
- id (schedule_id) — bigint — Primary key — NOT NULL
- username (이름) — varchar(255) — NOT NULL
- password (비밀번호) — varchar(255) — NOT NULL
- create_at (생성일) — timestamp — NOT NULL
- modified_at (수정일) — timestamp — NOT NULL
Schedule (일정)
- id (schedule_id) — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → Member.id — NOT NULL
- title (할일 제목) — varchar(255) — NOT NULL
- content (할일 내용) — varchar(255) — NOT NULL
- done (완료 여부) — boolean — NOT NULL
- create_at (생성일) — timestamp — NOT NULL
- modified_at (수정일) — timestamp — NOT NULL