test

Tables (4)

board_columns

  • id — UUID
  • board_id — UUID — Foreign key → boards.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • order_index — DECIMAL(10,4) — NOT NULL

boards

  • id — UUID
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tasks

  • id — UUID
  • column_id — UUID — Foreign key → board_columns.id — NOT NULL
  • creator_id — UUID — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • order_index — DECIMAL(10,4) — NOT NULL
  • version — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL