search

twentyhq / twenty

Building a modern alternative to Salesforce, powered by the community.
https://twenty.com
Other
17.69k stars 2.08k forks source link

Correct Data Model to map new standard objects Task and Note #6498

Open prateekj117 opened 2 months ago

prateekj117 commented 2 months ago

Bug Description

Notes and Tasks now being top-level objects (#6219 ), should be corrected related to each other in Data Model Diagram.

Screenshot 2024-08-01 at 8 14 51 PM

Expected behavior

Task has an assigneeId which means it is related to the Users table. Notes has a related NotesTarget Table which relates it to Company, Opportunity and User.

The data model should reflect the relation too.

brendanlaschke commented 2 months ago

Both noteTargets and taskTargets are system tables and therefore not visible at the moment. Im also not sure how great it is to show them. It would result in this visualization for the default data model(I just removed them from the object filter and activated all hidden fields):

Bildschirmfoto 2024-08-09 um 14 28 40

Maybe we can find such transitive relations and display them better? (special style of the edge with a label?) But im not sure how we could find them for generic relations & design it in the visualization ...

FelixMalfait commented 1 month ago

cc @Bonapara for input

Bonapara commented 1 month ago

I don't think we're mature enough yet to make a decision on this. We should refine the properties applied to an object first. Is it available as APIs? Can I create records? Can I create a relation with this object? Is it displayed in the app and settings?