DAILY DUTY - TO DO LIST APP

Meiji Grace Estrada

This documentation contains information about managing many different tasks and able to keep it on track. To create the app, data model and queries must be well constructed along with report and form. So, my client is able to insert and update their task in easy function.

Data model

This is a table for my client who wants to insert or add multiple tasks in database.

DAILY DUTY
ID	int (11) Primary key
Name	varchar(255)
Complete	bit(1) [b’0]
T	timestamp [ON UPDATE_CURRENT TIMESTAMP]

Queries

LIST OF PENDING TASKS (report)

SELECT ID, Name FROM DailyDuty_Task WHERE Complete = 0 ORDER BY T DESC LIMIT 10;

ADD THE NEW TASKS (form)

INSERT INTO DailyDuty_Task (Name)

VALUES (?);

MARK THE COMPLETED PENDING TASKS (form)

UPDATE DailyDuty_Task SET Complete = 1 WHERE ID = ? ORDER BY T;