todo_erd

Tables (4)

Untitled2 (friends)

  • userID — NOT NULL — Foreign key → User.userID — NOT NULL
  • Field (friend_ID) — NOT NULL

Untitled2 (shares)

  • Key (todoID) — NOT NULL — Foreign key → todo.Key — NOT NULL
  • userID — NOT NULL — Foreign key → todo.userID — NOT NULL

User (Untitled)

  • userID — NOT NULL — Primary key — NOT NULL
  • userName — NOT NULL
  • password — NOT NULL
  • email — NOT NULL
  • phoneNum (Field) — NOT NULL

todo

  • Key (todoID) — NOT NULL — Primary key — NOT NULL
  • userID — NOT NULL — Foreign key → User.userID — NOT NULL
  • Field (title) — NOT NULL
  • Field (memo) — NULL
  • Field (date) — NOT NULL
  • Field (start_time) — NOT NULL
  • Field (end_date) — NOT NULL
  • Field (place) — NULL