test

Tables (5)

board

  • board_id — Primary key — NOT NULL
  • user_id — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL

board_card

  • board_card_id — Primary key — NOT NULL
  • board_column_id — Foreign key → board_column.board_column_id — NOT NULL
  • owner_id — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • title
  • index

board_column

  • board_column_id — Primary key — NOT NULL
  • state_name — VARCHAR(100) — NOT NULL
  • index

board_members

  • board_id — BIGINT — Foreign key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • role — VARCHAR(50) — NOT NULL

users

  • user_id — Primary key — NOT NULL
  • user_name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL