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