scheduleDevelop
Tables (3)
comment (댓글)
- id (댓글 식별자) — NOTNULL — Primary key — NOT NULL
- id (일정 식별자) — NOTNULL — Foreign key → schedule.id — NOT NULL
- id (유저 식별자) — NOTNULL — Foreign key → schedule.id — NOT NULL
- comment (댓글내용) — NOTNULL
- created_at (작성일) — NOTNULL
- updated_at (수정일) — NOTNULL
member (사용자)
- id (유저 식별자) — NOTNULL — Primary key — NOT NULL
- user_name (유저명) — NOTNULL
- password (비밀번호) — NOTNULL
- email (이메일) — NOTNULL
- created_at (작성일) — NOTNULL
- updated_at (수정일) — NOTNULL
schedule (일정)
- id (일정 식별자) — NOTNULL — Primary key — NOT NULL
- id (유저 식별자) — NOTNULL — Foreign key → member.id — NOT NULL
- title (제목) — NOTNULL
- contents (내용) — NULL
- created_at (작성일) — NOTNULL
- updated_at (수정일) — NOTNULL