go-gitea / gitea

Git with a cup of tea! Painless self-hosted all-in-one software development service, including Git hosting, code review, team collaboration, package registry and CI/CD
https://gitea.com
MIT License
44.02k stars 5.4k forks source link

kanban board notes #12513

Open luwol03 opened 4 years ago

luwol03 commented 4 years ago

Allow notes in an project board which are not related to an issue, like github have it. IMG_20200817_235150

IMG_20200817_234916

Extarys commented 4 years ago

Yes, like custom tasks. Not sure if the new Kanban implementation have end date, but custom tasks should have the same level of options as issues in the kanban. (Ability to assign a person, a priority, tags, maybe a "private" options only team member would see)

kcbimonte commented 3 years ago

I say let's start small with just a comment and then add more functionality to the comment as time goes on. I'm proposing the following table definition for a comment:

Create Table Project_Comment (
  ID bigint primary key,
  Project_ID bigint not null,
  Project_Board_ID bigint not null,
  Comment Text not null,
  creator_id bigint not null,
  created_unix bigint not null,
  updated_unix bigint not null,
  Foreign Key (Project_ID) references Project(ID),
  Foreign Key (Project_Board_ID) references Project_Board(ID)
)

That is mostly SQL, which might contain a syntax error somewhere. Also would like to propose the following flow:

  1. Create a Project Board
  2. On any card, click a plus icon to create a comment
  3. Fill out comment and click save
    • Alternatively, click Cancel to delete the comment.
  4. Move comment (if needed) to any card
  5. Promote comment to issue
    • Remove from comment table and add to issue table.
    • Everything for an issue can be obtained from the foreign key relationships

Definitely open to comments on this, but I think this is a very fair start.

Wufus commented 1 year ago

Still missing, but hope to be added

zokkis commented 7 months ago

any updates?