TEAMFLOW

Tables (8)

boards

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • background_color — VARCHAR(255)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_user_id — INT — Foreign key → users.id — NOT NULL

boards_users

  • id — INT — Primary key — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • board_id — INT — Foreign key → boards.id — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL

cards

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_user_id — INT — Foreign key → users.id — NOT NULL
  • column_id — INT — Foreign key → columns.id — NOT NULL
  • color — VARCHAR(255)
  • deadline — TIMESTAMP
  • assigned_user_id — INT — Foreign key → users.id — NOT NULL
  • order_num — INT
  • from_column_id — INT
  • to_column_id — INT
  • status — ENUM

checklists

  • id — INT — Primary key — NOT NULL
  • item_name — VARCHAR(255)
  • checked — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • card_id — INT — Foreign key → cards.id — NOT NULL

columns

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • order_num — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • board_id — INT — Foreign key → boards.id — NOT NULL
  • status — ENUM

comments

  • id — INT — Primary key — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id — INT — Foreign key → users.id — NOT NULL
  • card_id — INT — Foreign key → cards.id — NOT NULL

files

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • path — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • card_id — INT — Foreign key → cards.id — NOT NULL

users

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • password — VARCHAR(255)
  • email — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP