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)