schedule
Tables (3)
comment (댓글)
- 번호 (id) — longint — Primary key — NOT NULL
- 내용 (content) — varchar(1000)
- 생성일자 (created_at) — datetime
- 수정일자 (updated_at) — datetime
- schedule_id (스케줄번호) — longint — Foreign key → schedule.id — NOT NULL
- user_id (회원번호) — longint — Foreign key → user.user_id — NOT NULL
schedule (스케쥴)
- id (번호) — longint — Primary key — NOT NULL
- content (내용) — varchar(1000)
- title (제목) — varchar(100)
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime
- user_id (회원번호) — longint — Foreign key → user.user_id — NOT NULL
user (사용자)
- user_id (회원번호) — longint — Primary key — NOT NULL
- email (이메일) — varchar(100)
- password (비밀번호) — varchar(1000)
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime