naveBoostCamp-taskify

Tables (4)

Card (card)

  • id — int — Primary key — NOT NULL — auto Increase
  • title — varchar(20)
  • content — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • column_id — int — Foreign key → Column.id — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL

Column (column)

  • id — int — Primary key — NOT NULL
  • title — varchar(20)

History (history)

  • id — int — Primary key — NOT NULL
  • action — varchar(10)
  • title — varchar(20)
  • prev_column — varchar(20)
  • current_column — varchar(20)
  • created_at — timestamp
  • user_id — int — Foreign key → User.id — NOT NULL

User (user)

  • id — int — Primary key — NOT NULL
  • name — varchar(10)
  • profile_img — varchar(255)