mysql - What is the relationship between the vortex and the edge tables? -


i work mysql database , have 2 tables namely vortex , edge. provided below,

enter image description here

is one-to-many relationship exists between tables ? explanation helpful.

there 2 one-to-many relationships because each vertex can source or destination of many edges, each edge can have 1 source , 1 destination.

speaking in terms of rows in tables, have each vertex id appearing once in vertex table, potentially more once in vertex_src_id , in vertex_dst_id columns of edges table.


Comments

Popular posts from this blog

4x4 Matrix in Python -

python - PyInstaller UAC not working in onefile mode -

wso2is - WSO2 IS 5.0.0 SP1 After restart there is authentication error -