trello

Tables (7)

Untitled3 (team)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Field (teamname) — varchar
  • Field2 (description) — varchar

Untitled4 (card)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (column_id) — bigint — Foreign key → Untitled7.Key — NOT NULL
  • Key (board_id) — bigint — Foreign key → Untitled7.Key — NOT NULL
  • Key (team_id) — bigint — Foreign key → Untitled7.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled7.Key — NOT NULL
  • Field (cardname) — varchar
  • Field (description) — varchar
  • Field (color) — varchar
  • Field (dueDate) — LocalDateTime
  • Field (createdAt) — LocalDateTime
  • Field (modifiedAt) — LocalDateTime

Untitled5 (board)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (team_id) — bigint — Foreign key → Untitled3.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled3.Key — NOT NULL
  • Field (boardname) — varchar
  • Field (backgroundcolor) — varchar
  • Field (description) — varchar
  • Field (username) — varchar

Untitled6 (comment)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (id2) — bigint — Foreign key → Untitled4.Key — NOT NULL
  • Key (column_id) — bigint — Foreign key → Untitled4.Key — NOT NULL
  • Key (board_id) — bigint — Foreign key → Untitled4.Key — NOT NULL
  • Key (team_id) — bigint — Foreign key → Untitled4.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled4.Key — NOT NULL
  • Key (id3) — bigInt — Foreign key → user.Key — NOT NULL
  • Field (content) — varchar
  • Field (createdAt) — LocalDateTime
  • Field (modifedAt) — LocalDateTime

Untitled7 (column)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (board_id) — bigint — Foreign key → Untitled5.Key — NOT NULL
  • Key (team_id) — bigint — Foreign key → Untitled5.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled5.Key — NOT NULL
  • Field (name) — varchar
  • Field (order) — bigint

member

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (role) — varchar
  • Key (member_id) — bigInt — Foreign key → user.Key — NOT NULL

user

  • Key (id) — bigInt — Primary key — NOT NULL
  • Field (username) — varchar
  • Field2 (password) — varchar
  • Field3 (email) — varchar
  • Field4 (intro) — varchar
  • Field (createdAt) — LocalDateTime
  • Field (modifiedAt) — LocalDateTime