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