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