taskify
Tables (6)
Card (card)
- id — BIGINT — Primary key — NOT NULL
- columnId (column_id) — INT — Foreign key → Column.id — NOT NULL
- title — VARCHAR(20) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- author — INT — NOT NULL
- order — BIGINT — NOT NULL
- createAt (create_at) — TIMESTAMP — NOT NULL
- modifyAt (modify_at) — TIMESTAMP — NOT NULL
- state — BOOL — NOT NULL
CardEditHistory (card_edit_history)
- historyId (history_id) — BIGINT — Foreign key → History.id — NOT NULL
- fromTitle (from_title) — VARCHAR(20) — NOT NULL
- toTitle (to_title) — VARCHAR(20) — NOT NULL
- fromContent (from_content) — VARCHAR(500) — NOT NULL
- toContent (to_content) — VARCHAR(500) — NOT NULL
CardMoveHistory (card_move_history)
- historyId (history_id) — BIGINT — Foreign key → History.id — NOT NULL
- fromColumnName (from_column_name) — VARCHAR(20) — NOT NULL
- toColumnName (to_column_name) — VARCHAR(20) — NOT NULL
- fromColumnId (from_column_id) — INT — NOT NULL
- toColumnId (to_column_id) — INT — NOT NULL
Column (column)
- id — INT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- position — INT — NOT NULL
- state — BOOL — NOT NULL
CreateDeleteHistory (create_delete_history)
- historyId (history_id) — BIGINT — Foreign key → History.id — NOT NULL
- type — INT — NOT NULL — 1 : Card 2 : Column
- id — BIGINT — NOT NULL
History (history)
- id — BIGINT — Primary key — NOT NULL
- action — INT — NOT NULL — 1 : 카드생성-등록 2 : 카드수정-변경 3 : 카드삭제-삭제 4 : 카드이동-이동 11 : 컬럼생성 12 : 컬럼삭제
- dataId (data_id) — BIGINT — NOT NULL — card나 column의 id
- dataName (data_name) — VARCHAR(20) — NOT NULL — card.title, column.name
- createAt (create_at) — TIMESTAMP — NOT NULL