trello2

Tables (10)

attachment

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • origin_file_name — varchar(255)
  • path — varchar(255)
  • card_id — bigint
  • user_id — bigint

board

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • background_color — varchar(7) — NOT NULL
  • title — varchar(100) — NOT NULL
  • workspace_id — bigint — NOT NULL

board_list

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • order_num — int
  • title — varchar(255) — NOT NULL
  • board_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

card

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255)
  • title — varchar(255)
  • board_list_id — bigint
  • user_id — bigint

card_log

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • member_email — varchar(255)
  • status — enum — NOT NULL
  • card_id — bigint
  • user_id — bigint

card_member

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • card_id — bigint
  • user_id — bigint

comment

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • comment — varchar(255) — archar(255) nul
  • card_id — bigint
  • user_id — bigint

member

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • member_role — enum — NOT NULL
  • user_id — bigint — NOT NULL
  • workspace_id — bigint — NOT NULL

users

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted — bit
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — enum — NOT NULL

workspace

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • description — varchar(300) — NOT NULL
  • title — varchar(100) — NOT NULL