project1

Tables (5)

Calendar (calendar)

  • Cal-id (cal-id) — Primary key — NOT NULL
  • Title (title)
  • Date (date)
  • Field
  • ID (id2) — Foreign key → User.ID — NOT NULL

Profile (profile)

  • ID (id) — Primary key — NOT NULL
  • Name (name)
  • E-mail (email)
  • Age (age)
  • Major (major)
  • ID (id2) — Foreign key → User.ID — NOT NULL

Routine (routine)

  • Rout-id (rout-id) — Primary key — NOT NULL
  • Title (title)
  • Day (day)
  • Time (time)
  • Field (field)
  • ID (id2) — Foreign key → User.ID — NOT NULL

Todo-list (todolist)

  • List-id (list-id) — Primary key — NOT NULL
  • Title (title)
  • Due date (due-date)
  • Field (field)
  • Priority (priority)
  • ID (id2) — Foreign key → User.ID — NOT NULL

User (user)

  • ID (id) — Primary key — NOT NULL
  • Username (username)
  • Password (password)