taskify
Tables (4)
card
- id — INT — Primary key — NOT NULL
- title — VARCHAR(50)
- contents — VARCHAR(500)
- author — VARCHAR(20)
- columnId — INT — Foreign key → column.id — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
column
- id — INT — Primary key — NOT NULL
- name — VARCHAR(50)
- createdAt — DATETIME
- updatedAt — DATETIME
history
- id — INT — Primary key — NOT NULL
- action — INT
- cardId — INT — Foreign key → card.id — NOT NULL
- createdAt — DATETIME
- title — VARCHAR(50)
- fromColumnName — VARCHAR(50)
- toColumnName — VARCHAR(50)
user
- id — INT — Primary key — NOT NULL
- username (name) — VARCHAR(30)
- pw — VARCHAR(30)
- createdAt — DATETIME