taskify
Tables (5)
card
- id — INT
- deleted — BOOLEAN
- title — VARCHAR(45) — NOT NULL
- content — VARCHAR(500)
- position — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- card_list_id — INT
card_list
- id — INT
- deleted — BOOLEAN
- title — VARCHAR(45) — NOT NULL
- position — INT — NOT NULL
- user_id — INT
history
- id — INT
- history_type — VARCHAR(20) — NOT NULL
- history_description — JSON
- created_at — DATETIME — NOT NULL
- user_id — INT
history_detail
- id — INT
- changed_table_name — VARCHAR(64) — NOT NULL
- changed_tuple_id — INT — NOT NULL
- changed_data — JSON — NOT NULL
- history_id — INT — NOT NULL
user
- id — INT
- username — VARCHAR(45) — NOT NULL
- password — VARCHAR(45) — NOT NULL