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