taskify
Tables (4)
card
- cardId — int — Primary key — NOT NULL
- userId (userId2) — varchar(100) — Foreign key → user.userId — NOT NULL
- columnId (columnId2) — int — Foreign key → columnList.columnId — NOT NULL
- userId — varchar(100) — NOT NULL
- columnId — int — NOT NULL
- title — varchar(100) — NOT NULL
- data — varchar(100) — NOT NULL
- author — varchar(100) — NOT NULL
- createTime — timestamp — NOT NULL
- updateTime — timestamp
columnList
- columnId — int — Primary key — NOT NULL
- columnname — varchar(100) — NOT NULL
history
- id — int — Primary key — NOT NULL
- cardId (cardId2) — int — Foreign key → card.cardId — NOT NULL
- userId (userId2) — varchar(100) — Foreign key → card.userId — NOT NULL
- columnId (columnId2) — int — Foreign key → card.columnId — NOT NULL
- cardId — int — NOT NULL
- action — varchar(4) — NOT NULL
- nowColumnId — int — NOT NULL
- preColumnId — int
- isDeleted — tinyint(1)
- createTime — timestamp
user
- userId — varchar(100) — Primary key — NOT NULL
- name — varchar(10) — NOT NULL
- pw — varchar(10) — NOT NULL