You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Awesome tool! Guys, thanks for creating this! I just have one question regarding foreign keys.
Let's assume we have two tables: State and City. There is One to Many relationship between State and City: State -> City (State can have zero or more cities; City can belong to exactly one State).
If we look at State table there will be columns: stateId, stateName, cities, however cities field will be empty, even though state has 3 cities. But that is not a problem.
Problem is this: In City table there are columns: cityId, cityName, state. Even though city is connected to a state, state field is empty. Is there a way to see stateId or something similar in that field?
The text was updated successfully, but these errors were encountered:
Awesome tool! Guys, thanks for creating this! I just have one question regarding foreign keys.
Let's assume we have two tables: State and City. There is One to Many relationship between State and City: State -> City (State can have zero or more cities; City can belong to exactly one State).
If we look at State table there will be columns: stateId, stateName, cities, however cities field will be empty, even though state has 3 cities. But that is not a problem.
Problem is this: In City table there are columns: cityId, cityName, state. Even though city is connected to a state, state field is empty. Is there a way to see stateId or something similar in that field?
The text was updated successfully, but these errors were encountered: