TODOLIST
Tables (7)
Label
- LabelID — SERIAL
- LabelName — VARCHAR(50) — NOT NULL
Notification
- NotificationID — SERIAL
- TaskID — INT
- SendDateTime — TIMESTAMP
- Content — TEXT
Priority
- PriorityID — SERIAL
- PriorityName — VARCHAR(50) — NOT NULL
Task
- TaskID — SERIAL
- Title — VARCHAR(255) — NOT NULL
- Description — TEXT
- PriorityID — INT
- DueDate — DATE
- IsComplete — BOOLEAN
- CreatedDate — DATE
TaskLabel
- TaskLabelID — SERIAL
- TaskID — INT
- LabelID — INT
User
- UserID — SERIAL
- Username — VARCHAR(255) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255)
- RegistrationDate — DATE
UserTask
- UserTaskID — SERIAL
- UserID — INT
- TaskID — INT