# MySQL Table Structure

**URL:** <https://community.dreamfactory.com/t/mysql-table-structure/2473>\
**Category:** Schema & Data\
**Created:** [April 4, 2016, 4:11am UTC](https://community.dreamfactory.com/t/mysql-table-structure/2473 "2016-04-04T04:11:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![raviypujar](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@raviypujar](https://community.dreamfactory.com/u/raviypujar)\
**Post date:** [April 4, 2016, 4:11am UTC](https://community.dreamfactory.com/t/mysql-table-structure/2473/1 "2016-04-04T04:11:55Z")

</div>

Hi,

I am trying to create two tables route\_details, passenger\_details to contain data as below. I am not able to understand how the both data base schema should be. Passenger details is one more table which comes attached depending on when date in travel\_date field of route\_details matches date in boarding\_date\_time field.

Also i am wondering if i write the below data as is and make a POST in MySQL API DOCS to route\_details table, will the DF create 1 row in route\_details table and 2 rows in passenger\_details table?

[

{“route\_num”:“33A”,  
“travel\_date”:“02-04-2016”,  
“coach\_num”:“KA-07-TT-747”,  
“available\_seats”:3,  
“captain1\_details”:“raju”,  
“origin”:“Bangalore”,  
“destination”:“Mumbai”,  
“passenger\_details”:[{  
“pnr\_number”:“254444”,  
“title”:“Mr”,“name”:“Ravi P”,  
“age”:17,“mobile”:“9988775858”,  
“bording\_date\_time”:“2016-04-02 09:05 PM”  
},  
{  
“pnr\_number”:“254445”,  
“title”:“Mr”,“name”:“Raju G”,  
“age”:19,“mobile”:“9988778898”,  
“bording\_date\_time”:“2016-04-02 09:05 PM”  
},  
]}

I am a hardware engineer, And don’t have much idea about mySQL or tables  
Any help would be appreciated.  
Thanks in Advance.  
Ravi