toduri

Tables (6)

Todo_status_history

  • Todo_id — VARCHAR(50) — Primary key — NOT NULL
  • T_id (T_id3) — Foreign key → Todos.T_id — NOT NULL
  • old_status — BOOLEAN
  • new_status — BOOLEAN
  • created_at — TIMESTAMP

Todos

  • T_id — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → User.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • due_date — DATE
  • completed — BOOLEAN
  • created_at — TIMESTAMP
  • Field

User

  • id — VARCHAR(50) — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

todo_status_history

  • id — BIGINT
  • todo_id — BIGINT — NOT NULL
  • old_status — BOOLEAN
  • new_status — BOOLEAN
  • changed_at — TIMESTAMP

todos

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • due_date — DATE
  • completed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP