schedule

Tables (3)

author (작성자)

  • id (작성자 id) — NOT NULL — Primary key — NOT NULL
  • name (이름) — NOTNULL
  • email (이메일) — NOTNULL
  • created (작성자등록일) — NULL
  • updated (작성자수정일) — NULL

plan (일정)

  • id (일정 id) — NOTNULL — Primary key — NOT NULL
  • authorId (작성자 id) — NOTNULL — Foreign key → author.id — NOT NULL
  • task (할일) — NOTNULL
  • pwd (비밀번호) — NOTNULL
  • created (일정등록일) — NULL
  • updated (일정수정일) — NULL

schedule (스케줄)

  • id (일정 id) — NOTNULL — Primary key — NOT NULL
  • author (작성자명) — NULL
  • task (할일) — NULL
  • pwd (비밀번호) — NULL
  • created (일정등록일) — NULL
  • updated (일정수정일) — NULL