Skip to content

Latest commit

 

History

History
31 lines (25 loc) · 1.03 KB

README.md

File metadata and controls

31 lines (25 loc) · 1.03 KB
Raw

Todolist Database

This is a terminal-based to-do list application. It allows users to add, delete, and modify tasks. The added tasks are stored in the database.

program running

how to run app

  • download and install JDK 17
  • setup environment and check java version installation on terminal 
    • java --version
  • download this repository or download todolist-database-1.0-SNAPSHOT in the repository
  • open terminal and go to file todolist-database-1.0-SNAPSHOT run the program 
    • C:\Users\YourComputer\Downloads\todolist> java -jar todolist-database-1.0-SNAPSHOT.jar

Entity Relationship Diagram

CREATE TABLE todolist(
      todo_id SERIAL,
      todo VARCHAR(255) NOT NULL,
      created_at TIMESTAMP WITH TIME ZONE DEFAULT (CURRENT_TIMESTAMP AT TIME ZONE 'Asia/Jakarta'),
      PRIMARY KEY (todo_id)
);

Using Technology

  • Java
  • PostgreSQL