I'm trying to create project siteWeb and mobile app with clean Architecture and Microservices.
create identity service with separate database A and make another api service with other database B.
for example i have table
Competence from DB(B) has relationship many to many with Table
AspNetUser from DB(A).
how to link between him?
Would the save two competence for user be required to store data from the User database (user_id, competence_Id) without relationship?
its a good idea to create table
profile in DB(B) has column Id
Profile -Id -FullName -Email
and each inscription user be required to save
user_id to Profile ("user_id","john doe","firstname.lastname@example.org") after that i link
profile with others table in DB(B)?
or i can to Make profile as
Profile -Id -FullName -Email CONSTRAINT [FK_Profile_ToAspNetUsers] FOREIGN KEY ([Id]) REFERENCES [dbo].[AspNetUsers]([Id])
Do we need that?