MyTrello

Tables (4)

Board

  • board (pk) — Primary key — NOT NULL
  • project (fk) — Foreign key → Project.project — NOT NULL
  • list_set (Field)

Card

  • card (pk) — int — Primary key — NOT NULL
  • list (fk) — Foreign key → List.list — NOT NULL
  • title
  • description
  • due_date (Field)

List

  • list (pk) — Primary key — NOT NULL
  • board (fk) — Foreign key → Board.board — NOT NULL
  • title
  • card_set (Field)

Project (Untitled)

  • project (pk) — Primary key — NOT NULL
  • board_set (Field)