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