[WIP] feat: memos relation backend implment

• [ ] create memos relation table
• [ ] create a find relation memos id in store
• [ ] old memos API contain relation memos id OR an additional api to get relation memos id
• [ ] add unit test

Design draft(need to discuss):

1. Link in single direct.
2. Two Api to get memos: to link and linked

@palmenhq FYI

hey @CorrectRoadH, awesome stuff! I was curious if you have any ideas how to create the relationships from a user and/or consumer perspective?

Perhaps we should join forces as i recently made #1562? An idea could be to try parsing out any mention of m/NNN (representing a memo link, similar to how #tags are used) and attach any found ids to the POST /api/memo request payload? (similar to how resourceIdList works)

@CorrectRoadH @boojack any thoughts on that approach?

@palmenhq If we put the relation in memo content, it will be hard to process in the future. So I suggest we should use the same way as resource&memo. 👇

Uffizzi Ephemeral Environment deployment-23062

:cloud: https://app.uffizzi.com/github.com/usememos/memos/pull/1575

:page_facing_up: View Application Logs etc.

What is Uffizzi? Learn more!

Implement in https://github.com/usememos/memos/pull/1618.🥳