[Good first issue | Feature] Ensure Data Type of foreign keys

[Z712023]

Problem

The data types of foreign keys need to be consistent.

Proposed Solution

Add validation to the metadata to ensure that the data types of the two columns related to foreign keys are the same.

Additional context

[analytical-aakriti]

I can take this up

[MooooCat]

I can take this up

Hi aakriti,

Sure, feel free to open a PR any time.

@Z712023 Please add more detailed information to this Issue, which will help our developers code in more detail

[Z712023]

I can take this up

Hello aakriti, you can complete the implementation of the code at

synthetic-data-generator/sdgx/data_models/relationship.py

Line 38 in c55e340

def build(

.

For function def build(), we need to check the validity of foreign keys before the end of the function. If there are exceptional situations, please raise RelationshipInitError(error_info). Additionally, you can get the data types of foreign keys through parent_table and child_table.

[aigerimmmm]

I can take this up

[Z712023]

I can take this up

Welcome. You can implement it based on my ideas and then conduct testing to make sure the functionality works as intended. Feel free to open a PR any time.

[MooooCat]

I can take this up

Hi aigerimmmm, @aigerimmmm

Feel free to open a PR any time!

I also suggest to add test cases in PR, including different cases about the foreign keys.