I just need to store origin and destination in a single table as this
id
name
orgin
destination
My question is should I maintain a separate table for origin and destination ?
I just need to store origin and destination in a single table as this
id
name
orgin
destination
My question is should I maintain a separate table for origin and destination ?
Depends.
What are ‘origin’ and ‘destination’?
What is the relation between them?
well,they are simply place.No relation ship
Then why do you want to put them in 1 row? Why that specific ‘origin’ with that specific ‘destination’ if there is no relation between them?
If they are simply places, why not create a table with
id
name
place
I need to store orgin and destination and display in page
Ok, then do it like you said in your first post:
id
name
orgin
destination
No need for 2 tables.
Thanks