jamrello

Tables (7)

board

  • id — Long — Primary key — NOT NULL
  • title — varchar — NOT NULL
  • background_color — varchar — NOT NULL
  • status — boolean — NOT NULL
  • created_at — LocalDateTime — NOT NULL
  • modified_at — LocalDateTime — NOT NULL
  • image_url — varchar

card_collaborator

  • id — Long — Primary key — NOT NULL
  • card_id — Long — Foreign key → cards.id — NOT NULL
  • user_id — Long — Foreign key → member.id — NOT NULL

cards

  • id — Long — Primary key — NOT NULL
  • column_id — Long — Foreign key → catalog.id — NOT NULL
  • tilte — varchar — NOT NULL
  • description — varchar
  • background_color — varchar — NOT NULL
  • status — boolean — NOT NULL
  • start_day — Timestamp
  • due_day — Timestamp
  • image_url — varchar
  • position — Long — NOT NULL
  • created_at — Timestamp — NOT NULL
  • modified_at — Timestamp — NOT NULL

catalog

  • id — Long — Primary key — NOT NULL
  • board_id — Long — Foreign key → board.id — NOT NULL
  • title — varchar — NOT NULL
  • status — boolean — NOT NULL
  • position — Long — NOT NULL
  • created_at — Timestamp — NOT NULL
  • modified_at — Timestamp — NOT NULL

comment

  • id — Long — Primary key — NOT NULL
  • card_id — Long — Foreign key → cards.id — NOT NULL
  • user_id — Long — Foreign key → member.id — NOT NULL
  • content — varchar — NOT NULL
  • created_at — Timestamp — NOT NULL
  • modified_at — Timestamp — NOT NULL

member

  • id — Long — Primary key — NOT NULL
  • username — varchar — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar — NOT NULL
  • email — varchar — NOT NULL
  • created_at — LocalDateTime — NOT NULL
  • modified_at — Timestamp — NOT NULL

user_board

  • id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → member.id — NOT NULL
  • board_id — Long — Foreign key → board.id — NOT NULL
  • role — varchar — NOT NULL