workflow

Tables (7)

Board

  • BoardID — INT
  • BoardName — VARCHAR(255)
  • BackgroundColor — VARCHAR(255)
  • Description — TEXT
  • UserID — INT
  • Created_at — TIMESTAMP
  • Updated_at — TIMESTAMP

Card

  • CardID — INT
  • CardName — VARCHAR(255)
  • Description — TEXT
  • Color — VARCHAR(255)
  • UserID — INT
  • ColumnID — INT
  • Created_at — TIMESTAMP
  • Updated_at — TIMESTAMP

Checklist

  • ChecklistID — INT
  • ItemName — VARCHAR(255)
  • Checked — BOOLEAN
  • CardID — INT
  • Created_at — TIMESTAMP
  • Updated_at — TIMESTAMP

Column

  • ColumnID — INT
  • ColumnName — VARCHAR(255)
  • BoardID — INT
  • Order — INT
  • Created_at — TIMESTAMP
  • Updated_at — TIMESTAMP

Comment

  • CommentID — INT
  • Content — TEXT
  • UserID — INT
  • CardID — INT
  • Created_at — TIMESTAMP
  • Updated_at — TIMESTAMP

File

  • FileID — INT
  • FileName — VARCHAR(255)
  • FilePath — VARCHAR(255)
  • CardID — INT
  • Created_at — TIMESTAMP
  • Updated_at — TIMESTAMP

User

  • UserID — INT
  • Username — VARCHAR(255)
  • Password — VARCHAR(255)
  • Email — VARCHAR(255)
  • Created_at — TIMESTAMP
  • Updated_at — TIMESTAMP