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