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